participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,342 rows where station_code = "KR002X" 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 |
---|---|---|---|---|---|
4512729 | 4512729 | 20240627175801_SNaxl | KR002X | 2024-06-29T12:04:14.402Z | 2024-07-06T12:16:14.040Z |
4512629 | 4512629 | 20240627174409_a6MNS | KR002X | 2024-06-29T12:04:10.017Z | 2024-07-06T12:16:13.897Z |
4507395 | 4507395 | 20240626152105_UGBMW | KR002X | 2024-06-28T12:01:52.034Z | 2024-07-05T12:11:21.763Z |
4507240 | 4507240 | 20240627164807_E5URy | KR002X | 2024-06-28T12:01:13.387Z | 2024-07-06T12:16:12.646Z |
4507203 | 4507203 | 20240627163440_AFmpP | KR002X | 2024-06-28T12:01:10.913Z | 2024-07-06T12:16:12.341Z |
4507083 | 4507083 | 20240627155425_0CW1Y | KR002X | 2024-06-28T12:01:02.924Z | 2024-07-06T12:16:12.074Z |
4506839 | 4506839 | 20240627145809_syWaY | KR002X | 2024-06-28T12:00:46.008Z | 2024-07-06T12:16:10.465Z |
4506627 | 4506627 | 20240627135902_mC4Wv | KR002X | 2024-06-28T12:00:30.659Z | 2024-07-06T12:16:09.641Z |
4506552 | 4506552 | 20240627132714_WsMje | KR002X | 2024-06-28T12:00:24.436Z | 2024-07-06T12:16:09.264Z |
4506433 | 4506433 | 20240627123603_ERhYh | KR002X | 2024-06-28T12:00:13.824Z | 2024-07-06T12:16:08.887Z |
4503057 | 4503057 | 20240626140535_TFOM2 | KR002X | 2024-06-27T12:01:07.542Z | 2024-07-05T12:11:20.368Z |
4498521 | 4498521 | 20240625153938_3L44b | KR002X | 2024-06-26T12:00:44.229Z | 2024-07-04T12:08:45.140Z |
4487471 | 4487471 | 20240619175234_VfFES | KR002X | 2024-06-21T12:04:03.306Z | 2024-06-28T12:09:33.675Z |
4487462 | 4487462 | 20240619175208_rE13L | KR002X | 2024-06-21T12:04:02.757Z | 2024-06-28T12:09:33.670Z |
4483669 | 4483669 | 20240618174252_foeP6 | KR002X | 2024-06-20T12:04:29.439Z | 2024-06-27T12:11:24.328Z |
4483470 | 4483470 | 20240618171217_Rzbsy | KR002X | 2024-06-20T12:04:13.846Z | 2024-06-27T12:11:22.863Z |
4477683 | 4477683 | 20240617182643_U7fxj | KR002X | 2024-06-19T12:05:48.150Z | 2024-06-26T12:14:35.419Z |
4477676 | 4477676 | 20240617182638_afwBg | KR002X | 2024-06-19T12:05:47.702Z | 2024-06-26T12:14:35.397Z |
4477544 | 4477544 | 20240617180616_gQ25j | KR002X | 2024-06-19T12:05:29.947Z | 2024-06-26T12:14:34.530Z |
4477526 | 4477526 | 20240617180342_iBZc7 | KR002X | 2024-06-19T12:05:28.728Z | 2024-06-26T12:14:34.317Z |
4477314 | 4477314 | 20240617173006_Unx3R | KR002X | 2024-06-19T12:05:13.556Z | 2024-06-26T12:14:32.447Z |
4477187 | 4477187 | 20240617170830_851sF | KR002X | 2024-06-19T12:05:05.644Z | 2024-06-26T12:14:31.568Z |
4476392 | 4476392 | 20240617132932_iKcd3 | KR002X | 2024-06-19T12:03:42.571Z | 2024-06-26T12:14:21.207Z |
4473978 | 4473978 | 20240616165446_SbxC7 | KR002X | 2024-06-18T12:04:42.373Z | 2024-06-24T12:11:36.842Z |
4466286 | 4466286 | 20240614163914_MJJKB | KR002X | 2024-06-16T12:06:53.892Z | 2024-06-22T12:16:34.834Z |
4463126 | 4463126 | 20240613184137_53DK3 | KR002X | 2024-06-15T12:09:27.241Z | 2024-06-21T12:11:48.011Z |
4462896 | 4462896 | 20240613180429_K36oa | KR002X | 2024-06-15T12:09:15.402Z | 2024-06-21T12:11:47.544Z |
4462655 | 4462655 | 20240613172556_GFqBf | KR002X | 2024-06-15T12:09:01.832Z | 2024-06-21T12:11:47.273Z |
4462539 | 4462539 | 20240613171006_jkB39 | KR002X | 2024-06-15T12:08:49.151Z | 2024-06-21T12:11:47.174Z |
4461979 | 4461979 | 20240613151808_FqVQz | KR002X | 2024-06-15T12:07:54.661Z | 2024-06-21T12:11:46.086Z |
4461872 | 4461872 | 20240613144036_QuGi8 | KR002X | 2024-06-15T12:07:44.679Z | 2024-06-21T12:11:45.464Z |
4461809 | 4461809 | 20240613141730_1GnSR | KR002X | 2024-06-15T12:07:39.638Z | 2024-06-21T12:11:45.426Z |
4461621 | 4461621 | 20240613130445_kfu7I | KR002X | 2024-06-15T12:07:15.667Z | 2024-06-21T12:11:44.611Z |
4459288 | 4459288 | 20240612172442_kqnPW | KR002X | 2024-06-14T12:05:27.464Z | 2024-06-20T12:12:04.955Z |
4458972 | 4458972 | 20240612162243_9T3QA | KR002X | 2024-06-14T12:05:16.772Z | 2024-06-20T12:12:04.553Z |
4458905 | 4458905 | 20240612160905_aYMAq | KR002X | 2024-06-14T12:05:14.181Z | 2024-06-20T12:12:04.288Z |
4458345 | 4458345 | 20240612131943_ctk8d | KR002X | 2024-06-14T12:04:49.089Z | 2024-06-20T12:12:03.494Z |
4454992 | 4454992 | 20240611184436_ySBn8 | KR002X | 2024-06-13T12:06:22.087Z | 2024-06-19T12:13:49.197Z |
4454903 | 4454903 | 20240611183312_2sWR2 | KR002X | 2024-06-13T12:06:20.268Z | 2024-06-19T12:13:48.723Z |
4454797 | 4454797 | 20240611182407_FNJDj | KR002X | 2024-06-13T12:06:18.562Z | 2024-06-19T12:13:48.604Z |
4454551 | 4454551 | 20240611175854_TBwwQ | KR002X | 2024-06-13T12:06:13.288Z | 2024-06-19T12:13:48.277Z |
4447617 | 4447617 | 20240610152659_1f6YC | KR002X | 2024-06-12T12:05:38.514Z | 2024-06-18T12:11:15.161Z |
4444799 | 4444799 | 20240610190517_5bDoJ | KR002X | 2024-06-12T12:00:42.353Z | 2024-06-19T12:13:24.298Z |
4444755 | 4444755 | 20240610184926_cGLyY | KR002X | 2024-06-12T12:00:37.466Z | 2024-06-19T12:13:24.229Z |
4444295 | 4444295 | 20240609153430_Dg1DF | KR002X | 2024-06-11T12:06:40.887Z | 2024-06-17T12:15:23.287Z |
4444290 | 4444290 | 20240609153332_h30h8 | KR002X | 2024-06-11T12:06:40.342Z | 2024-06-17T12:15:23.286Z |
4441811 | 4441811 | 20240609183347_LBdg9 | KR002X | 2024-06-11T12:00:36.694Z | 2024-06-18T12:11:01.408Z |
4441740 | 4441740 | 20240609175959_yZtrP | KR002X | 2024-06-11T12:00:28.518Z | 2024-06-18T12:11:01.220Z |
4430743 | 4430743 | 20240606123416_FXVRb | KR002X | 2024-06-08T12:10:21.818Z | 2024-06-14T12:08:31.888Z |
4425368 | 4425368 | 20240606150829_dLweA | KR002X | 2024-06-08T12:01:15.966Z | 2024-06-15T12:16:44.674Z |
4424826 | 4424826 | 20240606135324_G4APv | KR002X | 2024-06-08T12:00:22.881Z | 2024-06-15T12:16:42.795Z |
4424782 | 4424782 | 20240606134516_5nfEJ | KR002X | 2024-06-08T12:00:18.612Z | 2024-06-15T12:16:42.120Z |
4415532 | 4415532 | 20240604182121_GVezA | KR002X | 2024-06-06T12:04:51.613Z | 2024-06-13T12:08:30.041Z |
4415445 | 4415445 | 20240604180358_K20vH | KR002X | 2024-06-06T12:04:40.947Z | 2024-06-13T12:08:29.976Z |
4414787 | 4414787 | 20240604163225_UMIOT | KR002X | 2024-06-06T12:03:44.557Z | 2024-06-13T12:08:29.466Z |
4414502 | 4414502 | 20240604160103_GLQpM | KR002X | 2024-06-06T12:03:28.132Z | 2024-06-13T12:08:29.249Z |
4414372 | 4414372 | 20240604155051_P7Xu3 | KR002X | 2024-06-06T12:03:18.100Z | 2024-06-13T12:08:29.169Z |
4413426 | 4413426 | 20240604135427_k5HIF | KR002X | 2024-06-06T12:01:39.872Z | 2024-06-13T12:08:28.529Z |
4411148 | 4411148 | 20240603184653_RshYq | KR002X | 2024-06-05T12:06:22.121Z | 2024-06-12T12:10:36.810Z |
4409743 | 4409743 | 20240603155323_86zQe | KR002X | 2024-06-05T12:04:12.900Z | 2024-06-12T12:10:33.620Z |
4405801 | 4405801 | 20240602185150_oC4ji | KR002X | 2024-06-04T12:05:15.715Z | 2024-06-11T12:13:32.159Z |
4405437 | 4405437 | 20240602173952_b5RVe | KR002X | 2024-06-04T12:04:40.565Z | 2024-06-11T12:13:31.284Z |
4405245 | 4405245 | 20240602170041_jPCxG | KR002X | 2024-06-04T12:04:11.910Z | 2024-06-11T12:13:30.938Z |
4405043 | 4405043 | 20240602162942_OWpHR | KR002X | 2024-06-04T12:03:56.958Z | 2024-06-11T12:13:30.524Z |
4404939 | 4404939 | 20240602161217_fxYdG | KR002X | 2024-06-04T12:03:42.834Z | 2024-06-11T12:13:30.226Z |
4404912 | 4404912 | 20240602160637_fqfdI | KR002X | 2024-06-04T12:03:38.159Z | 2024-06-11T12:13:30.045Z |
4404725 | 4404725 | 20240602151500_BTmM3 | KR002X | 2024-06-04T12:03:12.291Z | 2024-06-11T12:13:29.470Z |
4400178 | 4400178 | 20240601185557_coVe7 | KR002X | 2024-06-03T12:05:18.106Z | 2024-06-10T12:06:45.737Z |
4400069 | 4400069 | 20240601182800_gyKMF | KR002X | 2024-06-03T12:05:10.496Z | 2024-06-10T12:06:45.617Z |
4398975 | 4398975 | 20240601125724_oqAlH | KR002X | 2024-06-03T12:02:33.195Z | 2024-06-10T12:06:44.643Z |
4391896 | 4391896 | 20240529140009_eqbia | KR002X | 2024-05-31T12:06:08.819Z | 2024-06-07T12:15:56.235Z |
4391483 | 4391483 | 20240529123847_My7mz | KR002X | 2024-05-31T12:05:30.564Z | 2024-06-07T12:15:55.531Z |
4389198 | 4389198 | 20240528184210_xY6j3 | KR002X | 2024-05-30T12:05:09.714Z | 2024-06-06T12:14:26.636Z |
4389153 | 4389153 | 20240528182214_DOdHS | KR002X | 2024-05-30T12:05:04.471Z | 2024-06-06T12:14:26.509Z |
4389051 | 4389051 | 20240528175336_vlKS3 | KR002X | 2024-05-30T12:04:45.632Z | 2024-06-06T12:14:26.086Z |
4389013 | 4389013 | 20240528173411_e6BDw | KR002X | 2024-05-30T12:04:40.812Z | 2024-06-06T12:14:25.997Z |
4388834 | 4388834 | 20240528163530_oESJZ | KR002X | 2024-05-30T12:04:26.149Z | 2024-06-06T12:14:25.640Z |
4388788 | 4388788 | 20240528162304_Sn6Vs | KR002X | 2024-05-30T12:04:21.385Z | 2024-06-06T12:14:25.362Z |
4385320 | 4385320 | 20240528151117_rU35l | KR002X | 2024-05-29T12:03:15.702Z | 2024-06-06T12:14:24.545Z |
4385169 | 4385169 | 20240528142750_GF3jM | KR002X | 2024-05-29T12:02:59.328Z | 2024-06-06T12:14:24.214Z |
4377434 | 4377434 | 20240519183345_NnHf0 | KR002X | 2024-05-27T12:12:07.973Z | 2024-05-27T12:12:07.973Z |
4369983 | 4369983 | 20240518170931_DZkH4 | KR002X | 2024-05-26T12:08:47.269Z | 2024-05-26T12:09:53.403Z |
4369948 | 4369948 | 20240518170400_b3cXf | KR002X | 2024-05-26T12:08:44.682Z | 2024-05-26T12:09:53.395Z |
4364017 | 4364017 | 20240516154653_37jvN | KR002X | 2024-05-25T12:07:39.271Z | 2024-05-25T12:07:39.271Z |
4360340 | 4360340 | 20240516185442_PdFmc | KR002X | 2024-05-25T12:01:39.689Z | 2024-05-25T12:09:10.402Z |
4345416 | 4345416 | 20240510161849_Jpmsx | KR002X | 2024-05-20T12:03:15.321Z | 2024-05-22T12:10:06.505Z |
4344429 | 4344429 | 20240510145922_P7E21 | KR002X | 2024-05-20T12:01:54.363Z | 2024-05-22T12:09:42.241Z |
4344238 | 4344238 | 20240510143649_VqJ3G | KR002X | 2024-05-20T12:01:34.976Z | 2024-05-22T12:09:37.497Z |
4329819 | 4329819 | 20240508192255_sRjGP | KR002X | 2024-05-17T12:09:04.625Z | 2024-05-19T12:14:28.496Z |
4329732 | 4329732 | 20240508191316_f3W9O | KR002X | 2024-05-17T12:08:58.875Z | 2024-05-19T12:14:26.358Z |
4329694 | 4329694 | 20240508191042_gt6ex | KR002X | 2024-05-17T12:08:57.782Z | 2024-05-19T12:14:26.171Z |
4329585 | 4329585 | 20240508185407_MU3T3 | KR002X | 2024-05-17T12:08:50.546Z | 2024-05-19T12:14:24.510Z |
4329451 | 4329451 | 20240508184026_LpIRv | KR002X | 2024-05-17T12:08:43.997Z | 2024-05-19T12:14:22.836Z |
4328566 | 4328566 | 20240508175602_1jw6s | KR002X | 2024-05-17T12:07:53.371Z | 2024-05-19T12:14:02.494Z |
4324343 | 4324343 | 20240508133349_7JUrl | KR002X | 2024-05-17T12:02:16.084Z | 2024-05-19T12:12:48.077Z |
4275262 | 4275262 | 20240502193145_IGfK1 | KR002X | 2024-05-05T12:10:17.154Z | 2024-05-11T12:27:56.556Z |
4275022 | 4275022 | 20240502190121_8q9g9 | KR002X | 2024-05-05T12:10:07.991Z | 2024-05-11T12:27:51.685Z |
4273826 | 4273826 | 20240502171004_akp0c | KR002X | 2024-05-05T12:08:28.116Z | 2024-05-11T12:27:25.446Z |
4266143 | 4266143 | 20240501185314_nEnif | KR002X | 2024-05-03T12:07:10.952Z | 2024-05-10T12:23:34.329Z |
4266136 | 4266136 | 20240501185255_SiZKE | KR002X | 2024-05-03T12:07:10.674Z | 2024-05-10T12:23:34.266Z |
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);