participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,733 rows where station_code = "HR0015" 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 |
---|---|---|---|---|---|
5524418 | 5524418 | 20241111040942_5k29g | HR0015 | 2024-11-12T14:17:17.038Z | 2024-11-12T14:18:08.611Z |
5524390 | 5524390 | 20241111040716_Ss3u7 | HR0015 | 2024-11-12T14:17:14.695Z | 2024-11-12T14:18:08.597Z |
5524304 | 5524304 | 20241111035100_HyXBT | HR0015 | 2024-11-12T14:16:58.724Z | 2024-11-12T14:18:08.553Z |
5524193 | 5524193 | 20241111032752_zelu3 | HR0015 | 2024-11-12T14:16:43.791Z | 2024-11-12T14:18:08.506Z |
5523729 | 5523729 | 20241111021312_2LpUg | HR0015 | 2024-11-12T14:16:09.661Z | 2024-11-12T14:18:08.319Z |
5523591 | 5523591 | 20241111015227_tCEzD | HR0015 | 2024-11-12T14:16:02.363Z | 2024-11-12T14:18:08.262Z |
5523440 | 5523440 | 20241111012550_wjqhu | HR0015 | 2024-11-12T14:15:37.105Z | 2024-11-12T14:18:08.196Z |
5523383 | 5523383 | 20241111011522_g9sme | HR0015 | 2024-11-12T14:15:29.451Z | 2024-11-12T14:18:08.169Z |
5523302 | 5523302 | 20241111005744_nrlMB | HR0015 | 2024-11-12T14:15:17.104Z | 2024-11-12T14:18:08.134Z |
5523300 | 5523300 | 20241111005635_FOz3f | HR0015 | 2024-11-12T14:15:15.769Z | 2024-11-12T14:18:08.132Z |
5523273 | 5523273 | 20241111005119_kQfGM | HR0015 | 2024-11-12T14:15:12.348Z | 2024-11-12T14:18:08.119Z |
5523269 | 5523269 | 20241111005009_OqFBS | HR0015 | 2024-11-12T14:15:11.679Z | 2024-11-12T14:18:08.117Z |
5523188 | 5523188 | 20241111002454_yTjRU | HR0015 | 2024-11-12T14:14:55.755Z | 2024-11-12T14:18:08.074Z |
5523095 | 5523095 | 20241111000029_Hn0qJ | HR0015 | 2024-11-12T14:14:45.296Z | 2024-11-12T14:18:08.028Z |
5522948 | 5522948 | 20241110231534_0NifO | HR0015 | 2024-11-12T14:14:32.939Z | 2024-11-12T14:18:07.969Z |
5522934 | 5522934 | 20241110230635_sWATN | HR0015 | 2024-11-12T14:14:31.645Z | 2024-11-12T14:18:07.962Z |
5522925 | 5522925 | 20241110230039_nH3Mb | HR0015 | 2024-11-12T14:14:30.281Z | 2024-11-12T14:18:07.958Z |
5522800 | 5522800 | 20241110214644_It8eM | HR0015 | 2024-11-12T14:14:19.797Z | 2024-11-12T14:18:07.902Z |
5522779 | 5522779 | 20241110213122_3LLkC | HR0015 | 2024-11-12T14:14:15.591Z | 2024-11-12T14:18:07.892Z |
5517691 | 5517691 | 20241110043135_bmTMs | HR0015 | 2024-11-11T14:14:45.608Z | 2024-11-12T14:21:52.281Z |
5517674 | 5517674 | 20241110042524_kKJhf | HR0015 | 2024-11-11T14:14:43.861Z | 2024-11-12T14:21:51.532Z |
5517525 | 5517525 | 20241110035723_PPdhZ | HR0015 | 2024-11-11T14:14:32.420Z | 2024-11-12T14:21:45.122Z |
5517352 | 5517352 | 20241110033210_CqI3N | HR0015 | 2024-11-11T14:14:17.784Z | 2024-11-12T14:21:38.518Z |
5517324 | 5517324 | 20241110032600_5tZ9S | HR0015 | 2024-11-11T14:14:14.438Z | 2024-11-12T14:21:37.861Z |
5517271 | 5517271 | 20241110031651_XVJxa | HR0015 | 2024-11-11T14:14:11.456Z | 2024-11-12T14:21:36.702Z |
5517080 | 5517080 | 20241110024457_UyzPs | HR0015 | 2024-11-11T14:13:51.236Z | 2024-11-12T14:21:31.117Z |
5516899 | 5516899 | 20241110021737_j6uYn | HR0015 | 2024-11-11T14:13:30.331Z | 2024-11-12T14:21:23.336Z |
5516481 | 5516481 | 20241110010540_1mr1F | HR0015 | 2024-11-11T14:13:03.763Z | 2024-11-12T14:21:07.078Z |
5516465 | 5516465 | 20241110010340_y2JO2 | HR0015 | 2024-11-11T14:13:02.737Z | 2024-11-12T14:21:06.336Z |
5516436 | 5516436 | 20241110005927_0PrCt | HR0015 | 2024-11-11T14:13:01.133Z | 2024-11-12T14:21:05.150Z |
5516075 | 5516075 | 20241109234615_6WrCM | HR0015 | 2024-11-11T14:12:07.913Z | 2024-11-12T14:20:48.698Z |
5516014 | 5516014 | 20241109233434_L8hLj | HR0015 | 2024-11-11T14:11:59.407Z | 2024-11-12T14:20:47.192Z |
5515682 | 5515682 | 20241109222244_2mzU0 | HR0015 | 2024-11-11T14:11:21.516Z | 2024-11-12T14:20:33.300Z |
5515576 | 5515576 | 20241109220207_8otpD | HR0015 | 2024-11-11T14:11:14.454Z | 2024-11-12T14:20:27.752Z |
5515180 | 5515180 | 20241109194804_Zf2hO | HR0015 | 2024-11-11T14:10:16.285Z | 2024-11-12T14:20:12.321Z |
5510174 | 5510174 | 20241109015418_xOFiA | HR0015 | 2024-11-10T14:14:44.094Z | 2024-11-12T14:23:31.429Z |
5510058 | 5510058 | 20241109013802_3Z0nz | HR0015 | 2024-11-10T14:14:31.722Z | 2024-11-12T14:23:29.819Z |
5510045 | 5510045 | 20241109013427_9mrPX | HR0015 | 2024-11-10T14:14:30.491Z | 2024-11-12T14:23:29.668Z |
5509996 | 5509996 | 20241109012503_mCJ52 | HR0015 | 2024-11-10T14:14:25.582Z | 2024-11-12T14:23:28.688Z |
5509995 | 5509995 | 20241109012442_w3s4i | HR0015 | 2024-11-10T14:14:24.892Z | 2024-11-12T14:23:28.670Z |
5509597 | 5509597 | 20241108235213_fuYf5 | HR0015 | 2024-11-10T14:13:38.490Z | 2024-11-12T14:23:22.263Z |
5509510 | 5509510 | 20241108233443_2t9uT | HR0015 | 2024-11-10T14:13:29.227Z | 2024-11-12T14:23:20.977Z |
5509501 | 5509501 | 20241108233343_QJVHc | HR0015 | 2024-11-10T14:13:28.327Z | 2024-11-12T14:23:20.588Z |
5509189 | 5509189 | 20241108222230_Ne5o2 | HR0015 | 2024-11-10T14:12:50.564Z | 2024-11-12T14:23:14.921Z |
5509171 | 5509171 | 20241108221345_VIWAo | HR0015 | 2024-11-10T14:12:47.916Z | 2024-11-12T14:23:14.294Z |
5509129 | 5509129 | 20241108215931_7gLJP | HR0015 | 2024-11-10T14:12:37.146Z | 2024-11-12T14:23:13.903Z |
5508949 | 5508949 | 20241108205651_mfjwp | HR0015 | 2024-11-10T14:12:08.784Z | 2024-11-12T14:23:09.998Z |
5508687 | 5508687 | 20241108174533_Youa3 | HR0015 | 2024-11-10T14:11:12.050Z | 2024-11-12T14:22:56.551Z |
5505247 | 5505247 | 20241108041557_dPUkT | HR0015 | 2024-11-09T14:15:59.036Z | 2024-11-12T14:25:14.193Z |
5505120 | 5505120 | 20241108035536_hqba2 | HR0015 | 2024-11-09T14:15:45.806Z | 2024-11-12T14:25:12.545Z |
5504730 | 5504730 | 20241108024811_jG13L | HR0015 | 2024-11-09T14:15:07.749Z | 2024-11-12T14:25:07.104Z |
5504673 | 5504673 | 20241108023842_yG8bK | HR0015 | 2024-11-09T14:15:03.185Z | 2024-11-12T14:25:06.348Z |
5504665 | 5504665 | 20241108023702_R6zoT | HR0015 | 2024-11-09T14:15:02.583Z | 2024-11-12T14:25:06.311Z |
5504661 | 5504661 | 20241108023556_cM33o | HR0015 | 2024-11-09T14:15:02.054Z | 2024-11-12T14:25:06.233Z |
5504650 | 5504650 | 20241108023510_ubUew | HR0015 | 2024-11-09T14:15:01.167Z | 2024-11-12T14:25:05.802Z |
5504614 | 5504614 | 20241108022418_vGj2L | HR0015 | 2024-11-09T14:14:57.020Z | 2024-11-12T14:25:05.545Z |
5504551 | 5504551 | 20241108021434_993Ss | HR0015 | 2024-11-09T14:14:50.412Z | 2024-11-12T14:25:04.867Z |
5504485 | 5504485 | 20241108020456_rzTc2 | HR0015 | 2024-11-09T14:14:44.316Z | 2024-11-12T14:25:03.697Z |
5504406 | 5504406 | 20241108015428_vq0nb | HR0015 | 2024-11-09T14:14:34.194Z | 2024-11-12T14:25:02.009Z |
5504401 | 5504401 | 20241108015307_kNnzB | HR0015 | 2024-11-09T14:14:33.054Z | 2024-11-12T14:25:01.988Z |
5504390 | 5504390 | 20241108015142_mkBq4 | HR0015 | 2024-11-09T14:14:30.796Z | 2024-11-12T14:25:01.941Z |
5504137 | 5504137 | 20241108010110_0fJDS | HR0015 | 2024-11-09T14:14:06.786Z | 2024-11-12T14:24:58.398Z |
5504123 | 5504123 | 20241108005828_w10uj | HR0015 | 2024-11-09T14:14:06.072Z | 2024-11-12T14:24:58.354Z |
5504094 | 5504094 | 20241108005156_5zMsd | HR0015 | 2024-11-09T14:14:04.048Z | 2024-11-12T14:24:57.570Z |
5504058 | 5504058 | 20241108004634_sA5XN | HR0015 | 2024-11-09T14:14:01.403Z | 2024-11-12T14:24:56.140Z |
5504050 | 5504050 | 20241108004532_NoLTM | HR0015 | 2024-11-09T14:14:00.670Z | 2024-11-12T14:24:55.839Z |
5503824 | 5503824 | 20241107235517_8Hqrt | HR0015 | 2024-11-09T14:13:46.356Z | 2024-11-12T14:24:53.194Z |
5503652 | 5503652 | 20241107231531_fjKLB | HR0015 | 2024-11-09T14:13:29.243Z | 2024-11-12T14:24:50.345Z |
5503601 | 5503601 | 20241107230003_vMcQ5 | HR0015 | 2024-11-09T14:13:23.383Z | 2024-11-12T14:24:49.396Z |
5503542 | 5503542 | 20241107224549_Fz32k | HR0015 | 2024-11-09T14:13:16.644Z | 2024-11-12T14:24:48.525Z |
5503507 | 5503507 | 20241107223751_Am6VF | HR0015 | 2024-11-09T14:13:13.942Z | 2024-11-12T14:24:48.308Z |
5503499 | 5503499 | 20241107223453_dbZge | HR0015 | 2024-11-09T14:13:12.955Z | 2024-11-12T14:24:48.249Z |
5503445 | 5503445 | 20241107222214_pgICq | HR0015 | 2024-11-09T14:13:06.005Z | 2024-11-12T14:24:47.336Z |
5503407 | 5503407 | 20241107220936_k83es | HR0015 | 2024-11-09T14:13:00.627Z | 2024-11-12T14:24:47.111Z |
5503316 | 5503316 | 20241107213629_RIvv6 | HR0015 | 2024-11-09T14:12:48.153Z | 2024-11-12T14:24:45.825Z |
5503272 | 5503272 | 20241107211945_Nh7d3 | HR0015 | 2024-11-09T14:12:42.402Z | 2024-11-12T14:24:45.480Z |
5503213 | 5503213 | 20241107205930_qZp0z | HR0015 | 2024-11-09T14:12:35.018Z | 2024-11-12T14:24:45.083Z |
5503145 | 5503145 | 20241107205001_JcgwO | HR0015 | 2024-11-09T14:12:27.824Z | 2024-11-12T14:24:44.621Z |
5502971 | 5502971 | 20241107202113_NbgCg | HR0015 | 2024-11-09T14:12:16.265Z | 2024-11-12T14:24:42.392Z |
5502858 | 5502858 | 20241107195921_ClSrm | HR0015 | 2024-11-09T14:12:08.601Z | 2024-11-12T14:24:40.306Z |
5502746 | 5502746 | 20241107194030_626mL | HR0015 | 2024-11-09T14:12:01.199Z | 2024-11-12T14:24:38.511Z |
5502542 | 5502542 | 20241107190003_aO9ss | HR0015 | 2024-11-09T14:11:42.293Z | 2024-11-12T14:24:36.882Z |
5502472 | 5502472 | 20241107184226_EgfCF | HR0015 | 2024-11-09T14:11:26.769Z | 2024-11-12T14:24:35.876Z |
5502465 | 5502465 | 20241107184124_5wMMZ | HR0015 | 2024-11-09T14:11:25.824Z | 2024-11-12T14:24:35.769Z |
5497701 | 5497701 | 20241107043639_GMBm2 | HR0015 | 2024-11-08T14:14:13.411Z | 2024-11-12T14:26:13.838Z |
5497662 | 5497662 | 20241107042141_dQ3An | HR0015 | 2024-11-08T14:14:09.235Z | 2024-11-12T14:26:13.688Z |
5497636 | 5497636 | 20241107041622_k7Bd7 | HR0015 | 2024-11-08T14:14:06.587Z | 2024-11-12T14:26:13.583Z |
5497623 | 5497623 | 20241107041352_y33lt | HR0015 | 2024-11-08T14:14:04.965Z | 2024-11-12T14:26:13.320Z |
5497577 | 5497577 | 20241107040246_X9JIv | HR0015 | 2024-11-08T14:13:59.398Z | 2024-11-12T14:26:12.873Z |
5497561 | 5497561 | 20241107040117_R6y0d | HR0015 | 2024-11-08T14:13:58.766Z | 2024-11-12T14:26:12.652Z |
5497497 | 5497497 | 20241107035033_PfbTh | HR0015 | 2024-11-08T14:13:54.201Z | 2024-11-12T14:26:12.435Z |
5497493 | 5497493 | 20241107035007_XQyuN | HR0015 | 2024-11-08T14:13:52.592Z | 2024-11-12T14:26:12.424Z |
5497425 | 5497425 | 20241107033724_R2dnz | HR0015 | 2024-11-08T14:13:45.464Z | 2024-11-12T14:26:11.884Z |
5497366 | 5497366 | 20241107032837_IqoJR | HR0015 | 2024-11-08T14:13:38.421Z | 2024-11-12T14:26:11.199Z |
5497354 | 5497354 | 20241107032739_TdS3p | HR0015 | 2024-11-08T14:13:37.600Z | 2024-11-12T14:26:11.167Z |
5497348 | 5497348 | 20241107032627_Mvrs1 | HR0015 | 2024-11-08T14:13:36.602Z | 2024-11-12T14:26:11.134Z |
5497265 | 5497265 | 20241107031022_uZMZR | HR0015 | 2024-11-08T14:13:27.627Z | 2024-11-12T14:26:10.444Z |
5497251 | 5497251 | 20241107030603_jSP3y | HR0015 | 2024-11-08T14:13:26.663Z | 2024-11-12T14:26:10.328Z |
5497250 | 5497250 | 20241107030534_PBKgH | HR0015 | 2024-11-08T14:13:26.524Z | 2024-11-12T14:26:10.260Z |
5497232 | 5497232 | 20241107030121_nX2Js | HR0015 | 2024-11-08T14:13:25.330Z | 2024-11-12T14:26:10.157Z |
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);