participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,015 rows where station_code = "NZ000A" 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 |
---|---|---|---|---|---|
3245531 | 3245531 | 20231022160252_gAh1f | NZ000A | 2024-01-06T00:03:17.604Z | 2024-01-06T00:03:17.604Z |
3245515 | 3245515 | 20231022160014_2OSpt | NZ000A | 2024-01-06T00:03:17.600Z | 2024-01-06T00:03:17.600Z |
3245441 | 3245441 | 20231022155155_2OSXZ | NZ000A | 2024-01-06T00:03:17.581Z | 2024-01-06T00:03:17.581Z |
3245365 | 3245365 | 20231022154404_3PK5u | NZ000A | 2024-01-06T00:03:17.563Z | 2024-01-06T00:03:17.563Z |
3245271 | 3245271 | 20231022153538_a7D0f | NZ000A | 2024-01-06T00:03:17.539Z | 2024-01-06T00:03:17.539Z |
3244996 | 3244996 | 20231022145756_cb8MI | NZ000A | 2024-01-06T00:03:17.462Z | 2024-01-06T00:03:17.462Z |
3244989 | 3244989 | 20231022145428_d797y | NZ000A | 2024-01-06T00:03:17.460Z | 2024-01-06T00:03:17.460Z |
3244937 | 3244937 | 20231022144754_ziH5h | NZ000A | 2024-01-06T00:03:17.446Z | 2024-01-06T00:03:17.446Z |
3244930 | 3244930 | 20231022144714_GMgCY | NZ000A | 2024-01-06T00:03:17.445Z | 2024-01-06T00:03:17.445Z |
3244914 | 3244914 | 20231022144332_HKgS7 | NZ000A | 2024-01-06T00:03:17.440Z | 2024-01-06T00:03:17.440Z |
3244895 | 3244895 | 20231022144107_poPKC | NZ000A | 2024-01-06T00:03:17.434Z | 2024-01-06T00:03:17.434Z |
3244708 | 3244708 | 20231022140653_fiBNr | NZ000A | 2024-01-06T00:03:17.383Z | 2024-01-06T00:03:17.383Z |
3244646 | 3244646 | 20231022134416_aiWG3 | NZ000A | 2024-01-06T00:03:17.360Z | 2024-01-06T00:03:17.360Z |
3244641 | 3244641 | 20231022134323_swwKt | NZ000A | 2024-01-06T00:03:17.359Z | 2024-01-06T00:03:17.359Z |
3244551 | 3244551 | 20231022130740_5wpbK | NZ000A | 2024-01-06T00:03:17.336Z | 2024-01-06T00:03:17.336Z |
3242402 | 3242402 | 20231022095316_y293Z | NZ000A | 2024-01-06T00:03:16.816Z | 2024-01-06T00:03:16.816Z |
3228318 | 3228318 | 20231021162518_2KDHu | NZ000A | 2024-01-06T00:03:11.257Z | 2024-01-06T00:03:11.257Z |
3228074 | 3228074 | 20231021160610_4XWK8 | NZ000A | 2024-01-06T00:03:11.210Z | 2024-01-06T00:03:11.210Z |
3227983 | 3227983 | 20231021155514_qRISY | NZ000A | 2024-01-06T00:03:11.186Z | 2024-01-06T00:03:11.186Z |
3227857 | 3227857 | 20231021154202_2JDVR | NZ000A | 2024-01-06T00:03:11.143Z | 2024-01-06T00:03:11.143Z |
3227822 | 3227822 | 20231021153748_VBJ3q | NZ000A | 2024-01-06T00:03:11.137Z | 2024-01-06T00:03:11.137Z |
3227790 | 3227790 | 20231021153640_yyTEI | NZ000A | 2024-01-06T00:03:11.133Z | 2024-01-06T00:03:11.133Z |
3227540 | 3227540 | 20231021150943_cAVaU | NZ000A | 2024-01-06T00:03:11.032Z | 2024-01-06T00:03:11.032Z |
3227328 | 3227328 | 20231021144310_calcq | NZ000A | 2024-01-06T00:03:10.991Z | 2024-01-06T00:03:10.991Z |
3227229 | 3227229 | 20231021142511_GMrI4 | NZ000A | 2024-01-06T00:03:10.968Z | 2024-01-06T00:03:10.968Z |
3227022 | 3227022 | 20231021132550_8AD0Y | NZ000A | 2024-01-06T00:03:10.923Z | 2024-01-06T00:03:10.923Z |
3226008 | 3226008 | 20231021114027_vx15t | NZ000A | 2024-01-06T00:03:10.692Z | 2024-01-06T00:03:10.692Z |
3224988 | 3224988 | 20231021102649_KVh2r | NZ000A | 2024-01-06T00:03:10.459Z | 2024-01-06T00:03:10.459Z |
3218372 | 3218372 | 20231020163045_5JIzD | NZ000A | 2024-01-06T00:03:06.328Z | 2024-01-06T00:03:06.328Z |
3218341 | 3218341 | 20231020162706_nhX8w | NZ000A | 2024-01-06T00:03:06.322Z | 2024-01-06T00:03:06.322Z |
3217899 | 3217899 | 20231020152759_fWzzt | NZ000A | 2024-01-06T00:03:06.237Z | 2024-01-06T00:03:06.237Z |
3217563 | 3217563 | 20231020135834_37UgU | NZ000A | 2024-01-06T00:03:06.151Z | 2024-01-06T00:03:06.151Z |
3212721 | 3212721 | 20231019155511_Qp6nQ | NZ000A | 2024-01-06T00:03:02.854Z | 2024-01-06T00:03:02.854Z |
3212658 | 3212658 | 20231019153746_80WtA | NZ000A | 2024-01-06T00:03:02.831Z | 2024-01-06T00:03:02.831Z |
3212493 | 3212493 | 20231019145948_02XF2 | NZ000A | 2024-01-06T00:03:02.799Z | 2024-01-06T00:03:02.799Z |
3212471 | 3212471 | 20231019145727_hu5PR | NZ000A | 2024-01-06T00:03:02.795Z | 2024-01-06T00:03:02.795Z |
3212308 | 3212308 | 20231019142759_PbG8b | NZ000A | 2024-01-06T00:03:02.756Z | 2024-01-06T00:03:02.756Z |
3212229 | 3212229 | 20231019140822_A0z75 | NZ000A | 2024-01-06T00:03:02.734Z | 2024-01-06T00:03:02.734Z |
3212164 | 3212164 | 20231019135632_WtJYU | NZ000A | 2024-01-06T00:03:02.718Z | 2024-01-06T00:03:02.718Z |
3212067 | 3212067 | 20231019133507_2er3r | NZ000A | 2024-01-06T00:03:02.631Z | 2024-01-06T00:03:02.631Z |
3211805 | 3211805 | 20231019123915_YzJWx | NZ000A | 2024-01-06T00:03:02.534Z | 2024-01-06T00:03:02.534Z |
3211458 | 3211458 | 20231019120850_6Fstl | NZ000A | 2024-01-06T00:03:02.422Z | 2024-01-06T00:03:02.422Z |
3209040 | 3209040 | 20231019085255_xFiH8 | NZ000A | 2024-01-06T00:03:01.781Z | 2024-01-06T00:03:01.781Z |
3205132 | 3205132 | 20231018144129_LKVYV | NZ000A | 2024-01-06T00:02:58.877Z | 2024-01-06T00:02:58.877Z |
3205070 | 3205070 | 20231018142353_1iJUj | NZ000A | 2024-01-06T00:02:58.855Z | 2024-01-06T00:02:58.855Z |
3205016 | 3205016 | 20231018140558_JepyI | NZ000A | 2024-01-06T00:02:58.836Z | 2024-01-06T00:02:58.836Z |
3204915 | 3204915 | 20231018134234_76Xof | NZ000A | 2024-01-06T00:02:58.802Z | 2024-01-06T00:02:58.802Z |
3204876 | 3204876 | 20231018132952_FSDfI | NZ000A | 2024-01-06T00:02:58.788Z | 2024-01-06T00:02:58.788Z |
3204718 | 3204718 | 20231018124219_DegyF | NZ000A | 2024-01-06T00:02:58.731Z | 2024-01-06T00:02:58.731Z |
3204321 | 3204321 | 20231018120030_f2gmH | NZ000A | 2024-01-06T00:02:58.607Z | 2024-01-06T00:02:58.607Z |
3202906 | 3202906 | 20231018092957_54HDV | NZ000A | 2024-01-06T00:02:58.232Z | 2024-01-06T00:02:58.232Z |
3197828 | 3197828 | 20231017162324_Vsi4X | NZ000A | 2024-01-06T00:02:54.779Z | 2024-01-06T00:02:54.779Z |
3197767 | 3197767 | 20231017161800_2y2Zd | NZ000A | 2024-01-06T00:02:54.774Z | 2024-01-06T00:02:54.774Z |
3197404 | 3197404 | 20231017152636_2mqAM | NZ000A | 2024-01-06T00:02:54.738Z | 2024-01-06T00:02:54.738Z |
3197366 | 3197366 | 20231017151828_Kvxi1 | NZ000A | 2024-01-06T00:02:54.734Z | 2024-01-06T00:02:54.734Z |
3197340 | 3197340 | 20231017151602_q6sdk | NZ000A | 2024-01-06T00:02:54.731Z | 2024-01-06T00:02:54.731Z |
3197174 | 3197174 | 20231017145012_eaX5N | NZ000A | 2024-01-06T00:02:54.717Z | 2024-01-06T00:02:54.717Z |
3197117 | 3197117 | 20231017143640_m2FL1 | NZ000A | 2024-01-06T00:02:54.711Z | 2024-01-06T00:02:54.711Z |
3197103 | 3197103 | 20231017143257_J30yt | NZ000A | 2024-01-06T00:02:54.710Z | 2024-01-06T00:02:54.710Z |
3197088 | 3197088 | 20231017143104_bIZox | NZ000A | 2024-01-06T00:02:54.709Z | 2024-01-06T00:02:54.709Z |
3197083 | 3197083 | 20231017142957_A3j6Q | NZ000A | 2024-01-06T00:02:54.708Z | 2024-01-06T00:02:54.708Z |
3197034 | 3197034 | 20231017141647_718OE | NZ000A | 2024-01-06T00:02:54.704Z | 2024-01-06T00:02:54.704Z |
3196761 | 3196761 | 20231017133455_lY1bv | NZ000A | 2024-01-06T00:02:54.679Z | 2024-01-06T00:02:54.679Z |
3196749 | 3196749 | 20231017133303_5qtM1 | NZ000A | 2024-01-06T00:02:54.678Z | 2024-01-06T00:02:54.678Z |
3196719 | 3196719 | 20231017132606_W9P3y | NZ000A | 2024-01-06T00:02:54.676Z | 2024-01-06T00:02:54.676Z |
3196642 | 3196642 | 20231017130845_YGiCK | NZ000A | 2024-01-06T00:02:54.667Z | 2024-01-06T00:02:54.667Z |
3196605 | 3196605 | 20231017125631_ApAWx | NZ000A | 2024-01-06T00:02:54.663Z | 2024-01-06T00:02:54.663Z |
3196582 | 3196582 | 20231017124955_w3N75 | NZ000A | 2024-01-06T00:02:54.660Z | 2024-01-06T00:02:54.660Z |
3196556 | 3196556 | 20231017124058_ZN5bp | NZ000A | 2024-01-06T00:02:54.658Z | 2024-01-06T00:02:54.658Z |
3196230 | 3196230 | 20231017120559_evxkx | NZ000A | 2024-01-06T00:02:54.626Z | 2024-01-06T00:02:54.626Z |
3195534 | 3195534 | 20231017105833_0e8Mt | NZ000A | 2024-01-06T00:02:54.558Z | 2024-01-06T00:02:54.558Z |
3195516 | 3195516 | 20231017105640_v2jUF | NZ000A | 2024-01-06T00:02:54.556Z | 2024-01-06T00:02:54.556Z |
3194964 | 3194964 | 20231017095512_7i2Ez | NZ000A | 2024-01-06T00:02:54.499Z | 2024-01-06T00:02:54.499Z |
3194621 | 3194621 | 20231017092336_UtWwr | NZ000A | 2024-01-06T00:02:54.464Z | 2024-01-06T00:02:54.464Z |
3194149 | 3194149 | 20231017082556_X4Ula | NZ000A | 2024-01-06T00:02:54.419Z | 2024-01-06T00:02:54.419Z |
3175932 | 3175932 | 20231015162154_gq43w | NZ000A | 2024-01-06T00:02:49.663Z | 2024-01-06T00:02:49.663Z |
3175819 | 3175819 | 20231015160526_xAbsu | NZ000A | 2024-01-06T00:02:49.649Z | 2024-01-06T00:02:49.649Z |
3175805 | 3175805 | 20231015160252_KTlhk | NZ000A | 2024-01-06T00:02:49.647Z | 2024-01-06T00:02:49.647Z |
3175786 | 3175786 | 20231015160107_suf3y | NZ000A | 2024-01-06T00:02:49.645Z | 2024-01-06T00:02:49.645Z |
3175726 | 3175726 | 20231015154942_d4YJq | NZ000A | 2024-01-06T00:02:49.638Z | 2024-01-06T00:02:49.638Z |
3175717 | 3175717 | 20231015154844_nQjAq | NZ000A | 2024-01-06T00:02:49.636Z | 2024-01-06T00:02:49.636Z |
3175291 | 3175291 | 20231015143941_vPBpb | NZ000A | 2024-01-06T00:02:49.585Z | 2024-01-06T00:02:49.585Z |
3175294 | 3175294 | 20231015144010_X0EXi | NZ000A | 2024-01-06T00:02:49.585Z | 2024-01-06T00:02:49.585Z |
3175223 | 3175223 | 20231015142749_vO9MC | NZ000A | 2024-01-06T00:02:49.318Z | 2024-01-06T00:02:49.318Z |
3175169 | 3175169 | 20231015141501_0CT7V | NZ000A | 2024-01-06T00:02:49.310Z | 2024-01-06T00:02:49.310Z |
3175137 | 3175137 | 20231015140858_xb9C3 | NZ000A | 2024-01-06T00:02:49.307Z | 2024-01-06T00:02:49.307Z |
3175067 | 3175067 | 20231015135421_L9e60 | NZ000A | 2024-01-06T00:02:49.298Z | 2024-01-06T00:02:49.298Z |
3175054 | 3175054 | 20231015135306_atDtI | NZ000A | 2024-01-06T00:02:49.297Z | 2024-01-06T00:02:49.297Z |
3175062 | 3175062 | 20231015135320_S92xS | NZ000A | 2024-01-06T00:02:49.297Z | 2024-01-06T00:02:49.297Z |
3175027 | 3175027 | 20231015134827_qLpUN | NZ000A | 2024-01-06T00:02:49.294Z | 2024-01-06T00:02:49.294Z |
3174888 | 3174888 | 20231015132037_bTHAU | NZ000A | 2024-01-06T00:02:49.278Z | 2024-01-06T00:02:49.278Z |
3174871 | 3174871 | 20231015131646_m3GRS | NZ000A | 2024-01-06T00:02:49.276Z | 2024-01-06T00:02:49.276Z |
3174776 | 3174776 | 20231015125609_7GSuv | NZ000A | 2024-01-06T00:02:49.265Z | 2024-01-06T00:02:49.265Z |
3174673 | 3174673 | 20231015123456_NDD3o | NZ000A | 2024-01-06T00:02:49.252Z | 2024-01-06T00:02:49.252Z |
3174342 | 3174342 | 20231015115801_JiKh0 | NZ000A | 2024-01-06T00:02:49.215Z | 2024-01-06T00:02:49.215Z |
3173893 | 3173893 | 20231015110508_WGypo | NZ000A | 2024-01-06T00:02:49.166Z | 2024-01-06T00:02:49.166Z |
3172958 | 3172958 | 20231015090032_5whaV | NZ000A | 2024-01-06T00:02:49.067Z | 2024-01-06T00:02:49.067Z |
3172696 | 3172696 | 20231015082021_TxTj1 | NZ000A | 2024-01-06T00:02:49.037Z | 2024-01-06T00:02:49.037Z |
3157967 | 3157967 | 20231014140842_zu4LD | NZ000A | 2024-01-06T00:02:46.157Z | 2024-01-06T00:02:46.157Z |
3157929 | 3157929 | 20231014135408_t0ihE | NZ000A | 2024-01-06T00:02:46.153Z | 2024-01-06T00:02:46.153Z |
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);