participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,187 rows where station_code = "KR0022" 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 |
---|---|---|---|---|---|
5070453 | 5070453 | 20240909125444_QzMXd | KR0022 | 2024-09-14T12:21:21.940Z | 2024-09-16T12:20:45.808Z |
5069045 | 5069045 | 20240910133018_vt1fn | KR0022 | 2024-09-14T12:19:24.745Z | 2024-09-16T12:20:16.256Z |
5069026 | 5069026 | 20240910132514_UnrSB | KR0022 | 2024-09-14T12:19:24.133Z | 2024-09-16T12:20:16.183Z |
5068858 | 5068858 | 20240910125016_0XmdD | KR0022 | 2024-09-14T12:19:22.248Z | 2024-09-16T12:20:15.476Z |
5063088 | 5063088 | 20240909194919_BeMJp | KR0022 | 2024-09-14T12:13:26.044Z | 2024-09-16T12:19:41.578Z |
5062986 | 5062986 | 20240909193000_sMiEh | KR0022 | 2024-09-14T12:13:13.872Z | 2024-09-16T12:19:40.711Z |
5062981 | 5062981 | 20240909192708_FOgTV | KR0022 | 2024-09-14T12:13:13.150Z | 2024-09-16T12:19:40.699Z |
5062853 | 5062853 | 20240909184205_D4Fhh | KR0022 | 2024-09-14T12:12:58.779Z | 2024-09-16T12:19:39.850Z |
5062811 | 5062811 | 20240909182852_czr3M | KR0022 | 2024-09-14T12:12:53.792Z | 2024-09-16T12:19:39.654Z |
5062755 | 5062755 | 20240909181545_YSLtT | KR0022 | 2024-09-14T12:12:47.344Z | 2024-09-16T12:19:39.243Z |
5062679 | 5062679 | 20240909180010_mu9H2 | KR0022 | 2024-09-14T12:12:42.721Z | 2024-09-16T12:19:38.636Z |
5062659 | 5062659 | 20240909175757_y6MhV | KR0022 | 2024-09-14T12:12:41.170Z | 2024-09-16T12:19:38.391Z |
5062508 | 5062508 | 20240909173426_7rKCO | KR0022 | 2024-09-14T12:12:30.175Z | 2024-09-16T12:19:37.634Z |
5061975 | 5061975 | 20240909163128_jlYeh | KR0022 | 2024-09-14T12:11:42.575Z | 2024-09-16T12:19:35.016Z |
5061970 | 5061970 | 20240909163110_13ecq | KR0022 | 2024-09-14T12:11:42.397Z | 2024-09-16T12:19:35.013Z |
5061924 | 5061924 | 20240909162328_YAbE2 | KR0022 | 2024-09-14T12:11:39.236Z | 2024-09-16T12:19:34.698Z |
5061853 | 5061853 | 20240909161129_7gt6d | KR0022 | 2024-09-14T12:11:33.343Z | 2024-09-16T12:19:34.326Z |
5061850 | 5061850 | 20240909160955_zxvVd | KR0022 | 2024-09-14T12:11:32.552Z | 2024-09-16T12:19:34.320Z |
5061627 | 5061627 | 20240909153038_33uxb | KR0022 | 2024-09-14T12:11:02.946Z | 2024-09-16T12:19:32.648Z |
5061526 | 5061526 | 20240909152043_6ByY9 | KR0022 | 2024-09-14T12:10:55.367Z | 2024-09-16T12:19:32.039Z |
5061409 | 5061409 | 20240909150405_MtuHt | KR0022 | 2024-09-14T12:10:47.860Z | 2024-09-16T12:19:31.405Z |
5061377 | 5061377 | 20240909145805_mdzcw | KR0022 | 2024-09-14T12:10:45.245Z | 2024-09-16T12:19:31.226Z |
5061107 | 5061107 | 20240909141732_42Nlj | KR0022 | 2024-09-14T12:10:17.202Z | 2024-09-16T12:19:29.312Z |
5061054 | 5061054 | 20240909135859_wVTdl | KR0022 | 2024-09-14T12:10:10.531Z | 2024-09-16T12:19:28.831Z |
5058980 | 5058980 | 20240910170547_gvM7x | KR0022 | 2024-09-14T12:05:03.561Z | 2024-09-16T12:18:00.212Z |
5058828 | 5058828 | 20240910165012_v8y3O | KR0022 | 2024-09-14T12:04:37.042Z | 2024-09-16T12:17:58.646Z |
5058598 | 5058598 | 20240910162948_VgBuE | KR0022 | 2024-09-14T12:04:06.378Z | 2024-09-16T12:17:56.396Z |
5058514 | 5058514 | 20240910161848_0YVyF | KR0022 | 2024-09-14T12:03:49.973Z | 2024-09-16T12:17:55.605Z |
5058317 | 5058317 | 20240910160218_ueR2L | KR0022 | 2024-09-14T12:03:27.654Z | 2024-09-16T12:17:52.913Z |
5058199 | 5058199 | 20240910155218_li1zq | KR0022 | 2024-09-14T12:03:08.270Z | 2024-09-16T12:17:51.692Z |
5058087 | 5058087 | 20240910154311_mWqta | KR0022 | 2024-09-14T12:02:54.089Z | 2024-09-16T12:17:50.043Z |
5057993 | 5057993 | 20240910153359_LKNCC | KR0022 | 2024-09-14T12:02:33.858Z | 2024-09-16T12:17:49.121Z |
5057938 | 5057938 | 20240910152836_8mFEJ | KR0022 | 2024-09-14T12:02:27.119Z | 2024-09-16T12:17:48.706Z |
5057764 | 5057764 | 20240910151114_2ESZ5 | KR0022 | 2024-09-14T12:01:54.675Z | 2024-09-16T12:17:47.164Z |
5057568 | 5057568 | 20240910145041_qV1aM | KR0022 | 2024-09-14T12:01:27.217Z | 2024-09-16T12:17:45.015Z |
5057431 | 5057431 | 20240910142919_ohYO8 | KR0022 | 2024-09-14T12:01:03.724Z | 2024-09-16T12:17:43.970Z |
5057427 | 5057427 | 20240910142909_58bDw | KR0022 | 2024-09-14T12:01:03.312Z | 2024-09-16T12:17:43.943Z |
5057411 | 5057411 | 20240910142420_Rk46E | KR0022 | 2024-09-14T12:01:01.246Z | 2024-09-16T12:17:43.695Z |
5057053 | 5057053 | 20240908120341_Nyymc | KR0022 | 2024-09-13T12:17:44.280Z | 2024-09-16T12:21:28.720Z |
5050316 | 5050316 | 20240907150833_hHLnn | KR0022 | 2024-09-13T12:13:24.482Z | 2024-09-16T12:20:57.044Z |
5049826 | 5049826 | 20240909114726_EPx1e | KR0022 | 2024-09-13T12:12:28.097Z | 2024-09-16T12:20:44.435Z |
5049794 | 5049794 | 20240909114142_512C2 | KR0022 | 2024-09-13T12:12:26.687Z | 2024-09-16T12:20:44.186Z |
5044514 | 5044514 | 20240908150833_nuz47 | KR0022 | 2024-09-13T12:02:18.463Z | 2024-09-16T12:20:22.470Z |
5044360 | 5044360 | 20240908145053_RU0Kz | KR0022 | 2024-09-13T12:02:02.976Z | 2024-09-16T12:20:21.688Z |
5044110 | 5044110 | 20240908141437_PhLH9 | KR0022 | 2024-09-13T12:01:29.637Z | 2024-09-16T12:20:19.919Z |
5043241 | 5043241 | 20240907141305_eaKgl | KR0022 | 2024-09-12T12:17:25.610Z | 2024-09-16T12:20:56.032Z |
5018647 | 5018647 | 20240904192205_GqpuN | KR0022 | 2024-09-10T12:11:05.988Z | 2024-09-13T12:19:48.393Z |
5018534 | 5018534 | 20240904184224_TA8uW | KR0022 | 2024-09-10T12:10:48.900Z | 2024-09-13T12:19:48.064Z |
5018517 | 5018517 | 20240904183041_3GNIk | KR0022 | 2024-09-10T12:10:45.581Z | 2024-09-13T12:19:47.997Z |
5018504 | 5018504 | 20240904182823_ToQuS | KR0022 | 2024-09-10T12:10:43.988Z | 2024-09-13T12:19:47.985Z |
5018420 | 5018420 | 20240904180232_mGfRF | KR0022 | 2024-09-10T12:10:36.038Z | 2024-09-13T12:19:47.870Z |
5018367 | 5018367 | 20240904174959_atdsV | KR0022 | 2024-09-10T12:10:31.302Z | 2024-09-13T12:19:47.657Z |
5018361 | 5018361 | 20240904174803_CRyqe | KR0022 | 2024-09-10T12:10:30.562Z | 2024-09-13T12:19:47.653Z |
5018335 | 5018335 | 20240904174346_vq03Z | KR0022 | 2024-09-10T12:10:28.999Z | 2024-09-13T12:19:47.606Z |
5018266 | 5018266 | 20240904173338_ICPR1 | KR0022 | 2024-09-10T12:10:17.924Z | 2024-09-13T12:19:47.488Z |
5018108 | 5018108 | 20240904171133_GCEtp | KR0022 | 2024-09-10T12:10:00.606Z | 2024-09-13T12:19:47.209Z |
5018068 | 5018068 | 20240904170834_meoDd | KR0022 | 2024-09-10T12:09:57.331Z | 2024-09-13T12:19:47.181Z |
5017912 | 5017912 | 20240904165257_7G7Zf | KR0022 | 2024-09-10T12:09:44.662Z | 2024-09-13T12:19:47.129Z |
5017726 | 5017726 | 20240904163630_eUN1b | KR0022 | 2024-09-10T12:09:27.390Z | 2024-09-13T12:19:47.065Z |
5017597 | 5017597 | 20240904162323_vLK20 | KR0022 | 2024-09-10T12:09:19.204Z | 2024-09-13T12:19:46.985Z |
5017520 | 5017520 | 20240904161618_ysrJq | KR0022 | 2024-09-10T12:09:13.828Z | 2024-09-13T12:19:46.901Z |
5017325 | 5017325 | 20240904155835_HRqbJ | KR0022 | 2024-09-10T12:09:03.941Z | 2024-09-13T12:19:46.794Z |
5016782 | 5016782 | 20240904145453_l3Rgp | KR0022 | 2024-09-10T12:08:17.608Z | 2024-09-13T12:19:46.311Z |
5016754 | 5016754 | 20240904144915_Y2t0O | KR0022 | 2024-09-10T12:08:14.720Z | 2024-09-13T12:19:46.260Z |
5016467 | 5016467 | 20240904141827_8TbW2 | KR0022 | 2024-09-10T12:07:51.880Z | 2024-09-13T12:19:45.782Z |
5016442 | 5016442 | 20240904141547_RO908 | KR0022 | 2024-09-10T12:07:50.294Z | 2024-09-13T12:19:45.748Z |
5016226 | 5016226 | 20240904134558_PMhGK | KR0022 | 2024-09-10T12:07:35.227Z | 2024-09-13T12:19:45.352Z |
5016108 | 5016108 | 20240904133157_wAZY6 | KR0022 | 2024-09-10T12:07:23.213Z | 2024-09-13T12:19:45.249Z |
5007106 | 5007106 | 20240903195831_VqZqi | KR0022 | 2024-09-09T12:05:26.448Z | 2024-09-12T12:19:11.379Z |
5006862 | 5006862 | 20240903191647_SmKAl | KR0022 | 2024-09-09T12:05:09.309Z | 2024-09-12T12:19:10.406Z |
5005091 | 5005091 | 20240903135801_u415A | KR0022 | 2024-09-09T12:03:19.732Z | 2024-09-12T12:19:05.245Z |
5005019 | 5005019 | 20240903134846_Jlnvv | KR0022 | 2024-09-09T12:03:16.290Z | 2024-09-12T12:19:05.158Z |
5005000 | 5005000 | 20240903134439_44orq | KR0022 | 2024-09-09T12:03:15.282Z | 2024-09-12T12:19:04.724Z |
5004977 | 5004977 | 20240903134031_531Vh | KR0022 | 2024-09-09T12:03:14.276Z | 2024-09-12T12:19:04.626Z |
5004846 | 5004846 | 20240903130509_cE609 | KR0022 | 2024-09-09T12:03:07.404Z | 2024-09-12T12:19:04.346Z |
5004592 | 5004592 | 20240903115038_3QaQ5 | KR0022 | 2024-09-09T12:02:49.787Z | 2024-09-12T12:19:03.182Z |
4987909 | 4987909 | 20240901191534_wwdLq | KR0022 | 2024-09-07T12:06:27.951Z | 2024-09-10T12:19:11.810Z |
4987719 | 4987719 | 20240901183845_WGO7C | KR0022 | 2024-09-07T12:06:09.489Z | 2024-09-10T12:19:11.202Z |
4987674 | 4987674 | 20240901182503_KzxGk | KR0022 | 2024-09-07T12:06:06.031Z | 2024-09-10T12:19:11.166Z |
4962951 | 4962951 | 20240811193437_ZioTj | KR0022 | 2024-09-04T12:05:01.220Z | 2024-09-06T12:04:12.611Z |
4962826 | 4962826 | 20240811192635_5Va02 | KR0022 | 2024-09-04T12:04:54.724Z | 2024-09-06T12:04:08.005Z |
4962512 | 4962512 | 20240811190412_F25L9 | KR0022 | 2024-09-04T12:04:36.686Z | 2024-09-06T12:03:49.364Z |
4962506 | 4962506 | 20240811190358_RYqO0 | KR0022 | 2024-09-04T12:04:36.305Z | 2024-09-06T12:03:49.092Z |
4962365 | 4962365 | 20240811185142_YCehk | KR0022 | 2024-09-04T12:04:27.053Z | 2024-09-06T12:03:43.529Z |
4962343 | 4962343 | 20240811185019_ZjKcY | KR0022 | 2024-09-04T12:04:26.160Z | 2024-09-06T12:03:42.829Z |
4962321 | 4962321 | 20240811184858_ndB9J | KR0022 | 2024-09-04T12:04:25.415Z | 2024-09-06T12:03:42.060Z |
4962157 | 4962157 | 20240811183823_tebr0 | KR0022 | 2024-09-04T12:04:19.210Z | 2024-09-06T12:03:31.836Z |
4962073 | 4962073 | 20240811183345_nC2GH | KR0022 | 2024-09-04T12:04:15.002Z | 2024-09-06T12:03:26.900Z |
4962050 | 4962050 | 20240811183234_mZckw | KR0022 | 2024-09-04T12:04:13.867Z | 2024-09-06T12:03:25.913Z |
4961993 | 4961993 | 20240811182309_212al | KR0022 | 2024-09-04T12:04:08.278Z | 2024-09-06T12:03:23.011Z |
4961964 | 4961964 | 20240811182102_Gs3VS | KR0022 | 2024-09-04T12:04:06.033Z | 2024-09-06T12:03:21.925Z |
4961931 | 4961931 | 20240811181816_aUlxi | KR0022 | 2024-09-04T12:04:04.657Z | 2024-09-06T12:03:20.957Z |
4961912 | 4961912 | 20240811181630_31YEj | KR0022 | 2024-09-04T12:04:03.419Z | 2024-09-06T12:03:19.837Z |
4961851 | 4961851 | 20240811180955_S3d3I | KR0022 | 2024-09-04T12:03:58.602Z | 2024-09-06T12:03:17.243Z |
4961839 | 4961839 | 20240811180852_r5Wvv | KR0022 | 2024-09-04T12:03:57.929Z | 2024-09-06T12:03:16.679Z |
4961807 | 4961807 | 20240811180609_BUlzQ | KR0022 | 2024-09-04T12:03:56.530Z | 2024-09-06T12:03:15.645Z |
4961781 | 4961781 | 20240811180348_UpiEN | KR0022 | 2024-09-04T12:03:55.242Z | 2024-09-06T12:03:14.540Z |
4961602 | 4961602 | 20240811175141_2uC45 | KR0022 | 2024-09-04T12:03:46.945Z | 2024-09-06T12:03:07.209Z |
4961596 | 4961596 | 20240811175128_yCXYD | KR0022 | 2024-09-04T12:03:46.812Z | 2024-09-06T12:03:07.091Z |
4961573 | 4961573 | 20240811174841_Eb4Ka | KR0022 | 2024-09-04T12:03:45.875Z | 2024-09-06T12:03:05.685Z |
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);