participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,922 rows where station_code = "HU0003" 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 |
---|---|---|---|---|---|
5573245 | 5573245 | 20241121041303_xXEai | HU0003 | 2024-11-22T14:19:17.956Z | 2024-11-22T14:19:22.476Z |
5572996 | 5572996 | 20241121033650_RofFu | HU0003 | 2024-11-22T14:19:02.819Z | 2024-11-22T14:19:22.429Z |
5572827 | 5572827 | 20241121031358_jSyOp | HU0003 | 2024-11-22T14:18:51.730Z | 2024-11-22T14:19:22.397Z |
5572675 | 5572675 | 20241121025550_LUCDy | HU0003 | 2024-11-22T14:18:42.144Z | 2024-11-22T14:19:22.372Z |
5572545 | 5572545 | 20241121023516_f3eIn | HU0003 | 2024-11-22T14:18:35.166Z | 2024-11-22T14:19:22.349Z |
5572266 | 5572266 | 20241121020113_HjzVz | HU0003 | 2024-11-22T14:18:09.060Z | 2024-11-22T14:19:22.292Z |
5572006 | 5572006 | 20241121011834_a2U5b | HU0003 | 2024-11-22T14:17:51.862Z | 2024-11-22T14:19:22.240Z |
5571960 | 5571960 | 20241121011317_vwpVR | HU0003 | 2024-11-22T14:17:49.609Z | 2024-11-22T14:19:22.232Z |
5571757 | 5571757 | 20241121004115_g2jrp | HU0003 | 2024-11-22T14:17:37.842Z | 2024-11-22T14:19:22.187Z |
5571745 | 5571745 | 20241121004005_eYeMH | HU0003 | 2024-11-22T14:17:37.144Z | 2024-11-22T14:19:22.185Z |
5571516 | 5571516 | 20241121000025_elBwz | HU0003 | 2024-11-22T14:17:13.112Z | 2024-11-22T14:19:22.140Z |
5565638 | 5565638 | 20241121042957_K8k5I | HU0003 | 2024-11-22T14:00:29.410Z | 2024-11-22T14:00:29.410Z |
5565627 | 5565627 | 20241121042712_DJrJV | HU0003 | 2024-11-22T14:00:27.419Z | 2024-11-22T14:00:27.419Z |
5562615 | 5562615 | 20241119235648_xkfdl | HU0003 | 2024-11-21T14:15:13.801Z | 2024-11-22T14:21:00.945Z |
5561311 | 5561311 | 20241119194655_B9R2n | HU0003 | 2024-11-21T14:13:03.911Z | 2024-11-22T14:20:31.722Z |
5561303 | 5561303 | 20241119193944_vUVfR | HU0003 | 2024-11-21T14:13:02.750Z | 2024-11-22T14:20:30.397Z |
5549320 | 5549320 | 20241117042121_6AGEL | HU0003 | 2024-11-18T14:11:27.638Z | 2024-11-22T14:23:20.215Z |
5548954 | 5548954 | 20241117022801_2OjYU | HU0003 | 2024-11-18T14:10:32.587Z | 2024-11-22T14:23:17.273Z |
5548627 | 5548627 | 20241117004048_Pbj5t | HU0003 | 2024-11-18T14:09:38.941Z | 2024-11-22T14:23:14.743Z |
5548600 | 5548600 | 20241117003008_hUbI6 | HU0003 | 2024-11-18T14:09:33.719Z | 2024-11-22T14:23:14.530Z |
5548072 | 5548072 | 20241116190641_S0XrP | HU0003 | 2024-11-18T14:07:59.401Z | 2024-11-22T14:23:09.041Z |
5548018 | 5548018 | 20241116180228_ewzAc | HU0003 | 2024-11-18T14:07:47.488Z | 2024-11-22T14:23:07.720Z |
5545261 | 5545261 | 20241116033318_Ifuo0 | HU0003 | 2024-11-17T14:04:20.961Z | 2024-11-22T14:23:39.291Z |
5545233 | 5545233 | 20241116031016_27pEX | HU0003 | 2024-11-17T14:04:17.040Z | 2024-11-22T14:23:37.815Z |
5545221 | 5545221 | 20241116025342_D0bYM | HU0003 | 2024-11-17T14:04:11.155Z | 2024-11-22T14:23:37.695Z |
5545134 | 5545134 | 20241116011145_73la7 | HU0003 | 2024-11-17T14:03:52.504Z | 2024-11-22T14:23:36.266Z |
5515447 | 5515447 | 20241109212627_DmNnq | HU0003 | 2024-11-11T14:11:05.331Z | 2024-11-18T14:26:26.096Z |
5515362 | 5515362 | 20241109205739_g4NED | HU0003 | 2024-11-11T14:10:50.697Z | 2024-11-18T14:26:25.725Z |
5515338 | 5515338 | 20241109203825_LUnLS | HU0003 | 2024-11-11T14:10:47.343Z | 2024-11-18T14:26:25.614Z |
5515316 | 5515316 | 20241109203017_nw2Sa | HU0003 | 2024-11-11T14:10:42.297Z | 2024-11-18T14:26:25.465Z |
5515168 | 5515168 | 20241109194557_Bapk3 | HU0003 | 2024-11-11T14:10:13.576Z | 2024-11-18T14:26:24.600Z |
5515127 | 5515127 | 20241109193033_vRYBD | HU0003 | 2024-11-11T14:10:07.288Z | 2024-11-18T14:26:24.418Z |
5514741 | 5514741 | 20241109171729_Mmk8s | HU0003 | 2024-11-11T14:09:05.986Z | 2024-11-18T14:26:22.205Z |
5511117 | 5511117 | 20241109043326_giihu | HU0003 | 2024-11-10T14:16:17.307Z | 2024-11-17T14:24:04.859Z |
5510993 | 5510993 | 20241109040443_8DYdg | HU0003 | 2024-11-10T14:16:01.784Z | 2024-11-17T14:24:03.169Z |
5510953 | 5510953 | 20241109035955_46Pbj | HU0003 | 2024-11-10T14:15:59.063Z | 2024-11-17T14:24:02.887Z |
5510727 | 5510727 | 20241109032944_6obV3 | HU0003 | 2024-11-10T14:15:36.267Z | 2024-11-17T14:24:00.662Z |
5510594 | 5510594 | 20241109030748_IW9nh | HU0003 | 2024-11-10T14:15:28.575Z | 2024-11-17T14:23:59.565Z |
5510588 | 5510588 | 20241109030510_fwxs9 | HU0003 | 2024-11-10T14:15:28.374Z | 2024-11-17T14:23:59.543Z |
5510539 | 5510539 | 20241109025612_ukCch | HU0003 | 2024-11-10T14:15:25.496Z | 2024-11-17T14:23:58.814Z |
5510460 | 5510460 | 20241109024349_oYPSg | HU0003 | 2024-11-10T14:15:17.655Z | 2024-11-17T14:23:58.018Z |
5510436 | 5510436 | 20241109024106_k7XtY | HU0003 | 2024-11-10T14:15:13.920Z | 2024-11-17T14:23:57.419Z |
5510422 | 5510422 | 20241109023859_CNtSH | HU0003 | 2024-11-10T14:15:12.231Z | 2024-11-17T14:23:57.335Z |
5510272 | 5510272 | 20241109021438_uluhf | HU0003 | 2024-11-10T14:14:55.589Z | 2024-11-17T14:23:55.548Z |
5510209 | 5510209 | 20241109015850_5qdS9 | HU0003 | 2024-11-10T14:14:47.687Z | 2024-11-17T14:23:54.050Z |
5510148 | 5510148 | 20241109015019_oOeyu | HU0003 | 2024-11-10T14:14:40.177Z | 2024-11-17T14:23:53.282Z |
5510100 | 5510100 | 20241109014320_Z6eRj | HU0003 | 2024-11-10T14:14:35.141Z | 2024-11-17T14:23:52.894Z |
5510094 | 5510094 | 20241109014245_CKKGo | HU0003 | 2024-11-10T14:14:34.889Z | 2024-11-17T14:23:52.893Z |
5509981 | 5509981 | 20241109012229_bZVGf | HU0003 | 2024-11-10T14:14:21.855Z | 2024-11-17T14:23:51.513Z |
5509966 | 5509966 | 20241109011808_vpdJO | HU0003 | 2024-11-10T14:14:20.155Z | 2024-11-17T14:23:51.414Z |
5509804 | 5509804 | 20241109004047_QM1GE | HU0003 | 2024-11-10T14:14:02.472Z | 2024-11-17T14:23:49.469Z |
5509498 | 5509498 | 20241108233255_y5zge | HU0003 | 2024-11-10T14:13:28.130Z | 2024-11-17T14:23:46.230Z |
5509316 | 5509316 | 20241108225054_MXFiK | HU0003 | 2024-11-10T14:13:11.810Z | 2024-11-17T14:23:43.023Z |
5509289 | 5509289 | 20241108224644_epH2B | HU0003 | 2024-11-10T14:13:09.495Z | 2024-11-17T14:23:42.649Z |
5509284 | 5509284 | 20241108224340_AP8wp | HU0003 | 2024-11-10T14:13:08.826Z | 2024-11-17T14:23:42.416Z |
5509143 | 5509143 | 20241108220456_Efsyu | HU0003 | 2024-11-10T14:12:40.478Z | 2024-11-17T14:23:40.982Z |
5509127 | 5509127 | 20241108215859_imrJt | HU0003 | 2024-11-10T14:12:35.927Z | 2024-11-17T14:23:40.619Z |
5509094 | 5509094 | 20241108214658_LNzZG | HU0003 | 2024-11-10T14:12:32.943Z | 2024-11-17T14:23:40.239Z |
5508997 | 5508997 | 20241108210847_Kc8B2 | HU0003 | 2024-11-10T14:12:16.230Z | 2024-11-17T14:23:39.182Z |
5508991 | 5508991 | 20241108210721_kwxMK | HU0003 | 2024-11-10T14:12:14.149Z | 2024-11-17T14:23:38.965Z |
5508951 | 5508951 | 20241108205843_B12AJ | HU0003 | 2024-11-10T14:12:09.055Z | 2024-11-17T14:23:37.917Z |
5508925 | 5508925 | 20241108205022_WlISD | HU0003 | 2024-11-10T14:12:05.157Z | 2024-11-17T14:23:37.186Z |
5508792 | 5508792 | 20241108192549_WIj3E | HU0003 | 2024-11-10T14:11:49.125Z | 2024-11-17T14:23:33.745Z |
5508742 | 5508742 | 20241108183610_VtbrI | HU0003 | 2024-11-10T14:11:34.698Z | 2024-11-17T14:23:31.569Z |
5505324 | 5505324 | 20241108043735_sGTod | HU0003 | 2024-11-09T14:16:09.934Z | 2024-11-16T14:28:30.061Z |
5505159 | 5505159 | 20241108040117_2xvfY | HU0003 | 2024-11-09T14:15:51.877Z | 2024-11-16T14:28:28.256Z |
5505048 | 5505048 | 20241108034500_F4xAy | HU0003 | 2024-11-09T14:15:38.857Z | 2024-11-16T14:28:25.865Z |
5504978 | 5504978 | 20241108032802_73gEA | HU0003 | 2024-11-09T14:15:31.098Z | 2024-11-16T14:28:25.390Z |
5504965 | 5504965 | 20241108032632_cJpve | HU0003 | 2024-11-09T14:15:29.331Z | 2024-11-16T14:28:25.194Z |
5504956 | 5504956 | 20241108032539_r0J0B | HU0003 | 2024-11-09T14:15:27.871Z | 2024-11-16T14:28:25.155Z |
5504763 | 5504763 | 20241108025335_HISXJ | HU0003 | 2024-11-09T14:15:09.726Z | 2024-11-16T14:28:23.327Z |
5504554 | 5504554 | 20241108021435_hzFlK | HU0003 | 2024-11-09T14:14:50.595Z | 2024-11-16T14:28:21.363Z |
5504543 | 5504543 | 20241108021354_yB7Sh | HU0003 | 2024-11-09T14:14:49.780Z | 2024-11-16T14:28:21.289Z |
5503960 | 5503960 | 20241108002626_hGmQ0 | HU0003 | 2024-11-09T14:13:54.938Z | 2024-11-16T14:28:14.383Z |
5503928 | 5503928 | 20241108001506_1ZaXL | HU0003 | 2024-11-09T14:13:51.767Z | 2024-11-16T14:28:13.832Z |
5503878 | 5503878 | 20241108000531_a1euc | HU0003 | 2024-11-09T14:13:49.195Z | 2024-11-16T14:28:13.462Z |
5503833 | 5503833 | 20241107235555_sHG7N | HU0003 | 2024-11-09T14:13:46.986Z | 2024-11-16T14:28:12.891Z |
5503789 | 5503789 | 20241107234828_GwPZI | HU0003 | 2024-11-09T14:13:44.332Z | 2024-11-16T14:28:12.570Z |
5503375 | 5503375 | 20241107220001_9Xc20 | HU0003 | 2024-11-09T14:12:56.214Z | 2024-11-16T14:28:06.879Z |
5503290 | 5503290 | 20241107212701_fbIR8 | HU0003 | 2024-11-09T14:12:44.706Z | 2024-11-16T14:28:05.727Z |
5503263 | 5503263 | 20241107211306_ewKFk | HU0003 | 2024-11-09T14:12:40.937Z | 2024-11-16T14:28:05.141Z |
5503194 | 5503194 | 20241107205744_Ma3TX | HU0003 | 2024-11-09T14:12:32.560Z | 2024-11-16T14:28:04.280Z |
5503039 | 5503039 | 20241107203109_NmQ9E | HU0003 | 2024-11-09T14:12:21.033Z | 2024-11-16T14:28:01.996Z |
5502428 | 5502428 | 20241107182934_Qnh1o | HU0003 | 2024-11-09T14:11:20.115Z | 2024-11-16T14:27:55.534Z |
5502345 | 5502345 | 20241107180921_u9vt3 | HU0003 | 2024-11-09T14:11:12.215Z | 2024-11-16T14:27:54.153Z |
5502052 | 5502052 | 20241107170033_IEi2n | HU0003 | 2024-11-09T14:10:52.423Z | 2024-11-16T14:27:49.758Z |
5502038 | 5502038 | 20241107165858_10U92 | HU0003 | 2024-11-09T14:10:51.528Z | 2024-11-16T14:27:49.586Z |
5497630 | 5497630 | 20241107041526_9esUk | HU0003 | 2024-11-08T14:14:05.635Z | 2024-11-15T14:25:05.140Z |
5497620 | 5497620 | 20241107041303_mDas1 | HU0003 | 2024-11-08T14:14:04.823Z | 2024-11-15T14:25:05.104Z |
5497610 | 5497610 | 20241107041103_h2mJT | HU0003 | 2024-11-08T14:14:02.715Z | 2024-11-15T14:25:05.064Z |
5497514 | 5497514 | 20241107035250_ra8bX | HU0003 | 2024-11-08T14:13:55.353Z | 2024-11-15T14:25:04.464Z |
5497468 | 5497468 | 20241107034538_wFgWT | HU0003 | 2024-11-08T14:13:49.960Z | 2024-11-15T14:25:04.172Z |
5497458 | 5497458 | 20241107034338_3VNtu | HU0003 | 2024-11-08T14:13:48.230Z | 2024-11-15T14:25:04.137Z |
5497362 | 5497362 | 20241107032816_dMxhh | HU0003 | 2024-11-08T14:13:37.918Z | 2024-11-15T14:25:03.188Z |
5497343 | 5497343 | 20241107032518_EMzgD | HU0003 | 2024-11-08T14:13:35.750Z | 2024-11-15T14:25:02.980Z |
5497296 | 5497296 | 20241107031527_lOC7J | HU0003 | 2024-11-08T14:13:30.567Z | 2024-11-15T14:25:02.725Z |
5497225 | 5497225 | 20241107030004_Wqyi3 | HU0003 | 2024-11-08T14:13:22.849Z | 2024-11-15T14:25:02.165Z |
5497220 | 5497220 | 20241107025913_6D9VU | HU0003 | 2024-11-08T14:13:22.485Z | 2024-11-15T14:25:02.134Z |
5497151 | 5497151 | 20241107024934_M9hly | HU0003 | 2024-11-08T14:13:16.187Z | 2024-11-15T14:25:01.962Z |
5497139 | 5497139 | 20241107024859_tunhA | HU0003 | 2024-11-08T14:13:14.919Z | 2024-11-15T14:25:01.918Z |
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);