participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,323 rows where station_code = "NZ000Q" 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 |
---|---|---|---|---|---|
5126601 | 5126601 | 20240918161028_bghrC | NZ000Q | 2024-09-19T12:06:31.568Z | 2024-09-19T12:06:42.234Z |
5110272 | 5110272 | 20240913142349_R4r6X | NZ000Q | 2024-09-17T12:15:02.478Z | 2024-09-19T12:20:56.379Z |
5110262 | 5110262 | 20240913141659_TGhdb | NZ000Q | 2024-09-17T12:15:02.116Z | 2024-09-19T12:20:56.352Z |
5110258 | 5110258 | 20240913141627_2wWSY | NZ000Q | 2024-09-17T12:15:01.988Z | 2024-09-19T12:20:56.343Z |
5110240 | 5110240 | 20240913135902_7eEDW | NZ000Q | 2024-09-17T12:15:01.310Z | 2024-09-19T12:20:56.265Z |
5098491 | 5098491 | 20240913173658_WhESS | NZ000Q | 2024-09-17T12:00:45.486Z | 2024-09-19T12:19:37.767Z |
5098402 | 5098402 | 20240913165644_5kLby | NZ000Q | 2024-09-17T12:00:28.320Z | 2024-09-19T12:19:36.839Z |
5098322 | 5098322 | 20240913155727_YvCa2 | NZ000Q | 2024-09-17T12:00:10.370Z | 2024-09-19T12:19:36.093Z |
5097086 | 5097086 | 20240912142958_kt036 | NZ000Q | 2024-09-16T12:16:44.678Z | 2024-09-19T12:21:24.729Z |
5096999 | 5096999 | 20240912132729_euY3v | NZ000Q | 2024-09-16T12:16:41.959Z | 2024-09-19T12:21:24.525Z |
5096950 | 5096950 | 20240912124430_dur2K | NZ000Q | 2024-09-16T12:16:40.087Z | 2024-09-19T12:21:24.318Z |
5083932 | 5083932 | 20240912165345_P02RV | NZ000Q | 2024-09-16T12:00:40.798Z | 2024-09-19T12:20:22.773Z |
5083925 | 5083925 | 20240912164642_kcLo6 | NZ000Q | 2024-09-16T12:00:39.869Z | 2024-09-19T12:20:22.638Z |
5083798 | 5083798 | 20240912154418_XRwZd | NZ000Q | 2024-09-16T12:00:23.893Z | 2024-09-19T12:20:21.262Z |
5083784 | 5083784 | 20240912152856_DEblg | NZ000Q | 2024-09-16T12:00:21.501Z | 2024-09-19T12:20:21.226Z |
5069058 | 5069058 | 20240910133227_OSfTd | NZ000Q | 2024-09-14T12:19:25.020Z | 2024-09-18T12:15:27.080Z |
5068031 | 5068031 | 20240910104332_3v7or | NZ000Q | 2024-09-14T12:19:07.206Z | 2024-09-18T12:15:25.406Z |
5062255 | 5062255 | 20240909170428_JRkH6 | NZ000Q | 2024-09-14T12:12:01.797Z | 2024-09-18T12:15:10.823Z |
5062054 | 5062054 | 20240909163804_TtS0b | NZ000Q | 2024-09-14T12:11:46.876Z | 2024-09-18T12:15:10.351Z |
5061914 | 5061914 | 20240909162251_FojmG | NZ000Q | 2024-09-14T12:11:38.549Z | 2024-09-18T12:15:10.155Z |
5061551 | 5061551 | 20240909152231_jzabH | NZ000Q | 2024-09-14T12:10:57.287Z | 2024-09-18T12:15:09.608Z |
5058251 | 5058251 | 20240910155919_KvLUk | NZ000Q | 2024-09-14T12:03:16.385Z | 2024-09-19T12:21:29.391Z |
5058221 | 5058221 | 20240910155436_b1dU6 | NZ000Q | 2024-09-14T12:03:10.976Z | 2024-09-19T12:21:29.379Z |
5058181 | 5058181 | 20240910155030_6JCIY | NZ000Q | 2024-09-14T12:03:06.403Z | 2024-09-19T12:21:29.258Z |
5051306 | 5051306 | 20240907171310_QPqKi | NZ000Q | 2024-09-13T12:14:09.439Z | 2024-09-16T12:21:00.053Z |
5051017 | 5051017 | 20240907163651_UDvdZ | NZ000Q | 2024-09-13T12:13:57.375Z | 2024-09-16T12:20:59.469Z |
5050894 | 5050894 | 20240907162207_DKQ1N | NZ000Q | 2024-09-13T12:13:52.017Z | 2024-09-16T12:20:59.122Z |
5050665 | 5050665 | 20240907155535_qKw2I | NZ000Q | 2024-09-13T12:13:42.765Z | 2024-09-16T12:20:58.210Z |
5048511 | 5048511 | 20240909082226_tWFHP | NZ000Q | 2024-09-13T12:10:45.828Z | 2024-09-17T12:19:07.302Z |
5041350 | 5041350 | 20240906080200_VX2kY | NZ000Q | 2024-09-12T12:16:39.283Z | 2024-09-14T12:23:13.311Z |
5035727 | 5035727 | 20240907101238_gBA9Q | NZ000Q | 2024-09-12T12:12:24.345Z | 2024-09-15T12:21:41.012Z |
5034699 | 5034699 | 20240907074504_RppPP | NZ000Q | 2024-09-12T12:11:12.895Z | 2024-09-15T12:21:35.565Z |
5006258 | 5006258 | 20240903170951_FcPAN | NZ000Q | 2024-09-09T12:04:26.985Z | 2024-09-12T12:19:08.044Z |
5006067 | 5006067 | 20240903165136_UY0p2 | NZ000Q | 2024-09-09T12:04:18.842Z | 2024-09-12T12:19:07.575Z |
5006037 | 5006037 | 20240903164818_YZEQF | NZ000Q | 2024-09-09T12:04:17.692Z | 2024-09-12T12:19:07.255Z |
5005919 | 5005919 | 20240903163131_lAyxL | NZ000Q | 2024-09-09T12:04:12.536Z | 2024-09-12T12:19:07.039Z |
5005866 | 5005866 | 20240903162521_edVTp | NZ000Q | 2024-09-09T12:04:10.494Z | 2024-09-12T12:19:06.975Z |
5005369 | 5005369 | 20240903145906_Y9EA0 | NZ000Q | 2024-09-09T12:03:39.005Z | 2024-09-12T12:19:05.819Z |
5005168 | 5005168 | 20240903142200_Hi3aC | NZ000Q | 2024-09-09T12:03:24.330Z | 2024-09-12T12:19:05.391Z |
5005151 | 5005151 | 20240903141337_lFGne | NZ000Q | 2024-09-09T12:03:23.046Z | 2024-09-12T12:19:05.368Z |
5005137 | 5005137 | 20240903140836_vXx26 | NZ000Q | 2024-09-09T12:03:22.382Z | 2024-09-12T12:19:05.358Z |
5004935 | 5004935 | 20240903133207_Q9jYZ | NZ000Q | 2024-09-09T12:03:12.403Z | 2024-09-12T12:19:04.530Z |
5004860 | 5004860 | 20240903130831_xZUXt | NZ000Q | 2024-09-09T12:03:08.291Z | 2024-09-12T12:19:04.357Z |
5004838 | 5004838 | 20240903130259_gQG97 | NZ000Q | 2024-09-09T12:03:05.889Z | 2024-09-12T12:19:04.340Z |
5004791 | 5004791 | 20240903124026_3uZDu | NZ000Q | 2024-09-09T12:03:02.726Z | 2024-09-12T12:19:04.103Z |
5004707 | 5004707 | 20240903121226_VrhVS | NZ000Q | 2024-09-09T12:02:55.662Z | 2024-09-12T12:19:03.565Z |
5004524 | 5004524 | 20240903114307_NoVjr | NZ000Q | 2024-09-09T12:02:46.722Z | 2024-09-12T12:19:02.605Z |
5004422 | 5004422 | 20240903112703_lJkEn | NZ000Q | 2024-09-09T12:02:41.490Z | 2024-09-12T12:19:02.062Z |
5004150 | 5004150 | 20240903104924_gyNNb | NZ000Q | 2024-09-09T12:02:24.323Z | 2024-09-12T12:19:00.891Z |
5003663 | 5003663 | 20240903093006_gaTh3 | NZ000Q | 2024-09-09T12:01:56.797Z | 2024-09-12T12:18:58.366Z |
4987611 | 4987611 | 20240901181020_7E1GM | NZ000Q | 2024-09-07T12:05:59.622Z | 2024-09-10T12:19:11.021Z |
4961007 | 4961007 | 20240811170911_0gYUZ | NZ000Q | 2024-09-04T12:03:11.055Z | 2024-09-06T12:02:39.008Z |
4960950 | 4960950 | 20240811170548_zF2B9 | NZ000Q | 2024-09-04T12:03:07.737Z | 2024-09-06T12:02:36.817Z |
4960935 | 4960935 | 20240811170351_9JxHk | NZ000Q | 2024-09-04T12:03:06.734Z | 2024-09-06T12:02:34.290Z |
4960296 | 4960296 | 20240811161447_O5OWT | NZ000Q | 2024-09-04T12:02:24.188Z | 2024-09-06T12:02:01.877Z |
4960289 | 4960289 | 20240811161444_FcInV | NZ000Q | 2024-09-04T12:02:23.914Z | 2024-09-06T12:02:01.633Z |
4934256 | 4934256 | 20240810180011_vh34T | NZ000Q | 2024-09-01T12:05:05.964Z | 2024-09-06T12:20:06.577Z |
4932903 | 4932903 | 20240810162902_oMyKj | NZ000Q | 2024-09-01T12:03:47.615Z | 2024-09-06T12:18:51.272Z |
4932667 | 4932667 | 20240810161345_RDo4k | NZ000Q | 2024-09-01T12:03:33.168Z | 2024-09-06T12:18:45.121Z |
4932630 | 4932630 | 20240810161010_avRDH | NZ000Q | 2024-09-01T12:03:30.488Z | 2024-09-06T12:18:43.678Z |
4930826 | 4930826 | 20240810090416_yiXHO | NZ000Q | 2024-08-31T12:23:58.822Z | 2024-09-02T12:30:27.989Z |
4930793 | 4930793 | 20240810090110_8MPf0 | NZ000Q | 2024-08-31T12:23:55.835Z | 2024-09-02T12:30:26.310Z |
4930731 | 4930731 | 20240810085403_dgUEv | NZ000Q | 2024-08-31T12:23:50.673Z | 2024-09-02T12:30:24.483Z |
4930420 | 4930420 | 20240810081001_DMncn | NZ000Q | 2024-08-31T12:23:29.371Z | 2024-09-02T12:30:12.367Z |
4906835 | 4906835 | 20240809131821_DCOKI | NZ000Q | 2024-08-29T12:02:19.939Z | 2024-09-02T12:17:59.485Z |
4906563 | 4906563 | 20240809125119_We05R | NZ000Q | 2024-08-29T12:02:00.804Z | 2024-09-02T12:17:42.339Z |
4906438 | 4906438 | 20240809124116_frRkV | NZ000Q | 2024-08-29T12:01:52.249Z | 2024-09-02T12:17:37.562Z |
4906331 | 4906331 | 20240809122917_aIe2m | NZ000Q | 2024-08-29T12:01:44.483Z | 2024-09-02T12:17:33.547Z |
4906240 | 4906240 | 20240809121723_jYPVc | NZ000Q | 2024-08-29T12:01:37.715Z | 2024-09-02T12:17:30.724Z |
4906156 | 4906156 | 20240809120812_r4TM3 | NZ000Q | 2024-08-29T12:01:31.113Z | 2024-09-02T12:17:28.032Z |
4905997 | 4905997 | 20240809114753_8FNH9 | NZ000Q | 2024-08-29T12:01:19.149Z | 2024-09-02T12:17:23.303Z |
4905551 | 4905551 | 20240809110315_ZE0OK | NZ000Q | 2024-08-29T12:00:34.855Z | 2024-09-02T12:16:51.186Z |
4905292 | 4905292 | 20240808090813_QBXJ9 | NZ000Q | 2024-08-28T12:21:15.717Z | 2024-08-28T12:21:15.717Z |
4893552 | 4893552 | 20240809100351_7iptN | NZ000Q | 2024-08-28T12:11:32.622Z | 2024-08-30T12:23:00.848Z |
4893473 | 4893473 | 20240809094153_PwQGZ | NZ000Q | 2024-08-28T12:11:29.074Z | 2024-08-30T12:22:58.676Z |
4892930 | 4892930 | 20240809074215_NB4tJ | NZ000Q | 2024-08-28T12:10:51.158Z | 2024-08-30T12:22:39.862Z |
4888755 | 4888755 | 20240808184100_IjJwl | NZ000Q | 2024-08-28T12:05:05.951Z | 2024-08-30T12:18:36.762Z |
4888703 | 4888703 | 20240808183229_7n1av | NZ000Q | 2024-08-28T12:04:59.518Z | 2024-08-30T12:18:34.172Z |
4888638 | 4888638 | 20240808182128_fUvkF | NZ000Q | 2024-08-28T12:04:53.311Z | 2024-08-30T12:18:30.943Z |
4888624 | 4888624 | 20240808181737_dFhDq | NZ000Q | 2024-08-28T12:04:52.437Z | 2024-08-30T12:18:30.418Z |
4888426 | 4888426 | 20240808175331_uVChT | NZ000Q | 2024-08-28T12:04:39.041Z | 2024-08-30T12:18:12.064Z |
4888343 | 4888343 | 20240808174340_USKnv | NZ000Q | 2024-08-28T12:04:33.472Z | 2024-08-30T12:18:09.276Z |
4888214 | 4888214 | 20240808173557_b25D9 | NZ000Q | 2024-08-28T12:04:22.373Z | 2024-08-30T12:18:03.511Z |
4888143 | 4888143 | 20240808172652_oXrnP | NZ000Q | 2024-08-28T12:04:18.095Z | 2024-08-30T12:18:00.959Z |
4887964 | 4887964 | 20240808171126_qvJu2 | NZ000Q | 2024-08-28T12:04:07.136Z | 2024-08-30T12:17:54.976Z |
4887907 | 4887907 | 20240808170540_q450H | NZ000Q | 2024-08-28T12:04:04.025Z | 2024-08-30T12:17:53.511Z |
4887884 | 4887884 | 20240808170334_C2kTN | NZ000Q | 2024-08-28T12:03:59.591Z | 2024-08-30T12:17:52.626Z |
4887859 | 4887859 | 20240808170058_A4XsJ | NZ000Q | 2024-08-28T12:03:57.610Z | 2024-08-30T12:17:51.509Z |
4887849 | 4887849 | 20240808170008_M7gp7 | NZ000Q | 2024-08-28T12:03:56.729Z | 2024-08-30T12:17:51.059Z |
4887681 | 4887681 | 20240808163604_S9ICp | NZ000Q | 2024-08-28T12:03:41.917Z | 2024-08-30T12:17:39.281Z |
4887674 | 4887674 | 20240808163516_8sxx3 | NZ000Q | 2024-08-28T12:03:41.359Z | 2024-08-30T12:17:38.466Z |
4887613 | 4887613 | 20240808162813_2wwJ2 | NZ000Q | 2024-08-28T12:03:37.598Z | 2024-08-30T12:17:34.411Z |
4887600 | 4887600 | 20240808162639_NfVsZ | NZ000Q | 2024-08-28T12:03:36.962Z | 2024-08-30T12:17:34.055Z |
4887581 | 4887581 | 20240808162455_c3lQP | NZ000Q | 2024-08-28T12:03:35.492Z | 2024-08-30T12:17:32.981Z |
4887569 | 4887569 | 20240808162354_1g3pP | NZ000Q | 2024-08-28T12:03:34.881Z | 2024-08-30T12:17:32.560Z |
4887566 | 4887566 | 20240808162240_TGY3Z | NZ000Q | 2024-08-28T12:03:34.666Z | 2024-08-30T12:17:32.447Z |
4887526 | 4887526 | 20240808161804_e5aIb | NZ000Q | 2024-08-28T12:03:30.601Z | 2024-08-30T12:17:30.638Z |
4887512 | 4887512 | 20240808161515_gHN2m | NZ000Q | 2024-08-28T12:03:28.933Z | 2024-08-30T12:17:29.754Z |
4887442 | 4887442 | 20240808160353_eSNKc | NZ000Q | 2024-08-28T12:03:24.074Z | 2024-08-30T12:17:26.050Z |
4887391 | 4887391 | 20240808155919_tJLva | NZ000Q | 2024-08-28T12:03:20.192Z | 2024-08-30T12:17:24.136Z |
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);