participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
938 rows where station_code = "NZ002A" 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 |
---|---|---|---|---|---|
5433711 | 5433711 | 20241027091501_vjN1y | NZ002A | 2024-10-31T12:23:03.774Z | 2024-11-05T14:26:55.717Z |
5426549 | 5426549 | 20241028095032_FNaF2 | NZ002A | 2024-10-31T12:10:58.449Z | 2024-11-06T14:27:05.546Z |
5426547 | 5426547 | 20241028083559_Eba2Y | NZ002A | 2024-10-31T12:10:43.993Z | 2024-11-06T14:27:04.131Z |
5422506 | 5422506 | 20241028130917_lztZ3 | NZ002A | 2024-10-30T12:20:27.333Z | 2024-11-06T14:27:10.256Z |
5422106 | 5422106 | 20241028121528_Na7aT | NZ002A | 2024-10-30T12:20:22.146Z | 2024-11-06T14:27:09.386Z |
5421988 | 5421988 | 20241028120522_71jHM | NZ002A | 2024-10-30T12:20:19.622Z | 2024-11-06T14:27:08.942Z |
5421974 | 5421974 | 20241028120456_8YZL2 | NZ002A | 2024-10-30T12:20:19.417Z | 2024-11-06T14:27:08.934Z |
5415008 | 5415008 | 20241027124309_AN54x | NZ002A | 2024-10-30T12:08:48.285Z | 2024-11-05T14:27:03.214Z |
5414945 | 5414945 | 20241027123207_4Y0xa | NZ002A | 2024-10-30T12:08:42.248Z | 2024-11-05T14:27:03.036Z |
5414905 | 5414905 | 20241027122605_JT3Zz | NZ002A | 2024-10-30T12:08:37.326Z | 2024-11-05T14:27:02.737Z |
5414201 | 5414201 | 20241027111418_JhFZJ | NZ002A | 2024-10-30T12:06:48.788Z | 2024-11-05T14:26:59.516Z |
5414181 | 5414181 | 20241027111309_PDR6z | NZ002A | 2024-10-30T12:06:46.735Z | 2024-11-05T14:26:59.499Z |
5414118 | 5414118 | 20241027110821_vymAh | NZ002A | 2024-10-30T12:06:39.434Z | 2024-11-05T14:26:59.359Z |
5413715 | 5413715 | 20241028105135_RT34x | NZ002A | 2024-10-30T12:04:01.693Z | 2024-11-06T14:27:07.531Z |
5413083 | 5413083 | 20241028084433_7MZKG | NZ002A | 2024-10-30T12:01:46.705Z | 2024-11-06T14:27:04.356Z |
5412204 | 5412204 | 20241027100957_dDXsx | NZ002A | 2024-10-29T12:19:33.815Z | 2024-11-05T14:26:57.875Z |
5411828 | 5411828 | 20241027093029_7UlWO | NZ002A | 2024-10-29T12:19:14.649Z | 2024-11-05T14:26:56.327Z |
5411756 | 5411756 | 20241027092129_BnpPe | NZ002A | 2024-10-29T12:19:11.186Z | 2024-11-05T14:26:55.954Z |
5392271 | 5392271 | 20241026154402_N23Z6 | NZ002A | 2024-10-28T12:07:35.452Z | 2024-11-04T14:28:37.918Z |
5174274 | 5174274 | 20240927165007_tBXd9 | NZ002A | 2024-09-28T12:13:42.519Z | 2024-10-05T12:28:57.715Z |
5173547 | 5173547 | 20240927150731_rPXGw | NZ002A | 2024-09-28T12:12:30.101Z | 2024-10-05T12:28:55.675Z |
5173392 | 5173392 | 20240927144616_GTdes | NZ002A | 2024-09-28T12:12:14.407Z | 2024-10-05T12:28:55.477Z |
5173325 | 5173325 | 20240927143923_XJzpk | NZ002A | 2024-09-28T12:12:09.094Z | 2024-10-05T12:28:55.382Z |
5173191 | 5173191 | 20240927142423_2af3u | NZ002A | 2024-09-28T12:12:01.351Z | 2024-10-05T12:28:54.937Z |
5173149 | 5173149 | 20240927142054_TiIrK | NZ002A | 2024-09-28T12:11:59.282Z | 2024-10-05T12:28:54.853Z |
5172735 | 5172735 | 20240927132941_XSIrN | NZ002A | 2024-09-28T12:11:19.415Z | 2024-10-05T12:28:53.611Z |
5172642 | 5172642 | 20240927131107_4sNtq | NZ002A | 2024-09-28T12:11:13.261Z | 2024-10-05T12:28:53.142Z |
5172629 | 5172629 | 20240927130719_LS6F0 | NZ002A | 2024-09-28T12:11:12.381Z | 2024-10-05T12:28:53.103Z |
5172566 | 5172566 | 20240927125803_RnVE6 | NZ002A | 2024-09-28T12:11:03.154Z | 2024-10-05T12:28:52.764Z |
5172523 | 5172523 | 20240927124949_fzbmQ | NZ002A | 2024-09-28T12:10:54.600Z | 2024-10-05T12:28:52.539Z |
5172483 | 5172483 | 20240927124529_nE0h8 | NZ002A | 2024-09-28T12:10:51.899Z | 2024-10-05T12:28:52.492Z |
5172204 | 5172204 | 20240927115527_YA2Kh | NZ002A | 2024-09-28T12:10:12.741Z | 2024-10-05T12:28:50.676Z |
5172094 | 5172094 | 20240927114525_ejU96 | NZ002A | 2024-09-28T12:09:59.236Z | 2024-10-05T12:28:49.715Z |
5171596 | 5171596 | 20240927102802_lw7f1 | NZ002A | 2024-09-28T12:09:00.505Z | 2024-10-05T12:28:47.393Z |
5171495 | 5171495 | 20240927101756_ruuiQ | NZ002A | 2024-09-28T12:08:49.077Z | 2024-10-05T12:28:46.545Z |
5171263 | 5171263 | 20240927093120_82Ugi | NZ002A | 2024-09-28T12:08:12.927Z | 2024-10-05T12:28:44.415Z |
5171100 | 5171100 | 20240927090834_0lY2J | NZ002A | 2024-09-28T12:07:49.772Z | 2024-10-05T12:28:44.006Z |
5171041 | 5171041 | 20240927085455_sH916 | NZ002A | 2024-09-28T12:07:40.960Z | 2024-10-05T12:28:43.431Z |
5171032 | 5171032 | 20240927085404_eXpkm | NZ002A | 2024-09-28T12:07:39.952Z | 2024-10-05T12:28:43.428Z |
5170729 | 5170729 | 20240927075628_eDW9V | NZ002A | 2024-09-28T12:07:01.782Z | 2024-10-05T12:28:41.681Z |
5170659 | 5170659 | 20240927073832_4I8hI | NZ002A | 2024-09-28T12:06:49.416Z | 2024-10-05T12:28:41.266Z |
5164108 | 5164108 | 20240924163139_XDsPJ | NZ002A | 2024-09-26T12:12:23.225Z | 2024-10-02T12:19:01.107Z |
5164087 | 5164087 | 20240924162553_tqkDW | NZ002A | 2024-09-26T12:12:21.203Z | 2024-10-02T12:19:01.067Z |
5163972 | 5163972 | 20240924160928_a2E29 | NZ002A | 2024-09-26T12:12:15.349Z | 2024-10-02T12:19:00.960Z |
5163800 | 5163800 | 20240924154517_cxhCA | NZ002A | 2024-09-26T12:12:07.011Z | 2024-10-02T12:19:00.670Z |
5163754 | 5163754 | 20240924153559_xJJ7m | NZ002A | 2024-09-26T12:12:04.380Z | 2024-10-02T12:19:00.577Z |
5163681 | 5163681 | 20240924152403_F2p4r | NZ002A | 2024-09-26T12:12:00.048Z | 2024-10-02T12:19:00.404Z |
5163614 | 5163614 | 20240924151314_RvBtT | NZ002A | 2024-09-26T12:11:57.229Z | 2024-10-02T12:19:00.302Z |
5163557 | 5163557 | 20240924150327_Lqn21 | NZ002A | 2024-09-26T12:11:54.419Z | 2024-10-02T12:19:00.214Z |
5162310 | 5162310 | 20240924112633_pCe37 | NZ002A | 2024-09-26T12:10:42.476Z | 2024-10-02T12:18:56.944Z |
5161460 | 5161460 | 20240925155003_UdJNc | NZ002A | 2024-09-26T12:08:02.817Z | 2024-10-03T12:25:30.055Z |
5161364 | 5161364 | 20240925151734_bAguX | NZ002A | 2024-09-26T12:07:56.461Z | 2024-10-03T12:25:29.547Z |
5154257 | 5154257 | 20240923155406_AhMf8 | NZ002A | 2024-09-24T12:07:27.479Z | 2024-10-01T12:22:19.482Z |
5153960 | 5153960 | 20240923144137_mJ4AN | NZ002A | 2024-09-24T12:07:10.968Z | 2024-10-01T12:22:19.133Z |
5153948 | 5153948 | 20240923143952_9vJMb | NZ002A | 2024-09-24T12:07:10.640Z | 2024-10-01T12:22:19.130Z |
5153917 | 5153917 | 20240923143307_jvKl7 | NZ002A | 2024-09-24T12:07:09.089Z | 2024-10-01T12:22:19.063Z |
5153894 | 5153894 | 20240923142257_rXphC | NZ002A | 2024-09-24T12:07:07.918Z | 2024-10-01T12:22:19.053Z |
5153753 | 5153753 | 20240923133548_p2y6O | NZ002A | 2024-09-24T12:06:59.090Z | 2024-10-01T12:22:18.813Z |
5153735 | 5153735 | 20240923132903_W6cXY | NZ002A | 2024-09-24T12:06:57.759Z | 2024-10-01T12:22:18.790Z |
5153672 | 5153672 | 20240923131037_lW8RG | NZ002A | 2024-09-24T12:06:48.287Z | 2024-10-01T12:22:18.740Z |
5153642 | 5153642 | 20240923130459_90XSS | NZ002A | 2024-09-24T12:06:43.666Z | 2024-10-01T12:22:18.659Z |
5153637 | 5153637 | 20240923130453_ipal1 | NZ002A | 2024-09-24T12:06:43.458Z | 2024-10-01T12:22:18.649Z |
5153552 | 5153552 | 20240923124126_M3n40 | NZ002A | 2024-09-24T12:06:28.628Z | 2024-10-01T12:22:18.373Z |
5153457 | 5153457 | 20240923121610_RsQgH | NZ002A | 2024-09-24T12:06:18.386Z | 2024-10-01T12:22:18.172Z |
5153434 | 5153434 | 20240923121228_bORN3 | NZ002A | 2024-09-24T12:06:16.504Z | 2024-10-01T12:22:18.095Z |
5153387 | 5153387 | 20240923120916_kxVQg | NZ002A | 2024-09-24T12:06:13.162Z | 2024-10-01T12:22:17.906Z |
5153258 | 5153258 | 20240923115016_A3uZw | NZ002A | 2024-09-24T12:06:05.520Z | 2024-10-01T12:22:17.600Z |
5152255 | 5152255 | 20240923085015_zkVKV | NZ002A | 2024-09-24T12:04:14.858Z | 2024-10-01T12:22:13.779Z |
5149569 | 5149569 | 20240922164626_KVpHM | NZ002A | 2024-09-23T12:08:45.357Z | 2024-09-30T12:22:48.727Z |
5149527 | 5149527 | 20240922163345_AdOPA | NZ002A | 2024-09-23T12:08:43.473Z | 2024-09-30T12:22:48.624Z |
5149401 | 5149401 | 20240922154123_sfkGA | NZ002A | 2024-09-23T12:08:26.575Z | 2024-09-30T12:22:48.456Z |
5149349 | 5149349 | 20240922152526_gbAPz | NZ002A | 2024-09-23T12:08:21.871Z | 2024-09-30T12:22:48.374Z |
5149253 | 5149253 | 20240922145029_OrjZp | NZ002A | 2024-09-23T12:08:07.360Z | 2024-09-30T12:22:48.159Z |
5149227 | 5149227 | 20240922144422_XOuSb | NZ002A | 2024-09-23T12:08:05.556Z | 2024-09-30T12:22:48.151Z |
5149218 | 5149218 | 20240922144231_bz27y | NZ002A | 2024-09-23T12:08:04.296Z | 2024-09-30T12:22:48.148Z |
5149137 | 5149137 | 20240922141424_a0Ujg | NZ002A | 2024-09-23T12:07:54.748Z | 2024-09-30T12:22:47.627Z |
5148974 | 5148974 | 20240922125912_S6SsN | NZ002A | 2024-09-23T12:07:39.310Z | 2024-09-30T12:22:47.406Z |
5148923 | 5148923 | 20240922123645_QFgsQ | NZ002A | 2024-09-23T12:07:33.902Z | 2024-09-30T12:22:47.343Z |
5148855 | 5148855 | 20240922121248_WtwVN | NZ002A | 2024-09-23T12:07:29.547Z | 2024-09-30T12:22:47.218Z |
5148733 | 5148733 | 20240922115642_njxGo | NZ002A | 2024-09-23T12:07:23.399Z | 2024-09-30T12:22:46.953Z |
5148601 | 5148601 | 20240922113140_ofrj4 | NZ002A | 2024-09-23T12:07:15.556Z | 2024-09-30T12:22:46.743Z |
5148353 | 5148353 | 20240922104335_CZrv1 | NZ002A | 2024-09-23T12:06:44.039Z | 2024-09-30T12:22:46.230Z |
5148347 | 5148347 | 20240922104148_8Q2KC | NZ002A | 2024-09-23T12:06:43.096Z | 2024-09-30T12:22:46.227Z |
5148079 | 5148079 | 20240922095111_wFfz0 | NZ002A | 2024-09-23T12:06:14.885Z | 2024-09-30T12:22:45.597Z |
5141138 | 5141138 | 20240920151219_wKgzX | NZ002A | 2024-09-21T12:05:03.752Z | 2024-09-28T12:23:24.388Z |
5140998 | 5140998 | 20240920141430_gPsOb | NZ002A | 2024-09-21T12:04:49.366Z | 2024-09-28T12:23:23.803Z |
5140966 | 5140966 | 20240920140252_C4ZKq | NZ002A | 2024-09-21T12:04:45.204Z | 2024-09-28T12:23:23.673Z |
5140959 | 5140959 | 20240920135914_B03jX | NZ002A | 2024-09-21T12:04:44.651Z | 2024-09-28T12:23:23.670Z |
5140902 | 5140902 | 20240920131506_VpBky | NZ002A | 2024-09-21T12:04:41.323Z | 2024-09-28T12:23:23.515Z |
5140782 | 5140782 | 20240920121335_UIdLb | NZ002A | 2024-09-21T12:04:34.181Z | 2024-09-28T12:23:23.172Z |
5140693 | 5140693 | 20240920114441_VjE31 | NZ002A | 2024-09-21T12:04:29.082Z | 2024-09-28T12:23:22.521Z |
5138279 | 5138279 | 20240919171421_xeteS | NZ002A | 2024-09-20T12:06:42.831Z | 2024-09-27T12:19:58.571Z |
5138231 | 5138231 | 20240919165252_57KSQ | NZ002A | 2024-09-20T12:06:31.071Z | 2024-09-27T12:19:58.162Z |
5138218 | 5138218 | 20240919164747_SkwuV | NZ002A | 2024-09-20T12:06:29.572Z | 2024-09-27T12:19:58.148Z |
5138204 | 5138204 | 20240919163925_eQcPd | NZ002A | 2024-09-20T12:06:25.574Z | 2024-09-27T12:19:58.106Z |
5138098 | 5138098 | 20240919153818_04WWt | NZ002A | 2024-09-20T12:06:13.599Z | 2024-09-27T12:19:57.781Z |
5138029 | 5138029 | 20240919145558_83wKW | NZ002A | 2024-09-20T12:06:07.041Z | 2024-09-27T12:19:57.335Z |
5137968 | 5137968 | 20240919142722_Tc5pF | NZ002A | 2024-09-20T12:06:01.345Z | 2024-09-27T12:19:57.201Z |
5137936 | 5137936 | 20240919141248_4DsNZ | NZ002A | 2024-09-20T12:05:58.974Z | 2024-09-27T12:19:57.100Z |
5135266 | 5135266 | 20240916172837_0JkBz | NZ002A | 2024-09-19T12:18:17.515Z | 2024-09-24T12:16:01.506Z |
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);