participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
996 rows where station_code = "KR002G" 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 |
---|---|---|---|---|---|
5124108 | 5124108 | 20240914150833_XVxA0 | KR002G | 2024-09-18T12:12:07.570Z | 2024-09-18T12:12:29.045Z |
5111149 | 5111149 | 20240914200822_7ApVi | KR002G | 2024-09-18T12:01:40.777Z | 2024-09-18T12:12:17.945Z |
5110653 | 5110653 | 20240914174914_23OME | KR002G | 2024-09-18T12:00:38.580Z | 2024-09-18T12:12:17.818Z |
5052135 | 5052135 | 20240907194402_D3nKf | KR002G | 2024-09-13T12:14:58.198Z | 2024-09-16T12:21:03.956Z |
5050957 | 5050957 | 20240907162934_EaWRY | KR002G | 2024-09-13T12:13:54.824Z | 2024-09-16T12:20:59.399Z |
5042618 | 5042618 | 20240907120919_i082R | KR002G | 2024-09-12T12:17:15.824Z | 2024-09-16T12:20:53.752Z |
4963043 | 4963043 | 20240811193846_Pvw2P | KR002G | 2024-09-04T12:05:07.538Z | 2024-09-06T12:04:15.757Z |
4962886 | 4962886 | 20240811193001_Zw3ar | KR002G | 2024-09-04T12:04:57.604Z | 2024-09-06T12:04:10.171Z |
4962819 | 4962819 | 20240811192526_2FvMf | KR002G | 2024-09-04T12:04:54.375Z | 2024-09-06T12:04:07.266Z |
4962706 | 4962706 | 20240811191711_3CnzG | KR002G | 2024-09-04T12:04:48.119Z | 2024-09-06T12:03:59.174Z |
4962676 | 4962676 | 20240811191603_0s6pa | KR002G | 2024-09-04T12:04:46.764Z | 2024-09-06T12:03:55.907Z |
4962672 | 4962672 | 20240811191559_R3kZ1 | KR002G | 2024-09-04T12:04:46.594Z | 2024-09-06T12:03:55.772Z |
4962568 | 4962568 | 20240811190920_ch9lF | KR002G | 2024-09-04T12:04:38.926Z | 2024-09-06T12:03:51.538Z |
4962547 | 4962547 | 20240811190720_Ar0Bg | KR002G | 2024-09-04T12:04:38.238Z | 2024-09-06T12:03:50.685Z |
4962494 | 4962494 | 20240811190244_PFq5s | KR002G | 2024-09-04T12:04:35.641Z | 2024-09-06T12:03:48.593Z |
4962447 | 4962447 | 20240811185800_TB0zf | KR002G | 2024-09-04T12:04:30.996Z | 2024-09-06T12:03:46.607Z |
4962384 | 4962384 | 20240811185225_tqDbA | KR002G | 2024-09-04T12:04:27.714Z | 2024-09-06T12:03:44.127Z |
4962342 | 4962342 | 20240811184955_jPdhX | KR002G | 2024-09-04T12:04:26.005Z | 2024-09-06T12:03:42.664Z |
4962286 | 4962286 | 20240811184618_UKP3O | KR002G | 2024-09-04T12:04:23.800Z | 2024-09-06T12:03:38.957Z |
4962210 | 4962210 | 20240811184138_quX4q | KR002G | 2024-09-04T12:04:21.051Z | 2024-09-06T12:03:33.536Z |
4962199 | 4962199 | 20240811184116_Dmsz2 | KR002G | 2024-09-04T12:04:20.705Z | 2024-09-06T12:03:33.177Z |
4962190 | 4962190 | 20240811184037_iHma3 | KR002G | 2024-09-04T12:04:20.424Z | 2024-09-06T12:03:32.926Z |
4962179 | 4962179 | 20240811183925_Oy2zI | KR002G | 2024-09-04T12:04:19.929Z | 2024-09-06T12:03:32.387Z |
4962106 | 4962106 | 20240811183548_hBCQ2 | KR002G | 2024-09-04T12:04:16.471Z | 2024-09-06T12:03:29.557Z |
4962087 | 4962087 | 20240811183403_5UkY5 | KR002G | 2024-09-04T12:04:15.489Z | 2024-09-06T12:03:27.660Z |
4961999 | 4961999 | 20240811182314_QauNg | KR002G | 2024-09-04T12:04:08.738Z | 2024-09-06T12:03:23.143Z |
4961951 | 4961951 | 20240811181952_FWTFq | KR002G | 2024-09-04T12:04:05.375Z | 2024-09-06T12:03:21.482Z |
4961910 | 4961910 | 20240811181543_n26J4 | KR002G | 2024-09-04T12:04:03.282Z | 2024-09-06T12:03:19.715Z |
4961864 | 4961864 | 20240811181115_UniBQ | KR002G | 2024-09-04T12:03:59.376Z | 2024-09-06T12:03:17.921Z |
4961827 | 4961827 | 20240811180735_VJrYO | KR002G | 2024-09-04T12:03:57.230Z | 2024-09-06T12:03:16.149Z |
4961820 | 4961820 | 20240811180658_zyhW4 | KR002G | 2024-09-04T12:03:56.980Z | 2024-09-06T12:03:15.982Z |
4961661 | 4961661 | 20240811175420_3KJNQ | KR002G | 2024-09-04T12:03:49.121Z | 2024-09-06T12:03:09.004Z |
4961561 | 4961561 | 20240811174750_rrFGL | KR002G | 2024-09-04T12:03:45.304Z | 2024-09-06T12:03:05.170Z |
4961550 | 4961550 | 20240811174640_lu1Tz | KR002G | 2024-09-04T12:03:44.808Z | 2024-09-06T12:03:04.781Z |
4961492 | 4961492 | 20240811174354_32Kwb | KR002G | 2024-09-04T12:03:42.528Z | 2024-09-06T12:03:02.905Z |
4961434 | 4961434 | 20240811174058_m2M15 | KR002G | 2024-09-04T12:03:38.274Z | 2024-09-06T12:02:57.914Z |
4961429 | 4961429 | 20240811174048_OLE75 | KR002G | 2024-09-04T12:03:38.019Z | 2024-09-06T12:02:57.725Z |
4961296 | 4961296 | 20240811173011_fR25C | KR002G | 2024-09-04T12:03:27.557Z | 2024-09-06T12:02:51.417Z |
4961288 | 4961288 | 20240811172933_cDomk | KR002G | 2024-09-04T12:03:27.032Z | 2024-09-06T12:02:51.018Z |
4961250 | 4961250 | 20240811172648_CMXgl | KR002G | 2024-09-04T12:03:24.732Z | 2024-09-06T12:02:49.169Z |
4961103 | 4961103 | 20240811171701_tkw6r | KR002G | 2024-09-04T12:03:17.259Z | 2024-09-06T12:02:43.633Z |
4961035 | 4961035 | 20240811171226_cRPGJ | KR002G | 2024-09-04T12:03:13.150Z | 2024-09-06T12:02:40.436Z |
4960933 | 4960933 | 20240811170336_8E3ZT | KR002G | 2024-09-04T12:03:06.563Z | 2024-09-06T12:02:33.863Z |
4960842 | 4960842 | 20240811165420_RF2JI | KR002G | 2024-09-04T12:02:58.228Z | 2024-09-06T12:02:28.976Z |
4960804 | 4960804 | 20240811164900_Z9NYv | KR002G | 2024-09-04T12:02:55.551Z | 2024-09-06T12:02:26.884Z |
4960688 | 4960688 | 20240811164227_0QcvP | KR002G | 2024-09-04T12:02:49.794Z | 2024-09-06T12:02:22.104Z |
4960662 | 4960662 | 20240811164109_t8Cot | KR002G | 2024-09-04T12:02:48.684Z | 2024-09-06T12:02:21.151Z |
4960642 | 4960642 | 20240811163952_mFq0o | KR002G | 2024-09-04T12:02:47.913Z | 2024-09-06T12:02:20.537Z |
4960559 | 4960559 | 20240811163407_QSAT1 | KR002G | 2024-09-04T12:02:42.489Z | 2024-09-06T12:02:15.956Z |
4960508 | 4960508 | 20240811162851_GaCW2 | KR002G | 2024-09-04T12:02:37.453Z | 2024-09-06T12:02:13.855Z |
4960067 | 4960067 | 20240811155824_ATtmt | KR002G | 2024-09-04T12:02:09.655Z | 2024-09-06T12:01:50.737Z |
4960022 | 4960022 | 20240811155706_sJE28 | KR002G | 2024-09-04T12:02:07.663Z | 2024-09-06T12:01:47.851Z |
4959984 | 4959984 | 20240811155313_kJ8hA | KR002G | 2024-09-04T12:02:05.465Z | 2024-09-06T12:01:45.896Z |
4959924 | 4959924 | 20240811154918_d532g | KR002G | 2024-09-04T12:02:02.871Z | 2024-09-06T12:01:43.505Z |
4959913 | 4959913 | 20240811154800_2C2BS | KR002G | 2024-09-04T12:02:02.430Z | 2024-09-06T12:01:42.963Z |
4959840 | 4959840 | 20240811154112_9iANb | KR002G | 2024-09-04T12:01:58.429Z | 2024-09-06T12:01:39.576Z |
4959737 | 4959737 | 20240811153255_ruabp | KR002G | 2024-09-04T12:01:52.785Z | 2024-09-06T12:01:34.858Z |
4959639 | 4959639 | 20240811152315_6h0qB | KR002G | 2024-09-04T12:01:46.120Z | 2024-09-06T12:01:28.436Z |
4959617 | 4959617 | 20240811152230_r6u18 | KR002G | 2024-09-04T12:01:45.246Z | 2024-09-06T12:01:27.152Z |
4959556 | 4959556 | 20240811151758_adyKd | KR002G | 2024-09-04T12:01:41.474Z | 2024-09-06T12:01:23.057Z |
4959519 | 4959519 | 20240811151310_nlazv | KR002G | 2024-09-04T12:01:39.171Z | 2024-09-06T12:01:20.582Z |
4959234 | 4959234 | 20240811122135_ORli2 | KR002G | 2024-09-03T12:23:11.271Z | 2024-09-06T12:32:37.485Z |
4951993 | 4951993 | 20240811145146_WiM2V | KR002G | 2024-09-03T12:01:42.140Z | 2024-09-06T12:01:10.125Z |
4951885 | 4951885 | 20240811144116_bs1dL | KR002G | 2024-09-03T12:01:32.545Z | 2024-09-06T12:01:03.796Z |
4951875 | 4951875 | 20240811144106_WvwWv | KR002G | 2024-09-03T12:01:31.583Z | 2024-09-06T12:01:03.259Z |
4951596 | 4951596 | 20240811140355_zwxeO | KR002G | 2024-09-03T12:01:10.607Z | 2024-09-06T12:00:49.099Z |
4951555 | 4951555 | 20240811140034_G3Fk1 | KR002G | 2024-09-03T12:01:08.579Z | 2024-09-06T12:00:47.920Z |
4951519 | 4951519 | 20240811135801_yAbpF | KR002G | 2024-09-03T12:01:06.775Z | 2024-09-06T12:00:47.110Z |
4951332 | 4951332 | 20240811133056_EeZJ1 | KR002G | 2024-09-03T12:00:51.758Z | 2024-09-06T12:00:38.740Z |
4935163 | 4935163 | 20240810194518_R0MJh | KR002G | 2024-09-01T12:06:09.630Z | 2024-09-06T12:20:28.737Z |
4934994 | 4934994 | 20240810192548_NJf5J | KR002G | 2024-09-01T12:05:59.792Z | 2024-09-06T12:20:25.085Z |
4934990 | 4934990 | 20240810192530_hciXB | KR002G | 2024-09-01T12:05:59.561Z | 2024-09-06T12:20:24.961Z |
4934946 | 4934946 | 20240810192208_51MkF | KR002G | 2024-09-01T12:05:57.163Z | 2024-09-06T12:20:24.195Z |
4934923 | 4934923 | 20240810191738_xGgMj | KR002G | 2024-09-01T12:05:55.808Z | 2024-09-06T12:20:23.448Z |
4934918 | 4934918 | 20240810191718_jFYKO | KR002G | 2024-09-01T12:05:55.669Z | 2024-09-06T12:20:23.409Z |
4934814 | 4934814 | 20240810190724_QfYHb | KR002G | 2024-09-01T12:05:50.124Z | 2024-09-06T12:20:21.123Z |
4934739 | 4934739 | 20240810185324_zdMe6 | KR002G | 2024-09-01T12:05:44.521Z | 2024-09-06T12:20:19.396Z |
4934668 | 4934668 | 20240810184616_DW1Ra | KR002G | 2024-09-01T12:05:38.232Z | 2024-09-06T12:20:17.680Z |
4934664 | 4934664 | 20240810184542_GQhM4 | KR002G | 2024-09-01T12:05:37.997Z | 2024-09-06T12:20:17.547Z |
4934565 | 4934565 | 20240810183132_D5LV0 | KR002G | 2024-09-01T12:05:31.390Z | 2024-09-06T12:20:14.923Z |
4934532 | 4934532 | 20240810182632_0fZpR | KR002G | 2024-09-01T12:05:29.172Z | 2024-09-06T12:20:14.102Z |
4934460 | 4934460 | 20240810181929_j6J3t | KR002G | 2024-09-01T12:05:23.826Z | 2024-09-06T12:20:12.383Z |
4934363 | 4934363 | 20240810180758_Tgvhf | KR002G | 2024-09-01T12:05:12.913Z | 2024-09-06T12:20:09.751Z |
4934323 | 4934323 | 20240810180326_INkJM | KR002G | 2024-09-01T12:05:09.570Z | 2024-09-06T12:20:08.752Z |
4934305 | 4934305 | 20240810180305_EObED | KR002G | 2024-09-01T12:05:08.644Z | 2024-09-06T12:20:08.395Z |
4933383 | 4933383 | 20240810170028_K3hdb | KR002G | 2024-09-01T12:04:16.650Z | 2024-09-06T12:19:09.767Z |
4933310 | 4933310 | 20240810165607_w9kcJ | KR002G | 2024-09-01T12:04:12.036Z | 2024-09-06T12:19:04.297Z |
4932481 | 4932481 | 20240810160022_wI23T | KR002G | 2024-09-01T12:03:23.968Z | 2024-09-06T12:18:40.134Z |
4932319 | 4932319 | 20240810155131_OPWv1 | KR002G | 2024-09-01T12:03:15.294Z | 2024-09-06T12:18:36.052Z |
4932184 | 4932184 | 20240810154402_qO5nN | KR002G | 2024-09-01T12:03:06.766Z | 2024-09-06T12:18:29.330Z |
4932088 | 4932088 | 20240810153611_wJO3q | KR002G | 2024-09-01T12:03:00.282Z | 2024-09-06T12:18:20.924Z |
4924958 | 4924958 | 20240810142642_RK72w | KR002G | 2024-08-31T12:02:45.872Z | 2024-09-06T12:17:17.769Z |
4924819 | 4924819 | 20240810141423_WyPxG | KR002G | 2024-08-31T12:02:34.266Z | 2024-09-06T12:17:13.041Z |
4850696 | 4850696 | 20240805193851_icliF | KR002G | 2024-08-17T12:13:34.469Z | 2024-08-19T12:23:18.943Z |
4850651 | 4850651 | 20240805193247_CJd0H | KR002G | 2024-08-17T12:13:30.686Z | 2024-08-19T12:23:16.293Z |
4850290 | 4850290 | 20240805184034_PmPvr | KR002G | 2024-08-17T12:12:51.994Z | 2024-08-19T12:22:55.193Z |
4850254 | 4850254 | 20240805183310_3IJS8 | KR002G | 2024-08-17T12:12:47.266Z | 2024-08-19T12:22:52.682Z |
4850120 | 4850120 | 20240805182551_OrwMY | KR002G | 2024-08-17T12:12:38.805Z | 2024-08-19T12:22:45.513Z |
4849934 | 4849934 | 20240805181226_iL3G1 | KR002G | 2024-08-17T12:12:26.559Z | 2024-08-19T12:22:37.152Z |
4844842 | 4844842 | 20240805151552_P0kga | KR002G | 2024-08-16T12:08:39.346Z | 2024-08-19T12:19:51.540Z |
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);