participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,775 rows where station_code = "KR002D" 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 |
---|---|---|---|---|---|
5561023 | 5561023 | 20241120170703_iD6bO | KR002D | 2024-11-21T14:10:19.981Z | 2024-11-22T14:19:21.792Z |
5560627 | 5560627 | 20241120132813_LrGb0 | KR002D | 2024-11-21T14:09:16.797Z | 2024-11-22T14:19:21.700Z |
5560510 | 5560510 | 20241120130306_1e25k | KR002D | 2024-11-21T14:08:59.633Z | 2024-11-22T14:19:21.675Z |
5552161 | 5552161 | 20241118184105_jmZhC | KR002D | 2024-11-19T14:06:04.456Z | 2024-11-22T14:22:15.394Z |
5552159 | 5552159 | 20241118183801_okBHy | KR002D | 2024-11-19T14:06:03.764Z | 2024-11-22T14:22:15.370Z |
5552067 | 5552067 | 20241118174402_BO0cD | KR002D | 2024-11-19T14:05:58.972Z | 2024-11-22T14:22:14.494Z |
5551981 | 5551981 | 20241118164457_eRbBi | KR002D | 2024-11-19T14:05:51.930Z | 2024-11-22T14:22:13.447Z |
5551818 | 5551818 | 20241118152057_swgIx | KR002D | 2024-11-19T14:05:38.852Z | 2024-11-22T14:22:12.626Z |
5551464 | 5551464 | 20241118134439_mr38x | KR002D | 2024-11-19T14:04:49.947Z | 2024-11-22T14:22:10.849Z |
5551390 | 5551390 | 20241118132045_Co0fg | KR002D | 2024-11-19T14:04:43.286Z | 2024-11-22T14:22:10.474Z |
5551291 | 5551291 | 20241118125521_ea6u8 | KR002D | 2024-11-19T14:04:16.230Z | 2024-11-22T14:22:09.758Z |
5550458 | 5550458 | 20241118102304_rtHgl | KR002D | 2024-11-19T14:02:22.365Z | 2024-11-22T14:22:03.125Z |
5550446 | 5550446 | 20241118102125_fXFJW | KR002D | 2024-11-19T14:02:20.895Z | 2024-11-22T14:22:02.994Z |
5547969 | 5547969 | 20241117205541_UmWNk | KR002D | 2024-11-18T14:06:52.060Z | 2024-11-22T14:22:46.128Z |
5547913 | 5547913 | 20241117203055_Uysab | KR002D | 2024-11-18T14:06:49.497Z | 2024-11-22T14:22:45.539Z |
5547885 | 5547885 | 20241117202255_N1OPX | KR002D | 2024-11-18T14:06:47.808Z | 2024-11-22T14:22:45.405Z |
5547697 | 5547697 | 20241117190933_fRXUj | KR002D | 2024-11-18T14:06:18.065Z | 2024-11-22T14:22:42.765Z |
5547624 | 5547624 | 20241117183457_4bXlX | KR002D | 2024-11-18T14:06:08.347Z | 2024-11-22T14:22:41.952Z |
5547564 | 5547564 | 20241117180341_xiyka | KR002D | 2024-11-18T14:06:03.946Z | 2024-11-22T14:22:41.075Z |
5547316 | 5547316 | 20241117153623_2JgoB | KR002D | 2024-11-18T14:05:29.252Z | 2024-11-22T14:22:38.970Z |
5537189 | 5537189 | 20241112205249_14sGs | KR002D | 2024-11-14T14:11:14.727Z | 2024-11-21T14:26:09.567Z |
5536978 | 5536978 | 20241112195450_pPdyo | KR002D | 2024-11-14T14:10:48.004Z | 2024-11-21T14:26:07.614Z |
5536971 | 5536971 | 20241112195310_iOYX8 | KR002D | 2024-11-14T14:10:47.483Z | 2024-11-21T14:26:07.472Z |
5536913 | 5536913 | 20241112193922_fBzd4 | KR002D | 2024-11-14T14:10:40.439Z | 2024-11-21T14:26:07.083Z |
5536690 | 5536690 | 20241112185246_iKwkT | KR002D | 2024-11-14T14:10:27.992Z | 2024-11-21T14:26:04.675Z |
5536590 | 5536590 | 20241112183400_DO670 | KR002D | 2024-11-14T14:10:22.269Z | 2024-11-21T14:26:03.422Z |
5536575 | 5536575 | 20241112183302_8mN22 | KR002D | 2024-11-14T14:10:21.239Z | 2024-11-21T14:26:03.363Z |
5536562 | 5536562 | 20241112183043_9cci2 | KR002D | 2024-11-14T14:10:18.186Z | 2024-11-21T14:26:03.121Z |
5536496 | 5536496 | 20241112181710_5KuGB | KR002D | 2024-11-14T14:10:04.936Z | 2024-11-21T14:26:01.427Z |
5536494 | 5536494 | 20241112181625_vvKpB | KR002D | 2024-11-14T14:10:03.862Z | 2024-11-21T14:26:01.423Z |
5536409 | 5536409 | 20241112175606_YL3P3 | KR002D | 2024-11-14T14:09:51.248Z | 2024-11-21T14:26:00.782Z |
5536386 | 5536386 | 20241112175103_ZtLUP | KR002D | 2024-11-14T14:09:47.928Z | 2024-11-21T14:26:00.424Z |
5536382 | 5536382 | 20241112174939_dk3zG | KR002D | 2024-11-14T14:09:47.161Z | 2024-11-21T14:26:00.402Z |
5536359 | 5536359 | 20241112174340_Sx5eR | KR002D | 2024-11-14T14:09:42.217Z | 2024-11-21T14:26:00.319Z |
5536312 | 5536312 | 20241112172140_o1ukL | KR002D | 2024-11-14T14:09:36.081Z | 2024-11-21T14:25:59.952Z |
5535793 | 5535793 | 20241112142306_vzmZU | KR002D | 2024-11-14T14:08:50.342Z | 2024-11-21T14:25:53.477Z |
5535617 | 5535617 | 20241112130539_JJU9x | KR002D | 2024-11-14T14:08:10.942Z | 2024-11-21T14:25:50.499Z |
5534839 | 5534839 | 20241113202827_w8BIJ | KR002D | 2024-11-14T14:05:33.158Z | 2024-11-22T14:24:17.116Z |
5534822 | 5534822 | 20241113195024_POOaC | KR002D | 2024-11-14T14:05:31.338Z | 2024-11-22T14:24:16.937Z |
5534800 | 5534800 | 20241113193539_vsQoT | KR002D | 2024-11-14T14:05:28.778Z | 2024-11-22T14:24:16.641Z |
5534798 | 5534798 | 20241113193221_mtasi | KR002D | 2024-11-14T14:05:28.467Z | 2024-11-22T14:24:16.599Z |
5534796 | 5534796 | 20241113192828_qzf3X | KR002D | 2024-11-14T14:05:27.611Z | 2024-11-22T14:24:16.499Z |
5534772 | 5534772 | 20241113184545_ygufS | KR002D | 2024-11-14T14:05:20.635Z | 2024-11-22T14:24:16.267Z |
5534742 | 5534742 | 20241113174654_q2G2J | KR002D | 2024-11-14T14:05:14.177Z | 2024-11-22T14:24:16.003Z |
5534731 | 5534731 | 20241113173021_18Ccp | KR002D | 2024-11-14T14:05:11.064Z | 2024-11-22T14:24:15.923Z |
5534671 | 5534671 | 20241113151617_VKaW6 | KR002D | 2024-11-14T14:04:52.642Z | 2024-11-22T14:24:15.096Z |
5528482 | 5528482 | 20241111210735_WRth3 | KR002D | 2024-11-13T14:10:47.884Z | 2024-11-20T14:25:31.069Z |
5528388 | 5528388 | 20241111203656_FY7Dg | KR002D | 2024-11-13T14:10:33.859Z | 2024-11-20T14:25:29.114Z |
5528368 | 5528368 | 20241111203240_HXb2z | KR002D | 2024-11-13T14:10:32.430Z | 2024-11-20T14:25:29.011Z |
5528251 | 5528251 | 20241111200359_Dcp8h | KR002D | 2024-11-13T14:10:19.804Z | 2024-11-20T14:25:27.327Z |
5528157 | 5528157 | 20241111194705_GYuIj | KR002D | 2024-11-13T14:10:09.830Z | 2024-11-20T14:25:26.144Z |
5528150 | 5528150 | 20241111194514_2CLm7 | KR002D | 2024-11-13T14:10:07.450Z | 2024-11-20T14:25:26.040Z |
5528125 | 5528125 | 20241111194121_B6eHY | KR002D | 2024-11-13T14:09:56.713Z | 2024-11-20T14:25:25.361Z |
5528104 | 5528104 | 20241111193521_mtf6s | KR002D | 2024-11-13T14:09:52.426Z | 2024-11-20T14:25:25.112Z |
5527965 | 5527965 | 20241111190814_obL5p | KR002D | 2024-11-13T14:09:38.340Z | 2024-11-20T14:25:23.622Z |
5527898 | 5527898 | 20241111185444_64zJ8 | KR002D | 2024-11-13T14:09:31.271Z | 2024-11-20T14:25:22.797Z |
5527805 | 5527805 | 20241111183711_Yyfrv | KR002D | 2024-11-13T14:09:14.436Z | 2024-11-20T14:25:20.686Z |
5527746 | 5527746 | 20241111182732_qJcY3 | KR002D | 2024-11-13T14:09:01.683Z | 2024-11-20T14:25:18.733Z |
5527740 | 5527740 | 20241111182556_RbWzl | KR002D | 2024-11-13T14:09:00.796Z | 2024-11-20T14:25:18.635Z |
5527632 | 5527632 | 20241111175620_G2xvb | KR002D | 2024-11-13T14:08:48.262Z | 2024-11-20T14:25:15.207Z |
5527618 | 5527618 | 20241111175135_z9LQF | KR002D | 2024-11-13T14:08:46.729Z | 2024-11-20T14:25:14.742Z |
5527616 | 5527616 | 20241111175018_MrVzh | KR002D | 2024-11-13T14:08:46.160Z | 2024-11-20T14:25:14.722Z |
5527614 | 5527614 | 20241111174855_CDRKn | KR002D | 2024-11-13T14:08:45.646Z | 2024-11-20T14:25:14.713Z |
5527544 | 5527544 | 20241111173338_dXA2c | KR002D | 2024-11-13T14:08:37.648Z | 2024-11-20T14:25:13.286Z |
5527536 | 5527536 | 20241111173026_Ye2ro | KR002D | 2024-11-13T14:08:36.789Z | 2024-11-20T14:25:13.208Z |
5527527 | 5527527 | 20241111172913_rsQDD | KR002D | 2024-11-13T14:08:35.554Z | 2024-11-20T14:25:13.023Z |
5527516 | 5527516 | 20241111172210_4Fv4b | KR002D | 2024-11-13T14:08:27.833Z | 2024-11-20T14:25:12.868Z |
5527476 | 5527476 | 20241111170142_2QwTk | KR002D | 2024-11-13T14:08:20.548Z | 2024-11-20T14:25:11.879Z |
5527412 | 5527412 | 20241111162716_Kq8WT | KR002D | 2024-11-13T14:08:10.725Z | 2024-11-20T14:25:10.467Z |
5527401 | 5527401 | 20241111160714_qngYC | KR002D | 2024-11-13T14:08:09.374Z | 2024-11-20T14:25:10.274Z |
5527280 | 5527280 | 20241111134108_6hVYV | KR002D | 2024-11-13T14:07:21.028Z | 2024-11-20T14:25:00.317Z |
5525607 | 5525607 | 20241105204801_1a6i3 | KR002D | 2024-11-12T14:26:45.920Z | 2024-11-14T14:23:17.252Z |
5525592 | 5525592 | 20241105193404_3U4b1 | KR002D | 2024-11-12T14:26:44.290Z | 2024-11-14T14:23:14.336Z |
5525587 | 5525587 | 20241105192443_WQaCf | KR002D | 2024-11-12T14:26:44.076Z | 2024-11-14T14:23:13.939Z |
5525567 | 5525567 | 20241105185024_w73BJ | KR002D | 2024-11-12T14:26:42.710Z | 2024-11-14T14:23:12.860Z |
5525555 | 5525555 | 20241105183327_MLgr8 | KR002D | 2024-11-12T14:26:42.060Z | 2024-11-14T14:23:12.345Z |
5525548 | 5525548 | 20241105180952_VHhkm | KR002D | 2024-11-12T14:26:40.362Z | 2024-11-14T14:23:11.031Z |
5525526 | 5525526 | 20241105171257_VsLdY | KR002D | 2024-11-12T14:26:36.028Z | 2024-11-14T14:23:08.507Z |
5525510 | 5525510 | 20241105163313_m1q0a | KR002D | 2024-11-12T14:26:35.133Z | 2024-11-14T14:23:07.253Z |
5525491 | 5525491 | 20241105160551_fxcr8 | KR002D | 2024-11-12T14:26:34.768Z | 2024-11-14T14:23:06.894Z |
5525481 | 5525481 | 20241105150715_2QV7t | KR002D | 2024-11-12T14:26:33.878Z | 2024-11-14T14:23:05.791Z |
5525452 | 5525452 | 20241105132017_6MhIh | KR002D | 2024-11-12T14:26:32.259Z | 2024-11-14T14:23:04.518Z |
5525449 | 5525449 | 20241106205733_egRGV | KR002D | 2024-11-12T14:25:57.091Z | 2024-11-15T14:24:52.254Z |
5525447 | 5525447 | 20241106205717_JNjjL | KR002D | 2024-11-12T14:25:56.920Z | 2024-11-15T14:24:52.252Z |
5525440 | 5525440 | 20241106205525_Hw1Tp | KR002D | 2024-11-12T14:25:56.610Z | 2024-11-15T14:24:51.972Z |
5525436 | 5525436 | 20241106204811_2J1J2 | KR002D | 2024-11-12T14:25:56.098Z | 2024-11-15T14:24:51.816Z |
5525429 | 5525429 | 20241106204421_qQJja | KR002D | 2024-11-12T14:25:56.001Z | 2024-11-15T14:24:51.723Z |
5525427 | 5525427 | 20241106201416_RBHtK | KR002D | 2024-11-12T14:25:54.778Z | 2024-11-15T14:24:50.403Z |
5525418 | 5525418 | 20241106195554_HIV1R | KR002D | 2024-11-12T14:25:54.020Z | 2024-11-15T14:24:49.720Z |
5525404 | 5525404 | 20241106192202_tMUUE | KR002D | 2024-11-12T14:25:52.164Z | 2024-11-15T14:24:48.251Z |
5525390 | 5525390 | 20241106191557_ePa39 | KR002D | 2024-11-12T14:25:51.539Z | 2024-11-15T14:24:48.011Z |
5525386 | 5525386 | 20241106191028_83Ild | KR002D | 2024-11-12T14:25:51.378Z | 2024-11-15T14:24:47.947Z |
5525382 | 5525382 | 20241106190609_NU4Tc | KR002D | 2024-11-12T14:25:51.220Z | 2024-11-15T14:24:47.863Z |
5525371 | 5525371 | 20241106185414_LQV92 | KR002D | 2024-11-12T14:25:50.500Z | 2024-11-15T14:24:47.123Z |
5525369 | 5525369 | 20241106184825_ey3uv | KR002D | 2024-11-12T14:25:50.009Z | 2024-11-15T14:24:46.791Z |
5525367 | 5525367 | 20241106184049_aeQ33 | KR002D | 2024-11-12T14:25:49.834Z | 2024-11-15T14:24:46.716Z |
5525363 | 5525363 | 20241106181716_bMJCo | KR002D | 2024-11-12T14:25:47.443Z | 2024-11-15T14:24:45.542Z |
5525361 | 5525361 | 20241106180914_jHOn3 | KR002D | 2024-11-12T14:25:47.322Z | 2024-11-15T14:24:45.246Z |
5525345 | 5525345 | 20241106175908_LGSpi | KR002D | 2024-11-12T14:25:46.385Z | 2024-11-15T14:24:44.673Z |
5525337 | 5525337 | 20241106174653_d1ww8 | KR002D | 2024-11-12T14:25:45.491Z | 2024-11-15T14:24:43.981Z |
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);