participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,672 rows where station_code = "KR002P" 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 |
---|---|---|---|---|---|
5555640 | 5555640 | 20241119141231_AF5fJ | KR002P | 2024-11-20T14:06:12.280Z | 2024-11-22T14:20:11.517Z |
5554995 | 5554995 | 20241119111748_1vRmq | KR002P | 2024-11-20T14:04:01.625Z | 2024-11-22T14:19:55.093Z |
5554566 | 5554566 | 20241119093655_TPoT2 | KR002P | 2024-11-20T14:02:29.748Z | 2024-11-22T14:19:44.179Z |
5552365 | 5552365 | 20241118205627_0EB24 | KR002P | 2024-11-19T14:06:26.967Z | 2024-11-22T14:22:17.039Z |
5536848 | 5536848 | 20241112192618_KCbh2 | KR002P | 2024-11-14T14:10:37.021Z | 2024-11-21T14:26:06.410Z |
5536781 | 5536781 | 20241112190322_iA1Ld | KR002P | 2024-11-14T14:10:32.813Z | 2024-11-21T14:26:05.454Z |
5536463 | 5536463 | 20241112180832_mBajt | KR002P | 2024-11-14T14:10:00.250Z | 2024-11-21T14:26:01.099Z |
5536424 | 5536424 | 20241112175830_l7mvN | KR002P | 2024-11-14T14:09:53.296Z | 2024-11-21T14:26:00.841Z |
5536209 | 5536209 | 20241112162041_qWUeZ | KR002P | 2024-11-14T14:09:19.161Z | 2024-11-21T14:25:57.743Z |
5525433 | 5525433 | 20241106204501_1AFuJ | KR002P | 2024-11-12T14:25:56.041Z | 2024-11-15T14:24:51.751Z |
5525424 | 5525424 | 20241106201024_sSUxs | KR002P | 2024-11-12T14:25:54.654Z | 2024-11-15T14:24:50.305Z |
5525394 | 5525394 | 20241106191832_yfE3X | KR002P | 2024-11-12T14:25:51.695Z | 2024-11-15T14:24:48.055Z |
5525348 | 5525348 | 20241106180152_bESVv | KR002P | 2024-11-12T14:25:46.512Z | 2024-11-15T14:24:44.841Z |
5525333 | 5525333 | 20241106173839_6IS9u | KR002P | 2024-11-12T14:25:45.208Z | 2024-11-15T14:24:43.769Z |
5525253 | 5525253 | 20241106152707_vyCgO | KR002P | 2024-11-12T14:25:38.846Z | 2024-11-15T14:24:38.671Z |
5525064 | 5525064 | 20241108172036_A0YHR | KR002P | 2024-11-12T14:22:54.346Z | 2024-11-17T14:23:27.852Z |
5525043 | 5525043 | 20241108155644_L8XJy | KR002P | 2024-11-12T14:22:50.529Z | 2024-11-17T14:23:23.069Z |
5522211 | 5522211 | 20241110192609_sr7zR | KR002P | 2024-11-12T14:12:58.138Z | 2024-11-19T14:21:59.438Z |
5521871 | 5521871 | 20241110182729_ZQt4B | KR002P | 2024-11-12T14:12:05.033Z | 2024-11-19T14:21:55.850Z |
5521836 | 5521836 | 20241110182206_dKL37 | KR002P | 2024-11-12T14:12:03.006Z | 2024-11-19T14:21:55.342Z |
5521730 | 5521730 | 20241110180901_JWdrb | KR002P | 2024-11-12T14:11:54.398Z | 2024-11-19T14:21:54.647Z |
5521649 | 5521649 | 20241110174818_H8Pei | KR002P | 2024-11-12T14:11:46.750Z | 2024-11-19T14:21:53.955Z |
5521595 | 5521595 | 20241110173931_PARan | KR002P | 2024-11-12T14:11:42.120Z | 2024-11-19T14:21:53.685Z |
5520990 | 5520990 | 20241110154050_38UQB | KR002P | 2024-11-12T14:09:59.574Z | 2024-11-19T14:21:46.923Z |
5520634 | 5520634 | 20241110125636_z4xdM | KR002P | 2024-11-12T14:08:52.229Z | 2024-11-19T14:21:40.786Z |
5503149 | 5503149 | 20241107205232_doiM6 | KR002P | 2024-11-09T14:12:28.035Z | 2024-11-16T14:28:03.818Z |
5502979 | 5502979 | 20241107202344_ErhkF | KR002P | 2024-11-09T14:12:16.604Z | 2024-11-16T14:28:01.659Z |
5502966 | 5502966 | 20241107201926_zRNuJ | KR002P | 2024-11-09T14:12:15.816Z | 2024-11-16T14:28:01.564Z |
5502826 | 5502826 | 20241107195115_yPsWN | KR002P | 2024-11-09T14:12:05.379Z | 2024-11-16T14:27:59.728Z |
5502728 | 5502728 | 20241107193714_KmXkQ | KR002P | 2024-11-09T14:11:59.741Z | 2024-11-16T14:27:58.906Z |
5502669 | 5502669 | 20241107193032_h5PJj | KR002P | 2024-11-09T14:11:57.532Z | 2024-11-16T14:27:58.353Z |
5502593 | 5502593 | 20241107191302_xy8bL | KR002P | 2024-11-09T14:11:47.536Z | 2024-11-16T14:27:57.807Z |
5502355 | 5502355 | 20241107181143_G4das | KR002P | 2024-11-09T14:11:12.726Z | 2024-11-16T14:27:54.364Z |
5502303 | 5502303 | 20241107175935_Mbiu3 | KR002P | 2024-11-09T14:11:08.823Z | 2024-11-16T14:27:53.140Z |
5502245 | 5502245 | 20241107174746_kENz1 | KR002P | 2024-11-09T14:11:05.714Z | 2024-11-16T14:27:51.983Z |
5502218 | 5502218 | 20241107174338_Giz5k | KR002P | 2024-11-09T14:11:04.322Z | 2024-11-16T14:27:51.752Z |
5502213 | 5502213 | 20241107174338_IBMan | KR002P | 2024-11-09T14:11:04.176Z | 2024-11-16T14:27:51.751Z |
5502034 | 5502034 | 20241107165802_A0zP6 | KR002P | 2024-11-09T14:10:50.977Z | 2024-11-16T14:27:49.525Z |
5502005 | 5502005 | 20241107165146_YhPJx | KR002P | 2024-11-09T14:10:49.499Z | 2024-11-16T14:27:49.433Z |
5501945 | 5501945 | 20241107164353_0zsW8 | KR002P | 2024-11-09T14:10:47.129Z | 2024-11-16T14:27:49.244Z |
5501755 | 5501755 | 20241107153622_03uuG | KR002P | 2024-11-09T14:10:18.069Z | 2024-11-16T14:27:47.705Z |
5501750 | 5501750 | 20241107153358_Lv5Rh | KR002P | 2024-11-09T14:10:17.553Z | 2024-11-16T14:27:46.851Z |
5501663 | 5501663 | 20241107150553_vziMw | KR002P | 2024-11-09T14:10:10.422Z | 2024-11-16T14:27:44.465Z |
5501647 | 5501647 | 20241107150217_EbNSV | KR002P | 2024-11-09T14:10:09.701Z | 2024-11-16T14:27:44.172Z |
5501597 | 5501597 | 20241107143741_4q5sU | KR002P | 2024-11-09T14:10:05.857Z | 2024-11-16T14:27:43.254Z |
5501560 | 5501560 | 20241107141801_Pv9lg | KR002P | 2024-11-09T14:10:00.849Z | 2024-11-16T14:27:42.604Z |
5501424 | 5501424 | 20241107130035_lCG2T | KR002P | 2024-11-09T14:09:33.228Z | 2024-11-16T14:27:38.929Z |
5500975 | 5500975 | 20241108184212_KiN7R | KR002P | 2024-11-09T14:07:31.607Z | 2024-11-17T14:23:31.777Z |
5500800 | 5500800 | 20241108173750_Ui2sg | KR002P | 2024-11-09T14:07:07.865Z | 2024-11-17T14:23:28.734Z |
5500758 | 5500758 | 20241108172225_HT8ea | KR002P | 2024-11-09T14:07:02.888Z | 2024-11-17T14:23:27.864Z |
5500696 | 5500696 | 20241108170239_GR7e3 | KR002P | 2024-11-09T14:06:55.612Z | 2024-11-17T14:23:26.591Z |
5500644 | 5500644 | 20241108164234_hxTWk | KR002P | 2024-11-09T14:06:50.695Z | 2024-11-17T14:23:25.894Z |
5500562 | 5500562 | 20241108160637_aHFSk | KR002P | 2024-11-09T14:06:34.807Z | 2024-11-17T14:23:23.645Z |
5500323 | 5500323 | 20241108151942_Til46 | KR002P | 2024-11-09T14:06:06.559Z | 2024-11-17T14:23:21.511Z |
5500171 | 5500171 | 20241108150125_adCXc | KR002P | 2024-11-09T14:05:56.668Z | 2024-11-17T14:23:19.987Z |
5499966 | 5499966 | 20241108141526_S3sg5 | KR002P | 2024-11-09T14:05:24.633Z | 2024-11-17T14:23:17.695Z |
5495634 | 5495634 | 20241106204501_SIPG2 | KR002P | 2024-11-08T14:10:31.336Z | 2024-11-11T14:19:33.805Z |
5495611 | 5495611 | 20241106203529_t0TKj | KR002P | 2024-11-08T14:10:28.256Z | 2024-11-15T14:24:51.496Z |
5495574 | 5495574 | 20241106202229_WP3dO | KR002P | 2024-11-08T14:10:25.034Z | 2024-11-15T14:24:50.710Z |
5495545 | 5495545 | 20241106201639_Y53cI | KR002P | 2024-11-08T14:10:22.649Z | 2024-11-15T14:24:50.457Z |
5495509 | 5495509 | 20241106200522_w0edL | KR002P | 2024-11-08T14:10:19.387Z | 2024-11-15T14:24:50.198Z |
5495427 | 5495427 | 20241106194644_D9qWm | KR002P | 2024-11-08T14:10:13.042Z | 2024-11-15T14:24:48.769Z |
5495312 | 5495312 | 20241106192111_CSQPQ | KR002P | 2024-11-08T14:09:55.665Z | 2024-11-15T14:24:48.226Z |
5495255 | 5495255 | 20241106190539_87Tl4 | KR002P | 2024-11-08T14:09:44.395Z | 2024-11-15T14:24:47.843Z |
5495250 | 5495250 | 20241106190522_p79wi | KR002P | 2024-11-08T14:09:44.224Z | 2024-11-15T14:24:47.841Z |
5495195 | 5495195 | 20241106185534_Ez3x4 | KR002P | 2024-11-08T14:09:35.856Z | 2024-11-15T14:24:47.375Z |
5495087 | 5495087 | 20241106183340_B2B35 | KR002P | 2024-11-08T14:09:15.562Z | 2024-11-15T14:24:46.537Z |
5495068 | 5495068 | 20241106183043_ajHrl | KR002P | 2024-11-08T14:09:12.691Z | 2024-11-15T14:24:46.014Z |
5495062 | 5495062 | 20241106182807_4anic | KR002P | 2024-11-08T14:09:11.389Z | 2024-11-15T14:24:45.938Z |
5494653 | 5494653 | 20241106163748_3TK2X | KR002P | 2024-11-08T14:08:14.603Z | 2024-11-15T14:24:40.902Z |
5494537 | 5494537 | 20241106154244_EW0oR | KR002P | 2024-11-08T14:07:45.532Z | 2024-11-15T14:24:39.760Z |
5494512 | 5494512 | 20241106152707_o8yDQ | KR002P | 2024-11-08T14:07:39.048Z | 2024-11-11T14:19:16.912Z |
5494496 | 5494496 | 20241106152205_pZpTz | KR002P | 2024-11-08T14:07:37.101Z | 2024-11-15T14:24:38.399Z |
5494490 | 5494490 | 20241106152133_pBSdg | KR002P | 2024-11-08T14:07:36.923Z | 2024-11-15T14:24:38.391Z |
5494428 | 5494428 | 20241106145154_x2344 | KR002P | 2024-11-08T14:07:28.856Z | 2024-11-15T14:24:37.311Z |
5494372 | 5494372 | 20241106141341_3KtNK | KR002P | 2024-11-08T14:07:18.189Z | 2024-11-15T14:24:36.429Z |
5494368 | 5494368 | 20241106140943_hhUBa | KR002P | 2024-11-08T14:07:13.522Z | 2024-11-15T14:24:36.087Z |
5494336 | 5494336 | 20241106134306_uQd1S | KR002P | 2024-11-08T14:06:57.951Z | 2024-11-15T14:24:35.245Z |
5494210 | 5494210 | 20241106115318_bw35V | KR002P | 2024-11-08T14:06:24.353Z | 2024-11-15T14:24:30.775Z |
5494204 | 5494204 | 20241106113715_9G685 | KR002P | 2024-11-08T14:06:21.514Z | 2024-11-15T14:24:30.052Z |
5489852 | 5489852 | 20241105201854_j8fYD | KR002P | 2024-11-07T14:12:50.070Z | 2024-11-14T14:23:15.825Z |
5489803 | 5489803 | 20241105200157_OYA4J | KR002P | 2024-11-07T14:12:46.432Z | 2024-11-14T14:23:15.719Z |
5489591 | 5489591 | 20241105192246_SjF2g | KR002P | 2024-11-07T14:12:14.742Z | 2024-11-14T14:23:13.891Z |
5489580 | 5489580 | 20241105192047_OxvBf | KR002P | 2024-11-07T14:12:13.862Z | 2024-11-14T14:23:13.861Z |
5489503 | 5489503 | 20241105190701_2vc9I | KR002P | 2024-11-07T14:12:06.127Z | 2024-11-14T14:23:13.597Z |
5489417 | 5489417 | 20241105184809_AE20O | KR002P | 2024-11-07T14:11:59.457Z | 2024-11-14T14:23:12.762Z |
5489402 | 5489402 | 20241105184734_dt4gG | KR002P | 2024-11-07T14:11:58.905Z | 2024-11-14T14:23:12.751Z |
5489361 | 5489361 | 20241105183934_6SNhh | KR002P | 2024-11-07T14:11:55.895Z | 2024-11-14T14:23:12.584Z |
5489350 | 5489350 | 20241105183835_OX1dr | KR002P | 2024-11-07T14:11:55.016Z | 2024-11-14T14:23:12.539Z |
5489308 | 5489308 | 20241105183340_jusut | KR002P | 2024-11-07T14:11:52.347Z | 2024-11-14T14:23:12.383Z |
5489232 | 5489232 | 20241105181206_W7bIQ | KR002P | 2024-11-07T14:11:33.434Z | 2024-11-14T14:23:11.053Z |
5489117 | 5489117 | 20241105175021_2zXi2 | KR002P | 2024-11-07T14:11:19.237Z | 2024-11-14T14:23:10.470Z |
5488935 | 5488935 | 20241105172259_YdLt5 | KR002P | 2024-11-07T14:11:01.438Z | 2024-11-14T14:23:08.693Z |
5488764 | 5488764 | 20241105164742_30FVM | KR002P | 2024-11-07T14:10:36.346Z | 2024-11-14T14:23:07.692Z |
5488707 | 5488707 | 20241105163035_HkTc1 | KR002P | 2024-11-07T14:10:30.689Z | 2024-11-14T14:23:07.222Z |
5488531 | 5488531 | 20241105153053_w29sJ | KR002P | 2024-11-07T14:10:06.018Z | 2024-11-14T14:23:06.527Z |
5488429 | 5488429 | 20241105144020_f5nXq | KR002P | 2024-11-07T14:09:52.962Z | 2024-11-14T14:23:05.529Z |
5488258 | 5488258 | 20241105122518_rxraz | KR002P | 2024-11-07T14:09:17.949Z | 2024-11-14T14:23:03.890Z |
5480981 | 5480981 | 20241104120250_yHG2Y | KR002P | 2024-11-06T14:08:15.660Z | 2024-11-13T14:27:24.474Z |
5473350 | 5473350 | 20241103140454_3nJw3 | KR002P | 2024-11-05T14:08:49.800Z | 2024-11-12T14:27:48.717Z |
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);