participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00L" 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 |
---|---|---|---|---|---|
5573079 | 5573079 | 20241121035000_V9xut | USL00L | 2024-11-22T14:19:09.007Z | 2024-11-22T14:19:22.446Z |
5573039 | 5573039 | 20241121034304_qFv0s | USL00L | 2024-11-22T14:19:06.908Z | 2024-11-22T14:19:22.438Z |
5568150 | 5568150 | 20241121115552_HQKzr | USL00L | 2024-11-22T14:08:13.220Z | 2024-11-22T14:08:13.220Z |
5568093 | 5568093 | 20241121114759_UcdZv | USL00L | 2024-11-22T14:08:05.031Z | 2024-11-22T14:08:05.031Z |
5568065 | 5568065 | 20241121114559_3Ime9 | USL00L | 2024-11-22T14:08:02.580Z | 2024-11-22T14:08:02.580Z |
5567973 | 5567973 | 20241121113709_DJN8N | USL00L | 2024-11-22T14:07:52.624Z | 2024-11-22T14:07:52.624Z |
5567865 | 5567865 | 20241121112011_gs9Iv | USL00L | 2024-11-22T14:07:27.497Z | 2024-11-22T14:07:27.497Z |
5567761 | 5567761 | 20241121110229_GT7Op | USL00L | 2024-11-22T14:07:13.288Z | 2024-11-22T14:07:13.288Z |
5567724 | 5567724 | 20241121105732_AE2dJ | USL00L | 2024-11-22T14:07:08.368Z | 2024-11-22T14:07:08.368Z |
5567489 | 5567489 | 20241121102823_RfEK0 | USL00L | 2024-11-22T14:06:23.726Z | 2024-11-22T14:06:23.726Z |
5567061 | 5567061 | 20241121090530_T2727 | USL00L | 2024-11-22T14:05:01.559Z | 2024-11-22T14:05:01.559Z |
5567042 | 5567042 | 20241121090004_8vv2W | USL00L | 2024-11-22T14:04:57.836Z | 2024-11-22T14:04:57.836Z |
5566967 | 5566967 | 20241121085041_P4EBY | USL00L | 2024-11-22T14:04:47.111Z | 2024-11-22T14:04:47.111Z |
5566959 | 5566959 | 20241121084918_Td3AU | USL00L | 2024-11-22T14:04:45.870Z | 2024-11-22T14:04:45.870Z |
5566818 | 5566818 | 20241121080232_8p6bn | USL00L | 2024-11-22T14:04:10.577Z | 2024-11-22T14:04:10.577Z |
5566729 | 5566729 | 20241121073316_DgvLO | USL00L | 2024-11-22T14:03:46.803Z | 2024-11-22T14:03:46.803Z |
5566597 | 5566597 | 20241121065613_UPM3I | USL00L | 2024-11-22T14:03:22.473Z | 2024-11-22T14:03:22.473Z |
5566558 | 5566558 | 20241121063907_AH9X2 | USL00L | 2024-11-22T14:03:10.872Z | 2024-11-22T14:03:10.872Z |
5566476 | 5566476 | 20241121062031_ITRlU | USL00L | 2024-11-22T14:02:58.830Z | 2024-11-22T14:02:58.830Z |
5566370 | 5566370 | 20241121060520_264Ut | USL00L | 2024-11-22T14:02:35.236Z | 2024-11-22T14:02:35.236Z |
5566239 | 5566239 | 20241121055056_myvgv | USL00L | 2024-11-22T14:02:16.937Z | 2024-11-22T14:02:16.937Z |
5566179 | 5566179 | 20241121054357_6sM83 | USL00L | 2024-11-22T14:02:07.981Z | 2024-11-22T14:02:07.981Z |
5566114 | 5566114 | 20241121053422_32dvy | USL00L | 2024-11-22T14:01:51.650Z | 2024-11-22T14:01:51.650Z |
5565219 | 5565219 | 20241120040505_fdZmU | USL00L | 2024-11-21T14:18:41.734Z | 2024-11-22T14:21:44.145Z |
5563987 | 5563987 | 20241120022047_FW0pE | USL00L | 2024-11-21T14:17:02.569Z | 2024-11-22T14:21:26.013Z |
5563694 | 5563694 | 20241120015741_F0P43 | USL00L | 2024-11-21T14:16:34.782Z | 2024-11-22T14:21:21.150Z |
5560522 | 5560522 | 20241120130715_oxcmH | USL00L | 2024-11-21T14:09:01.355Z | 2024-11-22T14:19:21.678Z |
5560516 | 5560516 | 20241120130600_VITO2 | USL00L | 2024-11-21T14:09:00.488Z | 2024-11-22T14:19:21.677Z |
5560498 | 5560498 | 20241120130057_Uka29 | USL00L | 2024-11-21T14:08:57.955Z | 2024-11-22T14:19:21.671Z |
5560495 | 5560495 | 20241120125932_hSJxg | USL00L | 2024-11-21T14:08:57.756Z | 2024-11-22T14:19:21.671Z |
5560455 | 5560455 | 20241120125336_a0EOo | USL00L | 2024-11-21T14:08:53.689Z | 2024-11-22T14:19:21.662Z |
5560363 | 5560363 | 20241120124217_HOd3p | USL00L | 2024-11-21T14:08:44.705Z | 2024-11-22T14:19:21.645Z |
5560296 | 5560296 | 20241120123205_2IErC | USL00L | 2024-11-21T14:08:32.734Z | 2024-11-22T14:19:21.631Z |
5560203 | 5560203 | 20241120121745_CQwuy | USL00L | 2024-11-21T14:08:15.429Z | 2024-11-22T14:19:21.611Z |
5560193 | 5560193 | 20241120121604_3waUj | USL00L | 2024-11-21T14:08:13.826Z | 2024-11-22T14:19:21.608Z |
5560166 | 5560166 | 20241120121001_0cuUB | USL00L | 2024-11-21T14:08:10.356Z | 2024-11-22T14:19:21.601Z |
5560157 | 5560157 | 20241120120813_STBGY | USL00L | 2024-11-21T14:08:08.816Z | 2024-11-22T14:19:21.599Z |
5560155 | 5560155 | 20241120120808_VM8WJ | USL00L | 2024-11-21T14:08:08.248Z | 2024-11-22T14:19:21.598Z |
5560081 | 5560081 | 20241120115654_ncxi3 | USL00L | 2024-11-21T14:08:00.521Z | 2024-11-22T14:19:21.584Z |
5560039 | 5560039 | 20241120114941_KYbul | USL00L | 2024-11-21T14:07:55.235Z | 2024-11-22T14:19:21.574Z |
5559981 | 5559981 | 20241120114059_EEknv | USL00L | 2024-11-21T14:07:48.150Z | 2024-11-22T14:19:21.561Z |
5559828 | 5559828 | 20241120112206_JDtbt | USL00L | 2024-11-21T14:07:17.356Z | 2024-11-22T14:19:21.533Z |
5559584 | 5559584 | 20241120104508_DcbvA | USL00L | 2024-11-21T14:06:39.844Z | 2024-11-22T14:19:21.479Z |
5559423 | 5559423 | 20241120102110_3iqxm | USL00L | 2024-11-21T14:06:17.597Z | 2024-11-22T14:19:21.443Z |
5559377 | 5559377 | 20241120101314_3GlNL | USL00L | 2024-11-21T14:06:11.410Z | 2024-11-22T14:19:21.431Z |
5559190 | 5559190 | 20241120093547_1HhMW | USL00L | 2024-11-21T14:05:33.985Z | 2024-11-22T14:19:21.382Z |
5559096 | 5559096 | 20241120092303_FneN9 | USL00L | 2024-11-21T14:05:20.729Z | 2024-11-22T14:19:21.363Z |
5559018 | 5559018 | 20241120090527_BNupF | USL00L | 2024-11-21T14:05:03.196Z | 2024-11-22T14:19:21.348Z |
5559005 | 5559005 | 20241120090451_ZuOpG | USL00L | 2024-11-21T14:05:01.361Z | 2024-11-22T14:19:21.345Z |
5558913 | 5558913 | 20241120084904_tUHS5 | USL00L | 2024-11-21T14:04:47.898Z | 2024-11-22T14:19:21.327Z |
5558911 | 5558911 | 20241120084728_CtR7W | USL00L | 2024-11-21T14:04:47.429Z | 2024-11-22T14:19:21.326Z |
5558860 | 5558860 | 20241120083209_PrJ2B | USL00L | 2024-11-21T14:04:40.051Z | 2024-11-22T14:19:21.316Z |
5558779 | 5558779 | 20241120075935_BSIrC | USL00L | 2024-11-21T14:04:20.101Z | 2024-11-22T14:19:21.298Z |
5558710 | 5558710 | 20241120074340_TfEBV | USL00L | 2024-11-21T14:04:08.513Z | 2024-11-22T14:19:21.286Z |
5558705 | 5558705 | 20241120074123_kpYdz | USL00L | 2024-11-21T14:04:06.901Z | 2024-11-22T14:19:21.284Z |
5558693 | 5558693 | 20241120073413_oPu2g | USL00L | 2024-11-21T14:04:04.509Z | 2024-11-22T14:19:21.281Z |
5558628 | 5558628 | 20241120071100_7JFEL | USL00L | 2024-11-21T14:03:52.701Z | 2024-11-22T14:19:21.267Z |
5558533 | 5558533 | 20241120062527_dnbO4 | USL00L | 2024-11-21T14:03:32.473Z | 2024-11-22T14:19:21.247Z |
5558248 | 5558248 | 20241120054822_p2f8n | USL00L | 2024-11-21T14:02:51.775Z | 2024-11-22T14:19:21.199Z |
5557981 | 5557981 | 20241120052800_hEtOa | USL00L | 2024-11-21T14:02:11.822Z | 2024-11-22T14:19:21.156Z |
5557517 | 5557517 | 20241120045251_73VMa | USL00L | 2024-11-21T14:01:04.114Z | 2024-11-22T14:19:21.083Z |
5555077 | 5555077 | 20241119113341_rkqhK | USL00L | 2024-11-20T14:04:24.883Z | 2024-11-22T14:19:56.997Z |
5554900 | 5554900 | 20241119105757_Ur9zI | USL00L | 2024-11-20T14:03:46.043Z | 2024-11-22T14:19:53.628Z |
5554890 | 5554890 | 20241119105554_tIkBJ | USL00L | 2024-11-20T14:03:44.205Z | 2024-11-22T14:19:53.314Z |
5554765 | 5554765 | 20241119103014_27sI3 | USL00L | 2024-11-20T14:03:13.014Z | 2024-11-22T14:19:50.968Z |
5554751 | 5554751 | 20241119102231_lT2kp | USL00L | 2024-11-20T14:03:11.309Z | 2024-11-22T14:19:50.689Z |
5554734 | 5554734 | 20241119102002_2yjf5 | USL00L | 2024-11-20T14:03:09.389Z | 2024-11-22T14:19:50.194Z |
5554732 | 5554732 | 20241119101956_FBiaI | USL00L | 2024-11-20T14:03:08.866Z | 2024-11-22T14:19:50.118Z |
5554707 | 5554707 | 20241119101404_GKPyl | USL00L | 2024-11-20T14:03:04.878Z | 2024-11-22T14:19:49.505Z |
5554620 | 5554620 | 20241119094922_fQz7N | USL00L | 2024-11-20T14:02:43.566Z | 2024-11-22T14:19:45.855Z |
5554491 | 5554491 | 20241119091542_sezQk | USL00L | 2024-11-20T14:02:17.104Z | 2024-11-22T14:19:41.847Z |
5554419 | 5554419 | 20241119085139_4jnjg | USL00L | 2024-11-20T14:01:59.428Z | 2024-11-22T14:19:40.429Z |
5554352 | 5554352 | 20241119082429_301mc | USL00L | 2024-11-20T14:01:44.288Z | 2024-11-22T14:19:38.009Z |
5554336 | 5554336 | 20241119081948_LzLq7 | USL00L | 2024-11-20T14:01:42.233Z | 2024-11-22T14:19:37.505Z |
5554328 | 5554328 | 20241119081515_kb66m | USL00L | 2024-11-20T14:01:40.216Z | 2024-11-22T14:19:37.313Z |
5554264 | 5554264 | 20241119073456_K3MkH | USL00L | 2024-11-20T14:01:18.158Z | 2024-11-22T14:19:34.453Z |
5553920 | 5553920 | 20241118045553_9xqlX | USL00L | 2024-11-19T14:11:33.677Z | 2024-11-22T14:22:57.301Z |
5553202 | 5553202 | 20241118013533_ZzW84 | USL00L | 2024-11-19T14:10:09.297Z | 2024-11-22T14:22:51.052Z |
5550832 | 5550832 | 20241118113422_rgMIe | USL00L | 2024-11-19T14:03:10.725Z | 2024-11-22T14:22:06.000Z |
5550731 | 5550731 | 20241118111650_PjBPK | USL00L | 2024-11-19T14:02:59.273Z | 2024-11-22T14:22:05.155Z |
5550531 | 5550531 | 20241118104240_Cf0Y4 | USL00L | 2024-11-19T14:02:31.238Z | 2024-11-22T14:22:03.787Z |
5550509 | 5550509 | 20241118103604_2Bupi | USL00L | 2024-11-19T14:02:28.566Z | 2024-11-22T14:22:03.588Z |
5550302 | 5550302 | 20241118100345_KFMZD | USL00L | 2024-11-19T14:02:09.618Z | 2024-11-22T14:22:01.148Z |
5550010 | 5550010 | 20241118090634_ICCoU | USL00L | 2024-11-19T14:01:26.434Z | 2024-11-22T14:21:56.698Z |
5549891 | 5549891 | 20241118083054_xaTyt | USL00L | 2024-11-19T14:01:09.096Z | 2024-11-22T14:21:54.758Z |
5549789 | 5549789 | 20241118063735_jC0Hn | USL00L | 2024-11-19T14:00:51.399Z | 2024-11-22T14:21:52.925Z |
5549768 | 5549768 | 20241118062306_uL65p | USL00L | 2024-11-19T14:00:48.389Z | 2024-11-22T14:21:52.533Z |
5545771 | 5545771 | 20241117064501_xZNTM | USL00L | 2024-11-18T14:00:54.619Z | 2024-11-22T14:22:25.984Z |
5543892 | 5543892 | 20241115041521_aC396 | USL00L | 2024-11-16T14:07:36.902Z | 2024-11-22T14:24:02.315Z |
5542812 | 5542812 | 20241115124432_xHieW | USL00L | 2024-11-16T14:02:40.076Z | 2024-11-22T14:23:31.486Z |
5541998 | 5541998 | 20241114052744_3yHSf | USL00L | 2024-11-15T14:08:46.788Z | 2024-11-22T14:24:21.641Z |
5541039 | 5541039 | 20241114125443_ORVRL | USL00L | 2024-11-15T14:04:58.178Z | 2024-11-22T14:23:54.396Z |
5541036 | 5541036 | 20241114125430_uDj4J | USL00L | 2024-11-15T14:04:58.026Z | 2024-11-22T14:23:54.385Z |
5540996 | 5540996 | 20241114124129_R2XV3 | USL00L | 2024-11-15T14:04:54.702Z | 2024-11-22T14:23:54.152Z |
5540984 | 5540984 | 20241114123950_L6Tey | USL00L | 2024-11-15T14:04:53.904Z | 2024-11-22T14:23:53.750Z |
5540766 | 5540766 | 20241114120359_M023B | USL00L | 2024-11-15T14:04:26.197Z | 2024-11-22T14:23:52.642Z |
5540734 | 5540734 | 20241114115709_ekxyI | USL00L | 2024-11-15T14:04:21.760Z | 2024-11-22T14:23:52.430Z |
5540448 | 5540448 | 20241114110749_ZBQt1 | USL00L | 2024-11-15T14:03:50.061Z | 2024-11-22T14:23:51.040Z |
5540343 | 5540343 | 20241114103840_rdY5P | USL00L | 2024-11-15T14:03:28.293Z | 2024-11-22T14:23:50.518Z |
5540263 | 5540263 | 20241114103047_cPBrJ | USL00L | 2024-11-15T14:03:12.196Z | 2024-11-22T14:23:50.129Z |
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);