participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,195 rows where station_code = "NZ0051" 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 |
---|---|---|---|---|---|
5461140 | 5461140 | 20241101160827_ihXAP | NZ0051 | 2024-11-03T14:14:45.325Z | 2024-11-03T14:19:33.680Z |
5461109 | 5461109 | 20241101155832_reQuJ | NZ0051 | 2024-11-03T14:14:43.836Z | 2024-11-03T14:19:33.674Z |
5461083 | 5461083 | 20241101155018_Z9PMu | NZ0051 | 2024-11-03T14:14:42.304Z | 2024-11-03T14:19:33.668Z |
5461068 | 5461068 | 20241101154531_4jm5c | NZ0051 | 2024-11-03T14:14:41.697Z | 2024-11-03T14:19:33.665Z |
5461045 | 5461045 | 20241101153944_OZJqU | NZ0051 | 2024-11-03T14:14:40.640Z | 2024-11-03T14:19:33.661Z |
5460997 | 5460997 | 20241101153112_n1XkE | NZ0051 | 2024-11-03T14:14:38.112Z | 2024-11-03T14:19:33.651Z |
5460981 | 5460981 | 20241101153007_2yk6p | NZ0051 | 2024-11-03T14:14:37.663Z | 2024-11-03T14:19:33.649Z |
5460953 | 5460953 | 20241101152442_6Uv7G | NZ0051 | 2024-11-03T14:14:35.911Z | 2024-11-03T14:19:33.643Z |
5460947 | 5460947 | 20241101152415_y7xVv | NZ0051 | 2024-11-03T14:14:35.516Z | 2024-11-03T14:19:33.642Z |
5460939 | 5460939 | 20241101152302_PkZCf | NZ0051 | 2024-11-03T14:14:35.108Z | 2024-11-03T14:19:33.640Z |
5460727 | 5460727 | 20241101145634_Shpas | NZ0051 | 2024-11-03T14:14:17.465Z | 2024-11-03T14:19:33.603Z |
5460716 | 5460716 | 20241101145547_IFU2T | NZ0051 | 2024-11-03T14:14:16.745Z | 2024-11-03T14:19:33.601Z |
5460702 | 5460702 | 20241101145449_jqFX9 | NZ0051 | 2024-11-03T14:14:15.643Z | 2024-11-03T14:19:33.599Z |
5460644 | 5460644 | 20241101144110_vB3zv | NZ0051 | 2024-11-03T14:14:07.181Z | 2024-11-03T14:19:33.588Z |
5460624 | 5460624 | 20241101143906_PXT9b | NZ0051 | 2024-11-03T14:14:04.590Z | 2024-11-03T14:19:33.585Z |
5460605 | 5460605 | 20241101143747_i0Gvx | NZ0051 | 2024-11-03T14:14:02.734Z | 2024-11-03T14:19:33.582Z |
5460590 | 5460590 | 20241101143416_bzDUn | NZ0051 | 2024-11-03T14:14:00.730Z | 2024-11-03T14:19:33.580Z |
5460561 | 5460561 | 20241101143025_DvbXH | NZ0051 | 2024-11-03T14:13:58.979Z | 2024-11-03T14:19:33.575Z |
5458488 | 5458488 | 20241101083456_WuhJL | NZ0051 | 2024-11-03T14:09:50.570Z | 2024-11-03T14:19:33.136Z |
5458389 | 5458389 | 20241101081943_yZaJ9 | NZ0051 | 2024-11-03T14:09:41.578Z | 2024-11-03T14:19:33.116Z |
5458040 | 5458040 | 20241102160151_d8sB2 | NZ0051 | 2024-11-03T14:08:35.724Z | 2024-11-03T14:08:35.724Z |
5458005 | 5458005 | 20241102155654_Kpy2Q | NZ0051 | 2024-11-03T14:08:31.975Z | 2024-11-03T14:08:31.975Z |
5458000 | 5458000 | 20241102155636_8kwKV | NZ0051 | 2024-11-03T14:08:31.680Z | 2024-11-03T14:08:31.680Z |
5457966 | 5457966 | 20241102154959_4yjvY | NZ0051 | 2024-11-03T14:08:24.866Z | 2024-11-03T14:08:24.866Z |
5457759 | 5457759 | 20241102152121_YG4fJ | NZ0051 | 2024-11-03T14:07:59.747Z | 2024-11-03T14:07:59.747Z |
5457715 | 5457715 | 20241102151456_yUaxz | NZ0051 | 2024-11-03T14:07:53.959Z | 2024-11-03T14:07:53.959Z |
5457695 | 5457695 | 20241102151010_P5MuQ | NZ0051 | 2024-11-03T14:07:51.840Z | 2024-11-03T14:07:51.840Z |
5457664 | 5457664 | 20241102150407_EqPcI | NZ0051 | 2024-11-03T14:07:47.802Z | 2024-11-03T14:07:47.802Z |
5457201 | 5457201 | 20241102134615_AgDp9 | NZ0051 | 2024-11-03T14:06:45.025Z | 2024-11-03T14:06:45.025Z |
5457069 | 5457069 | 20241102132603_UHXhs | NZ0051 | 2024-11-03T14:06:29.372Z | 2024-11-03T14:06:29.372Z |
5457037 | 5457037 | 20241102131624_aqizm | NZ0051 | 2024-11-03T14:06:25.773Z | 2024-11-03T14:06:25.773Z |
5457028 | 5457028 | 20241102131504_YV0W4 | NZ0051 | 2024-11-03T14:06:23.451Z | 2024-11-03T14:06:23.451Z |
5457023 | 5457023 | 20241102131349_jRGe8 | NZ0051 | 2024-11-03T14:06:23.167Z | 2024-11-03T14:06:23.167Z |
5456997 | 5456997 | 20241102131119_r9T5U | NZ0051 | 2024-11-03T14:06:19.829Z | 2024-11-03T14:06:19.829Z |
5456956 | 5456956 | 20241102125953_3FZLr | NZ0051 | 2024-11-03T14:06:09.072Z | 2024-11-03T14:06:09.072Z |
5456948 | 5456948 | 20241102125658_9Ajbr | NZ0051 | 2024-11-03T14:06:07.569Z | 2024-11-03T14:06:07.569Z |
5456181 | 5456181 | 20241102103630_aeOeX | NZ0051 | 2024-11-03T14:03:43.425Z | 2024-11-03T14:03:43.425Z |
5456086 | 5456086 | 20241102102008_JJahi | NZ0051 | 2024-11-03T14:03:19.065Z | 2024-11-03T14:03:19.065Z |
5456039 | 5456039 | 20241102101058_RxPhS | NZ0051 | 2024-11-03T14:03:10.624Z | 2024-11-03T14:03:10.624Z |
5455933 | 5455933 | 20241102094810_p3GT0 | NZ0051 | 2024-11-03T14:02:49.645Z | 2024-11-03T14:02:49.645Z |
5455704 | 5455704 | 20241102090112_Gr30B | NZ0051 | 2024-11-03T14:01:59.812Z | 2024-11-03T14:01:59.812Z |
5455670 | 5455670 | 20241102085509_snQcF | NZ0051 | 2024-11-03T14:01:51.294Z | 2024-11-03T14:01:51.294Z |
5455555 | 5455555 | 20241102082437_LkDPW | NZ0051 | 2024-11-03T14:01:22.131Z | 2024-11-03T14:01:22.131Z |
5449588 | 5449588 | 20241031155814_f9aY5 | NZ0051 | 2024-11-02T12:13:10.719Z | 2024-11-03T14:20:55.507Z |
5449571 | 5449571 | 20241031155527_YkmMV | NZ0051 | 2024-11-02T12:13:07.266Z | 2024-11-03T14:20:55.091Z |
5449552 | 5449552 | 20241031155242_8Ywfp | NZ0051 | 2024-11-02T12:13:05.515Z | 2024-11-03T14:20:54.651Z |
5449526 | 5449526 | 20241031154746_HhJto | NZ0051 | 2024-11-02T12:13:03.533Z | 2024-11-03T14:20:54.155Z |
5449345 | 5449345 | 20241031152344_NWIAM | NZ0051 | 2024-11-02T12:12:37.742Z | 2024-11-03T14:20:51.820Z |
5449210 | 5449210 | 20241031150429_M3MOa | NZ0051 | 2024-11-02T12:12:17.820Z | 2024-11-03T14:20:49.480Z |
5449130 | 5449130 | 20241031145844_rBE6q | NZ0051 | 2024-11-02T12:12:08.446Z | 2024-11-03T14:20:49.103Z |
5449040 | 5449040 | 20241031144633_1y8OF | NZ0051 | 2024-11-02T12:12:00.076Z | 2024-11-03T14:20:47.644Z |
5448959 | 5448959 | 20241031143622_i1SyN | NZ0051 | 2024-11-02T12:11:53.138Z | 2024-11-03T14:20:45.554Z |
5448945 | 5448945 | 20241031143448_js5E3 | NZ0051 | 2024-11-02T12:11:50.855Z | 2024-11-03T14:20:45.143Z |
5448848 | 5448848 | 20241031142325_12GiY | NZ0051 | 2024-11-02T12:11:33.671Z | 2024-11-03T14:20:43.415Z |
5448748 | 5448748 | 20241031141240_vx82F | NZ0051 | 2024-11-02T12:11:23.624Z | 2024-11-03T14:20:41.871Z |
5448682 | 5448682 | 20241031140519_WulVD | NZ0051 | 2024-11-02T12:11:18.498Z | 2024-11-03T14:20:41.252Z |
5448669 | 5448669 | 20241031140300_OdA4Y | NZ0051 | 2024-11-02T12:11:16.785Z | 2024-11-03T14:20:41.117Z |
5448643 | 5448643 | 20241031140015_1pQVg | NZ0051 | 2024-11-02T12:11:14.184Z | 2024-11-03T14:20:40.571Z |
5448613 | 5448613 | 20241031135412_NP9vY | NZ0051 | 2024-11-02T12:11:11.185Z | 2024-11-03T14:20:40.204Z |
5448454 | 5448454 | 20241031133320_jp9uX | NZ0051 | 2024-11-02T12:10:47.520Z | 2024-11-03T14:20:37.923Z |
5448324 | 5448324 | 20241031131531_BecVx | NZ0051 | 2024-11-02T12:10:33.023Z | 2024-11-03T14:20:35.513Z |
5448319 | 5448319 | 20241031131337_f6OBk | NZ0051 | 2024-11-02T12:10:32.479Z | 2024-11-03T14:20:35.504Z |
5448205 | 5448205 | 20241031125842_expEE | NZ0051 | 2024-11-02T12:10:15.977Z | 2024-11-03T14:20:34.144Z |
5448166 | 5448166 | 20241031125111_d2hnw | NZ0051 | 2024-11-02T12:10:08.725Z | 2024-11-03T14:20:33.754Z |
5448164 | 5448164 | 20241031125019_qm2z0 | NZ0051 | 2024-11-02T12:10:08.542Z | 2024-11-03T14:20:33.753Z |
5448005 | 5448005 | 20241031123205_SFPfC | NZ0051 | 2024-11-02T12:09:43.202Z | 2024-11-03T14:20:31.456Z |
5447970 | 5447970 | 20241031122803_Sa2sh | NZ0051 | 2024-11-02T12:09:32.686Z | 2024-11-03T14:20:30.886Z |
5447941 | 5447941 | 20241031122450_IWZDt | NZ0051 | 2024-11-02T12:09:28.237Z | 2024-11-03T14:20:30.620Z |
5447904 | 5447904 | 20241031122208_lQ4f3 | NZ0051 | 2024-11-02T12:09:24.583Z | 2024-11-03T14:20:30.115Z |
5447845 | 5447845 | 20241031121632_kJO3Y | NZ0051 | 2024-11-02T12:09:17.082Z | 2024-11-03T14:20:29.426Z |
5447752 | 5447752 | 20241031120833_NExrX | NZ0051 | 2024-11-02T12:09:02.120Z | 2024-11-03T14:20:27.883Z |
5447599 | 5447599 | 20241031115457_9KBrX | NZ0051 | 2024-11-02T12:08:33.818Z | 2024-11-03T14:20:24.971Z |
5447542 | 5447542 | 20241031115131_Sq36I | NZ0051 | 2024-11-02T12:08:25.129Z | 2024-11-03T14:20:23.944Z |
5447420 | 5447420 | 20241031113947_9JICh | NZ0051 | 2024-11-02T12:08:07.453Z | 2024-11-03T14:20:21.967Z |
5447334 | 5447334 | 20241031113146_Vx3kH | NZ0051 | 2024-11-02T12:07:47.660Z | 2024-11-03T14:20:20.830Z |
5447290 | 5447290 | 20241031112727_HsziF | NZ0051 | 2024-11-02T12:07:42.709Z | 2024-11-03T14:20:20.486Z |
5447149 | 5447149 | 20241031111303_9Eh1w | NZ0051 | 2024-11-02T12:07:23.346Z | 2024-11-03T14:20:16.741Z |
5447083 | 5447083 | 20241031110711_KGgSn | NZ0051 | 2024-11-02T12:07:14.061Z | 2024-11-03T14:20:15.528Z |
5446719 | 5446719 | 20241031102552_Tba64 | NZ0051 | 2024-11-02T12:06:06.832Z | 2024-11-03T14:20:06.357Z |
5446302 | 5446302 | 20241031094620_69MzS | NZ0051 | 2024-11-02T12:04:48.766Z | 2024-11-03T14:19:59.851Z |
5437835 | 5437835 | 20241030154911_w3zXQ | NZ0051 | 2024-11-01T12:10:26.344Z | 2024-11-03T14:22:40.653Z |
5437631 | 5437631 | 20241030153033_iP6AR | NZ0051 | 2024-11-01T12:10:07.321Z | 2024-11-03T14:22:40.164Z |
5437543 | 5437543 | 20241030151810_f2bnO | NZ0051 | 2024-11-01T12:09:58.409Z | 2024-11-03T14:22:39.901Z |
5437517 | 5437517 | 20241030151630_sxkLh | NZ0051 | 2024-11-01T12:09:56.402Z | 2024-11-03T14:22:39.805Z |
5437319 | 5437319 | 20241030145423_iFiT4 | NZ0051 | 2024-11-01T12:09:23.882Z | 2024-11-03T14:22:39.152Z |
5437258 | 5437258 | 20241030144829_3GR96 | NZ0051 | 2024-11-01T12:09:18.164Z | 2024-11-03T14:22:38.949Z |
5437195 | 5437195 | 20241030143958_n2g2p | NZ0051 | 2024-11-01T12:09:13.311Z | 2024-11-03T14:22:38.857Z |
5437168 | 5437168 | 20241030143617_NKNp3 | NZ0051 | 2024-11-01T12:09:11.549Z | 2024-11-03T14:22:38.803Z |
5437159 | 5437159 | 20241030143516_gess4 | NZ0051 | 2024-11-01T12:09:10.531Z | 2024-11-03T14:22:38.772Z |
5437134 | 5437134 | 20241030143134_glBYj | NZ0051 | 2024-11-01T12:09:06.106Z | 2024-11-03T14:22:38.686Z |
5437068 | 5437068 | 20241030142429_D8gEw | NZ0051 | 2024-11-01T12:08:49.207Z | 2024-11-03T14:22:38.479Z |
5437055 | 5437055 | 20241030142343_HvFjY | NZ0051 | 2024-11-01T12:08:48.570Z | 2024-11-03T14:22:38.458Z |
5437006 | 5437006 | 20241030141717_5AeHW | NZ0051 | 2024-11-01T12:08:42.139Z | 2024-11-03T14:22:38.267Z |
5436975 | 5436975 | 20241030141157_9foaM | NZ0051 | 2024-11-01T12:08:38.995Z | 2024-11-03T14:22:38.169Z |
5436907 | 5436907 | 20241030140409_CkpTe | NZ0051 | 2024-11-01T12:08:34.699Z | 2024-11-03T14:22:38.045Z |
5436845 | 5436845 | 20241030135518_rZgRD | NZ0051 | 2024-11-01T12:08:27.580Z | 2024-11-03T14:22:37.867Z |
5436739 | 5436739 | 20241030134323_PPJvA | NZ0051 | 2024-11-01T12:08:09.091Z | 2024-11-03T14:22:37.597Z |
5436700 | 5436700 | 20241030133805_6V4K6 | NZ0051 | 2024-11-01T12:08:06.239Z | 2024-11-03T14:22:37.503Z |
5436652 | 5436652 | 20241030133058_yE1v3 | NZ0051 | 2024-11-01T12:08:01.063Z | 2024-11-03T14:22:37.395Z |
5436620 | 5436620 | 20241030132835_dkmGS | NZ0051 | 2024-11-01T12:07:58.404Z | 2024-11-03T14:22:37.295Z |
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);