participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,519 rows where station_code = "NZ0032" 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 |
---|---|---|---|---|---|
5493987 | 5493987 | 20241107150452_huW9q | NZ0032 | 2024-11-08T14:05:12.659Z | 2024-11-09T14:16:27.803Z |
5493968 | 5493968 | 20241107145432_Y2q0g | NZ0032 | 2024-11-08T14:05:07.036Z | 2024-11-09T14:16:27.794Z |
5493937 | 5493937 | 20241107144224_4Qphq | NZ0032 | 2024-11-08T14:04:59.760Z | 2024-11-09T14:16:27.781Z |
5493926 | 5493926 | 20241107143818_k5tUa | NZ0032 | 2024-11-08T14:04:56.718Z | 2024-11-09T14:16:27.778Z |
5493722 | 5493722 | 20241107131055_606jS | NZ0032 | 2024-11-08T14:04:32.130Z | 2024-11-09T14:16:27.704Z |
5493691 | 5493691 | 20241107130318_9oCsd | NZ0032 | 2024-11-08T14:04:30.195Z | 2024-11-09T14:16:27.696Z |
5493687 | 5493687 | 20241107130145_TTNmD | NZ0032 | 2024-11-08T14:04:29.821Z | 2024-11-09T14:16:27.696Z |
5493569 | 5493569 | 20241107123722_35ui5 | NZ0032 | 2024-11-08T14:04:06.445Z | 2024-11-09T14:16:27.659Z |
5493516 | 5493516 | 20241107122343_G35DV | NZ0032 | 2024-11-08T14:03:56.381Z | 2024-11-09T14:16:27.644Z |
5493279 | 5493279 | 20241107113319_7hzkB | NZ0032 | 2024-11-08T14:03:27.591Z | 2024-11-09T14:16:27.575Z |
5493218 | 5493218 | 20241107111904_I0ruc | NZ0032 | 2024-11-08T14:03:11.428Z | 2024-11-09T14:16:27.562Z |
5493163 | 5493163 | 20241107111140_9PA3E | NZ0032 | 2024-11-08T14:03:00.194Z | 2024-11-09T14:16:27.551Z |
5493132 | 5493132 | 20241107110132_3r7bN | NZ0032 | 2024-11-08T14:02:56.242Z | 2024-11-09T14:16:27.541Z |
5493057 | 5493057 | 20241107104555_5YSy3 | NZ0032 | 2024-11-08T14:02:47.372Z | 2024-11-09T14:16:27.521Z |
5492990 | 5492990 | 20241107103118_Ewhme | NZ0032 | 2024-11-08T14:02:40.678Z | 2024-11-09T14:16:27.503Z |
5492644 | 5492644 | 20241107092336_1tUv6 | NZ0032 | 2024-11-08T14:01:43.427Z | 2024-11-09T14:16:27.419Z |
5492609 | 5492609 | 20241107091608_vsp5z | NZ0032 | 2024-11-08T14:01:33.425Z | 2024-11-09T14:16:27.412Z |
5492603 | 5492603 | 20241107091413_dAwVz | NZ0032 | 2024-11-08T14:01:32.438Z | 2024-11-09T14:16:27.411Z |
5492445 | 5492445 | 20241107083535_0K42Q | NZ0032 | 2024-11-08T14:01:12.121Z | 2024-11-09T14:16:27.375Z |
5473723 | 5473723 | 20241103145512_xEz1v | NZ0032 | 2024-11-05T14:09:34.275Z | 2024-11-09T14:21:40.658Z |
5473615 | 5473615 | 20241103143957_oR99c | NZ0032 | 2024-11-05T14:09:13.463Z | 2024-11-09T14:21:39.924Z |
5473062 | 5473062 | 20241103132146_cly7a | NZ0032 | 2024-11-05T14:08:08.646Z | 2024-11-09T14:21:36.844Z |
5465475 | 5465475 | 20241103121056_BMBtw | NZ0032 | 2024-11-04T14:03:47.466Z | 2024-11-09T14:21:33.565Z |
5465248 | 5465248 | 20241103111156_nGufX | NZ0032 | 2024-11-04T14:03:10.393Z | 2024-11-09T14:21:31.619Z |
5465231 | 5465231 | 20241103110600_Rjknu | NZ0032 | 2024-11-04T14:03:07.563Z | 2024-11-09T14:21:31.395Z |
5465228 | 5465228 | 20241103110440_WyGAc | NZ0032 | 2024-11-04T14:03:07.107Z | 2024-11-09T14:21:31.393Z |
5465224 | 5465224 | 20241103110434_A2HYW | NZ0032 | 2024-11-04T14:03:06.510Z | 2024-11-09T14:21:31.381Z |
5465009 | 5465009 | 20241103102041_UFG92 | NZ0032 | 2024-11-04T14:02:27.917Z | 2024-11-09T14:21:30.156Z |
5464999 | 5464999 | 20241103101657_upKjB | NZ0032 | 2024-11-04T14:02:26.572Z | 2024-11-09T14:21:30.127Z |
5464814 | 5464814 | 20241103092108_5u4z4 | NZ0032 | 2024-11-04T14:01:44.753Z | 2024-11-09T14:21:28.976Z |
5464762 | 5464762 | 20241103090735_Sgb8Z | NZ0032 | 2024-11-04T14:01:36.442Z | 2024-11-09T14:21:28.685Z |
5464739 | 5464739 | 20241103090502_4Y9km | NZ0032 | 2024-11-04T14:01:32.081Z | 2024-11-09T14:21:28.498Z |
5461138 | 5461138 | 20241101160827_ihXAP | NZ0032 | 2024-11-03T14:14:45.325Z | 2024-11-09T14:23:27.126Z |
5461090 | 5461090 | 20241101155123_9XI4Y | NZ0032 | 2024-11-03T14:14:42.728Z | 2024-11-09T14:23:26.899Z |
5461081 | 5461081 | 20241101155018_Z9PMu | NZ0032 | 2024-11-03T14:14:42.304Z | 2024-11-09T14:23:26.896Z |
5461077 | 5461077 | 20241101154834_8ET0C | NZ0032 | 2024-11-03T14:14:42.106Z | 2024-11-09T14:23:26.894Z |
5461053 | 5461053 | 20241101154212_6rtaR | NZ0032 | 2024-11-03T14:14:41.033Z | 2024-11-09T14:23:26.818Z |
5461023 | 5461023 | 20241101153700_pWZ2r | NZ0032 | 2024-11-03T14:14:39.627Z | 2024-11-09T14:23:26.581Z |
5461010 | 5461010 | 20241101153258_XZPW7 | NZ0032 | 2024-11-03T14:14:38.984Z | 2024-11-09T14:23:26.553Z |
5460992 | 5460992 | 20241101153112_n1XkE | NZ0032 | 2024-11-03T14:14:38.112Z | 2024-11-09T14:23:26.255Z |
5460976 | 5460976 | 20241101153007_2yk6p | NZ0032 | 2024-11-03T14:14:37.663Z | 2024-11-09T14:23:26.197Z |
5460946 | 5460946 | 20241101152415_y7xVv | NZ0032 | 2024-11-03T14:14:35.516Z | 2024-11-09T14:23:25.905Z |
5460859 | 5460859 | 20241101151259_NxOQk | NZ0032 | 2024-11-03T14:14:31.736Z | 2024-11-09T14:23:25.727Z |
5460712 | 5460712 | 20241101145547_IFU2T | NZ0032 | 2024-11-03T14:14:16.745Z | 2024-11-09T14:23:24.855Z |
5460598 | 5460598 | 20241101143708_ndLY2 | NZ0032 | 2024-11-03T14:14:01.295Z | 2024-11-09T14:23:24.624Z |
5460530 | 5460530 | 20241101142746_gy6P6 | NZ0032 | 2024-11-03T14:13:55.965Z | 2024-11-09T14:23:24.365Z |
5460409 | 5460409 | 20241101140349_W2cwX | NZ0032 | 2024-11-03T14:13:42.421Z | 2024-11-09T14:23:23.910Z |
5460341 | 5460341 | 20241101135257_e5Od8 | NZ0032 | 2024-11-03T14:13:37.250Z | 2024-11-09T14:23:23.560Z |
5460293 | 5460293 | 20241101133737_sVi6L | NZ0032 | 2024-11-03T14:13:33.771Z | 2024-11-09T14:23:23.294Z |
5460290 | 5460290 | 20241101133646_raXIE | NZ0032 | 2024-11-03T14:13:33.575Z | 2024-11-09T14:23:23.293Z |
5460268 | 5460268 | 20241101132534_wfX83 | NZ0032 | 2024-11-03T14:13:31.694Z | 2024-11-09T14:23:23.255Z |
5460171 | 5460171 | 20241101130132_TQoJG | NZ0032 | 2024-11-03T14:13:26.186Z | 2024-11-09T14:23:22.533Z |
5460006 | 5460006 | 20241101122847_zceQD | NZ0032 | 2024-11-03T14:13:05.886Z | 2024-11-09T14:23:21.984Z |
5459960 | 5459960 | 20241101122409_8hdCA | NZ0032 | 2024-11-03T14:12:58.215Z | 2024-11-09T14:23:21.559Z |
5459913 | 5459913 | 20241101121614_bc3U3 | NZ0032 | 2024-11-03T14:12:49.735Z | 2024-11-09T14:23:21.229Z |
5459826 | 5459826 | 20241101115828_NIMEh | NZ0032 | 2024-11-03T14:12:38.529Z | 2024-11-09T14:23:21.092Z |
5458558 | 5458558 | 20241101084249_t3bNy | NZ0032 | 2024-11-03T14:09:58.495Z | 2024-11-09T14:23:12.851Z |
5458486 | 5458486 | 20241101083456_WuhJL | NZ0032 | 2024-11-03T14:09:50.570Z | 2024-11-09T14:23:12.479Z |
5457996 | 5457996 | 20241102155558_cpvsg | NZ0032 | 2024-11-03T14:08:31.269Z | 2024-11-09T14:22:49.338Z |
5457938 | 5457938 | 20241102154406_DEzCf | NZ0032 | 2024-11-03T14:08:22.386Z | 2024-11-09T14:22:49.109Z |
5457927 | 5457927 | 20241102154052_lxTiR | NZ0032 | 2024-11-03T14:08:21.687Z | 2024-11-09T14:22:49.095Z |
5457889 | 5457889 | 20241102153459_BEpYC | NZ0032 | 2024-11-03T14:08:18.548Z | 2024-11-09T14:22:49.029Z |
5457832 | 5457832 | 20241102152905_UgE7i | NZ0032 | 2024-11-03T14:08:15.162Z | 2024-11-09T14:22:48.966Z |
5457755 | 5457755 | 20241102152121_YG4fJ | NZ0032 | 2024-11-03T14:07:59.747Z | 2024-11-09T14:22:48.657Z |
5457712 | 5457712 | 20241102151456_yUaxz | NZ0032 | 2024-11-03T14:07:53.958Z | 2024-11-09T14:22:48.566Z |
5457647 | 5457647 | 20241102150224_XoOgf | NZ0032 | 2024-11-03T14:07:46.440Z | 2024-11-09T14:22:48.335Z |
5457634 | 5457634 | 20241102145917_CDDKK | NZ0032 | 2024-11-03T14:07:45.618Z | 2024-11-09T14:22:48.309Z |
5457566 | 5457566 | 20241102144750_JqBfS | NZ0032 | 2024-11-03T14:07:40.173Z | 2024-11-09T14:22:48.185Z |
5457506 | 5457506 | 20241102143925_Cr90B | NZ0032 | 2024-11-03T14:07:34.838Z | 2024-11-09T14:22:48.048Z |
5457198 | 5457198 | 20241102134613_XXkGt | NZ0032 | 2024-11-03T14:06:44.751Z | 2024-11-09T14:22:47.038Z |
5457179 | 5457179 | 20241102134329_Uwyjf | NZ0032 | 2024-11-03T14:06:43.198Z | 2024-11-09T14:22:46.882Z |
5457085 | 5457085 | 20241102132901_Ovdqn | NZ0032 | 2024-11-03T14:06:31.631Z | 2024-11-09T14:22:46.596Z |
5456895 | 5456895 | 20241102124433_tdnRX | NZ0032 | 2024-11-03T14:05:54.126Z | 2024-11-09T14:22:45.968Z |
5456825 | 5456825 | 20241102123352_p1Zaa | NZ0032 | 2024-11-03T14:05:45.805Z | 2024-11-09T14:22:45.770Z |
5438027 | 5438027 | 20241030161534_AGtke | NZ0032 | 2024-11-01T12:10:52.873Z | 2024-11-08T14:22:58.722Z |
5437866 | 5437866 | 20241030155410_GuK46 | NZ0032 | 2024-11-01T12:10:33.553Z | 2024-11-08T14:22:58.242Z |
5437861 | 5437861 | 20241030155204_1Bq0R | NZ0032 | 2024-11-01T12:10:32.569Z | 2024-11-08T14:22:58.239Z |
5437766 | 5437766 | 20241030154044_mv4tn | NZ0032 | 2024-11-01T12:10:17.905Z | 2024-11-08T14:22:58.129Z |
5437746 | 5437746 | 20241030153854_tMkSL | NZ0032 | 2024-11-01T12:10:16.698Z | 2024-11-08T14:22:58.111Z |
5437279 | 5437279 | 20241030144948_jLusP | NZ0032 | 2024-11-01T12:09:19.920Z | 2024-11-08T14:22:56.955Z |
5437218 | 5437218 | 20241030144350_mxya0 | NZ0032 | 2024-11-01T12:09:15.289Z | 2024-11-08T14:22:56.771Z |
5437025 | 5437025 | 20241030142159_c6Vg1 | NZ0032 | 2024-11-01T12:08:45.796Z | 2024-11-08T14:22:56.382Z |
5437003 | 5437003 | 20241030141717_5AeHW | NZ0032 | 2024-11-01T12:08:42.139Z | 2024-11-08T14:22:56.078Z |
5436935 | 5436935 | 20241030140712_4BmZ2 | NZ0032 | 2024-11-01T12:08:36.315Z | 2024-11-08T14:22:55.835Z |
5436735 | 5436735 | 20241030134323_PPJvA | NZ0032 | 2024-11-01T12:08:09.091Z | 2024-11-08T14:22:54.807Z |
5436621 | 5436621 | 20241030132835_J5EcE | NZ0032 | 2024-11-01T12:07:58.608Z | 2024-11-08T14:22:54.525Z |
5436377 | 5436377 | 20241030125843_TreLy | NZ0032 | 2024-11-01T12:07:24.621Z | 2024-11-08T14:22:54.001Z |
5436362 | 5436362 | 20241030125743_tMhkY | NZ0032 | 2024-11-01T12:07:23.502Z | 2024-11-08T14:22:53.973Z |
5436288 | 5436288 | 20241030124645_8xLon | NZ0032 | 2024-11-01T12:07:14.113Z | 2024-11-08T14:22:53.744Z |
5436285 | 5436285 | 20241030124634_pyyl6 | NZ0032 | 2024-11-01T12:07:13.732Z | 2024-11-08T14:22:53.643Z |
5436096 | 5436096 | 20241030122730_kkOUO | NZ0032 | 2024-11-01T12:06:46.268Z | 2024-11-08T14:22:52.797Z |
5435740 | 5435740 | 20241030115354_GhxBz | NZ0032 | 2024-11-01T12:05:50.426Z | 2024-11-08T14:22:51.477Z |
5435632 | 5435632 | 20241030114550_z3LWE | NZ0032 | 2024-11-01T12:05:41.564Z | 2024-11-08T14:22:51.320Z |
5435087 | 5435087 | 20241030104905_rdolS | NZ0032 | 2024-11-01T12:04:17.033Z | 2024-11-08T14:22:49.157Z |
5434813 | 5434813 | 20241030101547_0tziB | NZ0032 | 2024-11-01T12:03:27.964Z | 2024-11-08T14:22:47.933Z |
5427987 | 5427987 | 20241028161107_6jD42 | NZ0032 | 2024-10-31T12:14:22.339Z | 2024-11-06T14:27:12.877Z |
5427871 | 5427871 | 20241028155424_8n9Lx | NZ0032 | 2024-10-31T12:14:07.743Z | 2024-11-06T14:27:12.777Z |
5427420 | 5427420 | 20241028150404_5pzQb | NZ0032 | 2024-10-31T12:13:31.258Z | 2024-11-06T14:27:11.735Z |
5427370 | 5427370 | 20241028150039_22Go2 | NZ0032 | 2024-10-31T12:13:28.847Z | 2024-11-06T14:27:11.690Z |
5427302 | 5427302 | 20241028145535_CvRNc | NZ0032 | 2024-10-31T12:13:25.100Z | 2024-11-06T14:27:11.626Z |
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);