participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,709 rows where station_code = "NZ004D" 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 |
---|---|---|---|---|---|
5494122 | 5494122 | 20241107154131_kZqh9 | NZ004D | 2024-11-08T14:05:24.466Z | 2024-11-08T14:05:24.466Z |
5494093 | 5494093 | 20241107153332_vID8h | NZ004D | 2024-11-08T14:05:22.084Z | 2024-11-08T14:05:22.084Z |
5493905 | 5493905 | 20241107143110_nDiJL | NZ004D | 2024-11-08T14:04:50.990Z | 2024-11-08T14:04:50.990Z |
5493876 | 5493876 | 20241107142433_wfbNx | NZ004D | 2024-11-08T14:04:48.413Z | 2024-11-08T14:04:48.413Z |
5493812 | 5493812 | 20241107135551_tuNP2 | NZ004D | 2024-11-08T14:04:41.101Z | 2024-11-08T14:04:41.101Z |
5493725 | 5493725 | 20241107131055_606jS | NZ004D | 2024-11-08T14:04:32.130Z | 2024-11-08T14:04:32.130Z |
5493714 | 5493714 | 20241107131028_JoOUu | NZ004D | 2024-11-08T14:04:31.742Z | 2024-11-08T14:04:31.742Z |
5493694 | 5493694 | 20241107130318_9oCsd | NZ004D | 2024-11-08T14:04:30.195Z | 2024-11-08T14:04:30.195Z |
5493689 | 5493689 | 20241107130145_TTNmD | NZ004D | 2024-11-08T14:04:29.821Z | 2024-11-08T14:04:29.821Z |
5493670 | 5493670 | 20241107125812_wPnzL | NZ004D | 2024-11-08T14:04:27.793Z | 2024-11-08T14:04:27.793Z |
5493616 | 5493616 | 20241107124501_APsG8 | NZ004D | 2024-11-08T14:04:18.439Z | 2024-11-08T14:04:18.439Z |
5493609 | 5493609 | 20241107124452_66mDI | NZ004D | 2024-11-08T14:04:15.663Z | 2024-11-08T14:04:15.663Z |
5493527 | 5493527 | 20241107122528_2ybyr | NZ004D | 2024-11-08T14:03:58.940Z | 2024-11-08T14:03:58.940Z |
5493498 | 5493498 | 20241107122300_fCJpK | NZ004D | 2024-11-08T14:03:53.270Z | 2024-11-08T14:03:53.270Z |
5493303 | 5493303 | 20241107114508_ssPuR | NZ004D | 2024-11-08T14:03:30.551Z | 2024-11-08T14:03:30.551Z |
5493281 | 5493281 | 20241107113319_7hzkB | NZ004D | 2024-11-08T14:03:27.591Z | 2024-11-08T14:03:27.591Z |
5493220 | 5493220 | 20241107111904_I0ruc | NZ004D | 2024-11-08T14:03:11.428Z | 2024-11-08T14:03:11.428Z |
5493210 | 5493210 | 20241107111815_4jowL | NZ004D | 2024-11-08T14:03:10.177Z | 2024-11-08T14:03:10.177Z |
5493164 | 5493164 | 20241107111140_9PA3E | NZ004D | 2024-11-08T14:03:00.194Z | 2024-11-08T14:03:00.194Z |
5492959 | 5492959 | 20241107102541_XD3T0 | NZ004D | 2024-11-08T14:02:38.271Z | 2024-11-08T14:02:38.271Z |
5492761 | 5492761 | 20241107095220_8lhsQ | NZ004D | 2024-11-08T14:02:02.709Z | 2024-11-08T14:02:02.709Z |
5492611 | 5492611 | 20241107091608_vsp5z | NZ004D | 2024-11-08T14:01:33.425Z | 2024-11-08T14:01:33.425Z |
5492414 | 5492414 | 20241107083011_OdZCx | NZ004D | 2024-11-08T14:01:01.579Z | 2024-11-08T14:01:01.579Z |
5474016 | 5474016 | 20241103153816_PqRmN | NZ004D | 2024-11-05T14:10:00.324Z | 2024-11-08T14:19:19.974Z |
5474008 | 5474008 | 20241103153816_Yd0Vr | NZ004D | 2024-11-05T14:09:59.683Z | 2024-11-08T14:19:19.934Z |
5473681 | 5473681 | 20241103144853_J8lxx | NZ004D | 2024-11-05T14:09:23.398Z | 2024-11-08T14:19:18.341Z |
5473272 | 5473272 | 20241103135254_RZStV | NZ004D | 2024-11-05T14:08:44.114Z | 2024-11-08T14:19:14.788Z |
5473064 | 5473064 | 20241103132146_cly7a | NZ004D | 2024-11-05T14:08:08.667Z | 2024-11-08T14:19:13.222Z |
5465307 | 5465307 | 20241103112147_LL7AH | NZ004D | 2024-11-04T14:03:17.689Z | 2024-11-08T14:19:07.406Z |
5465157 | 5465157 | 20241103105153_3iIlR | NZ004D | 2024-11-04T14:02:58.237Z | 2024-11-08T14:19:05.501Z |
5465137 | 5465137 | 20241103104539_mjiGY | NZ004D | 2024-11-04T14:02:54.935Z | 2024-11-08T14:19:04.809Z |
5465001 | 5465001 | 20241103101657_upKjB | NZ004D | 2024-11-04T14:02:26.572Z | 2024-11-08T14:19:03.421Z |
5464943 | 5464943 | 20241103095739_1nJB1 | NZ004D | 2024-11-04T14:02:15.393Z | 2024-11-08T14:19:02.076Z |
5464639 | 5464639 | 20241103083948_2sCdH | NZ004D | 2024-11-04T14:01:11.134Z | 2024-11-08T14:18:59.805Z |
5460149 | 5460149 | 20241101125604_u3Jlp | NZ004D | 2024-11-03T14:13:24.815Z | 2024-11-08T14:21:37.503Z |
5460136 | 5460136 | 20241101125236_snpKs | NZ004D | 2024-11-03T14:13:23.817Z | 2024-11-08T14:21:37.346Z |
5460122 | 5460122 | 20241101124918_qlC22 | NZ004D | 2024-11-03T14:13:22.449Z | 2024-11-08T14:21:37.267Z |
5460095 | 5460095 | 20241101124238_9R1uA | NZ004D | 2024-11-03T14:13:20.743Z | 2024-11-08T14:21:36.851Z |
5460083 | 5460083 | 20241101123831_WXP11 | NZ004D | 2024-11-03T14:13:19.905Z | 2024-11-08T14:21:36.811Z |
5460067 | 5460067 | 20241101123742_KYlzd | NZ004D | 2024-11-03T14:13:17.854Z | 2024-11-08T14:21:36.596Z |
5460008 | 5460008 | 20241101122847_zceQD | NZ004D | 2024-11-03T14:13:05.886Z | 2024-11-08T14:21:36.103Z |
5459600 | 5459600 | 20241101112203_NVoF9 | NZ004D | 2024-11-03T14:12:21.196Z | 2024-11-08T14:21:32.368Z |
5458683 | 5458683 | 20241101090316_Sw4Ba | NZ004D | 2024-11-03T14:10:27.978Z | 2024-11-08T14:21:25.612Z |
5458069 | 5458069 | 20241102160843_bD9F1 | NZ004D | 2024-11-03T14:08:41.280Z | 2024-11-08T14:20:42.481Z |
5458046 | 5458046 | 20241102160253_J9LuO | NZ004D | 2024-11-03T14:08:36.581Z | 2024-11-08T14:20:42.347Z |
5458004 | 5458004 | 20241102155654_Kpy2Q | NZ004D | 2024-11-03T14:08:31.975Z | 2024-11-08T14:20:42.222Z |
5457983 | 5457983 | 20241102155300_QBtvy | NZ004D | 2024-11-03T14:08:29.458Z | 2024-11-08T14:20:42.096Z |
5457970 | 5457970 | 20241102155108_SF30s | NZ004D | 2024-11-03T14:08:25.464Z | 2024-11-08T14:20:42.003Z |
5457923 | 5457923 | 20241102154003_dwBKN | NZ004D | 2024-11-03T14:08:20.996Z | 2024-11-08T14:20:41.611Z |
5457891 | 5457891 | 20241102153459_BEpYC | NZ004D | 2024-11-03T14:08:18.548Z | 2024-11-08T14:20:41.422Z |
5457838 | 5457838 | 20241102152920_Radzw | NZ004D | 2024-11-03T14:08:15.481Z | 2024-11-08T14:20:41.376Z |
5457663 | 5457663 | 20241102150407_EqPcI | NZ004D | 2024-11-03T14:07:47.802Z | 2024-11-08T14:20:40.055Z |
5457553 | 5457553 | 20241102144530_eHbZ4 | NZ004D | 2024-11-03T14:07:38.670Z | 2024-11-08T14:20:39.483Z |
5457526 | 5457526 | 20241102144002_1MQYq | NZ004D | 2024-11-03T14:07:35.791Z | 2024-11-08T14:20:39.442Z |
5457509 | 5457509 | 20241102143925_Cr90B | NZ004D | 2024-11-03T14:07:34.838Z | 2024-11-08T14:20:39.400Z |
5457499 | 5457499 | 20241102143842_xw2hV | NZ004D | 2024-11-03T14:07:34.368Z | 2024-11-08T14:20:39.393Z |
5457299 | 5457299 | 20241102140702_7qVaC | NZ004D | 2024-11-03T14:07:04.443Z | 2024-11-08T14:20:38.828Z |
5457283 | 5457283 | 20241102140338_KTXIh | NZ004D | 2024-11-03T14:07:02.729Z | 2024-11-08T14:20:38.621Z |
5457182 | 5457182 | 20241102134329_Uwyjf | NZ004D | 2024-11-03T14:06:43.198Z | 2024-11-08T14:20:38.169Z |
5457147 | 5457147 | 20241102133843_MEd8q | NZ004D | 2024-11-03T14:06:39.285Z | 2024-11-08T14:20:38.082Z |
5457143 | 5457143 | 20241102133705_pgj14 | NZ004D | 2024-11-03T14:06:38.303Z | 2024-11-08T14:20:38.052Z |
5457108 | 5457108 | 20241102133201_N9Afq | NZ004D | 2024-11-03T14:06:34.596Z | 2024-11-08T14:20:37.709Z |
5457063 | 5457063 | 20241102132408_nIllQ | NZ004D | 2024-11-03T14:06:28.417Z | 2024-11-08T14:20:37.508Z |
5457005 | 5457005 | 20241102131307_fkccZ | NZ004D | 2024-11-03T14:06:21.393Z | 2024-11-08T14:20:37.166Z |
5457002 | 5457002 | 20241102131306_HExOn | NZ004D | 2024-11-03T14:06:20.978Z | 2024-11-08T14:20:37.164Z |
5456994 | 5456994 | 20241102131119_r9T5U | NZ004D | 2024-11-03T14:06:19.829Z | 2024-11-08T14:20:37.119Z |
5456972 | 5456972 | 20241102130253_0tB5k | NZ004D | 2024-11-03T14:06:13.951Z | 2024-11-08T14:20:36.828Z |
5456947 | 5456947 | 20241102125658_9Ajbr | NZ004D | 2024-11-03T14:06:07.569Z | 2024-11-08T14:20:36.736Z |
5456856 | 5456856 | 20241102124012_Jim5W | NZ004D | 2024-11-03T14:05:49.785Z | 2024-11-08T14:20:35.571Z |
5456827 | 5456827 | 20241102123352_p1Zaa | NZ004D | 2024-11-03T14:05:45.805Z | 2024-11-08T14:20:34.236Z |
5456793 | 5456793 | 20241102122447_itfrg | NZ004D | 2024-11-03T14:05:41.525Z | 2024-11-08T14:20:33.758Z |
5456737 | 5456737 | 20241102121212_KeABw | NZ004D | 2024-11-03T14:05:35.092Z | 2024-11-08T14:20:33.189Z |
5449698 | 5449698 | 20241031160950_gb0dV | NZ004D | 2024-11-02T12:13:22.608Z | 2024-11-08T14:22:19.978Z |
5449649 | 5449649 | 20241031160409_WZBT3 | NZ004D | 2024-11-02T12:13:16.027Z | 2024-11-08T14:22:19.837Z |
5449614 | 5449614 | 20241031160025_Tdftz | NZ004D | 2024-11-02T12:13:12.610Z | 2024-11-08T14:22:19.751Z |
5449587 | 5449587 | 20241031155814_f9aY5 | NZ004D | 2024-11-02T12:13:10.719Z | 2024-11-08T14:22:19.691Z |
5449524 | 5449524 | 20241031154746_HhJto | NZ004D | 2024-11-02T12:13:03.533Z | 2024-11-08T14:22:19.583Z |
5449499 | 5449499 | 20241031154501_PKPpg | NZ004D | 2024-11-02T12:13:01.781Z | 2024-11-08T14:22:19.487Z |
5449241 | 5449241 | 20241031150935_hhBVJ | NZ004D | 2024-11-02T12:12:20.006Z | 2024-11-08T14:22:18.742Z |
5449092 | 5449092 | 20241031145205_Mfi38 | NZ004D | 2024-11-02T12:12:04.502Z | 2024-11-08T14:22:18.386Z |
5449034 | 5449034 | 20241031144533_zCjdn | NZ004D | 2024-11-02T12:11:59.418Z | 2024-11-08T14:22:18.259Z |
5448958 | 5448958 | 20241031143622_i1SyN | NZ004D | 2024-11-02T12:11:53.138Z | 2024-11-08T14:22:18.060Z |
5448859 | 5448859 | 20241031142436_z52PU | NZ004D | 2024-11-02T12:11:34.954Z | 2024-11-08T14:22:17.839Z |
5448847 | 5448847 | 20241031142325_12GiY | NZ004D | 2024-11-02T12:11:33.671Z | 2024-11-08T14:22:17.648Z |
5448696 | 5448696 | 20241031140720_4FV03 | NZ004D | 2024-11-02T12:11:19.953Z | 2024-11-08T14:22:17.164Z |
5438054 | 5438054 | 20241030161749_untm3 | NZ004D | 2024-11-01T12:10:55.077Z | 2024-11-08T14:22:58.769Z |
5437859 | 5437859 | 20241030155158_0Arm4 | NZ004D | 2024-11-01T12:10:31.960Z | 2024-11-08T14:22:58.239Z |
5437819 | 5437819 | 20241030154657_AtHw1 | NZ004D | 2024-11-01T12:10:23.912Z | 2024-11-08T14:22:58.147Z |
5437759 | 5437759 | 20241030153935_3f3Sx | NZ004D | 2024-11-01T12:10:17.274Z | 2024-11-08T14:22:58.114Z |
5437542 | 5437542 | 20241030151810_f2bnO | NZ004D | 2024-11-01T12:09:58.409Z | 2024-11-08T14:22:57.515Z |
5437513 | 5437513 | 20241030151624_uR1Nl | NZ004D | 2024-11-01T12:09:56.016Z | 2024-11-08T14:22:57.396Z |
5437477 | 5437477 | 20241030151107_wXQQ9 | NZ004D | 2024-11-01T12:09:46.808Z | 2024-11-08T14:22:57.234Z |
5437461 | 5437461 | 20241030151007_y2OEl | NZ004D | 2024-11-01T12:09:41.230Z | 2024-11-08T14:22:57.214Z |
5437427 | 5437427 | 20241030150632_hHx71 | NZ004D | 2024-11-01T12:09:34.682Z | 2024-11-08T14:22:57.196Z |
5437142 | 5437142 | 20241030143200_5It3R | NZ004D | 2024-11-01T12:09:08.443Z | 2024-11-08T14:22:56.700Z |
5437075 | 5437075 | 20241030142516_Wm4pW | NZ004D | 2024-11-01T12:08:49.858Z | 2024-11-08T14:22:56.610Z |
5436937 | 5436937 | 20241030140712_4BmZ2 | NZ004D | 2024-11-01T12:08:36.315Z | 2024-11-08T14:22:55.835Z |
5436844 | 5436844 | 20241030135518_rZgRD | NZ004D | 2024-11-01T12:08:27.580Z | 2024-11-08T14:22:55.681Z |
5436380 | 5436380 | 20241030125843_TreLy | NZ004D | 2024-11-01T12:07:24.621Z | 2024-11-08T14:22:54.001Z |
5436121 | 5436121 | 20241030123031_j2jkT | NZ004D | 2024-11-01T12:06:49.457Z | 2024-11-08T14:22:52.891Z |
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);