participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,421 rows where station_code = "KR001A" 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 |
---|---|---|---|---|---|
5547905 | 5547905 | 20241117202930_0nbcj | KR001A | 2024-11-18T14:06:48.920Z | 2024-11-22T14:22:45.484Z |
5547888 | 5547888 | 20241117202435_yWkWY | KR001A | 2024-11-18T14:06:48.079Z | 2024-11-22T14:22:45.429Z |
5547877 | 5547877 | 20241117202007_UBiep | KR001A | 2024-11-18T14:06:47.093Z | 2024-11-22T14:22:45.342Z |
5547862 | 5547862 | 20241117201416_nP6w1 | KR001A | 2024-11-18T14:06:45.906Z | 2024-11-22T14:22:45.267Z |
5547857 | 5547857 | 20241117201341_EfAap | KR001A | 2024-11-18T14:06:45.670Z | 2024-11-22T14:22:45.254Z |
5547723 | 5547723 | 20241117192012_8n7eI | KR001A | 2024-11-18T14:06:22.209Z | 2024-11-22T14:22:43.021Z |
5547676 | 5547676 | 20241117190227_UUcSv | KR001A | 2024-11-18T14:06:15.678Z | 2024-11-22T14:22:42.509Z |
5547667 | 5547667 | 20241117185848_oIJTj | KR001A | 2024-11-18T14:06:14.762Z | 2024-11-22T14:22:42.432Z |
5547529 | 5547529 | 20241117173704_tx673 | KR001A | 2024-11-18T14:06:01.002Z | 2024-11-22T14:22:40.605Z |
5547391 | 5547391 | 20241117160651_7ADGE | KR001A | 2024-11-18T14:05:39.055Z | 2024-11-22T14:22:39.493Z |
5500847 | 5500847 | 20241108175856_469T1 | KR001A | 2024-11-09T14:07:15.529Z | 2024-11-17T14:23:30.034Z |
5393866 | 5393866 | 20241025190146_ToSiS | KR001A | 2024-10-28T12:13:42.257Z | 2024-11-03T14:27:18.705Z |
5381557 | 5381557 | 20241025202400_cZ4bP | KR001A | 2024-10-27T12:08:43.932Z | 2024-11-03T14:27:21.050Z |
5325867 | 5325867 | 20241020180047_11VnB | KR001A | 2024-10-21T12:07:01.957Z | 2024-10-29T12:26:32.627Z |
4491557 | 4491557 | 20240620184350_DjZNz | KR001A | 2024-06-22T12:04:26.484Z | 2024-06-29T12:13:29.873Z |
4491235 | 4491235 | 20240620175336_Fz90n | KR001A | 2024-06-22T12:03:53.321Z | 2024-06-29T12:13:28.258Z |
4487798 | 4487798 | 20240619190235_D4PZq | KR001A | 2024-06-21T12:04:23.437Z | 2024-06-28T12:09:34.519Z |
4487722 | 4487722 | 20240619183841_x2Qij | KR001A | 2024-06-21T12:04:17.215Z | 2024-06-28T12:09:34.346Z |
4487680 | 4487680 | 20240619182913_zH9Ks | KR001A | 2024-06-21T12:04:14.363Z | 2024-06-28T12:09:34.249Z |
4487574 | 4487574 | 20240619181457_v2DMN | KR001A | 2024-06-21T12:04:09.278Z | 2024-06-28T12:09:33.992Z |
4487536 | 4487536 | 20240619180345_eZ83X | KR001A | 2024-06-21T12:04:06.613Z | 2024-06-28T12:09:33.889Z |
4484086 | 4484086 | 20240618183847_3E4RG | KR001A | 2024-06-20T12:05:02.211Z | 2024-06-27T12:11:27.342Z |
4484030 | 4484030 | 20240618182935_xsx2M | KR001A | 2024-06-20T12:04:56.103Z | 2024-06-27T12:11:26.993Z |
4483816 | 4483816 | 20240618180114_DwKJn | KR001A | 2024-06-20T12:04:38.612Z | 2024-06-27T12:11:25.338Z |
4483805 | 4483805 | 20240618180032_yUWAM | KR001A | 2024-06-20T12:04:38.111Z | 2024-06-27T12:11:25.300Z |
4483782 | 4483782 | 20240618175740_2L3ZZ | KR001A | 2024-06-20T12:04:37.347Z | 2024-06-27T12:11:25.158Z |
4479904 | 4479904 | 20240616190031_NMLno | KR001A | 2024-06-19T12:09:57.021Z | 2024-06-24T12:11:48.817Z |
4479607 | 4479607 | 20240616180133_dGHOb | KR001A | 2024-06-19T12:09:38.077Z | 2024-06-24T12:11:42.667Z |
4479590 | 4479590 | 20240616180008_23oZK | KR001A | 2024-06-19T12:09:37.359Z | 2024-06-24T12:11:42.449Z |
4477817 | 4477817 | 20240617184738_P2Ob7 | KR001A | 2024-06-19T12:06:01.829Z | 2024-06-26T12:14:36.697Z |
4477780 | 4477780 | 20240617183841_5TtLO | KR001A | 2024-06-19T12:05:59.783Z | 2024-06-26T12:14:35.903Z |
4477768 | 4477768 | 20240617183738_o03mL | KR001A | 2024-06-19T12:05:59.009Z | 2024-06-26T12:14:35.845Z |
4477689 | 4477689 | 20240617182645_p7Yuj | KR001A | 2024-06-19T12:05:49.045Z | 2024-06-26T12:14:35.448Z |
4477612 | 4477612 | 20240617181445_xcB3K | KR001A | 2024-06-19T12:05:36.704Z | 2024-06-26T12:14:35.161Z |
4477558 | 4477558 | 20240617180807_FUfwg | KR001A | 2024-06-19T12:05:30.633Z | 2024-06-26T12:14:34.688Z |
4477503 | 4477503 | 20240617180214_ECJd9 | KR001A | 2024-06-19T12:05:27.681Z | 2024-06-26T12:14:33.941Z |
4477260 | 4477260 | 20240617171926_2JUt1 | KR001A | 2024-06-19T12:05:09.689Z | 2024-06-26T12:14:32.109Z |
4477165 | 4477165 | 20240617170610_YkTmU | KR001A | 2024-06-19T12:05:03.602Z | 2024-06-26T12:14:31.424Z |
4477073 | 4477073 | 20240617165628_N9c3l | KR001A | 2024-06-19T12:04:47.037Z | 2024-06-26T12:14:29.893Z |
4477066 | 4477066 | 20240617165614_jOFJL | KR001A | 2024-06-19T12:04:46.824Z | 2024-06-26T12:14:29.866Z |
4477063 | 4477063 | 20240617165614_GetBE | KR001A | 2024-06-19T12:04:46.600Z | 2024-06-26T12:14:29.834Z |
4474220 | 4474220 | 20240616174011_6G0GV | KR001A | 2024-06-18T12:04:58.130Z | 2024-06-24T12:11:40.568Z |
4474201 | 4474201 | 20240616173843_xFjTD | KR001A | 2024-06-18T12:04:57.125Z | 2024-06-24T12:11:40.365Z |
4474145 | 4474145 | 20240616172708_4z2TB | KR001A | 2024-06-18T12:04:52.323Z | 2024-06-24T12:11:39.360Z |
4474101 | 4474101 | 20240616172106_NMrVQ | KR001A | 2024-06-18T12:04:50.469Z | 2024-06-24T12:11:38.682Z |
4473966 | 4473966 | 20240616165116_GMWZM | KR001A | 2024-06-18T12:04:41.685Z | 2024-06-24T12:11:36.528Z |
4473952 | 4473952 | 20240616165041_feBBb | KR001A | 2024-06-18T12:04:41.236Z | 2024-06-24T12:11:35.417Z |
4473864 | 4473864 | 20240616162927_kbuh8 | KR001A | 2024-06-18T12:04:35.777Z | 2024-06-24T12:11:34.820Z |
4473439 | 4473439 | 20240616131913_GXdpX | KR001A | 2024-06-18T12:03:56.934Z | 2024-06-24T12:11:27.951Z |
4473408 | 4473408 | 20240616130149_3DXf3 | KR001A | 2024-06-18T12:03:53.507Z | 2024-06-24T12:11:27.352Z |
4462741 | 4462741 | 20240613173656_sWWJR | KR001A | 2024-06-15T12:09:07.168Z | 2024-06-21T12:11:47.385Z |
4462715 | 4462715 | 20240613173244_1tsD3 | KR001A | 2024-06-15T12:09:05.922Z | 2024-06-21T12:11:47.365Z |
4462161 | 4462161 | 20240613160926_aSsVb | KR001A | 2024-06-15T12:08:11.032Z | 2024-06-21T12:11:46.401Z |
4462155 | 4462155 | 20240613160848_x87c3 | KR001A | 2024-06-15T12:08:10.778Z | 2024-06-21T12:11:46.400Z |
4462024 | 4462024 | 20240613153555_5Gl32 | KR001A | 2024-06-15T12:08:00.007Z | 2024-06-21T12:11:46.173Z |
4461701 | 4461701 | 20240613133243_rljN8 | KR001A | 2024-06-15T12:07:25.659Z | 2024-06-21T12:11:45.085Z |
4461655 | 4461655 | 20240613132009_Agu6r | KR001A | 2024-06-15T12:07:20.902Z | 2024-06-21T12:11:44.767Z |
4458816 | 4458816 | 20240612154023_hoh73 | KR001A | 2024-06-14T12:05:11.189Z | 2024-06-20T12:12:04.201Z |
4458597 | 4458597 | 20240612144114_8x5WO | KR001A | 2024-06-14T12:04:58.668Z | 2024-06-20T12:12:03.934Z |
4454975 | 4454975 | 20240611184314_pHOPf | KR001A | 2024-06-13T12:06:21.810Z | 2024-06-19T12:13:49.183Z |
4454823 | 4454823 | 20240611182526_mATF2 | KR001A | 2024-06-13T12:06:18.919Z | 2024-06-19T12:13:48.612Z |
4454775 | 4454775 | 20240611182102_gzexb | KR001A | 2024-06-13T12:06:18.165Z | 2024-06-19T12:13:48.588Z |
4441866 | 4441866 | 20240609185734_dF9E4 | KR001A | 2024-06-11T12:00:44.503Z | 2024-06-18T12:11:01.539Z |
4441773 | 4441773 | 20240609181456_k9Mha | KR001A | 2024-06-11T12:00:33.579Z | 2024-06-18T12:11:01.288Z |
4441711 | 4441711 | 20240609175040_OoBKc | KR001A | 2024-06-11T12:00:26.231Z | 2024-06-18T12:11:01.167Z |
4441578 | 4441578 | 20240609171000_mhISC | KR001A | 2024-06-11T12:00:12.371Z | 2024-06-18T12:11:00.811Z |
4439830 | 4439830 | 20240609141336_3AnOX | KR001A | 2024-06-10T12:02:37.863Z | 2024-06-17T12:15:22.490Z |
4439759 | 4439759 | 20240609134033_0fJFL | KR001A | 2024-06-10T12:02:35.558Z | 2024-06-17T12:15:22.040Z |
4430936 | 4430936 | 20240606132829_a5wfw | KR001A | 2024-06-08T12:10:27.574Z | 2024-06-14T12:08:32.051Z |
4426914 | 4426914 | 20240606183215_Sz6Li | KR001A | 2024-06-08T12:03:47.680Z | 2024-06-15T12:16:48.786Z |
4426885 | 4426885 | 20240606183001_1m8te | KR001A | 2024-06-08T12:03:46.560Z | 2024-06-15T12:16:48.763Z |
4426682 | 4426682 | 20240606181035_mp7kf | KR001A | 2024-06-08T12:03:25.038Z | 2024-06-15T12:16:48.096Z |
4426445 | 4426445 | 20240606174959_qPFvB | KR001A | 2024-06-08T12:03:00.711Z | 2024-06-15T12:16:47.271Z |
4426240 | 4426240 | 20240606171406_iUY6G | KR001A | 2024-06-08T12:02:41.773Z | 2024-06-15T12:16:46.618Z |
4421890 | 4421890 | 20240604161555_vui24 | KR001A | 2024-06-07T12:08:16.137Z | 2024-06-13T12:08:29.327Z |
4415735 | 4415735 | 20240604190016_Xwg1i | KR001A | 2024-06-06T12:05:14.797Z | 2024-06-13T12:08:30.262Z |
4415690 | 4415690 | 20240604184040_NzNDo | KR001A | 2024-06-06T12:05:11.867Z | 2024-06-13T12:08:30.193Z |
4415660 | 4415660 | 20240604183608_lpEKl | KR001A | 2024-06-06T12:05:10.583Z | 2024-06-13T12:08:30.179Z |
4415186 | 4415186 | 20240604172558_Zilky | KR001A | 2024-06-06T12:04:24.652Z | 2024-06-13T12:08:29.751Z |
4414883 | 4414883 | 20240604163958_ecqef | KR001A | 2024-06-06T12:03:49.793Z | 2024-06-13T12:08:29.523Z |
4414687 | 4414687 | 20240604162406_dwyKr | KR001A | 2024-06-06T12:03:39.078Z | 2024-06-13T12:08:29.357Z |
4414645 | 4414645 | 20240604161900_QWmAR | KR001A | 2024-06-06T12:03:36.710Z | 2024-06-13T12:08:29.339Z |
4414615 | 4414615 | 20240604161554_xJOoO | KR001A | 2024-06-06T12:03:35.709Z | 2024-06-13T12:08:29.320Z |
4414474 | 4414474 | 20240604155847_hvB1Z | KR001A | 2024-06-06T12:03:26.491Z | 2024-06-13T12:08:29.217Z |
4414222 | 4414222 | 20240604153550_RQEQ1 | KR001A | 2024-06-06T12:02:56.360Z | 2024-06-13T12:08:29.061Z |
4414031 | 4414031 | 20240604151304_zPNwL | KR001A | 2024-06-06T12:02:41.145Z | 2024-06-13T12:08:28.933Z |
4413398 | 4413398 | 20240604135047_FZ2lE | KR001A | 2024-06-06T12:01:37.927Z | 2024-06-13T12:08:28.509Z |
4412695 | 4412695 | 20240604120602_dvU4a | KR001A | 2024-06-06T12:00:26.979Z | 2024-06-13T12:08:28.062Z |
4411133 | 4411133 | 20240603184629_0ax90 | KR001A | 2024-06-05T12:06:20.806Z | 2024-06-12T12:10:36.766Z |
4410919 | 4410919 | 20240603182049_do3R3 | KR001A | 2024-06-05T12:06:08.462Z | 2024-06-12T12:10:36.174Z |
4410832 | 4410832 | 20240603180845_UI2UW | KR001A | 2024-06-05T12:05:59.035Z | 2024-06-12T12:10:35.924Z |
4410822 | 4410822 | 20240603180752_BkExI | KR001A | 2024-06-05T12:05:57.370Z | 2024-06-12T12:10:35.898Z |
4410621 | 4410621 | 20240603173114_x3fgS | KR001A | 2024-06-05T12:05:33.908Z | 2024-06-12T12:10:35.002Z |
4410592 | 4410592 | 20240603172943_ak4OE | KR001A | 2024-06-05T12:05:33.034Z | 2024-06-12T12:10:34.980Z |
4410547 | 4410547 | 20240603172749_NUYxZ | KR001A | 2024-06-05T12:05:30.950Z | 2024-06-12T12:10:34.903Z |
4410383 | 4410383 | 20240603170617_x8N9O | KR001A | 2024-06-05T12:05:20.831Z | 2024-06-12T12:10:34.677Z |
4410101 | 4410101 | 20240603163633_ifPGA | KR001A | 2024-06-05T12:04:49.822Z | 2024-06-12T12:10:34.216Z |
4409432 | 4409432 | 20240603150103_cG68Z | KR001A | 2024-06-05T12:03:32.676Z | 2024-06-12T12:10:33.139Z |
4409155 | 4409155 | 20240603141358_YZRis | KR001A | 2024-06-05T12:02:54.457Z | 2024-06-12T12:10:32.453Z |
4408730 | 4408730 | 20240603131111_am5Zf | KR001A | 2024-06-05T12:02:04.447Z | 2024-06-12T12:10:31.570Z |
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);