participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,336 rows where station_code = "HU0005" 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 |
|---|---|---|---|---|---|
| 9611579 | 9611579 | 20260405024017_V9HpM | HU0005 | 2026-04-06T12:15:09.960Z | 2026-04-06T12:16:14.826Z |
| 9611554 | 9611554 | 20260405023421_YEPv9 | HU0005 | 2026-04-06T12:15:05.655Z | 2026-04-06T12:16:14.821Z |
| 9611552 | 9611552 | 20260405023421_pVncH | HU0005 | 2026-04-06T12:15:04.980Z | 2026-04-06T12:16:14.821Z |
| 9611031 | 9611031 | 20260404233327_axtsz | HU0005 | 2026-04-06T12:12:41.582Z | 2026-04-06T12:16:14.716Z |
| 9610791 | 9610791 | 20260404215458_v7qZi | HU0005 | 2026-04-06T12:11:23.929Z | 2026-04-06T12:16:14.662Z |
| 9610715 | 9610715 | 20260404211630_4pvgy | HU0005 | 2026-04-06T12:10:50.128Z | 2026-04-06T12:16:14.641Z |
| 9610669 | 9610669 | 20260404210356_bg14T | HU0005 | 2026-04-06T12:10:39.141Z | 2026-04-06T12:16:14.631Z |
| 9610648 | 9610648 | 20260404210119_y5eRt | HU0005 | 2026-04-06T12:10:34.440Z | 2026-04-06T12:16:14.626Z |
| 9610562 | 9610562 | 20260404203329_MgJmB | HU0005 | 2026-04-06T12:10:09.501Z | 2026-04-06T12:16:14.604Z |
| 9610440 | 9610440 | 20260404190133_vgxsX | HU0005 | 2026-04-06T12:09:29.646Z | 2026-04-06T12:16:14.562Z |
| 9608879 | 9608879 | 20260404021221_c3phK | HU0005 | 2026-04-05T12:12:02.096Z | 2026-04-06T12:20:45.210Z |
| 9608827 | 9608827 | 20260404014913_CRHjk | HU0005 | 2026-04-05T12:11:52.162Z | 2026-04-06T12:20:41.284Z |
| 9608822 | 9608822 | 20260404014618_8HOI2 | HU0005 | 2026-04-05T12:11:51.305Z | 2026-04-06T12:20:40.882Z |
| 9608712 | 9608712 | 20260404005638_WswpJ | HU0005 | 2026-04-05T12:11:24.110Z | 2026-04-06T12:20:32.997Z |
| 9608707 | 9608707 | 20260404005223_lIfWK | HU0005 | 2026-04-05T12:11:23.008Z | 2026-04-06T12:20:32.566Z |
| 9608621 | 9608621 | 20260403235943_OdrrV | HU0005 | 2026-04-05T12:11:01.378Z | 2026-04-06T12:20:26.780Z |
| 9608610 | 9608610 | 20260403235716_lNhrY | HU0005 | 2026-04-05T12:10:54.921Z | 2026-04-06T12:20:25.326Z |
| 9608574 | 9608574 | 20260403234600_yAlJK | HU0005 | 2026-04-05T12:10:50.976Z | 2026-04-06T12:20:21.322Z |
| 9608435 | 9608435 | 20260403230443_SeAwU | HU0005 | 2026-04-05T12:10:26.673Z | 2026-04-06T12:20:12.830Z |
| 9608393 | 9608393 | 20260403225511_KYZzb | HU0005 | 2026-04-05T12:10:20.265Z | 2026-04-06T12:20:10.384Z |
| 9608327 | 9608327 | 20260403215159_u8HMn | HU0005 | 2026-04-05T12:10:01.800Z | 2026-04-06T12:20:05.858Z |
| 9608249 | 9608249 | 20260403212328_AjK3U | HU0005 | 2026-04-05T12:09:49.734Z | 2026-04-06T12:20:01.879Z |
| 9608136 | 9608136 | 20260403201127_ZlB7C | HU0005 | 2026-04-05T12:09:00.869Z | 2026-04-06T12:19:44.679Z |
| 9608054 | 9608054 | 20260403184841_Lohpn | HU0005 | 2026-04-05T12:08:06.840Z | 2026-04-06T12:19:29.723Z |
| 9604804 | 9604804 | 20260402004740_9YVL3 | HU0005 | 2026-04-03T12:11:37.194Z | 2026-04-06T12:26:20.147Z |
| 9580069 | 9580069 | 20260325000007_e8Xay | HU0005 | 2026-03-26T12:15:02.119Z | 2026-04-02T12:37:41.018Z |
| 9579885 | 9579885 | 20260324231227_x9S0D | HU0005 | 2026-03-26T12:14:37.858Z | 2026-04-02T12:37:33.741Z |
| 9579867 | 9579867 | 20260324231143_pKxqD | HU0005 | 2026-03-26T12:14:36.575Z | 2026-04-02T12:37:33.305Z |
| 9579740 | 9579740 | 20260324223947_8Bx2N | HU0005 | 2026-03-26T12:14:19.052Z | 2026-04-02T12:37:28.162Z |
| 9579583 | 9579583 | 20260324214503_4w3Ve | HU0005 | 2026-03-26T12:14:01.990Z | 2026-04-02T12:37:16.875Z |
| 9579559 | 9579559 | 20260324213040_Ad7Wr | HU0005 | 2026-03-26T12:13:56.404Z | 2026-04-02T12:37:15.951Z |
| 9579426 | 9579426 | 20260324202109_UcRWn | HU0005 | 2026-03-26T12:13:39.250Z | 2026-04-02T12:37:09.396Z |
| 9577021 | 9577021 | 20260325033916_D0z22 | HU0005 | 2026-03-26T12:03:55.011Z | 2026-04-03T12:36:29.669Z |
| 9576903 | 9576903 | 20260325032404_VCQS2 | HU0005 | 2026-03-26T12:03:37.054Z | 2026-04-03T12:36:25.137Z |
| 9576644 | 9576644 | 20260325024729_QOXQk | HU0005 | 2026-03-26T12:02:53.520Z | 2026-04-03T12:36:15.789Z |
| 9575295 | 9575295 | 20260323202117_nA7kn | HU0005 | 2026-03-25T12:20:46.046Z | 2026-03-31T12:28:53.816Z |
| 9575287 | 9575287 | 20260323201727_Smu7k | HU0005 | 2026-03-25T12:20:44.823Z | 2026-03-31T12:28:53.427Z |
| 9575284 | 9575284 | 20260323201727_p2BZE | HU0005 | 2026-03-25T12:20:44.626Z | 2026-03-31T12:28:53.351Z |
| 9575278 | 9575278 | 20260323201311_Jqmc3 | HU0005 | 2026-03-25T12:20:43.951Z | 2026-03-31T12:28:53.184Z |
| 9575193 | 9575193 | 20260323192034_hj711 | HU0005 | 2026-03-25T12:20:29.920Z | 2026-03-31T12:28:50.848Z |
| 9570082 | 9570082 | 20260322190816_R9mkE | HU0005 | 2026-03-24T12:22:33.541Z | 2026-03-30T12:30:27.507Z |
| 9569987 | 9569987 | 20260322184657_nlXu7 | HU0005 | 2026-03-24T12:22:26.550Z | 2026-03-30T12:30:25.998Z |
| 9541007 | 9541007 | 20260319185250_TqMDR | HU0005 | 2026-03-21T12:28:22.837Z | 2026-03-27T12:42:32.882Z |
| 9540985 | 9540985 | 20260319184825_uzK8i | HU0005 | 2026-03-21T12:28:21.441Z | 2026-03-27T12:42:32.709Z |
| 9533969 | 9533969 | 20260320031158_T5Vi2 | HU0005 | 2026-03-21T12:06:47.110Z | 2026-03-28T12:34:02.902Z |
| 9533519 | 9533519 | 20260320023621_klIAg | HU0005 | 2026-03-21T12:05:35.471Z | 2026-03-28T12:33:54.484Z |
| 9533114 | 9533114 | 20260320020144_dgRwA | HU0005 | 2026-03-21T12:04:29.932Z | 2026-03-28T12:33:48.984Z |
| 9532807 | 9532807 | 20260320012754_33t6E | HU0005 | 2026-03-21T12:03:41.832Z | 2026-03-28T12:33:44.293Z |
| 9532320 | 9532320 | 20260320004704_Cjdbc | HU0005 | 2026-03-21T12:02:23.211Z | 2026-03-28T12:33:27.691Z |
| 9532316 | 9532316 | 20260320004703_Dg9mJ | HU0005 | 2026-03-21T12:02:22.029Z | 2026-03-28T12:33:27.623Z |
| 9532257 | 9532257 | 20260320004134_ycnh8 | HU0005 | 2026-03-21T12:02:11.277Z | 2026-03-28T12:33:26.392Z |
| 9531433 | 9531433 | 20260318231003_Wm5cg | HU0005 | 2026-03-20T12:25:10.494Z | 2026-03-26T12:39:19.360Z |
| 9531271 | 9531271 | 20260318225058_O3es3 | HU0005 | 2026-03-20T12:25:03.824Z | 2026-03-26T12:39:18.489Z |
| 9531184 | 9531184 | 20260318224058_CMtH3 | HU0005 | 2026-03-20T12:25:00.868Z | 2026-03-26T12:39:17.958Z |
| 9531107 | 9531107 | 20260318222614_VhQog | HU0005 | 2026-03-20T12:24:57.910Z | 2026-03-26T12:39:17.470Z |
| 9531007 | 9531007 | 20260318221359_uC2uf | HU0005 | 2026-03-20T12:24:54.480Z | 2026-03-26T12:39:16.947Z |
| 9530864 | 9530864 | 20260318215449_23Q2Q | HU0005 | 2026-03-20T12:24:49.994Z | 2026-03-26T12:39:16.267Z |
| 9530675 | 9530675 | 20260318212345_zBxFu | HU0005 | 2026-03-20T12:24:35.316Z | 2026-03-26T12:39:14.725Z |
| 9530423 | 9530423 | 20260318205307_YieIK | HU0005 | 2026-03-20T12:24:23.005Z | 2026-03-26T12:39:12.146Z |
| 9530283 | 9530283 | 20260318203422_8YAqA | HU0005 | 2026-03-20T12:24:16.403Z | 2026-03-26T12:39:10.981Z |
| 9530187 | 9530187 | 20260318202341_C7HvO | HU0005 | 2026-03-20T12:24:11.047Z | 2026-03-26T12:39:10.169Z |
| 9529763 | 9529763 | 20260318192742_rgPL1 | HU0005 | 2026-03-20T12:23:37.882Z | 2026-03-26T12:39:06.260Z |
| 9529612 | 9529612 | 20260318185931_76RWT | HU0005 | 2026-03-20T12:23:21.428Z | 2026-03-26T12:39:04.868Z |
| 9521048 | 9521048 | 20260319035133_ouYpT | HU0005 | 2026-03-20T12:07:26.616Z | 2026-03-27T12:40:50.556Z |
| 9520428 | 9520428 | 20260319031600_mCjEd | HU0005 | 2026-03-20T12:06:22.451Z | 2026-03-27T12:40:43.039Z |
| 9520417 | 9520417 | 20260319031427_Q21D4 | HU0005 | 2026-03-20T12:06:21.456Z | 2026-03-27T12:40:42.789Z |
| 9520287 | 9520287 | 20260319030856_Lp3JF | HU0005 | 2026-03-20T12:06:08.617Z | 2026-03-27T12:40:41.583Z |
| 9519583 | 9519583 | 20260319021910_sUdxZ | HU0005 | 2026-03-20T12:04:40.953Z | 2026-03-27T12:40:32.734Z |
| 9519269 | 9519269 | 20260319015737_RN4PV | HU0005 | 2026-03-20T12:04:13.618Z | 2026-03-27T12:40:19.731Z |
| 9519132 | 9519132 | 20260319015154_PXNYS | HU0005 | 2026-03-20T12:03:58.690Z | 2026-03-27T12:40:18.480Z |
| 9518924 | 9518924 | 20260319013517_eIUvk | HU0005 | 2026-03-20T12:03:36.954Z | 2026-03-27T12:40:16.468Z |
| 9518896 | 9518896 | 20260319013327_L2jB8 | HU0005 | 2026-03-20T12:03:34.514Z | 2026-03-27T12:40:16.276Z |
| 9518885 | 9518885 | 20260319013156_evKtH | HU0005 | 2026-03-20T12:03:33.182Z | 2026-03-27T12:40:16.140Z |
| 9518875 | 9518875 | 20260319013122_eLriM | HU0005 | 2026-03-20T12:03:32.246Z | 2026-03-27T12:40:16.026Z |
| 9518837 | 9518837 | 20260319012915_GEjkc | HU0005 | 2026-03-20T12:03:29.295Z | 2026-03-27T12:40:15.685Z |
| 9518759 | 9518759 | 20260319012258_W9csF | HU0005 | 2026-03-20T12:03:16.100Z | 2026-03-27T12:40:13.445Z |
| 9518656 | 9518656 | 20260319011505_esIlN | HU0005 | 2026-03-20T12:03:03.995Z | 2026-03-27T12:40:12.438Z |
| 9517678 | 9517678 | 20260318235419_l1rne | HU0005 | 2026-03-20T12:01:00.185Z | 2026-03-27T12:40:02.349Z |
| 9517523 | 9517523 | 20260318233554_74MCE | HU0005 | 2026-03-20T12:00:37.077Z | 2026-03-27T12:40:00.514Z |
| 9501991 | 9501991 | 20260317005900_J3SWu | HU0005 | 2026-03-18T12:01:00.662Z | 2026-03-25T12:41:44.562Z |
| 9501460 | 9501460 | 20260315222437_kWHsp | HU0005 | 2026-03-17T12:25:03.594Z | 2026-03-23T12:22:44.632Z |
| 9501344 | 9501344 | 20260315220154_3IGbc | HU0005 | 2026-03-17T12:24:51.314Z | 2026-03-23T12:22:44.018Z |
| 9500920 | 9500920 | 20260315200313_GWM3J | HU0005 | 2026-03-17T12:24:10.543Z | 2026-03-23T12:22:42.295Z |
| 9500751 | 9500751 | 20260315191059_ZooPU | HU0005 | 2026-03-17T12:23:46.558Z | 2026-03-23T12:22:41.241Z |
| 9500747 | 9500747 | 20260315190922_FJEsq | HU0005 | 2026-03-17T12:23:46.130Z | 2026-03-23T12:22:41.222Z |
| 9500726 | 9500726 | 20260315185138_d5J3p | HU0005 | 2026-03-17T12:23:44.250Z | 2026-03-23T12:22:41.087Z |
| 9500693 | 9500693 | 20260315182551_tRj7f | HU0005 | 2026-03-17T12:23:38.719Z | 2026-03-23T12:22:40.857Z |
| 9494940 | 9494940 | 20260316033305_6Gceb | HU0005 | 2026-03-17T12:05:33.470Z | 2026-03-24T12:40:51.309Z |
| 9494848 | 9494848 | 20260316031209_X8wPj | HU0005 | 2026-03-17T12:05:14.172Z | 2026-03-24T12:40:50.649Z |
| 9494829 | 9494829 | 20260316031022_E2Kda | HU0005 | 2026-03-17T12:05:09.556Z | 2026-03-24T12:40:50.463Z |
| 9494808 | 9494808 | 20260316030703_q4UCT | HU0005 | 2026-03-17T12:05:03.594Z | 2026-03-24T12:40:50.295Z |
| 9494753 | 9494753 | 20260316025228_4pZJ3 | HU0005 | 2026-03-17T12:04:49.751Z | 2026-03-24T12:40:49.690Z |
| 9494680 | 9494680 | 20260316024521_dN7ri | HU0005 | 2026-03-17T12:04:37.901Z | 2026-03-24T12:40:49.334Z |
| 9494561 | 9494561 | 20260316022835_805M9 | HU0005 | 2026-03-17T12:04:15.049Z | 2026-03-24T12:40:48.216Z |
| 9494367 | 9494367 | 20260316020246_dWXSq | HU0005 | 2026-03-17T12:03:48.582Z | 2026-03-24T12:40:47.266Z |
| 9494360 | 9494360 | 20260316020119_7qCrC | HU0005 | 2026-03-17T12:03:47.272Z | 2026-03-24T12:40:47.229Z |
| 9494279 | 9494279 | 20260316014917_g16Ne | HU0005 | 2026-03-17T12:03:30.405Z | 2026-03-24T12:40:46.481Z |
| 9493910 | 9493910 | 20260316005430_0GSek | HU0005 | 2026-03-17T12:02:24.752Z | 2026-03-24T12:40:43.101Z |
| 9493623 | 9493623 | 20260316001041_M9FGB | HU0005 | 2026-03-17T12:01:34.862Z | 2026-03-24T12:40:41.169Z |
| 9493527 | 9493527 | 20260315234158_OXuhW | HU0005 | 2026-03-17T12:01:09.803Z | 2026-03-24T12:40:40.406Z |
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);