participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,692 rows where station_code = "NZ0045" 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 |
---|---|---|---|---|---|
5494089 | 5494089 | 20241107153303_21rzT | NZ0045 | 2024-11-08T14:05:21.938Z | 2024-11-09T14:16:27.840Z |
5493927 | 5493927 | 20241107143818_k5tUa | NZ0045 | 2024-11-08T14:04:56.718Z | 2024-11-09T14:16:27.778Z |
5493909 | 5493909 | 20241107143128_G6dtT | NZ0045 | 2024-11-08T14:04:51.672Z | 2024-11-09T14:16:27.770Z |
5493875 | 5493875 | 20241107142433_wfbNx | NZ0045 | 2024-11-08T14:04:48.413Z | 2024-11-09T14:16:27.762Z |
5493811 | 5493811 | 20241107135551_tuNP2 | NZ0045 | 2024-11-08T14:04:41.101Z | 2024-11-09T14:16:27.741Z |
5493760 | 5493760 | 20241107132401_EAT5o | NZ0045 | 2024-11-08T14:04:35.907Z | 2024-11-09T14:16:27.719Z |
5493724 | 5493724 | 20241107131055_606jS | NZ0045 | 2024-11-08T14:04:32.130Z | 2024-11-09T14:16:27.704Z |
5493713 | 5493713 | 20241107131028_JoOUu | NZ0045 | 2024-11-08T14:04:31.742Z | 2024-11-09T14:16:27.702Z |
5493693 | 5493693 | 20241107130318_9oCsd | NZ0045 | 2024-11-08T14:04:30.195Z | 2024-11-09T14:16:27.696Z |
5493688 | 5493688 | 20241107130145_TTNmD | NZ0045 | 2024-11-08T14:04:29.821Z | 2024-11-09T14:16:27.696Z |
5493685 | 5493685 | 20241107130124_k73UC | NZ0045 | 2024-11-08T14:04:29.617Z | 2024-11-09T14:16:27.695Z |
5493669 | 5493669 | 20241107125812_wPnzL | NZ0045 | 2024-11-08T14:04:27.793Z | 2024-11-09T14:16:27.688Z |
5493630 | 5493630 | 20241107124735_38Rgc | NZ0045 | 2024-11-08T14:04:22.091Z | 2024-11-09T14:16:27.676Z |
5493615 | 5493615 | 20241107124501_APsG8 | NZ0045 | 2024-11-08T14:04:18.439Z | 2024-11-09T14:16:27.673Z |
5493549 | 5493549 | 20241107123213_P1xdr | NZ0045 | 2024-11-08T14:04:02.481Z | 2024-11-09T14:16:27.652Z |
5493497 | 5493497 | 20241107122300_fCJpK | NZ0045 | 2024-11-08T14:03:53.270Z | 2024-11-09T14:16:27.641Z |
5493359 | 5493359 | 20241107115419_IWfNU | NZ0045 | 2024-11-08T14:03:36.677Z | 2024-11-09T14:16:27.599Z |
5493280 | 5493280 | 20241107113319_7hzkB | NZ0045 | 2024-11-08T14:03:27.591Z | 2024-11-09T14:16:27.575Z |
5493219 | 5493219 | 20241107111904_I0ruc | NZ0045 | 2024-11-08T14:03:11.428Z | 2024-11-09T14:16:27.562Z |
5493209 | 5493209 | 20241107111815_4jowL | NZ0045 | 2024-11-08T14:03:10.177Z | 2024-11-09T14:16:27.561Z |
5493156 | 5493156 | 20241107110931_Q0pf3 | NZ0045 | 2024-11-08T14:02:59.312Z | 2024-11-09T14:16:27.548Z |
5493059 | 5493059 | 20241107104555_5YSy3 | NZ0045 | 2024-11-08T14:02:47.372Z | 2024-11-09T14:16:27.521Z |
5492958 | 5492958 | 20241107102541_XD3T0 | NZ0045 | 2024-11-08T14:02:38.271Z | 2024-11-09T14:16:27.497Z |
5492760 | 5492760 | 20241107095220_8lhsQ | NZ0045 | 2024-11-08T14:02:02.709Z | 2024-11-09T14:16:27.448Z |
5492610 | 5492610 | 20241107091608_vsp5z | NZ0045 | 2024-11-08T14:01:33.425Z | 2024-11-09T14:16:27.412Z |
5492561 | 5492561 | 20241107090232_PIyBt | NZ0045 | 2024-11-08T14:01:25.533Z | 2024-11-09T14:16:27.401Z |
5473724 | 5473724 | 20241103145512_xEz1v | NZ0045 | 2024-11-05T14:09:34.275Z | 2024-11-09T14:21:40.658Z |
5473616 | 5473616 | 20241103143957_oR99c | NZ0045 | 2024-11-05T14:09:13.464Z | 2024-11-09T14:21:39.924Z |
5473271 | 5473271 | 20241103135254_RZStV | NZ0045 | 2024-11-05T14:08:44.114Z | 2024-11-09T14:21:37.466Z |
5473082 | 5473082 | 20241103132629_wJUjv | NZ0045 | 2024-11-05T14:08:13.084Z | 2024-11-09T14:21:36.946Z |
5473063 | 5473063 | 20241103132146_cly7a | NZ0045 | 2024-11-05T14:08:08.667Z | 2024-11-09T14:21:36.844Z |
5473055 | 5473055 | 20241103131935_oAkRF | NZ0045 | 2024-11-05T14:08:07.655Z | 2024-11-09T14:21:36.820Z |
5472876 | 5472876 | 20241103125526_BkKZF | NZ0045 | 2024-11-05T14:07:49.200Z | 2024-11-09T14:21:35.464Z |
5472028 | 5472028 | 20241104132835_TY7wa | NZ0045 | 2024-11-05T14:05:00.363Z | 2024-11-09T14:20:35.910Z |
5465290 | 5465290 | 20241103111924_CRzw0 | NZ0045 | 2024-11-04T14:03:15.480Z | 2024-11-09T14:21:31.775Z |
5465226 | 5465226 | 20241103110434_A2HYW | NZ0045 | 2024-11-04T14:03:06.510Z | 2024-11-09T14:21:31.381Z |
5465156 | 5465156 | 20241103105153_3iIlR | NZ0045 | 2024-11-04T14:02:58.237Z | 2024-11-09T14:21:31.125Z |
5465000 | 5465000 | 20241103101657_upKjB | NZ0045 | 2024-11-04T14:02:26.572Z | 2024-11-09T14:21:30.127Z |
5464638 | 5464638 | 20241103083948_2sCdH | NZ0045 | 2024-11-04T14:01:11.130Z | 2024-11-09T14:21:27.371Z |
5461091 | 5461091 | 20241101155123_9XI4Y | NZ0045 | 2024-11-03T14:14:42.728Z | 2024-11-09T14:23:26.899Z |
5461055 | 5461055 | 20241101154212_6rtaR | NZ0045 | 2024-11-03T14:14:41.033Z | 2024-11-09T14:23:26.818Z |
5461051 | 5461051 | 20241101154128_zW33u | NZ0045 | 2024-11-03T14:14:40.885Z | 2024-11-09T14:23:26.812Z |
5461011 | 5461011 | 20241101153258_XZPW7 | NZ0045 | 2024-11-03T14:14:38.985Z | 2024-11-09T14:23:26.553Z |
5461007 | 5461007 | 20241101153246_hcqyv | NZ0045 | 2024-11-03T14:14:38.629Z | 2024-11-09T14:23:26.538Z |
5460994 | 5460994 | 20241101153112_n1XkE | NZ0045 | 2024-11-03T14:14:38.112Z | 2024-11-09T14:23:26.255Z |
5460978 | 5460978 | 20241101153007_2yk6p | NZ0045 | 2024-11-03T14:14:37.663Z | 2024-11-09T14:23:26.197Z |
5460973 | 5460973 | 20241101152930_GSOfO | NZ0045 | 2024-11-03T14:14:37.536Z | 2024-11-09T14:23:26.195Z |
5460936 | 5460936 | 20241101152302_PkZCf | NZ0045 | 2024-11-03T14:14:35.108Z | 2024-11-09T14:23:25.862Z |
5460860 | 5460860 | 20241101151259_NxOQk | NZ0045 | 2024-11-03T14:14:31.736Z | 2024-11-09T14:23:25.727Z |
5460713 | 5460713 | 20241101145547_IFU2T | NZ0045 | 2024-11-03T14:14:16.745Z | 2024-11-09T14:23:24.855Z |
5460708 | 5460708 | 20241101145528_4YPI3 | NZ0045 | 2024-11-03T14:14:16.324Z | 2024-11-09T14:23:24.852Z |
5460637 | 5460637 | 20241101144040_RXJQm | NZ0045 | 2024-11-03T14:14:06.358Z | 2024-11-09T14:23:24.678Z |
5460559 | 5460559 | 20241101143025_DvbXH | NZ0045 | 2024-11-03T14:13:58.979Z | 2024-11-09T14:23:24.548Z |
5460506 | 5460506 | 20241101142400_YKS2W | NZ0045 | 2024-11-03T14:13:53.161Z | 2024-11-09T14:23:24.355Z |
5460468 | 5460468 | 20241101141438_ugjn3 | NZ0045 | 2024-11-03T14:13:47.036Z | 2024-11-09T14:23:24.301Z |
5460459 | 5460459 | 20241101141301_GUO3D | NZ0045 | 2024-11-03T14:13:46.076Z | 2024-11-09T14:23:24.290Z |
5460439 | 5460439 | 20241101141017_I4qe2 | NZ0045 | 2024-11-03T14:13:44.409Z | 2024-11-09T14:23:24.197Z |
5460410 | 5460410 | 20241101140349_W2cwX | NZ0045 | 2024-11-03T14:13:42.421Z | 2024-11-09T14:23:23.911Z |
5460342 | 5460342 | 20241101135257_e5Od8 | NZ0045 | 2024-11-03T14:13:37.250Z | 2024-11-09T14:23:23.560Z |
5460294 | 5460294 | 20241101133737_sVi6L | NZ0045 | 2024-11-03T14:13:33.771Z | 2024-11-09T14:23:23.294Z |
5460269 | 5460269 | 20241101132534_wfX83 | NZ0045 | 2024-11-03T14:13:31.694Z | 2024-11-09T14:23:23.255Z |
5460249 | 5460249 | 20241101132125_qXYBq | NZ0045 | 2024-11-03T14:13:30.925Z | 2024-11-09T14:23:23.217Z |
5460243 | 5460243 | 20241101132124_2H1n3 | NZ0045 | 2024-11-03T14:13:30.734Z | 2024-11-09T14:23:23.199Z |
5460214 | 5460214 | 20241101131052_8rnJ9 | NZ0045 | 2024-11-03T14:13:28.149Z | 2024-11-09T14:23:22.784Z |
5460172 | 5460172 | 20241101130132_TQoJG | NZ0045 | 2024-11-03T14:13:26.186Z | 2024-11-09T14:23:22.533Z |
5460148 | 5460148 | 20241101125604_u3Jlp | NZ0045 | 2024-11-03T14:13:24.815Z | 2024-11-09T14:23:22.524Z |
5460103 | 5460103 | 20241101124324_WctV5 | NZ0045 | 2024-11-03T14:13:21.109Z | 2024-11-09T14:23:22.205Z |
5460007 | 5460007 | 20241101122847_zceQD | NZ0045 | 2024-11-03T14:13:05.886Z | 2024-11-09T14:23:21.984Z |
5459958 | 5459958 | 20241101122254_UO8Le | NZ0045 | 2024-11-03T14:12:57.542Z | 2024-11-09T14:23:21.468Z |
5458795 | 5458795 | 20241101091913_uSSod | NZ0045 | 2024-11-03T14:10:37.878Z | 2024-11-09T14:23:14.533Z |
5458732 | 5458732 | 20241101090750_ABFgg | NZ0045 | 2024-11-03T14:10:32.106Z | 2024-11-09T14:23:14.043Z |
5458559 | 5458559 | 20241101084249_t3bNy | NZ0045 | 2024-11-03T14:09:58.495Z | 2024-11-09T14:23:12.851Z |
5458487 | 5458487 | 20241101083456_WuhJL | NZ0045 | 2024-11-03T14:09:50.570Z | 2024-11-09T14:23:12.479Z |
5458080 | 5458080 | 20241102161324_A3jPd | NZ0045 | 2024-11-03T14:08:45.782Z | 2024-11-09T14:22:49.495Z |
5458038 | 5458038 | 20241102160151_d8sB2 | NZ0045 | 2024-11-03T14:08:35.724Z | 2024-11-09T14:22:49.407Z |
5458007 | 5458007 | 20241102155706_L20RQ | NZ0045 | 2024-11-03T14:08:32.311Z | 2024-11-09T14:22:49.360Z |
5457982 | 5457982 | 20241102155300_QBtvy | NZ0045 | 2024-11-03T14:08:29.458Z | 2024-11-09T14:22:49.321Z |
5457921 | 5457921 | 20241102154003_dwBKN | NZ0045 | 2024-11-03T14:08:20.996Z | 2024-11-09T14:22:49.088Z |
5457913 | 5457913 | 20241102153904_m811I | NZ0045 | 2024-11-03T14:08:20.364Z | 2024-11-09T14:22:49.064Z |
5457890 | 5457890 | 20241102153459_BEpYC | NZ0045 | 2024-11-03T14:08:18.548Z | 2024-11-09T14:22:49.029Z |
5457857 | 5457857 | 20241102153007_SrxYn | NZ0045 | 2024-11-03T14:08:16.366Z | 2024-11-09T14:22:48.973Z |
5457844 | 5457844 | 20241102152926_XHf3m | NZ0045 | 2024-11-03T14:08:15.801Z | 2024-11-09T14:22:48.969Z |
5457833 | 5457833 | 20241102152905_UgE7i | NZ0045 | 2024-11-03T14:08:15.162Z | 2024-11-09T14:22:48.966Z |
5457792 | 5457792 | 20241102152343_h095y | NZ0045 | 2024-11-03T14:08:11.161Z | 2024-11-09T14:22:48.825Z |
5457762 | 5457762 | 20241102152158_9JLSS | NZ0045 | 2024-11-03T14:08:01.251Z | 2024-11-09T14:22:48.661Z |
5457757 | 5457757 | 20241102152121_YG4fJ | NZ0045 | 2024-11-03T14:07:59.747Z | 2024-11-09T14:22:48.657Z |
5457649 | 5457649 | 20241102150224_XoOgf | NZ0045 | 2024-11-03T14:07:46.441Z | 2024-11-09T14:22:48.335Z |
5457636 | 5457636 | 20241102145917_CDDKK | NZ0045 | 2024-11-03T14:07:45.618Z | 2024-11-09T14:22:48.309Z |
5457579 | 5457579 | 20241102144851_ZrS5o | NZ0045 | 2024-11-03T14:07:41.430Z | 2024-11-09T14:22:48.205Z |
5457567 | 5457567 | 20241102144750_JqBfS | NZ0045 | 2024-11-03T14:07:40.173Z | 2024-11-09T14:22:48.185Z |
5457525 | 5457525 | 20241102144002_1MQYq | NZ0045 | 2024-11-03T14:07:35.791Z | 2024-11-09T14:22:48.085Z |
5457508 | 5457508 | 20241102143925_Cr90B | NZ0045 | 2024-11-03T14:07:34.838Z | 2024-11-09T14:22:48.048Z |
5457425 | 5457425 | 20241102142849_1njXB | NZ0045 | 2024-11-03T14:07:17.474Z | 2024-11-09T14:22:47.702Z |
5457392 | 5457392 | 20241102142258_jjoS1 | NZ0045 | 2024-11-03T14:07:12.854Z | 2024-11-09T14:22:47.567Z |
5457332 | 5457332 | 20241102141223_EFJfo | NZ0045 | 2024-11-03T14:07:08.267Z | 2024-11-09T14:22:47.460Z |
5457181 | 5457181 | 20241102134329_Uwyjf | NZ0045 | 2024-11-03T14:06:43.198Z | 2024-11-09T14:22:46.882Z |
5457146 | 5457146 | 20241102133843_MEd8q | NZ0045 | 2024-11-03T14:06:39.285Z | 2024-11-09T14:22:46.841Z |
5457004 | 5457004 | 20241102131307_fkccZ | NZ0045 | 2024-11-03T14:06:21.393Z | 2024-11-09T14:22:46.389Z |
5457001 | 5457001 | 20241102131306_HExOn | NZ0045 | 2024-11-03T14:06:20.978Z | 2024-11-09T14:22:46.388Z |
5456993 | 5456993 | 20241102131119_r9T5U | NZ0045 | 2024-11-03T14:06:19.829Z | 2024-11-09T14:22:46.343Z |
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);