participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,018 rows where station_code = "KR001E" 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 |
---|---|---|---|---|---|
5099056 | 5099056 | 20240913201619_fib2j | KR001E | 2024-09-17T12:02:15.406Z | 2024-09-22T12:17:45.890Z |
5098753 | 5098753 | 20240913192029_7GJBE | KR001E | 2024-09-17T12:01:30.709Z | 2024-09-22T12:17:43.759Z |
5098393 | 5098393 | 20240913165332_giEez | KR001E | 2024-09-17T12:00:26.837Z | 2024-09-22T12:17:39.497Z |
5068949 | 5068949 | 20240910131224_42CQZ | KR001E | 2024-09-14T12:19:23.213Z | 2024-09-18T12:15:26.885Z |
5062885 | 5062885 | 20240909185316_fstFM | KR001E | 2024-09-14T12:13:00.933Z | 2024-09-18T12:15:12.433Z |
5062810 | 5062810 | 20240909182852_czr3M | KR001E | 2024-09-14T12:12:53.792Z | 2024-09-18T12:15:12.087Z |
5062796 | 5062796 | 20240909182541_v86vE | KR001E | 2024-09-14T12:12:52.265Z | 2024-09-18T12:15:12.070Z |
5062754 | 5062754 | 20240909181545_YSLtT | KR001E | 2024-09-14T12:12:47.344Z | 2024-09-18T12:15:12.024Z |
5062495 | 5062495 | 20240909173354_n31R0 | KR001E | 2024-09-14T12:12:28.129Z | 2024-09-18T12:15:11.400Z |
5062315 | 5062315 | 20240909171025_x4d6g | KR001E | 2024-09-14T12:12:09.137Z | 2024-09-18T12:15:10.867Z |
5062285 | 5062285 | 20240909170714_EMu5J | KR001E | 2024-09-14T12:12:05.756Z | 2024-09-18T12:15:10.834Z |
5062153 | 5062153 | 20240909165138_0PhvY | KR001E | 2024-09-14T12:11:52.911Z | 2024-09-18T12:15:10.440Z |
5062146 | 5062146 | 20240909165058_gvOrA | KR001E | 2024-09-14T12:11:52.361Z | 2024-09-18T12:15:10.438Z |
5061974 | 5061974 | 20240909163128_jlYeh | KR001E | 2024-09-14T12:11:42.575Z | 2024-09-18T12:15:10.266Z |
5061802 | 5061802 | 20240909160110_gUj7F | KR001E | 2024-09-14T12:11:26.426Z | 2024-09-18T12:15:09.996Z |
5061749 | 5061749 | 20240909155025_5ekIf | KR001E | 2024-09-14T12:11:19.339Z | 2024-09-18T12:15:09.942Z |
5061646 | 5061646 | 20240909153504_s92R4 | KR001E | 2024-09-14T12:11:05.723Z | 2024-09-18T12:15:09.825Z |
5061296 | 5061296 | 20240909144246_cw4bp | KR001E | 2024-09-14T12:10:40.758Z | 2024-09-18T12:15:08.844Z |
5057881 | 5057881 | 20240910152149_vk2Ck | KR001E | 2024-09-14T12:02:19.096Z | 2024-09-19T12:21:28.881Z |
5057643 | 5057643 | 20240910145921_LDzdL | KR001E | 2024-09-14T12:01:37.338Z | 2024-09-19T12:21:28.511Z |
5057292 | 5057292 | 20240910140838_QaBp0 | KR001E | 2024-09-14T12:00:45.772Z | 2024-09-19T12:21:27.518Z |
5057191 | 5057191 | 20240910135717_bvb8K | KR001E | 2024-09-14T12:00:28.807Z | 2024-09-19T12:21:27.251Z |
5049894 | 5049894 | 20240909115350_hGDXi | KR001E | 2024-09-13T12:12:30.541Z | 2024-09-17T12:19:11.793Z |
5044178 | 5044178 | 20240908142257_lyg6f | KR001E | 2024-09-13T12:01:37.553Z | 2024-09-17T12:18:53.639Z |
5043829 | 5043829 | 20240908131739_COG1U | KR001E | 2024-09-13T12:00:46.128Z | 2024-09-17T12:18:52.925Z |
5018726 | 5018726 | 20240904195657_nDxoF | KR001E | 2024-09-10T12:11:27.072Z | 2024-09-13T12:19:48.603Z |
5018683 | 5018683 | 20240904193203_KTJHT | KR001E | 2024-09-10T12:11:13.083Z | 2024-09-13T12:19:48.525Z |
5018481 | 5018481 | 20240904182055_ZuA6k | KR001E | 2024-09-10T12:10:41.898Z | 2024-09-13T12:19:47.954Z |
5018475 | 5018475 | 20240904182003_vKLBG | KR001E | 2024-09-10T12:10:41.478Z | 2024-09-13T12:19:47.952Z |
5018426 | 5018426 | 20240904180419_nTdNm | KR001E | 2024-09-10T12:10:36.471Z | 2024-09-13T12:19:47.882Z |
5018385 | 5018385 | 20240904175332_YHORV | KR001E | 2024-09-10T12:10:32.729Z | 2024-09-13T12:19:47.699Z |
5018152 | 5018152 | 20240904171512_ic7mG | KR001E | 2024-09-10T12:10:04.302Z | 2024-09-13T12:19:47.336Z |
5017955 | 5017955 | 20240904165843_y6oBN | KR001E | 2024-09-10T12:09:47.422Z | 2024-09-13T12:19:47.141Z |
5017446 | 5017446 | 20240904160911_u2L2F | KR001E | 2024-09-10T12:09:11.038Z | 2024-09-13T12:19:46.887Z |
5017378 | 5017378 | 20240904160307_Lox8k | KR001E | 2024-09-10T12:09:06.687Z | 2024-09-13T12:19:46.810Z |
5017305 | 5017305 | 20240904155521_Z2kez | KR001E | 2024-09-10T12:09:03.021Z | 2024-09-13T12:19:46.763Z |
5017031 | 5017031 | 20240904152344_EXeLe | KR001E | 2024-09-10T12:08:40.851Z | 2024-09-13T12:19:46.505Z |
5016395 | 5016395 | 20240904141220_oW2Xt | KR001E | 2024-09-10T12:07:47.056Z | 2024-09-13T12:19:45.666Z |
5015768 | 5015768 | 20240904122838_OYxu2 | KR001E | 2024-09-10T12:06:45.374Z | 2024-09-13T12:19:44.653Z |
5007103 | 5007103 | 20240903195747_HbgJo | KR001E | 2024-09-09T12:05:26.336Z | 2024-09-12T12:19:11.362Z |
5006842 | 5006842 | 20240903190954_52oqh | KR001E | 2024-09-09T12:05:08.058Z | 2024-09-12T12:19:10.293Z |
5006760 | 5006760 | 20240903185029_Eycqh | KR001E | 2024-09-09T12:05:00.030Z | 2024-09-12T12:19:09.426Z |
5006751 | 5006751 | 20240903184515_UIORb | KR001E | 2024-09-09T12:04:58.908Z | 2024-09-12T12:19:09.397Z |
5006706 | 5006706 | 20240903183350_536eI | KR001E | 2024-09-09T12:04:56.435Z | 2024-09-12T12:19:09.265Z |
5006674 | 5006674 | 20240903182209_2B27f | KR001E | 2024-09-09T12:04:52.731Z | 2024-09-12T12:19:09.182Z |
5006653 | 5006653 | 20240903181849_APaNi | KR001E | 2024-09-09T12:04:51.547Z | 2024-09-12T12:19:09.133Z |
5006121 | 5006121 | 20240903165628_NEwt7 | KR001E | 2024-09-09T12:04:21.738Z | 2024-09-12T12:19:07.684Z |
5006104 | 5006104 | 20240903165508_h6Eeq | KR001E | 2024-09-09T12:04:20.985Z | 2024-09-12T12:19:07.638Z |
5005905 | 5005905 | 20240903163122_D31wC | KR001E | 2024-09-09T12:04:12.202Z | 2024-09-12T12:19:07.034Z |
5005886 | 5005886 | 20240903162910_Ow8wC | KR001E | 2024-09-09T12:04:11.468Z | 2024-09-12T12:19:07.003Z |
5005481 | 5005481 | 20240903151947_o1sH4 | KR001E | 2024-09-09T12:03:45.009Z | 2024-09-12T12:19:06.007Z |
5005479 | 5005479 | 20240903151947_TEwun | KR001E | 2024-09-09T12:03:44.874Z | 2024-09-12T12:19:06.006Z |
5005361 | 5005361 | 20240903145905_pMu58 | KR001E | 2024-09-09T12:03:38.809Z | 2024-09-12T12:19:05.815Z |
5005245 | 5005245 | 20240903143725_5SmdN | KR001E | 2024-09-09T12:03:31.457Z | 2024-09-12T12:19:05.586Z |
5004999 | 5004999 | 20240903134439_44orq | KR001E | 2024-09-09T12:03:15.282Z | 2024-09-12T12:19:04.723Z |
5004967 | 5004967 | 20240903134030_H0B4V | KR001E | 2024-09-09T12:03:14.133Z | 2024-09-12T12:19:04.621Z |
5004784 | 5004784 | 20240903123907_I0dk3 | KR001E | 2024-09-09T12:03:02.495Z | 2024-09-12T12:19:04.101Z |
4987990 | 4987990 | 20240901193534_jLrcG | KR001E | 2024-09-07T12:06:38.758Z | 2024-09-10T12:19:12.155Z |
4987908 | 4987908 | 20240901191534_wwdLq | KR001E | 2024-09-07T12:06:27.951Z | 2024-09-10T12:19:11.810Z |
4987815 | 4987815 | 20240901190057_YTwxf | KR001E | 2024-09-07T12:06:21.498Z | 2024-09-10T12:19:11.459Z |
4987718 | 4987718 | 20240901183845_WGO7C | KR001E | 2024-09-07T12:06:09.489Z | 2024-09-10T12:19:11.202Z |
4987595 | 4987595 | 20240901180619_9MEJu | KR001E | 2024-09-07T12:05:58.592Z | 2024-09-10T12:19:11.015Z |
4987586 | 4987586 | 20240901180305_mFIqb | KR001E | 2024-09-07T12:05:58.030Z | 2024-09-10T12:19:11.009Z |
4985790 | 4985790 | 20240901133344_cFBfM | KR001E | 2024-09-07T12:03:46.727Z | 2024-09-10T12:19:08.351Z |
4962993 | 4962993 | 20240811193639_7PT3c | KR001E | 2024-09-04T12:05:03.963Z | 2024-09-06T12:04:14.250Z |
4962960 | 4962960 | 20240811193448_3A9lo | KR001E | 2024-09-04T12:05:01.534Z | 2024-09-06T12:04:12.915Z |
4962940 | 4962940 | 20240811193334_3nC6Y | KR001E | 2024-09-04T12:05:00.663Z | 2024-09-06T12:04:12.184Z |
4962881 | 4962881 | 20240811193001_Zw3ar | KR001E | 2024-09-04T12:04:57.604Z | 2024-09-06T12:04:10.171Z |
4962724 | 4962724 | 20240811191848_UNBxW | KR001E | 2024-09-04T12:04:48.903Z | 2024-09-06T12:03:59.969Z |
4962711 | 4962711 | 20240811191751_RBU0H | KR001E | 2024-09-04T12:04:48.376Z | 2024-09-06T12:03:59.525Z |
4962670 | 4962670 | 20240811191559_R3kZ1 | KR001E | 2024-09-04T12:04:46.594Z | 2024-09-06T12:03:55.772Z |
4962604 | 4962604 | 20240811191156_rjRjp | KR001E | 2024-09-04T12:04:43.338Z | 2024-09-06T12:03:53.331Z |
4962570 | 4962570 | 20240811190946_UpiNx | KR001E | 2024-09-04T12:04:39.030Z | 2024-09-06T12:03:51.660Z |
4962253 | 4962253 | 20240811184409_FftVO | KR001E | 2024-09-04T12:04:22.572Z | 2024-09-06T12:03:35.733Z |
4962207 | 4962207 | 20240811184138_quX4q | KR001E | 2024-09-04T12:04:21.051Z | 2024-09-06T12:03:33.536Z |
4962155 | 4962155 | 20240811183823_tebr0 | KR001E | 2024-09-04T12:04:19.210Z | 2024-09-06T12:03:31.836Z |
4962126 | 4962126 | 20240811183649_ZqTIv | KR001E | 2024-09-04T12:04:17.542Z | 2024-09-06T12:03:30.456Z |
4962049 | 4962049 | 20240811183234_mZckw | KR001E | 2024-09-04T12:04:13.866Z | 2024-09-06T12:03:25.913Z |
4961996 | 4961996 | 20240811182314_QauNg | KR001E | 2024-09-04T12:04:08.737Z | 2024-09-06T12:03:23.143Z |
4961963 | 4961963 | 20240811182102_Gs3VS | KR001E | 2024-09-04T12:04:06.033Z | 2024-09-06T12:03:21.925Z |
4961940 | 4961940 | 20240811181821_8umiq | KR001E | 2024-09-04T12:04:05.022Z | 2024-09-06T12:03:21.237Z |
4961938 | 4961938 | 20240811181820_Y1ZXp | KR001E | 2024-09-04T12:04:04.809Z | 2024-09-06T12:03:21.063Z |
4961886 | 4961886 | 20240811181235_DbXGX | KR001E | 2024-09-04T12:04:02.254Z | 2024-09-06T12:03:18.809Z |
4961855 | 4961855 | 20240811181001_CCU9l | KR001E | 2024-09-04T12:03:58.822Z | 2024-09-06T12:03:17.392Z |
4961838 | 4961838 | 20240811180852_r5Wvv | KR001E | 2024-09-04T12:03:57.929Z | 2024-09-06T12:03:16.679Z |
4961728 | 4961728 | 20240811175911_2sbOL | KR001E | 2024-09-04T12:03:52.401Z | 2024-09-06T12:03:11.938Z |
4961705 | 4961705 | 20240811175807_BPOHN | KR001E | 2024-09-04T12:03:51.579Z | 2024-09-06T12:03:11.207Z |
4961691 | 4961691 | 20240811175653_R9i5m | KR001E | 2024-09-04T12:03:50.779Z | 2024-09-06T12:03:10.535Z |
4961608 | 4961608 | 20240811175152_uoZ1J | KR001E | 2024-09-04T12:03:47.089Z | 2024-09-06T12:03:07.332Z |
4961555 | 4961555 | 20240811174744_7XW7T | KR001E | 2024-09-04T12:03:45.123Z | 2024-09-06T12:03:05.046Z |
4961419 | 4961419 | 20240811173953_wIxTv | KR001E | 2024-09-04T12:03:36.862Z | 2024-09-06T12:02:56.727Z |
4961367 | 4961367 | 20240811173435_3qvRa | KR001E | 2024-09-04T12:03:33.537Z | 2024-09-06T12:02:53.937Z |
4961215 | 4961215 | 20240811172434_83EvN | KR001E | 2024-09-04T12:03:23.178Z | 2024-09-06T12:02:47.843Z |
4961169 | 4961169 | 20240811172117_FSq6N | KR001E | 2024-09-04T12:03:21.202Z | 2024-09-06T12:02:46.213Z |
4961145 | 4961145 | 20240811171938_b8yo5 | KR001E | 2024-09-04T12:03:19.833Z | 2024-09-06T12:02:45.212Z |
4961139 | 4961139 | 20240811171926_JoiLX | KR001E | 2024-09-04T12:03:19.693Z | 2024-09-06T12:02:45.107Z |
4961110 | 4961110 | 20240811171804_IWCMQ | KR001E | 2024-09-04T12:03:17.654Z | 2024-09-06T12:02:43.926Z |
4961076 | 4961076 | 20240811171533_zmuLO | KR001E | 2024-09-04T12:03:16.081Z | 2024-09-06T12:02:42.898Z |
4961026 | 4961026 | 20240811171108_MhlXG | KR001E | 2024-09-04T12:03:12.503Z | 2024-09-06T12:02:39.995Z |
4961004 | 4961004 | 20240811170844_4EV6o | KR001E | 2024-09-04T12:03:10.816Z | 2024-09-06T12:02:38.821Z |
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);