participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,567 rows where station_code = "KR003A" 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 |
---|---|---|---|---|---|
5069096 | 5069096 | 20240910134117_M5Nml | KR003A | 2024-09-14T12:19:25.514Z | 2024-09-16T12:20:16.426Z |
5068984 | 5068984 | 20240910131902_IH6hn | KR003A | 2024-09-14T12:19:23.476Z | 2024-09-16T12:20:16.049Z |
5068369 | 5068369 | 20240910112431_nlSUj | KR003A | 2024-09-14T12:19:13.323Z | 2024-09-16T12:20:13.648Z |
5063064 | 5063064 | 20240909194719_BqAke | KR003A | 2024-09-14T12:13:23.618Z | 2024-09-16T12:19:41.483Z |
5063009 | 5063009 | 20240909193622_Tti4G | KR003A | 2024-09-14T12:13:17.542Z | 2024-09-16T12:19:41.286Z |
5062971 | 5062971 | 20240909192313_TKlW1 | KR003A | 2024-09-14T12:13:11.315Z | 2024-09-16T12:19:40.641Z |
5062912 | 5062912 | 20240909190007_2zDWy | KR003A | 2024-09-14T12:13:02.601Z | 2024-09-16T12:19:40.250Z |
5062801 | 5062801 | 20240909182644_dAi2F | KR003A | 2024-09-14T12:12:52.608Z | 2024-09-16T12:19:39.604Z |
5062466 | 5062466 | 20240909172828_yPbAQ | KR003A | 2024-09-14T12:12:24.421Z | 2024-09-16T12:19:37.459Z |
5062201 | 5062201 | 20240909165640_Zp6kP | KR003A | 2024-09-14T12:11:55.356Z | 2024-09-16T12:19:36.360Z |
5062063 | 5062063 | 20240909164110_mBRhW | KR003A | 2024-09-14T12:11:47.412Z | 2024-09-16T12:19:35.399Z |
5061882 | 5061882 | 20240909161757_UnePY | KR003A | 2024-09-14T12:11:35.410Z | 2024-09-16T12:19:34.449Z |
5061720 | 5061720 | 20240909154730_YffD4 | KR003A | 2024-09-14T12:11:15.518Z | 2024-09-16T12:19:33.248Z |
5061379 | 5061379 | 20240909145805_mdzcw | KR003A | 2024-09-14T12:10:45.246Z | 2024-09-16T12:19:31.226Z |
5060963 | 5060963 | 20240909133743_eMNxz | KR003A | 2024-09-14T12:09:59.639Z | 2024-09-16T12:19:28.427Z |
5060043 | 5060043 | 20240910194057_sKHdK | KR003A | 2024-09-14T12:08:03.558Z | 2024-09-16T12:18:11.744Z |
5056995 | 5056995 | 20240908115054_eT4cV | KR003A | 2024-09-13T12:17:42.478Z | 2024-09-16T12:21:28.300Z |
5056916 | 5056916 | 20240908114126_TGFHk | KR003A | 2024-09-13T12:17:41.062Z | 2024-09-16T12:21:27.803Z |
5052174 | 5052174 | 20240907195401_4eH3T | KR003A | 2024-09-13T12:14:59.333Z | 2024-09-16T12:21:04.309Z |
5052118 | 5052118 | 20240907194225_KKno8 | KR003A | 2024-09-13T12:14:57.240Z | 2024-09-16T12:21:03.801Z |
5052103 | 5052103 | 20240907194101_Vm96s | KR003A | 2024-09-13T12:14:56.612Z | 2024-09-16T12:21:03.718Z |
5052077 | 5052077 | 20240907193920_0lsOX | KR003A | 2024-09-13T12:14:55.962Z | 2024-09-16T12:21:03.631Z |
5051530 | 5051530 | 20240907173958_BsCRO | KR003A | 2024-09-13T12:14:21.776Z | 2024-09-16T12:21:01.152Z |
5051405 | 5051405 | 20240907172505_9Uefc | KR003A | 2024-09-13T12:14:13.459Z | 2024-09-16T12:21:00.347Z |
5051289 | 5051289 | 20240907171244_s8h9m | KR003A | 2024-09-13T12:14:09.067Z | 2024-09-16T12:21:00.033Z |
5051280 | 5051280 | 20240907171051_CtB2j | KR003A | 2024-09-13T12:14:08.554Z | 2024-09-16T12:21:00.001Z |
5051262 | 5051262 | 20240907171014_D63h0 | KR003A | 2024-09-13T12:14:08.169Z | 2024-09-16T12:20:59.945Z |
5051060 | 5051060 | 20240907164105_UBoOS | KR003A | 2024-09-13T12:14:00.376Z | 2024-09-16T12:20:59.525Z |
5050880 | 5050880 | 20240907162033_3kRYl | KR003A | 2024-09-13T12:13:51.305Z | 2024-09-16T12:20:59.023Z |
5050409 | 5050409 | 20240907151835_Pn3K8 | KR003A | 2024-09-13T12:13:30.591Z | 2024-09-16T12:20:57.580Z |
5050302 | 5050302 | 20240907150527_Pme6E | KR003A | 2024-09-13T12:13:23.138Z | 2024-09-16T12:20:56.974Z |
5050188 | 5050188 | 20240907144605_a96df | KR003A | 2024-09-13T12:13:16.062Z | 2024-09-16T12:20:56.674Z |
5045584 | 5045584 | 20240908172622_0973w | KR003A | 2024-09-13T12:04:23.939Z | 2024-09-16T12:20:26.178Z |
5045470 | 5045470 | 20240908170756_fm7EV | KR003A | 2024-09-13T12:04:11.799Z | 2024-09-16T12:20:25.880Z |
5045291 | 5045291 | 20240908164911_1cIsX | KR003A | 2024-09-13T12:03:51.824Z | 2024-09-16T12:20:25.349Z |
5044934 | 5044934 | 20240908155706_ubJT8 | KR003A | 2024-09-13T12:03:14.026Z | 2024-09-16T12:20:23.889Z |
5044357 | 5044357 | 20240908145000_X7WTK | KR003A | 2024-09-13T12:02:02.562Z | 2024-09-16T12:20:21.668Z |
5044017 | 5044017 | 20240908135353_9E911 | KR003A | 2024-09-13T12:01:15.535Z | 2024-09-16T12:20:19.671Z |
5043898 | 5043898 | 20240908133325_D3XmD | KR003A | 2024-09-13T12:00:56.199Z | 2024-09-16T12:20:19.457Z |
5043815 | 5043815 | 20240908131513_9N3qv | KR003A | 2024-09-13T12:00:44.180Z | 2024-09-16T12:20:19.017Z |
5043705 | 5043705 | 20240908124659_9i65i | KR003A | 2024-09-13T12:00:27.405Z | 2024-09-16T12:20:18.606Z |
5043049 | 5043049 | 20240907134047_a8A6Q | KR003A | 2024-09-12T12:17:22.170Z | 2024-09-16T12:20:55.203Z |
5042584 | 5042584 | 20240907120537_Wng3w | KR003A | 2024-09-12T12:17:15.518Z | 2024-09-16T12:20:53.638Z |
5018178 | 5018178 | 20240904172313_QIsJo | KR003A | 2024-09-10T12:10:07.142Z | 2024-09-13T12:19:47.357Z |
5017700 | 5017700 | 20240904163315_PuZlM | KR003A | 2024-09-10T12:09:24.667Z | 2024-09-13T12:19:47.057Z |
5017696 | 5017696 | 20240904163301_mMseo | KR003A | 2024-09-10T12:09:24.427Z | 2024-09-13T12:19:47.056Z |
5016974 | 5016974 | 20240904151527_mXYD2 | KR003A | 2024-09-10T12:08:36.049Z | 2024-09-13T12:19:46.481Z |
5016849 | 5016849 | 20240904150413_2que7 | KR003A | 2024-09-10T12:08:24.198Z | 2024-09-13T12:19:46.390Z |
5016387 | 5016387 | 20240904141116_rNzpM | KR003A | 2024-09-10T12:07:46.319Z | 2024-09-13T12:19:45.595Z |
5016305 | 5016305 | 20240904135908_moQ2d | KR003A | 2024-09-10T12:07:40.225Z | 2024-09-13T12:19:45.481Z |
5015497 | 5015497 | 20240904114535_oMOlM | KR003A | 2024-09-10T12:06:15.756Z | 2024-09-13T12:19:44.161Z |
5006987 | 5006987 | 20240903193956_LhEJZ | KR003A | 2024-09-09T12:05:17.668Z | 2024-09-12T12:19:11.010Z |
5006830 | 5006830 | 20240903190745_4KBmj | KR003A | 2024-09-09T12:05:07.207Z | 2024-09-12T12:19:10.240Z |
5006800 | 5006800 | 20240903185919_P0xTk | KR003A | 2024-09-09T12:05:05.132Z | 2024-09-12T12:19:09.535Z |
5006714 | 5006714 | 20240903183747_D52PW | KR003A | 2024-09-09T12:04:56.767Z | 2024-09-12T12:19:09.295Z |
5006280 | 5006280 | 20240903171053_h7w8E | KR003A | 2024-09-09T12:04:28.849Z | 2024-09-12T12:19:08.073Z |
5006147 | 5006147 | 20240903170049_4KQc7 | KR003A | 2024-09-09T12:04:22.542Z | 2024-09-12T12:19:07.695Z |
5006139 | 5006139 | 20240903165936_bEna6 | KR003A | 2024-09-09T12:04:22.232Z | 2024-09-12T12:19:07.688Z |
5005997 | 5005997 | 20240903164022_u2Og1 | KR003A | 2024-09-09T12:04:15.784Z | 2024-09-12T12:19:07.172Z |
5005949 | 5005949 | 20240903163726_SqBCQ | KR003A | 2024-09-09T12:04:13.983Z | 2024-09-12T12:19:07.105Z |
5005831 | 5005831 | 20240903161929_uw7R8 | KR003A | 2024-09-09T12:04:09.076Z | 2024-09-12T12:19:06.952Z |
5005513 | 5005513 | 20240903152639_RAOYm | KR003A | 2024-09-09T12:03:46.948Z | 2024-09-12T12:19:06.120Z |
5005395 | 5005395 | 20240903150530_6huL6 | KR003A | 2024-09-09T12:03:40.581Z | 2024-09-12T12:19:05.871Z |
5005119 | 5005119 | 20240903140240_zNUxp | KR003A | 2024-09-09T12:03:21.080Z | 2024-09-12T12:19:05.306Z |
5004912 | 5004912 | 20240903132310_Oq56i | KR003A | 2024-09-09T12:03:10.964Z | 2024-09-12T12:19:04.468Z |
5003121 | 5003121 | 20240904111511_Ceqw6 | KR003A | 2024-09-09T12:01:22.595Z | 2024-09-13T12:19:43.417Z |
4995879 | 4995879 | 20240902180408_SFzXq | KR003A | 2024-09-08T12:04:09.362Z | 2024-09-11T12:20:49.221Z |
4995861 | 4995861 | 20240902180135_25U7B | KR003A | 2024-09-08T12:04:08.439Z | 2024-09-11T12:20:49.136Z |
4995727 | 4995727 | 20240902173922_7xh2m | KR003A | 2024-09-08T12:03:57.657Z | 2024-09-11T12:20:47.599Z |
4995350 | 4995350 | 20240902164447_ekSAN | KR003A | 2024-09-08T12:03:34.798Z | 2024-09-11T12:20:44.655Z |
4962843 | 4962843 | 20240811192710_hSniY | KR003A | 2024-09-04T12:04:55.111Z | 2024-09-06T12:04:08.317Z |
4962697 | 4962697 | 20240811191643_u4ZnD | KR003A | 2024-09-04T12:04:47.698Z | 2024-09-06T12:03:58.237Z |
4962617 | 4962617 | 20240811191227_urrvq | KR003A | 2024-09-04T12:04:43.598Z | 2024-09-06T12:03:53.543Z |
4962418 | 4962418 | 20240811185535_Rh3YI | KR003A | 2024-09-04T12:04:29.531Z | 2024-09-06T12:03:45.548Z |
4962407 | 4962407 | 20240811185517_0CWb3 | KR003A | 2024-09-04T12:04:28.911Z | 2024-09-06T12:03:45.038Z |
4962302 | 4962302 | 20240811184740_GQE2L | KR003A | 2024-09-04T12:04:24.465Z | 2024-09-06T12:03:41.142Z |
4962299 | 4962299 | 20240811184709_jTQpm | KR003A | 2024-09-04T12:04:24.352Z | 2024-09-06T12:03:40.762Z |
4962147 | 4962147 | 20240811183806_I0rkZ | KR003A | 2024-09-04T12:04:18.932Z | 2024-09-06T12:03:31.627Z |
4962119 | 4962119 | 20240811183622_AD4Qa | KR003A | 2024-09-04T12:04:17.087Z | 2024-09-06T12:03:30.165Z |
4962097 | 4962097 | 20240811183548_Whx1n | KR003A | 2024-09-04T12:04:16.328Z | 2024-09-06T12:03:29.395Z |
4961981 | 4961981 | 20240811182120_6O23Z | KR003A | 2024-09-04T12:04:06.682Z | 2024-09-06T12:03:22.434Z |
4961779 | 4961779 | 20240811180255_THIW2 | KR003A | 2024-09-04T12:03:55.099Z | 2024-09-06T12:03:14.419Z |
4961761 | 4961761 | 20240811180136_DGSAd | KR003A | 2024-09-04T12:03:54.148Z | 2024-09-06T12:03:13.647Z |
4961594 | 4961594 | 20240811175116_wYqcY | KR003A | 2024-09-04T12:03:46.677Z | 2024-09-06T12:03:07.011Z |
4961393 | 4961393 | 20240811173715_MEtCZ | KR003A | 2024-09-04T12:03:34.838Z | 2024-09-06T12:02:55.063Z |
4961361 | 4961361 | 20240811173412_xrNOP | KR003A | 2024-09-04T12:03:33.246Z | 2024-09-06T12:02:53.713Z |
4961354 | 4961354 | 20240811173338_Nio9v | KR003A | 2024-09-04T12:03:32.852Z | 2024-09-06T12:02:53.361Z |
4961189 | 4961189 | 20240811172301_YqPI0 | KR003A | 2024-09-04T12:03:22.064Z | 2024-09-06T12:02:46.884Z |
4961184 | 4961184 | 20240811172250_mP7Zr | KR003A | 2024-09-04T12:03:21.924Z | 2024-09-06T12:02:46.789Z |
4961012 | 4961012 | 20240811170951_Lsf28 | KR003A | 2024-09-04T12:03:11.377Z | 2024-09-06T12:02:39.177Z |
4960912 | 4960912 | 20240811170136_T3ZMS | KR003A | 2024-09-04T12:03:05.126Z | 2024-09-06T12:02:32.710Z |
4960902 | 4960902 | 20240811170032_T1Bcw | KR003A | 2024-09-04T12:03:04.441Z | 2024-09-06T12:02:32.080Z |
4960604 | 4960604 | 20240811163702_3G120 | KR003A | 2024-09-04T12:02:45.409Z | 2024-09-06T12:02:17.635Z |
4960417 | 4960417 | 20240811162440_9LwZI | KR003A | 2024-09-04T12:02:31.601Z | 2024-09-06T12:02:08.488Z |
4960351 | 4960351 | 20240811161837_8xuDX | KR003A | 2024-09-04T12:02:27.463Z | 2024-09-06T12:02:04.802Z |
4960314 | 4960314 | 20240811161523_tSoTl | KR003A | 2024-09-04T12:02:25.193Z | 2024-09-06T12:02:02.751Z |
4960215 | 4960215 | 20240811161039_QQjpc | KR003A | 2024-09-04T12:02:19.699Z | 2024-09-06T12:01:58.574Z |
4960202 | 4960202 | 20240811160932_58156 | KR003A | 2024-09-04T12:02:18.915Z | 2024-09-06T12:01:58.051Z |
4960054 | 4960054 | 20240811155756_CKCen | KR003A | 2024-09-04T12:02:09.292Z | 2024-09-06T12:01:50.408Z |
4959829 | 4959829 | 20240811154054_z3F6m | KR003A | 2024-09-04T12:01:58.083Z | 2024-09-06T12:01:39.209Z |
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);