participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL01A" 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 |
---|---|---|---|---|---|
5499653 | 5499653 | 20241108125137_NQboU | USL01A | 2024-11-09T14:04:34.055Z | 2024-11-09T14:04:34.055Z |
5499519 | 5499519 | 20241108123117_RgqPj | USL01A | 2024-11-09T14:04:15.072Z | 2024-11-09T14:04:15.072Z |
5499429 | 5499429 | 20241108121803_3i52o | USL01A | 2024-11-09T14:04:05.642Z | 2024-11-09T14:04:05.642Z |
5499342 | 5499342 | 20241108120111_DaSTz | USL01A | 2024-11-09T14:03:48.285Z | 2024-11-09T14:03:48.285Z |
5499336 | 5499336 | 20241108120006_rohN6 | USL01A | 2024-11-09T14:03:47.588Z | 2024-11-09T14:03:47.588Z |
5499157 | 5499157 | 20241108112000_FPqP7 | USL01A | 2024-11-09T14:03:26.669Z | 2024-11-09T14:03:26.669Z |
5498998 | 5498998 | 20241108104047_vBOFz | USL01A | 2024-11-09T14:02:56.683Z | 2024-11-09T14:02:56.683Z |
5498979 | 5498979 | 20241108103811_yjGJo | USL01A | 2024-11-09T14:02:54.746Z | 2024-11-09T14:02:54.746Z |
5498933 | 5498933 | 20241108102904_wydZZ | USL01A | 2024-11-09T14:02:48.363Z | 2024-11-09T14:02:48.363Z |
5498876 | 5498876 | 20241108101804_1HJMA | USL01A | 2024-11-09T14:02:40.749Z | 2024-11-09T14:02:40.749Z |
5498834 | 5498834 | 20241108101011_2xwxD | USL01A | 2024-11-09T14:02:31.226Z | 2024-11-09T14:02:31.226Z |
5498820 | 5498820 | 20241108100841_eA57Y | USL01A | 2024-11-09T14:02:28.830Z | 2024-11-09T14:02:28.830Z |
5498803 | 5498803 | 20241108100239_DRjPH | USL01A | 2024-11-09T14:02:26.248Z | 2024-11-09T14:02:26.248Z |
5498688 | 5498688 | 20241108093651_aB8EV | USL01A | 2024-11-09T14:02:11.573Z | 2024-11-09T14:02:11.573Z |
5498675 | 5498675 | 20241108093429_keQP1 | USL01A | 2024-11-09T14:02:09.728Z | 2024-11-09T14:02:09.728Z |
5498669 | 5498669 | 20241108093339_HSxP2 | USL01A | 2024-11-09T14:02:08.255Z | 2024-11-09T14:02:08.255Z |
5498653 | 5498653 | 20241108093213_yQ9u5 | USL01A | 2024-11-09T14:02:06.355Z | 2024-11-09T14:02:06.355Z |
5498638 | 5498638 | 20241108092853_37mPH | USL01A | 2024-11-09T14:02:03.997Z | 2024-11-09T14:02:03.997Z |
5498606 | 5498606 | 20241108091855_cGuXm | USL01A | 2024-11-09T14:01:54.768Z | 2024-11-09T14:01:54.768Z |
5498597 | 5498597 | 20241108091627_4V59X | USL01A | 2024-11-09T14:01:54.105Z | 2024-11-09T14:01:54.105Z |
5498529 | 5498529 | 20241108085712_bjNQ0 | USL01A | 2024-11-09T14:01:42.677Z | 2024-11-09T14:01:42.677Z |
5498460 | 5498460 | 20241108083712_C96JQ | USL01A | 2024-11-09T14:01:32.400Z | 2024-11-09T14:01:32.400Z |
5498439 | 5498439 | 20241108083146_dUebJ | USL01A | 2024-11-09T14:01:29.848Z | 2024-11-09T14:01:29.848Z |
5498408 | 5498408 | 20241108082742_XMZPK | USL01A | 2024-11-09T14:01:26.109Z | 2024-11-09T14:01:26.109Z |
5498311 | 5498311 | 20241108075957_j4m0a | USL01A | 2024-11-09T14:01:06.775Z | 2024-11-09T14:01:06.775Z |
5498265 | 5498265 | 20241108074555_wxtlU | USL01A | 2024-11-09T14:00:58.978Z | 2024-11-09T14:00:58.978Z |
5498205 | 5498205 | 20241108072759_1deTg | USL01A | 2024-11-09T14:00:49.290Z | 2024-11-09T14:00:49.290Z |
5498201 | 5498201 | 20241108072758_NAnbJ | USL01A | 2024-11-09T14:00:48.957Z | 2024-11-09T14:00:48.957Z |
5498068 | 5498068 | 20241108063902_IqGkc | USL01A | 2024-11-09T14:00:22.429Z | 2024-11-09T14:00:22.429Z |
5485489 | 5485489 | 20241105060149_jiBrn | USL01A | 2024-11-06T14:18:21.891Z | 2024-11-09T14:21:22.114Z |
5485383 | 5485383 | 20241105051454_ikUnQ | USL01A | 2024-11-06T14:18:11.259Z | 2024-11-09T14:21:21.300Z |
5485270 | 5485270 | 20241105043323_A4wxg | USL01A | 2024-11-06T14:18:00.472Z | 2024-11-09T14:21:20.379Z |
5484721 | 5484721 | 20241105032222_Rp2EX | USL01A | 2024-11-06T14:17:11.776Z | 2024-11-09T14:21:16.082Z |
5471741 | 5471741 | 20241104123224_q2ax3 | USL01A | 2024-11-05T14:04:32.218Z | 2024-11-09T14:20:33.251Z |
5471736 | 5471736 | 20241104123053_UmXyQ | USL01A | 2024-11-05T14:04:31.522Z | 2024-11-09T14:20:33.132Z |
5471639 | 5471639 | 20241104121330_sBFUu | USL01A | 2024-11-05T14:04:08.552Z | 2024-11-09T14:20:32.281Z |
5471606 | 5471606 | 20241104120828_3r9CD | USL01A | 2024-11-05T14:04:03.233Z | 2024-11-09T14:20:32.170Z |
5471479 | 5471479 | 20241104114840_RLxPP | USL01A | 2024-11-05T14:03:48.316Z | 2024-11-09T14:20:31.359Z |
5471474 | 5471474 | 20241104114751_blOaB | USL01A | 2024-11-05T14:03:47.461Z | 2024-11-09T14:20:31.226Z |
5471353 | 5471353 | 20241104113025_9B5vY | USL01A | 2024-11-05T14:03:30.775Z | 2024-11-09T14:20:30.451Z |
5463954 | 5463954 | 20241102061947_Z8q33 | USL01A | 2024-11-03T14:19:26.877Z | 2024-11-09T14:23:44.973Z |
5463306 | 5463306 | 20241102031256_Cmgyw | USL01A | 2024-11-03T14:18:31.824Z | 2024-11-09T14:23:39.874Z |
5463229 | 5463229 | 20241102025811_3nsi7 | USL01A | 2024-11-03T14:18:27.081Z | 2024-11-09T14:23:38.846Z |
5456886 | 5456886 | 20241102124320_0Vuv2 | USL01A | 2024-11-03T14:05:53.125Z | 2024-11-09T14:22:45.932Z |
5456837 | 5456837 | 20241102123613_rVSko | USL01A | 2024-11-03T14:05:47.377Z | 2024-11-09T14:22:45.788Z |
5456801 | 5456801 | 20241102122625_OBI9W | USL01A | 2024-11-03T14:05:42.416Z | 2024-11-09T14:22:45.648Z |
5456655 | 5456655 | 20241102115831_O40yM | USL01A | 2024-11-03T14:05:14.498Z | 2024-11-09T14:22:44.878Z |
5456504 | 5456504 | 20241102113539_sybSc | USL01A | 2024-11-03T14:04:51.822Z | 2024-11-09T14:22:44.205Z |
5456481 | 5456481 | 20241102113107_GF13V | USL01A | 2024-11-03T14:04:48.209Z | 2024-11-09T14:22:44.018Z |
5456305 | 5456305 | 20241102105600_MMRjM | USL01A | 2024-11-03T14:04:09.247Z | 2024-11-09T14:22:42.797Z |
5456291 | 5456291 | 20241102105438_Tu6zS | USL01A | 2024-11-03T14:04:06.785Z | 2024-11-09T14:22:42.715Z |
5456278 | 5456278 | 20241102105236_P2hte | USL01A | 2024-11-03T14:04:05.279Z | 2024-11-09T14:22:42.679Z |
5456274 | 5456274 | 20241102105205_eLUS3 | USL01A | 2024-11-03T14:04:04.916Z | 2024-11-09T14:22:42.672Z |
5456216 | 5456216 | 20241102104350_K2JQL | USL01A | 2024-11-03T14:03:49.756Z | 2024-11-09T14:22:42.486Z |
5456142 | 5456142 | 20241102102815_3QPsg | USL01A | 2024-11-03T14:03:29.343Z | 2024-11-09T14:22:42.108Z |
5456131 | 5456131 | 20241102102739_RFoYX | USL01A | 2024-11-03T14:03:26.253Z | 2024-11-09T14:22:42.079Z |
5455944 | 5455944 | 20241102094917_Gl8kH | USL01A | 2024-11-03T14:02:53.504Z | 2024-11-09T14:22:40.928Z |
5455809 | 5455809 | 20241102092136_p52uc | USL01A | 2024-11-03T14:02:23.205Z | 2024-11-09T14:22:39.839Z |
5455732 | 5455732 | 20241102090620_6Ga1q | USL01A | 2024-11-03T14:02:05.594Z | 2024-11-09T14:22:38.543Z |
5455720 | 5455720 | 20241102090446_tJ0BR | USL01A | 2024-11-03T14:02:03.705Z | 2024-11-09T14:22:38.366Z |
5455710 | 5455710 | 20241102090348_1un2q | USL01A | 2024-11-03T14:02:01.647Z | 2024-11-09T14:22:38.263Z |
5455665 | 5455665 | 20241102085322_ja4Ki | USL01A | 2024-11-03T14:01:50.279Z | 2024-11-09T14:22:37.746Z |
5455638 | 5455638 | 20241102084641_atX3n | USL01A | 2024-11-03T14:01:45.546Z | 2024-11-09T14:22:37.579Z |
5455603 | 5455603 | 20241102084201_I0Xny | USL01A | 2024-11-03T14:01:38.787Z | 2024-11-09T14:22:37.361Z |
5455546 | 5455546 | 20241102082332_yGrZp | USL01A | 2024-11-03T14:01:20.079Z | 2024-11-09T14:22:36.742Z |
5455539 | 5455539 | 20241102082154_llww3 | USL01A | 2024-11-03T14:01:16.361Z | 2024-11-09T14:22:36.715Z |
5455369 | 5455369 | 20241102073302_XbT1g | USL01A | 2024-11-03T14:00:42.749Z | 2024-11-09T14:22:35.062Z |
5455215 | 5455215 | 20241102064853_sAHvz | USL01A | 2024-11-03T14:00:09.565Z | 2024-11-09T14:22:33.300Z |
5455128 | 5455128 | 20241031063544_3tssS | USL01A | 2024-11-02T12:23:31.602Z | 2024-11-08T14:23:27.515Z |
5455027 | 5455027 | 20241031060908_CTsnu | USL01A | 2024-11-02T12:23:29.731Z | 2024-11-08T14:23:26.895Z |
5454731 | 5454731 | 20241031050153_X92TT | USL01A | 2024-11-02T12:23:19.236Z | 2024-11-08T14:23:25.351Z |
5454496 | 5454496 | 20241031042956_zUBCT | USL01A | 2024-11-02T12:23:07.723Z | 2024-11-08T14:23:23.371Z |
5454237 | 5454237 | 20241031040112_vnzyT | USL01A | 2024-11-02T12:22:55.628Z | 2024-11-08T14:23:21.662Z |
5454022 | 5454022 | 20241031033220_J3w2Z | USL01A | 2024-11-02T12:22:48.632Z | 2024-11-08T14:23:20.012Z |
5448054 | 5448054 | 20241031123643_GKtL1 | USL01A | 2024-11-02T12:09:50.966Z | 2024-11-09T14:24:02.552Z |
5448044 | 5448044 | 20241031123600_3LbLf | USL01A | 2024-11-02T12:09:49.754Z | 2024-11-09T14:24:02.540Z |
5448001 | 5448001 | 20241031123108_C6rYG | USL01A | 2024-11-02T12:09:41.777Z | 2024-11-09T14:24:02.067Z |
5447912 | 5447912 | 20241031122220_FNnLV | USL01A | 2024-11-02T12:09:25.038Z | 2024-11-09T14:24:01.637Z |
5447908 | 5447908 | 20241031122220_rdnj3 | USL01A | 2024-11-02T12:09:24.840Z | 2024-11-09T14:24:01.631Z |
5447831 | 5447831 | 20241031121509_tabiI | USL01A | 2024-11-02T12:09:15.471Z | 2024-11-09T14:24:01.459Z |
5447611 | 5447611 | 20241031115618_0BI51 | USL01A | 2024-11-02T12:08:38.766Z | 2024-11-09T14:24:00.596Z |
5447428 | 5447428 | 20241031114036_KmiCL | USL01A | 2024-11-02T12:08:09.058Z | 2024-11-09T14:23:59.661Z |
5447409 | 5447409 | 20241031113927_4Q51e | USL01A | 2024-11-02T12:08:05.748Z | 2024-11-09T14:23:59.631Z |
5447346 | 5447346 | 20241031113342_xiRwL | USL01A | 2024-11-02T12:07:50.997Z | 2024-11-09T14:23:58.895Z |
5447343 | 5447343 | 20241031113334_65hVN | USL01A | 2024-11-02T12:07:50.311Z | 2024-11-09T14:23:58.893Z |
5447288 | 5447288 | 20241031112722_th664 | USL01A | 2024-11-02T12:07:41.793Z | 2024-11-09T14:23:58.736Z |
5447276 | 5447276 | 20241031112613_KV1YX | USL01A | 2024-11-02T12:07:40.545Z | 2024-11-09T14:23:58.516Z |
5447255 | 5447255 | 20241031112337_FY7ax | USL01A | 2024-11-02T12:07:37.076Z | 2024-11-09T14:23:58.468Z |
5447241 | 5447241 | 20241031112124_8j336 | USL01A | 2024-11-02T12:07:35.318Z | 2024-11-09T14:23:58.431Z |
5447215 | 5447215 | 20241031111956_EjvuE | USL01A | 2024-11-02T12:07:30.657Z | 2024-11-09T14:23:58.408Z |
5447205 | 5447205 | 20241031111746_W7fcA | USL01A | 2024-11-02T12:07:28.908Z | 2024-11-09T14:23:58.272Z |
5447146 | 5447146 | 20241031111221_5823g | USL01A | 2024-11-02T12:07:22.960Z | 2024-11-09T14:23:58.038Z |
5447127 | 5447127 | 20241031110900_3973M | USL01A | 2024-11-02T12:07:20.672Z | 2024-11-09T14:23:57.996Z |
5447085 | 5447085 | 20241031110724_9lpI5 | USL01A | 2024-11-02T12:07:14.623Z | 2024-11-09T14:23:57.900Z |
5447043 | 5447043 | 20241031110121_3g7SN | USL01A | 2024-11-02T12:06:59.009Z | 2024-11-09T14:23:57.487Z |
5446998 | 5446998 | 20241031105519_Q7BGr | USL01A | 2024-11-02T12:06:51.578Z | 2024-11-09T14:23:57.329Z |
5446991 | 5446991 | 20241031105432_O8khb | USL01A | 2024-11-02T12:06:50.923Z | 2024-11-09T14:23:57.308Z |
5446974 | 5446974 | 20241031105333_ZNhjy | USL01A | 2024-11-02T12:06:48.866Z | 2024-11-09T14:23:57.292Z |
5446931 | 5446931 | 20241031104931_sBJYM | USL01A | 2024-11-02T12:06:43.592Z | 2024-11-09T14:23:57.141Z |
5446869 | 5446869 | 20241031104124_0EgzD | USL01A | 2024-11-02T12:06:34.370Z | 2024-11-09T14:23:56.894Z |
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);