participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,219 rows where station_code = "NZ004C" 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 |
---|---|---|---|---|---|
5460869 | 5460869 | 20241101151353_N5Wqr | NZ004C | 2024-11-03T14:14:32.054Z | 2024-11-03T14:19:33.627Z |
5460838 | 5460838 | 20241101151148_ZK5Gl | NZ004C | 2024-11-03T14:14:31.015Z | 2024-11-03T14:19:33.623Z |
5460744 | 5460744 | 20241101145843_TFc3B | NZ004C | 2024-11-03T14:14:19.817Z | 2024-11-03T14:19:33.606Z |
5460638 | 5460638 | 20241101144040_RXJQm | NZ004C | 2024-11-03T14:14:06.358Z | 2024-11-03T14:19:33.587Z |
5460567 | 5460567 | 20241101143106_qtY0v | NZ004C | 2024-11-03T14:13:59.491Z | 2024-11-03T14:19:33.576Z |
5460563 | 5460563 | 20241101143046_A8irD | NZ004C | 2024-11-03T14:13:59.314Z | 2024-11-03T14:19:33.576Z |
5460460 | 5460460 | 20241101141301_GUO3D | NZ004C | 2024-11-03T14:13:46.076Z | 2024-11-03T14:19:33.551Z |
5460360 | 5460360 | 20241101135759_K66Xk | NZ004C | 2024-11-03T14:13:38.359Z | 2024-11-03T14:19:33.530Z |
5460250 | 5460250 | 20241101132125_qXYBq | NZ004C | 2024-11-03T14:13:30.925Z | 2024-11-03T14:19:33.507Z |
5460215 | 5460215 | 20241101131052_8rnJ9 | NZ004C | 2024-11-03T14:13:28.149Z | 2024-11-03T14:19:33.499Z |
5460155 | 5460155 | 20241101125837_l3XNi | NZ004C | 2024-11-03T14:13:24.949Z | 2024-11-03T14:19:33.488Z |
5460121 | 5460121 | 20241101124918_qlC22 | NZ004C | 2024-11-03T14:13:22.449Z | 2024-11-03T14:19:33.481Z |
5460118 | 5460118 | 20241101124802_vzT21 | NZ004C | 2024-11-03T14:13:22.070Z | 2024-11-03T14:19:33.479Z |
5460094 | 5460094 | 20241101124238_9R1uA | NZ004C | 2024-11-03T14:13:20.743Z | 2024-11-03T14:19:33.475Z |
5460038 | 5460038 | 20241101123251_2t4t8 | NZ004C | 2024-11-03T14:13:13.270Z | 2024-11-03T14:19:33.466Z |
5459892 | 5459892 | 20241101121135_FkmDN | NZ004C | 2024-11-03T14:12:46.135Z | 2024-11-03T14:19:33.438Z |
5459789 | 5459789 | 20241101115129_FroyW | NZ004C | 2024-11-03T14:12:36.074Z | 2024-11-03T14:19:33.418Z |
5459747 | 5459747 | 20241101114710_AJKYE | NZ004C | 2024-11-03T14:12:33.113Z | 2024-11-03T14:19:33.412Z |
5459700 | 5459700 | 20241101114010_UPh3P | NZ004C | 2024-11-03T14:12:29.078Z | 2024-11-03T14:19:33.400Z |
5459475 | 5459475 | 20241101110324_F50r8 | NZ004C | 2024-11-03T14:11:59.621Z | 2024-11-03T14:19:33.350Z |
5458682 | 5458682 | 20241101090316_Sw4Ba | NZ004C | 2024-11-03T14:10:27.978Z | 2024-11-03T14:19:33.176Z |
5458649 | 5458649 | 20241101085549_gdw8L | NZ004C | 2024-11-03T14:10:14.777Z | 2024-11-03T14:19:33.167Z |
5458068 | 5458068 | 20241102160843_bD9F1 | NZ004C | 2024-11-03T14:08:41.280Z | 2024-11-03T14:08:41.280Z |
5458064 | 5458064 | 20241102160651_ogKYF | NZ004C | 2024-11-03T14:08:40.083Z | 2024-11-03T14:08:40.083Z |
5458059 | 5458059 | 20241102160543_3V7Fh | NZ004C | 2024-11-03T14:08:38.406Z | 2024-11-03T14:08:38.406Z |
5457985 | 5457985 | 20241102155322_388AA | NZ004C | 2024-11-03T14:08:29.761Z | 2024-11-03T14:08:29.761Z |
5457922 | 5457922 | 20241102154003_dwBKN | NZ004C | 2024-11-03T14:08:20.996Z | 2024-11-03T14:08:20.996Z |
5457914 | 5457914 | 20241102153904_m811I | NZ004C | 2024-11-03T14:08:20.364Z | 2024-11-03T14:08:20.364Z |
5457874 | 5457874 | 20241102153155_2JvuR | NZ004C | 2024-11-03T14:08:17.251Z | 2024-11-03T14:08:17.251Z |
5457858 | 5457858 | 20241102153007_SrxYn | NZ004C | 2024-11-03T14:08:16.366Z | 2024-11-03T14:08:16.366Z |
5457837 | 5457837 | 20241102152920_Radzw | NZ004C | 2024-11-03T14:08:15.481Z | 2024-11-03T14:08:15.481Z |
5457816 | 5457816 | 20241102152540_XVpku | NZ004C | 2024-11-03T14:08:13.410Z | 2024-11-03T14:08:13.410Z |
5457752 | 5457752 | 20241102152036_QFUFu | NZ004C | 2024-11-03T14:07:57.983Z | 2024-11-03T14:07:57.983Z |
5457707 | 5457707 | 20241102151235_yw0Dt | NZ004C | 2024-11-03T14:07:53.269Z | 2024-11-03T14:07:53.269Z |
5457646 | 5457646 | 20241102150028_QLm13 | NZ004C | 2024-11-03T14:07:46.161Z | 2024-11-03T14:07:46.161Z |
5457309 | 5457309 | 20241102140749_upzBF | NZ004C | 2024-11-03T14:07:05.629Z | 2024-11-03T14:07:05.629Z |
5457107 | 5457107 | 20241102133201_N9Afq | NZ004C | 2024-11-03T14:06:34.596Z | 2024-11-03T14:06:34.596Z |
5457076 | 5457076 | 20241102132833_kPUhu | NZ004C | 2024-11-03T14:06:30.580Z | 2024-11-03T14:06:30.580Z |
5457047 | 5457047 | 20241102132129_hW9gA | NZ004C | 2024-11-03T14:06:26.669Z | 2024-11-03T14:06:26.669Z |
5457032 | 5457032 | 20241102131539_Uwwcy | NZ004C | 2024-11-03T14:06:24.334Z | 2024-11-03T14:06:24.334Z |
5456968 | 5456968 | 20241102130246_U7qz2 | NZ004C | 2024-11-03T14:06:12.459Z | 2024-11-03T14:06:12.459Z |
5456954 | 5456954 | 20241102125946_00MhU | NZ004C | 2024-11-03T14:06:08.670Z | 2024-11-03T14:06:08.670Z |
5456944 | 5456944 | 20241102125650_vjDjV | NZ004C | 2024-11-03T14:06:06.944Z | 2024-11-03T14:06:06.944Z |
5456928 | 5456928 | 20241102125351_odQP3 | NZ004C | 2024-11-03T14:06:04.005Z | 2024-11-03T14:06:04.005Z |
5456872 | 5456872 | 20241102124251_uKvOJ | NZ004C | 2024-11-03T14:05:51.699Z | 2024-11-03T14:05:51.699Z |
5456823 | 5456823 | 20241102123345_P4Olu | NZ004C | 2024-11-03T14:05:45.366Z | 2024-11-03T14:05:45.366Z |
5456819 | 5456819 | 20241102123142_E3OAP | NZ004C | 2024-11-03T14:05:44.945Z | 2024-11-03T14:05:44.945Z |
5456803 | 5456803 | 20241102122626_9lt4K | NZ004C | 2024-11-03T14:05:42.829Z | 2024-11-03T14:05:42.829Z |
5456750 | 5456750 | 20241102121420_zldT2 | NZ004C | 2024-11-03T14:05:37.111Z | 2024-11-03T14:05:37.111Z |
5456663 | 5456663 | 20241102115955_XzkfH | NZ004C | 2024-11-03T14:05:15.878Z | 2024-11-03T14:05:15.878Z |
5456580 | 5456580 | 20241102114642_LWHKR | NZ004C | 2024-11-03T14:05:01.914Z | 2024-11-03T14:05:01.914Z |
5456573 | 5456573 | 20241102114612_4BQ3F | NZ004C | 2024-11-03T14:05:01.073Z | 2024-11-03T14:05:01.073Z |
5456265 | 5456265 | 20241102105027_oVxHL | NZ004C | 2024-11-03T14:03:59.332Z | 2024-11-03T14:03:59.332Z |
5456250 | 5456250 | 20241102104844_mnlUL | NZ004C | 2024-11-03T14:03:54.195Z | 2024-11-03T14:03:54.195Z |
5456145 | 5456145 | 20241102102838_2XO1s | NZ004C | 2024-11-03T14:03:30.285Z | 2024-11-03T14:03:30.285Z |
5456014 | 5456014 | 20241102100702_Syu8v | NZ004C | 2024-11-03T14:03:06.844Z | 2024-11-03T14:03:06.844Z |
5455758 | 5455758 | 20241102091151_YGBjg | NZ004C | 2024-11-03T14:02:14.639Z | 2024-11-03T14:02:14.639Z |
5455748 | 5455748 | 20241102091033_G4dDg | NZ004C | 2024-11-03T14:02:10.097Z | 2024-11-03T14:02:10.097Z |
5448191 | 5448191 | 20241031125808_SPUu3 | NZ004C | 2024-11-02T12:10:12.604Z | 2024-11-03T14:20:34.035Z |
5448065 | 5448065 | 20241031123801_1nuZg | NZ004C | 2024-11-02T12:09:52.123Z | 2024-11-03T14:20:32.223Z |
5447556 | 5447556 | 20241031115233_s5f4q | NZ004C | 2024-11-02T12:08:26.698Z | 2024-11-03T14:20:24.058Z |
5447444 | 5447444 | 20241031114329_yelX8 | NZ004C | 2024-11-02T12:08:11.609Z | 2024-11-03T14:20:22.491Z |
5447359 | 5447359 | 20241031113523_sldFC | NZ004C | 2024-11-02T12:07:56.078Z | 2024-11-03T14:20:21.185Z |
5447354 | 5447354 | 20241031113453_vapeI | NZ004C | 2024-11-02T12:07:54.422Z | 2024-11-03T14:20:21.122Z |
5447349 | 5447349 | 20241031113410_rwbeF | NZ004C | 2024-11-02T12:07:51.835Z | 2024-11-03T14:20:20.937Z |
5446558 | 5446558 | 20241031101135_OLKZd | NZ004C | 2024-11-02T12:05:37.272Z | 2024-11-03T14:20:04.209Z |
5437758 | 5437758 | 20241030153935_3f3Sx | NZ004C | 2024-11-01T12:10:17.273Z | 2024-11-03T14:22:40.478Z |
5437426 | 5437426 | 20241030150632_hHx71 | NZ004C | 2024-11-01T12:09:34.682Z | 2024-11-03T14:22:39.568Z |
5437278 | 5437278 | 20241030144915_erDoP | NZ004C | 2024-11-01T12:09:19.675Z | 2024-11-03T14:22:39.020Z |
5437197 | 5437197 | 20241030144027_3zAkD | NZ004C | 2024-11-01T12:09:13.634Z | 2024-11-03T14:22:38.861Z |
5427732 | 5427732 | 20241028153807_rpsfv | NZ004C | 2024-10-31T12:13:53.143Z | 2024-11-03T14:24:48.488Z |
5427682 | 5427682 | 20241028153227_GdtC6 | NZ004C | 2024-10-31T12:13:47.978Z | 2024-11-03T14:24:48.451Z |
5427632 | 5427632 | 20241028152412_lSdlv | NZ004C | 2024-10-31T12:13:41.576Z | 2024-11-03T14:24:48.127Z |
5427616 | 5427616 | 20241028152220_lrijr | NZ004C | 2024-10-31T12:13:41.044Z | 2024-11-03T14:24:48.119Z |
5426587 | 5426587 | 20241028133002_8WlYF | NZ004C | 2024-10-31T12:12:14.841Z | 2024-11-03T14:24:43.554Z |
5425110 | 5425110 | 20241029155524_5udhi | NZ004C | 2024-10-31T12:06:52.214Z | 2024-11-03T14:23:40.862Z |
5424800 | 5424800 | 20241029151520_PapbR | NZ004C | 2024-10-31T12:06:03.093Z | 2024-11-03T14:23:39.226Z |
5424370 | 5424370 | 20241029140823_LyGku | NZ004C | 2024-10-31T12:04:48.951Z | 2024-11-03T14:23:36.224Z |
5423943 | 5423943 | 20241029122812_9yovz | NZ004C | 2024-10-31T12:03:16.177Z | 2024-11-03T14:23:33.207Z |
5423937 | 5423937 | 20241029122641_n2BkU | NZ004C | 2024-10-31T12:03:15.364Z | 2024-11-03T14:23:33.047Z |
5423901 | 5423901 | 20241029121927_2hEe4 | NZ004C | 2024-10-31T12:03:06.767Z | 2024-11-03T14:23:32.846Z |
5423820 | 5423820 | 20241029120745_RZ82P | NZ004C | 2024-10-31T12:02:53.202Z | 2024-11-03T14:23:31.882Z |
5423734 | 5423734 | 20241029114821_4Fbte | NZ004C | 2024-10-31T12:02:29.547Z | 2024-11-03T14:23:30.477Z |
5423699 | 5423699 | 20241029113616_Xt5v2 | NZ004C | 2024-10-31T12:02:21.242Z | 2024-11-03T14:23:29.591Z |
5423596 | 5423596 | 20241029110737_vgOJ6 | NZ004C | 2024-10-31T12:02:05.865Z | 2024-11-03T14:23:28.814Z |
5423511 | 5423511 | 20241029104355_nVhnt | NZ004C | 2024-10-31T12:01:41.179Z | 2024-11-03T14:23:28.218Z |
5423497 | 5423497 | 20241029103335_AN6vR | NZ004C | 2024-10-31T12:01:38.265Z | 2024-11-03T14:23:28.118Z |
5423483 | 5423483 | 20241029103027_mtX56 | NZ004C | 2024-10-31T12:01:34.046Z | 2024-11-03T14:23:28.026Z |
5423278 | 5423278 | 20241029090749_70Ec4 | NZ004C | 2024-10-31T12:00:51.389Z | 2024-11-03T14:23:25.915Z |
5423231 | 5423231 | 20241029084142_juq2c | NZ004C | 2024-10-31T12:00:42.313Z | 2024-11-03T14:23:25.691Z |
5422404 | 5422404 | 20241028125940_1PoFK | NZ004C | 2024-10-30T12:20:26.367Z | 2024-11-03T14:24:42.049Z |
5422379 | 5422379 | 20241028125629_njDsQ | NZ004C | 2024-10-30T12:20:26.046Z | 2024-11-03T14:24:41.958Z |
5422366 | 5422366 | 20241028125556_uggNN | NZ004C | 2024-10-30T12:20:25.940Z | 2024-11-03T14:24:41.940Z |
5422200 | 5422200 | 20241028122832_MAEEA | NZ004C | 2024-10-30T12:20:23.661Z | 2024-11-03T14:24:41.266Z |
5422128 | 5422128 | 20241028121811_h3sb0 | NZ004C | 2024-10-30T12:20:22.567Z | 2024-11-03T14:24:41.097Z |
5422062 | 5422062 | 20241028121049_MKaPK | NZ004C | 2024-10-30T12:20:20.863Z | 2024-11-03T14:24:40.170Z |
5421797 | 5421797 | 20241028113946_I2Xap | NZ004C | 2024-10-30T12:20:15.229Z | 2024-11-03T14:24:39.273Z |
5421688 | 5421688 | 20241028112157_oVXtP | NZ004C | 2024-10-30T12:20:12.622Z | 2024-11-03T14:24:39.015Z |
5421682 | 5421682 | 20241028111941_ZRcpr | NZ004C | 2024-10-30T12:20:11.847Z | 2024-11-03T14:24:38.995Z |
5416641 | 5416641 | 20241027162242_nMThs | NZ004C | 2024-10-30T12:11:59.703Z | 2024-11-03T14:25:42.707Z |
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);