participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,845 rows where station_code = "KR003N" 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 |
---|---|---|---|---|---|
5069047 | 5069047 | 20240910133018_vt1fn | KR003N | 2024-09-14T12:19:24.745Z | 2024-09-16T12:20:16.256Z |
5069027 | 5069027 | 20240910132514_UnrSB | KR003N | 2024-09-14T12:19:24.133Z | 2024-09-16T12:20:16.183Z |
5068860 | 5068860 | 20240910125016_0XmdD | KR003N | 2024-09-14T12:19:22.249Z | 2024-09-16T12:20:15.476Z |
5068647 | 5068647 | 20240910115833_c1Bs3 | KR003N | 2024-09-14T12:19:19.828Z | 2024-09-16T12:20:14.557Z |
5068371 | 5068371 | 20240910112431_nlSUj | KR003N | 2024-09-14T12:19:13.323Z | 2024-09-16T12:20:13.648Z |
5068127 | 5068127 | 20240910105935_CGyvo | KR003N | 2024-09-14T12:19:09.425Z | 2024-09-16T12:20:12.936Z |
5063010 | 5063010 | 20240909193622_Tti4G | KR003N | 2024-09-14T12:13:17.542Z | 2024-09-16T12:19:41.286Z |
5062987 | 5062987 | 20240909193000_sMiEh | KR003N | 2024-09-14T12:13:13.872Z | 2024-09-16T12:19:40.711Z |
5062958 | 5062958 | 20240909192152_dG6ab | KR003N | 2024-09-14T12:13:08.867Z | 2024-09-16T12:19:40.612Z |
5062943 | 5062943 | 20240909191650_pt45K | KR003N | 2024-09-14T12:13:06.050Z | 2024-09-16T12:19:40.531Z |
5062913 | 5062913 | 20240909190007_2zDWy | KR003N | 2024-09-14T12:13:02.601Z | 2024-09-16T12:19:40.250Z |
5062854 | 5062854 | 20240909184205_D4Fhh | KR003N | 2024-09-14T12:12:58.779Z | 2024-09-16T12:19:39.850Z |
5062735 | 5062735 | 20240909180749_E0Gjb | KR003N | 2024-09-14T12:12:46.213Z | 2024-09-16T12:19:39.153Z |
5062667 | 5062667 | 20240909175817_WhEcE | KR003N | 2024-09-14T12:12:41.482Z | 2024-09-16T12:19:38.505Z |
5062662 | 5062662 | 20240909175809_uaKXy | KR003N | 2024-09-14T12:12:41.281Z | 2024-09-16T12:19:38.404Z |
5062510 | 5062510 | 20240909173426_7rKCO | KR003N | 2024-09-14T12:12:30.175Z | 2024-09-16T12:19:37.634Z |
5062501 | 5062501 | 20240909173409_7QyFq | KR003N | 2024-09-14T12:12:28.884Z | 2024-09-16T12:19:37.576Z |
5062467 | 5062467 | 20240909172828_yPbAQ | KR003N | 2024-09-14T12:12:24.421Z | 2024-09-16T12:19:37.459Z |
5062064 | 5062064 | 20240909164110_mBRhW | KR003N | 2024-09-14T12:11:47.412Z | 2024-09-16T12:19:35.399Z |
5061927 | 5061927 | 20240909162328_YAbE2 | KR003N | 2024-09-14T12:11:39.236Z | 2024-09-16T12:19:34.698Z |
5061883 | 5061883 | 20240909161757_UnePY | KR003N | 2024-09-14T12:11:35.410Z | 2024-09-16T12:19:34.449Z |
5060069 | 5060069 | 20240910194639_60vRe | KR003N | 2024-09-14T12:08:08.822Z | 2024-09-16T12:18:12.549Z |
5060044 | 5060044 | 20240910194057_sKHdK | KR003N | 2024-09-14T12:08:03.558Z | 2024-09-16T12:18:11.744Z |
5059994 | 5059994 | 20240910192804_F2KZF | KR003N | 2024-09-14T12:07:54.114Z | 2024-09-16T12:18:10.690Z |
5059951 | 5059951 | 20240910192323_GrQ6w | KR003N | 2024-09-14T12:07:48.777Z | 2024-09-16T12:18:10.311Z |
5059925 | 5059925 | 20240910192012_NrjjJ | KR003N | 2024-09-14T12:07:41.431Z | 2024-09-16T12:18:10.183Z |
5059909 | 5059909 | 20240910191748_Aup3J | KR003N | 2024-09-14T12:07:36.323Z | 2024-09-16T12:18:10.000Z |
5059879 | 5059879 | 20240910191247_Yt2HJ | KR003N | 2024-09-14T12:07:31.107Z | 2024-09-16T12:18:09.761Z |
5059724 | 5059724 | 20240910183758_JCzBA | KR003N | 2024-09-14T12:06:52.937Z | 2024-09-16T12:18:07.894Z |
5059526 | 5059526 | 20240910180012_sTK6A | KR003N | 2024-09-14T12:06:18.240Z | 2024-09-16T12:18:05.805Z |
5059502 | 5059502 | 20240910175407_66V5Y | KR003N | 2024-09-14T12:06:14.203Z | 2024-09-16T12:18:05.496Z |
5059479 | 5059479 | 20240910174829_N2Bgi | KR003N | 2024-09-14T12:06:12.075Z | 2024-09-16T12:18:05.323Z |
5059298 | 5059298 | 20240910172907_no2x6 | KR003N | 2024-09-14T12:05:38.072Z | 2024-09-16T12:18:03.345Z |
5059058 | 5059058 | 20240910170933_N526q | KR003N | 2024-09-14T12:05:09.523Z | 2024-09-16T12:18:01.351Z |
5058981 | 5058981 | 20240910170547_gvM7x | KR003N | 2024-09-14T12:05:03.561Z | 2024-09-16T12:18:00.212Z |
5058690 | 5058690 | 20240910163715_RfBgD | KR003N | 2024-09-14T12:04:19.862Z | 2024-09-16T12:17:57.146Z |
5058600 | 5058600 | 20240910162948_VgBuE | KR003N | 2024-09-14T12:04:06.378Z | 2024-09-16T12:17:56.396Z |
5058200 | 5058200 | 20240910155218_li1zq | KR003N | 2024-09-14T12:03:08.270Z | 2024-09-16T12:17:51.692Z |
5058119 | 5058119 | 20240910154651_O6Lu1 | KR003N | 2024-09-14T12:02:59.606Z | 2024-09-16T12:17:50.270Z |
5057493 | 5057493 | 20240910143528_SjeBW | KR003N | 2024-09-14T12:01:13.388Z | 2024-09-16T12:17:44.526Z |
5057321 | 5057321 | 20240910141111_uXUgj | KR003N | 2024-09-14T12:00:49.928Z | 2024-09-16T12:17:42.407Z |
5052255 | 5052255 | 20240907200437_H3fV4 | KR003N | 2024-09-13T12:15:01.842Z | 2024-09-16T12:21:04.798Z |
5052119 | 5052119 | 20240907194225_KKno8 | KR003N | 2024-09-13T12:14:57.240Z | 2024-09-16T12:21:03.801Z |
5052104 | 5052104 | 20240907194101_Vm96s | KR003N | 2024-09-13T12:14:56.612Z | 2024-09-16T12:21:03.718Z |
5052088 | 5052088 | 20240907193939_lR2tY | KR003N | 2024-09-13T12:14:56.091Z | 2024-09-16T12:21:03.637Z |
5051889 | 5051889 | 20240907190040_dqkUB | KR003N | 2024-09-13T12:14:42.097Z | 2024-09-16T12:21:02.406Z |
5051881 | 5051881 | 20240907190028_91T6Z | KR003N | 2024-09-13T12:14:41.589Z | 2024-09-16T12:21:02.368Z |
5051842 | 5051842 | 20240907185013_Cmv0Q | KR003N | 2024-09-13T12:14:37.478Z | 2024-09-16T12:21:02.118Z |
5051822 | 5051822 | 20240907184659_PFAOm | KR003N | 2024-09-13T12:14:36.519Z | 2024-09-16T12:21:02.087Z |
5051815 | 5051815 | 20240907184600_dJ2Jm | KR003N | 2024-09-13T12:14:36.271Z | 2024-09-16T12:21:02.081Z |
5051752 | 5051752 | 20240907183121_ilKTJ | KR003N | 2024-09-13T12:14:32.454Z | 2024-09-16T12:21:01.809Z |
5051716 | 5051716 | 20240907182647_XEdwp | KR003N | 2024-09-13T12:14:30.478Z | 2024-09-16T12:21:01.653Z |
5051709 | 5051709 | 20240907182637_0wh1F | KR003N | 2024-09-13T12:14:30.329Z | 2024-09-16T12:21:01.645Z |
5051583 | 5051583 | 20240907174734_6Qmkf | KR003N | 2024-09-13T12:14:23.420Z | 2024-09-16T12:21:01.353Z |
5051290 | 5051290 | 20240907171244_s8h9m | KR003N | 2024-09-13T12:14:09.067Z | 2024-09-16T12:21:00.033Z |
5051263 | 5051263 | 20240907171014_D63h0 | KR003N | 2024-09-13T12:14:08.169Z | 2024-09-16T12:20:59.945Z |
5050149 | 5050149 | 20240907144001_ABzy3 | KR003N | 2024-09-13T12:13:12.492Z | 2024-09-16T12:20:56.447Z |
5042951 | 5042951 | 20240907131935_ek2K5 | KR003N | 2024-09-12T12:17:21.089Z | 2024-09-16T12:20:54.948Z |
5018470 | 5018470 | 20240904181632_GqTBY | KR003N | 2024-09-10T12:10:40.899Z | 2024-09-13T12:19:47.942Z |
5018412 | 5018412 | 20240904180141_4oUuA | KR003N | 2024-09-10T12:10:35.093Z | 2024-09-13T12:19:47.824Z |
5018369 | 5018369 | 20240904174959_atdsV | KR003N | 2024-09-10T12:10:31.302Z | 2024-09-13T12:19:47.657Z |
5018364 | 5018364 | 20240904174854_MYRRm | KR003N | 2024-09-10T12:10:30.834Z | 2024-09-13T12:19:47.654Z |
5018362 | 5018362 | 20240904174803_CRyqe | KR003N | 2024-09-10T12:10:30.562Z | 2024-09-13T12:19:47.653Z |
5018338 | 5018338 | 20240904174346_vq03Z | KR003N | 2024-09-10T12:10:28.999Z | 2024-09-13T12:19:47.606Z |
5018211 | 5018211 | 20240904172705_KCxpU | KR003N | 2024-09-10T12:10:10.938Z | 2024-09-13T12:19:47.441Z |
5018110 | 5018110 | 20240904171133_GCEtp | KR003N | 2024-09-10T12:10:00.606Z | 2024-09-13T12:19:47.209Z |
5017330 | 5017330 | 20240904155835_HRqbJ | KR003N | 2024-09-10T12:09:03.941Z | 2024-09-13T12:19:46.794Z |
5017090 | 5017090 | 20240904153027_m5H2V | KR003N | 2024-09-10T12:08:46.877Z | 2024-09-13T12:19:46.572Z |
5016975 | 5016975 | 20240904151527_mXYD2 | KR003N | 2024-09-10T12:08:36.049Z | 2024-09-13T12:19:46.481Z |
5016850 | 5016850 | 20240904150413_2que7 | KR003N | 2024-09-10T12:08:24.198Z | 2024-09-13T12:19:46.390Z |
5016626 | 5016626 | 20240904143254_qg89V | KR003N | 2024-09-10T12:08:01.625Z | 2024-09-13T12:19:45.929Z |
5016478 | 5016478 | 20240904141916_S5CJC | KR003N | 2024-09-10T12:07:52.611Z | 2024-09-13T12:19:45.812Z |
5016388 | 5016388 | 20240904141116_rNzpM | KR003N | 2024-09-10T12:07:46.319Z | 2024-09-13T12:19:45.595Z |
5016228 | 5016228 | 20240904134558_PMhGK | KR003N | 2024-09-10T12:07:35.227Z | 2024-09-13T12:19:45.352Z |
5015725 | 5015725 | 20240904122021_llJIa | KR003N | 2024-09-10T12:06:41.930Z | 2024-09-13T12:19:44.626Z |
5007017 | 5007017 | 20240903194823_AwMpT | KR003N | 2024-09-09T12:05:19.828Z | 2024-09-12T12:19:11.122Z |
5006896 | 5006896 | 20240903192250_xF33Z | KR003N | 2024-09-09T12:05:11.595Z | 2024-09-12T12:19:10.815Z |
5006847 | 5006847 | 20240903191114_qw5i0 | KR003N | 2024-09-09T12:05:08.339Z | 2024-09-12T12:19:10.314Z |
5006831 | 5006831 | 20240903190745_4KBmj | KR003N | 2024-09-09T12:05:07.207Z | 2024-09-12T12:19:10.240Z |
5006281 | 5006281 | 20240903171053_h7w8E | KR003N | 2024-09-09T12:04:28.849Z | 2024-09-12T12:19:08.073Z |
5006255 | 5006255 | 20240903170940_fFeU9 | KR003N | 2024-09-09T12:04:26.851Z | 2024-09-12T12:19:08.042Z |
5006217 | 5006217 | 20240903170557_N2Hhk | KR003N | 2024-09-09T12:04:25.230Z | 2024-09-12T12:19:07.975Z |
5006156 | 5006156 | 20240903170128_5pCw6 | KR003N | 2024-09-09T12:04:22.817Z | 2024-09-12T12:19:07.736Z |
5005998 | 5005998 | 20240903164022_u2Og1 | KR003N | 2024-09-09T12:04:15.784Z | 2024-09-12T12:19:07.172Z |
5005950 | 5005950 | 20240903163726_SqBCQ | KR003N | 2024-09-09T12:04:13.983Z | 2024-09-12T12:19:07.105Z |
5005832 | 5005832 | 20240903161929_uw7R8 | KR003N | 2024-09-09T12:04:09.076Z | 2024-09-12T12:19:06.952Z |
5005807 | 5005807 | 20240903161505_bwA1c | KR003N | 2024-09-09T12:04:07.501Z | 2024-09-12T12:19:06.914Z |
5005727 | 5005727 | 20240903160112_iWYYI | KR003N | 2024-09-09T12:04:00.014Z | 2024-09-12T12:19:06.512Z |
5005604 | 5005604 | 20240903154216_IDWfe | KR003N | 2024-09-09T12:03:50.906Z | 2024-09-12T12:19:06.244Z |
5005552 | 5005552 | 20240903153257_XwCtD | KR003N | 2024-09-09T12:03:48.432Z | 2024-09-12T12:19:06.158Z |
5005396 | 5005396 | 20240903150530_6huL6 | KR003N | 2024-09-09T12:03:40.581Z | 2024-09-12T12:19:05.871Z |
5005228 | 5005228 | 20240903143409_8iZOc | KR003N | 2024-09-09T12:03:27.742Z | 2024-09-12T12:19:05.499Z |
5005215 | 5005215 | 20240903143135_MdMDc | KR003N | 2024-09-09T12:03:26.999Z | 2024-09-12T12:19:05.464Z |
5005125 | 5005125 | 20240903140407_OM6dg | KR003N | 2024-09-09T12:03:21.324Z | 2024-09-12T12:19:05.310Z |
5005030 | 5005030 | 20240903134923_fhW43 | KR003N | 2024-09-09T12:03:16.668Z | 2024-09-12T12:19:05.165Z |
5004961 | 5004961 | 20240903133931_ERlHh | KR003N | 2024-09-09T12:03:13.953Z | 2024-09-12T12:19:04.613Z |
5004914 | 5004914 | 20240903132310_Oq56i | KR003N | 2024-09-09T12:03:10.964Z | 2024-09-12T12:19:04.468Z |
5004717 | 5004717 | 20240903121326_tfc0c | KR003N | 2024-09-09T12:02:56.136Z | 2024-09-12T12:19:03.588Z |
5004699 | 5004699 | 20240903121011_2ZDUn | KR003N | 2024-09-09T12:02:55.329Z | 2024-09-12T12:19:03.545Z |
5004228 | 5004228 | 20240903105923_GSQAg | KR003N | 2024-09-09T12:02:28.907Z | 2024-09-12T12:19:01.293Z |
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);