participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,772 rows where station_code = "KR002T" 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 |
---|---|---|---|---|---|
5069064 | 5069064 | 20240910133438_ls1BY | KR002T | 2024-09-14T12:19:25.069Z | 2024-09-16T12:20:16.315Z |
5069006 | 5069006 | 20240910132138_fTjcz | KR002T | 2024-09-14T12:19:23.775Z | 2024-09-16T12:20:16.135Z |
5068950 | 5068950 | 20240910131224_42CQZ | KR002T | 2024-09-14T12:19:23.213Z | 2024-09-16T12:20:15.899Z |
5068123 | 5068123 | 20240910105743_rWaMT | KR002T | 2024-09-14T12:19:09.236Z | 2024-09-16T12:20:12.931Z |
5062865 | 5062865 | 20240909184427_5snJs | KR002T | 2024-09-14T12:12:59.301Z | 2024-09-16T12:19:39.872Z |
5062532 | 5062532 | 20240909173715_nSo7f | KR002T | 2024-09-14T12:12:31.271Z | 2024-09-16T12:19:37.672Z |
5062075 | 5062075 | 20240909164126_hWCCn | KR002T | 2024-09-14T12:11:47.567Z | 2024-09-16T12:19:35.411Z |
5061056 | 5061056 | 20240909135859_wVTdl | KR002T | 2024-09-14T12:10:10.531Z | 2024-09-16T12:19:28.831Z |
5061051 | 5061051 | 20240909135856_SE38K | KR002T | 2024-09-14T12:10:09.203Z | 2024-09-16T12:19:28.740Z |
5059733 | 5059733 | 20240910183911_Zvggj | KR002T | 2024-09-14T12:06:55.997Z | 2024-09-16T12:18:07.989Z |
5059553 | 5059553 | 20240910180533_sfWX9 | KR002T | 2024-09-14T12:06:26.720Z | 2024-09-16T12:18:06.061Z |
5059531 | 5059531 | 20240910180124_n5kAt | KR002T | 2024-09-14T12:06:19.270Z | 2024-09-16T12:18:05.823Z |
5058512 | 5058512 | 20240910161846_ml2rx | KR002T | 2024-09-14T12:03:49.588Z | 2024-09-16T12:17:55.456Z |
5058402 | 5058402 | 20240910160911_mcnib | KR002T | 2024-09-14T12:03:39.289Z | 2024-09-16T12:17:54.046Z |
5058318 | 5058318 | 20240910160218_ueR2L | KR002T | 2024-09-14T12:03:27.654Z | 2024-09-16T12:17:52.913Z |
5058089 | 5058089 | 20240910154311_mWqta | KR002T | 2024-09-14T12:02:54.089Z | 2024-09-16T12:17:50.043Z |
5057940 | 5057940 | 20240910152836_8mFEJ | KR002T | 2024-09-14T12:02:27.119Z | 2024-09-16T12:17:48.706Z |
5057839 | 5057839 | 20240910151711_vWhYR | KR002T | 2024-09-14T12:02:12.598Z | 2024-09-16T12:17:47.963Z |
5057570 | 5057570 | 20240910145041_qV1aM | KR002T | 2024-09-14T12:01:27.217Z | 2024-09-16T12:17:45.015Z |
5057428 | 5057428 | 20240910142909_58bDw | KR002T | 2024-09-14T12:01:03.312Z | 2024-09-16T12:17:43.943Z |
5056733 | 5056733 | 20240908111500_HSskc | KR002T | 2024-09-13T12:17:38.630Z | 2024-09-16T12:21:26.962Z |
5052080 | 5052080 | 20240907193920_Iesz0 | KR002T | 2024-09-13T12:14:55.995Z | 2024-09-16T12:21:03.636Z |
5052018 | 5052018 | 20240907192733_3pIEf | KR002T | 2024-09-13T12:14:53.589Z | 2024-09-16T12:21:03.131Z |
5051747 | 5051747 | 20240907183037_05pp5 | KR002T | 2024-09-13T12:14:32.418Z | 2024-09-16T12:21:01.740Z |
5051656 | 5051656 | 20240907180945_ANIHH | KR002T | 2024-09-13T12:14:27.535Z | 2024-09-16T12:21:01.494Z |
5051124 | 5051124 | 20240907165104_2Mqy3 | KR002T | 2024-09-13T12:14:02.923Z | 2024-09-16T12:20:59.615Z |
5051103 | 5051103 | 20240907164855_yfdHS | KR002T | 2024-09-13T12:14:01.877Z | 2024-09-16T12:20:59.585Z |
5050626 | 5050626 | 20240907154850_2o2fB | KR002T | 2024-09-13T12:13:40.586Z | 2024-09-16T12:20:58.107Z |
5050610 | 5050610 | 20240907154727_VSgts | KR002T | 2024-09-13T12:13:38.824Z | 2024-09-16T12:20:58.086Z |
5050306 | 5050306 | 20240907150623_D6kyl | KR002T | 2024-09-13T12:13:23.285Z | 2024-09-16T12:20:56.975Z |
5045933 | 5045933 | 20240908200800_jS63L | KR002T | 2024-09-13T12:05:24.111Z | 2024-09-16T12:20:28.113Z |
5045899 | 5045899 | 20240908195856_2rf9J | KR002T | 2024-09-13T12:05:20.122Z | 2024-09-16T12:20:28.028Z |
5045879 | 5045879 | 20240908195102_Zqk9L | KR002T | 2024-09-13T12:05:17.594Z | 2024-09-16T12:20:27.904Z |
5045845 | 5045845 | 20240908194207_tJotG | KR002T | 2024-09-13T12:05:12.109Z | 2024-09-16T12:20:27.755Z |
5045783 | 5045783 | 20240908191953_be8HY | KR002T | 2024-09-13T12:04:56.437Z | 2024-09-16T12:20:27.405Z |
5045766 | 5045766 | 20240908191201_liBv1 | KR002T | 2024-09-13T12:04:54.235Z | 2024-09-16T12:20:27.338Z |
5045753 | 5045753 | 20240908185050_yKYAB | KR002T | 2024-09-13T12:04:52.089Z | 2024-09-16T12:20:27.261Z |
5045749 | 5045749 | 20240908185042_0r6xN | KR002T | 2024-09-13T12:04:51.740Z | 2024-09-16T12:20:27.259Z |
5045720 | 5045720 | 20240908182654_KJOKd | KR002T | 2024-09-13T12:04:47.210Z | 2024-09-16T12:20:26.983Z |
5045693 | 5045693 | 20240908180822_RuftQ | KR002T | 2024-09-13T12:04:43.470Z | 2024-09-16T12:20:26.775Z |
5045450 | 5045450 | 20240908170544_C0dbo | KR002T | 2024-09-13T12:04:09.415Z | 2024-09-16T12:20:25.703Z |
5045313 | 5045313 | 20240908165219_85tVQ | KR002T | 2024-09-13T12:03:57.233Z | 2024-09-16T12:20:25.430Z |
5045241 | 5045241 | 20240908163919_DdLiO | KR002T | 2024-09-13T12:03:45.275Z | 2024-09-16T12:20:25.023Z |
5044721 | 5044721 | 20240908153252_15jqB | KR002T | 2024-09-13T12:02:50.630Z | 2024-09-16T12:20:23.425Z |
5044510 | 5044510 | 20240908150721_DcBPO | KR002T | 2024-09-13T12:02:17.643Z | 2024-09-16T12:20:22.396Z |
5044462 | 5044462 | 20240908150355_dpQQd | KR002T | 2024-09-13T12:02:13.634Z | 2024-09-16T12:20:22.215Z |
5044425 | 5044425 | 20240908145910_95ovB | KR002T | 2024-09-13T12:02:09.606Z | 2024-09-16T12:20:21.888Z |
5043596 | 5043596 | 20240908121834_ertpr | KR002T | 2024-09-13T12:00:10.534Z | 2024-09-16T12:20:18.199Z |
5042859 | 5042859 | 20240907130100_WJx1E | KR002T | 2024-09-12T12:17:19.068Z | 2024-09-16T12:20:54.691Z |
5030631 | 5030631 | 20240906172118_L9UO2 | KR002T | 2024-09-12T12:02:31.054Z | 2024-09-15T12:21:19.366Z |
5018586 | 5018586 | 20240904185547_3uB3D | KR002T | 2024-09-10T12:10:54.902Z | 2024-09-13T12:19:48.181Z |
5018572 | 5018572 | 20240904185223_zChVW | KR002T | 2024-09-10T12:10:52.017Z | 2024-09-13T12:19:48.174Z |
5018562 | 5018562 | 20240904184820_3tMf3 | KR002T | 2024-09-10T12:10:51.213Z | 2024-09-13T12:19:48.151Z |
5018519 | 5018519 | 20240904183041_3GNIk | KR002T | 2024-09-10T12:10:45.581Z | 2024-09-13T12:19:47.997Z |
5018401 | 5018401 | 20240904175603_Z54fZ | KR002T | 2024-09-10T12:10:33.920Z | 2024-09-13T12:19:47.753Z |
5018342 | 5018342 | 20240904174506_xZsLl | KR002T | 2024-09-10T12:10:29.356Z | 2024-09-13T12:19:47.609Z |
5018100 | 5018100 | 20240904171106_9T8gB | KR002T | 2024-09-10T12:09:59.978Z | 2024-09-13T12:19:47.206Z |
5016110 | 5016110 | 20240904133157_wAZY6 | KR002T | 2024-09-10T12:07:23.214Z | 2024-09-13T12:19:45.249Z |
5007099 | 5007099 | 20240903195647_rDEvW | KR002T | 2024-09-09T12:05:26.014Z | 2024-09-12T12:19:11.358Z |
5006864 | 5006864 | 20240903191647_SmKAl | KR002T | 2024-09-09T12:05:09.309Z | 2024-09-12T12:19:10.406Z |
5006084 | 5006084 | 20240903165318_Q9JS6 | KR002T | 2024-09-09T12:04:19.635Z | 2024-09-12T12:19:07.616Z |
5005964 | 5005964 | 20240903163820_q6wxi | KR002T | 2024-09-09T12:04:14.833Z | 2024-09-12T12:19:07.149Z |
5005791 | 5005791 | 20240903161126_kfVfP | KR002T | 2024-09-09T12:04:04.708Z | 2024-09-12T12:19:06.659Z |
5005633 | 5005633 | 20240903154758_jje7l | KR002T | 2024-09-09T12:03:52.245Z | 2024-09-12T12:19:06.331Z |
5005001 | 5005001 | 20240903134439_44orq | KR002T | 2024-09-09T12:03:15.282Z | 2024-09-12T12:19:04.724Z |
5004849 | 5004849 | 20240903130509_cE609 | KR002T | 2024-09-09T12:03:07.419Z | 2024-09-12T12:19:04.347Z |
4994695 | 4994695 | 20240902145918_pREK3 | KR002T | 2024-09-08T12:02:51.753Z | 2024-09-11T12:20:37.397Z |
4994188 | 4994188 | 20240902124227_NWFpN | KR002T | 2024-09-08T12:02:18.584Z | 2024-09-11T12:20:31.432Z |
4994127 | 4994127 | 20240902122325_W3enF | KR002T | 2024-09-08T12:02:13.785Z | 2024-09-11T12:20:30.598Z |
4987672 | 4987672 | 20240901182408_MZRn4 | KR002T | 2024-09-07T12:06:05.786Z | 2024-09-10T12:19:11.165Z |
4987072 | 4987072 | 20240901164401_K8rsH | KR002T | 2024-09-07T12:05:16.814Z | 2024-09-10T12:19:10.010Z |
4986230 | 4986230 | 20240901143431_Wrzdm | KR002T | 2024-09-07T12:04:19.538Z | 2024-09-10T12:19:09.074Z |
4986022 | 4986022 | 20240901140704_DF8u3 | KR002T | 2024-09-07T12:04:02.776Z | 2024-09-10T12:19:08.824Z |
4985785 | 4985785 | 20240901133154_SBrei | KR002T | 2024-09-07T12:03:46.013Z | 2024-09-10T12:19:08.347Z |
4985779 | 4985779 | 20240901133135_Mnkb3 | KR002T | 2024-09-07T12:03:45.423Z | 2024-09-10T12:19:08.345Z |
4963261 | 4963261 | 20240811195221_XDl9l | KR002T | 2024-09-04T12:05:23.009Z | 2024-09-06T12:04:26.391Z |
4963029 | 4963029 | 20240811193749_tMxIl | KR002T | 2024-09-04T12:05:07.158Z | 2024-09-06T12:04:15.416Z |
4962784 | 4962784 | 20240811192239_ODXNy | KR002T | 2024-09-04T12:04:52.215Z | 2024-09-06T12:04:02.695Z |
4962744 | 4962744 | 20240811192046_rd3RC | KR002T | 2024-09-04T12:04:49.818Z | 2024-09-06T12:04:00.798Z |
4962520 | 4962520 | 20240811190529_zcvIK | KR002T | 2024-09-04T12:04:36.921Z | 2024-09-06T12:03:49.571Z |
4962486 | 4962486 | 20240811190231_yQ7ZH | KR002T | 2024-09-04T12:04:35.416Z | 2024-09-06T12:03:48.357Z |
4962476 | 4962476 | 20240811190204_emeDN | KR002T | 2024-09-04T12:04:35.091Z | 2024-09-06T12:03:48.097Z |
4962323 | 4962323 | 20240811184858_ndB9J | KR002T | 2024-09-04T12:04:25.415Z | 2024-09-06T12:03:42.060Z |
4962247 | 4962247 | 20240811184346_wD3UN | KR002T | 2024-09-04T12:04:22.247Z | 2024-09-06T12:03:34.749Z |
4962214 | 4962214 | 20240811184153_cEfEn | KR002T | 2024-09-04T12:04:21.239Z | 2024-09-06T12:03:33.683Z |
4961990 | 4961990 | 20240811182242_QReWC | KR002T | 2024-09-04T12:04:07.650Z | 2024-09-06T12:03:22.868Z |
4961915 | 4961915 | 20240811181630_31YEj | KR002T | 2024-09-04T12:04:03.419Z | 2024-09-06T12:03:19.837Z |
4961884 | 4961884 | 20240811181231_ChC2w | KR002T | 2024-09-04T12:04:02.076Z | 2024-09-06T12:03:18.732Z |
4961744 | 4961744 | 20240811180029_wOB0H | KR002T | 2024-09-04T12:03:53.101Z | 2024-09-06T12:03:12.536Z |
4961711 | 4961711 | 20240811175807_BPOHN | KR002T | 2024-09-04T12:03:51.579Z | 2024-09-06T12:03:11.207Z |
4961525 | 4961525 | 20240811174525_yAZ0D | KR002T | 2024-09-04T12:03:43.941Z | 2024-09-06T12:03:04.130Z |
4961412 | 4961412 | 20240811173922_FOVpJ | KR002T | 2024-09-04T12:03:36.072Z | 2024-09-06T12:02:56.223Z |
4961332 | 4961332 | 20240811173118_Vlzs5 | KR002T | 2024-09-04T12:03:31.720Z | 2024-09-06T12:02:52.463Z |
4961310 | 4961310 | 20240811173017_JSfQN | KR002T | 2024-09-04T12:03:27.729Z | 2024-09-06T12:02:51.585Z |
4961233 | 4961233 | 20240811172512_89Mgf | KR002T | 2024-09-04T12:03:23.736Z | 2024-09-06T12:02:48.292Z |
4961143 | 4961143 | 20240811171926_JoiLX | KR002T | 2024-09-04T12:03:19.693Z | 2024-09-06T12:02:45.107Z |
4961115 | 4961115 | 20240811171804_IWCMQ | KR002T | 2024-09-04T12:03:17.654Z | 2024-09-06T12:02:43.926Z |
4960822 | 4960822 | 20240811165129_DhvXA | KR002T | 2024-09-04T12:02:56.962Z | 2024-09-06T12:02:28.003Z |
4960787 | 4960787 | 20240811164735_N98Hl | KR002T | 2024-09-04T12:02:54.430Z | 2024-09-06T12:02:25.936Z |
4960766 | 4960766 | 20240811164634_8zPY9 | KR002T | 2024-09-04T12:02:53.747Z | 2024-09-06T12:02:25.362Z |
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);