participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,433 rows where station_code = "US0035" 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 |
---|---|---|---|---|---|
5134299 | 5134299 | 20240916075738_pu3zM | US0035 | 2024-09-19T12:17:36.109Z | 2024-09-19T12:17:36.109Z |
5134281 | 5134281 | 20240916074720_mG44P | US0035 | 2024-09-19T12:17:35.198Z | 2024-09-19T12:17:35.198Z |
5134206 | 5134206 | 20240916064141_YOSm3 | US0035 | 2024-09-19T12:17:30.074Z | 2024-09-19T12:17:30.074Z |
5123398 | 5123398 | 20240914095751_Y3wfT | US0035 | 2024-09-18T12:11:47.877Z | 2024-09-19T12:20:10.749Z |
5123288 | 5123288 | 20240914093506_kXWjZ | US0035 | 2024-09-18T12:11:44.066Z | 2024-09-19T12:20:09.398Z |
5123278 | 5123278 | 20240914093113_mYr67 | US0035 | 2024-09-18T12:11:43.938Z | 2024-09-19T12:20:09.273Z |
5123204 | 5123204 | 20240914091659_QhDJY | US0035 | 2024-09-18T12:11:42.366Z | 2024-09-19T12:20:08.922Z |
5123147 | 5123147 | 20240914090443_dylR6 | US0035 | 2024-09-18T12:11:41.064Z | 2024-09-19T12:20:08.472Z |
5123111 | 5123111 | 20240914085447_RrAsU | US0035 | 2024-09-18T12:11:40.037Z | 2024-09-19T12:20:07.731Z |
5123083 | 5123083 | 20240914084953_zPdSs | US0035 | 2024-09-18T12:11:39.601Z | 2024-09-19T12:20:07.585Z |
5122925 | 5122925 | 20240914082404_nocXV | US0035 | 2024-09-18T12:11:34.280Z | 2024-09-19T12:20:06.707Z |
5122689 | 5122689 | 20240914073237_j1PQo | US0035 | 2024-09-18T12:11:28.449Z | 2024-09-19T12:20:05.725Z |
5122642 | 5122642 | 20240914072651_NzB2E | US0035 | 2024-09-18T12:11:26.703Z | 2024-09-19T12:20:05.498Z |
5122627 | 5122627 | 20240914072452_6wMUM | US0035 | 2024-09-18T12:11:25.615Z | 2024-09-19T12:20:05.458Z |
5122604 | 5122604 | 20240914072209_C35TL | US0035 | 2024-09-18T12:11:24.758Z | 2024-09-19T12:20:05.379Z |
5122407 | 5122407 | 20240914061207_EWst3 | US0035 | 2024-09-18T12:11:17.518Z | 2024-09-19T12:20:04.196Z |
5122378 | 5122378 | 20240914060321_hCsLz | US0035 | 2024-09-18T12:11:16.668Z | 2024-09-19T12:20:04.080Z |
5122373 | 5122373 | 20240914060231_LZsPA | US0035 | 2024-09-18T12:11:15.929Z | 2024-09-19T12:20:04.053Z |
5122323 | 5122323 | 20240914053932_FGx47 | US0035 | 2024-09-18T12:11:14.411Z | 2024-09-19T12:20:03.932Z |
5122283 | 5122283 | 20240914052327_7ujgL | US0035 | 2024-09-18T12:11:12.603Z | 2024-09-19T12:20:03.694Z |
5121259 | 5121259 | 20240914035643_w2UvV | US0035 | 2024-09-18T12:10:53.461Z | 2024-09-19T12:20:01.534Z |
5121188 | 5121188 | 20240914035505_Ks4oq | US0035 | 2024-09-18T12:10:52.270Z | 2024-09-19T12:20:01.487Z |
5120241 | 5120241 | 20240914031005_fQrgh | US0035 | 2024-09-18T12:10:36.128Z | 2024-09-19T12:19:59.807Z |
5119915 | 5119915 | 20240914025315_UYReI | US0035 | 2024-09-18T12:10:29.408Z | 2024-09-19T12:19:59.148Z |
5118461 | 5118461 | 20240915095121_r1kIL | US0035 | 2024-09-18T12:08:45.702Z | 2024-09-19T12:19:23.077Z |
5118221 | 5118221 | 20240915085503_u26Ec | US0035 | 2024-09-18T12:08:31.209Z | 2024-09-19T12:19:21.414Z |
5118193 | 5118193 | 20240915084841_2UeLV | US0035 | 2024-09-18T12:08:29.393Z | 2024-09-19T12:19:21.172Z |
5118174 | 5118174 | 20240915084642_6WYKY | US0035 | 2024-09-18T12:08:28.406Z | 2024-09-19T12:19:21.077Z |
5118118 | 5118118 | 20240915083610_mWjS7 | US0035 | 2024-09-18T12:08:25.140Z | 2024-09-19T12:19:20.582Z |
5117809 | 5117809 | 20240915070714_bgc7M | US0035 | 2024-09-18T12:08:00.908Z | 2024-09-19T12:19:18.148Z |
5117622 | 5117622 | 20240915055314_GEuXo | US0035 | 2024-09-18T12:07:49.641Z | 2024-09-19T12:19:16.502Z |
5117495 | 5117495 | 20240915044610_ucfzN | US0035 | 2024-09-18T12:07:43.220Z | 2024-09-19T12:19:15.485Z |
5117375 | 5117375 | 20240915042134_gkwQb | US0035 | 2024-09-18T12:07:38.986Z | 2024-09-19T12:19:14.533Z |
5116340 | 5116340 | 20240915032237_Hvtya | US0035 | 2024-09-18T12:06:59.022Z | 2024-09-19T12:19:10.565Z |
5115149 | 5115149 | 20240915022227_yfV2Z | US0035 | 2024-09-18T12:06:03.892Z | 2024-09-19T12:19:02.612Z |
5114210 | 5114210 | 20240915013130_Vnx9E | US0035 | 2024-09-18T12:05:06.669Z | 2024-09-19T12:18:56.922Z |
5114155 | 5114155 | 20240915012955_36z96 | US0035 | 2024-09-18T12:05:04.542Z | 2024-09-19T12:18:56.516Z |
5108940 | 5108940 | 20240913080942_YA24Q | US0035 | 2024-09-17T12:14:20.721Z | 2024-09-19T12:20:51.224Z |
5108856 | 5108856 | 20240913074752_k4124 | US0035 | 2024-09-17T12:14:10.763Z | 2024-09-19T12:20:50.954Z |
5108840 | 5108840 | 20240913074443_OQ8eY | US0035 | 2024-09-17T12:14:09.401Z | 2024-09-19T12:20:50.917Z |
5108731 | 5108731 | 20240913071332_3Dxd0 | US0035 | 2024-09-17T12:14:01.789Z | 2024-09-19T12:20:50.534Z |
5108697 | 5108697 | 20240913070506_k5Ng2 | US0035 | 2024-09-17T12:13:58.011Z | 2024-09-19T12:20:50.360Z |
5108427 | 5108427 | 20240913053135_FAoPT | US0035 | 2024-09-17T12:13:44.166Z | 2024-09-19T12:20:48.784Z |
5108420 | 5108420 | 20240913053014_ezPjj | US0035 | 2024-09-17T12:13:43.722Z | 2024-09-19T12:20:48.764Z |
5108407 | 5108407 | 20240913052647_35PSa | US0035 | 2024-09-17T12:13:43.026Z | 2024-09-19T12:20:48.687Z |
5108338 | 5108338 | 20240913045702_TlneO | US0035 | 2024-09-17T12:13:37.598Z | 2024-09-19T12:20:48.262Z |
5107736 | 5107736 | 20240913040923_a3TkJ | US0035 | 2024-09-17T12:13:23.165Z | 2024-09-19T12:20:47.512Z |
5106919 | 5106919 | 20240913033909_qKoOH | US0035 | 2024-09-17T12:13:04.062Z | 2024-09-19T12:20:46.585Z |
5106072 | 5106072 | 20240913030853_1OU2K | US0035 | 2024-09-17T12:12:41.173Z | 2024-09-19T12:20:45.437Z |
5106015 | 5106015 | 20240913030653_u7LQd | US0035 | 2024-09-17T12:12:37.959Z | 2024-09-19T12:20:45.156Z |
5105159 | 5105159 | 20240913023410_wuQv9 | US0035 | 2024-09-17T12:12:00.118Z | 2024-09-19T12:20:44.020Z |
5102739 | 5102739 | 20240914014023_jM7tV | US0035 | 2024-09-17T12:07:33.768Z | 2024-09-19T12:19:55.477Z |
5098157 | 5098157 | 20240913012044_o0jjl | US0035 | 2024-09-16T12:17:21.229Z | 2024-09-19T12:20:39.748Z |
5098044 | 5098044 | 20240913011442_ZuW1T | US0035 | 2024-09-16T12:17:18.997Z | 2024-09-19T12:20:39.559Z |
5097853 | 5097853 | 20240913010624_rCoIu | US0035 | 2024-09-16T12:17:15.690Z | 2024-09-19T12:20:39.127Z |
5097352 | 5097352 | 20240913004226_Z2tEO | US0035 | 2024-09-16T12:17:11.444Z | 2024-09-19T12:20:38.392Z |
5097328 | 5097328 | 20240913004046_fifZg | US0035 | 2024-09-16T12:17:10.826Z | 2024-09-19T12:20:38.262Z |
5095293 | 5095293 | 20240912070111_Z47fA | US0035 | 2024-09-16T12:15:30.367Z | 2024-09-19T12:21:17.975Z |
5095167 | 5095167 | 20240912062353_PfV2Y | US0035 | 2024-09-16T12:15:19.844Z | 2024-09-19T12:21:17.415Z |
5095164 | 5095164 | 20240912062244_53kOr | US0035 | 2024-09-16T12:15:19.791Z | 2024-09-19T12:21:17.414Z |
5095085 | 5095085 | 20240912054533_RCfyk | US0035 | 2024-09-16T12:15:13.365Z | 2024-09-19T12:21:17.245Z |
5095028 | 5095028 | 20240912051628_QCdBR | US0035 | 2024-09-16T12:15:10.102Z | 2024-09-19T12:21:17.009Z |
5093150 | 5093150 | 20240912031250_dWf0d | US0035 | 2024-09-16T12:14:12.317Z | 2024-09-19T12:21:14.985Z |
5082203 | 5082203 | 20240911093633_WzU6v | US0035 | 2024-09-15T12:18:06.627Z | 2024-09-19T12:21:47.469Z |
5082048 | 5082048 | 20240911091517_7tThu | US0035 | 2024-09-15T12:18:00.587Z | 2024-09-19T12:21:47.117Z |
5082031 | 5082031 | 20240911091433_pwL4b | US0035 | 2024-09-15T12:18:00.067Z | 2024-09-19T12:21:47.108Z |
5081972 | 5081972 | 20240911090825_2oi2V | US0035 | 2024-09-15T12:17:56.589Z | 2024-09-19T12:21:46.825Z |
5081892 | 5081892 | 20240911090022_JuhHg | US0035 | 2024-09-15T12:17:53.493Z | 2024-09-19T12:21:46.664Z |
5081821 | 5081821 | 20240911084655_fJ59K | US0035 | 2024-09-15T12:17:49.647Z | 2024-09-19T12:21:46.511Z |
5081653 | 5081653 | 20240911081811_xI8K3 | US0035 | 2024-09-15T12:17:39.968Z | 2024-09-19T12:21:45.978Z |
5081487 | 5081487 | 20240911075017_2OjNt | US0035 | 2024-09-15T12:17:35.735Z | 2024-09-19T12:21:45.551Z |
5081379 | 5081379 | 20240911073232_XWcuh | US0035 | 2024-09-15T12:17:31.790Z | 2024-09-19T12:21:45.218Z |
5081331 | 5081331 | 20240911072320_7TRhg | US0035 | 2024-09-15T12:17:30.508Z | 2024-09-19T12:21:45.091Z |
5080966 | 5080966 | 20240911054725_vgFUv | US0035 | 2024-09-15T12:17:18.712Z | 2024-09-19T12:21:44.149Z |
5080910 | 5080910 | 20240911052239_S5cDh | US0035 | 2024-09-15T12:17:17.039Z | 2024-09-19T12:21:44.038Z |
5080613 | 5080613 | 20240911041339_AEqNK | US0035 | 2024-09-15T12:17:08.908Z | 2024-09-19T12:21:43.353Z |
5080024 | 5080024 | 20240911032727_6TRbm | US0035 | 2024-09-15T12:16:46.482Z | 2024-09-19T12:21:43.033Z |
5078388 | 5078388 | 20240911015503_gy0k7 | US0035 | 2024-09-15T12:15:37.678Z | 2024-09-19T12:21:40.333Z |
5077814 | 5077814 | 20240911012023_yvOv3 | US0035 | 2024-09-15T12:15:07.209Z | 2024-09-19T12:21:39.714Z |
5077451 | 5077451 | 20240911005506_zeA6a | US0035 | 2024-09-15T12:14:45.765Z | 2024-09-19T12:21:39.003Z |
5077420 | 5077420 | 20240911005031_ThXd3 | US0035 | 2024-09-15T12:14:43.914Z | 2024-09-19T12:21:38.980Z |
5067306 | 5067306 | 20240910091747_7zcmz | US0035 | 2024-09-14T12:18:38.815Z | 2024-09-18T12:15:23.768Z |
5067247 | 5067247 | 20240910091212_KxwMv | US0035 | 2024-09-14T12:18:37.273Z | 2024-09-18T12:15:23.677Z |
5067136 | 5067136 | 20240910085900_2drlE | US0035 | 2024-09-14T12:18:33.521Z | 2024-09-18T12:15:23.461Z |
5067129 | 5067129 | 20240910085821_7aPpR | US0035 | 2024-09-14T12:18:33.280Z | 2024-09-18T12:15:23.456Z |
5067030 | 5067030 | 20240910084832_uFwF5 | US0035 | 2024-09-14T12:18:27.456Z | 2024-09-18T12:15:23.221Z |
5066820 | 5066820 | 20240910082111_7ohb2 | US0035 | 2024-09-14T12:18:15.166Z | 2024-09-18T12:15:22.814Z |
5066789 | 5066789 | 20240910081641_2SbpO | US0035 | 2024-09-14T12:18:12.481Z | 2024-09-18T12:15:22.755Z |
5066733 | 5066733 | 20240910081033_ouz38 | US0035 | 2024-09-14T12:18:09.711Z | 2024-09-18T12:15:22.636Z |
5066598 | 5066598 | 20240910075328_8Djhn | US0035 | 2024-09-14T12:18:04.170Z | 2024-09-18T12:15:22.275Z |
5066272 | 5066272 | 20240910070330_W68Am | US0035 | 2024-09-14T12:17:47.799Z | 2024-09-18T12:15:21.503Z |
5066236 | 5066236 | 20240910065722_3AhCN | US0035 | 2024-09-14T12:17:45.986Z | 2024-09-18T12:15:21.433Z |
5066212 | 5066212 | 20240910065331_edcEg | US0035 | 2024-09-14T12:17:45.348Z | 2024-09-18T12:15:21.388Z |
5065874 | 5065874 | 20240910055324_yqpbV | US0035 | 2024-09-14T12:17:26.518Z | 2024-09-18T12:15:20.598Z |
5065778 | 5065778 | 20240910053239_2zsS3 | US0035 | 2024-09-14T12:17:23.542Z | 2024-09-18T12:15:20.394Z |
5065751 | 5065751 | 20240910052657_Avc0I | US0035 | 2024-09-14T12:17:22.595Z | 2024-09-18T12:15:20.310Z |
5065714 | 5065714 | 20240910051850_9wPhM | US0035 | 2024-09-14T12:17:20.612Z | 2024-09-18T12:15:20.204Z |
5065685 | 5065685 | 20240910051256_XioHy | US0035 | 2024-09-14T12:17:19.062Z | 2024-09-18T12:15:20.153Z |
5065654 | 5065654 | 20240910050200_kh0hw | US0035 | 2024-09-14T12:17:16.890Z | 2024-09-18T12:15:20.099Z |
5065652 | 5065652 | 20240910050142_Ru3aM | US0035 | 2024-09-14T12:17:16.776Z | 2024-09-18T12:15:20.097Z |
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);