participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,453 rows where station_code = "KR000F" 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 |
---|---|---|---|---|---|
5006506 | 5006506 | 20240903174510_qbL2w | KR000F | 2024-09-09T12:04:42.928Z | 2024-09-12T12:19:08.355Z |
5005456 | 5005456 | 20240903151629_35Bnz | KR000F | 2024-09-09T12:03:43.489Z | 2024-09-12T12:19:05.957Z |
5005286 | 5005286 | 20240903144728_elALO | KR000F | 2024-09-09T12:03:33.930Z | 2024-09-12T12:19:05.645Z |
4518687 | 4518687 | 20240628171543_cGhBV | KR000F | 2024-06-30T12:02:03.919Z | 2024-07-07T12:13:44.299Z |
4477789 | 4477789 | 20240617184134_3ET3d | KR000F | 2024-06-19T12:06:00.153Z | 2024-06-26T12:14:36.185Z |
4477566 | 4477566 | 20240617180921_gkR8V | KR000F | 2024-06-19T12:05:31.663Z | 2024-06-26T12:14:34.890Z |
4477463 | 4477463 | 20240617175925_H9IJY | KR000F | 2024-06-19T12:05:24.075Z | 2024-06-26T12:14:33.746Z |
4477217 | 4477217 | 20240617171432_kXInI | KR000F | 2024-06-19T12:05:07.609Z | 2024-06-26T12:14:31.778Z |
4405762 | 4405762 | 20240602184353_YGMXa | KR000F | 2024-06-04T12:05:13.073Z | 2024-06-11T12:13:32.083Z |
4405560 | 4405560 | 20240602180223_N4gBK | KR000F | 2024-06-04T12:04:58.414Z | 2024-06-11T12:13:31.631Z |
4405483 | 4405483 | 20240602175037_ONOtB | KR000F | 2024-06-04T12:04:51.131Z | 2024-06-11T12:13:31.496Z |
4405051 | 4405051 | 20240602163121_X1TdZ | KR000F | 2024-06-04T12:03:58.167Z | 2024-06-11T12:13:30.547Z |
4404843 | 4404843 | 20240602154546_9muuR | KR000F | 2024-06-04T12:03:27.995Z | 2024-06-11T12:13:29.767Z |
4400158 | 4400158 | 20240601185415_mG7Ca | KR000F | 2024-06-03T12:05:17.828Z | 2024-06-10T12:06:45.713Z |
4400113 | 4400113 | 20240601184127_LW6Ab | KR000F | 2024-06-03T12:05:14.338Z | 2024-06-10T12:06:45.663Z |
4400092 | 4400092 | 20240601183610_6flwo | KR000F | 2024-06-03T12:05:12.535Z | 2024-06-10T12:06:45.641Z |
4113693 | 4113693 | 20240326124033_ChYxY | KR000F | 2024-03-28T12:00:15.657Z | 2024-04-04T12:17:08.130Z |
4113531 | 4113531 | 20240326105743_evNYX | KR000F | 2024-03-27T12:03:42.793Z | 2024-04-03T12:18:11.314Z |
4059198 | 4059198 | 20240310122530_GF2EV | KR000F | 2024-03-12T12:03:17.902Z | 2024-03-19T12:22:17.449Z |
4051324 | 4051324 | 20240308204129_bwbXB | KR000F | 2024-03-10T12:08:34.000Z | 2024-03-17T12:18:17.589Z |
4048442 | 4048442 | 20240308123209_yiujj | KR000F | 2024-03-10T12:02:59.718Z | 2024-03-17T12:17:54.351Z |
4037969 | 4037969 | 20240306142842_Ye0iG | KR000F | 2024-03-08T14:03:13.242Z | 2024-03-15T12:18:50.720Z |
4016567 | 4016567 | 20240301205414_fG2Ag | KR000F | 2024-03-03T14:05:47.455Z | 2024-03-10T12:21:16.878Z |
4016437 | 4016437 | 20240301202244_kEAWL | KR000F | 2024-03-03T14:05:35.285Z | 2024-03-10T12:21:15.353Z |
4016432 | 4016432 | 20240301202035_a4vxN | KR000F | 2024-03-03T14:05:34.994Z | 2024-03-10T12:21:15.336Z |
4015645 | 4015645 | 20240301143831_dsVbH | KR000F | 2024-03-03T14:03:24.051Z | 2024-03-10T12:21:08.829Z |
4011649 | 4011649 | 20240301163934_a003S | KR000F | 2024-03-02T14:04:20.383Z | 2024-03-10T12:21:11.693Z |
4011625 | 4011625 | 20240301163400_us1rv | KR000F | 2024-03-02T14:04:15.429Z | 2024-03-10T12:21:11.491Z |
4011621 | 4011621 | 20240301163103_mOo2g | KR000F | 2024-03-02T14:04:15.035Z | 2024-03-10T12:21:11.478Z |
4011401 | 4011401 | 20240301144457_34lfA | KR000F | 2024-03-02T14:03:37.074Z | 2024-03-10T12:21:09.150Z |
4010627 | 4010627 | 20240301113134_WNajE | KR000F | 2024-03-02T14:01:15.402Z | 2024-03-10T12:21:02.215Z |
4002810 | 4002810 | 20240226115051_VZIaL | KR000F | 2024-02-27T14:00:13.482Z | 2024-03-06T14:19:30.921Z |
3911072 | 3911072 | 20240202130604_oA4Bx | KR000F | 2024-02-03T14:12:02.450Z | 2024-02-10T14:25:17.037Z |
3899084 | 3899084 | 20240130122831_c6pOg | KR000F | 2024-01-31T14:07:05.138Z | 2024-02-07T14:22:37.503Z |
3896628 | 3896628 | 20240128115445_EVjZY | KR000F | 2024-01-30T14:10:19.090Z | 2024-02-05T14:19:34.437Z |
3896354 | 3896354 | 20240129161133_ZTzhv | KR000F | 2024-01-30T14:07:48.778Z | 2024-02-06T14:21:04.436Z |
3896061 | 3896061 | 20240129143223_Qv2C8 | KR000F | 2024-01-30T14:07:15.470Z | 2024-02-06T14:21:02.075Z |
3895245 | 3895245 | 20240129102743_11kH3 | KR000F | 2024-01-30T14:05:10.609Z | 2024-02-06T14:20:54.050Z |
3893257 | 3893257 | 20240128160748_mumVu | KR000F | 2024-01-29T14:06:32.467Z | 2024-02-05T14:19:40.845Z |
3893050 | 3893050 | 20240128142421_g7Kak | KR000F | 2024-01-29T14:06:00.673Z | 2024-02-05T14:19:38.522Z |
3893044 | 3893044 | 20240128142250_fzjeK | KR000F | 2024-01-29T14:06:00.304Z | 2024-02-05T14:19:38.509Z |
3892979 | 3892979 | 20240128134550_R0NQd | KR000F | 2024-01-29T14:05:43.797Z | 2024-02-05T14:19:37.975Z |
3892788 | 3892788 | 20240128120625_iMYFN | KR000F | 2024-01-29T14:05:18.353Z | 2024-02-05T14:19:34.594Z |
3892565 | 3892565 | 20240128095431_AK2PY | KR000F | 2024-01-29T14:04:41.432Z | 2024-02-05T14:19:30.445Z |
3844387 | 3844387 | 20240116170200_Eq6Uk | KR000F | 2024-01-19T14:12:18.574Z | 2024-01-25T14:22:15.614Z |
3843606 | 3843606 | 20240116142807_wGrUi | KR000F | 2024-01-19T14:11:04.053Z | 2024-01-25T14:22:10.888Z |
3843601 | 3843601 | 20240116142735_58f93 | KR000F | 2024-01-19T14:11:03.285Z | 2024-01-25T14:22:10.867Z |
3843103 | 3843103 | 20240116132505_q29k7 | KR000F | 2024-01-19T14:10:17.765Z | 2024-01-25T14:22:07.876Z |
3838472 | 3838472 | 20240113174132_2NV3Q | KR000F | 2024-01-18T14:20:40.778Z | 2024-01-22T14:23:01.916Z |
3837938 | 3837938 | 20240115214329_AryNb | KR000F | 2024-01-18T14:15:02.256Z | 2024-01-24T14:19:17.562Z |
3837708 | 3837708 | 20240115211407_UNJct | KR000F | 2024-01-18T14:14:46.475Z | 2024-01-24T14:19:16.723Z |
3837692 | 3837692 | 20240115211237_Yx0om | KR000F | 2024-01-18T14:14:45.291Z | 2024-01-24T14:19:16.430Z |
3837628 | 3837628 | 20240115210649_8Lhxz | KR000F | 2024-01-18T14:14:38.171Z | 2024-01-24T14:19:16.163Z |
3837372 | 3837372 | 20240115204812_2Q98g | KR000F | 2024-01-18T14:14:19.144Z | 2024-01-24T14:19:14.122Z |
3837240 | 3837240 | 20240115202912_i0kH6 | KR000F | 2024-01-18T14:14:11.561Z | 2024-01-24T14:19:13.337Z |
3837200 | 3837200 | 20240115202613_BsyJE | KR000F | 2024-01-18T14:14:10.078Z | 2024-01-24T14:19:12.864Z |
3836890 | 3836890 | 20240115200446_ErWLl | KR000F | 2024-01-18T14:14:01.104Z | 2024-01-24T14:19:11.506Z |
3836131 | 3836131 | 20240115185153_2CUz2 | KR000F | 2024-01-18T14:13:12.415Z | 2024-01-24T14:19:06.949Z |
3836036 | 3836036 | 20240115184057_n74y9 | KR000F | 2024-01-18T14:13:07.607Z | 2024-01-24T14:19:06.489Z |
3835423 | 3835423 | 20240115174126_fa32h | KR000F | 2024-01-18T14:12:05.822Z | 2024-01-24T14:19:03.703Z |
3834887 | 3834887 | 20240115154102_b3kh1 | KR000F | 2024-01-18T14:11:09.464Z | 2024-01-24T14:19:00.535Z |
3834642 | 3834642 | 20240115151233_2WdoX | KR000F | 2024-01-18T14:10:53.343Z | 2024-01-24T14:18:59.137Z |
3834634 | 3834634 | 20240115151101_GqPoU | KR000F | 2024-01-18T14:10:53.005Z | 2024-01-24T14:18:59.135Z |
3834518 | 3834518 | 20240115144829_xoHox | KR000F | 2024-01-18T14:10:45.075Z | 2024-01-24T14:18:58.206Z |
3834120 | 3834120 | 20240115134607_Ot5OD | KR000F | 2024-01-18T14:09:55.113Z | 2024-01-24T14:18:56.489Z |
3833278 | 3833278 | 20240115115313_CbIUB | KR000F | 2024-01-18T14:07:57.970Z | 2024-01-24T14:18:49.409Z |
3829156 | 3829156 | 20240114165128_dT3Dy | KR000F | 2024-01-17T14:12:07.243Z | 2024-01-23T14:25:11.116Z |
3829071 | 3829071 | 20240114163121_MFMxf | KR000F | 2024-01-17T14:12:02.790Z | 2024-01-23T14:25:10.513Z |
3821153 | 3821153 | 20240113192743_OiFl7 | KR000F | 2024-01-16T14:12:36.931Z | 2024-01-22T14:23:09.500Z |
3820562 | 3820562 | 20240113180059_47pIw | KR000F | 2024-01-16T14:11:46.077Z | 2024-01-22T14:23:02.877Z |
3820372 | 3820372 | 20240113173623_fWnGJ | KR000F | 2024-01-16T14:11:36.983Z | 2024-01-22T14:23:01.758Z |
3820210 | 3820210 | 20240113170959_QVT3v | KR000F | 2024-01-16T14:11:19.416Z | 2024-01-22T14:23:00.350Z |
3820163 | 3820163 | 20240113170629_Xj3oz | KR000F | 2024-01-16T14:11:15.749Z | 2024-01-22T14:22:59.525Z |
3820035 | 3820035 | 20240113164949_A2GsK | KR000F | 2024-01-16T14:10:59.481Z | 2024-01-22T14:22:58.533Z |
3819981 | 3819981 | 20240113162352_hIAgr | KR000F | 2024-01-16T14:10:50.516Z | 2024-01-22T14:22:57.363Z |
3819819 | 3819819 | 20240113155646_9XI2O | KR000F | 2024-01-16T14:10:41.328Z | 2024-01-22T14:22:56.417Z |
3819457 | 3819457 | 20240113151713_1TUHN | KR000F | 2024-01-16T14:10:05.444Z | 2024-01-22T14:22:54.754Z |
3819388 | 3819388 | 20240113151128_Ww6if | KR000F | 2024-01-16T14:09:59.653Z | 2024-01-22T14:22:54.345Z |
3819291 | 3819291 | 20240113145050_yh0FB | KR000F | 2024-01-16T14:09:49.737Z | 2024-01-22T14:22:52.480Z |
3819130 | 3819130 | 20240113142947_beIxL | KR000F | 2024-01-16T14:09:30.855Z | 2024-01-22T14:22:50.261Z |
3814056 | 3814056 | 20240112210030_GPHD8 | KR000F | 2024-01-15T14:13:35.027Z | 2024-01-21T14:27:54.437Z |
3813713 | 3813713 | 20240112200122_4xODT | KR000F | 2024-01-15T14:13:15.275Z | 2024-01-21T14:27:53.830Z |
3813651 | 3813651 | 20240112195027_wfoSh | KR000F | 2024-01-15T14:13:11.757Z | 2024-01-21T14:27:53.394Z |
3813565 | 3813565 | 20240112193452_otFd7 | KR000F | 2024-01-15T14:13:04.769Z | 2024-01-21T14:27:53.229Z |
3813546 | 3813546 | 20240112193219_FaGXH | KR000F | 2024-01-15T14:13:03.731Z | 2024-01-21T14:27:53.181Z |
3813360 | 3813360 | 20240112190815_CVPi0 | KR000F | 2024-01-15T14:12:52.767Z | 2024-01-21T14:27:52.831Z |
3812936 | 3812936 | 20240112181226_NlTSj | KR000F | 2024-01-15T14:12:28.284Z | 2024-01-21T14:27:51.988Z |
3812924 | 3812924 | 20240112180901_q0cbD | KR000F | 2024-01-15T14:12:27.873Z | 2024-01-21T14:27:51.915Z |
3812666 | 3812666 | 20240112172456_CHoE3 | KR000F | 2024-01-15T14:12:12.626Z | 2024-01-21T14:27:51.089Z |
3812644 | 3812644 | 20240112172300_bBwKn | KR000F | 2024-01-15T14:12:11.827Z | 2024-01-21T14:27:51.018Z |
3812621 | 3812621 | 20240112171747_ESqYf | KR000F | 2024-01-15T14:12:10.908Z | 2024-01-21T14:27:50.959Z |
3811877 | 3811877 | 20240112150549_4KtYa | KR000F | 2024-01-15T14:11:04.768Z | 2024-01-21T14:27:49.045Z |
3811634 | 3811634 | 20240112142834_Pnafn | KR000F | 2024-01-15T14:10:48.869Z | 2024-01-21T14:27:48.499Z |
3811536 | 3811536 | 20240112141626_8non9 | KR000F | 2024-01-15T14:10:32.923Z | 2024-01-21T14:27:48.323Z |
3810413 | 3810413 | 20240112121327_UHIyM | KR000F | 2024-01-15T14:08:34.636Z | 2024-01-21T14:27:44.357Z |
3810191 | 3810191 | 20240112114709_q8hQh | KR000F | 2024-01-15T14:08:07.812Z | 2024-01-21T14:27:43.426Z |
3796790 | 3796790 | 20240110110948_EE2Cb | KR000F | 2024-01-13T14:10:22.274Z | 2024-01-19T14:27:22.783Z |
3777118 | 3777118 | 20240107212154_A2gtF | KR000F | 2024-01-10T14:12:25.534Z | 2024-01-16T14:27:28.321Z |
3776731 | 3776731 | 20240107204207_dx4JF | KR000F | 2024-01-10T14:12:01.357Z | 2024-01-16T14:27:27.036Z |
3775751 | 3775751 | 20240107191123_U87Np | KR000F | 2024-01-10T14:10:39.069Z | 2024-01-16T14:27:23.017Z |
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);