participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,997 rows where station_code = "NZ004X" 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 |
---|---|---|---|---|---|
5494090 | 5494090 | 20241107153303_21rzT | NZ004X | 2024-11-08T14:05:21.938Z | 2024-11-08T14:05:21.938Z |
5493929 | 5493929 | 20241107143818_k5tUa | NZ004X | 2024-11-08T14:04:56.718Z | 2024-11-08T14:04:56.718Z |
5493877 | 5493877 | 20241107142433_wfbNx | NZ004X | 2024-11-08T14:04:48.413Z | 2024-11-08T14:04:48.413Z |
5493813 | 5493813 | 20241107135551_tuNP2 | NZ004X | 2024-11-08T14:04:41.101Z | 2024-11-08T14:04:41.101Z |
5493761 | 5493761 | 20241107132401_EAT5o | NZ004X | 2024-11-08T14:04:35.907Z | 2024-11-08T14:04:35.907Z |
5493727 | 5493727 | 20241107131055_606jS | NZ004X | 2024-11-08T14:04:32.130Z | 2024-11-08T14:04:32.130Z |
5493720 | 5493720 | 20241107131033_o7ojP | NZ004X | 2024-11-08T14:04:32.011Z | 2024-11-08T14:04:32.011Z |
5493715 | 5493715 | 20241107131028_JoOUu | NZ004X | 2024-11-08T14:04:31.742Z | 2024-11-08T14:04:31.742Z |
5493695 | 5493695 | 20241107130318_9oCsd | NZ004X | 2024-11-08T14:04:30.195Z | 2024-11-08T14:04:30.195Z |
5493690 | 5493690 | 20241107130145_TTNmD | NZ004X | 2024-11-08T14:04:29.821Z | 2024-11-08T14:04:29.821Z |
5493686 | 5493686 | 20241107130124_k73UC | NZ004X | 2024-11-08T14:04:29.617Z | 2024-11-08T14:04:29.617Z |
5493671 | 5493671 | 20241107125812_wPnzL | NZ004X | 2024-11-08T14:04:27.793Z | 2024-11-08T14:04:27.793Z |
5493631 | 5493631 | 20241107124735_38Rgc | NZ004X | 2024-11-08T14:04:22.091Z | 2024-11-08T14:04:22.091Z |
5493617 | 5493617 | 20241107124501_APsG8 | NZ004X | 2024-11-08T14:04:18.439Z | 2024-11-08T14:04:18.439Z |
5493499 | 5493499 | 20241107122300_fCJpK | NZ004X | 2024-11-08T14:03:53.270Z | 2024-11-08T14:03:53.270Z |
5493360 | 5493360 | 20241107115419_IWfNU | NZ004X | 2024-11-08T14:03:36.677Z | 2024-11-08T14:03:36.677Z |
5493222 | 5493222 | 20241107111904_I0ruc | NZ004X | 2024-11-08T14:03:11.428Z | 2024-11-08T14:03:11.428Z |
5493166 | 5493166 | 20241107111140_9PA3E | NZ004X | 2024-11-08T14:03:00.194Z | 2024-11-08T14:03:00.194Z |
5493157 | 5493157 | 20241107110931_Q0pf3 | NZ004X | 2024-11-08T14:02:59.312Z | 2024-11-08T14:02:59.312Z |
5493061 | 5493061 | 20241107104555_5YSy3 | NZ004X | 2024-11-08T14:02:47.373Z | 2024-11-08T14:02:47.373Z |
5492960 | 5492960 | 20241107102541_XD3T0 | NZ004X | 2024-11-08T14:02:38.271Z | 2024-11-08T14:02:38.271Z |
5492612 | 5492612 | 20241107091608_vsp5z | NZ004X | 2024-11-08T14:01:33.425Z | 2024-11-08T14:01:33.425Z |
5492397 | 5492397 | 20241107082216_YvCm8 | NZ004X | 2024-11-08T14:00:59.690Z | 2024-11-08T14:00:59.690Z |
5487407 | 5487407 | 20241106155848_Yd7s8 | NZ004X | 2024-11-07T14:05:42.130Z | 2024-11-08T14:14:34.515Z |
5487337 | 5487337 | 20241106153843_ZNT7E | NZ004X | 2024-11-07T14:05:33.080Z | 2024-11-08T14:14:34.490Z |
5473618 | 5473618 | 20241103143957_oR99c | NZ004X | 2024-11-05T14:09:13.464Z | 2024-11-08T14:19:17.951Z |
5473500 | 5473500 | 20241103142503_oFwvk | NZ004X | 2024-11-05T14:09:00.845Z | 2024-11-08T14:19:17.152Z |
5473273 | 5473273 | 20241103135254_RZStV | NZ004X | 2024-11-05T14:08:44.114Z | 2024-11-08T14:19:14.788Z |
5473083 | 5473083 | 20241103132629_wJUjv | NZ004X | 2024-11-05T14:08:13.084Z | 2024-11-08T14:19:13.309Z |
5473066 | 5473066 | 20241103132146_cly7a | NZ004X | 2024-11-05T14:08:08.667Z | 2024-11-08T14:19:13.222Z |
5473056 | 5473056 | 20241103131935_oAkRF | NZ004X | 2024-11-05T14:08:07.655Z | 2024-11-08T14:19:13.197Z |
5472877 | 5472877 | 20241103125526_BkKZF | NZ004X | 2024-11-05T14:07:49.200Z | 2024-11-08T14:19:10.989Z |
5465291 | 5465291 | 20241103111924_CRzw0 | NZ004X | 2024-11-04T14:03:15.480Z | 2024-11-08T14:19:06.937Z |
5465158 | 5465158 | 20241103105153_3iIlR | NZ004X | 2024-11-04T14:02:58.237Z | 2024-11-08T14:19:05.501Z |
5465002 | 5465002 | 20241103101657_upKjB | NZ004X | 2024-11-04T14:02:26.572Z | 2024-11-08T14:19:03.421Z |
5461139 | 5461139 | 20241101160827_ihXAP | NZ004X | 2024-11-03T14:14:45.325Z | 2024-11-08T14:21:41.139Z |
5461093 | 5461093 | 20241101155123_9XI4Y | NZ004X | 2024-11-03T14:14:42.728Z | 2024-11-08T14:21:41.003Z |
5461057 | 5461057 | 20241101154212_6rtaR | NZ004X | 2024-11-03T14:14:41.033Z | 2024-11-08T14:21:40.990Z |
5461052 | 5461052 | 20241101154128_zW33u | NZ004X | 2024-11-03T14:14:40.885Z | 2024-11-08T14:21:40.986Z |
5461012 | 5461012 | 20241101153258_XZPW7 | NZ004X | 2024-11-03T14:14:38.985Z | 2024-11-08T14:21:40.909Z |
5460996 | 5460996 | 20241101153112_n1XkE | NZ004X | 2024-11-03T14:14:38.112Z | 2024-11-08T14:21:40.887Z |
5460980 | 5460980 | 20241101153007_2yk6p | NZ004X | 2024-11-03T14:14:37.663Z | 2024-11-08T14:21:40.874Z |
5460974 | 5460974 | 20241101152930_GSOfO | NZ004X | 2024-11-03T14:14:37.536Z | 2024-11-08T14:21:40.873Z |
5460938 | 5460938 | 20241101152302_PkZCf | NZ004X | 2024-11-03T14:14:35.108Z | 2024-11-08T14:21:40.609Z |
5460861 | 5460861 | 20241101151259_NxOQk | NZ004X | 2024-11-03T14:14:31.737Z | 2024-11-08T14:21:40.296Z |
5460715 | 5460715 | 20241101145547_IFU2T | NZ004X | 2024-11-03T14:14:16.745Z | 2024-11-08T14:21:39.453Z |
5458974 | 5458974 | 20241101095141_Z1D6U | NZ004X | 2024-11-03T14:10:53.709Z | 2024-11-08T14:21:28.025Z |
5458796 | 5458796 | 20241101091913_uSSod | NZ004X | 2024-11-03T14:10:37.878Z | 2024-11-08T14:21:26.305Z |
5458733 | 5458733 | 20241101090750_ABFgg | NZ004X | 2024-11-03T14:10:32.106Z | 2024-11-08T14:21:25.957Z |
5458560 | 5458560 | 20241101084249_t3bNy | NZ004X | 2024-11-03T14:09:58.495Z | 2024-11-08T14:21:24.279Z |
5458081 | 5458081 | 20241102161324_A3jPd | NZ004X | 2024-11-03T14:08:45.782Z | 2024-11-08T14:20:42.509Z |
5458039 | 5458039 | 20241102160151_d8sB2 | NZ004X | 2024-11-03T14:08:35.724Z | 2024-11-08T14:20:42.331Z |
5458008 | 5458008 | 20241102155706_L20RQ | NZ004X | 2024-11-03T14:08:32.311Z | 2024-11-08T14:20:42.223Z |
5457915 | 5457915 | 20241102153904_m811I | NZ004X | 2024-11-03T14:08:20.364Z | 2024-11-08T14:20:41.595Z |
5457893 | 5457893 | 20241102153459_BEpYC | NZ004X | 2024-11-03T14:08:18.548Z | 2024-11-08T14:20:41.422Z |
5457845 | 5457845 | 20241102152926_XHf3m | NZ004X | 2024-11-03T14:08:15.801Z | 2024-11-08T14:20:41.380Z |
5457834 | 5457834 | 20241102152905_UgE7i | NZ004X | 2024-11-03T14:08:15.162Z | 2024-11-08T14:20:41.368Z |
5457793 | 5457793 | 20241102152343_h095y | NZ004X | 2024-11-03T14:08:11.161Z | 2024-11-08T14:20:41.277Z |
5457770 | 5457770 | 20241102152213_8wMcP | NZ004X | 2024-11-03T14:08:03.284Z | 2024-11-08T14:20:41.184Z |
5457763 | 5457763 | 20241102152158_9JLSS | NZ004X | 2024-11-03T14:08:01.252Z | 2024-11-08T14:20:41.117Z |
5457651 | 5457651 | 20241102150224_XoOgf | NZ004X | 2024-11-03T14:07:46.441Z | 2024-11-08T14:20:39.995Z |
5457580 | 5457580 | 20241102144851_ZrS5o | NZ004X | 2024-11-03T14:07:41.430Z | 2024-11-08T14:20:39.617Z |
5457569 | 5457569 | 20241102144750_JqBfS | NZ004X | 2024-11-03T14:07:40.173Z | 2024-11-08T14:20:39.562Z |
5457527 | 5457527 | 20241102144002_1MQYq | NZ004X | 2024-11-03T14:07:35.791Z | 2024-11-08T14:20:39.442Z |
5457511 | 5457511 | 20241102143925_Cr90B | NZ004X | 2024-11-03T14:07:34.838Z | 2024-11-08T14:20:39.400Z |
5457426 | 5457426 | 20241102142849_1njXB | NZ004X | 2024-11-03T14:07:17.474Z | 2024-11-08T14:20:39.184Z |
5457393 | 5457393 | 20241102142258_jjoS1 | NZ004X | 2024-11-03T14:07:12.854Z | 2024-11-08T14:20:39.085Z |
5457333 | 5457333 | 20241102141223_EFJfo | NZ004X | 2024-11-03T14:07:08.267Z | 2024-11-08T14:20:38.943Z |
5457312 | 5457312 | 20241102140851_qypTV | NZ004X | 2024-11-03T14:07:06.053Z | 2024-11-08T14:20:38.907Z |
5457225 | 5457225 | 20241102135352_hy7vN | NZ004X | 2024-11-03T14:06:57.321Z | 2024-11-08T14:20:38.333Z |
5457184 | 5457184 | 20241102134329_Uwyjf | NZ004X | 2024-11-03T14:06:43.198Z | 2024-11-08T14:20:38.169Z |
5457148 | 5457148 | 20241102133843_MEd8q | NZ004X | 2024-11-03T14:06:39.285Z | 2024-11-08T14:20:38.082Z |
5457006 | 5457006 | 20241102131307_fkccZ | NZ004X | 2024-11-03T14:06:21.393Z | 2024-11-08T14:20:37.166Z |
5456996 | 5456996 | 20241102131119_r9T5U | NZ004X | 2024-11-03T14:06:19.829Z | 2024-11-08T14:20:37.119Z |
5456873 | 5456873 | 20241102124251_uKvOJ | NZ004X | 2024-11-03T14:05:51.699Z | 2024-11-08T14:20:35.785Z |
5456857 | 5456857 | 20241102124012_Jim5W | NZ004X | 2024-11-03T14:05:49.785Z | 2024-11-08T14:20:35.571Z |
5456828 | 5456828 | 20241102123352_p1Zaa | NZ004X | 2024-11-03T14:05:45.805Z | 2024-11-08T14:20:34.236Z |
5456719 | 5456719 | 20241102120827_Rr9OP | NZ004X | 2024-11-03T14:05:32.847Z | 2024-11-08T14:20:33.068Z |
5449650 | 5449650 | 20241031160409_WZBT3 | NZ004X | 2024-11-02T12:13:16.027Z | 2024-11-08T14:22:19.838Z |
5449570 | 5449570 | 20241031155527_YkmMV | NZ004X | 2024-11-02T12:13:07.266Z | 2024-11-08T14:22:19.666Z |
5449525 | 5449525 | 20241031154746_HhJto | NZ004X | 2024-11-02T12:13:03.533Z | 2024-11-08T14:22:19.583Z |
5449500 | 5449500 | 20241031154501_PKPpg | NZ004X | 2024-11-02T12:13:01.781Z | 2024-11-08T14:22:19.487Z |
5438055 | 5438055 | 20241030161749_untm3 | NZ004X | 2024-11-01T12:10:55.077Z | 2024-11-08T14:22:58.769Z |
5438026 | 5438026 | 20241030161514_WN21s | NZ004X | 2024-11-01T12:10:52.738Z | 2024-11-08T14:22:58.720Z |
5437860 | 5437860 | 20241030155158_0Arm4 | NZ004X | 2024-11-01T12:10:31.960Z | 2024-11-08T14:22:58.239Z |
5437749 | 5437749 | 20241030153854_tMkSL | NZ004X | 2024-11-01T12:10:16.699Z | 2024-11-08T14:22:58.111Z |
5437514 | 5437514 | 20241030151624_uR1Nl | NZ004X | 2024-11-01T12:09:56.016Z | 2024-11-08T14:22:57.396Z |
5437493 | 5437493 | 20241030151325_eqPyf | NZ004X | 2024-11-01T12:09:53.173Z | 2024-11-08T14:22:57.293Z |
5437478 | 5437478 | 20241030151107_wXQQ9 | NZ004X | 2024-11-01T12:09:46.808Z | 2024-11-08T14:22:57.234Z |
5437282 | 5437282 | 20241030144948_jLusP | NZ004X | 2024-11-01T12:09:19.920Z | 2024-11-08T14:22:56.955Z |
5437263 | 5437263 | 20241030144859_RgHt4 | NZ004X | 2024-11-01T12:09:18.525Z | 2024-11-08T14:22:56.796Z |
5437255 | 5437255 | 20241030144817_rvTRr | NZ004X | 2024-11-01T12:09:17.947Z | 2024-11-08T14:22:56.794Z |
5437067 | 5437067 | 20241030142429_D8gEw | NZ004X | 2024-11-01T12:08:49.207Z | 2024-11-08T14:22:56.608Z |
5436956 | 5436956 | 20241030141101_4gKui | NZ004X | 2024-11-01T12:08:38.007Z | 2024-11-08T14:22:55.852Z |
5436738 | 5436738 | 20241030134323_PPJvA | NZ004X | 2024-11-01T12:08:09.091Z | 2024-11-08T14:22:54.807Z |
5436729 | 5436729 | 20241030134155_2oITy | NZ004X | 2024-11-01T12:08:08.412Z | 2024-11-08T14:22:54.804Z |
5436690 | 5436690 | 20241030133735_9NUq3 | NZ004X | 2024-11-01T12:08:05.747Z | 2024-11-08T14:22:54.590Z |
5436487 | 5436487 | 20241030131244_ii5GL | NZ004X | 2024-11-01T12:07:45.341Z | 2024-11-08T14:22:54.135Z |
5435959 | 5435959 | 20241030121328_yJIYt | NZ004X | 2024-11-01T12:06:26.436Z | 2024-11-08T14:22:52.187Z |
5435744 | 5435744 | 20241030115354_GhxBz | NZ004X | 2024-11-01T12:05:50.426Z | 2024-11-08T14:22:51.477Z |
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);