participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,959 rows where station_code = "HR001D" 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 |
---|---|---|---|---|---|
5524566 | 5524566 | 20241111043648_6Y9R8 | HR001D | 2024-11-12T14:17:41.179Z | 2024-11-12T14:18:08.683Z |
5522950 | 5522950 | 20241110231544_TzqJq | HR001D | 2024-11-12T14:14:33.092Z | 2024-11-12T14:18:07.970Z |
5522923 | 5522923 | 20241110225924_2ZthX | HR001D | 2024-11-12T14:14:30.013Z | 2024-11-12T14:18:07.956Z |
5522852 | 5522852 | 20241110222134_x3sGv | HR001D | 2024-11-12T14:14:24.229Z | 2024-11-12T14:18:07.925Z |
5522837 | 5522837 | 20241110221641_rDfeB | HR001D | 2024-11-12T14:14:22.962Z | 2024-11-12T14:18:07.919Z |
5522408 | 5522408 | 20241110195702_i6bis | HR001D | 2024-11-12T14:13:12.476Z | 2024-11-12T14:18:07.732Z |
5522344 | 5522344 | 20241110194822_3NBP2 | HR001D | 2024-11-12T14:13:06.391Z | 2024-11-12T14:18:07.700Z |
5521540 | 5521540 | 20241110172742_4CoY3 | HR001D | 2024-11-12T14:11:30.956Z | 2024-11-12T14:18:07.343Z |
5521495 | 5521495 | 20241110172213_54aZ4 | HR001D | 2024-11-12T14:11:18.620Z | 2024-11-12T14:18:07.325Z |
5521344 | 5521344 | 20241110165355_KV3Wk | HR001D | 2024-11-12T14:10:52.192Z | 2024-11-12T14:18:07.249Z |
5517690 | 5517690 | 20241110043039_oRx62 | HR001D | 2024-11-11T14:14:45.064Z | 2024-11-12T14:21:52.231Z |
5517611 | 5517611 | 20241110041139_Kb3va | HR001D | 2024-11-11T14:14:39.942Z | 2024-11-12T14:21:48.405Z |
5517468 | 5517468 | 20241110034656_3D5bO | HR001D | 2024-11-11T14:14:26.862Z | 2024-11-12T14:21:42.643Z |
5517340 | 5517340 | 20241110032819_5BZ7t | HR001D | 2024-11-11T14:14:16.645Z | 2024-11-12T14:21:38.233Z |
5517222 | 5517222 | 20241110030700_fCgpf | HR001D | 2024-11-11T14:14:06.863Z | 2024-11-12T14:21:35.315Z |
5517066 | 5517066 | 20241110024221_mXuIe | HR001D | 2024-11-11T14:13:49.640Z | 2024-11-12T14:21:30.428Z |
5516654 | 5516654 | 20241110013418_OBpGQ | HR001D | 2024-11-11T14:13:13.357Z | 2024-11-12T14:21:15.085Z |
5516327 | 5516327 | 20241110004039_BTezr | HR001D | 2024-11-11T14:12:44.427Z | 2024-11-12T14:21:00.348Z |
5516206 | 5516206 | 20241110001315_5ffdi | HR001D | 2024-11-11T14:12:27.288Z | 2024-11-12T14:20:53.745Z |
5516009 | 5516009 | 20241109233343_Dtzmr | HR001D | 2024-11-11T14:11:58.275Z | 2024-11-12T14:20:47.089Z |
5515964 | 5515964 | 20241109232027_8AI2a | HR001D | 2024-11-11T14:11:51.127Z | 2024-11-12T14:20:45.101Z |
5515850 | 5515850 | 20241109225749_QYzhw | HR001D | 2024-11-11T14:11:37.246Z | 2024-11-12T14:20:41.047Z |
5515476 | 5515476 | 20241109213336_hW0rU | HR001D | 2024-11-11T14:11:07.147Z | 2024-11-12T14:20:23.666Z |
5515308 | 5515308 | 20241109202923_EVZhr | HR001D | 2024-11-11T14:10:41.006Z | 2024-11-12T14:20:17.165Z |
5515304 | 5515304 | 20241109202459_fKnJr | HR001D | 2024-11-11T14:10:39.999Z | 2024-11-12T14:20:16.942Z |
5515055 | 5515055 | 20241109191222_gUZIX | HR001D | 2024-11-11T14:09:57.971Z | 2024-11-12T14:20:05.805Z |
5514983 | 5514983 | 20241109184739_JbXkv | HR001D | 2024-11-11T14:09:50.979Z | 2024-11-12T14:20:01.401Z |
5511078 | 5511078 | 20241109041946_ETKXQ | HR001D | 2024-11-10T14:16:12.270Z | 2024-11-12T14:23:44.583Z |
5509589 | 5509589 | 20241108235147_cEGoc | HR001D | 2024-11-10T14:13:37.658Z | 2024-11-12T14:23:22.165Z |
5508953 | 5508953 | 20241108205935_HFUFz | HR001D | 2024-11-10T14:12:09.258Z | 2024-11-12T14:23:10.082Z |
5508905 | 5508905 | 20241108203547_tD3Tv | HR001D | 2024-11-10T14:12:01.629Z | 2024-11-12T14:23:07.893Z |
5508684 | 5508684 | 20241108174229_27se6 | HR001D | 2024-11-10T14:11:10.962Z | 2024-11-12T14:22:56.147Z |
5504388 | 5504388 | 20241108015132_2nhZI | HR001D | 2024-11-09T14:14:30.680Z | 2024-11-12T14:25:01.930Z |
5504021 | 5504021 | 20241108003952_fPmzm | HR001D | 2024-11-09T14:13:58.904Z | 2024-11-12T14:24:55.425Z |
5503973 | 5503973 | 20241108002928_nL3ns | HR001D | 2024-11-09T14:13:55.737Z | 2024-11-12T14:24:55.065Z |
5503836 | 5503836 | 20241107235559_WjGod | HR001D | 2024-11-09T14:13:47.126Z | 2024-11-12T14:24:53.546Z |
5503582 | 5503582 | 20241107225726_dZhwG | HR001D | 2024-11-09T14:13:19.871Z | 2024-11-12T14:24:49.246Z |
5503519 | 5503519 | 20241107223905_85lji | HR001D | 2024-11-09T14:13:14.729Z | 2024-11-12T14:24:48.350Z |
5503348 | 5503348 | 20241107215007_AxQr1 | HR001D | 2024-11-09T14:12:52.322Z | 2024-11-12T14:24:46.251Z |
5503340 | 5503340 | 20241107214533_IVqyX | HR001D | 2024-11-09T14:12:51.022Z | 2024-11-12T14:24:46.179Z |
5502796 | 5502796 | 20241107194539_nrqqN | HR001D | 2024-11-09T14:12:03.755Z | 2024-11-12T14:24:39.918Z |
5502711 | 5502711 | 20241107193547_cKc22 | HR001D | 2024-11-09T14:11:59.229Z | 2024-11-12T14:24:38.430Z |
5502511 | 5502511 | 20241107185323_vu2aV | HR001D | 2024-11-09T14:11:37.961Z | 2024-11-12T14:24:36.220Z |
5502425 | 5502425 | 20241107182806_aBPfl | HR001D | 2024-11-09T14:11:19.599Z | 2024-11-12T14:24:34.538Z |
5502118 | 5502118 | 20241107172445_HWDXt | HR001D | 2024-11-09T14:10:58.025Z | 2024-11-12T14:24:28.877Z |
5502040 | 5502040 | 20241107165917_p1Fb0 | HR001D | 2024-11-09T14:10:52.006Z | 2024-11-12T14:24:27.545Z |
5497658 | 5497658 | 20241107042018_gps2j | HR001D | 2024-11-08T14:14:08.785Z | 2024-11-12T14:26:13.678Z |
5497589 | 5497589 | 20241107040658_2WeAh | HR001D | 2024-11-08T14:14:00.835Z | 2024-11-12T14:26:12.908Z |
5497129 | 5497129 | 20241107024635_vqRdL | HR001D | 2024-11-08T14:13:13.771Z | 2024-11-12T14:26:09.710Z |
5497005 | 5497005 | 20241107022625_UT1ls | HR001D | 2024-11-08T14:13:02.971Z | 2024-11-12T14:26:08.367Z |
5496694 | 5496694 | 20241107011728_xHji0 | HR001D | 2024-11-08T14:12:43.547Z | 2024-11-12T14:26:06.147Z |
5496353 | 5496353 | 20241107000119_zNwgJ | HR001D | 2024-11-08T14:12:01.456Z | 2024-11-12T14:26:03.594Z |
5496240 | 5496240 | 20241106233508_9P5rm | HR001D | 2024-11-08T14:11:50.107Z | 2024-11-12T14:26:02.866Z |
5496047 | 5496047 | 20241106224547_PU98P | HR001D | 2024-11-08T14:11:26.872Z | 2024-11-12T14:26:01.004Z |
5496007 | 5496007 | 20241106223458_wtUA3 | HR001D | 2024-11-08T14:11:22.834Z | 2024-11-12T14:26:00.571Z |
5495780 | 5495780 | 20241106213342_eE171 | HR001D | 2024-11-08T14:10:51.657Z | 2024-11-12T14:25:57.739Z |
5495737 | 5495737 | 20241106211856_FaoIa | HR001D | 2024-11-08T14:10:44.083Z | 2024-11-12T14:25:57.535Z |
5495730 | 5495730 | 20241106211715_A5les | HR001D | 2024-11-08T14:10:42.922Z | 2024-11-12T14:25:57.527Z |
5495600 | 5495600 | 20241106202927_B28xa | HR001D | 2024-11-08T14:10:27.290Z | 2024-11-12T14:25:55.359Z |
5495168 | 5495168 | 20241106185158_N42pt | HR001D | 2024-11-08T14:09:30.639Z | 2024-11-12T14:25:50.283Z |
5494961 | 5494961 | 20241106180014_810Wo | HR001D | 2024-11-08T14:08:53.315Z | 2024-11-12T14:25:46.430Z |
5491660 | 5491660 | 20241106041841_h7cjs | HR001D | 2024-11-07T14:16:40.145Z | 2024-11-12T14:26:55.576Z |
5491244 | 5491244 | 20241106023620_gfHYS | HR001D | 2024-11-07T14:15:37.471Z | 2024-11-12T14:26:53.673Z |
5490872 | 5490872 | 20241106010139_JzCvr | HR001D | 2024-11-07T14:15:01.634Z | 2024-11-12T14:26:51.812Z |
5490744 | 5490744 | 20241106002723_Ysdvd | HR001D | 2024-11-07T14:14:47.612Z | 2024-11-12T14:26:51.140Z |
5490141 | 5490141 | 20241105212003_YjtAO | HR001D | 2024-11-07T14:13:18.983Z | 2024-11-12T14:26:46.624Z |
5489881 | 5489881 | 20241105202409_n3Pr2 | HR001D | 2024-11-07T14:12:52.669Z | 2024-11-12T14:26:45.274Z |
5489878 | 5489878 | 20241105202405_TXlN5 | HR001D | 2024-11-07T14:12:52.420Z | 2024-11-12T14:26:45.273Z |
5489245 | 5489245 | 20241105181443_aBfjX | HR001D | 2024-11-07T14:11:39.470Z | 2024-11-12T14:26:40.742Z |
5485129 | 5485129 | 20241105040744_Bd8E6 | HR001D | 2024-11-06T14:17:48.758Z | 2024-11-12T14:27:37.031Z |
5484821 | 5484821 | 20241105033157_YnMag | HR001D | 2024-11-06T14:17:20.488Z | 2024-11-12T14:27:35.609Z |
5484620 | 5484620 | 20241105031147_yISXg | HR001D | 2024-11-06T14:17:06.454Z | 2024-11-12T14:27:34.978Z |
5484064 | 5484064 | 20241105020707_OXWDD | HR001D | 2024-11-06T14:16:10.451Z | 2024-11-12T14:27:31.333Z |
5483955 | 5483955 | 20241105014911_0o3SK | HR001D | 2024-11-06T14:15:57.698Z | 2024-11-12T14:27:30.762Z |
5483914 | 5483914 | 20241105014337_6pCVM | HR001D | 2024-11-06T14:15:53.003Z | 2024-11-12T14:27:30.586Z |
5483643 | 5483643 | 20241105011426_dqi12 | HR001D | 2024-11-06T14:15:33.262Z | 2024-11-12T14:27:29.500Z |
5483605 | 5483605 | 20241105010523_yUpfd | HR001D | 2024-11-06T14:15:31.096Z | 2024-11-12T14:27:29.044Z |
5483053 | 5483053 | 20241104235126_cQewt | HR001D | 2024-11-06T14:14:36.738Z | 2024-11-12T14:27:25.460Z |
5482941 | 5482941 | 20241104233706_CHZCc | HR001D | 2024-11-06T14:14:27.109Z | 2024-11-12T14:27:24.765Z |
5482714 | 5482714 | 20241104230629_R0QHf | HR001D | 2024-11-06T14:13:42.198Z | 2024-11-12T14:27:23.912Z |
5482666 | 5482666 | 20241104225801_850vk | HR001D | 2024-11-06T14:13:33.339Z | 2024-11-12T14:27:23.664Z |
5482295 | 5482295 | 20241104214548_4m2Zf | HR001D | 2024-11-06T14:12:52.336Z | 2024-11-12T14:27:21.562Z |
5482060 | 5482060 | 20241104205924_BXhN6 | HR001D | 2024-11-06T14:12:19.494Z | 2024-11-12T14:27:19.505Z |
5481903 | 5481903 | 20241104201422_5RuNU | HR001D | 2024-11-06T14:11:49.136Z | 2024-11-12T14:27:17.948Z |
5481844 | 5481844 | 20241104195755_U2PzX | HR001D | 2024-11-06T14:11:40.901Z | 2024-11-12T14:27:17.509Z |
5481711 | 5481711 | 20241104192015_Wsw4W | HR001D | 2024-11-06T14:11:26.588Z | 2024-11-12T14:27:16.138Z |
5481538 | 5481538 | 20241104181630_KqXq1 | HR001D | 2024-11-06T14:10:46.016Z | 2024-11-12T14:27:14.123Z |
5481512 | 5481512 | 20241104180524_TOuz4 | HR001D | 2024-11-06T14:10:42.447Z | 2024-11-12T14:27:13.995Z |
5478353 | 5478353 | 20241104035527_nL2I2 | HR001D | 2024-11-05T14:18:15.267Z | 2024-11-12T14:28:14.992Z |
5478262 | 5478262 | 20241104034401_5RbjR | HR001D | 2024-11-05T14:18:07.313Z | 2024-11-12T14:28:14.746Z |
5478233 | 5478233 | 20241104034001_K8vh7 | HR001D | 2024-11-05T14:18:05.582Z | 2024-11-12T14:28:14.631Z |
5477975 | 5477975 | 20241104030341_MVKJH | HR001D | 2024-11-05T14:17:41.560Z | 2024-11-12T14:28:13.676Z |
5477140 | 5477140 | 20241104010800_HH1LD | HR001D | 2024-11-05T14:16:26.490Z | 2024-11-12T14:28:09.826Z |
5477132 | 5477132 | 20241104010443_2lRwp | HR001D | 2024-11-05T14:16:25.359Z | 2024-11-12T14:28:09.771Z |
5476502 | 5476502 | 20241103233617_pwr33 | HR001D | 2024-11-05T14:15:31.839Z | 2024-11-12T14:28:06.324Z |
5475865 | 5475865 | 20241103214249_r8djw | HR001D | 2024-11-05T14:14:24.119Z | 2024-11-12T14:28:01.683Z |
5475778 | 5475778 | 20241103212238_Jsgal | HR001D | 2024-11-05T14:14:11.455Z | 2024-11-12T14:28:00.922Z |
5475607 | 5475607 | 20241103204913_D3oW2 | HR001D | 2024-11-05T14:13:52.705Z | 2024-11-12T14:28:00.055Z |
5469621 | 5469621 | 20241103035224_WnpUJ | HR001D | 2024-11-04T14:16:41.122Z | 2024-11-11T14:23:01.733Z |
5469419 | 5469419 | 20241103032424_gN7NQ | HR001D | 2024-11-04T14:16:26.376Z | 2024-11-11T14:23:00.211Z |
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);