participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,718 rows where station_code = "NZ003W" 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 |
---|---|---|---|---|---|
5461127 | 5461127 | 20241101160646_OlDNE | NZ003W | 2024-11-03T14:14:44.758Z | 2024-11-03T14:19:33.678Z |
5461034 | 5461034 | 20241101153757_brDkt | NZ003W | 2024-11-03T14:14:40.193Z | 2024-11-03T14:19:33.659Z |
5461016 | 5461016 | 20241101153325_Xi2dr | NZ003W | 2024-11-03T14:14:39.117Z | 2024-11-03T14:19:33.654Z |
5460988 | 5460988 | 20241101153035_T5mAm | NZ003W | 2024-11-03T14:14:38.025Z | 2024-11-03T14:19:33.650Z |
5460968 | 5460968 | 20241101152810_S6Eji | NZ003W | 2024-11-03T14:14:37.364Z | 2024-11-03T14:19:33.647Z |
5460933 | 5460933 | 20241101152254_CIyCS | NZ003W | 2024-11-03T14:14:34.969Z | 2024-11-03T14:19:33.640Z |
5460916 | 5460916 | 20241101151916_2tBxh | NZ003W | 2024-11-03T14:14:34.040Z | 2024-11-03T14:19:33.636Z |
5460841 | 5460841 | 20241101151226_Pq4RB | NZ003W | 2024-11-03T14:14:31.180Z | 2024-11-03T14:19:33.623Z |
5460830 | 5460830 | 20241101150937_VJy83 | NZ003W | 2024-11-03T14:14:30.540Z | 2024-11-03T14:19:33.620Z |
5460787 | 5460787 | 20241101150300_xA2W6 | NZ003W | 2024-11-03T14:14:25.421Z | 2024-11-03T14:19:33.613Z |
5460688 | 5460688 | 20241101144855_EmokF | NZ003W | 2024-11-03T14:14:14.197Z | 2024-11-03T14:19:33.597Z |
5460646 | 5460646 | 20241101144316_ZUcAx | NZ003W | 2024-11-03T14:14:07.227Z | 2024-11-03T14:19:33.589Z |
5460573 | 5460573 | 20241101143140_v5z5P | NZ003W | 2024-11-03T14:13:59.896Z | 2024-11-03T14:19:33.577Z |
5460526 | 5460526 | 20241101142705_jj2Bt | NZ003W | 2024-11-03T14:13:54.635Z | 2024-11-03T14:19:33.567Z |
5460521 | 5460521 | 20241101142645_eN177 | NZ003W | 2024-11-03T14:13:54.509Z | 2024-11-03T14:19:33.566Z |
5460454 | 5460454 | 20241101141246_2kxMu | NZ003W | 2024-11-03T14:13:45.882Z | 2024-11-03T14:19:33.550Z |
5460443 | 5460443 | 20241101141113_z2W6V | NZ003W | 2024-11-03T14:13:44.806Z | 2024-11-03T14:19:33.547Z |
5460415 | 5460415 | 20241101140407_lJGpx | NZ003W | 2024-11-03T14:13:42.616Z | 2024-11-03T14:19:33.541Z |
5460388 | 5460388 | 20241101140153_ZOEZw | NZ003W | 2024-11-03T14:13:41.269Z | 2024-11-03T14:19:33.536Z |
5460374 | 5460374 | 20241101135925_X2C42 | NZ003W | 2024-11-03T14:13:39.068Z | 2024-11-03T14:19:33.532Z |
5460283 | 5460283 | 20241101133130_mRgwp | NZ003W | 2024-11-03T14:13:32.968Z | 2024-11-03T14:19:33.514Z |
5460279 | 5460279 | 20241101133042_6ZvMb | NZ003W | 2024-11-03T14:13:32.798Z | 2024-11-03T14:19:33.513Z |
5460276 | 5460276 | 20241101132936_zxHWo | NZ003W | 2024-11-03T14:13:32.405Z | 2024-11-03T14:19:33.512Z |
5460195 | 5460195 | 20241101130345_ZsT3g | NZ003W | 2024-11-03T14:13:27.388Z | 2024-11-03T14:19:33.495Z |
5459807 | 5459807 | 20241101115420_QvHGG | NZ003W | 2024-11-03T14:12:37.303Z | 2024-11-03T14:19:33.421Z |
5459615 | 5459615 | 20241101112410_Gn4aP | NZ003W | 2024-11-03T14:12:21.788Z | 2024-11-03T14:19:33.380Z |
5459386 | 5459386 | 20241101105242_vkga6 | NZ003W | 2024-11-03T14:11:46.611Z | 2024-11-03T14:19:33.332Z |
5459253 | 5459253 | 20241101103054_zyd9k | NZ003W | 2024-11-03T14:11:34.183Z | 2024-11-03T14:19:33.303Z |
5459173 | 5459173 | 20241101101949_VsQ2y | NZ003W | 2024-11-03T14:11:27.134Z | 2024-11-03T14:19:33.286Z |
5459076 | 5459076 | 20241101100442_nOZH5 | NZ003W | 2024-11-03T14:11:16.517Z | 2024-11-03T14:19:33.262Z |
5459035 | 5459035 | 20241101100028_CSxEG | NZ003W | 2024-11-03T14:11:04.312Z | 2024-11-03T14:19:33.254Z |
5458831 | 5458831 | 20241101092337_woTF6 | NZ003W | 2024-11-03T14:10:40.769Z | 2024-11-03T14:19:33.208Z |
5458827 | 5458827 | 20241101092336_7ke4D | NZ003W | 2024-11-03T14:10:40.608Z | 2024-11-03T14:19:33.207Z |
5458315 | 5458315 | 20241101080439_9hmoJ | NZ003W | 2024-11-03T14:09:34.640Z | 2024-11-03T14:19:33.102Z |
5457810 | 5457810 | 20241102152449_RXi1f | NZ003W | 2024-11-03T14:08:12.832Z | 2024-11-03T14:08:12.832Z |
5457720 | 5457720 | 20241102151545_9n40g | NZ003W | 2024-11-03T14:07:54.248Z | 2024-11-03T14:07:54.248Z |
5457540 | 5457540 | 20241102144030_Gbx94 | NZ003W | 2024-11-03T14:07:36.846Z | 2024-11-03T14:07:36.846Z |
5457492 | 5457492 | 20241102143756_3xr6V | NZ003W | 2024-11-03T14:07:33.637Z | 2024-11-03T14:07:33.637Z |
5457484 | 5457484 | 20241102143639_ov7WT | NZ003W | 2024-11-03T14:07:31.800Z | 2024-11-03T14:07:31.800Z |
5457461 | 5457461 | 20241102143347_o27AT | NZ003W | 2024-11-03T14:07:22.655Z | 2024-11-03T14:07:22.655Z |
5457438 | 5457438 | 20241102143029_ti26q | NZ003W | 2024-11-03T14:07:19.264Z | 2024-11-03T14:07:19.264Z |
5457435 | 5457435 | 20241102143014_iiK5A | NZ003W | 2024-11-03T14:07:18.854Z | 2024-11-03T14:07:18.854Z |
5457433 | 5457433 | 20241102142922_7JlhX | NZ003W | 2024-11-03T14:07:18.522Z | 2024-11-03T14:07:18.522Z |
5457218 | 5457218 | 20241102135133_DoKj4 | NZ003W | 2024-11-03T14:06:56.099Z | 2024-11-03T14:06:56.099Z |
5449618 | 5449618 | 20241031160051_SwBVA | NZ003W | 2024-11-02T12:13:13.155Z | 2024-11-03T14:20:55.742Z |
5449604 | 5449604 | 20241031155932_CMPcg | NZ003W | 2024-11-02T12:13:11.298Z | 2024-11-03T14:20:55.657Z |
5449386 | 5449386 | 20241031152948_RCa1W | NZ003W | 2024-11-02T12:12:48.601Z | 2024-11-03T14:20:52.174Z |
5449161 | 5449161 | 20241031150047_tmdTC | NZ003W | 2024-11-02T12:12:10.956Z | 2024-11-03T14:20:49.202Z |
5449088 | 5449088 | 20241031145024_pyf1I | NZ003W | 2024-11-02T12:12:04.206Z | 2024-11-03T14:20:48.627Z |
5448939 | 5448939 | 20241031143356_FOwT1 | NZ003W | 2024-11-02T12:11:49.327Z | 2024-11-03T14:20:45.057Z |
5448772 | 5448772 | 20241031141522_eFFQ0 | NZ003W | 2024-11-02T12:11:25.220Z | 2024-11-03T14:20:42.012Z |
5448670 | 5448670 | 20241031140325_SR8QA | NZ003W | 2024-11-02T12:11:17.104Z | 2024-11-03T14:20:41.133Z |
5448565 | 5448565 | 20241031134711_3h251 | NZ003W | 2024-11-02T12:11:06.953Z | 2024-11-03T14:20:39.619Z |
5448460 | 5448460 | 20241031133357_tyLWm | NZ003W | 2024-11-02T12:10:48.135Z | 2024-11-03T14:20:37.969Z |
5448411 | 5448411 | 20241031132841_Qbz14 | NZ003W | 2024-11-02T12:10:43.060Z | 2024-11-03T14:20:36.826Z |
5448072 | 5448072 | 20241031124053_zguSP | NZ003W | 2024-11-02T12:09:53.069Z | 2024-11-03T14:20:32.377Z |
5447801 | 5447801 | 20241031121136_iX92Q | NZ003W | 2024-11-02T12:09:07.574Z | 2024-11-03T14:20:28.266Z |
5447734 | 5447734 | 20241031120611_D1c3q | NZ003W | 2024-11-02T12:09:00.149Z | 2024-11-03T14:20:27.682Z |
5447683 | 5447683 | 20241031120222_BWMr2 | NZ003W | 2024-11-02T12:08:48.511Z | 2024-11-03T14:20:26.353Z |
5447672 | 5447672 | 20241031120148_8zy3Q | NZ003W | 2024-11-02T12:08:47.521Z | 2024-11-03T14:20:26.203Z |
5447524 | 5447524 | 20241031114856_gjvEP | NZ003W | 2024-11-02T12:08:21.958Z | 2024-11-03T14:20:23.573Z |
5447436 | 5447436 | 20241031114135_KcLvV | NZ003W | 2024-11-02T12:08:10.346Z | 2024-11-03T14:20:22.289Z |
5447210 | 5447210 | 20241031111808_QO8ls | NZ003W | 2024-11-02T12:07:29.533Z | 2024-11-03T14:20:18.181Z |
5447065 | 5447065 | 20241031110333_dbiYL | NZ003W | 2024-11-02T12:07:05.393Z | 2024-11-03T14:20:15.279Z |
5446486 | 5446486 | 20241031100410_M6GDd | NZ003W | 2024-11-02T12:05:26.848Z | 2024-11-03T14:20:03.171Z |
5446308 | 5446308 | 20241031094706_t2BYl | NZ003W | 2024-11-02T12:04:50.012Z | 2024-11-03T14:20:00.015Z |
5445619 | 5445619 | 20241031082731_Ee6CL | NZ003W | 2024-11-02T12:02:39.699Z | 2024-11-03T14:19:46.822Z |
5437988 | 5437988 | 20241030161036_mvyMF | NZ003W | 2024-11-01T12:10:49.426Z | 2024-11-03T14:22:41.130Z |
5437872 | 5437872 | 20241030155443_aNcJg | NZ003W | 2024-11-01T12:10:35.089Z | 2024-11-03T14:22:40.787Z |
5437797 | 5437797 | 20241030154358_3DxLS | NZ003W | 2024-11-01T12:10:20.904Z | 2024-11-03T14:22:40.613Z |
5437697 | 5437697 | 20241030153628_Mf2Tx | NZ003W | 2024-11-01T12:10:12.680Z | 2024-11-03T14:22:40.314Z |
5437503 | 5437503 | 20241030151515_tlC2h | NZ003W | 2024-11-01T12:09:54.990Z | 2024-11-03T14:22:39.783Z |
5437446 | 5437446 | 20241030150905_hnIoD | NZ003W | 2024-11-01T12:09:38.731Z | 2024-11-03T14:22:39.622Z |
5437385 | 5437385 | 20241030150201_xDNCs | NZ003W | 2024-11-01T12:09:29.680Z | 2024-11-03T14:22:39.419Z |
5437274 | 5437274 | 20241030144910_7QH1B | NZ003W | 2024-11-01T12:09:19.305Z | 2024-11-03T14:22:38.958Z |
5436478 | 5436478 | 20241030131221_m3aq2 | NZ003W | 2024-11-01T12:07:44.471Z | 2024-11-03T14:22:36.793Z |
5436420 | 5436420 | 20241030130511_TsMR5 | NZ003W | 2024-11-01T12:07:31.844Z | 2024-11-03T14:22:36.528Z |
5436244 | 5436244 | 20241030124134_6Wa33 | NZ003W | 2024-11-01T12:07:09.870Z | 2024-11-03T14:22:35.978Z |
5436217 | 5436217 | 20241030123842_wEFX6 | NZ003W | 2024-11-01T12:07:07.377Z | 2024-11-03T14:22:35.865Z |
5435986 | 5435986 | 20241030121723_7FWKS | NZ003W | 2024-11-01T12:06:29.522Z | 2024-11-03T14:22:34.775Z |
5435785 | 5435785 | 20241030115553_2TBbs | NZ003W | 2024-11-01T12:05:53.093Z | 2024-11-03T14:22:34.051Z |
5435594 | 5435594 | 20241030114328_xnlm4 | NZ003W | 2024-11-01T12:05:37.926Z | 2024-11-03T14:22:33.287Z |
5434750 | 5434750 | 20241030101014_xnCO4 | NZ003W | 2024-11-01T12:03:17.365Z | 2024-11-03T14:22:25.981Z |
5434658 | 5434658 | 20241030095542_xMkhR | NZ003W | 2024-11-01T12:03:02.545Z | 2024-11-03T14:22:25.272Z |
5427712 | 5427712 | 20241028153601_1LbNd | NZ003W | 2024-10-31T12:13:51.375Z | 2024-11-03T14:24:48.473Z |
5427625 | 5427625 | 20241028152257_TNI17 | NZ003W | 2024-10-31T12:13:41.426Z | 2024-11-03T14:24:48.124Z |
5427278 | 5427278 | 20241028145401_UAc9E | NZ003W | 2024-10-31T12:13:23.852Z | 2024-11-03T14:24:46.507Z |
5427257 | 5427257 | 20241028145207_cBwoB | NZ003W | 2024-10-31T12:13:22.778Z | 2024-11-03T14:24:46.406Z |
5427219 | 5427219 | 20241028144539_dk56m | NZ003W | 2024-10-31T12:13:20.629Z | 2024-11-03T14:24:46.363Z |
5427093 | 5427093 | 20241028143011_L3kUD | NZ003W | 2024-10-31T12:13:07.134Z | 2024-11-03T14:24:45.814Z |
5426954 | 5426954 | 20241028141533_DHWEY | NZ003W | 2024-10-31T12:12:42.796Z | 2024-11-03T14:24:45.477Z |
5426822 | 5426822 | 20241028140126_dYOBl | NZ003W | 2024-10-31T12:12:30.323Z | 2024-11-03T14:24:45.065Z |
5426765 | 5426765 | 20241028135433_LVZ6r | NZ003W | 2024-10-31T12:12:27.395Z | 2024-11-03T14:24:45.031Z |
5425005 | 5425005 | 20241029153917_LQNFd | NZ003W | 2024-10-31T12:06:39.412Z | 2024-11-03T14:23:40.225Z |
5424914 | 5424914 | 20241029153200_qhQMw | NZ003W | 2024-10-31T12:06:29.264Z | 2024-11-03T14:23:39.756Z |
5424863 | 5424863 | 20241029152417_hdlYR | NZ003W | 2024-10-31T12:06:11.934Z | 2024-11-03T14:23:39.541Z |
5424851 | 5424851 | 20241029152136_2GroJ | NZ003W | 2024-10-31T12:06:09.300Z | 2024-11-03T14:23:39.476Z |
5424708 | 5424708 | 20241029150310_P3xov | NZ003W | 2024-10-31T12:05:52.661Z | 2024-11-03T14:23:38.590Z |
5424702 | 5424702 | 20241029150212_nQlYR | NZ003W | 2024-10-31T12:05:51.825Z | 2024-11-03T14:23:38.559Z |
5424582 | 5424582 | 20241029144817_VHxPX | NZ003W | 2024-10-31T12:05:29.001Z | 2024-11-03T14:23:38.159Z |
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);