participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,858 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 |
---|---|---|---|---|---|
5505324 | 5505324 | 20241108043735_sGTod | HU0003 | 2024-11-09T14:16:09.934Z | 2024-11-09T14:16:28.755Z |
5505159 | 5505159 | 20241108040117_2xvfY | HU0003 | 2024-11-09T14:15:51.877Z | 2024-11-09T14:16:28.714Z |
5505048 | 5505048 | 20241108034500_F4xAy | HU0003 | 2024-11-09T14:15:38.857Z | 2024-11-09T14:16:28.688Z |
5504978 | 5504978 | 20241108032802_73gEA | HU0003 | 2024-11-09T14:15:31.098Z | 2024-11-09T14:16:28.671Z |
5504965 | 5504965 | 20241108032632_cJpve | HU0003 | 2024-11-09T14:15:29.331Z | 2024-11-09T14:16:28.668Z |
5504956 | 5504956 | 20241108032539_r0J0B | HU0003 | 2024-11-09T14:15:27.871Z | 2024-11-09T14:16:28.666Z |
5504763 | 5504763 | 20241108025335_HISXJ | HU0003 | 2024-11-09T14:15:09.726Z | 2024-11-09T14:16:28.619Z |
5504554 | 5504554 | 20241108021435_hzFlK | HU0003 | 2024-11-09T14:14:50.595Z | 2024-11-09T14:16:28.568Z |
5504543 | 5504543 | 20241108021354_yB7Sh | HU0003 | 2024-11-09T14:14:49.780Z | 2024-11-09T14:16:28.565Z |
5503960 | 5503960 | 20241108002626_hGmQ0 | HU0003 | 2024-11-09T14:13:54.938Z | 2024-11-09T14:16:28.411Z |
5503928 | 5503928 | 20241108001506_1ZaXL | HU0003 | 2024-11-09T14:13:51.767Z | 2024-11-09T14:16:28.399Z |
5503878 | 5503878 | 20241108000531_a1euc | HU0003 | 2024-11-09T14:13:49.195Z | 2024-11-09T14:16:28.378Z |
5503833 | 5503833 | 20241107235555_sHG7N | HU0003 | 2024-11-09T14:13:46.986Z | 2024-11-09T14:16:28.361Z |
5503789 | 5503789 | 20241107234828_GwPZI | HU0003 | 2024-11-09T14:13:44.332Z | 2024-11-09T14:16:28.347Z |
5503375 | 5503375 | 20241107220001_9Xc20 | HU0003 | 2024-11-09T14:12:56.214Z | 2024-11-09T14:16:28.234Z |
5503290 | 5503290 | 20241107212701_fbIR8 | HU0003 | 2024-11-09T14:12:44.706Z | 2024-11-09T14:16:28.209Z |
5503263 | 5503263 | 20241107211306_ewKFk | HU0003 | 2024-11-09T14:12:40.937Z | 2024-11-09T14:16:28.203Z |
5503194 | 5503194 | 20241107205744_Ma3TX | HU0003 | 2024-11-09T14:12:32.560Z | 2024-11-09T14:16:28.187Z |
5503039 | 5503039 | 20241107203109_NmQ9E | HU0003 | 2024-11-09T14:12:21.033Z | 2024-11-09T14:16:28.152Z |
5502428 | 5502428 | 20241107182934_Qnh1o | HU0003 | 2024-11-09T14:11:20.115Z | 2024-11-09T14:16:28.026Z |
5502345 | 5502345 | 20241107180921_u9vt3 | HU0003 | 2024-11-09T14:11:12.215Z | 2024-11-09T14:16:28.008Z |
5502052 | 5502052 | 20241107170033_IEi2n | HU0003 | 2024-11-09T14:10:52.423Z | 2024-11-09T14:16:27.929Z |
5502038 | 5502038 | 20241107165858_10U92 | HU0003 | 2024-11-09T14:10:51.528Z | 2024-11-09T14:16:27.925Z |
5497630 | 5497630 | 20241107041526_9esUk | HU0003 | 2024-11-08T14:14:05.635Z | 2024-11-09T14:18:48.272Z |
5497620 | 5497620 | 20241107041303_mDas1 | HU0003 | 2024-11-08T14:14:04.823Z | 2024-11-09T14:18:47.843Z |
5497610 | 5497610 | 20241107041103_h2mJT | HU0003 | 2024-11-08T14:14:02.715Z | 2024-11-09T14:18:47.462Z |
5497514 | 5497514 | 20241107035250_ra8bX | HU0003 | 2024-11-08T14:13:55.353Z | 2024-11-09T14:18:45.086Z |
5497468 | 5497468 | 20241107034538_wFgWT | HU0003 | 2024-11-08T14:13:49.960Z | 2024-11-09T14:18:43.991Z |
5497458 | 5497458 | 20241107034338_3VNtu | HU0003 | 2024-11-08T14:13:48.230Z | 2024-11-09T14:18:43.559Z |
5497362 | 5497362 | 20241107032816_dMxhh | HU0003 | 2024-11-08T14:13:37.918Z | 2024-11-09T14:18:41.623Z |
5497343 | 5497343 | 20241107032518_EMzgD | HU0003 | 2024-11-08T14:13:35.750Z | 2024-11-09T14:18:41.130Z |
5497296 | 5497296 | 20241107031527_lOC7J | HU0003 | 2024-11-08T14:13:30.567Z | 2024-11-09T14:18:40.192Z |
5497225 | 5497225 | 20241107030004_Wqyi3 | HU0003 | 2024-11-08T14:13:22.849Z | 2024-11-09T14:18:37.567Z |
5497220 | 5497220 | 20241107025913_6D9VU | HU0003 | 2024-11-08T14:13:22.485Z | 2024-11-09T14:18:37.480Z |
5497151 | 5497151 | 20241107024934_M9hly | HU0003 | 2024-11-08T14:13:16.187Z | 2024-11-09T14:18:36.123Z |
5497139 | 5497139 | 20241107024859_tunhA | HU0003 | 2024-11-08T14:13:14.919Z | 2024-11-09T14:18:35.924Z |
5497056 | 5497056 | 20241107023521_dfy4K | HU0003 | 2024-11-08T14:13:07.523Z | 2024-11-09T14:18:34.813Z |
5496993 | 5496993 | 20241107022428_vCWkG | HU0003 | 2024-11-08T14:13:02.334Z | 2024-11-09T14:18:33.995Z |
5496949 | 5496949 | 20241107021457_nwkhi | HU0003 | 2024-11-08T14:13:00.508Z | 2024-11-09T14:18:33.515Z |
5496727 | 5496727 | 20241107012611_s5x87 | HU0003 | 2024-11-08T14:12:48.264Z | 2024-11-09T14:18:29.140Z |
5496685 | 5496685 | 20241107011553_M87cu | HU0003 | 2024-11-08T14:12:41.175Z | 2024-11-09T14:18:27.551Z |
5496578 | 5496578 | 20241107005552_evIbs | HU0003 | 2024-11-08T14:12:27.505Z | 2024-11-09T14:18:25.724Z |
5496435 | 5496435 | 20241107002508_F6ikb | HU0003 | 2024-11-08T14:12:09.635Z | 2024-11-09T14:18:22.251Z |
5496427 | 5496427 | 20241107002202_YphTv | HU0003 | 2024-11-08T14:12:08.935Z | 2024-11-09T14:18:22.124Z |
5496265 | 5496265 | 20241106234147_R4SVH | HU0003 | 2024-11-08T14:11:52.169Z | 2024-11-09T14:18:19.242Z |
5496223 | 5496223 | 20241106233014_vPoqr | HU0003 | 2024-11-08T14:11:47.958Z | 2024-11-09T14:18:18.536Z |
5496163 | 5496163 | 20241106231116_bvnO4 | HU0003 | 2024-11-08T14:11:40.797Z | 2024-11-09T14:18:17.267Z |
5495932 | 5495932 | 20241106221031_aeC0S | HU0003 | 2024-11-08T14:11:09.403Z | 2024-11-09T14:18:12.174Z |
5495856 | 5495856 | 20241106215013_WFmF4 | HU0003 | 2024-11-08T14:11:01.775Z | 2024-11-09T14:18:10.351Z |
5495714 | 5495714 | 20241106210950_tBVTC | HU0003 | 2024-11-08T14:10:40.937Z | 2024-11-09T14:18:05.505Z |
5495685 | 5495685 | 20241106210330_iTi9V | HU0003 | 2024-11-08T14:10:37.330Z | 2024-11-09T14:18:04.342Z |
5495643 | 5495643 | 20241106204721_j7dU5 | HU0003 | 2024-11-08T14:10:32.466Z | 2024-11-09T14:18:02.474Z |
5495540 | 5495540 | 20241106201406_8fgDG | HU0003 | 2024-11-08T14:10:22.113Z | 2024-11-09T14:17:57.113Z |
5495535 | 5495535 | 20241106201215_JXiAh | HU0003 | 2024-11-08T14:10:21.630Z | 2024-11-09T14:17:56.904Z |
5495353 | 5495353 | 20241106193457_WT2tL | HU0003 | 2024-11-08T14:10:06.025Z | 2024-11-09T14:17:51.738Z |
5491651 | 5491651 | 20241106041438_HFHH5 | HU0003 | 2024-11-07T14:16:38.425Z | 2024-11-09T14:20:12.336Z |
5491588 | 5491588 | 20241106035726_3l3KM | HU0003 | 2024-11-07T14:16:27.817Z | 2024-11-09T14:20:11.311Z |
5491539 | 5491539 | 20241106034146_z3k2d | HU0003 | 2024-11-07T14:16:20.761Z | 2024-11-09T14:20:10.543Z |
5491532 | 5491532 | 20241106033742_LYAjs | HU0003 | 2024-11-07T14:16:20.219Z | 2024-11-09T14:20:10.509Z |
5491506 | 5491506 | 20241106032944_3Cv8n | HU0003 | 2024-11-07T14:16:15.848Z | 2024-11-09T14:20:09.798Z |
5491392 | 5491392 | 20241106031049_Z04nK | HU0003 | 2024-11-07T14:16:02.669Z | 2024-11-09T14:20:07.318Z |
5491356 | 5491356 | 20241106030326_VjyxP | HU0003 | 2024-11-07T14:15:56.869Z | 2024-11-09T14:20:07.078Z |
5491338 | 5491338 | 20241106025949_LA3xa | HU0003 | 2024-11-07T14:15:54.045Z | 2024-11-09T14:20:06.881Z |
5491328 | 5491328 | 20241106025632_HzniR | HU0003 | 2024-11-07T14:15:52.784Z | 2024-11-09T14:20:06.763Z |
5491310 | 5491310 | 20241106025242_s2AAV | HU0003 | 2024-11-07T14:15:50.704Z | 2024-11-09T14:20:06.523Z |
5491276 | 5491276 | 20241106024518_Uyj2X | HU0003 | 2024-11-07T14:15:45.700Z | 2024-11-09T14:20:06.290Z |
5491261 | 5491261 | 20241106023814_qyT80 | HU0003 | 2024-11-07T14:15:43.349Z | 2024-11-09T14:20:06.130Z |
5491254 | 5491254 | 20241106023739_J7sWG | HU0003 | 2024-11-07T14:15:41.809Z | 2024-11-09T14:20:06.086Z |
5491032 | 5491032 | 20241106014042_MCmu8 | HU0003 | 2024-11-07T14:15:14.261Z | 2024-11-09T14:20:03.235Z |
5490982 | 5490982 | 20241106012937_4GgTT | HU0003 | 2024-11-07T14:15:09.951Z | 2024-11-09T14:20:02.607Z |
5490964 | 5490964 | 20241106012409_2Li9x | HU0003 | 2024-11-07T14:15:08.483Z | 2024-11-09T14:20:02.456Z |
5490947 | 5490947 | 20241106012210_xXLXf | HU0003 | 2024-11-07T14:15:06.985Z | 2024-11-09T14:20:02.228Z |
5490945 | 5490945 | 20241106012120_OkaSY | HU0003 | 2024-11-07T14:15:06.717Z | 2024-11-09T14:20:02.131Z |
5490924 | 5490924 | 20241106011512_3W2OB | HU0003 | 2024-11-07T14:15:05.743Z | 2024-11-09T14:20:01.763Z |
5490892 | 5490892 | 20241106010645_YeVCL | HU0003 | 2024-11-07T14:15:03.321Z | 2024-11-09T14:20:01.076Z |
5490860 | 5490860 | 20241106005726_ZeLDS | HU0003 | 2024-11-07T14:15:00.482Z | 2024-11-09T14:20:00.479Z |
5490850 | 5490850 | 20241106005200_GVz5M | HU0003 | 2024-11-07T14:14:59.566Z | 2024-11-09T14:20:00.328Z |
5490831 | 5490831 | 20241106004919_g7PF3 | HU0003 | 2024-11-07T14:14:58.118Z | 2024-11-09T14:19:59.814Z |
5490773 | 5490773 | 20241106003244_mcQdg | HU0003 | 2024-11-07T14:14:53.322Z | 2024-11-09T14:19:59.400Z |
5490764 | 5490764 | 20241106003141_EreWn | HU0003 | 2024-11-07T14:14:51.964Z | 2024-11-09T14:19:59.360Z |
5490728 | 5490728 | 20241106002352_0muQR | HU0003 | 2024-11-07T14:14:42.769Z | 2024-11-09T14:19:58.906Z |
5490700 | 5490700 | 20241106001247_yRAEB | HU0003 | 2024-11-07T14:14:34.548Z | 2024-11-09T14:19:58.656Z |
5490676 | 5490676 | 20241106000407_ojo2t | HU0003 | 2024-11-07T14:14:29.148Z | 2024-11-09T14:19:58.306Z |
5490669 | 5490669 | 20241106000211_iGA9y | HU0003 | 2024-11-07T14:14:27.060Z | 2024-11-09T14:19:57.807Z |
5490638 | 5490638 | 20241105235110_2xwgK | HU0003 | 2024-11-07T14:14:21.557Z | 2024-11-09T14:19:57.508Z |
5490612 | 5490612 | 20241105233941_HyOJR | HU0003 | 2024-11-07T14:14:18.325Z | 2024-11-09T14:19:57.316Z |
5490477 | 5490477 | 20241105225928_ZOaBr | HU0003 | 2024-11-07T14:14:04.969Z | 2024-11-09T14:19:56.027Z |
5490421 | 5490421 | 20241105224137_ASmrL | HU0003 | 2024-11-07T14:14:00.031Z | 2024-11-09T14:19:55.257Z |
5490366 | 5490366 | 20241105222610_6PNPc | HU0003 | 2024-11-07T14:13:56.086Z | 2024-11-09T14:19:54.269Z |
5490264 | 5490264 | 20241105215119_kK2Oa | HU0003 | 2024-11-07T14:13:47.006Z | 2024-11-09T14:19:53.256Z |
5490243 | 5490243 | 20241105214629_FKigz | HU0003 | 2024-11-07T14:13:41.684Z | 2024-11-09T14:19:53.075Z |
5490196 | 5490196 | 20241105213834_43Sjp | HU0003 | 2024-11-07T14:13:33.232Z | 2024-11-09T14:19:52.112Z |
5490187 | 5490187 | 20241105213305_jYhLk | HU0003 | 2024-11-07T14:13:31.219Z | 2024-11-09T14:19:51.805Z |
5490175 | 5490175 | 20241105213120_dMyHw | HU0003 | 2024-11-07T14:13:30.033Z | 2024-11-09T14:19:51.752Z |
5490143 | 5490143 | 20241105212028_5vy6M | HU0003 | 2024-11-07T14:13:19.443Z | 2024-11-09T14:19:51.316Z |
5489946 | 5489946 | 20241105203228_3DoZD | HU0003 | 2024-11-07T14:12:56.903Z | 2024-11-09T14:19:49.377Z |
5485256 | 5485256 | 20241105043054_Wlrnx | HU0003 | 2024-11-06T14:17:59.668Z | 2024-11-09T14:21:20.297Z |
5485082 | 5485082 | 20241105040150_UFTYc | HU0003 | 2024-11-06T14:17:43.883Z | 2024-11-09T14:21:19.198Z |
5485074 | 5485074 | 20241105040117_NTHDa | HU0003 | 2024-11-06T14:17:43.632Z | 2024-11-09T14:21:19.185Z |
5485047 | 5485047 | 20241105035726_8Lqm8 | HU0003 | 2024-11-06T14:17:41.225Z | 2024-11-09T14:21:18.896Z |
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);