participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
439 rows where station_code = "US0050" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5134436 | 5134436 | 20240916091342_M253F | US0050 | 2024-09-19T12:17:43.672Z | 2024-09-19T12:17:43.672Z |
5134290 | 5134290 | 20240916074941_lMpM1 | US0050 | 2024-09-19T12:17:35.395Z | 2024-09-19T12:17:35.395Z |
5134277 | 5134277 | 20240916074555_C1oay | US0050 | 2024-09-19T12:17:34.960Z | 2024-09-19T12:17:34.960Z |
5134251 | 5134251 | 20240916072720_VCPjq | US0050 | 2024-09-19T12:17:33.586Z | 2024-09-19T12:17:33.586Z |
5134235 | 5134235 | 20240916072100_ziBE1 | US0050 | 2024-09-19T12:17:32.755Z | 2024-09-19T12:17:32.755Z |
5122787 | 5122787 | 20240914075755_3Yhqr | US0050 | 2024-09-18T12:11:31.159Z | 2024-09-19T12:20:06.187Z |
5122713 | 5122713 | 20240914073555_9uFt2 | US0050 | 2024-09-18T12:11:29.106Z | 2024-09-19T12:20:05.827Z |
5122658 | 5122658 | 20240914072754_KyVB5 | US0050 | 2024-09-18T12:11:27.191Z | 2024-09-19T12:20:05.542Z |
5122477 | 5122477 | 20240914063547_xL10y | US0050 | 2024-09-18T12:11:20.251Z | 2024-09-19T12:20:04.497Z |
5122438 | 5122438 | 20240914062222_4rbFF | US0050 | 2024-09-18T12:11:18.385Z | 2024-09-19T12:20:04.337Z |
5122227 | 5122227 | 20240914050231_cJeu3 | US0050 | 2024-09-18T12:11:10.821Z | 2024-09-19T12:20:03.305Z |
5122191 | 5122191 | 20240914044942_DXoBB | US0050 | 2024-09-18T12:11:08.919Z | 2024-09-19T12:20:02.951Z |
5121887 | 5121887 | 20240914041933_VZoL3 | US0050 | 2024-09-18T12:11:02.782Z | 2024-09-19T12:20:02.480Z |
5120747 | 5120747 | 20240914033435_ejHdR | US0050 | 2024-09-18T12:10:46.528Z | 2024-09-19T12:20:00.847Z |
5120464 | 5120464 | 20240914032131_u2X1c | US0050 | 2024-09-18T12:10:40.963Z | 2024-09-19T12:20:00.350Z |
5118417 | 5118417 | 20240915094047_aS1ra | US0050 | 2024-09-18T12:08:43.161Z | 2024-09-19T12:19:22.629Z |
5118412 | 5118412 | 20240915093912_FbI5K | US0050 | 2024-09-18T12:08:42.980Z | 2024-09-19T12:19:22.588Z |
5118371 | 5118371 | 20240915092922_pvRyg | US0050 | 2024-09-18T12:08:40.559Z | 2024-09-19T12:19:22.378Z |
5118206 | 5118206 | 20240915085122_iFDCv | US0050 | 2024-09-18T12:08:29.821Z | 2024-09-19T12:19:21.257Z |
5118136 | 5118136 | 20240915084029_zZlZQ | US0050 | 2024-09-18T12:08:26.267Z | 2024-09-19T12:19:20.712Z |
5118083 | 5118083 | 20240915082749_FqosZ | US0050 | 2024-09-18T12:08:22.527Z | 2024-09-19T12:19:20.221Z |
5118046 | 5118046 | 20240915081507_TEh3m | US0050 | 2024-09-18T12:08:20.474Z | 2024-09-19T12:19:19.936Z |
5118030 | 5118030 | 20240915080929_6HXrz | US0050 | 2024-09-18T12:08:19.147Z | 2024-09-19T12:19:19.846Z |
5117985 | 5117985 | 20240915080508_hFnDo | US0050 | 2024-09-18T12:08:15.426Z | 2024-09-19T12:19:19.493Z |
5117959 | 5117959 | 20240915075739_zyDbG | US0050 | 2024-09-18T12:08:11.636Z | 2024-09-19T12:19:19.325Z |
5117814 | 5117814 | 20240915070811_Ia0He | US0050 | 2024-09-18T12:08:01.086Z | 2024-09-19T12:19:18.165Z |
5117721 | 5117721 | 20240915063604_pwjxj | US0050 | 2024-09-18T12:07:53.468Z | 2024-09-19T12:19:17.212Z |
5117701 | 5117701 | 20240915062830_EI1II | US0050 | 2024-09-18T12:07:52.542Z | 2024-09-19T12:19:17.013Z |
5117697 | 5117697 | 20240915062739_cvpOX | US0050 | 2024-09-18T12:07:52.483Z | 2024-09-19T12:19:17.007Z |
5117654 | 5117654 | 20240915060429_9V5Fb | US0050 | 2024-09-18T12:07:51.070Z | 2024-09-19T12:19:16.774Z |
5109193 | 5109193 | 20240913091043_2GaNV | US0050 | 2024-09-17T12:14:32.940Z | 2024-09-19T12:20:52.432Z |
5109167 | 5109167 | 20240913090128_d7JiM | US0050 | 2024-09-17T12:14:32.168Z | 2024-09-19T12:20:52.349Z |
5109102 | 5109102 | 20240913084627_bU4O8 | US0050 | 2024-09-17T12:14:30.305Z | 2024-09-19T12:20:51.711Z |
5108969 | 5108969 | 20240913081541_Y1eux | US0050 | 2024-09-17T12:14:22.901Z | 2024-09-19T12:20:51.327Z |
5108937 | 5108937 | 20240913080758_EaMmY | US0050 | 2024-09-17T12:14:19.564Z | 2024-09-19T12:20:51.207Z |
5108935 | 5108935 | 20240913080708_IoUu1 | US0050 | 2024-09-17T12:14:19.338Z | 2024-09-19T12:20:51.205Z |
5108864 | 5108864 | 20240913074857_EufOv | US0050 | 2024-09-17T12:14:11.246Z | 2024-09-19T12:20:50.959Z |
5108714 | 5108714 | 20240913070728_cMcNl | US0050 | 2024-09-17T12:13:58.598Z | 2024-09-19T12:20:50.465Z |
5108666 | 5108666 | 20240913065653_ttu2W | US0050 | 2024-09-17T12:13:56.448Z | 2024-09-19T12:20:50.215Z |
5108549 | 5108549 | 20240913062204_92AyQ | US0050 | 2024-09-17T12:13:50.735Z | 2024-09-19T12:20:49.454Z |
5108492 | 5108492 | 20240913055809_f2X2u | US0050 | 2024-09-17T12:13:47.458Z | 2024-09-19T12:20:49.030Z |
5108438 | 5108438 | 20240913053210_R4fwh | US0050 | 2024-09-17T12:13:44.628Z | 2024-09-19T12:20:48.825Z |
5108337 | 5108337 | 20240913045533_J9hiQ | US0050 | 2024-09-17T12:13:37.515Z | 2024-09-19T12:20:48.253Z |
5108286 | 5108286 | 20240913044140_VurAC | US0050 | 2024-09-17T12:13:34.860Z | 2024-09-19T12:20:48.002Z |
5107571 | 5107571 | 20240913040149_6oocq | US0050 | 2024-09-17T12:13:17.277Z | 2024-09-19T12:20:47.264Z |
5107418 | 5107418 | 20240913035519_miAgj | US0050 | 2024-09-17T12:13:14.819Z | 2024-09-19T12:20:47.125Z |
5106756 | 5106756 | 20240913033332_RhcyN | US0050 | 2024-09-17T12:13:00.693Z | 2024-09-19T12:20:46.381Z |
5105889 | 5105889 | 20240913030209_vJNAH | US0050 | 2024-09-17T12:12:32.069Z | 2024-09-19T12:20:45.025Z |
5105504 | 5105504 | 20240913024926_U7RrJ | US0050 | 2024-09-17T12:12:19.459Z | 2024-09-19T12:20:44.604Z |
5095660 | 5095660 | 20240912083510_R0ZI9 | US0050 | 2024-09-16T12:15:52.271Z | 2024-09-19T12:21:19.619Z |
5095587 | 5095587 | 20240912081249_aCcNj | US0050 | 2024-09-16T12:15:49.751Z | 2024-09-19T12:21:19.166Z |
5095488 | 5095488 | 20240912074646_yDkcA | US0050 | 2024-09-16T12:15:43.166Z | 2024-09-19T12:21:18.668Z |
5095449 | 5095449 | 20240912073603_h2KcN | US0050 | 2024-09-16T12:15:40.552Z | 2024-09-19T12:21:18.556Z |
5095402 | 5095402 | 20240912072819_xRmvs | US0050 | 2024-09-16T12:15:38.815Z | 2024-09-19T12:21:18.412Z |
5095327 | 5095327 | 20240912071520_odGFz | US0050 | 2024-09-16T12:15:32.618Z | 2024-09-19T12:21:18.137Z |
5095314 | 5095314 | 20240912071139_NA1cw | US0050 | 2024-09-16T12:15:31.955Z | 2024-09-19T12:21:18.091Z |
5095212 | 5095212 | 20240912063957_nqlVw | US0050 | 2024-09-16T12:15:23.050Z | 2024-09-19T12:21:17.528Z |
5095208 | 5095208 | 20240912063622_Urayt | US0050 | 2024-09-16T12:15:22.486Z | 2024-09-19T12:21:17.514Z |
5095192 | 5095192 | 20240912063137_Ml7YB | US0050 | 2024-09-16T12:15:21.411Z | 2024-09-19T12:21:17.461Z |
5095128 | 5095128 | 20240912060507_aFVPV | US0050 | 2024-09-16T12:15:17.159Z | 2024-09-19T12:21:17.308Z |
5095126 | 5095126 | 20240912060505_IvNNF | US0050 | 2024-09-16T12:15:17.063Z | 2024-09-19T12:21:17.307Z |
5094947 | 5094947 | 20240912044755_KGxrQ | US0050 | 2024-09-16T12:15:02.685Z | 2024-09-19T12:21:16.618Z |
5094631 | 5094631 | 20240912041232_T292j | US0050 | 2024-09-16T12:14:52.615Z | 2024-09-19T12:21:16.332Z |
5093049 | 5093049 | 20240912030940_krZfu | US0050 | 2024-09-16T12:14:10.870Z | 2024-09-19T12:21:14.918Z |
5089334 | 5089334 | 20240912003553_ymhH5 | US0050 | 2024-09-16T12:11:20.508Z | 2024-09-19T12:21:09.888Z |
5082178 | 5082178 | 20240911093228_0Kjoq | US0050 | 2024-09-15T12:18:05.879Z | 2024-09-19T12:21:47.407Z |
5082071 | 5082071 | 20240911091720_69kmV | US0050 | 2024-09-15T12:18:01.159Z | 2024-09-19T12:21:47.151Z |
5082069 | 5082069 | 20240911091707_2A6i0 | US0050 | 2024-09-15T12:18:01.068Z | 2024-09-19T12:21:47.141Z |
5081883 | 5081883 | 20240911085755_Xd2O2 | US0050 | 2024-09-15T12:17:53.162Z | 2024-09-19T12:21:46.625Z |
5081845 | 5081845 | 20240911085055_ViVWn | US0050 | 2024-09-15T12:17:50.935Z | 2024-09-19T12:21:46.564Z |
5081810 | 5081810 | 20240911084526_Zk6QC | US0050 | 2024-09-15T12:17:49.174Z | 2024-09-19T12:21:46.490Z |
5081384 | 5081384 | 20240911073323_NPh4I | US0050 | 2024-09-15T12:17:31.839Z | 2024-09-19T12:21:45.218Z |
5081266 | 5081266 | 20240911070928_gWcSX | US0050 | 2024-09-15T12:17:28.371Z | 2024-09-19T12:21:44.938Z |
5081256 | 5081256 | 20240911070607_GnqUi | US0050 | 2024-09-15T12:17:28.124Z | 2024-09-19T12:21:44.909Z |
5081161 | 5081161 | 20240911064323_ZcE5W | US0050 | 2024-09-15T12:17:25.213Z | 2024-09-19T12:21:44.685Z |
5081132 | 5081132 | 20240911064035_eNFVO | US0050 | 2024-09-15T12:17:24.671Z | 2024-09-19T12:21:44.664Z |
5080830 | 5080830 | 20240911045832_OwYmE | US0050 | 2024-09-15T12:17:14.846Z | 2024-09-19T12:21:43.842Z |
5079579 | 5079579 | 20240911030427_oV4AX | US0050 | 2024-09-15T12:16:26.669Z | 2024-09-19T12:21:42.390Z |
5078981 | 5078981 | 20240911022743_ATNpd | US0050 | 2024-09-15T12:16:01.350Z | 2024-09-19T12:21:40.951Z |
5078648 | 5078648 | 20240911020759_ogauH | US0050 | 2024-09-15T12:15:47.664Z | 2024-09-19T12:21:40.645Z |
5077990 | 5077990 | 20240911013404_wqET1 | US0050 | 2024-09-15T12:15:15.750Z | 2024-09-19T12:21:39.880Z |
5077757 | 5077757 | 20240911011606_Uj3AS | US0050 | 2024-09-15T12:15:03.371Z | 2024-09-19T12:21:39.608Z |
5067265 | 5067265 | 20240910091336_uvo12 | US0050 | 2024-09-14T12:18:37.756Z | 2024-09-18T12:15:23.698Z |
5067170 | 5067170 | 20240910090235_XGsvb | US0050 | 2024-09-14T12:18:34.556Z | 2024-09-18T12:15:23.522Z |
5066794 | 5066794 | 20240910081714_wVETp | US0050 | 2024-09-14T12:18:12.594Z | 2024-09-18T12:15:22.757Z |
5066675 | 5066675 | 20240910080125_Cz2Jt | US0050 | 2024-09-14T12:18:07.033Z | 2024-09-18T12:15:22.407Z |
5066580 | 5066580 | 20240910075140_afCS2 | US0050 | 2024-09-14T12:18:03.360Z | 2024-09-18T12:15:22.245Z |
5066550 | 5066550 | 20240910074838_yKgam | US0050 | 2024-09-14T12:18:02.286Z | 2024-09-18T12:15:22.161Z |
5066470 | 5066470 | 20240910073550_3F7NU | US0050 | 2024-09-14T12:17:58.250Z | 2024-09-18T12:15:22.022Z |
5066354 | 5066354 | 20240910071725_wpW2T | US0050 | 2024-09-14T12:17:52.615Z | 2024-09-18T12:15:21.660Z |
5066305 | 5066305 | 20240910070922_A2bgZ | US0050 | 2024-09-14T12:17:49.083Z | 2024-09-18T12:15:21.571Z |
5066192 | 5066192 | 20240910064943_tGrqz | US0050 | 2024-09-14T12:17:44.070Z | 2024-09-18T12:15:21.348Z |
5066144 | 5066144 | 20240910064339_HSLuD | US0050 | 2024-09-14T12:17:41.720Z | 2024-09-18T12:15:21.240Z |
5066130 | 5066130 | 20240910064126_cDItx | US0050 | 2024-09-14T12:17:40.175Z | 2024-09-18T12:15:21.215Z |
5065996 | 5065996 | 20240910061433_vsT3L | US0050 | 2024-09-14T12:17:34.018Z | 2024-09-18T12:15:20.957Z |
5065528 | 5065528 | 20240910043258_mvkpN | US0050 | 2024-09-14T12:17:09.218Z | 2024-09-18T12:15:19.692Z |
5065292 | 5065292 | 20240910033717_lSalS | US0050 | 2024-09-14T12:16:54.332Z | 2024-09-18T12:15:18.946Z |
5064940 | 5064940 | 20240910023738_zHWTN | US0050 | 2024-09-14T12:16:11.215Z | 2024-09-18T12:15:17.855Z |
5064569 | 5064569 | 20240910013808_v7izA | US0050 | 2024-09-14T12:15:40.226Z | 2024-09-18T12:15:16.845Z |
5064537 | 5064537 | 20240910012905_53nu6 | US0050 | 2024-09-14T12:15:36.574Z | 2024-09-18T12:15:16.814Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);