participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,019 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 |
---|---|---|---|---|---|
5565843 | 5565843 | 20241121045358_xa9Y3 | HR001D | 2024-11-22T14:01:05.127Z | 2024-11-22T14:01:05.127Z |
5549313 | 5549313 | 20241117041912_ok7Wa | HR001D | 2024-11-18T14:11:26.906Z | 2024-11-22T14:23:20.154Z |
5549213 | 5549213 | 20241117035030_I2ghf | HR001D | 2024-11-18T14:11:17.577Z | 2024-11-22T14:23:19.385Z |
5549039 | 5549039 | 20241117024706_rZAKq | HR001D | 2024-11-18T14:10:44.742Z | 2024-11-22T14:23:17.656Z |
5548949 | 5548949 | 20241117022606_a3w3T | HR001D | 2024-11-18T14:10:32.054Z | 2024-11-22T14:23:17.265Z |
5548836 | 5548836 | 20241117015534_jVrBg | HR001D | 2024-11-18T14:10:18.522Z | 2024-11-22T14:23:16.233Z |
5548725 | 5548725 | 20241117012219_JmCIM | HR001D | 2024-11-18T14:10:05.598Z | 2024-11-22T14:23:15.320Z |
5548454 | 5548454 | 20241116233950_KonA1 | HR001D | 2024-11-18T14:09:15.848Z | 2024-11-22T14:23:13.251Z |
5548420 | 5548420 | 20241116232306_aickF | HR001D | 2024-11-18T14:09:11.034Z | 2024-11-22T14:23:13.019Z |
5548417 | 5548417 | 20241116232159_b5mb4 | HR001D | 2024-11-18T14:09:10.935Z | 2024-11-22T14:23:13.004Z |
5548378 | 5548378 | 20241116230052_2Ejjd | HR001D | 2024-11-18T14:09:01.892Z | 2024-11-22T14:23:12.440Z |
5548203 | 5548203 | 20241116211716_dQnfZ | HR001D | 2024-11-18T14:08:26.831Z | 2024-11-22T14:23:10.949Z |
5548199 | 5548199 | 20241116211230_DcIR3 | HR001D | 2024-11-18T14:08:26.352Z | 2024-11-22T14:23:10.920Z |
5548126 | 5548126 | 20241116195910_YS5AH | HR001D | 2024-11-18T14:08:17.504Z | 2024-11-22T14:23:10.161Z |
5545291 | 5545291 | 20241116040256_0WB7y | HR001D | 2024-11-17T14:04:24.385Z | 2024-11-22T14:23:39.499Z |
5545111 | 5545111 | 20241116002541_vltwT | HR001D | 2024-11-17T14:03:48.910Z | 2024-11-22T14:23:36.175Z |
5545055 | 5545055 | 20241115225926_RilBm | HR001D | 2024-11-17T14:03:41.759Z | 2024-11-22T14:23:35.623Z |
5544933 | 5544933 | 20241115173412_YF9S1 | HR001D | 2024-11-17T14:03:21.614Z | 2024-11-22T14:23:33.154Z |
5543657 | 5543657 | 20241115024318_pNNqS | HR001D | 2024-11-16T14:06:58.637Z | 2024-11-22T14:24:00.581Z |
5543492 | 5543492 | 20241115014540_DPh7g | HR001D | 2024-11-16T14:06:31.597Z | 2024-11-22T14:23:59.712Z |
5543380 | 5543380 | 20241115004831_6Oee0 | HR001D | 2024-11-16T14:06:11.924Z | 2024-11-22T14:23:58.478Z |
5543329 | 5543329 | 20241115001523_RwDG2 | HR001D | 2024-11-16T14:06:06.153Z | 2024-11-22T14:23:58.252Z |
5543317 | 5543317 | 20241115000828_gCSxK | HR001D | 2024-11-16T14:06:05.307Z | 2024-11-22T14:23:58.170Z |
5543291 | 5543291 | 20241114235234_fAwo3 | HR001D | 2024-11-16T14:06:00.961Z | 2024-11-22T14:23:57.978Z |
5543253 | 5543253 | 20241114232702_YtLIx | HR001D | 2024-11-16T14:05:50.634Z | 2024-11-22T14:23:57.747Z |
5538174 | 5538174 | 20241113022908_BZ3qX | HR001D | 2024-11-14T14:13:00.456Z | 2024-11-21T14:26:21.284Z |
5537929 | 5537929 | 20241113013326_fYQJt | HR001D | 2024-11-14T14:12:38.312Z | 2024-11-21T14:26:17.336Z |
5537833 | 5537833 | 20241113005332_lOhNx | HR001D | 2024-11-14T14:12:32.218Z | 2024-11-21T14:26:16.400Z |
5537761 | 5537761 | 20241113002844_HIxd3 | HR001D | 2024-11-14T14:12:28.804Z | 2024-11-21T14:26:15.845Z |
5537563 | 5537563 | 20241112234004_AgRr3 | HR001D | 2024-11-14T14:12:10.282Z | 2024-11-21T14:26:14.240Z |
5537529 | 5537529 | 20241112233143_i9w94 | HR001D | 2024-11-14T14:12:04.275Z | 2024-11-21T14:26:14.019Z |
5537478 | 5537478 | 20241112231800_MuruX | HR001D | 2024-11-14T14:11:55.123Z | 2024-11-21T14:26:13.387Z |
5537406 | 5537406 | 20241112224235_9PGLF | HR001D | 2024-11-14T14:11:45.179Z | 2024-11-21T14:26:12.705Z |
5537292 | 5537292 | 20241112215555_KSzXW | HR001D | 2024-11-14T14:11:31.577Z | 2024-11-21T14:26:10.851Z |
5537266 | 5537266 | 20241112214318_QPpTF | HR001D | 2024-11-14T14:11:29.201Z | 2024-11-21T14:26:10.739Z |
5537228 | 5537228 | 20241112211424_suLAi | HR001D | 2024-11-14T14:11:21.740Z | 2024-11-21T14:26:10.094Z |
5537145 | 5537145 | 20241112203543_lL3KK | HR001D | 2024-11-14T14:11:07.747Z | 2024-11-21T14:26:09.224Z |
5537114 | 5537114 | 20241112202925_YT2oC | HR001D | 2024-11-14T14:11:03.842Z | 2024-11-21T14:26:08.933Z |
5536803 | 5536803 | 20241112191416_KLi0U | HR001D | 2024-11-14T14:10:33.993Z | 2024-11-21T14:26:05.811Z |
5536787 | 5536787 | 20241112190814_JO2Qu | HR001D | 2024-11-14T14:10:33.120Z | 2024-11-21T14:26:05.476Z |
5536618 | 5536618 | 20241112184000_PhAVp | HR001D | 2024-11-14T14:10:24.172Z | 2024-11-21T14:26:03.677Z |
5536614 | 5536614 | 20241112183931_uFr3w | HR001D | 2024-11-14T14:10:23.665Z | 2024-11-21T14:26:03.598Z |
5532243 | 5532243 | 20241112045530_HwRUE | HR001D | 2024-11-13T14:16:30.602Z | 2024-11-20T14:26:21.300Z |
5532074 | 5532074 | 20241112043446_wN31Y | HR001D | 2024-11-13T14:16:15.742Z | 2024-11-20T14:26:18.383Z |
5531726 | 5531726 | 20241112040516_fxJAX | HR001D | 2024-11-13T14:15:52.753Z | 2024-11-20T14:26:13.704Z |
5531645 | 5531645 | 20241112035634_LdBoE | HR001D | 2024-11-13T14:15:48.334Z | 2024-11-20T14:26:12.961Z |
5530950 | 5530950 | 20241112030135_H4q7T | HR001D | 2024-11-13T14:14:54.068Z | 2024-11-20T14:26:05.612Z |
5529845 | 5529845 | 20241112011006_LZBJv | HR001D | 2024-11-13T14:13:14.936Z | 2024-11-20T14:25:49.919Z |
5529162 | 5529162 | 20241111233950_6qsYR | HR001D | 2024-11-13T14:12:09.842Z | 2024-11-20T14:25:40.868Z |
5529146 | 5529146 | 20241111233632_Ga6Ng | HR001D | 2024-11-13T14:12:08.758Z | 2024-11-20T14:25:40.636Z |
5529079 | 5529079 | 20241111232650_yIOSX | HR001D | 2024-11-13T14:12:03.360Z | 2024-11-20T14:25:39.508Z |
5528823 | 5528823 | 20241111224709_OGHCa | HR001D | 2024-11-13T14:11:28.564Z | 2024-11-20T14:25:36.308Z |
5528749 | 5528749 | 20241111223100_F6Ve4 | HR001D | 2024-11-13T14:11:22.621Z | 2024-11-20T14:25:34.857Z |
5528271 | 5528271 | 20241111200810_h38qT | HR001D | 2024-11-13T14:10:21.835Z | 2024-11-20T14:25:27.620Z |
5528253 | 5528253 | 20241111200409_RbTgn | HR001D | 2024-11-13T14:10:20.283Z | 2024-11-20T14:25:27.358Z |
5528098 | 5528098 | 20241111193159_3G2Cd | HR001D | 2024-11-13T14:09:50.065Z | 2024-11-20T14:25:24.971Z |
5528035 | 5528035 | 20241111191921_gdLDR | HR001D | 2024-11-13T14:09:43.888Z | 2024-11-20T14:25:24.448Z |
5527553 | 5527553 | 20241111173536_idbcv | HR001D | 2024-11-13T14:08:38.940Z | 2024-11-20T14:25:13.761Z |
5527551 | 5527551 | 20241111173441_KPWHR | HR001D | 2024-11-13T14:08:38.513Z | 2024-11-20T14:25:13.560Z |
5527442 | 5527442 | 20241111164044_p3bf9 | HR001D | 2024-11-13T14:08:14.861Z | 2024-11-20T14:25:11.256Z |
5524566 | 5524566 | 20241111043648_6Y9R8 | HR001D | 2024-11-12T14:17:41.179Z | 2024-11-19T14:22:22.271Z |
5522950 | 5522950 | 20241110231544_TzqJq | HR001D | 2024-11-12T14:14:33.092Z | 2024-11-19T14:22:09.115Z |
5522923 | 5522923 | 20241110225924_2ZthX | HR001D | 2024-11-12T14:14:30.013Z | 2024-11-19T14:22:08.908Z |
5522852 | 5522852 | 20241110222134_x3sGv | HR001D | 2024-11-12T14:14:24.229Z | 2024-11-19T14:22:07.958Z |
5522837 | 5522837 | 20241110221641_rDfeB | HR001D | 2024-11-12T14:14:22.962Z | 2024-11-19T14:22:07.672Z |
5522408 | 5522408 | 20241110195702_i6bis | HR001D | 2024-11-12T14:13:12.476Z | 2024-11-19T14:22:01.778Z |
5522344 | 5522344 | 20241110194822_3NBP2 | HR001D | 2024-11-12T14:13:06.391Z | 2024-11-19T14:22:00.722Z |
5521540 | 5521540 | 20241110172742_4CoY3 | HR001D | 2024-11-12T14:11:30.956Z | 2024-11-19T14:21:53.369Z |
5521495 | 5521495 | 20241110172213_54aZ4 | HR001D | 2024-11-12T14:11:18.620Z | 2024-11-19T14:21:53.167Z |
5521344 | 5521344 | 20241110165355_KV3Wk | HR001D | 2024-11-12T14:10:52.192Z | 2024-11-19T14:21:52.154Z |
5517690 | 5517690 | 20241110043039_oRx62 | HR001D | 2024-11-11T14:14:45.064Z | 2024-11-18T14:26:37.837Z |
5517611 | 5517611 | 20241110041139_Kb3va | HR001D | 2024-11-11T14:14:39.942Z | 2024-11-18T14:26:37.379Z |
5517468 | 5517468 | 20241110034656_3D5bO | HR001D | 2024-11-11T14:14:26.862Z | 2024-11-18T14:26:36.547Z |
5517340 | 5517340 | 20241110032819_5BZ7t | HR001D | 2024-11-11T14:14:16.645Z | 2024-11-18T14:26:35.997Z |
5517222 | 5517222 | 20241110030700_fCgpf | HR001D | 2024-11-11T14:14:06.863Z | 2024-11-18T14:26:35.423Z |
5517066 | 5517066 | 20241110024221_mXuIe | HR001D | 2024-11-11T14:13:49.640Z | 2024-11-18T14:26:34.499Z |
5516654 | 5516654 | 20241110013418_OBpGQ | HR001D | 2024-11-11T14:13:13.357Z | 2024-11-18T14:26:32.627Z |
5516327 | 5516327 | 20241110004039_BTezr | HR001D | 2024-11-11T14:12:44.427Z | 2024-11-18T14:26:30.694Z |
5516206 | 5516206 | 20241110001315_5ffdi | HR001D | 2024-11-11T14:12:27.288Z | 2024-11-18T14:26:30.082Z |
5516009 | 5516009 | 20241109233343_Dtzmr | HR001D | 2024-11-11T14:11:58.275Z | 2024-11-18T14:26:28.919Z |
5515964 | 5515964 | 20241109232027_8AI2a | HR001D | 2024-11-11T14:11:51.127Z | 2024-11-18T14:26:28.662Z |
5515850 | 5515850 | 20241109225749_QYzhw | HR001D | 2024-11-11T14:11:37.246Z | 2024-11-18T14:26:28.187Z |
5515476 | 5515476 | 20241109213336_hW0rU | HR001D | 2024-11-11T14:11:07.147Z | 2024-11-18T14:26:26.211Z |
5515308 | 5515308 | 20241109202923_EVZhr | HR001D | 2024-11-11T14:10:41.006Z | 2024-11-18T14:26:25.422Z |
5515304 | 5515304 | 20241109202459_fKnJr | HR001D | 2024-11-11T14:10:39.999Z | 2024-11-18T14:26:25.370Z |
5515055 | 5515055 | 20241109191222_gUZIX | HR001D | 2024-11-11T14:09:57.971Z | 2024-11-18T14:26:24.050Z |
5514983 | 5514983 | 20241109184739_JbXkv | HR001D | 2024-11-11T14:09:50.979Z | 2024-11-18T14:26:23.690Z |
5511078 | 5511078 | 20241109041946_ETKXQ | HR001D | 2024-11-10T14:16:12.270Z | 2024-11-17T14:24:04.334Z |
5509589 | 5509589 | 20241108235147_cEGoc | HR001D | 2024-11-10T14:13:37.658Z | 2024-11-17T14:23:47.467Z |
5508953 | 5508953 | 20241108205935_HFUFz | HR001D | 2024-11-10T14:12:09.258Z | 2024-11-17T14:23:37.923Z |
5508905 | 5508905 | 20241108203547_tD3Tv | HR001D | 2024-11-10T14:12:01.629Z | 2024-11-17T14:23:36.257Z |
5508684 | 5508684 | 20241108174229_27se6 | HR001D | 2024-11-10T14:11:10.962Z | 2024-11-17T14:23:28.933Z |
5504388 | 5504388 | 20241108015132_2nhZI | HR001D | 2024-11-09T14:14:30.680Z | 2024-11-16T14:28:19.465Z |
5504021 | 5504021 | 20241108003952_fPmzm | HR001D | 2024-11-09T14:13:58.904Z | 2024-11-16T14:28:15.024Z |
5503973 | 5503973 | 20241108002928_nL3ns | HR001D | 2024-11-09T14:13:55.737Z | 2024-11-16T14:28:14.528Z |
5503836 | 5503836 | 20241107235559_WjGod | HR001D | 2024-11-09T14:13:47.126Z | 2024-11-16T14:28:12.941Z |
5503582 | 5503582 | 20241107225726_dZhwG | HR001D | 2024-11-09T14:13:19.871Z | 2024-11-16T14:28:09.158Z |
5503519 | 5503519 | 20241107223905_85lji | HR001D | 2024-11-09T14:13:14.729Z | 2024-11-16T14:28:08.409Z |
5503348 | 5503348 | 20241107215007_AxQr1 | HR001D | 2024-11-09T14:12:52.322Z | 2024-11-16T14:28:06.461Z |
5503340 | 5503340 | 20241107214533_IVqyX | HR001D | 2024-11-09T14:12:51.022Z | 2024-11-16T14:28:06.201Z |
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);