participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
438 rows where station_code = "KR001K" 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 |
---|---|---|---|---|---|
5131542 | 5131542 | 20240915201317_7vOkI | KR001K | 2024-09-19T12:15:08.482Z | 2024-09-24T12:15:34.808Z |
5131220 | 5131220 | 20240915183542_3rPxD | KR001K | 2024-09-19T12:14:39.638Z | 2024-09-24T12:15:31.902Z |
5131208 | 5131208 | 20240915183023_aazRF | KR001K | 2024-09-19T12:14:38.258Z | 2024-09-24T12:15:31.794Z |
5131147 | 5131147 | 20240915180731_wK5F6 | KR001K | 2024-09-19T12:14:29.684Z | 2024-09-24T12:15:31.408Z |
5098701 | 5098701 | 20240913190317_LdFx4 | KR001K | 2024-09-17T12:01:23.178Z | 2024-09-22T12:17:43.031Z |
5098646 | 5098646 | 20240913184723_dPSVm | KR001K | 2024-09-17T12:01:13.114Z | 2024-09-22T12:17:42.556Z |
5098606 | 5098606 | 20240913183325_5iqQv | KR001K | 2024-09-17T12:01:03.798Z | 2024-09-22T12:17:42.182Z |
5098496 | 5098496 | 20240913173736_3w2FF | KR001K | 2024-09-17T12:00:45.870Z | 2024-09-22T12:17:40.951Z |
5098459 | 5098459 | 20240913172550_8Ucjs | KR001K | 2024-09-17T12:00:39.904Z | 2024-09-22T12:17:40.652Z |
4934594 | 4934594 | 20240810183640_bgJOw | KR001K | 2024-09-01T12:05:33.609Z | 2024-09-06T12:20:15.944Z |
4897130 | 4897130 | 20240807171301_yr6Ak | KR001K | 2024-08-28T12:15:07.468Z | 2024-08-28T12:15:07.468Z |
4897068 | 4897068 | 20240807170550_dH4lF | KR001K | 2024-08-28T12:15:02.537Z | 2024-08-28T12:15:02.537Z |
4897002 | 4897002 | 20240807165703_XzfdJ | KR001K | 2024-08-28T12:14:58.943Z | 2024-08-28T12:14:58.943Z |
4896929 | 4896929 | 20240807164254_ugAq6 | KR001K | 2024-08-28T12:14:52.983Z | 2024-08-28T12:14:52.983Z |
4896881 | 4896881 | 20240807163603_Cn2vg | KR001K | 2024-08-28T12:14:50.572Z | 2024-08-28T12:14:50.572Z |
4848720 | 4848720 | 20240805171905_k2DDt | KR001K | 2024-08-17T12:10:53.993Z | 2024-08-19T12:21:39.014Z |
4848231 | 4848231 | 20240805165754_09OJd | KR001K | 2024-08-17T12:10:18.907Z | 2024-08-19T12:21:14.914Z |
4848091 | 4848091 | 20240805165246_wWXY3 | KR001K | 2024-08-17T12:10:10.343Z | 2024-08-19T12:21:13.013Z |
4813041 | 4813041 | 20240803152411_97gkt | KR001K | 2024-08-13T12:11:31.111Z | 2024-08-15T12:21:20.765Z |
4755181 | 4755181 | 20240730161406_N5SFE | KR001K | 2024-08-05T12:10:47.748Z | 2024-08-08T12:21:10.850Z |
4755063 | 4755063 | 20240730160111_nUxfn | KR001K | 2024-08-05T12:10:40.528Z | 2024-08-08T12:21:09.141Z |
4753744 | 4753744 | 20240730133010_lnc3h | KR001K | 2024-08-05T12:08:47.868Z | 2024-08-08T12:20:46.140Z |
4738732 | 4738732 | 20240729125612_dxJbC | KR001K | 2024-08-03T12:09:11.494Z | 2024-08-06T12:15:11.002Z |
4725961 | 4725961 | 20240728153208_vLXzb | KR001K | 2024-07-31T12:11:51.674Z | 2024-08-05T12:20:21.750Z |
4689249 | 4689249 | 20240724181015_B67OK | KR001K | 2024-07-26T12:11:22.862Z | 2024-08-01T12:12:08.706Z |
4670591 | 4670591 | 20240719182149_22Lis | KR001K | 2024-07-21T12:01:32.072Z | 2024-07-28T12:14:49.828Z |
4670392 | 4670392 | 20240719150326_HADn2 | KR001K | 2024-07-21T12:01:07.291Z | 2024-07-28T12:14:48.779Z |
4512808 | 4512808 | 20240627180646_VvJ22 | KR001K | 2024-06-29T12:04:18.108Z | 2024-07-06T12:16:14.170Z |
4512673 | 4512673 | 20240627175042_Bb5o0 | KR001K | 2024-06-29T12:04:12.370Z | 2024-07-06T12:16:13.974Z |
4512493 | 4512493 | 20240627172942_YWWFk | KR001K | 2024-06-29T12:03:58.215Z | 2024-07-06T12:16:13.634Z |
4512400 | 4512400 | 20240627172139_KHSwl | KR001K | 2024-06-29T12:03:49.383Z | 2024-07-06T12:16:13.414Z |
4507280 | 4507280 | 20240627170710_Vrmdp | KR001K | 2024-06-28T12:01:16.955Z | 2024-07-06T12:16:13.170Z |
4507109 | 4507109 | 20240627155842_myNGk | KR001K | 2024-06-28T12:01:04.080Z | 2024-07-06T12:16:12.132Z |
4506996 | 4506996 | 20240627153716_g8wOe | KR001K | 2024-06-28T12:00:58.250Z | 2024-07-06T12:16:11.762Z |
4506836 | 4506836 | 20240627145809_syWaY | KR001K | 2024-06-28T12:00:46.008Z | 2024-07-06T12:16:10.465Z |
4498663 | 4498663 | 20240625172702_mfI1Z | KR001K | 2024-06-26T12:01:01.893Z | 2024-07-04T12:08:45.746Z |
4490817 | 4490817 | 20240620161055_6Y5LP | KR001K | 2024-06-22T12:03:08.844Z | 2024-06-29T12:13:26.313Z |
4405776 | 4405776 | 20240602184755_AhRii | KR001K | 2024-06-04T12:05:14.151Z | 2024-06-11T12:13:32.116Z |
4376835 | 4376835 | 20240519155504_B32o6 | KR001K | 2024-05-27T12:11:47.949Z | 2024-05-27T12:11:47.949Z |
4345183 | 4345183 | 20240510160003_XkykE | KR001K | 2024-05-20T12:02:54.753Z | 2024-05-22T12:09:59.218Z |
4340553 | 4340553 | 20240509190401_T4gTj | KR001K | 2024-05-19T12:07:10.250Z | 2024-05-21T12:09:18.582Z |
4329060 | 4329060 | 20240508181356_9vSB9 | KR001K | 2024-05-17T12:08:21.725Z | 2024-05-19T12:14:12.564Z |
4127684 | 4127684 | 20240330195744_xlejF | KR001K | 2024-04-01T12:04:14.153Z | 2024-04-08T12:18:27.696Z |
4127679 | 4127679 | 20240330195638_WHaqr | KR001K | 2024-04-01T12:04:13.778Z | 2024-04-08T12:18:27.674Z |
4075742 | 4075742 | 20240315202500_SkbIQ | KR001K | 2024-03-17T12:06:32.749Z | 2024-03-24T12:20:35.071Z |
4056811 | 4056811 | 20240309203412_FtA2T | KR001K | 2024-03-11T12:08:35.256Z | 2024-03-18T12:19:57.904Z |
4056466 | 4056466 | 20240309193918_2w7j4 | KR001K | 2024-03-11T12:08:12.533Z | 2024-03-18T12:19:53.939Z |
4056026 | 4056026 | 20240309182829_FcMBj | KR001K | 2024-03-11T12:07:33.188Z | 2024-03-18T12:19:50.743Z |
4054755 | 4054755 | 20240309161035_bd3Wq | KR001K | 2024-03-11T12:05:31.177Z | 2024-03-18T12:19:39.987Z |
4016505 | 4016505 | 20240301204503_m4Ny2 | KR001K | 2024-03-03T14:05:42.731Z | 2024-03-10T12:21:16.311Z |
3985082 | 3985082 | 20240217174702_en6Ht | KR001K | 2024-02-19T14:04:42.687Z | 2024-02-26T14:16:20.712Z |
3984887 | 3984887 | 20240217164032_BzqeA | KR001K | 2024-02-19T14:04:11.447Z | 2024-02-26T14:16:12.791Z |
3984796 | 3984796 | 20240217162253_cg89d | KR001K | 2024-02-19T14:03:59.146Z | 2024-02-26T14:16:10.293Z |
3980999 | 3980999 | 20240216201005_H29Zt | KR001K | 2024-02-18T14:05:26.148Z | 2024-02-25T14:18:29.543Z |
3980589 | 3980589 | 20240216182854_VhTf6 | KR001K | 2024-02-18T14:04:23.178Z | 2024-02-25T14:18:22.513Z |
3980548 | 3980548 | 20240216181719_226A9 | KR001K | 2024-02-18T14:04:17.999Z | 2024-02-25T14:18:21.885Z |
3980530 | 3980530 | 20240216181307_ZnO7R | KR001K | 2024-02-18T14:04:16.471Z | 2024-02-25T14:18:21.661Z |
3980100 | 3980100 | 20240216161331_Y1Uof | KR001K | 2024-02-18T14:03:04.329Z | 2024-02-25T14:18:06.456Z |
3975644 | 3975644 | 20240215205036_6O5wy | KR001K | 2024-02-17T14:05:20.931Z | 2024-02-24T14:23:19.386Z |
3975585 | 3975585 | 20240215202132_wRCG9 | KR001K | 2024-02-17T14:05:04.009Z | 2024-02-24T14:23:17.713Z |
3975479 | 3975479 | 20240215191247_PrfZ8 | KR001K | 2024-02-17T14:04:41.346Z | 2024-02-24T14:23:13.838Z |
3938857 | 3938857 | 20240208195903_BXbKE | KR001K | 2024-02-10T14:04:28.605Z | 2024-02-17T14:26:07.359Z |
3938798 | 3938798 | 20240208194755_zUB29 | KR001K | 2024-02-10T14:04:21.778Z | 2024-02-17T14:26:06.765Z |
3893309 | 3893309 | 20240128162823_vFbWQ | KR001K | 2024-01-29T14:06:38.021Z | 2024-02-05T14:19:41.194Z |
3837866 | 3837866 | 20240115212853_3EAM4 | KR001K | 2024-01-18T14:14:57.782Z | 2024-01-24T14:19:17.358Z |
3837812 | 3837812 | 20240115212215_49xHl | KR001K | 2024-01-18T14:14:53.177Z | 2024-01-24T14:19:17.259Z |
3837577 | 3837577 | 20240115210330_KXoj0 | KR001K | 2024-01-18T14:14:34.131Z | 2024-01-24T14:19:14.917Z |
3837460 | 3837460 | 20240115205524_PNpqe | KR001K | 2024-01-18T14:14:25.689Z | 2024-01-24T14:19:14.493Z |
3837320 | 3837320 | 20240115204405_hajwx | KR001K | 2024-01-18T14:14:15.154Z | 2024-01-24T14:19:13.880Z |
3837264 | 3837264 | 20240115203302_ibiTH | KR001K | 2024-01-18T14:14:12.468Z | 2024-01-24T14:19:13.446Z |
3837229 | 3837229 | 20240115202811_4kZjY | KR001K | 2024-01-18T14:14:11.239Z | 2024-01-24T14:19:13.294Z |
3837190 | 3837190 | 20240115202612_lGrJ2 | KR001K | 2024-01-18T14:14:09.866Z | 2024-01-24T14:19:12.854Z |
3837152 | 3837152 | 20240115202323_3mCDM | KR001K | 2024-01-18T14:14:08.301Z | 2024-01-24T14:19:12.712Z |
3837089 | 3837089 | 20240115201717_SGbbp | KR001K | 2024-01-18T14:14:06.439Z | 2024-01-24T14:19:12.573Z |
3836981 | 3836981 | 20240115201043_Syvdy | KR001K | 2024-01-18T14:14:03.562Z | 2024-01-24T14:19:12.282Z |
3836918 | 3836918 | 20240115200546_pOOEJ | KR001K | 2024-01-18T14:14:01.470Z | 2024-01-24T14:19:11.520Z |
3836625 | 3836625 | 20240115193902_zU9O3 | KR001K | 2024-01-18T14:13:46.610Z | 2024-01-24T14:19:10.117Z |
3836506 | 3836506 | 20240115192849_8ZzTV | KR001K | 2024-01-18T14:13:36.699Z | 2024-01-24T14:19:09.473Z |
3835754 | 3835754 | 20240115181519_1T3WW | KR001K | 2024-01-18T14:12:35.518Z | 2024-01-24T14:19:05.080Z |
3835620 | 3835620 | 20240115180000_a6TlL | KR001K | 2024-01-18T14:12:19.648Z | 2024-01-24T14:19:04.167Z |
3835475 | 3835475 | 20240115174428_u33tk | KR001K | 2024-01-18T14:12:09.803Z | 2024-01-24T14:19:03.768Z |
3835429 | 3835429 | 20240115174126_fa32h | KR001K | 2024-01-18T14:12:05.823Z | 2024-01-24T14:19:03.705Z |
3834749 | 3834749 | 20240115152626_jvKTL | KR001K | 2024-01-18T14:10:59.709Z | 2024-01-24T14:18:59.619Z |
3834511 | 3834511 | 20240115144754_UUGu3 | KR001K | 2024-01-18T14:10:44.794Z | 2024-01-24T14:18:58.033Z |
3833675 | 3833675 | 20240115124236_y9UEn | KR001K | 2024-01-18T14:08:58.621Z | 2024-01-24T14:18:52.813Z |
3832722 | 3832722 | 20240115104449_D3hi2 | KR001K | 2024-01-18T14:06:44.912Z | 2024-01-24T14:18:44.304Z |
3830703 | 3830703 | 20240114212757_wSln3 | KR001K | 2024-01-17T14:13:54.716Z | 2024-01-23T14:25:22.606Z |
3830677 | 3830677 | 20240114212509_JCIUE | KR001K | 2024-01-17T14:13:53.771Z | 2024-01-23T14:25:22.541Z |
3829811 | 3829811 | 20240114185641_I2hxz | KR001K | 2024-01-17T14:13:02.249Z | 2024-01-23T14:25:15.825Z |
3829804 | 3829804 | 20240114185630_Qb1NU | KR001K | 2024-01-17T14:13:01.857Z | 2024-01-23T14:25:15.820Z |
3814166 | 3814166 | 20240112212416_Y4TeE | KR001K | 2024-01-15T14:13:39.522Z | 2024-01-21T14:27:55.158Z |
3814136 | 3814136 | 20240112211856_ZY3PH | KR001K | 2024-01-15T14:13:38.446Z | 2024-01-21T14:27:55.106Z |
3814111 | 3814111 | 20240112211540_UCLaC | KR001K | 2024-01-15T14:13:37.539Z | 2024-01-21T14:27:54.599Z |
3814018 | 3814018 | 20240112205641_3zXrC | KR001K | 2024-01-15T14:13:33.567Z | 2024-01-21T14:27:54.364Z |
3814005 | 3814005 | 20240112205616_6Ikg1 | KR001K | 2024-01-15T14:13:33.085Z | 2024-01-21T14:27:54.319Z |
3813805 | 3813805 | 20240112201953_872fE | KR001K | 2024-01-15T14:13:20.521Z | 2024-01-21T14:27:53.965Z |
3813692 | 3813692 | 20240112195916_ZaBX2 | KR001K | 2024-01-15T14:13:13.945Z | 2024-01-21T14:27:53.755Z |
3813639 | 3813639 | 20240112194706_R6vvR | KR001K | 2024-01-15T14:13:11.176Z | 2024-01-21T14:27:53.390Z |
3813436 | 3813436 | 20240112191718_iRXPc | KR001K | 2024-01-15T14:12:57.424Z | 2024-01-21T14:27:52.984Z |
3813423 | 3813423 | 20240112191635_4jW2f | KR001K | 2024-01-15T14:12:57.182Z | 2024-01-21T14:27:52.967Z |
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);