participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,805 rows where station_code = "USL015" 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 |
---|---|---|---|---|---|
5543614 | 5543614 | 20241115023404_p4nS2 | USL015 | 2024-11-16T14:06:56.070Z | 2024-11-22T14:24:00.410Z |
5543491 | 5543491 | 20241115014506_1W2R8 | USL015 | 2024-11-16T14:06:31.256Z | 2024-11-22T14:23:59.661Z |
5542823 | 5542823 | 20241115124931_9ob20 | USL015 | 2024-11-16T14:02:41.322Z | 2024-11-22T14:23:31.508Z |
5542717 | 5542717 | 20241115120333_Y9Hm3 | USL015 | 2024-11-16T14:02:15.466Z | 2024-11-22T14:23:30.622Z |
5542548 | 5542548 | 20241115105233_bAmqa | USL015 | 2024-11-16T14:01:44.361Z | 2024-11-22T14:23:27.475Z |
5542544 | 5542544 | 20241115105029_3wL2M | USL015 | 2024-11-16T14:01:43.700Z | 2024-11-22T14:23:27.417Z |
5541560 | 5541560 | 20241114023836_7uUFE | USL015 | 2024-11-15T14:07:51.208Z | 2024-11-22T14:24:19.462Z |
5541516 | 5541516 | 20241114022054_rrPoX | USL015 | 2024-11-15T14:07:46.404Z | 2024-11-22T14:24:19.277Z |
5540934 | 5540934 | 20241114123154_4yrww | USL015 | 2024-11-15T14:04:46.715Z | 2024-11-22T14:23:53.231Z |
5540917 | 5540917 | 20241114122659_s8Is3 | USL015 | 2024-11-15T14:04:42.744Z | 2024-11-22T14:23:53.153Z |
5540759 | 5540759 | 20241114120324_JWJWl | USL015 | 2024-11-15T14:04:25.192Z | 2024-11-22T14:23:52.566Z |
5540510 | 5540510 | 20241114111732_Tku84 | USL015 | 2024-11-15T14:03:56.984Z | 2024-11-22T14:23:51.269Z |
5540444 | 5540444 | 20241114110740_s5A3a | USL015 | 2024-11-15T14:03:49.680Z | 2024-11-22T14:23:51.013Z |
5540303 | 5540303 | 20241114103510_ba1Zq | USL015 | 2024-11-15T14:03:19.900Z | 2024-11-22T14:23:50.349Z |
5540257 | 5540257 | 20241114102939_4pvU9 | USL015 | 2024-11-15T14:03:11.819Z | 2024-11-22T14:23:50.120Z |
5540158 | 5540158 | 20241114101548_517dy | USL015 | 2024-11-15T14:03:02.759Z | 2024-11-22T14:23:49.307Z |
5540043 | 5540043 | 20241114095327_kRj1t | USL015 | 2024-11-15T14:02:42.109Z | 2024-11-22T14:23:48.619Z |
5539613 | 5539613 | 20241114081038_ppzHw | USL015 | 2024-11-15T14:01:32.148Z | 2024-11-22T14:23:45.235Z |
5535394 | 5535394 | 20241112122331_7lz8R | USL015 | 2024-11-14T14:07:53.291Z | 2024-11-21T14:25:46.918Z |
5535179 | 5535179 | 20241112115215_k2031 | USL015 | 2024-11-14T14:07:25.879Z | 2024-11-21T14:25:44.522Z |
5535088 | 5535088 | 20241112113440_PlGLI | USL015 | 2024-11-14T14:07:12.601Z | 2024-11-21T14:25:43.835Z |
5535009 | 5535009 | 20241112112456_XDl5W | USL015 | 2024-11-14T14:07:05.730Z | 2024-11-21T14:25:42.989Z |
5534447 | 5534447 | 20241113121008_1r2yg | USL015 | 2024-11-14T14:04:25.082Z | 2024-11-22T14:24:13.935Z |
5534221 | 5534221 | 20241113112129_U5z3O | USL015 | 2024-11-14T14:03:50.352Z | 2024-11-22T14:24:13.023Z |
5534014 | 5534014 | 20241113103813_Loae7 | USL015 | 2024-11-14T14:03:26.125Z | 2024-11-22T14:24:11.989Z |
5533977 | 5533977 | 20241113103332_l04vc | USL015 | 2024-11-14T14:03:22.928Z | 2024-11-22T14:24:11.881Z |
5533975 | 5533975 | 20241113103310_y25BO | USL015 | 2024-11-14T14:03:22.583Z | 2024-11-22T14:24:11.856Z |
5533941 | 5533941 | 20241113102937_7e27R | USL015 | 2024-11-14T14:03:18.880Z | 2024-11-22T14:24:11.770Z |
5533480 | 5533480 | 20241113090612_utAhH | USL015 | 2024-11-14T14:02:05.936Z | 2024-11-22T14:24:09.567Z |
5533395 | 5533395 | 20241113084736_G742A | USL015 | 2024-11-14T14:01:52.938Z | 2024-11-22T14:24:08.956Z |
5533074 | 5533074 | 20241113070532_fEfUd | USL015 | 2024-11-14T14:01:03.979Z | 2024-11-22T14:24:06.929Z |
5532163 | 5532163 | 20241112044553_YPvLm | USL015 | 2024-11-13T14:16:23.756Z | 2024-11-20T14:26:20.511Z |
5527137 | 5527137 | 20241111085624_Fp5Sv | USL015 | 2024-11-13T14:05:45.529Z | 2024-11-20T14:24:40.372Z |
5526921 | 5526921 | 20241112103117_gpbWY | USL015 | 2024-11-13T14:04:34.282Z | 2024-11-21T14:25:39.726Z |
5526896 | 5526896 | 20241112102723_FLSgg | USL015 | 2024-11-13T14:04:28.469Z | 2024-11-21T14:25:39.551Z |
5526523 | 5526523 | 20241112093928_2ato3 | USL015 | 2024-11-13T14:03:23.527Z | 2024-11-21T14:25:36.099Z |
5526378 | 5526378 | 20241112090845_zz6f7 | USL015 | 2024-11-13T14:02:49.227Z | 2024-11-21T14:25:34.602Z |
5526309 | 5526309 | 20241112085712_97Xmq | USL015 | 2024-11-13T14:02:41.363Z | 2024-11-21T14:25:34.038Z |
5526060 | 5526060 | 20241112075648_xlgZ5 | USL015 | 2024-11-13T14:01:44.411Z | 2024-11-21T14:25:30.275Z |
5526033 | 5526033 | 20241112075201_2T3n2 | USL015 | 2024-11-13T14:01:39.703Z | 2024-11-21T14:25:30.125Z |
5525911 | 5525911 | 20241112071524_lp93Y | USL015 | 2024-11-13T14:01:11.519Z | 2024-11-21T14:25:28.897Z |
5525844 | 5525844 | 20241112070045_BLnkB | USL015 | 2024-11-13T14:00:54.348Z | 2024-11-21T14:25:28.122Z |
5524655 | 5524655 | 20241111050014_w2pVy | USL015 | 2024-11-12T14:17:51.155Z | 2024-11-19T14:22:23.207Z |
5524388 | 5524388 | 20241111040657_FnNaM | USL015 | 2024-11-12T14:17:13.746Z | 2024-11-19T14:22:20.917Z |
5519438 | 5519438 | 20241111112336_euCgI | USL015 | 2024-11-12T14:04:00.914Z | 2024-11-20T14:24:50.354Z |
5518727 | 5518727 | 20241111090137_xVFzw | USL015 | 2024-11-12T14:01:47.665Z | 2024-11-20T14:24:40.620Z |
5518396 | 5518396 | 20241111072648_0zKKj | USL015 | 2024-11-12T14:00:50.308Z | 2024-11-20T14:24:33.497Z |
5518260 | 5518260 | 20241111064322_yn950 | USL015 | 2024-11-12T14:00:24.060Z | 2024-11-20T14:24:30.925Z |
5518072 | 5518072 | 20241110055315_KmhJl | USL015 | 2024-11-11T14:15:11.583Z | 2024-11-18T14:26:39.479Z |
5517889 | 5517889 | 20241110050837_YMipx | USL015 | 2024-11-11T14:14:59.661Z | 2024-11-18T14:26:38.778Z |
5517708 | 5517708 | 20241110043303_Y4OhD | USL015 | 2024-11-11T14:14:46.004Z | 2024-11-18T14:26:37.918Z |
5517333 | 5517333 | 20241110032720_FgXkq | USL015 | 2024-11-11T14:14:16.224Z | 2024-11-18T14:26:35.989Z |
5513794 | 5513794 | 20241110122120_CHy9d | USL015 | 2024-11-11T14:05:28.895Z | 2024-11-19T14:21:37.761Z |
5513769 | 5513769 | 20241110121928_acUPt | USL015 | 2024-11-11T14:05:26.817Z | 2024-11-19T14:21:37.611Z |
5513602 | 5513602 | 20241110115619_poqO5 | USL015 | 2024-11-11T14:04:56.990Z | 2024-11-19T14:21:36.236Z |
5513532 | 5513532 | 20241110114613_uS3zX | USL015 | 2024-11-11T14:04:47.053Z | 2024-11-19T14:21:35.496Z |
5513478 | 5513478 | 20241110113545_z2yuw | USL015 | 2024-11-11T14:04:42.358Z | 2024-11-19T14:21:34.673Z |
5513402 | 5513402 | 20241110112549_9cOiH | USL015 | 2024-11-11T14:04:35.101Z | 2024-11-19T14:21:33.837Z |
5513393 | 5513393 | 20241110112522_dJ3po | USL015 | 2024-11-11T14:04:34.560Z | 2024-11-19T14:21:33.817Z |
5513236 | 5513236 | 20241110110137_3QLW3 | USL015 | 2024-11-11T14:04:12.576Z | 2024-11-19T14:21:32.134Z |
5513020 | 5513020 | 20241110102312_nJfZ7 | USL015 | 2024-11-11T14:03:45.347Z | 2024-11-19T14:21:30.358Z |
5513002 | 5513002 | 20241110101958_Oqkrz | USL015 | 2024-11-11T14:03:43.619Z | 2024-11-19T14:21:30.253Z |
5512879 | 5512879 | 20241110100353_muchW | USL015 | 2024-11-11T14:03:23.789Z | 2024-11-19T14:21:29.125Z |
5512463 | 5512463 | 20241110085409_KZ6Ld | USL015 | 2024-11-11T14:02:22.338Z | 2024-11-19T14:21:24.909Z |
5512413 | 5512413 | 20241110084510_M2bqy | USL015 | 2024-11-11T14:02:16.329Z | 2024-11-19T14:21:24.125Z |
5511962 | 5511962 | 20241110073251_1i24O | USL015 | 2024-11-11T14:01:12.520Z | 2024-11-19T14:21:17.961Z |
5511822 | 5511822 | 20241110070449_kqrcO | USL015 | 2024-11-11T14:00:53.131Z | 2024-11-19T14:21:16.438Z |
5511265 | 5511265 | 20241109052746_6jye7 | USL015 | 2024-11-10T14:16:36.859Z | 2024-11-17T14:24:07.472Z |
5511127 | 5511127 | 20241109043459_otZty | USL015 | 2024-11-10T14:16:18.616Z | 2024-11-17T14:24:05.420Z |
5510867 | 5510867 | 20241109034554_zxoh5 | USL015 | 2024-11-10T14:15:47.567Z | 2024-11-17T14:24:01.984Z |
5507789 | 5507789 | 20241109122615_h9pBx | USL015 | 2024-11-10T14:06:11.638Z | 2024-11-18T14:26:14.729Z |
5507652 | 5507652 | 20241109120358_GQ7S9 | USL015 | 2024-11-10T14:05:42.391Z | 2024-11-18T14:26:12.843Z |
5507549 | 5507549 | 20241109114913_4MwQ2 | USL015 | 2024-11-10T14:05:31.503Z | 2024-11-18T14:26:11.936Z |
5507461 | 5507461 | 20241109113235_zpkuK | USL015 | 2024-11-10T14:05:16.762Z | 2024-11-18T14:26:11.039Z |
5507398 | 5507398 | 20241109112346_42tWG | USL015 | 2024-11-10T14:05:00.521Z | 2024-11-18T14:26:10.576Z |
5507308 | 5507308 | 20241109111005_AA84f | USL015 | 2024-11-10T14:04:48.419Z | 2024-11-18T14:26:09.475Z |
5507177 | 5507177 | 20241109104843_cDtYu | USL015 | 2024-11-10T14:04:35.608Z | 2024-11-18T14:26:08.113Z |
5506944 | 5506944 | 20241109100252_kS7R8 | USL015 | 2024-11-10T14:03:54.593Z | 2024-11-18T14:26:04.175Z |
5506884 | 5506884 | 20241109095319_z5uUA | USL015 | 2024-11-10T14:03:39.212Z | 2024-11-18T14:26:03.296Z |
5506860 | 5506860 | 20241109094931_EpRuI | USL015 | 2024-11-10T14:03:31.514Z | 2024-11-18T14:26:03.046Z |
5506808 | 5506808 | 20241109093912_DKCvS | USL015 | 2024-11-10T14:03:22.274Z | 2024-11-18T14:26:02.538Z |
5506570 | 5506570 | 20241109090128_rF3Bj | USL015 | 2024-11-10T14:02:34.945Z | 2024-11-18T14:26:00.607Z |
5506521 | 5506521 | 20241109085230_CbfOz | USL015 | 2024-11-10T14:02:28.158Z | 2024-11-18T14:26:00.244Z |
5506399 | 5506399 | 20241109083425_dtASx | USL015 | 2024-11-10T14:02:06.319Z | 2024-11-18T14:25:59.110Z |
5506394 | 5506394 | 20241109083356_c33rQ | USL015 | 2024-11-10T14:02:02.983Z | 2024-11-18T14:25:59.068Z |
5506347 | 5506347 | 20241109082338_Bhqni | USL015 | 2024-11-10T14:01:52.679Z | 2024-11-18T14:25:58.802Z |
5506314 | 5506314 | 20241109081927_jEadu | USL015 | 2024-11-10T14:01:48.109Z | 2024-11-18T14:25:58.434Z |
5506194 | 5506194 | 20241109075245_CtS16 | USL015 | 2024-11-10T14:01:32.506Z | 2024-11-18T14:25:57.416Z |
5506139 | 5506139 | 20241109074414_ILXo1 | USL015 | 2024-11-10T14:01:19.162Z | 2024-11-18T14:25:56.779Z |
5506062 | 5506062 | 20241109073236_kmjfB | USL015 | 2024-11-10T14:01:08.616Z | 2024-11-18T14:25:56.163Z |
5506024 | 5506024 | 20241109072648_gAcVH | USL015 | 2024-11-10T14:01:03.639Z | 2024-11-18T14:25:55.661Z |
5505953 | 5505953 | 20241109071154_7ZUcm | USL015 | 2024-11-10T14:00:53.221Z | 2024-11-18T14:25:55.049Z |
5505712 | 5505712 | 20241109062346_auvJ4 | USL015 | 2024-11-10T14:00:13.794Z | 2024-11-18T14:25:51.616Z |
5504537 | 5504537 | 20241108021256_QlmD5 | USL015 | 2024-11-09T14:14:49.311Z | 2024-11-16T14:28:21.276Z |
5499652 | 5499652 | 20241108125137_NQboU | USL015 | 2024-11-09T14:04:34.055Z | 2024-11-17T14:23:14.149Z |
5499556 | 5499556 | 20241108123622_czN4P | USL015 | 2024-11-09T14:04:18.582Z | 2024-11-17T14:23:13.000Z |
5499518 | 5499518 | 20241108123117_RgqPj | USL015 | 2024-11-09T14:04:15.072Z | 2024-11-17T14:23:12.643Z |
5499461 | 5499461 | 20241108122216_pWh8Q | USL015 | 2024-11-09T14:04:08.542Z | 2024-11-17T14:23:11.739Z |
5499335 | 5499335 | 20241108120006_rohN6 | USL015 | 2024-11-09T14:03:47.588Z | 2024-11-17T14:23:09.884Z |
5498459 | 5498459 | 20241108083712_C96JQ | USL015 | 2024-11-09T14:01:32.400Z | 2024-11-17T14:22:55.552Z |
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);