participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,236 rows where station_code = "KR0004" 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 |
---|---|---|---|---|---|
5570762 | 5570762 | 20241120205113_6PYeK | KR0004 | 2024-11-22T14:16:04.365Z | 2024-11-22T14:19:21.976Z |
5570565 | 5570565 | 20241120201005_JRzoo | KR0004 | 2024-11-22T14:15:47.867Z | 2024-11-22T14:19:21.939Z |
5570409 | 5570409 | 20241120193406_6VuTj | KR0004 | 2024-11-22T14:15:20.023Z | 2024-11-22T14:19:21.912Z |
5570383 | 5570383 | 20241120192941_2kNFj | KR0004 | 2024-11-22T14:15:18.188Z | 2024-11-22T14:19:21.908Z |
5570346 | 5570346 | 20241120192138_gmRvG | KR0004 | 2024-11-22T14:15:12.705Z | 2024-11-22T14:19:21.902Z |
5569683 | 5569683 | 20241121205031_GbyI5 | KR0004 | 2024-11-22T14:11:29.470Z | 2024-11-22T14:11:29.470Z |
5569658 | 5569658 | 20241121201023_1xe8G | KR0004 | 2024-11-22T14:11:27.077Z | 2024-11-22T14:11:27.077Z |
5569645 | 5569645 | 20241121194955_PIoZ2 | KR0004 | 2024-11-22T14:11:26.257Z | 2024-11-22T14:11:26.257Z |
5569619 | 5569619 | 20241121182547_fd24u | KR0004 | 2024-11-22T14:11:23.921Z | 2024-11-22T14:11:23.921Z |
5569611 | 5569611 | 20241121175540_2dTJT | KR0004 | 2024-11-22T14:11:23.070Z | 2024-11-22T14:11:23.070Z |
5569599 | 5569599 | 20241121174629_pr5cb | KR0004 | 2024-11-22T14:11:21.899Z | 2024-11-22T14:11:21.899Z |
5569596 | 5569596 | 20241121174127_29bNa | KR0004 | 2024-11-22T14:11:21.569Z | 2024-11-22T14:11:21.569Z |
5569594 | 5569594 | 20241121173724_RBYLv | KR0004 | 2024-11-22T14:11:21.308Z | 2024-11-22T14:11:21.308Z |
5569572 | 5569572 | 20241121171008_YRBkU | KR0004 | 2024-11-22T14:11:18.748Z | 2024-11-22T14:11:18.748Z |
5569551 | 5569551 | 20241121162810_hwRQp | KR0004 | 2024-11-22T14:11:07.679Z | 2024-11-22T14:11:07.679Z |
5569539 | 5569539 | 20241121160832_MP9Wb | KR0004 | 2024-11-22T14:11:04.203Z | 2024-11-22T14:11:04.203Z |
5569090 | 5569090 | 20241121142954_yRnXN | KR0004 | 2024-11-22T14:10:20.066Z | 2024-11-22T14:10:20.066Z |
5568718 | 5568718 | 20241121132717_UDVnk | KR0004 | 2024-11-22T14:09:36.476Z | 2024-11-22T14:09:36.476Z |
5568418 | 5568418 | 20241121124411_3JsYn | KR0004 | 2024-11-22T14:08:55.202Z | 2024-11-22T14:08:55.202Z |
5567601 | 5567601 | 20241121104250_92373 | KR0004 | 2024-11-22T14:06:36.334Z | 2024-11-22T14:06:36.334Z |
5560936 | 5560936 | 20241120152514_9Ekjq | KR0004 | 2024-11-21T14:09:59.795Z | 2024-11-22T14:19:21.765Z |
5560840 | 5560840 | 20241120144554_3cgfq | KR0004 | 2024-11-21T14:09:50.741Z | 2024-11-22T14:19:21.744Z |
5560486 | 5560486 | 20241120125806_4sk3b | KR0004 | 2024-11-21T14:08:56.837Z | 2024-11-22T14:19:21.669Z |
5555157 | 5555157 | 20241119115758_mmYTO | KR0004 | 2024-11-20T14:04:34.919Z | 2024-11-22T14:20:00.140Z |
5552235 | 5552235 | 20241118193340_I8m3o | KR0004 | 2024-11-19T14:06:09.088Z | 2024-11-22T14:22:15.992Z |
5552196 | 5552196 | 20241118191512_FFDTd | KR0004 | 2024-11-19T14:06:07.305Z | 2024-11-22T14:22:15.829Z |
5552149 | 5552149 | 20241118183448_JNpHq | KR0004 | 2024-11-19T14:06:03.032Z | 2024-11-22T14:22:15.304Z |
5552133 | 5552133 | 20241118182935_O5a8Z | KR0004 | 2024-11-19T14:06:02.491Z | 2024-11-22T14:22:15.146Z |
5552127 | 5552127 | 20241118182846_1ePZh | KR0004 | 2024-11-19T14:06:02.359Z | 2024-11-22T14:22:15.123Z |
5552116 | 5552116 | 20241118182410_Y6b8y | KR0004 | 2024-11-19T14:06:01.757Z | 2024-11-22T14:22:15.036Z |
5552096 | 5552096 | 20241118181905_hqB1h | KR0004 | 2024-11-19T14:06:00.740Z | 2024-11-22T14:22:14.848Z |
5552039 | 5552039 | 20241118172528_oHVB7 | KR0004 | 2024-11-19T14:05:57.293Z | 2024-11-22T14:22:14.187Z |
5552025 | 5552025 | 20241118172255_RPoxH | KR0004 | 2024-11-19T14:05:56.025Z | 2024-11-22T14:22:14.072Z |
5551987 | 5551987 | 20241118165427_7HwTj | KR0004 | 2024-11-19T14:05:52.351Z | 2024-11-22T14:22:13.502Z |
5551964 | 5551964 | 20241118162417_79pLy | KR0004 | 2024-11-19T14:05:51.041Z | 2024-11-22T14:22:13.314Z |
5551896 | 5551896 | 20241118153707_kJe7H | KR0004 | 2024-11-19T14:05:46.888Z | 2024-11-22T14:22:12.936Z |
5551718 | 5551718 | 20241118145447_tNc7R | KR0004 | 2024-11-19T14:05:20.445Z | 2024-11-22T14:22:12.256Z |
5551517 | 5551517 | 20241118140523_KqDiK | KR0004 | 2024-11-19T14:04:56.430Z | 2024-11-22T14:22:11.222Z |
5551478 | 5551478 | 20241118135524_Y5XmG | KR0004 | 2024-11-19T14:04:51.782Z | 2024-11-22T14:22:10.981Z |
5551329 | 5551329 | 20241118130929_nnqOe | KR0004 | 2024-11-19T14:04:26.888Z | 2024-11-22T14:22:10.121Z |
5551219 | 5551219 | 20241118124547_qykg0 | KR0004 | 2024-11-19T14:04:07.547Z | 2024-11-22T14:22:09.301Z |
5550937 | 5550937 | 20241118115728_qrN8b | KR0004 | 2024-11-19T14:03:32.910Z | 2024-11-22T14:22:06.981Z |
5550308 | 5550308 | 20241118100444_HHlx9 | KR0004 | 2024-11-19T14:02:10.680Z | 2024-11-22T14:22:01.246Z |
5550266 | 5550266 | 20241118095745_o5VAo | KR0004 | 2024-11-19T14:02:01.464Z | 2024-11-22T14:22:00.623Z |
5550208 | 5550208 | 20241118094622_zSSGT | KR0004 | 2024-11-19T14:01:46.256Z | 2024-11-22T14:21:59.652Z |
5547975 | 5547975 | 20241117210135_cHNcM | KR0004 | 2024-11-18T14:06:52.505Z | 2024-11-22T14:22:46.151Z |
5547970 | 5547970 | 20241117205629_pgb40 | KR0004 | 2024-11-18T14:06:52.142Z | 2024-11-22T14:22:46.129Z |
5547910 | 5547910 | 20241117202947_nPIpE | KR0004 | 2024-11-18T14:06:49.195Z | 2024-11-22T14:22:45.509Z |
5547819 | 5547819 | 20241117195211_rkw1D | KR0004 | 2024-11-18T14:06:41.756Z | 2024-11-22T14:22:44.839Z |
5547811 | 5547811 | 20241117195125_NlVPs | KR0004 | 2024-11-18T14:06:40.872Z | 2024-11-22T14:22:44.742Z |
5547797 | 5547797 | 20241117195027_cSHar | KR0004 | 2024-11-18T14:06:35.888Z | 2024-11-22T14:22:43.785Z |
5547789 | 5547789 | 20241117194848_pJFKA | KR0004 | 2024-11-18T14:06:33.538Z | 2024-11-22T14:22:43.784Z |
5547681 | 5547681 | 20241117190533_Rys1y | KR0004 | 2024-11-18T14:06:16.379Z | 2024-11-22T14:22:42.562Z |
5547647 | 5547647 | 20241117185045_1NrlM | KR0004 | 2024-11-18T14:06:10.973Z | 2024-11-22T14:22:42.284Z |
5547637 | 5547637 | 20241117184604_ZYFPk | KR0004 | 2024-11-18T14:06:09.912Z | 2024-11-22T14:22:42.149Z |
5547595 | 5547595 | 20241117182025_RGsqt | KR0004 | 2024-11-18T14:06:06.741Z | 2024-11-22T14:22:41.455Z |
5547568 | 5547568 | 20241117181043_Pec3x | KR0004 | 2024-11-18T14:06:04.447Z | 2024-11-22T14:22:41.107Z |
5547556 | 5547556 | 20241117180208_I4mcY | KR0004 | 2024-11-18T14:06:03.452Z | 2024-11-22T14:22:41.033Z |
5547550 | 5547550 | 20241117175859_umSaI | KR0004 | 2024-11-18T14:06:03.195Z | 2024-11-22T14:22:40.986Z |
5547515 | 5547515 | 20241117173153_3xNRH | KR0004 | 2024-11-18T14:06:00.124Z | 2024-11-22T14:22:40.572Z |
5547507 | 5547507 | 20241117172921_4pR3Y | KR0004 | 2024-11-18T14:05:59.292Z | 2024-11-22T14:22:40.487Z |
5547505 | 5547505 | 20241117172748_sUrJ0 | KR0004 | 2024-11-18T14:05:58.909Z | 2024-11-22T14:22:40.415Z |
5547494 | 5547494 | 20241117172448_7sVd3 | KR0004 | 2024-11-18T14:05:57.951Z | 2024-11-22T14:22:40.388Z |
5547478 | 5547478 | 20241117171138_sA7DM | KR0004 | 2024-11-18T14:05:56.697Z | 2024-11-22T14:22:40.290Z |
5547473 | 5547473 | 20241117171105_grHIN | KR0004 | 2024-11-18T14:05:56.372Z | 2024-11-22T14:22:40.277Z |
5547430 | 5547430 | 20241117164221_cxfxf | KR0004 | 2024-11-18T14:05:51.795Z | 2024-11-22T14:22:39.878Z |
5547419 | 5547419 | 20241117164002_iVmqO | KR0004 | 2024-11-18T14:05:50.321Z | 2024-11-22T14:22:39.849Z |
5547415 | 5547415 | 20241117163129_6Df3z | KR0004 | 2024-11-18T14:05:48.279Z | 2024-11-22T14:22:39.760Z |
5547401 | 5547401 | 20241117161513_N1sHq | KR0004 | 2024-11-18T14:05:42.541Z | 2024-11-22T14:22:39.665Z |
5547382 | 5547382 | 20241117155742_uuBUK | KR0004 | 2024-11-18T14:05:38.326Z | 2024-11-22T14:22:39.444Z |
5547343 | 5547343 | 20241117154526_6I4Pk | KR0004 | 2024-11-18T14:05:33.225Z | 2024-11-22T14:22:39.068Z |
5547307 | 5547307 | 20241117153501_McVNW | KR0004 | 2024-11-18T14:05:27.581Z | 2024-11-22T14:22:38.921Z |
5547182 | 5547182 | 20241117150357_tLitL | KR0004 | 2024-11-18T14:05:14.068Z | 2024-11-22T14:22:37.871Z |
5547133 | 5547133 | 20241117145750_3wcIA | KR0004 | 2024-11-18T14:05:09.574Z | 2024-11-22T14:22:37.553Z |
5545440 | 5545440 | 20241113203313_oa3lm | KR0004 | 2024-11-17T14:08:55.316Z | 2024-11-22T14:24:17.122Z |
5544047 | 5544047 | 20241113184212_1S9Gn | KR0004 | 2024-11-16T14:09:52.738Z | 2024-11-22T14:24:16.241Z |
5539963 | 5539963 | 20241114093839_glKdg | KR0004 | 2024-11-15T14:02:25.955Z | 2024-11-22T14:23:47.602Z |
5537119 | 5537119 | 20241112203159_phFK3 | KR0004 | 2024-11-14T14:11:04.340Z | 2024-11-21T14:26:09.110Z |
5536995 | 5536995 | 20241112200236_QgOuT | KR0004 | 2024-11-14T14:10:49.469Z | 2024-11-21T14:26:07.740Z |
5536888 | 5536888 | 20241112193657_kTjbd | KR0004 | 2024-11-14T14:10:39.631Z | 2024-11-21T14:26:06.702Z |
5536782 | 5536782 | 20241112190520_V1qvY | KR0004 | 2024-11-14T14:10:32.915Z | 2024-11-21T14:26:05.456Z |
5536775 | 5536775 | 20241112190322_iA1Ld | KR0004 | 2024-11-14T14:10:32.813Z | 2024-11-21T14:26:05.454Z |
5536737 | 5536737 | 20241112190122_9MKnI | KR0004 | 2024-11-14T14:10:31.156Z | 2024-11-21T14:26:05.299Z |
5536697 | 5536697 | 20241112185509_60clf | KR0004 | 2024-11-14T14:10:28.526Z | 2024-11-21T14:26:04.966Z |
5536580 | 5536580 | 20241112183322_v0gRY | KR0004 | 2024-11-14T14:10:21.678Z | 2024-11-21T14:26:03.391Z |
5536360 | 5536360 | 20241112174407_kXope | KR0004 | 2024-11-14T14:09:42.505Z | 2024-11-21T14:26:00.321Z |
5536340 | 5536340 | 20241112173424_kbK7n | KR0004 | 2024-11-14T14:09:39.923Z | 2024-11-21T14:26:00.189Z |
5536285 | 5536285 | 20241112171003_Q1fVK | KR0004 | 2024-11-14T14:09:33.511Z | 2024-11-21T14:25:59.760Z |
5535867 | 5535867 | 20241112143843_aOXkU | KR0004 | 2024-11-14T14:08:55.907Z | 2024-11-21T14:25:53.923Z |
5534835 | 5534835 | 20241113201553_qpq9z | KR0004 | 2024-11-14T14:05:32.954Z | 2024-11-22T14:24:17.108Z |
5534811 | 5534811 | 20241113193917_35UdN | KR0004 | 2024-11-14T14:05:30.077Z | 2024-11-22T14:24:16.750Z |
5534809 | 5534809 | 20241113193853_fOFz2 | KR0004 | 2024-11-14T14:05:29.796Z | 2024-11-22T14:24:16.734Z |
5534804 | 5534804 | 20241113193731_25zqv | KR0004 | 2024-11-14T14:05:29.321Z | 2024-11-22T14:24:16.657Z |
5534778 | 5534778 | 20241113191251_Bac3T | KR0004 | 2024-11-14T14:05:22.586Z | 2024-11-22T14:24:16.417Z |
5534776 | 5534776 | 20241113190814_l4w1v | KR0004 | 2024-11-14T14:05:21.820Z | 2024-11-22T14:24:16.412Z |
5534773 | 5534773 | 20241113185816_wFOGB | KR0004 | 2024-11-14T14:05:21.316Z | 2024-11-22T14:24:16.356Z |
5534763 | 5534763 | 20241113183543_1yNmH | KR0004 | 2024-11-14T14:05:19.886Z | 2024-11-22T14:24:16.178Z |
5534753 | 5534753 | 20241113180520_YL6T4 | KR0004 | 2024-11-14T14:05:17.164Z | 2024-11-22T14:24:16.067Z |
5534745 | 5534745 | 20241113175510_qD2UJ | KR0004 | 2024-11-14T14:05:15.430Z | 2024-11-22T14:24:16.040Z |
5534739 | 5534739 | 20241113174557_d2o3h | KR0004 | 2024-11-14T14:05:13.861Z | 2024-11-22T14:24:15.982Z |
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);