participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,590 rows where station_code = "KR002Q" 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 |
---|---|---|---|---|---|
5131583 | 5131583 | 20240915202054_h02ui | KR002Q | 2024-09-19T12:15:10.168Z | 2024-09-19T12:15:10.168Z |
5131369 | 5131369 | 20240915192739_OwcwO | KR002Q | 2024-09-19T12:14:59.217Z | 2024-09-19T12:14:59.217Z |
5131263 | 5131263 | 20240915185715_nfopt | KR002Q | 2024-09-19T12:14:48.705Z | 2024-09-19T12:14:48.705Z |
5124224 | 5124224 | 20240914161943_xO4ry | KR002Q | 2024-09-18T12:12:11.137Z | 2024-09-19T12:20:18.650Z |
5110984 | 5110984 | 20240914193822_mUSR6 | KR002Q | 2024-09-18T12:01:17.904Z | 2024-09-19T12:18:25.229Z |
5110368 | 5110368 | 20240913153247_kxewa | KR002Q | 2024-09-17T12:15:07.452Z | 2024-09-19T12:20:56.874Z |
5110363 | 5110363 | 20240913153034_A8pUf | KR002Q | 2024-09-17T12:15:07.339Z | 2024-09-19T12:20:56.847Z |
5098316 | 5098316 | 20240913155211_RQYTK | KR002Q | 2024-09-17T12:00:09.153Z | 2024-09-19T12:19:36.036Z |
5069005 | 5069005 | 20240910132138_fTjcz | KR002Q | 2024-09-14T12:19:23.775Z | 2024-09-18T12:15:26.977Z |
5058401 | 5058401 | 20240910160911_mcnib | KR002Q | 2024-09-14T12:03:39.289Z | 2024-09-19T12:21:29.590Z |
5058147 | 5058147 | 20240910154756_y2Mrj | KR002Q | 2024-09-14T12:03:02.063Z | 2024-09-19T12:21:29.181Z |
5057516 | 5057516 | 20240910143929_lI6wL | KR002Q | 2024-09-14T12:01:18.113Z | 2024-09-19T12:21:28.219Z |
5052288 | 5052288 | 20240907200907_31jGs | KR002Q | 2024-09-13T12:15:02.930Z | 2024-09-16T12:21:04.982Z |
5052061 | 5052061 | 20240907193724_WyPQW | KR002Q | 2024-09-13T12:14:55.519Z | 2024-09-16T12:21:03.520Z |
5051938 | 5051938 | 20240907190907_PbeRO | KR002Q | 2024-09-13T12:14:47.982Z | 2024-09-16T12:21:02.550Z |
5051745 | 5051745 | 20240907183037_05pp5 | KR002Q | 2024-09-13T12:14:32.418Z | 2024-09-16T12:21:01.740Z |
5051506 | 5051506 | 20240907173713_GQIk8 | KR002Q | 2024-09-13T12:14:20.882Z | 2024-09-16T12:21:00.635Z |
5051477 | 5051477 | 20240907173239_HsQ8H | KR002Q | 2024-09-13T12:14:18.296Z | 2024-09-16T12:21:00.549Z |
5051402 | 5051402 | 20240907172416_81mlH | KR002Q | 2024-09-13T12:14:13.272Z | 2024-09-16T12:21:00.333Z |
5051152 | 5051152 | 20240907165413_gvfjE | KR002Q | 2024-09-13T12:14:04.413Z | 2024-09-16T12:20:59.738Z |
5050382 | 5050382 | 20240907151554_JDerz | KR002Q | 2024-09-13T12:13:29.523Z | 2024-09-16T12:20:57.508Z |
5050291 | 5050291 | 20240907150424_kozuQ | KR002Q | 2024-09-13T12:13:22.664Z | 2024-09-16T12:20:56.927Z |
5045922 | 5045922 | 20240908200554_zU923 | KR002Q | 2024-09-13T12:05:22.878Z | 2024-09-17T12:18:58.200Z |
5045904 | 5045904 | 20240908200147_PlQkn | KR002Q | 2024-09-13T12:05:20.839Z | 2024-09-17T12:18:58.094Z |
5045830 | 5045830 | 20240908193746_NrwnV | KR002Q | 2024-09-13T12:05:05.125Z | 2024-09-17T12:18:57.478Z |
5045827 | 5045827 | 20240908193740_lgWNB | KR002Q | 2024-09-13T12:05:04.259Z | 2024-09-17T12:18:57.476Z |
5045821 | 5045821 | 20240908193733_Ihpox | KR002Q | 2024-09-13T12:05:03.253Z | 2024-09-17T12:18:57.455Z |
5045757 | 5045757 | 20240908185512_jt8nA | KR002Q | 2024-09-13T12:04:52.918Z | 2024-09-17T12:18:57.219Z |
5045737 | 5045737 | 20240908183906_vTtcL | KR002Q | 2024-09-13T12:04:49.652Z | 2024-09-17T12:18:57.182Z |
5045466 | 5045466 | 20240908170741_bmAab | KR002Q | 2024-09-13T12:04:11.473Z | 2024-09-17T12:18:56.599Z |
5045122 | 5045122 | 20240908162218_Upoxr | KR002Q | 2024-09-13T12:03:34.530Z | 2024-09-17T12:18:55.937Z |
5044915 | 5044915 | 20240908155436_334kX | KR002Q | 2024-09-13T12:03:09.191Z | 2024-09-17T12:18:55.396Z |
5044746 | 5044746 | 20240908153917_kMlf2 | KR002Q | 2024-09-13T12:02:53.166Z | 2024-09-17T12:18:54.926Z |
5044568 | 5044568 | 20240908151724_tOqFs | KR002Q | 2024-09-13T12:02:25.079Z | 2024-09-17T12:18:54.700Z |
5044509 | 5044509 | 20240908150721_DcBPO | KR002Q | 2024-09-13T12:02:17.643Z | 2024-09-17T12:18:54.552Z |
5043883 | 5043883 | 20240908133057_PH4LH | KR002Q | 2024-09-13T12:00:54.047Z | 2024-09-17T12:18:52.996Z |
5043150 | 5043150 | 20240907135754_LKYmL | KR002Q | 2024-09-12T12:17:24.039Z | 2024-09-16T12:20:55.616Z |
5042996 | 5042996 | 20240907132746_hN424 | KR002Q | 2024-09-12T12:17:21.483Z | 2024-09-16T12:20:55.094Z |
5018571 | 5018571 | 20240904185223_zChVW | KR002Q | 2024-09-10T12:10:52.017Z | 2024-09-13T12:19:48.174Z |
5018474 | 5018474 | 20240904182000_38BGV | KR002Q | 2024-09-10T12:10:41.259Z | 2024-09-13T12:19:47.949Z |
5018446 | 5018446 | 20240904181154_ZzDPJ | KR002Q | 2024-09-10T12:10:37.798Z | 2024-09-13T12:19:47.903Z |
5018400 | 5018400 | 20240904175603_Z54fZ | KR002Q | 2024-09-10T12:10:33.920Z | 2024-09-13T12:19:47.753Z |
5016336 | 5016336 | 20240904140113_HZuey | KR002Q | 2024-09-10T12:07:42.208Z | 2024-09-13T12:19:45.523Z |
5016084 | 5016084 | 20240904132919_lG97c | KR002Q | 2024-09-10T12:07:19.586Z | 2024-09-13T12:19:45.195Z |
4987199 | 4987199 | 20240901165852_x83U8 | KR002Q | 2024-09-07T12:05:26.639Z | 2024-09-10T12:19:10.243Z |
4986567 | 4986567 | 20240901152429_99SjR | KR002Q | 2024-09-07T12:04:43.875Z | 2024-09-10T12:19:09.413Z |
4986473 | 4986473 | 20240901151300_2ajBn | KR002Q | 2024-09-07T12:04:37.257Z | 2024-09-10T12:19:09.349Z |
4986390 | 4986390 | 20240901145736_HaGF5 | KR002Q | 2024-09-07T12:04:31.208Z | 2024-09-10T12:19:09.278Z |
4985778 | 4985778 | 20240901133135_Mnkb3 | KR002Q | 2024-09-07T12:03:45.420Z | 2024-09-10T12:19:08.345Z |
4962896 | 4962896 | 20240811193023_PBC3c | KR002Q | 2024-09-04T12:04:57.888Z | 2024-09-06T12:04:10.441Z |
4962890 | 4962890 | 20240811193021_tTYME | KR002Q | 2024-09-04T12:04:57.732Z | 2024-09-06T12:04:10.316Z |
4962764 | 4962764 | 20240811192109_ty8dD | KR002Q | 2024-09-04T12:04:50.583Z | 2024-09-06T12:04:01.475Z |
4962749 | 4962749 | 20240811192052_4Es9n | KR002Q | 2024-09-04T12:04:49.907Z | 2024-09-06T12:04:00.878Z |
4962645 | 4962645 | 20240811191401_uqiYt | KR002Q | 2024-09-04T12:04:44.989Z | 2024-09-06T12:03:54.628Z |
4962637 | 4962637 | 20240811191343_dWqws | KR002Q | 2024-09-04T12:04:44.731Z | 2024-09-06T12:03:54.422Z |
4962555 | 4962555 | 20240811190738_n3tDj | KR002Q | 2024-09-04T12:04:38.540Z | 2024-09-06T12:03:51.030Z |
4962548 | 4962548 | 20240811190720_Ar0Bg | KR002Q | 2024-09-04T12:04:38.238Z | 2024-09-06T12:03:50.685Z |
4962531 | 4962531 | 20240811190612_9dwf4 | KR002Q | 2024-09-04T12:04:37.362Z | 2024-09-06T12:03:49.974Z |
4962485 | 4962485 | 20240811190231_yQ7ZH | KR002Q | 2024-09-04T12:04:35.416Z | 2024-09-06T12:03:48.357Z |
4962467 | 4962467 | 20240811190016_OnSWP | KR002Q | 2024-09-04T12:04:32.957Z | 2024-09-06T12:03:47.538Z |
4962431 | 4962431 | 20240811185544_ATowy | KR002Q | 2024-09-04T12:04:30.126Z | 2024-09-06T12:03:45.966Z |
4962429 | 4962429 | 20240811185541_LKXrT | KR002Q | 2024-09-04T12:04:29.955Z | 2024-09-06T12:03:45.877Z |
4962401 | 4962401 | 20240811185320_RKLpe | KR002Q | 2024-09-04T12:04:28.714Z | 2024-09-06T12:03:44.803Z |
4962318 | 4962318 | 20240811184842_YWb93 | KR002Q | 2024-09-04T12:04:25.273Z | 2024-09-06T12:03:41.937Z |
4962239 | 4962239 | 20240811184342_dravG | KR002Q | 2024-09-04T12:04:22.127Z | 2024-09-06T12:03:34.543Z |
4962232 | 4962232 | 20240811184249_71qZs | KR002Q | 2024-09-04T12:04:21.727Z | 2024-09-06T12:03:34.048Z |
4962181 | 4962181 | 20240811183932_bhFRZ | KR002Q | 2024-09-04T12:04:20.106Z | 2024-09-06T12:03:32.563Z |
4961879 | 4961879 | 20240811181146_glngU | KR002Q | 2024-09-04T12:04:00.395Z | 2024-09-06T12:03:18.458Z |
4961873 | 4961873 | 20240811181144_DJmB5 | KR002Q | 2024-09-04T12:04:00.110Z | 2024-09-06T12:03:18.307Z |
4961804 | 4961804 | 20240811180554_HJawz | KR002Q | 2024-09-04T12:03:56.403Z | 2024-09-06T12:03:15.498Z |
4961743 | 4961743 | 20240811180029_wOB0H | KR002Q | 2024-09-04T12:03:53.101Z | 2024-09-06T12:03:12.536Z |
4961738 | 4961738 | 20240811175939_2O8ZP | KR002Q | 2024-09-04T12:03:52.801Z | 2024-09-06T12:03:12.254Z |
4961677 | 4961677 | 20240811175548_9dfz5 | KR002Q | 2024-09-04T12:03:49.878Z | 2024-09-06T12:03:09.669Z |
4961625 | 4961625 | 20240811175238_aHZZC | KR002Q | 2024-09-04T12:03:47.464Z | 2024-09-06T12:03:07.672Z |
4961572 | 4961572 | 20240811174835_NfQDa | KR002Q | 2024-09-04T12:03:45.670Z | 2024-09-06T12:03:05.515Z |
4961529 | 4961529 | 20240811174546_De5Ap | KR002Q | 2024-09-04T12:03:44.135Z | 2024-09-06T12:03:04.284Z |
4961471 | 4961471 | 20240811174258_EkDc2 | KR002Q | 2024-09-04T12:03:41.244Z | 2024-09-06T12:03:01.801Z |
4961340 | 4961340 | 20240811173144_94ymW | KR002Q | 2024-09-04T12:03:32.051Z | 2024-09-06T12:02:52.686Z |
4961298 | 4961298 | 20240811173011_fR25C | KR002Q | 2024-09-04T12:03:27.557Z | 2024-09-06T12:02:51.417Z |
4961129 | 4961129 | 20240811171854_kzwQv | KR002Q | 2024-09-04T12:03:18.951Z | 2024-09-06T12:02:44.716Z |
4960881 | 4960881 | 20240811165847_eAZMB | KR002Q | 2024-09-04T12:03:01.646Z | 2024-09-06T12:02:30.787Z |
4960805 | 4960805 | 20240811164900_Z9NYv | KR002Q | 2024-09-04T12:02:55.551Z | 2024-09-06T12:02:26.884Z |
4960741 | 4960741 | 20240811164504_oj9An | KR002Q | 2024-09-04T12:02:52.647Z | 2024-09-06T12:02:24.368Z |
4960739 | 4960739 | 20240811164453_atYxu | KR002Q | 2024-09-04T12:02:52.479Z | 2024-09-06T12:02:24.215Z |
4960729 | 4960729 | 20240811164441_xeuht | KR002Q | 2024-09-04T12:02:52.072Z | 2024-09-06T12:02:23.875Z |
4960644 | 4960644 | 20240811163952_mFq0o | KR002Q | 2024-09-04T12:02:47.913Z | 2024-09-06T12:02:20.537Z |
4960629 | 4960629 | 20240811163914_9mNum | KR002Q | 2024-09-04T12:02:47.310Z | 2024-09-06T12:02:20.021Z |
4960569 | 4960569 | 20240811163428_ILOnF | KR002Q | 2024-09-04T12:02:42.937Z | 2024-09-06T12:02:16.242Z |
4960387 | 4960387 | 20240811162241_nwXp2 | KR002Q | 2024-09-04T12:02:29.780Z | 2024-09-06T12:02:06.822Z |
4960172 | 4960172 | 20240811160626_SK6A6 | KR002Q | 2024-09-04T12:02:16.914Z | 2024-09-06T12:01:56.475Z |
4960027 | 4960027 | 20240811155715_96Fwp | KR002Q | 2024-09-04T12:02:07.857Z | 2024-09-06T12:01:48.016Z |
4959990 | 4959990 | 20240811155434_wCESm | KR002Q | 2024-09-04T12:02:05.883Z | 2024-09-06T12:01:46.262Z |
4959762 | 4959762 | 20240811153524_eBDWS | KR002Q | 2024-09-04T12:01:54.645Z | 2024-09-06T12:01:36.371Z |
4959678 | 4959678 | 20240811152741_tnNKz | KR002Q | 2024-09-04T12:01:48.263Z | 2024-09-06T12:01:30.822Z |
4959532 | 4959532 | 20240811151449_6KO7I | KR002Q | 2024-09-04T12:01:39.775Z | 2024-09-06T12:01:21.330Z |
4959512 | 4959512 | 20240811151231_9piAL | KR002Q | 2024-09-04T12:01:38.796Z | 2024-09-06T12:01:20.232Z |
4959475 | 4959475 | 20240811150555_bm2Wi | KR002Q | 2024-09-04T12:01:36.456Z | 2024-09-06T12:01:18.066Z |
4959369 | 4959369 | 20240811145759_Gsa6n | KR002Q | 2024-09-04T12:01:29.440Z | 2024-09-06T12:01:13.410Z |
4959353 | 4959353 | 20240811145605_4Ty2f | KR002Q | 2024-09-04T12:01:27.218Z | 2024-09-06T12:01:12.491Z |
4951969 | 4951969 | 20240811144956_Kc8vC | KR002Q | 2024-09-03T12:01:40.325Z | 2024-09-06T12:01:09.038Z |
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);