participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,292 rows where station_code = "NZ000W" 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 |
---|---|---|---|---|---|
5314003 | 5314003 | 20241016110201_6hzQ7 | NZ000W | 2024-10-17T12:01:33.212Z | 2024-10-17T12:01:33.212Z |
5307522 | 5307522 | 20241015102254_qfpT7 | NZ000W | 2024-10-16T12:01:40.710Z | 2024-10-17T12:08:52.972Z |
5298192 | 5298192 | 20241012154655_tyYZL | NZ000W | 2024-10-14T12:10:01.991Z | 2024-10-17T12:15:00.252Z |
5298092 | 5298092 | 20241012152706_QWBrM | NZ000W | 2024-10-14T12:09:52.475Z | 2024-10-17T12:14:59.391Z |
5297963 | 5297963 | 20241012150335_HiM5L | NZ000W | 2024-10-14T12:09:32.280Z | 2024-10-17T12:14:57.840Z |
5297779 | 5297779 | 20241012143455_kNKdN | NZ000W | 2024-10-14T12:09:08.578Z | 2024-10-17T12:14:56.349Z |
5297716 | 5297716 | 20241012142006_wlJW6 | NZ000W | 2024-10-14T12:09:02.497Z | 2024-10-17T12:14:55.305Z |
5297507 | 5297507 | 20241012133831_VWFkt | NZ000W | 2024-10-14T12:08:31.622Z | 2024-10-17T12:14:51.992Z |
5297479 | 5297479 | 20241012133151_eTDpO | NZ000W | 2024-10-14T12:08:29.288Z | 2024-10-17T12:14:51.781Z |
5297179 | 5297179 | 20241012120646_nVyNU | NZ000W | 2024-10-14T12:07:52.700Z | 2024-10-17T12:14:46.598Z |
5290192 | 5290192 | 20241011164253_nmevJ | NZ000W | 2024-10-13T12:12:01.758Z | 2024-10-17T12:17:26.504Z |
5290001 | 5290001 | 20241011162239_mdL73 | NZ000W | 2024-10-13T12:11:47.617Z | 2024-10-17T12:17:25.001Z |
5289893 | 5289893 | 20241011161538_N4bng | NZ000W | 2024-10-13T12:11:37.792Z | 2024-10-17T12:17:23.645Z |
5289787 | 5289787 | 20241011160324_JpxcP | NZ000W | 2024-10-13T12:11:25.357Z | 2024-10-17T12:17:23.147Z |
5289695 | 5289695 | 20241011155515_Jzxlo | NZ000W | 2024-10-13T12:11:15.394Z | 2024-10-17T12:17:22.707Z |
5289687 | 5289687 | 20241011155439_QuZmm | NZ000W | 2024-10-13T12:11:14.405Z | 2024-10-17T12:17:22.680Z |
5289559 | 5289559 | 20241011154226_I2XGn | NZ000W | 2024-10-13T12:11:00.649Z | 2024-10-17T12:17:22.229Z |
5289374 | 5289374 | 20241011152504_kVZsp | NZ000W | 2024-10-13T12:10:40.355Z | 2024-10-17T12:17:21.535Z |
5289233 | 5289233 | 20241011151156_BLhkJ | NZ000W | 2024-10-13T12:10:32.289Z | 2024-10-17T12:17:20.794Z |
5289082 | 5289082 | 20241011145734_c9VrG | NZ000W | 2024-10-13T12:10:23.312Z | 2024-10-17T12:17:20.082Z |
5288938 | 5288938 | 20241011144326_p4QY1 | NZ000W | 2024-10-13T12:10:14.094Z | 2024-10-17T12:17:19.396Z |
5288897 | 5288897 | 20241011144027_5Ki0D | NZ000W | 2024-10-13T12:10:09.206Z | 2024-10-17T12:17:19.341Z |
5288882 | 5288882 | 20241011143840_RlJI4 | NZ000W | 2024-10-13T12:10:07.652Z | 2024-10-17T12:17:19.307Z |
5288866 | 5288866 | 20241011143647_azclX | NZ000W | 2024-10-13T12:10:06.187Z | 2024-10-17T12:17:19.193Z |
5288693 | 5288693 | 20241011141932_32P0f | NZ000W | 2024-10-13T12:09:46.040Z | 2024-10-17T12:17:18.364Z |
5288688 | 5288688 | 20241011141834_qI0Xy | NZ000W | 2024-10-13T12:09:44.962Z | 2024-10-17T12:17:18.350Z |
5288621 | 5288621 | 20241011141405_T4Yl1 | NZ000W | 2024-10-13T12:09:36.520Z | 2024-10-17T12:17:18.035Z |
5288569 | 5288569 | 20241011140941_O6wMK | NZ000W | 2024-10-13T12:09:27.379Z | 2024-10-17T12:17:17.631Z |
5288232 | 5288232 | 20241011132521_K5WrO | NZ000W | 2024-10-13T12:09:04.220Z | 2024-10-17T12:17:15.817Z |
5288177 | 5288177 | 20241011131509_ecoL6 | NZ000W | 2024-10-13T12:09:00.762Z | 2024-10-17T12:17:15.721Z |
5288164 | 5288164 | 20241011131115_HY6Kn | NZ000W | 2024-10-13T12:08:59.410Z | 2024-10-17T12:17:15.660Z |
5288142 | 5288142 | 20241011130823_T5GiM | NZ000W | 2024-10-13T12:08:57.446Z | 2024-10-17T12:17:15.420Z |
5288057 | 5288057 | 20241011124852_KslXJ | NZ000W | 2024-10-13T12:08:34.880Z | 2024-10-17T12:17:14.850Z |
5287910 | 5287910 | 20241011122709_GOt2e | NZ000W | 2024-10-13T12:08:17.040Z | 2024-10-17T12:17:12.825Z |
5280501 | 5280501 | 20241010161430_AVaQb | NZ000W | 2024-10-12T12:12:32.378Z | 2024-10-17T12:18:45.691Z |
5280494 | 5280494 | 20241010161419_22fxw | NZ000W | 2024-10-12T12:12:32.200Z | 2024-10-17T12:18:45.691Z |
5280480 | 5280480 | 20241010161236_hAESi | NZ000W | 2024-10-12T12:12:30.932Z | 2024-10-17T12:18:45.639Z |
5280237 | 5280237 | 20241010155211_8ed4C | NZ000W | 2024-10-12T12:12:07.654Z | 2024-10-17T12:18:44.904Z |
5279988 | 5279988 | 20241010153507_wrSiS | NZ000W | 2024-10-12T12:11:42.186Z | 2024-10-17T12:18:43.791Z |
5279880 | 5279880 | 20241010152600_36bfQ | NZ000W | 2024-10-12T12:11:30.816Z | 2024-10-17T12:18:42.914Z |
5279865 | 5279865 | 20241010152410_0qrE7 | NZ000W | 2024-10-12T12:11:27.566Z | 2024-10-17T12:18:42.865Z |
5279476 | 5279476 | 20241010144330_ap3uU | NZ000W | 2024-10-12T12:10:56.930Z | 2024-10-17T12:18:41.682Z |
5279451 | 5279451 | 20241010144106_y93Bc | NZ000W | 2024-10-12T12:10:55.284Z | 2024-10-17T12:18:41.559Z |
5279442 | 5279442 | 20241010144033_5BfDt | NZ000W | 2024-10-12T12:10:54.542Z | 2024-10-17T12:18:41.524Z |
5279381 | 5279381 | 20241010143327_L0CS3 | NZ000W | 2024-10-12T12:10:46.493Z | 2024-10-17T12:18:41.343Z |
5279288 | 5279288 | 20241010142331_9hXp3 | NZ000W | 2024-10-12T12:10:28.210Z | 2024-10-17T12:18:40.913Z |
5279097 | 5279097 | 20241010140030_20RUt | NZ000W | 2024-10-12T12:10:09.564Z | 2024-10-17T12:18:39.977Z |
5278777 | 5278777 | 20241010132112_ihvc2 | NZ000W | 2024-10-12T12:09:34.664Z | 2024-10-17T12:18:38.488Z |
5278716 | 5278716 | 20241010131146_h2LpM | NZ000W | 2024-10-12T12:09:27.162Z | 2024-10-17T12:18:38.310Z |
5278652 | 5278652 | 20241010130413_uVFSq | NZ000W | 2024-10-12T12:09:20.817Z | 2024-10-17T12:18:37.957Z |
5278270 | 5278270 | 20241011100331_sbI3V | NZ000W | 2024-10-12T12:05:38.102Z | 2024-10-17T12:16:58.581Z |
5278170 | 5278170 | 20241011094959_3jCDx | NZ000W | 2024-10-12T12:05:24.548Z | 2024-10-17T12:16:57.390Z |
5271646 | 5271646 | 20241010122229_4vqsy | NZ000W | 2024-10-11T12:07:22.056Z | 2024-10-17T12:18:36.292Z |
5271305 | 5271305 | 20241010113927_Bxzpy | NZ000W | 2024-10-11T12:06:31.576Z | 2024-10-17T12:18:33.220Z |
5271271 | 5271271 | 20241010113527_tKaa5 | NZ000W | 2024-10-11T12:06:29.046Z | 2024-10-17T12:18:33.115Z |
5270375 | 5270375 | 20241010093029_J6v3y | NZ000W | 2024-10-11T12:04:17.690Z | 2024-10-17T12:18:26.452Z |
5266399 | 5266399 | 20241008145938_mIyRF | NZ000W | 2024-10-10T12:11:43.848Z | 2024-10-17T12:20:04.359Z |
5260250 | 5260250 | 20241007155959_WAgtG | NZ000W | 2024-10-09T12:12:12.019Z | 2024-10-16T12:21:10.659Z |
5260208 | 5260208 | 20241007155329_axVQE | NZ000W | 2024-10-09T12:12:06.341Z | 2024-10-16T12:21:10.616Z |
5260139 | 5260139 | 20241007154016_JGeIR | NZ000W | 2024-10-09T12:11:55.216Z | 2024-10-16T12:21:10.351Z |
5260082 | 5260082 | 20241007153121_RrCdI | NZ000W | 2024-10-09T12:11:48.071Z | 2024-10-16T12:21:10.279Z |
5260007 | 5260007 | 20241007152057_Y4tiD | NZ000W | 2024-10-09T12:11:40.498Z | 2024-10-16T12:21:10.218Z |
5259925 | 5259925 | 20241007151039_6OfGe | NZ000W | 2024-10-09T12:11:33.303Z | 2024-10-16T12:21:09.851Z |
5259712 | 5259712 | 20241007143712_P0JrS | NZ000W | 2024-10-09T12:11:21.104Z | 2024-10-16T12:21:09.331Z |
5259547 | 5259547 | 20241007141617_qJK3o | NZ000W | 2024-10-09T12:11:06.254Z | 2024-10-16T12:21:08.830Z |
5259361 | 5259361 | 20241007134933_4FBx3 | NZ000W | 2024-10-09T12:10:40.542Z | 2024-10-16T12:21:08.532Z |
5259267 | 5259267 | 20241007133636_ryZk6 | NZ000W | 2024-10-09T12:10:30.906Z | 2024-10-16T12:21:08.449Z |
5259258 | 5259258 | 20241007133627_skQxh | NZ000W | 2024-10-09T12:10:30.753Z | 2024-10-16T12:21:08.448Z |
5259023 | 5259023 | 20241007124525_KduAu | NZ000W | 2024-10-09T12:10:16.735Z | 2024-10-16T12:21:08.169Z |
5258957 | 5258957 | 20241007123612_F5fEW | NZ000W | 2024-10-09T12:10:13.563Z | 2024-10-16T12:21:08.121Z |
5258948 | 5258948 | 20241007123243_FgWT8 | NZ000W | 2024-10-09T12:10:13.038Z | 2024-10-16T12:21:08.118Z |
5258914 | 5258914 | 20241007122707_iCDHh | NZ000W | 2024-10-09T12:10:10.119Z | 2024-10-16T12:21:07.961Z |
5258805 | 5258805 | 20241007115019_l2RWI | NZ000W | 2024-10-09T12:09:46.251Z | 2024-10-16T12:21:07.598Z |
5258733 | 5258733 | 20241007112726_fX5Tt | NZ000W | 2024-10-09T12:09:37.781Z | 2024-10-16T12:21:07.044Z |
5258639 | 5258639 | 20241007104535_JFPGr | NZ000W | 2024-10-09T12:09:19.567Z | 2024-10-16T12:21:06.234Z |
5258632 | 5258632 | 20241007104156_oFVf8 | NZ000W | 2024-10-09T12:09:18.400Z | 2024-10-16T12:21:06.161Z |
5258628 | 5258628 | 20241007104135_IU91A | NZ000W | 2024-10-09T12:09:18.168Z | 2024-10-16T12:21:06.159Z |
5258495 | 5258495 | 20241008162809_5fBtY | NZ000W | 2024-10-09T12:07:05.219Z | 2024-10-17T12:20:05.915Z |
5258446 | 5258446 | 20241008161301_jHOKB | NZ000W | 2024-10-09T12:06:57.592Z | 2024-10-17T12:20:05.630Z |
5258406 | 5258406 | 20241008160208_ODt9I | NZ000W | 2024-10-09T12:06:53.905Z | 2024-10-17T12:20:05.540Z |
5258294 | 5258294 | 20241008150944_Wn0BJ | NZ000W | 2024-10-09T12:06:42.238Z | 2024-10-17T12:20:04.416Z |
5258256 | 5258256 | 20241008143123_ep6KP | NZ000W | 2024-10-09T12:06:39.831Z | 2024-10-17T12:20:03.398Z |
5258228 | 5258228 | 20241008141742_SvXNw | NZ000W | 2024-10-09T12:06:38.032Z | 2024-10-17T12:20:03.308Z |
5258222 | 5258222 | 20241008141526_1U12E | NZ000W | 2024-10-09T12:06:37.404Z | 2024-10-17T12:20:03.298Z |
5258188 | 5258188 | 20241008134106_e5HsP | NZ000W | 2024-10-09T12:06:34.513Z | 2024-10-17T12:20:03.021Z |
5258172 | 5258172 | 20241008133350_PL2UR | NZ000W | 2024-10-09T12:06:33.247Z | 2024-10-17T12:20:02.997Z |
5258169 | 5258169 | 20241008133051_KM7YX | NZ000W | 2024-10-09T12:06:33.060Z | 2024-10-17T12:20:02.963Z |
5258119 | 5258119 | 20241008124846_3HIkU | NZ000W | 2024-10-09T12:06:28.579Z | 2024-10-17T12:20:02.768Z |
5251934 | 5251934 | 20241006160428_vpeHk | NZ000W | 2024-10-08T12:10:47.091Z | 2024-10-15T12:28:55.783Z |
5251908 | 5251908 | 20241006155443_zwxGM | NZ000W | 2024-10-08T12:10:44.948Z | 2024-10-15T12:28:55.722Z |
5251882 | 5251882 | 20241006154129_pqAjQ | NZ000W | 2024-10-08T12:10:43.340Z | 2024-10-15T12:28:55.323Z |
5251873 | 5251873 | 20241006153755_OwUJ5 | NZ000W | 2024-10-08T12:10:42.756Z | 2024-10-15T12:28:55.317Z |
5251743 | 5251743 | 20241006144335_Zv1bs | NZ000W | 2024-10-08T12:10:33.853Z | 2024-10-15T12:28:54.736Z |
5251722 | 5251722 | 20241006143624_3L19P | NZ000W | 2024-10-08T12:10:32.195Z | 2024-10-15T12:28:54.629Z |
5249419 | 5249419 | 20241007091019_X3K77 | NZ000W | 2024-10-08T12:04:53.942Z | 2024-10-16T12:21:04.030Z |
5242392 | 5242392 | 20241005135908_yBEQo | NZ000W | 2024-10-07T12:12:07.299Z | 2024-10-14T12:24:28.904Z |
5242383 | 5242383 | 20241005135759_scJSD | NZ000W | 2024-10-07T12:12:06.525Z | 2024-10-14T12:24:28.900Z |
5242303 | 5242303 | 20241005134513_D3BFk | NZ000W | 2024-10-07T12:12:00.702Z | 2024-10-14T12:24:28.793Z |
5232396 | 5232396 | 20241004165006_Lqqn5 | NZ000W | 2024-10-06T12:11:53.250Z | 2024-10-13T12:26:19.098Z |
5231777 | 5231777 | 20241004152052_Bffjm | NZ000W | 2024-10-06T12:10:51.081Z | 2024-10-13T12:26:18.286Z |
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);