participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00N" 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 |
---|---|---|---|---|---|
5567490 | 5567490 | 20241121102823_RfEK0 | USL00N | 2024-11-22T14:06:23.726Z | 2024-11-22T14:06:23.726Z |
5567406 | 5567406 | 20241121101228_9VS2Y | USL00N | 2024-11-22T14:06:10.824Z | 2024-11-22T14:06:10.824Z |
5567393 | 5567393 | 20241121100933_YGOsz | USL00N | 2024-11-22T14:06:04.831Z | 2024-11-22T14:06:04.831Z |
5567195 | 5567195 | 20241121093851_NBxb5 | USL00N | 2024-11-22T14:05:32.740Z | 2024-11-22T14:05:32.740Z |
5567085 | 5567085 | 20241121091436_j1mwI | USL00N | 2024-11-22T14:05:05.681Z | 2024-11-22T14:05:05.681Z |
5567048 | 5567048 | 20241121090037_jTXDo | USL00N | 2024-11-22T14:04:58.753Z | 2024-11-22T14:04:58.753Z |
5565792 | 5565792 | 20241121044635_vbDlL | USL00N | 2024-11-22T14:00:57.259Z | 2024-11-22T14:00:57.259Z |
5565728 | 5565728 | 20241121043837_bAMwT | USL00N | 2024-11-22T14:00:47.235Z | 2024-11-22T14:00:47.235Z |
5565303 | 5565303 | 20241120041750_l4xjo | USL00N | 2024-11-21T14:18:45.807Z | 2024-11-22T14:21:45.815Z |
5565067 | 5565067 | 20241120034914_Ig2rq | USL00N | 2024-11-21T14:18:27.469Z | 2024-11-22T14:21:40.834Z |
5565019 | 5565019 | 20241120034517_7oIci | USL00N | 2024-11-21T14:18:21.880Z | 2024-11-22T14:21:40.389Z |
5560244 | 5560244 | 20241120122335_akYCf | USL00N | 2024-11-21T14:08:22.550Z | 2024-11-22T14:19:21.619Z |
5560108 | 5560108 | 20241120120149_AahDc | USL00N | 2024-11-21T14:08:03.408Z | 2024-11-22T14:19:21.589Z |
5560018 | 5560018 | 20241120114630_i8wCF | USL00N | 2024-11-21T14:07:52.487Z | 2024-11-22T14:19:21.570Z |
5560000 | 5560000 | 20241120114507_328EU | USL00N | 2024-11-21T14:07:50.166Z | 2024-11-22T14:19:21.565Z |
5559585 | 5559585 | 20241120104508_DcbvA | USL00N | 2024-11-21T14:06:39.844Z | 2024-11-22T14:19:21.479Z |
5559408 | 5559408 | 20241120101951_uvy3P | USL00N | 2024-11-21T14:06:15.722Z | 2024-11-22T14:19:21.440Z |
5559214 | 5559214 | 20241120093833_rIAr3 | USL00N | 2024-11-21T14:05:37.421Z | 2024-11-22T14:19:21.387Z |
5558476 | 5558476 | 20241120061105_10xt7 | USL00N | 2024-11-21T14:03:23.207Z | 2024-11-22T14:19:21.236Z |
5557982 | 5557982 | 20241120052800_hEtOa | USL00N | 2024-11-21T14:02:11.823Z | 2024-11-22T14:19:21.156Z |
5557114 | 5557114 | 20241119035810_8YLXF | USL00N | 2024-11-20T14:12:19.020Z | 2024-11-22T14:22:22.316Z |
5554270 | 5554270 | 20241119073814_20p1R | USL00N | 2024-11-20T14:01:21.239Z | 2024-11-22T14:19:34.594Z |
5553968 | 5553968 | 20241119050032_W4nc2 | USL00N | 2024-11-20T14:00:14.311Z | 2024-11-22T14:19:25.046Z |
5549669 | 5549669 | 20241118055554_g13Og | USL00N | 2024-11-19T14:00:32.398Z | 2024-11-22T14:21:51.088Z |
5549614 | 5549614 | 20241118053851_MBFDq | USL00N | 2024-11-19T14:00:25.887Z | 2024-11-22T14:21:50.765Z |
5543845 | 5543845 | 20241115035017_vTzuF | USL00N | 2024-11-16T14:07:25.127Z | 2024-11-22T14:24:01.903Z |
5542809 | 5542809 | 20241115124219_7a3VX | USL00N | 2024-11-16T14:02:39.585Z | 2024-11-22T14:23:31.469Z |
5540883 | 5540883 | 20241114122021_JgT18 | USL00N | 2024-11-15T14:04:37.186Z | 2024-11-22T14:23:52.977Z |
5540534 | 5540534 | 20241114112253_343of | USL00N | 2024-11-15T14:04:00.226Z | 2024-11-22T14:23:51.456Z |
5540063 | 5540063 | 20241114095754_9R3Zj | USL00N | 2024-11-15T14:02:47.243Z | 2024-11-22T14:23:48.795Z |
5535553 | 5535553 | 20241112124756_FI2yx | USL00N | 2024-11-14T14:08:04.455Z | 2024-11-21T14:25:49.995Z |
5535501 | 5535501 | 20241112123854_hQ60M | USL00N | 2024-11-14T14:08:00.484Z | 2024-11-21T14:25:48.688Z |
5533825 | 5533825 | 20241113101551_XEzMC | USL00N | 2024-11-14T14:02:56.366Z | 2024-11-22T14:24:11.431Z |
5533630 | 5533630 | 20241113093539_KQot8 | USL00N | 2024-11-14T14:02:32.380Z | 2024-11-22T14:24:10.537Z |
5533627 | 5533627 | 20241113093539_VyxvX | USL00N | 2024-11-14T14:02:32.057Z | 2024-11-22T14:24:10.528Z |
5533517 | 5533517 | 20241113091114_zE6RM | USL00N | 2024-11-14T14:02:13.128Z | 2024-11-22T14:24:09.774Z |
5527036 | 5527036 | 20241112105041_tq0VK | USL00N | 2024-11-13T14:04:54.102Z | 2024-11-21T14:25:40.762Z |
5527031 | 5527031 | 20241112104859_hh0xF | USL00N | 2024-11-13T14:04:53.341Z | 2024-11-21T14:25:40.707Z |
5526994 | 5526994 | 20241112104309_b2CXQ | USL00N | 2024-11-13T14:04:48.710Z | 2024-11-21T14:25:40.189Z |
5526955 | 5526955 | 20241112103644_TtayF | USL00N | 2024-11-13T14:04:43.606Z | 2024-11-21T14:25:39.919Z |
5526873 | 5526873 | 20241112102534_ANe3q | USL00N | 2024-11-13T14:04:25.674Z | 2024-11-21T14:25:39.473Z |
5526868 | 5526868 | 20241112102530_QLDhK | USL00N | 2024-11-13T14:04:24.890Z | 2024-11-21T14:25:39.363Z |
5526830 | 5526830 | 20241112102030_2UwZ3 | USL00N | 2024-11-13T14:04:17.363Z | 2024-11-21T14:25:38.891Z |
5526758 | 5526758 | 20241112101122_BWdgz | USL00N | 2024-11-13T14:04:05.649Z | 2024-11-21T14:25:38.070Z |
5526700 | 5526700 | 20241112100325_hAeN6 | USL00N | 2024-11-13T14:03:57.729Z | 2024-11-21T14:25:37.296Z |
5526626 | 5526626 | 20241112095620_nRPye | USL00N | 2024-11-13T14:03:39.761Z | 2024-11-21T14:25:36.866Z |
5526138 | 5526138 | 20241112081447_HKkhE | USL00N | 2024-11-13T14:01:59.796Z | 2024-11-21T14:25:30.669Z |
5526039 | 5526039 | 20241112075317_LF8rP | USL00N | 2024-11-13T14:01:40.441Z | 2024-11-21T14:25:30.151Z |
5317897 | 5317897 | 20241017122401_jLwwy | USL00N | 2024-10-18T12:01:03.201Z | 2024-10-26T12:27:52.006Z |
5317884 | 5317884 | 20241017121404_BNn1s | USL00N | 2024-10-18T12:01:01.515Z | 2024-10-26T12:27:51.967Z |
5317029 | 5317029 | 20241016023919_PaX8i | USL00N | 2024-10-17T12:07:38.676Z | 2024-10-24T12:27:58.613Z |
5315354 | 5315354 | 20241015122544_hTUcf | USL00N | 2024-10-17T12:04:29.136Z | 2024-10-24T12:27:52.192Z |
5315050 | 5315050 | 20241015113344_S58yw | USL00N | 2024-10-17T12:04:08.735Z | 2024-10-24T12:27:49.411Z |
5315015 | 5315015 | 20241015112919_yeeh0 | USL00N | 2024-10-17T12:04:06.512Z | 2024-10-24T12:27:49.092Z |
5314930 | 5314930 | 20241015111448_Kcnv0 | USL00N | 2024-10-17T12:04:00.186Z | 2024-10-24T12:27:47.820Z |
5314381 | 5314381 | 20241016123751_z333F | USL00N | 2024-10-17T12:02:13.611Z | 2024-10-25T12:24:30.033Z |
5314334 | 5314334 | 20241016122727_9ozBi | USL00N | 2024-10-17T12:02:07.587Z | 2024-10-25T12:24:29.871Z |
5314269 | 5314269 | 20241016120830_hmwVy | USL00N | 2024-10-17T12:01:55.512Z | 2024-10-25T12:24:29.380Z |
5314095 | 5314095 | 20241016113146_M38DH | USL00N | 2024-10-17T12:01:41.113Z | 2024-10-25T12:24:28.730Z |
5314055 | 5314055 | 20241016112338_lJ22E | USL00N | 2024-10-17T12:01:37.980Z | 2024-10-25T12:24:28.598Z |
5312064 | 5312064 | 20241015023953_uAGJ0 | USL00N | 2024-10-16T12:09:55.934Z | 2024-10-23T12:24:47.637Z |
5309512 | 5309512 | 20241014123249_TZa3Q | USL00N | 2024-10-16T12:05:33.491Z | 2024-10-23T12:24:26.010Z |
5309398 | 5309398 | 20241014120938_inKx9 | USL00N | 2024-10-16T12:05:24.591Z | 2024-10-23T12:24:25.274Z |
5309383 | 5309383 | 20241014120704_zeoFu | USL00N | 2024-10-16T12:05:22.249Z | 2024-10-23T12:24:25.195Z |
5309330 | 5309330 | 20241014115534_JH1qd | USL00N | 2024-10-16T12:05:07.760Z | 2024-10-23T12:24:25.052Z |
5308997 | 5308997 | 20241014111337_32PW0 | USL00N | 2024-10-16T12:04:42.189Z | 2024-10-23T12:24:21.956Z |
5308981 | 5308981 | 20241014111058_dFmb2 | USL00N | 2024-10-16T12:04:39.389Z | 2024-10-23T12:24:21.862Z |
5308950 | 5308950 | 20241014110510_qfo6n | USL00N | 2024-10-16T12:04:32.073Z | 2024-10-23T12:24:21.605Z |
5308909 | 5308909 | 20241014105934_H9NUe | USL00N | 2024-10-16T12:04:25.561Z | 2024-10-23T12:24:21.350Z |
5308602 | 5308602 | 20241014101631_S4VhX | USL00N | 2024-10-16T12:04:02.265Z | 2024-10-23T12:24:18.536Z |
5308501 | 5308501 | 20241014100340_qW08c | USL00N | 2024-10-16T12:03:46.451Z | 2024-10-23T12:24:16.940Z |
5308481 | 5308481 | 20241014095911_3tMAu | USL00N | 2024-10-16T12:03:43.060Z | 2024-10-23T12:24:16.667Z |
5307819 | 5307819 | 20241015110832_FdjvW | USL00N | 2024-10-16T12:02:18.666Z | 2024-10-24T12:27:46.796Z |
5305038 | 5305038 | 20241013115637_Fo8RS | USL00N | 2024-10-15T12:03:17.618Z | 2024-10-22T12:24:22.618Z |
5304991 | 5304991 | 20241013114518_pUaMl | USL00N | 2024-10-15T12:03:13.133Z | 2024-10-22T12:24:22.292Z |
5304885 | 5304885 | 20241013112548_2oT5c | USL00N | 2024-10-15T12:03:01.255Z | 2024-10-22T12:24:21.687Z |
5297246 | 5297246 | 20241012122441_td72z | USL00N | 2024-10-14T12:08:00.487Z | 2024-10-21T12:23:16.261Z |
5297236 | 5297236 | 20241012121936_Uoghf | USL00N | 2024-10-14T12:07:59.244Z | 2024-10-21T12:23:15.839Z |
5297138 | 5297138 | 20241012115949_u2FMu | USL00N | 2024-10-14T12:07:39.156Z | 2024-10-21T12:23:13.661Z |
5297109 | 5297109 | 20241012115531_CZS1C | USL00N | 2024-10-14T12:07:30.605Z | 2024-10-21T12:23:13.008Z |
5297064 | 5297064 | 20241012114718_cJ3B0 | USL00N | 2024-10-14T12:07:24.073Z | 2024-10-21T12:23:12.784Z |
5297053 | 5297053 | 20241012114436_bY2Jg | USL00N | 2024-10-14T12:07:22.811Z | 2024-10-21T12:23:12.703Z |
5296764 | 5296764 | 20241012110523_dYFjV | USL00N | 2024-10-14T12:06:51.176Z | 2024-10-21T12:23:08.917Z |
5296668 | 5296668 | 20241012104924_WfGJi | USL00N | 2024-10-14T12:06:33.559Z | 2024-10-21T12:23:07.409Z |
5296635 | 5296635 | 20241012104612_mpWyz | USL00N | 2024-10-14T12:06:30.672Z | 2024-10-21T12:23:06.582Z |
5296516 | 5296516 | 20241012102859_Z3K7U | USL00N | 2024-10-14T12:06:18.544Z | 2024-10-21T12:23:04.732Z |
5296460 | 5296460 | 20241012102458_cyp0Q | USL00N | 2024-10-14T12:06:13.997Z | 2024-10-21T12:23:04.345Z |
5296443 | 5296443 | 20241012102237_NOnTv | USL00N | 2024-10-14T12:06:12.282Z | 2024-10-21T12:23:03.786Z |
5296339 | 5296339 | 20241012095815_Cl2nE | USL00N | 2024-10-14T12:05:47.605Z | 2024-10-21T12:23:02.889Z |
5296318 | 5296318 | 20241012095232_L0yIU | USL00N | 2024-10-14T12:05:43.132Z | 2024-10-21T12:23:02.733Z |
5295782 | 5295782 | 20241013090255_KlsXM | USL00N | 2024-10-14T12:03:29.787Z | 2024-10-22T12:24:14.997Z |
5295466 | 5295466 | 20241013075856_F73y7 | USL00N | 2024-10-14T12:02:28.917Z | 2024-10-22T12:24:12.296Z |
5295409 | 5295409 | 20241013074542_RiWmL | USL00N | 2024-10-14T12:02:18.412Z | 2024-10-22T12:24:11.830Z |
5294322 | 5294322 | 20241012034219_KWMF6 | USL00N | 2024-10-13T12:18:30.331Z | 2024-10-20T12:25:10.197Z |
5293789 | 5293789 | 20241012021718_mKZjT | USL00N | 2024-10-13T12:17:52.095Z | 2024-10-20T12:25:04.104Z |
5287361 | 5287361 | 20241011112741_2vZLO | USL00N | 2024-10-13T12:07:05.554Z | 2024-10-20T12:23:48.892Z |
5287103 | 5287103 | 20241011105951_c4yZf | USL00N | 2024-10-13T12:06:22.375Z | 2024-10-20T12:23:46.175Z |
5286528 | 5286528 | 20241012084921_9uq9f | USL00N | 2024-10-13T12:02:40.583Z | 2024-10-21T12:22:55.086Z |
5286490 | 5286490 | 20241012084240_rPeIX | USL00N | 2024-10-13T12:02:35.513Z | 2024-10-21T12:22:54.548Z |
5286479 | 5286479 | 20241012084221_awuos | USL00N | 2024-10-13T12:02:34.351Z | 2024-10-21T12:22:54.499Z |
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);