participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,048 rows where station_code = "KR0003" 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 |
---|---|---|---|---|---|
4524686 | 4524686 | 20240630182933_mBhnI | KR0003 | 2024-07-01T12:00:24.738Z | 2024-07-09T12:07:59.824Z |
4524646 | 4524646 | 20240630172702_2UvGS | KR0003 | 2024-07-01T12:00:19.845Z | 2024-07-09T12:07:59.630Z |
4517633 | 4517633 | 20240628143236_9On8A | KR0003 | 2024-06-30T12:00:45.810Z | 2024-07-07T12:13:41.361Z |
4510530 | 4510530 | 20240627121137_nxV9v | KR0003 | 2024-06-28T12:04:45.579Z | 2024-07-05T12:11:33.612Z |
4506987 | 4506987 | 20240627153546_Mh1z5 | KR0003 | 2024-06-28T12:00:57.613Z | 2024-07-06T12:16:11.735Z |
4506873 | 4506873 | 20240627150616_psGay | KR0003 | 2024-06-28T12:00:49.528Z | 2024-07-06T12:16:11.234Z |
4506581 | 4506581 | 20240627134319_sKUfe | KR0003 | 2024-06-28T12:00:27.124Z | 2024-07-06T12:16:09.426Z |
4503280 | 4503280 | 20240626144443_6aXq0 | KR0003 | 2024-06-27T12:01:25.381Z | 2024-07-05T12:11:21.511Z |
4491513 | 4491513 | 20240620183826_CwbDM | KR0003 | 2024-06-22T12:04:22.593Z | 2024-06-29T12:13:29.455Z |
4491479 | 4491479 | 20240620183258_7ACCG | KR0003 | 2024-06-22T12:04:20.293Z | 2024-06-29T12:13:29.283Z |
4491315 | 4491315 | 20240620180610_Ys5Gr | KR0003 | 2024-06-22T12:04:05.812Z | 2024-06-29T12:13:28.716Z |
4487691 | 4487691 | 20240619183003_HkYpR | KR0003 | 2024-06-21T12:04:14.778Z | 2024-06-28T12:09:34.281Z |
4487678 | 4487678 | 20240619182913_zH9Ks | KR0003 | 2024-06-21T12:04:14.342Z | 2024-06-28T12:09:34.249Z |
4487570 | 4487570 | 20240619181457_v2DMN | KR0003 | 2024-06-21T12:04:09.265Z | 2024-06-28T12:09:33.992Z |
4483813 | 4483813 | 20240618180114_DwKJn | KR0003 | 2024-06-20T12:04:38.612Z | 2024-06-27T12:11:25.338Z |
4483512 | 4483512 | 20240618171741_S6d29 | KR0003 | 2024-06-20T12:04:19.256Z | 2024-06-27T12:11:23.184Z |
4483483 | 4483483 | 20240618171501_N3BeO | KR0003 | 2024-06-20T12:04:14.937Z | 2024-06-27T12:11:22.890Z |
4483316 | 4483316 | 20240618165654_F0pc1 | KR0003 | 2024-06-20T12:03:58.175Z | 2024-06-27T12:11:21.516Z |
4479870 | 4479870 | 20240616185213_sN4s2 | KR0003 | 2024-06-19T12:09:55.429Z | 2024-06-24T12:11:48.452Z |
4479661 | 4479661 | 20240616181035_LHZDI | KR0003 | 2024-06-19T12:09:42.457Z | 2024-06-24T12:11:43.395Z |
4479604 | 4479604 | 20240616180133_dGHOb | KR0003 | 2024-06-19T12:09:38.077Z | 2024-06-24T12:11:42.667Z |
4477815 | 4477815 | 20240617184738_P2Ob7 | KR0003 | 2024-06-19T12:06:01.829Z | 2024-06-26T12:14:36.697Z |
4477777 | 4477777 | 20240617183841_5TtLO | KR0003 | 2024-06-19T12:05:59.783Z | 2024-06-26T12:14:35.902Z |
4477758 | 4477758 | 20240617183632_T27Qn | KR0003 | 2024-06-19T12:05:58.377Z | 2024-06-26T12:14:35.806Z |
4477686 | 4477686 | 20240617182645_p7Yuj | KR0003 | 2024-06-19T12:05:49.045Z | 2024-06-26T12:14:35.448Z |
4477556 | 4477556 | 20240617180807_FUfwg | KR0003 | 2024-06-19T12:05:30.633Z | 2024-06-26T12:14:34.688Z |
4477499 | 4477499 | 20240617180214_ECJd9 | KR0003 | 2024-06-19T12:05:27.680Z | 2024-06-26T12:14:33.940Z |
4477420 | 4477420 | 20240617175030_98vJV | KR0003 | 2024-06-19T12:05:21.174Z | 2024-06-26T12:14:33.472Z |
4477338 | 4477338 | 20240617173545_3JA1M | KR0003 | 2024-06-19T12:05:15.569Z | 2024-06-26T12:14:32.595Z |
4477252 | 4477252 | 20240617171833_BPWrx | KR0003 | 2024-06-19T12:05:09.485Z | 2024-06-26T12:14:32.080Z |
4477161 | 4477161 | 20240617170610_YkTmU | KR0003 | 2024-06-19T12:05:03.602Z | 2024-06-26T12:14:31.424Z |
4474197 | 4474197 | 20240616173843_xFjTD | KR0003 | 2024-06-18T12:04:57.124Z | 2024-06-24T12:11:40.364Z |
4474006 | 4474006 | 20240616165755_suBJC | KR0003 | 2024-06-18T12:04:43.976Z | 2024-06-24T12:11:37.221Z |
4473721 | 4473721 | 20240616153002_WC4rC | KR0003 | 2024-06-18T12:04:21.951Z | 2024-06-24T12:11:32.174Z |
4473406 | 4473406 | 20240616130149_3DXf3 | KR0003 | 2024-06-18T12:03:53.507Z | 2024-06-24T12:11:27.352Z |
4470879 | 4470879 | 20240615183536_E3bFQ | KR0003 | 2024-06-17T12:07:50.477Z | 2024-06-23T12:12:33.844Z |
4466504 | 4466504 | 20240614173434_l8paY | KR0003 | 2024-06-16T12:07:22.257Z | 2024-06-22T12:16:35.662Z |
4466351 | 4466351 | 20240614170203_FrdTz | KR0003 | 2024-06-16T12:07:02.387Z | 2024-06-22T12:16:35.149Z |
4462736 | 4462736 | 20240613173656_sWWJR | KR0003 | 2024-06-15T12:09:07.168Z | 2024-06-21T12:11:47.384Z |
4462657 | 4462657 | 20240613172619_m6Erp | KR0003 | 2024-06-15T12:09:02.434Z | 2024-06-21T12:11:47.276Z |
4462485 | 4462485 | 20240613170245_N39BZ | KR0003 | 2024-06-15T12:08:44.045Z | 2024-06-21T12:11:46.996Z |
4462311 | 4462311 | 20240613163242_lhhJh | KR0003 | 2024-06-15T12:08:26.389Z | 2024-06-21T12:11:46.724Z |
4462185 | 4462185 | 20240613161419_Mtdzb | KR0003 | 2024-06-15T12:08:12.209Z | 2024-06-21T12:11:46.415Z |
4462153 | 4462153 | 20240613160848_x87c3 | KR0003 | 2024-06-15T12:08:10.778Z | 2024-06-21T12:11:46.400Z |
4462064 | 4462064 | 20240613154334_QEoyO | KR0003 | 2024-06-15T12:08:04.867Z | 2024-06-21T12:11:46.221Z |
4461699 | 4461699 | 20240613133243_rljN8 | KR0003 | 2024-06-15T12:07:25.659Z | 2024-06-21T12:11:45.085Z |
4458668 | 4458668 | 20240612145237_8pZoj | KR0003 | 2024-06-14T12:05:01.050Z | 2024-06-20T12:12:04.008Z |
4458595 | 4458595 | 20240612144114_8x5WO | KR0003 | 2024-06-14T12:04:58.668Z | 2024-06-20T12:12:03.934Z |
4454970 | 4454970 | 20240611184314_pHOPf | KR0003 | 2024-06-13T12:06:21.810Z | 2024-06-19T12:13:49.183Z |
4454819 | 4454819 | 20240611182526_mATF2 | KR0003 | 2024-06-13T12:06:18.919Z | 2024-06-19T12:13:48.612Z |
4454515 | 4454515 | 20240611175039_ISdcE | KR0003 | 2024-06-13T12:06:12.478Z | 2024-06-19T12:13:48.261Z |
4454489 | 4454489 | 20240611174539_2OTJR | KR0003 | 2024-06-13T12:06:11.528Z | 2024-06-19T12:13:47.891Z |
4453708 | 4453708 | 20240611161101_TDTe4 | KR0003 | 2024-06-13T12:05:47.931Z | 2024-06-19T12:13:47.156Z |
4452378 | 4452378 | 20240611130635_q2ICj | KR0003 | 2024-06-13T12:05:04.853Z | 2024-06-19T12:13:45.088Z |
4448447 | 4448447 | 20240610174059_qAtDq | KR0003 | 2024-06-12T12:06:23.832Z | 2024-06-18T12:11:17.674Z |
4447472 | 4447472 | 20240610145422_JlOWH | KR0003 | 2024-06-12T12:05:30.287Z | 2024-06-18T12:11:14.903Z |
4444169 | 4444169 | 20240609122052_LjmVZ | KR0003 | 2024-06-11T12:06:15.283Z | 2024-06-17T12:15:21.459Z |
4430935 | 4430935 | 20240606132829_a5wfw | KR0003 | 2024-06-08T12:10:27.573Z | 2024-06-14T12:08:32.051Z |
4426884 | 4426884 | 20240606183001_1m8te | KR0003 | 2024-06-08T12:03:46.560Z | 2024-06-15T12:16:48.763Z |
4426855 | 4426855 | 20240606182754_Fwy6m | KR0003 | 2024-06-08T12:03:45.222Z | 2024-06-15T12:16:48.720Z |
4426733 | 4426733 | 20240606181517_rCPbG | KR0003 | 2024-06-08T12:03:32.581Z | 2024-06-15T12:16:48.251Z |
4424802 | 4424802 | 20240606135014_KCCU3 | KR0003 | 2024-06-08T12:00:21.156Z | 2024-06-15T12:16:42.326Z |
4415686 | 4415686 | 20240604184040_NzNDo | KR0003 | 2024-06-06T12:05:11.866Z | 2024-06-13T12:08:30.193Z |
4415657 | 4415657 | 20240604183608_lpEKl | KR0003 | 2024-06-06T12:05:10.583Z | 2024-06-13T12:08:30.179Z |
4415378 | 4415378 | 20240604175404_9Ysii | KR0003 | 2024-06-06T12:04:37.227Z | 2024-06-13T12:08:29.914Z |
4415153 | 4415153 | 20240604172115_oCvPK | KR0003 | 2024-06-06T12:04:22.857Z | 2024-06-13T12:08:29.728Z |
4414913 | 4414913 | 20240604164515_GwfMv | KR0003 | 2024-06-06T12:03:51.844Z | 2024-06-13T12:08:29.538Z |
4414880 | 4414880 | 20240604163958_ecqef | KR0003 | 2024-06-06T12:03:49.793Z | 2024-06-13T12:08:29.523Z |
4414405 | 4414405 | 20240604155323_BFk0Z | KR0003 | 2024-06-06T12:03:22.273Z | 2024-06-13T12:08:29.192Z |
4414303 | 4414303 | 20240604154331_SquL5 | KR0003 | 2024-06-06T12:03:06.539Z | 2024-06-13T12:08:29.101Z |
4414218 | 4414218 | 20240604153550_RQEQ1 | KR0003 | 2024-06-06T12:02:56.360Z | 2024-06-13T12:08:29.061Z |
4413828 | 4413828 | 20240604144947_G77Ym | KR0003 | 2024-06-06T12:02:24.222Z | 2024-06-13T12:08:28.793Z |
4412702 | 4412702 | 20240604120719_G02KR | KR0003 | 2024-06-06T12:00:27.897Z | 2024-06-13T12:08:28.064Z |
4410998 | 4410998 | 20240603182805_SVygc | KR0003 | 2024-06-05T12:06:13.442Z | 2024-06-12T12:10:36.363Z |
4410831 | 4410831 | 20240603180845_UI2UW | KR0003 | 2024-06-05T12:05:59.035Z | 2024-06-12T12:10:35.924Z |
4410697 | 4410697 | 20240603174741_Q2rYR | KR0003 | 2024-06-05T12:05:41.727Z | 2024-06-12T12:10:35.215Z |
4410616 | 4410616 | 20240603173114_x3fgS | KR0003 | 2024-06-05T12:05:33.908Z | 2024-06-12T12:10:35.002Z |
4410588 | 4410588 | 20240603172943_ak4OE | KR0003 | 2024-06-05T12:05:33.034Z | 2024-06-12T12:10:34.980Z |
4410157 | 4410157 | 20240603164036_cfe4L | KR0003 | 2024-06-05T12:04:54.259Z | 2024-06-12T12:10:34.293Z |
4410096 | 4410096 | 20240603163633_ifPGA | KR0003 | 2024-06-05T12:04:49.822Z | 2024-06-12T12:10:34.216Z |
4409431 | 4409431 | 20240603150103_cG68Z | KR0003 | 2024-06-05T12:03:32.676Z | 2024-06-12T12:10:33.139Z |
4409394 | 4409394 | 20240603145727_RhVQv | KR0003 | 2024-06-05T12:03:27.179Z | 2024-06-12T12:10:33.060Z |
4401615 | 4401615 | 20240531175438_xYYMr | KR0003 | 2024-06-03T12:08:57.087Z | 2024-06-09T12:05:59.926Z |
4392339 | 4392339 | 20240529152223_6GGM3 | KR0003 | 2024-05-31T12:06:48.934Z | 2024-06-07T12:15:56.901Z |
4386441 | 4386441 | 20240527152949_NyEaw | KR0003 | 2024-05-29T12:06:04.096Z | 2024-06-05T12:17:54.743Z |
4386358 | 4386358 | 20240527145506_3BpU4 | KR0003 | 2024-05-29T12:05:49.279Z | 2024-06-05T12:17:54.474Z |
4385386 | 4385386 | 20240528153053_vlKem | KR0003 | 2024-05-29T12:03:27.175Z | 2024-06-06T12:14:24.693Z |
4385303 | 4385303 | 20240528150448_1839X | KR0003 | 2024-05-29T12:03:12.152Z | 2024-06-06T12:14:24.494Z |
4385159 | 4385159 | 20240528142614_fFW3J | KR0003 | 2024-05-29T12:02:58.525Z | 2024-06-06T12:14:24.208Z |
4385036 | 4385036 | 20240528132745_fjrTr | KR0003 | 2024-05-29T12:02:47.135Z | 2024-06-06T12:14:23.949Z |
4384978 | 4384978 | 20240528131313_sJqiR | KR0003 | 2024-05-29T12:02:42.378Z | 2024-06-06T12:14:23.799Z |
4384811 | 4384811 | 20240528120359_dLu94 | KR0003 | 2024-05-29T12:02:18.561Z | 2024-06-06T12:14:23.432Z |
4377472 | 4377472 | 20240519185843_mKLeA | KR0003 | 2024-05-27T12:12:09.580Z | 2024-05-27T12:12:09.580Z |
4377249 | 4377249 | 20240519173802_jNjXI | KR0003 | 2024-05-27T12:12:02.601Z | 2024-05-27T12:12:02.601Z |
4377212 | 4377212 | 20240519173127_ULEUl | KR0003 | 2024-05-27T12:12:02.139Z | 2024-05-27T12:12:02.139Z |
4377142 | 4377142 | 20240519170435_fUcj7 | KR0003 | 2024-05-27T12:12:00.318Z | 2024-05-27T12:12:00.318Z |
4377118 | 4377118 | 20240519165820_3qRNB | KR0003 | 2024-05-27T12:11:58.888Z | 2024-05-27T12:11:58.888Z |
4371522 | 4371522 | 20240523174916_JmPto | KR0003 | 2024-05-27T12:02:02.707Z | 2024-05-31T12:16:10.856Z |
4370784 | 4370784 | 20240518191845_D8kRG | KR0003 | 2024-05-26T12:09:47.127Z | 2024-05-26T12:09:53.609Z |
4370707 | 4370707 | 20240518185738_gx42g | KR0003 | 2024-05-26T12:09:40.205Z | 2024-05-26T12:09:53.585Z |
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);