participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,471 rows where station_code = "KR000G" 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 |
---|---|---|---|---|---|
5070447 | 5070447 | 20240909125444_QzMXd | KR000G | 2024-09-14T12:21:21.940Z | 2024-09-16T12:20:45.808Z |
5069022 | 5069022 | 20240910132514_UnrSB | KR000G | 2024-09-14T12:19:24.133Z | 2024-09-16T12:20:16.183Z |
5068644 | 5068644 | 20240910115833_c1Bs3 | KR000G | 2024-09-14T12:19:19.828Z | 2024-09-16T12:20:14.556Z |
5061921 | 5061921 | 20240909162328_YAbE2 | KR000G | 2024-09-14T12:11:39.236Z | 2024-09-16T12:19:34.698Z |
5061602 | 5061602 | 20240909152804_OZKYA | KR000G | 2024-09-14T12:10:59.995Z | 2024-09-16T12:19:32.292Z |
5059723 | 5059723 | 20240910183758_JCzBA | KR000G | 2024-09-14T12:06:52.937Z | 2024-09-16T12:18:07.894Z |
5059692 | 5059692 | 20240910183310_htS1p | KR000G | 2024-09-14T12:06:46.924Z | 2024-09-16T12:18:07.689Z |
5059497 | 5059497 | 20240910175407_66V5Y | KR000G | 2024-09-14T12:06:14.203Z | 2024-09-16T12:18:05.496Z |
5058639 | 5058639 | 20240910163231_m14R2 | KR000G | 2024-09-14T12:04:14.479Z | 2024-09-16T12:17:56.759Z |
5057933 | 5057933 | 20240910152836_8mFEJ | KR000G | 2024-09-14T12:02:27.118Z | 2024-09-16T12:17:48.706Z |
5057834 | 5057834 | 20240910151711_vWhYR | KR000G | 2024-09-14T12:02:12.594Z | 2024-09-16T12:17:47.963Z |
5057565 | 5057565 | 20240910145041_qV1aM | KR000G | 2024-09-14T12:01:27.202Z | 2024-09-16T12:17:45.015Z |
5057316 | 5057316 | 20240910141111_uXUgj | KR000G | 2024-09-14T12:00:49.902Z | 2024-09-16T12:17:42.407Z |
5052192 | 5052192 | 20240907195635_2IArg | KR000G | 2024-09-13T12:14:59.776Z | 2024-09-16T12:21:04.341Z |
5052154 | 5052154 | 20240907194912_BiAMX | KR000G | 2024-09-13T12:14:58.863Z | 2024-09-16T12:21:04.249Z |
5051886 | 5051886 | 20240907190040_dqkUB | KR000G | 2024-09-13T12:14:42.097Z | 2024-09-16T12:21:02.406Z |
5051682 | 5051682 | 20240907182402_V2lPi | KR000G | 2024-09-13T12:14:29.618Z | 2024-09-16T12:21:01.601Z |
5051287 | 5051287 | 20240907171244_s8h9m | KR000G | 2024-09-13T12:14:09.067Z | 2024-09-16T12:21:00.033Z |
5050734 | 5050734 | 20240907160317_K9409 | KR000G | 2024-09-13T12:13:45.478Z | 2024-09-16T12:20:58.395Z |
5050223 | 5050223 | 20240907145053_O19in | KR000G | 2024-09-13T12:13:19.013Z | 2024-09-16T12:20:56.784Z |
5050052 | 5050052 | 20240909123504_kABcJ | KR000G | 2024-09-13T12:12:38.056Z | 2024-09-16T12:20:45.302Z |
5050025 | 5050025 | 20240909122903_MkRrT | KR000G | 2024-09-13T12:12:36.944Z | 2024-09-16T12:20:45.250Z |
5049823 | 5049823 | 20240909114726_EPx1e | KR000G | 2024-09-13T12:12:28.090Z | 2024-09-16T12:20:44.435Z |
5043542 | 5043542 | 20240907112527_bP567 | KR000G | 2024-09-12T12:17:36.346Z | 2024-09-15T12:21:42.065Z |
5043416 | 5043416 | 20240907105923_gnhYd | KR000G | 2024-09-12T12:17:33.387Z | 2024-09-15T12:21:41.621Z |
5043239 | 5043239 | 20240907141305_eaKgl | KR000G | 2024-09-12T12:17:25.610Z | 2024-09-16T12:20:56.032Z |
5042899 | 5042899 | 20240907130858_qn2hD | KR000G | 2024-09-12T12:17:20.610Z | 2024-09-16T12:20:54.839Z |
5042718 | 5042718 | 20240907123133_Dalg8 | KR000G | 2024-09-12T12:17:17.175Z | 2024-09-16T12:20:53.986Z |
5042712 | 5042712 | 20240907122954_7UkYj | KR000G | 2024-09-12T12:17:17.026Z | 2024-09-16T12:20:53.967Z |
5042649 | 5042649 | 20240907121948_WT94S | KR000G | 2024-09-12T12:17:16.560Z | 2024-09-16T12:20:53.840Z |
5042581 | 5042581 | 20240907120537_Wng3w | KR000G | 2024-09-12T12:17:15.510Z | 2024-09-16T12:20:53.638Z |
5017909 | 5017909 | 20240904165257_7G7Zf | KR000G | 2024-09-10T12:09:44.661Z | 2024-09-13T12:19:47.129Z |
5017320 | 5017320 | 20240904155835_HRqbJ | KR000G | 2024-09-10T12:09:03.941Z | 2024-09-13T12:19:46.794Z |
5017088 | 5017088 | 20240904153027_m5H2V | KR000G | 2024-09-10T12:08:46.877Z | 2024-09-13T12:19:46.572Z |
5016477 | 5016477 | 20240904141916_S5CJC | KR000G | 2024-09-10T12:07:52.611Z | 2024-09-13T12:19:45.812Z |
5016386 | 5016386 | 20240904141116_rNzpM | KR000G | 2024-09-10T12:07:46.319Z | 2024-09-13T12:19:45.595Z |
5016225 | 5016225 | 20240904134558_PMhGK | KR000G | 2024-09-10T12:07:35.227Z | 2024-09-13T12:19:45.352Z |
5015816 | 5015816 | 20240904124106_JQSEf | KR000G | 2024-09-10T12:06:48.934Z | 2024-09-13T12:19:44.716Z |
5015723 | 5015723 | 20240904122021_llJIa | KR000G | 2024-09-10T12:06:41.930Z | 2024-09-13T12:19:44.626Z |
5007015 | 5007015 | 20240903194823_AwMpT | KR000G | 2024-09-09T12:05:19.813Z | 2024-09-12T12:19:11.122Z |
5007001 | 5007001 | 20240903194226_cNT3z | KR000G | 2024-09-09T12:05:18.878Z | 2024-09-12T12:19:11.061Z |
5006657 | 5006657 | 20240903181918_K6GTd | KR000G | 2024-09-09T12:04:51.890Z | 2024-09-12T12:19:09.147Z |
5006340 | 5006340 | 20240903172555_ZqoMd | KR000G | 2024-09-09T12:04:31.562Z | 2024-09-12T12:19:08.154Z |
5005995 | 5005995 | 20240903164022_u2Og1 | KR000G | 2024-09-09T12:04:15.784Z | 2024-09-12T12:19:07.172Z |
5005225 | 5005225 | 20240903143409_8iZOc | KR000G | 2024-09-09T12:03:27.741Z | 2024-09-12T12:19:05.499Z |
5005026 | 5005026 | 20240903134923_fhW43 | KR000G | 2024-09-09T12:03:16.654Z | 2024-09-12T12:19:05.165Z |
5004974 | 5004974 | 20240903134031_531Vh | KR000G | 2024-09-09T12:03:14.276Z | 2024-09-12T12:19:04.626Z |
5003205 | 5003205 | 20240904112338_MDQ9Q | KR000G | 2024-09-09T12:01:27.495Z | 2024-09-13T12:19:43.682Z |
4996437 | 4996437 | 20240902194037_hs2zY | KR000G | 2024-09-08T12:04:49.259Z | 2024-09-11T12:20:54.345Z |
4996060 | 4996060 | 20240902183552_1tK9H | KR000G | 2024-09-08T12:04:20.116Z | 2024-09-11T12:20:50.857Z |
4996006 | 4996006 | 20240902182633_SV9hB | KR000G | 2024-09-08T12:04:17.099Z | 2024-09-11T12:20:50.428Z |
4995911 | 4995911 | 20240902181024_q6fDz | KR000G | 2024-09-08T12:04:11.511Z | 2024-09-11T12:20:49.612Z |
4995846 | 4995846 | 20240902180019_HxNgN | KR000G | 2024-09-08T12:04:07.400Z | 2024-09-11T12:20:48.920Z |
4995637 | 4995637 | 20240902172435_WnAhr | KR000G | 2024-09-08T12:03:50.934Z | 2024-09-11T12:20:47.067Z |
4995085 | 4995085 | 20240902161201_keuks | KR000G | 2024-09-08T12:03:14.882Z | 2024-09-11T12:20:41.851Z |
4994287 | 4994287 | 20240902132234_ITvZK | KR000G | 2024-09-08T12:02:25.242Z | 2024-09-11T12:20:32.415Z |
4985123 | 4985123 | 20240901113441_awBQ5 | KR000G | 2024-09-07T12:02:51.490Z | 2024-09-10T12:19:06.951Z |
4962955 | 4962955 | 20240811193445_l1SCc | KR000G | 2024-09-04T12:05:01.394Z | 2024-09-06T12:04:12.760Z |
4962612 | 4962612 | 20240811191227_urrvq | KR000G | 2024-09-04T12:04:43.598Z | 2024-09-06T12:03:53.543Z |
4962511 | 4962511 | 20240811190412_F25L9 | KR000G | 2024-09-04T12:04:36.686Z | 2024-09-06T12:03:49.364Z |
4962416 | 4962416 | 20240811185535_Rh3YI | KR000G | 2024-09-04T12:04:29.531Z | 2024-09-06T12:03:45.548Z |
4962240 | 4962240 | 20240811184346_wD3UN | KR000G | 2024-09-04T12:04:22.247Z | 2024-09-06T12:03:34.749Z |
4962115 | 4962115 | 20240811183622_AD4Qa | KR000G | 2024-09-04T12:04:17.087Z | 2024-09-06T12:03:30.165Z |
4961929 | 4961929 | 20240811181816_aUlxi | KR000G | 2024-09-04T12:04:04.657Z | 2024-09-06T12:03:20.956Z |
4961849 | 4961849 | 20240811180955_S3d3I | KR000G | 2024-09-04T12:03:58.602Z | 2024-09-06T12:03:17.243Z |
4961770 | 4961770 | 20240811180224_3G7QM | KR000G | 2024-09-04T12:03:54.847Z | 2024-09-06T12:03:14.185Z |
4961392 | 4961392 | 20240811173715_MEtCZ | KR000G | 2024-09-04T12:03:34.838Z | 2024-09-06T12:02:55.063Z |
4961301 | 4961301 | 20240811173017_JSfQN | KR000G | 2024-09-04T12:03:27.729Z | 2024-09-06T12:02:51.584Z |
4960819 | 4960819 | 20240811165124_fa0X9 | KR000G | 2024-09-04T12:02:56.730Z | 2024-09-06T12:02:27.800Z |
4960779 | 4960779 | 20240811164735_N98Hl | KR000G | 2024-09-04T12:02:54.430Z | 2024-09-06T12:02:25.936Z |
4960672 | 4960672 | 20240811164220_0h7ei | KR000G | 2024-09-04T12:02:49.444Z | 2024-09-06T12:02:21.806Z |
4960539 | 4960539 | 20240811163221_6ZF9i | KR000G | 2024-09-04T12:02:41.410Z | 2024-09-06T12:02:15.267Z |
4960346 | 4960346 | 20240811161745_DgWiy | KR000G | 2024-09-04T12:02:27.283Z | 2024-09-06T12:02:04.666Z |
4960211 | 4960211 | 20240811161039_QQjpc | KR000G | 2024-09-04T12:02:19.699Z | 2024-09-06T12:01:58.574Z |
4960200 | 4960200 | 20240811160932_58156 | KR000G | 2024-09-04T12:02:18.915Z | 2024-09-06T12:01:58.051Z |
4960164 | 4960164 | 20240811160542_OB7eu | KR000G | 2024-09-04T12:02:16.542Z | 2024-09-06T12:01:56.168Z |
4960117 | 4960117 | 20240811160244_wLnMv | KR000G | 2024-09-04T12:02:13.589Z | 2024-09-06T12:01:53.106Z |
4960049 | 4960049 | 20240811155756_CKCen | KR000G | 2024-09-04T12:02:09.292Z | 2024-09-06T12:01:50.408Z |
4959827 | 4959827 | 20240811154054_z3F6m | KR000G | 2024-09-04T12:01:58.083Z | 2024-09-06T12:01:39.209Z |
4959815 | 4959815 | 20240811154020_wT3ST | KR000G | 2024-09-04T12:01:57.455Z | 2024-09-06T12:01:38.889Z |
4959383 | 4959383 | 20240811145922_5r5Pb | KR000G | 2024-09-04T12:01:30.305Z | 2024-09-06T12:01:14.056Z |
4951611 | 4951611 | 20240811140703_usxHm | KR000G | 2024-09-03T12:01:11.995Z | 2024-09-06T12:00:50.899Z |
4951564 | 4951564 | 20240811140206_vpTXw | KR000G | 2024-09-03T12:01:09.158Z | 2024-09-06T12:00:48.257Z |
4951500 | 4951500 | 20240811135655_lzpY3 | KR000G | 2024-09-03T12:01:06.028Z | 2024-09-06T12:00:46.586Z |
4951478 | 4951478 | 20240811135030_uI1bN | KR000G | 2024-09-03T12:01:04.269Z | 2024-09-06T12:00:45.664Z |
4951468 | 4951468 | 20240811135012_W1KM9 | KR000G | 2024-09-03T12:01:03.726Z | 2024-09-06T12:00:45.282Z |
4951111 | 4951111 | 20240811130746_xFEmt | KR000G | 2024-09-03T12:00:29.514Z | 2024-09-06T12:00:24.383Z |
4463023 | 4463023 | 20240613183157_xVgOo | KR000G | 2024-06-15T12:09:23.285Z | 2024-06-21T12:11:47.802Z |
4463005 | 4463005 | 20240613182712_T2y5M | KR000G | 2024-06-15T12:09:22.136Z | 2024-06-21T12:11:47.752Z |
4462945 | 4462945 | 20240613181300_k2ZvQ | KR000G | 2024-06-15T12:09:18.579Z | 2024-06-21T12:11:47.651Z |
4462916 | 4462916 | 20240613181008_uUvFW | KR000G | 2024-06-15T12:09:17.197Z | 2024-06-21T12:11:47.637Z |
4462782 | 4462782 | 20240613174535_j6Ab2 | KR000G | 2024-06-15T12:09:09.264Z | 2024-06-21T12:11:47.441Z |
4462530 | 4462530 | 20240613170940_m6hvY | KR000G | 2024-06-15T12:08:48.909Z | 2024-06-21T12:11:47.168Z |
4462000 | 4462000 | 20240613152927_OviIZ | KR000G | 2024-06-15T12:07:58.085Z | 2024-06-21T12:11:46.160Z |
4461849 | 4461849 | 20240613143957_TJqIR | KR000G | 2024-06-15T12:07:43.906Z | 2024-06-21T12:11:45.461Z |
4454752 | 4454752 | 20240611181926_2ePs2 | KR000G | 2024-06-13T12:06:17.956Z | 2024-06-19T12:13:48.577Z |
4454722 | 4454722 | 20240611181543_NkFq7 | KR000G | 2024-06-13T12:06:17.226Z | 2024-06-19T12:13:48.541Z |
4454558 | 4454558 | 20240611175858_HM77w | KR000G | 2024-06-13T12:06:13.481Z | 2024-06-19T12:13:48.303Z |
4454482 | 4454482 | 20240611174501_yFmg3 | KR000G | 2024-06-13T12:06:11.362Z | 2024-06-19T12:13:47.889Z |
4454433 | 4454433 | 20240611173748_BfH3Z | KR000G | 2024-06-13T12:06:10.323Z | 2024-06-19T12:13:47.813Z |
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);