participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,798 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 |
---|---|---|---|---|---|
5573068 | 5573068 | 20241121034828_RsQ1T | HR0015 | 2024-11-22T14:19:08.298Z | 2024-11-22T14:19:22.444Z |
5572927 | 5572927 | 20241121032503_ZG7a1 | HR0015 | 2024-11-22T14:18:58.997Z | 2024-11-22T14:19:22.415Z |
5572895 | 5572895 | 20241121032258_wC2Au | HR0015 | 2024-11-22T14:18:57.012Z | 2024-11-22T14:19:22.409Z |
5572760 | 5572760 | 20241121030604_hfbp2 | HR0015 | 2024-11-22T14:18:48.376Z | 2024-11-22T14:19:22.386Z |
5572726 | 5572726 | 20241121030240_sA3Wh | HR0015 | 2024-11-22T14:18:46.341Z | 2024-11-22T14:19:22.381Z |
5572632 | 5572632 | 20241121025152_lZXoJ | HR0015 | 2024-11-22T14:18:40.570Z | 2024-11-22T14:19:22.365Z |
5572599 | 5572599 | 20241121024752_OARGP | HR0015 | 2024-11-22T14:18:39.048Z | 2024-11-22T14:19:22.360Z |
5572386 | 5572386 | 20241121021558_Hqa33 | HR0015 | 2024-11-22T14:18:21.430Z | 2024-11-22T14:19:22.319Z |
5572318 | 5572318 | 20241121020915_rmiLX | HR0015 | 2024-11-22T14:18:15.578Z | 2024-11-22T14:19:22.305Z |
5572315 | 5572315 | 20241121020900_YN0lx | HR0015 | 2024-11-22T14:18:15.250Z | 2024-11-22T14:19:22.304Z |
5572281 | 5572281 | 20241121020306_2ap03 | HR0015 | 2024-11-22T14:18:10.965Z | 2024-11-22T14:19:22.297Z |
5572261 | 5572261 | 20241121020039_sA6S1 | HR0015 | 2024-11-22T14:18:08.784Z | 2024-11-22T14:19:22.291Z |
5572166 | 5572166 | 20241121014242_f2CVG | HR0015 | 2024-11-22T14:18:02.700Z | 2024-11-22T14:19:22.272Z |
5571913 | 5571913 | 20241121010653_0pv2c | HR0015 | 2024-11-22T14:17:46.624Z | 2024-11-22T14:19:22.221Z |
5571911 | 5571911 | 20241121010441_ItRSq | HR0015 | 2024-11-22T14:17:46.415Z | 2024-11-22T14:19:22.220Z |
5571907 | 5571907 | 20241121010413_GpP38 | HR0015 | 2024-11-22T14:17:46.239Z | 2024-11-22T14:19:22.219Z |
5571401 | 5571401 | 20241120233927_ZBmmr | HR0015 | 2024-11-22T14:17:02.706Z | 2024-11-22T14:19:22.118Z |
5571393 | 5571393 | 20241120233648_Ktixg | HR0015 | 2024-11-22T14:17:01.044Z | 2024-11-22T14:19:22.116Z |
5565622 | 5565622 | 20241121042655_8QFrj | HR0015 | 2024-11-22T14:00:26.418Z | 2024-11-22T14:00:26.418Z |
5565594 | 5565594 | 20241121042431_DNm8O | HR0015 | 2024-11-22T14:00:22.760Z | 2024-11-22T14:00:22.760Z |
5565496 | 5565496 | 20241117030207_1vDb6 | HR0015 | 2024-11-21T14:23:10.571Z | 2024-11-22T14:23:17.909Z |
5549260 | 5549260 | 20241117040342_j5qVG | HR0015 | 2024-11-18T14:11:22.777Z | 2024-11-22T14:23:19.649Z |
5549233 | 5549233 | 20241117035801_ZQhDw | HR0015 | 2024-11-18T14:11:20.248Z | 2024-11-22T14:23:19.497Z |
5549231 | 5549231 | 20241117035751_HznSq | HR0015 | 2024-11-18T14:11:19.963Z | 2024-11-22T14:23:19.492Z |
5549151 | 5549151 | 20241117032759_li0E0 | HR0015 | 2024-11-18T14:11:09.468Z | 2024-11-22T14:23:18.977Z |
5549128 | 5549128 | 20241117031628_Q9lAQ | HR0015 | 2024-11-18T14:11:01.858Z | 2024-11-22T14:23:18.714Z |
5549117 | 5549117 | 20241117031338_rFwwA | HR0015 | 2024-11-18T14:10:59.813Z | 2024-11-22T14:23:18.686Z |
5549075 | 5549075 | 20241117025849_4EGPE | HR0015 | 2024-11-18T14:10:49.911Z | 2024-11-22T14:23:17.790Z |
5548895 | 5548895 | 20241117021019_aHZcs | HR0015 | 2024-11-18T14:10:24.434Z | 2024-11-22T14:23:16.740Z |
5548575 | 5548575 | 20241117002518_hr1Op | HR0015 | 2024-11-18T14:09:31.295Z | 2024-11-22T14:23:14.400Z |
5545222 | 5545222 | 20241116025947_d4xmW | HR0015 | 2024-11-17T14:04:11.746Z | 2024-11-22T14:23:37.723Z |
5543894 | 5543894 | 20241115042104_mYfI0 | HR0015 | 2024-11-16T14:07:37.185Z | 2024-11-22T14:24:02.332Z |
5543752 | 5543752 | 20241115031826_8IjwA | HR0015 | 2024-11-16T14:07:08.409Z | 2024-11-22T14:24:01.237Z |
5543719 | 5543719 | 20241115030514_C9ITh | HR0015 | 2024-11-16T14:07:04.485Z | 2024-11-22T14:24:00.923Z |
5543531 | 5543531 | 20241115015912_qR6r0 | HR0015 | 2024-11-16T14:06:36.373Z | 2024-11-22T14:23:59.914Z |
5543506 | 5543506 | 20241115014938_6D1mM | HR0015 | 2024-11-16T14:06:32.888Z | 2024-11-22T14:23:59.778Z |
5538503 | 5538503 | 20241113040030_liKat | HR0015 | 2024-11-14T14:13:34.539Z | 2024-11-21T14:26:26.713Z |
5538431 | 5538431 | 20241113034221_CHTQM | HR0015 | 2024-11-14T14:13:26.561Z | 2024-11-21T14:26:25.721Z |
5538376 | 5538376 | 20241113032303_KVjO7 | HR0015 | 2024-11-14T14:13:21.295Z | 2024-11-21T14:26:25.059Z |
5538332 | 5538332 | 20241113031406_yBh7P | HR0015 | 2024-11-14T14:13:16.273Z | 2024-11-21T14:26:23.513Z |
5538307 | 5538307 | 20241113030526_b1dUu | HR0015 | 2024-11-14T14:13:12.675Z | 2024-11-21T14:26:22.997Z |
5538229 | 5538229 | 20241113024245_Q6s79 | HR0015 | 2024-11-14T14:13:06.363Z | 2024-11-21T14:26:21.840Z |
5538070 | 5538070 | 20241113020549_ds3UK | HR0015 | 2024-11-14T14:12:49.304Z | 2024-11-21T14:26:20.311Z |
5537888 | 5537888 | 20241113012312_vLVUw | HR0015 | 2024-11-14T14:12:35.653Z | 2024-11-21T14:26:16.643Z |
5537884 | 5537884 | 20241113012023_v96nN | HR0015 | 2024-11-14T14:12:35.357Z | 2024-11-21T14:26:16.629Z |
5537873 | 5537873 | 20241113011344_rkAzA | HR0015 | 2024-11-14T14:12:34.735Z | 2024-11-21T14:26:16.523Z |
5537703 | 5537703 | 20241113001121_W7fy4 | HR0015 | 2024-11-14T14:12:25.427Z | 2024-11-21T14:26:15.398Z |
5537686 | 5537686 | 20241113000635_DVG5d | HR0015 | 2024-11-14T14:12:24.428Z | 2024-11-21T14:26:15.233Z |
5537586 | 5537586 | 20241112234720_241zy | HR0015 | 2024-11-14T14:12:12.904Z | 2024-11-21T14:26:14.785Z |
5531604 | 5531604 | 20241112035125_F3Am9 | HR0015 | 2024-11-13T14:15:46.380Z | 2024-11-20T14:26:12.688Z |
5531558 | 5531558 | 20241112034815_FkntB | HR0015 | 2024-11-13T14:15:44.608Z | 2024-11-20T14:26:12.340Z |
5531344 | 5531344 | 20241112033241_dG82A | HR0015 | 2024-11-13T14:15:35.108Z | 2024-11-20T14:26:10.428Z |
5531228 | 5531228 | 20241112032358_4A9N2 | HR0015 | 2024-11-13T14:15:28.904Z | 2024-11-20T14:26:08.714Z |
5530927 | 5530927 | 20241112030016_HoE2r | HR0015 | 2024-11-13T14:14:51.724Z | 2024-11-20T14:26:05.335Z |
5530635 | 5530635 | 20241112023554_bvI0v | HR0015 | 2024-11-13T14:14:25.474Z | 2024-11-20T14:26:02.176Z |
5530350 | 5530350 | 20241112021020_Zz7y8 | HR0015 | 2024-11-13T14:14:10.284Z | 2024-11-20T14:25:57.795Z |
5529649 | 5529649 | 20241112004936_Ara0E | HR0015 | 2024-11-13T14:13:04.198Z | 2024-11-20T14:25:47.164Z |
5529539 | 5529539 | 20241112003152_pYiL2 | HR0015 | 2024-11-13T14:12:57.027Z | 2024-11-20T14:25:46.186Z |
5529383 | 5529383 | 20241112000925_fB2jh | HR0015 | 2024-11-13T14:12:29.910Z | 2024-11-20T14:25:43.928Z |
5529334 | 5529334 | 20241112000355_uBIgj | HR0015 | 2024-11-13T14:12:22.878Z | 2024-11-20T14:25:42.887Z |
5529292 | 5529292 | 20241111235751_lk6PA | HR0015 | 2024-11-13T14:12:19.761Z | 2024-11-20T14:25:42.599Z |
5529227 | 5529227 | 20241111234944_P6tjo | HR0015 | 2024-11-13T14:12:14.417Z | 2024-11-20T14:25:41.950Z |
5528653 | 5528653 | 20241111220526_WFPbq | HR0015 | 2024-11-13T14:11:13.195Z | 2024-11-20T14:25:33.219Z |
5528399 | 5528399 | 20241111203910_VZcHV | HR0015 | 2024-11-13T14:10:35.016Z | 2024-11-20T14:25:29.998Z |
5528348 | 5528348 | 20241111202745_GE4pn | HR0015 | 2024-11-13T14:10:29.215Z | 2024-11-20T14:25:28.838Z |
5524418 | 5524418 | 20241111040942_5k29g | HR0015 | 2024-11-12T14:17:17.038Z | 2024-11-19T14:22:21.187Z |
5524390 | 5524390 | 20241111040716_Ss3u7 | HR0015 | 2024-11-12T14:17:14.695Z | 2024-11-19T14:22:20.938Z |
5524304 | 5524304 | 20241111035100_HyXBT | HR0015 | 2024-11-12T14:16:58.724Z | 2024-11-19T14:22:19.851Z |
5524193 | 5524193 | 20241111032752_zelu3 | HR0015 | 2024-11-12T14:16:43.791Z | 2024-11-19T14:22:18.559Z |
5523729 | 5523729 | 20241111021312_2LpUg | HR0015 | 2024-11-12T14:16:09.661Z | 2024-11-19T14:22:14.585Z |
5523591 | 5523591 | 20241111015227_tCEzD | HR0015 | 2024-11-12T14:16:02.363Z | 2024-11-19T14:22:13.596Z |
5523440 | 5523440 | 20241111012550_wjqhu | HR0015 | 2024-11-12T14:15:37.105Z | 2024-11-19T14:22:12.147Z |
5523383 | 5523383 | 20241111011522_g9sme | HR0015 | 2024-11-12T14:15:29.451Z | 2024-11-19T14:22:11.581Z |
5523302 | 5523302 | 20241111005744_nrlMB | HR0015 | 2024-11-12T14:15:17.104Z | 2024-11-19T14:22:11.166Z |
5523300 | 5523300 | 20241111005635_FOz3f | HR0015 | 2024-11-12T14:15:15.769Z | 2024-11-19T14:22:11.150Z |
5523273 | 5523273 | 20241111005119_kQfGM | HR0015 | 2024-11-12T14:15:12.348Z | 2024-11-19T14:22:11.029Z |
5523269 | 5523269 | 20241111005009_OqFBS | HR0015 | 2024-11-12T14:15:11.679Z | 2024-11-19T14:22:10.995Z |
5523188 | 5523188 | 20241111002454_yTjRU | HR0015 | 2024-11-12T14:14:55.755Z | 2024-11-19T14:22:10.392Z |
5523095 | 5523095 | 20241111000029_Hn0qJ | HR0015 | 2024-11-12T14:14:45.296Z | 2024-11-19T14:22:09.928Z |
5522948 | 5522948 | 20241110231534_0NifO | HR0015 | 2024-11-12T14:14:32.939Z | 2024-11-19T14:22:09.101Z |
5522934 | 5522934 | 20241110230635_sWATN | HR0015 | 2024-11-12T14:14:31.645Z | 2024-11-19T14:22:09.002Z |
5522925 | 5522925 | 20241110230039_nH3Mb | HR0015 | 2024-11-12T14:14:30.281Z | 2024-11-19T14:22:08.925Z |
5522800 | 5522800 | 20241110214644_It8eM | HR0015 | 2024-11-12T14:14:19.797Z | 2024-11-19T14:22:06.420Z |
5522779 | 5522779 | 20241110213122_3LLkC | HR0015 | 2024-11-12T14:14:15.591Z | 2024-11-19T14:22:06.257Z |
5517691 | 5517691 | 20241110043135_bmTMs | HR0015 | 2024-11-11T14:14:45.608Z | 2024-11-18T14:26:37.847Z |
5517674 | 5517674 | 20241110042524_kKJhf | HR0015 | 2024-11-11T14:14:43.861Z | 2024-11-18T14:26:37.772Z |
5517525 | 5517525 | 20241110035723_PPdhZ | HR0015 | 2024-11-11T14:14:32.420Z | 2024-11-18T14:26:36.979Z |
5517352 | 5517352 | 20241110033210_CqI3N | HR0015 | 2024-11-11T14:14:17.784Z | 2024-11-18T14:26:36.069Z |
5517324 | 5517324 | 20241110032600_5tZ9S | HR0015 | 2024-11-11T14:14:14.438Z | 2024-11-18T14:26:35.955Z |
5517271 | 5517271 | 20241110031651_XVJxa | HR0015 | 2024-11-11T14:14:11.456Z | 2024-11-18T14:26:35.715Z |
5517080 | 5517080 | 20241110024457_UyzPs | HR0015 | 2024-11-11T14:13:51.236Z | 2024-11-18T14:26:34.646Z |
5516899 | 5516899 | 20241110021737_j6uYn | HR0015 | 2024-11-11T14:13:30.331Z | 2024-11-18T14:26:33.696Z |
5516481 | 5516481 | 20241110010540_1mr1F | HR0015 | 2024-11-11T14:13:03.763Z | 2024-11-18T14:26:31.444Z |
5516465 | 5516465 | 20241110010340_y2JO2 | HR0015 | 2024-11-11T14:13:02.737Z | 2024-11-18T14:26:31.328Z |
5516436 | 5516436 | 20241110005927_0PrCt | HR0015 | 2024-11-11T14:13:01.133Z | 2024-11-18T14:26:31.225Z |
5516075 | 5516075 | 20241109234615_6WrCM | HR0015 | 2024-11-11T14:12:07.913Z | 2024-11-18T14:26:29.325Z |
5516014 | 5516014 | 20241109233434_L8hLj | HR0015 | 2024-11-11T14:11:59.407Z | 2024-11-18T14:26:28.937Z |
5515682 | 5515682 | 20241109222244_2mzU0 | HR0015 | 2024-11-11T14:11:21.516Z | 2024-11-18T14:26:27.418Z |
5515576 | 5515576 | 20241109220207_8otpD | HR0015 | 2024-11-11T14:11:14.454Z | 2024-11-18T14:26:26.831Z |
5515180 | 5515180 | 20241109194804_Zf2hO | HR0015 | 2024-11-11T14:10:16.285Z | 2024-11-18T14:26:24.742Z |
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);