participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,452 rows where station_code = "USL01E" 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 |
---|---|---|---|---|---|
5572499 | 5572499 | 20241121022855_KeUC4 | USL01E | 2024-11-22T14:18:30.206Z | 2024-11-22T14:19:22.339Z |
5572280 | 5572280 | 20241121020252_64QfT | USL01E | 2024-11-22T14:18:10.832Z | 2024-11-22T14:19:22.296Z |
5572193 | 5572193 | 20241121014517_m3Iko | USL01E | 2024-11-22T14:18:04.041Z | 2024-11-22T14:19:22.276Z |
5565414 | 5565414 | 20241120042343_fp3m0 | USL01E | 2024-11-21T14:18:48.332Z | 2024-11-22T14:21:46.540Z |
5565304 | 5565304 | 20241120041750_l4xjo | USL01E | 2024-11-21T14:18:45.807Z | 2024-11-22T14:21:45.815Z |
5565276 | 5565276 | 20241120041116_3o4qs | USL01E | 2024-11-21T14:18:44.386Z | 2024-11-22T14:21:45.038Z |
5564868 | 5564868 | 20241120033337_ERVKK | USL01E | 2024-11-21T14:18:10.522Z | 2024-11-22T14:21:37.403Z |
5564600 | 5564600 | 20241120031231_dkg38 | USL01E | 2024-11-21T14:17:52.398Z | 2024-11-22T14:21:33.960Z |
5564557 | 5564557 | 20241120030908_ROvE5 | USL01E | 2024-11-21T14:17:48.470Z | 2024-11-22T14:21:33.459Z |
5564483 | 5564483 | 20241120030022_ZrcSc | USL01E | 2024-11-21T14:17:41.429Z | 2024-11-22T14:21:32.692Z |
5564146 | 5564146 | 20241120023349_EQWK2 | USL01E | 2024-11-21T14:17:14.460Z | 2024-11-22T14:21:27.611Z |
5564029 | 5564029 | 20241120022445_KrUQ4 | USL01E | 2024-11-21T14:17:05.453Z | 2024-11-22T14:21:26.598Z |
5563746 | 5563746 | 20241120020113_UZPTC | USL01E | 2024-11-21T14:16:38.364Z | 2024-11-22T14:21:21.625Z |
5563415 | 5563415 | 20241120012854_a4okM | USL01E | 2024-11-21T14:16:04.709Z | 2024-11-22T14:21:15.338Z |
5560417 | 5560417 | 20241120124902_2TiYR | USL01E | 2024-11-21T14:08:48.919Z | 2024-11-22T14:19:21.654Z |
5560365 | 5560365 | 20241120124217_HOd3p | USL01E | 2024-11-21T14:08:44.705Z | 2024-11-22T14:19:21.645Z |
5560297 | 5560297 | 20241120123205_2IErC | USL01E | 2024-11-21T14:08:32.734Z | 2024-11-22T14:19:21.631Z |
5560194 | 5560194 | 20241120121604_3waUj | USL01E | 2024-11-21T14:08:13.826Z | 2024-11-22T14:19:21.608Z |
5560168 | 5560168 | 20241120121015_1J63m | USL01E | 2024-11-21T14:08:10.761Z | 2024-11-22T14:19:21.602Z |
5560060 | 5560060 | 20241120115300_2XpPj | USL01E | 2024-11-21T14:07:57.583Z | 2024-11-22T14:19:21.578Z |
5560030 | 5560030 | 20241120114806_I5IQh | USL01E | 2024-11-21T14:07:53.766Z | 2024-11-22T14:19:21.572Z |
5559931 | 5559931 | 20241120113547_ign65 | USL01E | 2024-11-21T14:07:35.662Z | 2024-11-22T14:19:21.552Z |
5559917 | 5559917 | 20241120113351_qHDJ2 | USL01E | 2024-11-21T14:07:33.596Z | 2024-11-22T14:19:21.549Z |
5559896 | 5559896 | 20241120113051_R7kzu | USL01E | 2024-11-21T14:07:29.699Z | 2024-11-22T14:19:21.545Z |
5559868 | 5559868 | 20241120112805_Bfdkw | USL01E | 2024-11-21T14:07:21.723Z | 2024-11-22T14:19:21.539Z |
5559139 | 5559139 | 20241120092733_pgcDC | USL01E | 2024-11-21T14:05:26.943Z | 2024-11-22T14:19:21.372Z |
5559135 | 5559135 | 20241120092719_CdsA7 | USL01E | 2024-11-21T14:05:26.586Z | 2024-11-22T14:19:21.371Z |
5559097 | 5559097 | 20241120092303_FneN9 | USL01E | 2024-11-21T14:05:20.729Z | 2024-11-22T14:19:21.363Z |
5559019 | 5559019 | 20241120090527_BNupF | USL01E | 2024-11-21T14:05:03.196Z | 2024-11-22T14:19:21.348Z |
5559003 | 5559003 | 20241120090443_sm4sh | USL01E | 2024-11-21T14:05:00.954Z | 2024-11-22T14:19:21.345Z |
5559000 | 5559000 | 20241120090420_lJTj9 | USL01E | 2024-11-21T14:05:00.463Z | 2024-11-22T14:19:21.344Z |
5558978 | 5558978 | 20241120090140_tf32I | USL01E | 2024-11-21T14:04:56.527Z | 2024-11-22T14:19:21.340Z |
5558953 | 5558953 | 20241120085622_EhJk7 | USL01E | 2024-11-21T14:04:51.891Z | 2024-11-22T14:19:21.333Z |
5558944 | 5558944 | 20241120085246_dlx2S | USL01E | 2024-11-21T14:04:51.207Z | 2024-11-22T14:19:21.332Z |
5558926 | 5558926 | 20241120085046_pxCXX | USL01E | 2024-11-21T14:04:49.270Z | 2024-11-22T14:19:21.329Z |
5558888 | 5558888 | 20241120084330_RyIyo | USL01E | 2024-11-21T14:04:43.608Z | 2024-11-22T14:19:21.321Z |
5558696 | 5558696 | 20241120073429_gcAJv | USL01E | 2024-11-21T14:04:05.050Z | 2024-11-22T14:19:21.282Z |
5558666 | 5558666 | 20241120072358_PQmFt | USL01E | 2024-11-21T14:03:59.857Z | 2024-11-22T14:19:21.276Z |
5558655 | 5558655 | 20241120071727_ehQ0f | USL01E | 2024-11-21T14:03:57.454Z | 2024-11-22T14:19:21.272Z |
5558548 | 5558548 | 20241120062729_JK12f | USL01E | 2024-11-21T14:03:35.987Z | 2024-11-22T14:19:21.249Z |
5558477 | 5558477 | 20241120061105_10xt7 | USL01E | 2024-11-21T14:03:23.207Z | 2024-11-22T14:19:21.236Z |
5558446 | 5558446 | 20241120060442_02Els | USL01E | 2024-11-21T14:03:16.733Z | 2024-11-22T14:19:21.230Z |
5558437 | 5558437 | 20241120060347_H3dwB | USL01E | 2024-11-21T14:03:15.073Z | 2024-11-22T14:19:21.228Z |
5557985 | 5557985 | 20241120052803_YBPcK | USL01E | 2024-11-21T14:02:12.391Z | 2024-11-22T14:19:21.156Z |
5557983 | 5557983 | 20241120052800_hEtOa | USL01E | 2024-11-21T14:02:11.831Z | 2024-11-22T14:19:21.156Z |
5557613 | 5557613 | 20241120050143_0EqLL | USL01E | 2024-11-21T14:01:22.352Z | 2024-11-22T14:19:21.100Z |
5557602 | 5557602 | 20241120045955_5SEqi | USL01E | 2024-11-21T14:01:20.768Z | 2024-11-22T14:19:21.098Z |
5557570 | 5557570 | 20241120045750_tMQvV | USL01E | 2024-11-21T14:01:12.054Z | 2024-11-22T14:19:21.092Z |
5557549 | 5557549 | 20241120045638_qBj34 | USL01E | 2024-11-21T14:01:09.443Z | 2024-11-22T14:19:21.089Z |
5557521 | 5557521 | 20241120045325_2Qqal | USL01E | 2024-11-21T14:01:04.703Z | 2024-11-22T14:19:21.084Z |
5557261 | 5557261 | 20241120043139_8wYUi | USL01E | 2024-11-21T14:00:17.860Z | 2024-11-22T14:19:21.039Z |
5553900 | 5553900 | 20241118044437_tYVF6 | USL01E | 2024-11-19T14:11:32.622Z | 2024-11-22T14:22:57.174Z |
5553846 | 5553846 | 20241118043143_25lnc | USL01E | 2024-11-19T14:11:29.715Z | 2024-11-22T14:22:56.548Z |
5553665 | 5553665 | 20241118034612_r3eNt | USL01E | 2024-11-19T14:11:11.309Z | 2024-11-22T14:22:55.160Z |
5553647 | 5553647 | 20241118034003_2d38z | USL01E | 2024-11-19T14:11:08.883Z | 2024-11-22T14:22:55.035Z |
5553627 | 5553627 | 20241118033631_bZKC3 | USL01E | 2024-11-19T14:11:06.023Z | 2024-11-22T14:22:54.883Z |
5553443 | 5553443 | 20241118023905_2DJHt | USL01E | 2024-11-19T14:10:35.475Z | 2024-11-22T14:22:53.274Z |
5553399 | 5553399 | 20241118021923_vfZWx | USL01E | 2024-11-19T14:10:28.246Z | 2024-11-22T14:22:52.867Z |
5553360 | 5553360 | 20241118021005_3VuPP | USL01E | 2024-11-19T14:10:22.404Z | 2024-11-22T14:22:52.403Z |
5553245 | 5553245 | 20241118014648_isCdC | USL01E | 2024-11-19T14:10:12.074Z | 2024-11-22T14:22:51.373Z |
5551323 | 5551323 | 20241118130636_2w2Y6 | USL01E | 2024-11-19T14:04:25.055Z | 2024-11-22T14:22:10.052Z |
5551297 | 5551297 | 20241118125756_72m8J | USL01E | 2024-11-19T14:04:17.892Z | 2024-11-22T14:22:09.807Z |
5551273 | 5551273 | 20241118125226_NmTZJ | USL01E | 2024-11-19T14:04:13.367Z | 2024-11-22T14:22:09.610Z |
5551214 | 5551214 | 20241118124530_a3k3H | USL01E | 2024-11-19T14:04:07.119Z | 2024-11-22T14:22:09.277Z |
5551176 | 5551176 | 20241118123925_7eLX2 | USL01E | 2024-11-19T14:04:02.778Z | 2024-11-22T14:22:08.942Z |
5550891 | 5550891 | 20241118114427_veC6o | USL01E | 2024-11-19T14:03:20.012Z | 2024-11-22T14:22:06.488Z |
5550839 | 5550839 | 20241118113436_jTFDH | USL01E | 2024-11-19T14:03:11.460Z | 2024-11-22T14:22:06.068Z |
5550668 | 5550668 | 20241118110504_lhLXk | USL01E | 2024-11-19T14:02:53.842Z | 2024-11-22T14:22:04.781Z |
5550660 | 5550660 | 20241118110431_Q3ED0 | USL01E | 2024-11-19T14:02:53.227Z | 2024-11-22T14:22:04.740Z |
5550593 | 5550593 | 20241118105256_aX8mh | USL01E | 2024-11-19T14:02:43.147Z | 2024-11-22T14:22:04.186Z |
5550540 | 5550540 | 20241118104410_giQlC | USL01E | 2024-11-19T14:02:32.180Z | 2024-11-22T14:22:03.813Z |
5550472 | 5550472 | 20241118102422_lJR66 | USL01E | 2024-11-19T14:02:23.665Z | 2024-11-22T14:22:03.283Z |
5550462 | 5550462 | 20241118102308_va6MD | USL01E | 2024-11-19T14:02:22.643Z | 2024-11-22T14:22:03.172Z |
5550428 | 5550428 | 20241118102032_mcFd9 | USL01E | 2024-11-19T14:02:19.622Z | 2024-11-22T14:22:02.840Z |
5550297 | 5550297 | 20241118100052_oQDOZ | USL01E | 2024-11-19T14:02:08.066Z | 2024-11-22T14:22:00.919Z |
5550216 | 5550216 | 20241118094659_e2jzf | USL01E | 2024-11-19T14:01:46.872Z | 2024-11-22T14:21:59.839Z |
5550163 | 5550163 | 20241118094212_FPq3G | USL01E | 2024-11-19T14:01:40.082Z | 2024-11-22T14:21:59.098Z |
5550157 | 5550157 | 20241118094039_uCcTb | USL01E | 2024-11-19T14:01:39.870Z | 2024-11-22T14:21:59.080Z |
5550134 | 5550134 | 20241118093619_AMGxS | USL01E | 2024-11-19T14:01:36.813Z | 2024-11-22T14:21:58.705Z |
5550105 | 5550105 | 20241118093004_0h5rY | USL01E | 2024-11-19T14:01:34.742Z | 2024-11-22T14:21:58.207Z |
5549978 | 5549978 | 20241118085951_fr8zA | USL01E | 2024-11-19T14:01:23.077Z | 2024-11-22T14:21:55.994Z |
5549958 | 5549958 | 20241118085622_0w2qE | USL01E | 2024-11-19T14:01:21.602Z | 2024-11-22T14:21:55.794Z |
5549934 | 5549934 | 20241118084844_cIt25 | USL01E | 2024-11-19T14:01:15.620Z | 2024-11-22T14:21:55.287Z |
5549920 | 5549920 | 20241118084354_Anpp2 | USL01E | 2024-11-19T14:01:13.989Z | 2024-11-22T14:21:55.146Z |
5549914 | 5549914 | 20241118084347_kMPaX | USL01E | 2024-11-19T14:01:13.637Z | 2024-11-22T14:21:55.076Z |
5549904 | 5549904 | 20241118083708_4Y1j5 | USL01E | 2024-11-19T14:01:12.292Z | 2024-11-22T14:21:54.885Z |
5549896 | 5549896 | 20241118083404_qoYt2 | USL01E | 2024-11-19T14:01:09.397Z | 2024-11-22T14:21:54.774Z |
5549855 | 5549855 | 20241118080601_CdPve | USL01E | 2024-11-19T14:01:00.154Z | 2024-11-22T14:21:54.105Z |
5549851 | 5549851 | 20241118075931_92yNF | USL01E | 2024-11-19T14:00:59.850Z | 2024-11-22T14:21:54.052Z |
5549836 | 5549836 | 20241118074453_916Vl | USL01E | 2024-11-19T14:00:58.130Z | 2024-11-22T14:21:53.879Z |
5549830 | 5549830 | 20241118073050_lyzw2 | USL01E | 2024-11-19T14:00:57.572Z | 2024-11-22T14:21:53.874Z |
5549816 | 5549816 | 20241118070525_tFnCA | USL01E | 2024-11-19T14:00:55.535Z | 2024-11-22T14:21:53.576Z |
5549756 | 5549756 | 20241118061828_PMnBh | USL01E | 2024-11-19T14:00:45.920Z | 2024-11-22T14:21:52.393Z |
5549652 | 5549652 | 20241118054947_U9svq | USL01E | 2024-11-19T14:00:30.604Z | 2024-11-22T14:21:51.019Z |
5549592 | 5549592 | 20241118053523_omIiU | USL01E | 2024-11-19T14:00:22.030Z | 2024-11-22T14:21:50.474Z |
5549574 | 5549574 | 20241118053152_YzDTa | USL01E | 2024-11-19T14:00:20.111Z | 2024-11-22T14:21:50.367Z |
5549551 | 5549551 | 20241118052501_cnWeO | USL01E | 2024-11-19T14:00:16.973Z | 2024-11-22T14:21:50.197Z |
5549265 | 5549265 | 20241117040434_BRbxE | USL01E | 2024-11-18T14:11:23.304Z | 2024-11-22T14:23:19.831Z |
5549041 | 5549041 | 20241117024816_DC9SF | USL01E | 2024-11-18T14:10:45.697Z | 2024-11-22T14:23:17.672Z |
5546805 | 5546805 | 20241117124749_Mip96 | USL01E | 2024-11-18T14:04:15.715Z | 2024-11-22T14:22:34.678Z |
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);