participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,703 rows where station_code = "CA0026" 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 |
---|---|---|---|---|---|
5134479 | 5134479 | 20240916092955_jJCT1 | CA0026 | 2024-09-19T12:17:46.035Z | 2024-09-19T12:17:46.035Z |
5134445 | 5134445 | 20240916091836_DB4oe | CA0026 | 2024-09-19T12:17:44.228Z | 2024-09-19T12:17:44.228Z |
5134406 | 5134406 | 20240916085606_uWa8Q | CA0026 | 2024-09-19T12:17:42.497Z | 2024-09-19T12:17:42.497Z |
5134384 | 5134384 | 20240916084830_62uXk | CA0026 | 2024-09-19T12:17:40.408Z | 2024-09-19T12:17:40.408Z |
5134372 | 5134372 | 20240916083923_LMwfx | CA0026 | 2024-09-19T12:17:39.966Z | 2024-09-19T12:17:39.966Z |
5134368 | 5134368 | 20240916083847_22a3B | CA0026 | 2024-09-19T12:17:39.848Z | 2024-09-19T12:17:39.848Z |
5134366 | 5134366 | 20240916083820_G6H4u | CA0026 | 2024-09-19T12:17:39.820Z | 2024-09-19T12:17:39.820Z |
5134349 | 5134349 | 20240916082930_NWG9b | CA0026 | 2024-09-19T12:17:38.656Z | 2024-09-19T12:17:38.656Z |
5134258 | 5134258 | 20240916073522_PIAs5 | CA0026 | 2024-09-19T12:17:34.110Z | 2024-09-19T12:17:34.110Z |
5134246 | 5134246 | 20240916072508_TqzUi | CA0026 | 2024-09-19T12:17:33.055Z | 2024-09-19T12:17:33.055Z |
5134211 | 5134211 | 20240916064345_5d5eh | CA0026 | 2024-09-19T12:17:30.703Z | 2024-09-19T12:17:30.703Z |
5134187 | 5134187 | 20240916062610_3cHVu | CA0026 | 2024-09-19T12:17:28.580Z | 2024-09-19T12:17:28.580Z |
5134159 | 5134159 | 20240916054057_0igen | CA0026 | 2024-09-19T12:17:25.847Z | 2024-09-19T12:17:25.847Z |
5134142 | 5134142 | 20240916053010_5oDV9 | CA0026 | 2024-09-19T12:17:24.779Z | 2024-09-19T12:17:24.779Z |
5134135 | 5134135 | 20240916052803_XsJJH | CA0026 | 2024-09-19T12:17:24.548Z | 2024-09-19T12:17:24.548Z |
5134016 | 5134016 | 20240916043136_19s2M | CA0026 | 2024-09-19T12:17:16.338Z | 2024-09-19T12:17:16.338Z |
5133597 | 5133597 | 20240916034443_TD4SI | CA0026 | 2024-09-19T12:17:03.305Z | 2024-09-19T12:17:03.305Z |
5133553 | 5133553 | 20240916033954_UywY3 | CA0026 | 2024-09-19T12:17:01.550Z | 2024-09-19T12:17:01.550Z |
5133268 | 5133268 | 20240916031540_0C7Tg | CA0026 | 2024-09-19T12:16:52.284Z | 2024-09-19T12:16:52.284Z |
5133128 | 5133128 | 20240916025959_Vkt3U | CA0026 | 2024-09-19T12:16:44.854Z | 2024-09-19T12:16:44.854Z |
5132687 | 5132687 | 20240916015720_c5cNy | CA0026 | 2024-09-19T12:16:26.623Z | 2024-09-19T12:16:26.623Z |
5132683 | 5132683 | 20240916015516_JPXsc | CA0026 | 2024-09-19T12:16:26.474Z | 2024-09-19T12:16:26.474Z |
5132252 | 5132252 | 20240916001054_89yNL | CA0026 | 2024-09-19T12:16:01.674Z | 2024-09-19T12:16:01.674Z |
5130093 | 5130093 | 20240917085531_eP2uH | CA0026 | 2024-09-19T12:12:33.994Z | 2024-09-19T12:12:33.994Z |
5130052 | 5130052 | 20240917083057_kMp6b | CA0026 | 2024-09-19T12:12:30.081Z | 2024-09-19T12:12:30.081Z |
5129990 | 5129990 | 20240917073057_bhRLN | CA0026 | 2024-09-19T12:12:23.659Z | 2024-09-19T12:12:23.659Z |
5129952 | 5129952 | 20240917065743_FyhMO | CA0026 | 2024-09-19T12:12:19.397Z | 2024-09-19T12:12:19.397Z |
5129931 | 5129931 | 20240917063325_uT52b | CA0026 | 2024-09-19T12:12:17.929Z | 2024-09-19T12:12:17.929Z |
5129908 | 5129908 | 20240917060321_BFHk2 | CA0026 | 2024-09-19T12:12:15.596Z | 2024-09-19T12:12:15.596Z |
5129482 | 5129482 | 20240917040419_LhNRL | CA0026 | 2024-09-19T12:11:42.826Z | 2024-09-19T12:11:42.826Z |
5129480 | 5129480 | 20240917040119_kpW6m | CA0026 | 2024-09-19T12:11:41.935Z | 2024-09-19T12:11:41.935Z |
5129235 | 5129235 | 20240917033902_CpnEj | CA0026 | 2024-09-19T12:11:23.871Z | 2024-09-19T12:11:23.871Z |
5128065 | 5128065 | 20240917003217_njnLv | CA0026 | 2024-09-19T12:09:59.794Z | 2024-09-19T12:09:59.794Z |
5127952 | 5127952 | 20240917000932_FSCtI | CA0026 | 2024-09-19T12:09:48.480Z | 2024-09-19T12:09:48.480Z |
5127894 | 5127894 | 20240917000031_5khTi | CA0026 | 2024-09-19T12:09:45.956Z | 2024-09-19T12:09:45.956Z |
5126065 | 5126065 | 20240918074932_r1t40 | CA0026 | 2024-09-19T12:04:53.060Z | 2024-09-19T12:06:42.134Z |
5126040 | 5126040 | 20240918071452_Nw9dR | CA0026 | 2024-09-19T12:04:49.613Z | 2024-09-19T12:06:42.129Z |
5125934 | 5125934 | 20240918045832_LVK1Q | CA0026 | 2024-09-19T12:04:35.571Z | 2024-09-19T12:06:42.111Z |
5125835 | 5125835 | 20240918040403_90Lfr | CA0026 | 2024-09-19T12:04:12.460Z | 2024-09-19T12:06:42.093Z |
5125672 | 5125672 | 20240918031629_2Ztld | CA0026 | 2024-09-19T12:03:50.563Z | 2024-09-19T12:06:42.066Z |
5125626 | 5125626 | 20240918031148_Q3qOK | CA0026 | 2024-09-19T12:03:45.643Z | 2024-09-19T12:06:42.060Z |
5125226 | 5125226 | 20240918012220_umdQw | CA0026 | 2024-09-19T12:02:32.435Z | 2024-09-19T12:06:41.994Z |
5123248 | 5123248 | 20240914092508_Xq03R | CA0026 | 2024-09-18T12:11:43.369Z | 2024-09-19T12:20:09.142Z |
5123106 | 5123106 | 20240914085352_Angbu | CA0026 | 2024-09-18T12:11:40.014Z | 2024-09-19T12:20:07.714Z |
5123028 | 5123028 | 20240914084343_ze6l1 | CA0026 | 2024-09-18T12:11:38.585Z | 2024-09-19T12:20:07.352Z |
5122984 | 5122984 | 20240914083333_Do0Ab | CA0026 | 2024-09-18T12:11:36.909Z | 2024-09-19T12:20:07.100Z |
5122904 | 5122904 | 20240914081902_2qdYT | CA0026 | 2024-09-18T12:11:33.774Z | 2024-09-19T12:20:06.663Z |
5122738 | 5122738 | 20240914074704_MsChW | CA0026 | 2024-09-18T12:11:29.756Z | 2024-09-19T12:20:05.894Z |
5122638 | 5122638 | 20240914072647_IyQxe | CA0026 | 2024-09-18T12:11:26.640Z | 2024-09-19T12:20:05.488Z |
5122562 | 5122562 | 20240914070816_ku93I | CA0026 | 2024-09-18T12:11:23.313Z | 2024-09-19T12:20:05.018Z |
5122551 | 5122551 | 20240914070556_YJQU5 | CA0026 | 2024-09-18T12:11:22.997Z | 2024-09-19T12:20:04.946Z |
5122519 | 5122519 | 20240914070043_ts9C8 | CA0026 | 2024-09-18T12:11:21.836Z | 2024-09-19T12:20:04.710Z |
5122513 | 5122513 | 20240914065951_UK5DD | CA0026 | 2024-09-18T12:11:21.569Z | 2024-09-19T12:20:04.702Z |
5122508 | 5122508 | 20240914065516_kkgfj | CA0026 | 2024-09-18T12:11:21.196Z | 2024-09-19T12:20:04.672Z |
5122363 | 5122363 | 20240914055611_jSq91 | CA0026 | 2024-09-18T12:11:15.612Z | 2024-09-19T12:20:04.014Z |
5122351 | 5122351 | 20240914054947_mjlC3 | CA0026 | 2024-09-18T12:11:15.445Z | 2024-09-19T12:20:03.991Z |
5122294 | 5122294 | 20240914052732_xubqV | CA0026 | 2024-09-18T12:11:12.968Z | 2024-09-19T12:20:03.755Z |
5122277 | 5122277 | 20240914051949_zff8I | CA0026 | 2024-09-18T12:11:12.281Z | 2024-09-19T12:20:03.671Z |
5122272 | 5122272 | 20240914051822_oF5dR | CA0026 | 2024-09-18T12:11:12.155Z | 2024-09-19T12:20:03.591Z |
5122259 | 5122259 | 20240914051631_r9ocy | CA0026 | 2024-09-18T12:11:11.884Z | 2024-09-19T12:20:03.536Z |
5122241 | 5122241 | 20240914051040_hurPN | CA0026 | 2024-09-18T12:11:11.285Z | 2024-09-19T12:20:03.434Z |
5122222 | 5122222 | 20240914050206_HRyBC | CA0026 | 2024-09-18T12:11:10.786Z | 2024-09-19T12:20:03.265Z |
5122200 | 5122200 | 20240914045330_OybMA | CA0026 | 2024-09-18T12:11:09.582Z | 2024-09-19T12:20:03.127Z |
5122006 | 5122006 | 20240914042603_2JA3d | CA0026 | 2024-09-18T12:11:04.777Z | 2024-09-19T12:20:02.674Z |
5121088 | 5121088 | 20240914035146_F9t0y | CA0026 | 2024-09-18T12:10:50.808Z | 2024-09-19T12:20:01.331Z |
5120988 | 5120988 | 20240914034358_DMLnJ | CA0026 | 2024-09-18T12:10:49.092Z | 2024-09-19T12:20:01.088Z |
5120570 | 5120570 | 20240914032804_QZc4q | CA0026 | 2024-09-18T12:10:43.206Z | 2024-09-19T12:20:00.605Z |
5119361 | 5119361 | 20240914022831_vUD5R | CA0026 | 2024-09-18T12:10:20.598Z | 2024-09-19T12:19:58.090Z |
5118362 | 5118362 | 20240915092916_IsiMB | CA0026 | 2024-09-18T12:08:39.799Z | 2024-09-19T12:19:22.328Z |
5118323 | 5118323 | 20240915092105_qt2ER | CA0026 | 2024-09-18T12:08:37.694Z | 2024-09-19T12:19:22.072Z |
5118307 | 5118307 | 20240915091419_aCelr | CA0026 | 2024-09-18T12:08:36.915Z | 2024-09-19T12:19:21.977Z |
5118137 | 5118137 | 20240915084058_6Dky4 | CA0026 | 2024-09-18T12:08:26.460Z | 2024-09-19T12:19:20.720Z |
5118026 | 5118026 | 20240915080909_9MwPW | CA0026 | 2024-09-18T12:08:18.921Z | 2024-09-19T12:19:19.833Z |
5117994 | 5117994 | 20240915080737_Y90JR | CA0026 | 2024-09-18T12:08:16.120Z | 2024-09-19T12:19:19.600Z |
5117922 | 5117922 | 20240915074739_dYo2Q | CA0026 | 2024-09-18T12:08:07.467Z | 2024-09-19T12:19:18.962Z |
5117827 | 5117827 | 20240915071416_NOJy2 | CA0026 | 2024-09-18T12:08:02.137Z | 2024-09-19T12:19:18.313Z |
5117639 | 5117639 | 20240915055658_dAqUL | CA0026 | 2024-09-18T12:07:50.540Z | 2024-09-19T12:19:16.668Z |
5117585 | 5117585 | 20240915053703_iWYVn | CA0026 | 2024-09-18T12:07:47.910Z | 2024-09-19T12:19:16.145Z |
5117550 | 5117550 | 20240915051744_gtiqR | CA0026 | 2024-09-18T12:07:46.374Z | 2024-09-19T12:19:15.902Z |
5117543 | 5117543 | 20240915051308_rVblZ | CA0026 | 2024-09-18T12:07:46.168Z | 2024-09-19T12:19:15.843Z |
5117512 | 5117512 | 20240915045058_W0kk4 | CA0026 | 2024-09-18T12:07:44.312Z | 2024-09-19T12:19:15.568Z |
5117331 | 5117331 | 20240915041926_MBx0V | CA0026 | 2024-09-18T12:07:38.000Z | 2024-09-19T12:19:14.303Z |
5117325 | 5117325 | 20240915041840_6ua7Q | CA0026 | 2024-09-18T12:07:37.913Z | 2024-09-19T12:19:14.302Z |
5115899 | 5115899 | 20240915025845_yPMMh | CA0026 | 2024-09-18T12:06:31.363Z | 2024-09-19T12:19:07.803Z |
5113087 | 5113087 | 20240915002151_2RZSA | CA0026 | 2024-09-18T12:03:56.034Z | 2024-09-19T12:18:46.990Z |
5110475 | 5110475 | 20240911080214_VBorO | CA0026 | 2024-09-17T12:18:13.261Z | 2024-09-19T12:21:45.762Z |
5109242 | 5109242 | 20240913091826_2ViEz | CA0026 | 2024-09-17T12:14:33.885Z | 2024-09-19T12:20:52.657Z |
5109195 | 5109195 | 20240913091106_o1R39 | CA0026 | 2024-09-17T12:14:32.975Z | 2024-09-19T12:20:52.433Z |
5109135 | 5109135 | 20240913085446_KG8Hd | CA0026 | 2024-09-17T12:14:31.277Z | 2024-09-19T12:20:51.807Z |
5109081 | 5109081 | 20240913084253_h3dQc | CA0026 | 2024-09-17T12:14:29.715Z | 2024-09-19T12:20:51.655Z |
5109045 | 5109045 | 20240913083413_2WWzs | CA0026 | 2024-09-17T12:14:27.885Z | 2024-09-19T12:20:51.545Z |
5109025 | 5109025 | 20240913082801_iFsfu | CA0026 | 2024-09-17T12:14:26.238Z | 2024-09-19T12:20:51.499Z |
5109006 | 5109006 | 20240913082313_uBpFQ | CA0026 | 2024-09-17T12:14:25.215Z | 2024-09-19T12:20:51.441Z |
5108953 | 5108953 | 20240913081327_BQJ3Z | CA0026 | 2024-09-17T12:14:21.833Z | 2024-09-19T12:20:51.291Z |
5108873 | 5108873 | 20240913075322_dYqho | CA0026 | 2024-09-17T12:14:13.284Z | 2024-09-19T12:20:50.975Z |
5108727 | 5108727 | 20240913071207_FCuPG | CA0026 | 2024-09-17T12:14:00.920Z | 2024-09-19T12:20:50.508Z |
5108482 | 5108482 | 20240913055623_nQ6aq | CA0026 | 2024-09-17T12:13:47.253Z | 2024-09-19T12:20:48.977Z |
5108265 | 5108265 | 20240913043835_Ajl9o | CA0026 | 2024-09-17T12:13:34.454Z | 2024-09-19T12:20:47.990Z |
5107699 | 5107699 | 20240913040833_2q0B4 | CA0026 | 2024-09-17T12:13:21.967Z | 2024-09-19T12:20:47.470Z |
5106694 | 5106694 | 20240913033231_ewXas | CA0026 | 2024-09-17T12:12:59.641Z | 2024-09-19T12:20:46.290Z |
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);