participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
705 rows where station_code = "KR002N" 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 |
---|---|---|---|---|---|
5554811 | 5554811 | 20241119104348_dgJbd | KR002N | 2024-11-20T14:03:21.551Z | 2024-11-22T14:19:51.911Z |
5552355 | 5552355 | 20241118205519_uUJ2d | KR002N | 2024-11-19T14:06:25.269Z | 2024-11-22T14:22:17.020Z |
5547988 | 5547988 | 20241117210553_N3f6N | KR002N | 2024-11-18T14:06:52.879Z | 2024-11-22T14:22:46.190Z |
5547537 | 5547537 | 20241117174010_p23Jw | KR002N | 2024-11-18T14:06:01.244Z | 2024-11-22T14:22:40.708Z |
5547533 | 5547533 | 20241117173704_tx673 | KR002N | 2024-11-18T14:06:01.002Z | 2024-11-22T14:22:40.605Z |
5525332 | 5525332 | 20241106173839_6IS9u | KR002N | 2024-11-12T14:25:45.194Z | 2024-11-15T14:24:43.769Z |
5503121 | 5503121 | 20241107204405_d4Mc6 | KR002N | 2024-11-09T14:12:26.146Z | 2024-11-16T14:28:03.285Z |
5502570 | 5502570 | 20241107190811_RRxH0 | KR002N | 2024-11-09T14:11:45.206Z | 2024-11-16T14:27:57.574Z |
5502244 | 5502244 | 20241107174746_kENz1 | KR002N | 2024-11-09T14:11:05.714Z | 2024-11-16T14:27:51.983Z |
5502197 | 5502197 | 20241107174013_DLVfd | KR002N | 2024-11-09T14:11:03.539Z | 2024-11-16T14:27:51.612Z |
5501973 | 5501973 | 20241107164820_R12yA | KR002N | 2024-11-09T14:10:48.375Z | 2024-11-16T14:27:49.387Z |
5501944 | 5501944 | 20241107164353_0zsW8 | KR002N | 2024-11-09T14:10:47.129Z | 2024-11-16T14:27:49.244Z |
5501923 | 5501923 | 20241107163949_5i3B4 | KR002N | 2024-11-09T14:10:45.856Z | 2024-11-16T14:27:49.100Z |
5501832 | 5501832 | 20241107161112_UgO1K | KR002N | 2024-11-09T14:10:31.761Z | 2024-11-16T14:27:48.677Z |
5500643 | 5500643 | 20241108164234_hxTWk | KR002N | 2024-11-09T14:06:50.695Z | 2024-11-17T14:23:25.894Z |
5500511 | 5500511 | 20241108155616_tqAPR | KR002N | 2024-11-09T14:06:23.618Z | 2024-11-17T14:23:23.068Z |
5495610 | 5495610 | 20241106203529_t0TKj | KR002N | 2024-11-08T14:10:28.256Z | 2024-11-15T14:24:51.496Z |
5495547 | 5495547 | 20241106201650_T5SYd | KR002N | 2024-11-08T14:10:22.938Z | 2024-11-15T14:24:50.469Z |
5495544 | 5495544 | 20241106201639_Y53cI | KR002N | 2024-11-08T14:10:22.649Z | 2024-11-15T14:24:50.457Z |
5495531 | 5495531 | 20241106201102_420bs | KR002N | 2024-11-08T14:10:21.250Z | 2024-11-15T14:24:50.318Z |
5495511 | 5495511 | 20241106200602_i4t6n | KR002N | 2024-11-08T14:10:19.538Z | 2024-11-15T14:24:50.200Z |
5495508 | 5495508 | 20241106200522_w0edL | KR002N | 2024-11-08T14:10:19.387Z | 2024-11-15T14:24:50.198Z |
5495318 | 5495318 | 20241106192310_0dWZF | KR002N | 2024-11-08T14:09:56.923Z | 2024-11-15T14:24:48.253Z |
5495086 | 5495086 | 20241106183340_B2B35 | KR002N | 2024-11-08T14:09:15.562Z | 2024-11-15T14:24:46.537Z |
5495007 | 5495007 | 20241106181444_bKCs2 | KR002N | 2024-11-08T14:09:00.813Z | 2024-11-15T14:24:45.533Z |
5494940 | 5494940 | 20241106175449_vZB0B | KR002N | 2024-11-08T14:08:51.548Z | 2024-11-15T14:24:44.659Z |
5494904 | 5494904 | 20241106174833_moqhj | KR002N | 2024-11-08T14:08:47.432Z | 2024-11-15T14:24:44.262Z |
5494897 | 5494897 | 20241106174749_Ed7N3 | KR002N | 2024-11-08T14:08:46.697Z | 2024-11-15T14:24:44.242Z |
5494892 | 5494892 | 20241106174700_lRyNT | KR002N | 2024-11-08T14:08:46.036Z | 2024-11-15T14:24:43.986Z |
5494743 | 5494743 | 20241106170913_yvlEN | KR002N | 2024-11-08T14:08:31.429Z | 2024-11-15T14:24:42.215Z |
5494609 | 5494609 | 20241106161053_Z155u | KR002N | 2024-11-08T14:08:00.495Z | 2024-11-15T14:24:40.450Z |
5494577 | 5494577 | 20241106160000_D1Rrk | KR002N | 2024-11-08T14:07:52.357Z | 2024-11-15T14:24:40.235Z |
5494379 | 5494379 | 20241106141723_BB9tN | KR002N | 2024-11-08T14:07:21.761Z | 2024-11-15T14:24:36.478Z |
5494216 | 5494216 | 20241106115821_SWYNt | KR002N | 2024-11-08T14:06:25.382Z | 2024-11-15T14:24:30.874Z |
5489388 | 5489388 | 20241105184326_TxVit | KR002N | 2024-11-07T14:11:57.937Z | 2024-11-14T14:23:12.673Z |
5489106 | 5489106 | 20241105174935_2yMkM | KR002N | 2024-11-07T14:11:18.439Z | 2024-11-14T14:23:10.462Z |
5489076 | 5489076 | 20241105174621_vr6RQ | KR002N | 2024-11-07T14:11:16.454Z | 2024-11-14T14:23:10.265Z |
5488598 | 5488598 | 20241105155505_2DVsD | KR002N | 2024-11-07T14:10:21.672Z | 2024-11-14T14:23:06.772Z |
5466606 | 5466606 | 20241102181632_KfxO2 | KR002N | 2024-11-04T14:09:24.883Z | 2024-11-11T14:22:41.623Z |
5466505 | 5466505 | 20241102175209_Xa31f | KR002N | 2024-11-04T14:09:03.002Z | 2024-11-11T14:22:41.147Z |
5466462 | 5466462 | 20241102174623_LDvy2 | KR002N | 2024-11-04T14:08:56.238Z | 2024-11-11T14:22:41.060Z |
5466220 | 5466220 | 20241102165338_u12zA | KR002N | 2024-11-04T14:08:17.965Z | 2024-11-11T14:22:39.920Z |
5466082 | 5466082 | 20241102161746_esEY3 | KR002N | 2024-11-04T14:07:58.875Z | 2024-11-11T14:22:38.835Z |
5466031 | 5466031 | 20241102160451_XNAbN | KR002N | 2024-11-04T14:07:54.368Z | 2024-11-11T14:22:38.605Z |
5438816 | 5438816 | 20241030180955_kV6kb | KR002N | 2024-11-01T12:12:28.970Z | 2024-11-08T14:23:00.870Z |
5438483 | 5438483 | 20241030172400_8jxuC | KR002N | 2024-11-01T12:11:46.514Z | 2024-11-08T14:23:00.010Z |
5438415 | 5438415 | 20241030171525_meMpz | KR002N | 2024-11-01T12:11:40.793Z | 2024-11-08T14:22:59.956Z |
5361705 | 5361705 | 20241023183846_oXgf8 | KR002N | 2024-10-25T12:13:14.722Z | 2024-11-01T12:26:50.485Z |
5361648 | 5361648 | 20241023183303_GYkh6 | KR002N | 2024-10-25T12:13:04.515Z | 2024-11-01T12:26:50.404Z |
5359368 | 5359368 | 20241023132036_QseRs | KR002N | 2024-10-25T12:08:28.262Z | 2024-11-01T12:26:45.499Z |
5322930 | 5322930 | 20241019192213_tAwkX | KR002N | 2024-10-20T12:03:33.510Z | 2024-10-28T12:26:42.187Z |
5322897 | 5322897 | 20241019182231_lK3w2 | KR002N | 2024-10-20T12:03:28.402Z | 2024-10-28T12:26:41.630Z |
5322893 | 5322893 | 20241019181947_QcDWK | KR002N | 2024-10-20T12:03:27.758Z | 2024-10-28T12:26:41.577Z |
5322888 | 5322888 | 20241019181250_DVdap | KR002N | 2024-10-20T12:03:26.915Z | 2024-10-28T12:26:41.555Z |
5299920 | 5299920 | 20241012194831_B6U2U | KR002N | 2024-10-14T12:13:17.995Z | 2024-10-21T12:23:45.029Z |
5299800 | 5299800 | 20241012193230_583FB | KR002N | 2024-10-14T12:13:09.693Z | 2024-10-21T12:23:43.800Z |
5299692 | 5299692 | 20241012192115_X0sDt | KR002N | 2024-10-14T12:12:54.059Z | 2024-10-21T12:23:43.122Z |
5299146 | 5299146 | 20241012181016_7yaGY | KR002N | 2024-10-14T12:11:57.780Z | 2024-10-21T12:23:34.941Z |
5298921 | 5298921 | 20241012173435_TivEY | KR002N | 2024-10-14T12:11:18.683Z | 2024-10-21T12:23:32.743Z |
5298504 | 5298504 | 20241012162656_hA8gF | KR002N | 2024-10-14T12:10:28.904Z | 2024-10-21T12:23:27.639Z |
5298428 | 5298428 | 20241012161934_yiVf2 | KR002N | 2024-10-14T12:10:19.992Z | 2024-10-21T12:23:27.450Z |
5298338 | 5298338 | 20241012161113_jOuzw | KR002N | 2024-10-14T12:10:12.183Z | 2024-10-21T12:23:26.726Z |
5297867 | 5297867 | 20241012144902_ihXK2 | KR002N | 2024-10-14T12:09:16.047Z | 2024-10-21T12:23:23.216Z |
5297817 | 5297817 | 20241012144141_VAj12 | KR002N | 2024-10-14T12:09:12.915Z | 2024-10-21T12:23:23.034Z |
5297320 | 5297320 | 20241012124510_Csb0W | KR002N | 2024-10-14T12:08:07.914Z | 2024-10-21T12:23:16.859Z |
5232863 | 5232863 | 20241004182753_lACyQ | KR002N | 2024-10-06T12:12:30.819Z | 2024-10-13T12:26:19.873Z |
5232692 | 5232692 | 20241004175007_1zPIY | KR002N | 2024-10-06T12:12:12.667Z | 2024-10-13T12:26:19.591Z |
5232623 | 5232623 | 20241004173018_rsi5g | KR002N | 2024-10-06T12:12:08.242Z | 2024-10-13T12:26:19.480Z |
5232574 | 5232574 | 20241004171831_DWEQz | KR002N | 2024-10-06T12:12:04.999Z | 2024-10-13T12:26:19.404Z |
5232160 | 5232160 | 20241004162329_Kh9jz | KR002N | 2024-10-06T12:11:27.618Z | 2024-10-13T12:26:18.872Z |
5231584 | 5231584 | 20241004145458_In3YP | KR002N | 2024-10-06T12:10:32.275Z | 2024-10-13T12:26:18.017Z |
5231428 | 5231428 | 20241004143106_GS63M | KR002N | 2024-10-06T12:10:21.299Z | 2024-10-13T12:26:17.875Z |
5224303 | 5224303 | 20241003202303_XoTf6 | KR002N | 2024-10-05T12:18:23.383Z | 2024-10-12T12:25:07.973Z |
5224153 | 5224153 | 20241003200934_lrlQE | KR002N | 2024-10-05T12:18:13.156Z | 2024-10-12T12:25:07.654Z |
5224034 | 5224034 | 20241003200038_dKmje | KR002N | 2024-10-05T12:18:07.934Z | 2024-10-12T12:25:07.210Z |
5224011 | 5224011 | 20241003195804_P3yH2 | KR002N | 2024-10-05T12:18:06.535Z | 2024-10-12T12:25:07.165Z |
5223931 | 5223931 | 20241003195000_XQnO7 | KR002N | 2024-10-05T12:17:58.382Z | 2024-10-12T12:25:07.132Z |
5223742 | 5223742 | 20241003192616_2uGz8 | KR002N | 2024-10-05T12:17:29.499Z | 2024-10-12T12:25:06.926Z |
5223679 | 5223679 | 20241003191958_Hw5us | KR002N | 2024-10-05T12:17:25.324Z | 2024-10-12T12:25:06.897Z |
5223306 | 5223306 | 20241003172308_Eo4Q2 | KR002N | 2024-10-05T12:16:45.679Z | 2024-10-12T12:25:05.324Z |
5209546 | 5209546 | 20241001153852_239Wh | KR002N | 2024-10-03T12:13:29.793Z | 2024-10-10T12:24:43.167Z |
5209528 | 5209528 | 20241001153020_IGAj0 | KR002N | 2024-10-03T12:13:28.558Z | 2024-10-10T12:24:43.113Z |
5209479 | 5209479 | 20241001151333_2vb1W | KR002N | 2024-10-03T12:13:21.854Z | 2024-10-10T12:24:43.057Z |
5209382 | 5209382 | 20241001140539_TKO8B | KR002N | 2024-10-03T12:12:59.319Z | 2024-10-10T12:24:42.812Z |
5209378 | 5209378 | 20241001140456_RQ0Qb | KR002N | 2024-10-03T12:12:58.858Z | 2024-10-10T12:24:42.801Z |
5209092 | 5209092 | 20241002201904_1WTKI | KR002N | 2024-10-03T12:09:52.193Z | 2024-10-11T12:23:32.340Z |
5209054 | 5209054 | 20241002194354_bEvof | KR002N | 2024-10-03T12:09:47.105Z | 2024-10-11T12:23:31.752Z |
5209043 | 5209043 | 20241002194121_ufTG7 | KR002N | 2024-10-03T12:09:46.207Z | 2024-10-11T12:23:31.708Z |
5208941 | 5208941 | 20241002182959_2enLW | KR002N | 2024-10-03T12:09:35.106Z | 2024-10-11T12:23:30.856Z |
5208931 | 5208931 | 20241002182410_UT38f | KR002N | 2024-10-03T12:09:34.553Z | 2024-10-11T12:23:30.707Z |
5208917 | 5208917 | 20241002181559_DUcEa | KR002N | 2024-10-03T12:09:33.136Z | 2024-10-11T12:23:30.685Z |
5208900 | 5208900 | 20241002180411_YN3Od | KR002N | 2024-10-03T12:09:31.846Z | 2024-10-11T12:23:30.671Z |
5208887 | 5208887 | 20241002175830_Jb7B0 | KR002N | 2024-10-03T12:09:30.351Z | 2024-10-11T12:23:30.647Z |
5208830 | 5208830 | 20241002173443_vOUMd | KR002N | 2024-10-03T12:09:21.132Z | 2024-10-11T12:23:30.562Z |
5208825 | 5208825 | 20241002173315_Z579T | KR002N | 2024-10-03T12:09:20.908Z | 2024-10-11T12:23:30.559Z |
5208555 | 5208555 | 20241002141131_6f3Th | KR002N | 2024-10-03T12:08:36.479Z | 2024-10-11T12:23:29.991Z |
5208527 | 5208527 | 20241002134529_p3Ah6 | KR002N | 2024-10-03T12:08:28.699Z | 2024-10-11T12:23:29.750Z |
5208480 | 5208480 | 20241002132104_qkxFb | KR002N | 2024-10-03T12:08:21.084Z | 2024-10-11T12:23:29.636Z |
5208458 | 5208458 | 20241002124259_2Kd2A | KR002N | 2024-10-03T12:08:16.735Z | 2024-10-11T12:23:29.566Z |
5208448 | 5208448 | 20241002123522_kG36h | KR002N | 2024-10-03T12:08:15.643Z | 2024-10-11T12:23:29.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);