participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,335 rows where station_code = "NZ002Y" 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 |
---|---|---|---|---|---|
5500030 | 5500030 | 20241108142906_DTiHO | NZ002Y | 2024-11-09T14:05:32.527Z | 2024-11-09T14:05:32.527Z |
5499951 | 5499951 | 20241108141235_MNT03 | NZ002Y | 2024-11-09T14:05:23.468Z | 2024-11-09T14:05:23.468Z |
5499462 | 5499462 | 20241108122240_Y3Mhs | NZ002Y | 2024-11-09T14:04:08.827Z | 2024-11-09T14:04:08.827Z |
5499218 | 5499218 | 20241108113637_GM2Qs | NZ002Y | 2024-11-09T14:03:33.687Z | 2024-11-09T14:03:33.687Z |
5499134 | 5499134 | 20241108111703_6Dq8T | NZ002Y | 2024-11-09T14:03:22.660Z | 2024-11-09T14:03:22.660Z |
5494020 | 5494020 | 20241107151306_36aIz | NZ002Y | 2024-11-08T14:05:16.026Z | 2024-11-09T14:16:27.815Z |
5493997 | 5493997 | 20241107150649_Zny1f | NZ002Y | 2024-11-08T14:05:13.817Z | 2024-11-09T14:16:27.806Z |
5493971 | 5493971 | 20241107145702_FT79b | NZ002Y | 2024-11-08T14:05:08.302Z | 2024-11-09T14:16:27.796Z |
5493957 | 5493957 | 20241107144830_sK29D | NZ002Y | 2024-11-08T14:05:04.045Z | 2024-11-09T14:16:27.788Z |
5493941 | 5493941 | 20241107144315_B1HCS | NZ002Y | 2024-11-08T14:05:01.050Z | 2024-11-09T14:16:27.783Z |
5493940 | 5493940 | 20241107144258_ojw2c | NZ002Y | 2024-11-08T14:05:00.600Z | 2024-11-09T14:16:27.782Z |
5493896 | 5493896 | 20241107142834_8BlMV | NZ002Y | 2024-11-08T14:04:50.090Z | 2024-11-09T14:16:27.768Z |
5493895 | 5493895 | 20241107142817_eZtma | NZ002Y | 2024-11-08T14:04:49.787Z | 2024-11-09T14:16:27.767Z |
5493853 | 5493853 | 20241107141514_lDTgt | NZ002Y | 2024-11-08T14:04:46.036Z | 2024-11-09T14:16:27.756Z |
5493846 | 5493846 | 20241107141126_r4hYU | NZ002Y | 2024-11-08T14:04:44.187Z | 2024-11-09T14:16:27.752Z |
5493818 | 5493818 | 20241107135652_L9IAT | NZ002Y | 2024-11-08T14:04:41.724Z | 2024-11-09T14:16:27.743Z |
5493802 | 5493802 | 20241107135243_DDGYb | NZ002Y | 2024-11-08T14:04:40.453Z | 2024-11-09T14:16:27.738Z |
5493794 | 5493794 | 20241107134936_7cAen | NZ002Y | 2024-11-08T14:04:39.833Z | 2024-11-09T14:16:27.736Z |
5493773 | 5493773 | 20241107133515_8sKVz | NZ002Y | 2024-11-08T14:04:37.702Z | 2024-11-09T14:16:27.727Z |
5493745 | 5493745 | 20241107131639_OTlai | NZ002Y | 2024-11-08T14:04:34.081Z | 2024-11-09T14:16:27.712Z |
5493740 | 5493740 | 20241107131353_yQlru | NZ002Y | 2024-11-08T14:04:33.523Z | 2024-11-09T14:16:27.709Z |
5493734 | 5493734 | 20241107131308_oAVCZ | NZ002Y | 2024-11-08T14:04:33.062Z | 2024-11-09T14:16:27.707Z |
5493618 | 5493618 | 20241107124519_TCYj7 | NZ002Y | 2024-11-08T14:04:19.040Z | 2024-11-09T14:16:27.673Z |
5493570 | 5493570 | 20241107123745_eNoaF | NZ002Y | 2024-11-08T14:04:06.994Z | 2024-11-09T14:16:27.660Z |
5493550 | 5493550 | 20241107123239_3ZvT2 | NZ002Y | 2024-11-08T14:04:02.840Z | 2024-11-09T14:16:27.653Z |
5493469 | 5493469 | 20241107121850_vd9uu | NZ002Y | 2024-11-08T14:03:50.820Z | 2024-11-09T14:16:27.635Z |
5493379 | 5493379 | 20241107120048_XXpGm | NZ002Y | 2024-11-08T14:03:39.375Z | 2024-11-09T14:16:27.606Z |
5493332 | 5493332 | 20241107115014_2xItF | NZ002Y | 2024-11-08T14:03:34.340Z | 2024-11-09T14:16:27.590Z |
5493262 | 5493262 | 20241107112923_m931v | NZ002Y | 2024-11-08T14:03:22.770Z | 2024-11-09T14:16:27.571Z |
5492807 | 5492807 | 20241107095810_HEbUJ | NZ002Y | 2024-11-08T14:02:08.054Z | 2024-11-09T14:16:27.458Z |
5492753 | 5492753 | 20241107095053_YkFRX | NZ002Y | 2024-11-08T14:02:02.065Z | 2024-11-09T14:16:27.446Z |
5492725 | 5492725 | 20241107094247_nA9PE | NZ002Y | 2024-11-08T14:01:58.530Z | 2024-11-09T14:16:27.438Z |
5492385 | 5492385 | 20241107082055_w3vdI | NZ002Y | 2024-11-08T14:00:58.165Z | 2024-11-09T14:16:27.360Z |
5492347 | 5492347 | 20241107081214_N7JPE | NZ002Y | 2024-11-08T14:00:50.514Z | 2024-11-09T14:16:27.350Z |
5474059 | 5474059 | 20241103154447_lh3Xl | NZ002Y | 2024-11-05T14:10:03.765Z | 2024-11-09T14:21:43.132Z |
5474025 | 5474025 | 20241103154102_H2YUe | NZ002Y | 2024-11-05T14:10:01.168Z | 2024-11-09T14:21:42.784Z |
5473791 | 5473791 | 20241103150352_LJnHS | NZ002Y | 2024-11-05T14:09:44.409Z | 2024-11-09T14:21:40.982Z |
5473683 | 5473683 | 20241103144855_ldAYp | NZ002Y | 2024-11-05T14:09:24.079Z | 2024-11-09T14:21:40.379Z |
5473493 | 5473493 | 20241103142408_Zo2g2 | NZ002Y | 2024-11-05T14:09:00.205Z | 2024-11-09T14:21:39.123Z |
5473310 | 5473310 | 20241103135938_RL2zv | NZ002Y | 2024-11-05T14:08:46.927Z | 2024-11-09T14:21:37.754Z |
5473304 | 5473304 | 20241103135534_evrmL | NZ002Y | 2024-11-05T14:08:46.264Z | 2024-11-09T14:21:37.712Z |
5473261 | 5473261 | 20241103135102_JnXKE | NZ002Y | 2024-11-05T14:08:43.048Z | 2024-11-09T14:21:37.382Z |
5473085 | 5473085 | 20241103132645_INYB4 | NZ002Y | 2024-11-05T14:08:13.344Z | 2024-11-09T14:21:36.958Z |
5472924 | 5472924 | 20241103130009_hweqZ | NZ002Y | 2024-11-05T14:07:52.423Z | 2024-11-09T14:21:35.755Z |
5472776 | 5472776 | 20241103123600_OpG4t | NZ002Y | 2024-11-05T14:07:41.404Z | 2024-11-09T14:21:34.872Z |
5472725 | 5472725 | 20241103123038_9zUok | NZ002Y | 2024-11-05T14:07:37.476Z | 2024-11-09T14:21:34.277Z |
5472537 | 5472537 | 20241104153607_rDE0E | NZ002Y | 2024-11-05T14:06:07.270Z | 2024-11-09T14:20:41.768Z |
5472521 | 5472521 | 20241104153320_PRWl1 | NZ002Y | 2024-11-05T14:06:03.602Z | 2024-11-09T14:20:41.297Z |
5472479 | 5472479 | 20241104151501_jf1sU | NZ002Y | 2024-11-05T14:05:54.259Z | 2024-11-09T14:20:40.741Z |
5472432 | 5472432 | 20241104150324_xu35Z | NZ002Y | 2024-11-05T14:05:49.362Z | 2024-11-09T14:20:40.153Z |
5472429 | 5472429 | 20241104150240_JciRs | NZ002Y | 2024-11-05T14:05:48.985Z | 2024-11-09T14:20:40.095Z |
5472384 | 5472384 | 20241104145410_5uNaJ | NZ002Y | 2024-11-05T14:05:44.036Z | 2024-11-09T14:20:39.776Z |
5472361 | 5472361 | 20241104144828_nWD8Y | NZ002Y | 2024-11-05T14:05:41.628Z | 2024-11-09T14:20:39.482Z |
5472326 | 5472326 | 20241104143920_WDB50 | NZ002Y | 2024-11-05T14:05:38.401Z | 2024-11-09T14:20:39.251Z |
5472318 | 5472318 | 20241104143811_wROl1 | NZ002Y | 2024-11-05T14:05:37.806Z | 2024-11-09T14:20:38.973Z |
5472310 | 5472310 | 20241104143642_t8i2l | NZ002Y | 2024-11-05T14:05:37.248Z | 2024-11-09T14:20:38.941Z |
5472270 | 5472270 | 20241104142146_ZtmHK | NZ002Y | 2024-11-05T14:05:33.344Z | 2024-11-09T14:20:37.828Z |
5472261 | 5472261 | 20241104141851_2Tk8U | NZ002Y | 2024-11-05T14:05:32.377Z | 2024-11-09T14:20:37.776Z |
5472256 | 5472256 | 20241104141526_U8ttA | NZ002Y | 2024-11-05T14:05:31.719Z | 2024-11-09T14:20:37.683Z |
5472171 | 5472171 | 20241104135857_j9BtL | NZ002Y | 2024-11-05T14:05:22.724Z | 2024-11-09T14:20:37.047Z |
5472161 | 5472161 | 20241104135754_SSckL | NZ002Y | 2024-11-05T14:05:19.458Z | 2024-11-09T14:20:37.029Z |
5472097 | 5472097 | 20241104133837_1hKHB | NZ002Y | 2024-11-05T14:05:06.295Z | 2024-11-09T14:20:36.525Z |
5472067 | 5472067 | 20241104133348_HOvjw | NZ002Y | 2024-11-05T14:05:04.281Z | 2024-11-09T14:20:36.341Z |
5472018 | 5472018 | 20241104132307_gHIxl | NZ002Y | 2024-11-05T14:04:58.980Z | 2024-11-09T14:20:35.666Z |
5471992 | 5471992 | 20241104131939_sCibD | NZ002Y | 2024-11-05T14:04:55.510Z | 2024-11-09T14:20:35.394Z |
5471904 | 5471904 | 20241104130015_JqLgg | NZ002Y | 2024-11-05T14:04:47.477Z | 2024-11-09T14:20:34.803Z |
5471867 | 5471867 | 20241104125218_Ebl9b | NZ002Y | 2024-11-05T14:04:44.322Z | 2024-11-09T14:20:34.361Z |
5471860 | 5471860 | 20241104125201_mugst | NZ002Y | 2024-11-05T14:04:43.703Z | 2024-11-09T14:20:34.325Z |
5471814 | 5471814 | 20241104124649_JlQus | NZ002Y | 2024-11-05T14:04:39.458Z | 2024-11-09T14:20:33.919Z |
5471530 | 5471530 | 20241104115914_QIXPf | NZ002Y | 2024-11-05T14:03:53.632Z | 2024-11-09T14:20:31.686Z |
5471509 | 5471509 | 20241104115659_erxqA | NZ002Y | 2024-11-05T14:03:50.838Z | 2024-11-09T14:20:31.515Z |
5471384 | 5471384 | 20241104113454_2l6zN | NZ002Y | 2024-11-05T14:03:35.687Z | 2024-11-09T14:20:30.748Z |
5471312 | 5471312 | 20241104112642_8253q | NZ002Y | 2024-11-05T14:03:23.657Z | 2024-11-09T14:20:30.196Z |
5471216 | 5471216 | 20241104110401_8WWl4 | NZ002Y | 2024-11-05T14:03:08.748Z | 2024-11-09T14:20:29.316Z |
5470777 | 5470777 | 20241104094651_FsPJ1 | NZ002Y | 2024-11-05T14:01:49.596Z | 2024-11-09T14:20:24.859Z |
5470620 | 5470620 | 20241104090541_xB9pD | NZ002Y | 2024-11-05T14:01:18.433Z | 2024-11-09T14:20:21.953Z |
5470483 | 5470483 | 20241104081510_I0GMa | NZ002Y | 2024-11-05T14:00:51.955Z | 2024-11-09T14:20:20.878Z |
5465438 | 5465438 | 20241103115836_qimzM | NZ002Y | 2024-11-04T14:03:43.318Z | 2024-11-09T14:21:33.356Z |
5465414 | 5465414 | 20241103115044_okCzc | NZ002Y | 2024-11-04T14:03:40.527Z | 2024-11-09T14:21:33.134Z |
5465144 | 5465144 | 20241103104658_gVgUo | NZ002Y | 2024-11-04T14:02:55.938Z | 2024-11-09T14:21:31.056Z |
5465108 | 5465108 | 20241103104000_SmJsv | NZ002Y | 2024-11-04T14:02:48.324Z | 2024-11-09T14:21:30.784Z |
5465098 | 5465098 | 20241103103757_c6dXM | NZ002Y | 2024-11-04T14:02:44.888Z | 2024-11-09T14:21:30.675Z |
5465088 | 5465088 | 20241103103631_3vZpW | NZ002Y | 2024-11-04T14:02:42.774Z | 2024-11-09T14:21:30.612Z |
5465031 | 5465031 | 20241103102537_XSu22 | NZ002Y | 2024-11-04T14:02:31.475Z | 2024-11-09T14:21:30.303Z |
5464933 | 5464933 | 20241103095534_eJNqq | NZ002Y | 2024-11-04T14:02:14.035Z | 2024-11-09T14:21:29.743Z |
5464910 | 5464910 | 20241103095053_s8N9q | NZ002Y | 2024-11-04T14:02:09.319Z | 2024-11-09T14:21:29.594Z |
5464892 | 5464892 | 20241103094857_TdZLT | NZ002Y | 2024-11-04T14:02:06.434Z | 2024-11-09T14:21:29.517Z |
5464806 | 5464806 | 20241103091841_v0chw | NZ002Y | 2024-11-04T14:01:43.300Z | 2024-11-09T14:21:28.907Z |
5464659 | 5464659 | 20241103084358_oFwVT | NZ002Y | 2024-11-04T14:01:16.207Z | 2024-11-09T14:21:27.450Z |
5464644 | 5464644 | 20241103084248_lBJ3U | NZ002Y | 2024-11-04T14:01:12.189Z | 2024-11-09T14:21:27.392Z |
5460601 | 5460601 | 20241101143737_5S9h7 | NZ002Y | 2024-11-03T14:14:01.740Z | 2024-11-09T14:23:24.652Z |
5449489 | 5449489 | 20241031154428_XPIo4 | NZ002Y | 2024-11-02T12:13:00.782Z | 2024-11-09T14:24:10.537Z |
5449360 | 5449360 | 20241031152440_OW8MU | NZ002Y | 2024-11-02T12:12:44.985Z | 2024-11-09T14:24:10.232Z |
5449291 | 5449291 | 20241031151711_zI31l | NZ002Y | 2024-11-02T12:12:26.616Z | 2024-11-09T14:24:10.102Z |
5449227 | 5449227 | 20241031150713_0dOV3 | NZ002Y | 2024-11-02T12:12:19.180Z | 2024-11-09T14:24:09.923Z |
5449102 | 5449102 | 20241031145400_ALHz9 | NZ002Y | 2024-11-02T12:12:05.504Z | 2024-11-09T14:24:09.436Z |
5449030 | 5449030 | 20241031144431_4cmd0 | NZ002Y | 2024-11-02T12:11:59.268Z | 2024-11-09T14:24:08.848Z |
5448861 | 5448861 | 20241031142537_pxap3 | NZ002Y | 2024-11-02T12:11:35.289Z | 2024-11-09T14:24:08.002Z |
5448845 | 5448845 | 20241031142320_R2KkR | NZ002Y | 2024-11-02T12:11:33.499Z | 2024-11-09T14:24:07.963Z |
5448663 | 5448663 | 20241031140230_qnR3u | NZ002Y | 2024-11-02T12:11:16.385Z | 2024-11-09T14:24:06.927Z |
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);