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 |
---|---|---|---|---|---|
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 |
5286342 | 5286342 | 20241012082241_XDrZA | USL00N | 2024-10-13T12:02:13.609Z | 2024-10-21T12:22:53.001Z |
5286338 | 5286338 | 20241012082131_yjC44 | USL00N | 2024-10-13T12:02:12.146Z | 2024-10-21T12:22:52.991Z |
5286133 | 5286133 | 20241012074735_lnakR | USL00N | 2024-10-13T12:01:39.454Z | 2024-10-21T12:22:49.560Z |
5285978 | 5285978 | 20241012070453_DQpgj | USL00N | 2024-10-13T12:01:09.427Z | 2024-10-21T12:22:47.358Z |
5285969 | 5285969 | 20241012070123_3623z | USL00N | 2024-10-13T12:01:08.391Z | 2024-10-21T12:22:47.313Z |
5285914 | 5285914 | 20241012063229_0TVb5 | USL00N | 2024-10-13T12:00:59.960Z | 2024-10-21T12:22:46.311Z |
5278283 | 5278283 | 20241011100407_FPtb5 | USL00N | 2024-10-12T12:05:41.493Z | 2024-10-20T12:23:39.720Z |
5278201 | 5278201 | 20241011095438_OdJVz | USL00N | 2024-10-12T12:05:28.317Z | 2024-10-20T12:23:38.920Z |
5278104 | 5278104 | 20241011094157_k6iCd | USL00N | 2024-10-12T12:05:13.625Z | 2024-10-20T12:23:37.505Z |
5277602 | 5277602 | 20241011082406_QhZ84 | USL00N | 2024-10-12T12:03:50.021Z | 2024-10-20T12:23:30.149Z |
5277517 | 5277517 | 20241011080604_tAkyS | USL00N | 2024-10-12T12:03:38.571Z | 2024-10-20T12:23:29.069Z |
5277500 | 5277500 | 20241011080321_Jhocc | USL00N | 2024-10-12T12:03:36.680Z | 2024-10-20T12:23:28.777Z |
5277279 | 5277279 | 20241011071319_uwlc1 | USL00N | 2024-10-12T12:02:59.624Z | 2024-10-20T12:23:24.455Z |
5277054 | 5277054 | 20241011060125_8i20u | USL00N | 2024-10-12T12:02:23.261Z | 2024-10-20T12:23:18.877Z |
5276924 | 5276924 | 20241011052401_ZpfWO | USL00N | 2024-10-12T12:02:04.081Z | 2024-10-20T12:23:15.560Z |
5271704 | 5271704 | 20241010122850_HsxnH | USL00N | 2024-10-11T12:07:26.678Z | 2024-10-19T12:27:07.359Z |
5271466 | 5271466 | 20241010120158_ue9Ex | USL00N | 2024-10-11T12:07:04.690Z | 2024-10-19T12:27:05.768Z |
5271457 | 5271457 | 20241010120115_3xN6Q | USL00N | 2024-10-11T12:07:02.528Z | 2024-10-19T12:27:05.741Z |
5271443 | 5271443 | 20241010120002_3VeZL | USL00N | 2024-10-11T12:06:55.410Z | 2024-10-19T12:27:05.616Z |
5271364 | 5271364 | 20241010114851_jSKye | USL00N | 2024-10-11T12:06:38.319Z | 2024-10-19T12:27:04.974Z |
5271320 | 5271320 | 20241010114129_bGx0d | USL00N | 2024-10-11T12:06:33.075Z | 2024-10-19T12:27:04.632Z |
5271252 | 5271252 | 20241010113309_4lGDq | USL00N | 2024-10-11T12:06:27.278Z | 2024-10-19T12:27:04.286Z |
5271180 | 5271180 | 20241010112256_YZlxr | USL00N | 2024-10-11T12:06:20.965Z | 2024-10-19T12:27:03.637Z |
5271059 | 5271059 | 20241010110650_Xtzsm | USL00N | 2024-10-11T12:05:57.497Z | 2024-10-19T12:27:02.376Z |
5270474 | 5270474 | 20241010094654_NPKwM | USL00N | 2024-10-11T12:04:37.628Z | 2024-10-19T12:26:59.505Z |
5270409 | 5270409 | 20241010093759_JEUnK | USL00N | 2024-10-11T12:04:22.088Z | 2024-10-19T12:26:59.186Z |
5270163 | 5270163 | 20241010084834_cQVFM | USL00N | 2024-10-11T12:03:48.754Z | 2024-10-19T12:26:58.084Z |
5270056 | 5270056 | 20241010082438_QrSFI | USL00N | 2024-10-11T12:03:31.692Z | 2024-10-19T12:26:57.095Z |
5270014 | 5270014 | 20241010081749_SQ8k9 | USL00N | 2024-10-11T12:03:26.287Z | 2024-10-19T12:26:56.815Z |
5269928 | 5269928 | 20241010075648_BDtuC | USL00N | 2024-10-11T12:03:14.928Z | 2024-10-19T12:26:55.487Z |
5269875 | 5269875 | 20241010074532_6thCg | USL00N | 2024-10-11T12:03:04.668Z | 2024-10-19T12:26:55.040Z |
5269761 | 5269761 | 20241010071233_FfdrS | USL00N | 2024-10-11T12:02:40.863Z | 2024-10-19T12:26:53.845Z |
5269659 | 5269659 | 20241010064056_PQPaw | USL00N | 2024-10-11T12:02:26.461Z | 2024-10-19T12:26:53.053Z |
5265396 | 5265396 | 20241009115705_SlEU3 | USL00N | 2024-10-10T12:07:00.682Z | 2024-10-18T12:21:51.584Z |
5264433 | 5264433 | 20241009084551_U6L2M | USL00N | 2024-10-10T12:04:03.702Z | 2024-10-18T12:21:43.826Z |
5264132 | 5264132 | 20241009073958_RO3q3 | USL00N | 2024-10-10T12:03:11.979Z | 2024-10-18T12:21:41.518Z |
5263815 | 5263815 | 20241009061655_Yj9Z8 | USL00N | 2024-10-10T12:02:18.937Z | 2024-10-18T12:21:38.402Z |
5263126 | 5263126 | 20241008031008_192FG | USL00N | 2024-10-09T12:16:39.516Z | 2024-10-16T12:21:21.658Z |
5263060 | 5263060 | 20241008030211_7eZoA | USL00N | 2024-10-09T12:16:37.327Z | 2024-10-16T12:21:21.331Z |
5263056 | 5263056 | 20241008030201_uHLqM | USL00N | 2024-10-09T12:16:37.273Z | 2024-10-16T12:21:21.290Z |
5258103 | 5258103 | 20241008123039_fCWB9 | USL00N | 2024-10-09T12:06:26.961Z | 2024-10-17T12:20:02.702Z |
5258054 | 5258054 | 20241008120855_1yAI6 | USL00N | 2024-10-09T12:06:18.176Z | 2024-10-17T12:20:02.543Z |
5258022 | 5258022 | 20241008115932_y8rvC | USL00N | 2024-10-09T12:06:14.652Z | 2024-10-17T12:20:02.339Z |
5257909 | 5257909 | 20241008113800_013uq | USL00N | 2024-10-09T12:06:00.781Z | 2024-10-17T12:20:01.889Z |
5257756 | 5257756 | 20241008110747_rqFpu | USL00N | 2024-10-09T12:05:46.553Z | 2024-10-17T12:20:01.322Z |
5257550 | 5257550 | 20241008101442_2C8hi | USL00N | 2024-10-09T12:05:19.417Z | 2024-10-17T12:20:00.631Z |
5256399 | 5256399 | 20241008065215_lu2Ai | USL00N | 2024-10-09T12:02:55.478Z | 2024-10-17T12:19:56.287Z |
5256141 | 5256141 | 20241008061110_LXANa | USL00N | 2024-10-09T12:02:27.735Z | 2024-10-17T12:19:55.577Z |
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);