participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00P" 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 |
---|---|---|---|---|---|
5535581 | 5535581 | 20241112125400_GR6Jd | USL00P | 2024-11-14T14:08:08.414Z | 2024-11-21T14:25:50.224Z |
5535448 | 5535448 | 20241112123122_wPOzs | USL00P | 2024-11-14T14:07:57.194Z | 2024-11-21T14:25:48.439Z |
5535424 | 5535424 | 20241112122509_fVuIr | USL00P | 2024-11-14T14:07:55.160Z | 2024-11-21T14:25:47.989Z |
5535411 | 5535411 | 20241112122449_1V9FR | USL00P | 2024-11-14T14:07:54.470Z | 2024-11-21T14:25:47.785Z |
5535404 | 5535404 | 20241112122355_OXzvK | USL00P | 2024-11-14T14:07:54.260Z | 2024-11-21T14:25:47.760Z |
5535339 | 5535339 | 20241112121456_Dw7S4 | USL00P | 2024-11-14T14:07:49.802Z | 2024-11-21T14:25:46.519Z |
5535333 | 5535333 | 20241112121204_VEnN6 | USL00P | 2024-11-14T14:07:49.074Z | 2024-11-21T14:25:46.416Z |
5535204 | 5535204 | 20241112115456_m3bcP | USL00P | 2024-11-14T14:07:29.778Z | 2024-11-21T14:25:45.026Z |
5535149 | 5535149 | 20241112114430_Z4FQ5 | USL00P | 2024-11-14T14:07:19.132Z | 2024-11-21T14:25:44.285Z |
5535128 | 5535128 | 20241112114115_uNvmz | USL00P | 2024-11-14T14:07:17.088Z | 2024-11-21T14:25:44.085Z |
5535126 | 5535126 | 20241112114046_aLIoW | USL00P | 2024-11-14T14:07:16.722Z | 2024-11-21T14:25:44.045Z |
5535119 | 5535119 | 20241112113955_K8iol | USL00P | 2024-11-14T14:07:16.334Z | 2024-11-21T14:25:43.966Z |
5535085 | 5535085 | 20241112113440_PlGLI | USL00P | 2024-11-14T14:07:12.601Z | 2024-11-21T14:25:43.835Z |
5535072 | 5535072 | 20241112113154_twR5o | USL00P | 2024-11-14T14:07:10.185Z | 2024-11-21T14:25:43.584Z |
5535047 | 5535047 | 20241112112825_ZHprs | USL00P | 2024-11-14T14:07:08.508Z | 2024-11-21T14:25:43.370Z |
5534902 | 5534902 | 20241112110657_Vjuue | USL00P | 2024-11-14T14:06:58.070Z | 2024-11-21T14:25:41.498Z |
5532731 | 5532731 | 20241112055606_5PrPB | USL00P | 2024-11-13T14:17:12.766Z | 2024-11-20T14:26:25.904Z |
5532581 | 5532581 | 20241112054016_UOqON | USL00P | 2024-11-13T14:17:01.256Z | 2024-11-20T14:26:24.890Z |
5532469 | 5532469 | 20241112052739_12HU8 | USL00P | 2024-11-13T14:16:51.346Z | 2024-11-20T14:26:23.823Z |
5532447 | 5532447 | 20241112052441_qVStT | USL00P | 2024-11-13T14:16:48.962Z | 2024-11-20T14:26:23.496Z |
5527059 | 5527059 | 20241112105457_L2D3v | USL00P | 2024-11-13T14:04:57.083Z | 2024-11-21T14:25:40.827Z |
5526995 | 5526995 | 20241112104309_b2CXQ | USL00P | 2024-11-13T14:04:48.710Z | 2024-11-21T14:25:40.189Z |
5526932 | 5526932 | 20241112103339_d2s9Q | USL00P | 2024-11-13T14:04:37.741Z | 2024-11-21T14:25:39.801Z |
5526869 | 5526869 | 20241112102530_QLDhK | USL00P | 2024-11-13T14:04:24.890Z | 2024-11-21T14:25:39.363Z |
5526819 | 5526819 | 20241112102002_5JUwi | USL00P | 2024-11-13T14:04:14.735Z | 2024-11-21T14:25:38.833Z |
5526648 | 5526648 | 20241112095733_ytrbU | USL00P | 2024-11-13T14:03:42.795Z | 2024-11-21T14:25:36.887Z |
5526640 | 5526640 | 20241112095708_4xtD1 | USL00P | 2024-11-13T14:03:41.474Z | 2024-11-21T14:25:36.878Z |
5526627 | 5526627 | 20241112095620_nRPye | USL00P | 2024-11-13T14:03:39.761Z | 2024-11-21T14:25:36.866Z |
5526616 | 5526616 | 20241112095454_RwTzS | USL00P | 2024-11-13T14:03:38.615Z | 2024-11-21T14:25:36.831Z |
5526488 | 5526488 | 20241112093254_mAyd2 | USL00P | 2024-11-13T14:03:18.723Z | 2024-11-21T14:25:35.892Z |
5526458 | 5526458 | 20241112092321_rdT2N | USL00P | 2024-11-13T14:03:12.512Z | 2024-11-21T14:25:35.649Z |
5526449 | 5526449 | 20241112092106_wpKGi | USL00P | 2024-11-13T14:03:05.799Z | 2024-11-21T14:25:35.511Z |
5526422 | 5526422 | 20241112091734_3zlCq | USL00P | 2024-11-13T14:02:58.254Z | 2024-11-21T14:25:34.815Z |
5526387 | 5526387 | 20241112090930_sCgZP | USL00P | 2024-11-13T14:02:50.892Z | 2024-11-21T14:25:34.665Z |
5526335 | 5526335 | 20241112090115_ykO7D | USL00P | 2024-11-13T14:02:44.085Z | 2024-11-21T14:25:34.104Z |
5526333 | 5526333 | 20241112090050_lZ6wa | USL00P | 2024-11-13T14:02:43.634Z | 2024-11-21T14:25:34.093Z |
5526275 | 5526275 | 20241112085004_0U8T6 | USL00P | 2024-11-13T14:02:34.075Z | 2024-11-21T14:25:33.597Z |
5526210 | 5526210 | 20241112083338_0hN2q | USL00P | 2024-11-13T14:02:13.913Z | 2024-11-21T14:25:31.845Z |
5526175 | 5526175 | 20241112082649_YdaRA | USL00P | 2024-11-13T14:02:05.374Z | 2024-11-21T14:25:30.893Z |
5526168 | 5526168 | 20241112082548_2xZ4D | USL00P | 2024-11-13T14:02:04.615Z | 2024-11-21T14:25:30.850Z |
5526145 | 5526145 | 20241112081621_CWX2m | USL00P | 2024-11-13T14:02:00.621Z | 2024-11-21T14:25:30.691Z |
5526123 | 5526123 | 20241112081008_OBth6 | USL00P | 2024-11-13T14:01:57.752Z | 2024-11-21T14:25:30.584Z |
5526085 | 5526085 | 20241112080140_0bArr | USL00P | 2024-11-13T14:01:52.590Z | 2024-11-21T14:25:30.398Z |
5526083 | 5526083 | 20241112080139_ZM72E | USL00P | 2024-11-13T14:01:52.047Z | 2024-11-21T14:25:30.392Z |
5526062 | 5526062 | 20241112075830_do2oW | USL00P | 2024-11-13T14:01:45.050Z | 2024-11-21T14:25:30.329Z |
5526059 | 5526059 | 20241112075648_xlgZ5 | USL00P | 2024-11-13T14:01:44.411Z | 2024-11-21T14:25:30.275Z |
5525971 | 5525971 | 20241112073411_Hev95 | USL00P | 2024-11-13T14:01:20.766Z | 2024-11-21T14:25:29.241Z |
5525952 | 5525952 | 20241112073110_aoIXI | USL00P | 2024-11-13T14:01:18.455Z | 2024-11-21T14:25:29.204Z |
5525929 | 5525929 | 20241112072142_wDPsT | USL00P | 2024-11-13T14:01:14.994Z | 2024-11-21T14:25:29.053Z |
5525841 | 5525841 | 20241112070045_BLnkB | USL00P | 2024-11-13T14:00:54.343Z | 2024-11-21T14:25:28.122Z |
5525771 | 5525771 | 20241112063438_SePYV | USL00P | 2024-11-13T14:00:41.925Z | 2024-11-21T14:25:26.415Z |
5318276 | 5318276 | 20241017020820_qsc5r | USL00P | 2024-10-18T12:03:17.501Z | 2024-10-25T12:24:34.387Z |
5317681 | 5317681 | 20241017082851_G51Vj | USL00P | 2024-10-18T12:00:30.208Z | 2024-10-26T12:27:50.827Z |
5317046 | 5317046 | 20241016024259_8xT70 | USL00P | 2024-10-17T12:07:41.857Z | 2024-10-24T12:27:58.684Z |
5317030 | 5317030 | 20241016023919_PaX8i | USL00P | 2024-10-17T12:07:38.676Z | 2024-10-24T12:27:58.613Z |
5315384 | 5315384 | 20241015123818_UxsPf | USL00P | 2024-10-17T12:04:34.238Z | 2024-10-24T12:27:52.721Z |
5315355 | 5315355 | 20241015122544_hTUcf | USL00P | 2024-10-17T12:04:29.136Z | 2024-10-24T12:27:52.192Z |
5315303 | 5315303 | 20241015121348_phSG9 | USL00P | 2024-10-17T12:04:24.991Z | 2024-10-24T12:27:51.892Z |
5315278 | 5315278 | 20241015121158_vowYr | USL00P | 2024-10-17T12:04:23.812Z | 2024-10-24T12:27:51.787Z |
5315202 | 5315202 | 20241015120058_DqIK2 | USL00P | 2024-10-17T12:04:18.404Z | 2024-10-24T12:27:51.076Z |
5315175 | 5315175 | 20241015115448_Mivd5 | USL00P | 2024-10-17T12:04:16.516Z | 2024-10-24T12:27:50.686Z |
5315115 | 5315115 | 20241015114517_gdhZ1 | USL00P | 2024-10-17T12:04:13.064Z | 2024-10-24T12:27:49.921Z |
5315103 | 5315103 | 20241015114442_FJeaa | USL00P | 2024-10-17T12:04:12.647Z | 2024-10-24T12:27:49.778Z |
5315016 | 5315016 | 20241015112919_yeeh0 | USL00P | 2024-10-17T12:04:06.512Z | 2024-10-24T12:27:49.092Z |
5314405 | 5314405 | 20241016124448_7ZyQY | USL00P | 2024-10-17T12:02:17.764Z | 2024-10-25T12:24:30.129Z |
5314400 | 5314400 | 20241016124348_YRTWf | USL00P | 2024-10-17T12:02:15.587Z | 2024-10-25T12:24:30.104Z |
5314397 | 5314397 | 20241016124332_6TE75 | USL00P | 2024-10-17T12:02:15.167Z | 2024-10-25T12:24:30.084Z |
5314371 | 5314371 | 20241016123353_f18dt | USL00P | 2024-10-17T12:02:12.347Z | 2024-10-25T12:24:30.026Z |
5314366 | 5314366 | 20241016123313_OlkTB | USL00P | 2024-10-17T12:02:11.948Z | 2024-10-25T12:24:30.022Z |
5314323 | 5314323 | 20241016122517_7tLml | USL00P | 2024-10-17T12:02:05.127Z | 2024-10-25T12:24:29.677Z |
5314317 | 5314317 | 20241016122316_C1wRh | USL00P | 2024-10-17T12:02:04.444Z | 2024-10-25T12:24:29.607Z |
5314270 | 5314270 | 20241016120830_hmwVy | USL00P | 2024-10-17T12:01:55.512Z | 2024-10-25T12:24:29.380Z |
5314237 | 5314237 | 20241016120358_ORIQZ | USL00P | 2024-10-17T12:01:53.367Z | 2024-10-25T12:24:29.245Z |
5314233 | 5314233 | 20241016120311_ODblK | USL00P | 2024-10-17T12:01:53.137Z | 2024-10-25T12:24:29.241Z |
5314196 | 5314196 | 20241016115725_D9nwC | USL00P | 2024-10-17T12:01:50.133Z | 2024-10-25T12:24:29.006Z |
5314186 | 5314186 | 20241016115248_1Rcc1 | USL00P | 2024-10-17T12:01:49.185Z | 2024-10-25T12:24:28.975Z |
5314102 | 5314102 | 20241016113524_22bvO | USL00P | 2024-10-17T12:01:41.862Z | 2024-10-25T12:24:28.746Z |
5314079 | 5314079 | 20241016112929_95aKL | USL00P | 2024-10-17T12:01:40.286Z | 2024-10-25T12:24:28.673Z |
5314056 | 5314056 | 20241016112338_lJ22E | USL00P | 2024-10-17T12:01:37.990Z | 2024-10-25T12:24:28.598Z |
5313993 | 5313993 | 20241016105943_ZZUIs | USL00P | 2024-10-17T12:01:32.353Z | 2024-10-25T12:24:28.297Z |
5313987 | 5313987 | 20241016105844_aCn9B | USL00P | 2024-10-17T12:01:31.707Z | 2024-10-25T12:24:28.293Z |
5313931 | 5313931 | 20241016104605_mf0KC | USL00P | 2024-10-17T12:01:20.683Z | 2024-10-25T12:24:27.919Z |
5313919 | 5313919 | 20241016104226_CBRdL | USL00P | 2024-10-17T12:01:18.678Z | 2024-10-25T12:24:27.844Z |
5313915 | 5313915 | 20241016104215_e3VcK | USL00P | 2024-10-17T12:01:17.637Z | 2024-10-25T12:24:27.819Z |
5313891 | 5313891 | 20241016103742_UxzFh | USL00P | 2024-10-17T12:01:15.412Z | 2024-10-25T12:24:27.728Z |
5313861 | 5313861 | 20241016103357_QWHx0 | USL00P | 2024-10-17T12:01:12.116Z | 2024-10-25T12:24:27.443Z |
5313837 | 5313837 | 20241016102805_FZmnM | USL00P | 2024-10-17T12:01:06.985Z | 2024-10-25T12:24:27.208Z |
5313818 | 5313818 | 20241016102127_09w2Z | USL00P | 2024-10-17T12:01:04.621Z | 2024-10-25T12:24:27.165Z |
5313759 | 5313759 | 20241016100113_89Kb2 | USL00P | 2024-10-17T12:00:58.304Z | 2024-10-25T12:24:26.962Z |
5313688 | 5313688 | 20241016093354_Bqte7 | USL00P | 2024-10-17T12:00:50.657Z | 2024-10-25T12:24:26.579Z |
5313663 | 5313663 | 20241016092654_b9Eh2 | USL00P | 2024-10-17T12:00:47.738Z | 2024-10-25T12:24:26.366Z |
5313641 | 5313641 | 20241016091540_GTask | USL00P | 2024-10-17T12:00:43.892Z | 2024-10-25T12:24:26.271Z |
5313524 | 5313524 | 20241016081833_UnlZc | USL00P | 2024-10-17T12:00:27.760Z | 2024-10-25T12:24:25.522Z |
5312721 | 5312721 | 20241015043830_Zzw2I | USL00P | 2024-10-16T12:10:56.228Z | 2024-10-23T12:24:53.000Z |
5312140 | 5312140 | 20241015024953_dne0y | USL00P | 2024-10-16T12:10:03.102Z | 2024-10-23T12:24:48.757Z |
5309517 | 5309517 | 20241014123442_2boyZ | USL00P | 2024-10-16T12:05:34.047Z | 2024-10-23T12:24:26.092Z |
5309502 | 5309502 | 20241014122834_jl78A | USL00P | 2024-10-16T12:05:33.187Z | 2024-10-23T12:24:25.986Z |
5309470 | 5309470 | 20241014122024_PK7PJ | USL00P | 2024-10-16T12:05:30.255Z | 2024-10-23T12:24:25.689Z |
5309457 | 5309457 | 20241014121935_BVAux | USL00P | 2024-10-16T12:05:29.503Z | 2024-10-23T12:24:25.493Z |
5309414 | 5309414 | 20241014121044_yIOSz | USL00P | 2024-10-16T12:05:26.737Z | 2024-10-23T12:24:25.342Z |
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);