participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,157 rows where station_code = "NZ0026" 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 |
---|---|---|---|---|---|
5474015 | 5474015 | 20241103153816_PqRmN | NZ0026 | 2024-11-05T14:10:00.324Z | 2024-11-09T14:21:42.741Z |
5473984 | 5473984 | 20241103153426_fg5UA | NZ0026 | 2024-11-05T14:09:58.082Z | 2024-11-09T14:21:42.355Z |
5473722 | 5473722 | 20241103145512_xEz1v | NZ0026 | 2024-11-05T14:09:34.275Z | 2024-11-09T14:21:40.658Z |
5473686 | 5473686 | 20241103144908_8mAZP | NZ0026 | 2024-11-05T14:09:24.495Z | 2024-11-09T14:21:40.380Z |
5473680 | 5473680 | 20241103144853_J8lxx | NZ0026 | 2024-11-05T14:09:23.398Z | 2024-11-09T14:21:40.377Z |
5473654 | 5473654 | 20241103144606_g5Ad3 | NZ0026 | 2024-11-05T14:09:19.795Z | 2024-11-09T14:21:40.277Z |
5473642 | 5473642 | 20241103144444_yUSuA | NZ0026 | 2024-11-05T14:09:18.823Z | 2024-11-09T14:21:40.272Z |
5471161 | 5471161 | 20241104105515_IAIte | NZ0026 | 2024-11-05T14:03:00.603Z | 2024-11-09T14:20:28.916Z |
5471074 | 5471074 | 20241104104224_9FLdV | NZ0026 | 2024-11-05T14:02:43.885Z | 2024-11-09T14:20:28.228Z |
5471058 | 5471058 | 20241104104122_Hkbky | NZ0026 | 2024-11-05T14:02:40.285Z | 2024-11-09T14:20:28.092Z |
5470720 | 5470720 | 20241104093232_e5Ix2 | NZ0026 | 2024-11-05T14:01:39.841Z | 2024-11-09T14:20:23.817Z |
5470687 | 5470687 | 20241104091950_ueunG | NZ0026 | 2024-11-05T14:01:33.196Z | 2024-11-09T14:20:22.896Z |
5470682 | 5470682 | 20241104091932_ROrZE | NZ0026 | 2024-11-05T14:01:32.088Z | 2024-11-09T14:20:22.608Z |
5461136 | 5461136 | 20241101160827_ihXAP | NZ0026 | 2024-11-03T14:14:45.325Z | 2024-11-09T14:23:27.126Z |
5461080 | 5461080 | 20241101155018_Z9PMu | NZ0026 | 2024-11-03T14:14:42.304Z | 2024-11-09T14:23:26.896Z |
5460990 | 5460990 | 20241101153112_n1XkE | NZ0026 | 2024-11-03T14:14:38.112Z | 2024-11-09T14:23:26.255Z |
5460935 | 5460935 | 20241101152302_PkZCf | NZ0026 | 2024-11-03T14:14:35.108Z | 2024-11-09T14:23:25.862Z |
5460710 | 5460710 | 20241101145547_IFU2T | NZ0026 | 2024-11-03T14:14:16.745Z | 2024-11-09T14:23:24.855Z |
5460622 | 5460622 | 20241101143906_PXT9b | NZ0026 | 2024-11-03T14:14:04.590Z | 2024-11-09T14:23:24.663Z |
5460604 | 5460604 | 20241101143747_i0Gvx | NZ0026 | 2024-11-03T14:14:02.734Z | 2024-11-09T14:23:24.652Z |
5460557 | 5460557 | 20241101143025_DvbXH | NZ0026 | 2024-11-03T14:13:58.979Z | 2024-11-09T14:23:24.548Z |
5458045 | 5458045 | 20241102160253_J9LuO | NZ0026 | 2024-11-03T14:08:36.581Z | 2024-11-09T14:22:49.412Z |
5458002 | 5458002 | 20241102155654_Kpy2Q | NZ0026 | 2024-11-03T14:08:31.975Z | 2024-11-09T14:22:49.356Z |
5457969 | 5457969 | 20241102155108_SF30s | NZ0026 | 2024-11-03T14:08:25.464Z | 2024-11-09T14:22:49.244Z |
5457919 | 5457919 | 20241102154003_dwBKN | NZ0026 | 2024-11-03T14:08:20.996Z | 2024-11-09T14:22:49.088Z |
5457888 | 5457888 | 20241102153459_BEpYC | NZ0026 | 2024-11-03T14:08:18.548Z | 2024-11-09T14:22:49.029Z |
5457853 | 5457853 | 20241102153007_SrxYn | NZ0026 | 2024-11-03T14:08:16.364Z | 2024-11-09T14:22:48.973Z |
5457693 | 5457693 | 20241102151010_P5MuQ | NZ0026 | 2024-11-03T14:07:51.839Z | 2024-11-09T14:22:48.445Z |
5457661 | 5457661 | 20241102150407_EqPcI | NZ0026 | 2024-11-03T14:07:47.802Z | 2024-11-09T14:22:48.364Z |
5457574 | 5457574 | 20241102144758_IWJzX | NZ0026 | 2024-11-03T14:07:41.079Z | 2024-11-09T14:22:48.203Z |
5457534 | 5457534 | 20241102144028_M3LV4 | NZ0026 | 2024-11-03T14:07:36.543Z | 2024-11-09T14:22:48.113Z |
5457497 | 5457497 | 20241102143842_xw2hV | NZ0026 | 2024-11-03T14:07:34.368Z | 2024-11-09T14:22:48.041Z |
5457423 | 5457423 | 20241102142849_1njXB | NZ0026 | 2024-11-03T14:07:17.474Z | 2024-11-09T14:22:47.702Z |
5457259 | 5457259 | 20241102135944_mzdSF | NZ0026 | 2024-11-03T14:07:00.096Z | 2024-11-09T14:22:47.203Z |
5457236 | 5457236 | 20241102135435_BQcO2 | NZ0026 | 2024-11-03T14:06:57.878Z | 2024-11-09T14:22:47.171Z |
5457223 | 5457223 | 20241102135352_hy7vN | NZ0026 | 2024-11-03T14:06:57.321Z | 2024-11-09T14:22:47.168Z |
5457213 | 5457213 | 20241102135102_PpNf4 | NZ0026 | 2024-11-03T14:06:54.461Z | 2024-11-09T14:22:47.128Z |
5457141 | 5457141 | 20241102133705_pgj14 | NZ0026 | 2024-11-03T14:06:38.303Z | 2024-11-09T14:22:46.829Z |
5457094 | 5457094 | 20241102132958_2NIaB | NZ0026 | 2024-11-03T14:06:33.038Z | 2024-11-09T14:22:46.658Z |
5457067 | 5457067 | 20241102132603_UHXhs | NZ0026 | 2024-11-03T14:06:29.371Z | 2024-11-09T14:22:46.521Z |
5457062 | 5457062 | 20241102132408_nIllQ | NZ0026 | 2024-11-03T14:06:28.417Z | 2024-11-09T14:22:46.517Z |
5456992 | 5456992 | 20241102131119_r9T5U | NZ0026 | 2024-11-03T14:06:19.829Z | 2024-11-09T14:22:46.343Z |
5456989 | 5456989 | 20241102130622_7UlJg | NZ0026 | 2024-11-03T14:06:19.453Z | 2024-11-09T14:22:46.329Z |
5456971 | 5456971 | 20241102130253_0tB5k | NZ0026 | 2024-11-03T14:06:13.951Z | 2024-11-09T14:22:46.314Z |
5456917 | 5456917 | 20241102125052_JPiDK | NZ0026 | 2024-11-03T14:06:00.448Z | 2024-11-09T14:22:46.095Z |
5456735 | 5456735 | 20241102121212_KeABw | NZ0026 | 2024-11-03T14:05:35.092Z | 2024-11-09T14:22:45.299Z |
5455554 | 5455554 | 20241102082437_LkDPW | NZ0026 | 2024-11-03T14:01:22.121Z | 2024-11-09T14:22:36.775Z |
5448641 | 5448641 | 20241031140015_1pQVg | NZ0026 | 2024-11-02T12:11:14.184Z | 2024-11-09T14:24:06.875Z |
5448610 | 5448610 | 20241031135411_MCJdr | NZ0026 | 2024-11-02T12:11:10.883Z | 2024-11-09T14:24:06.655Z |
5448526 | 5448526 | 20241031134337_cIA5i | NZ0026 | 2024-11-02T12:11:00.769Z | 2024-11-09T14:24:06.328Z |
5448451 | 5448451 | 20241031133320_jp9uX | NZ0026 | 2024-11-02T12:10:47.520Z | 2024-11-09T14:24:05.915Z |
5448387 | 5448387 | 20241031132342_DQ5TO | NZ0026 | 2024-11-02T12:10:40.421Z | 2024-11-09T14:24:05.737Z |
5448204 | 5448204 | 20241031125842_expEE | NZ0026 | 2024-11-02T12:10:15.977Z | 2024-11-09T14:24:03.924Z |
5448004 | 5448004 | 20241031123205_SFPfC | NZ0026 | 2024-11-02T12:09:43.202Z | 2024-11-09T14:24:02.313Z |
5447844 | 5447844 | 20241031121632_kJO3Y | NZ0026 | 2024-11-02T12:09:17.082Z | 2024-11-09T14:24:01.519Z |
5447751 | 5447751 | 20241031120833_NExrX | NZ0026 | 2024-11-02T12:09:02.120Z | 2024-11-09T14:24:01.315Z |
5447738 | 5447738 | 20241031120618_23DNd | NZ0026 | 2024-11-02T12:09:00.520Z | 2024-11-09T14:24:01.151Z |
5447598 | 5447598 | 20241031115457_9KBrX | NZ0026 | 2024-11-02T12:08:33.818Z | 2024-11-09T14:24:00.550Z |
5447082 | 5447082 | 20241031110711_KGgSn | NZ0026 | 2024-11-02T12:07:14.061Z | 2024-11-09T14:23:57.899Z |
5446871 | 5446871 | 20241031104125_EZWYA | NZ0026 | 2024-11-02T12:06:34.900Z | 2024-11-09T14:23:56.896Z |
5445649 | 5445649 | 20241031083100_mhpem | NZ0026 | 2024-11-02T12:02:45.021Z | 2024-11-09T14:23:51.053Z |
5438052 | 5438052 | 20241030161749_untm3 | NZ0026 | 2024-11-01T12:10:55.077Z | 2024-11-08T14:22:58.769Z |
5438022 | 5438022 | 20241030161514_WN21s | NZ0026 | 2024-11-01T12:10:52.738Z | 2024-11-08T14:22:58.720Z |
5437856 | 5437856 | 20241030155158_0Arm4 | NZ0026 | 2024-11-01T12:10:31.960Z | 2024-11-08T14:22:58.238Z |
5437833 | 5437833 | 20241030154911_w3zXQ | NZ0026 | 2024-11-01T12:10:26.344Z | 2024-11-08T14:22:58.228Z |
5437816 | 5437816 | 20241030154657_AtHw1 | NZ0026 | 2024-11-01T12:10:23.912Z | 2024-11-08T14:22:58.147Z |
5437476 | 5437476 | 20241030151107_wXQQ9 | NZ0026 | 2024-11-01T12:09:46.808Z | 2024-11-08T14:22:57.234Z |
5437459 | 5437459 | 20241030151007_y2OEl | NZ0026 | 2024-11-01T12:09:41.230Z | 2024-11-08T14:22:57.214Z |
5437360 | 5437360 | 20241030145948_bpubi | NZ0026 | 2024-11-01T12:09:27.834Z | 2024-11-08T14:22:57.083Z |
5437316 | 5437316 | 20241030145423_iFiT4 | NZ0026 | 2024-11-01T12:09:23.882Z | 2024-11-08T14:22:56.990Z |
5437071 | 5437071 | 20241030142516_Wm4pW | NZ0026 | 2024-11-01T12:08:49.858Z | 2024-11-08T14:22:56.610Z |
5437061 | 5437061 | 20241030142429_D8gEw | NZ0026 | 2024-11-01T12:08:49.207Z | 2024-11-08T14:22:56.608Z |
5436981 | 5436981 | 20241030141418_bQN31 | NZ0026 | 2024-11-01T12:08:39.420Z | 2024-11-08T14:22:55.866Z |
5436934 | 5436934 | 20241030140712_4BmZ2 | NZ0026 | 2024-11-01T12:08:36.315Z | 2024-11-08T14:22:55.835Z |
5436842 | 5436842 | 20241030135518_rZgRD | NZ0026 | 2024-11-01T12:08:27.580Z | 2024-11-08T14:22:55.681Z |
5436733 | 5436733 | 20241030134323_PPJvA | NZ0026 | 2024-11-01T12:08:09.091Z | 2024-11-08T14:22:54.807Z |
5436712 | 5436712 | 20241030134114_1Ts75 | NZ0026 | 2024-11-01T12:08:07.238Z | 2024-11-08T14:22:54.597Z |
5436686 | 5436686 | 20241030133735_9NUq3 | NZ0026 | 2024-11-01T12:08:05.747Z | 2024-11-08T14:22:54.590Z |
5436653 | 5436653 | 20241030133242_9Qlq2 | NZ0026 | 2024-11-01T12:08:01.369Z | 2024-11-08T14:22:54.568Z |
5435952 | 5435952 | 20241030121314_zcPFi | NZ0026 | 2024-11-01T12:06:26.083Z | 2024-11-08T14:22:52.186Z |
5435738 | 5435738 | 20241030115354_GhxBz | NZ0026 | 2024-11-01T12:05:50.426Z | 2024-11-08T14:22:51.477Z |
5435726 | 5435726 | 20241030115321_hzex2 | NZ0026 | 2024-11-01T12:05:49.187Z | 2024-11-08T14:22:51.422Z |
5435548 | 5435548 | 20241030114100_t2Sbi | NZ0026 | 2024-11-01T12:05:29.270Z | 2024-11-08T14:22:51.127Z |
5435039 | 5435039 | 20241030104241_pgTAP | NZ0026 | 2024-11-01T12:04:02.890Z | 2024-11-08T14:22:48.985Z |
5434464 | 5434464 | 20241030092711_nRWE0 | NZ0026 | 2024-11-01T12:02:27.052Z | 2024-11-08T14:22:46.590Z |
5434084 | 5434084 | 20241030081700_JCxHt | NZ0026 | 2024-11-01T12:01:09.644Z | 2024-11-08T14:22:44.749Z |
5427412 | 5427412 | 20241028150329_eESmU | NZ0026 | 2024-10-31T12:13:30.966Z | 2024-11-06T14:27:11.731Z |
5427334 | 5427334 | 20241028145827_vVyum | NZ0026 | 2024-10-31T12:13:27.215Z | 2024-11-06T14:27:11.668Z |
5427324 | 5427324 | 20241028145741_8oXq5 | NZ0026 | 2024-10-31T12:13:26.637Z | 2024-11-06T14:27:11.652Z |
5427155 | 5427155 | 20241028143804_Tp9I6 | NZ0026 | 2024-10-31T12:13:16.787Z | 2024-11-06T14:27:11.410Z |
5426888 | 5426888 | 20241028140735_xX8SK | NZ0026 | 2024-10-31T12:12:35.919Z | 2024-11-06T14:27:10.721Z |
5426843 | 5426843 | 20241028140335_GO0er | NZ0026 | 2024-10-31T12:12:32.799Z | 2024-11-06T14:27:10.694Z |
5426749 | 5426749 | 20241028135307_fYbx7 | NZ0026 | 2024-10-31T12:12:26.129Z | 2024-11-06T14:27:10.595Z |
5426713 | 5426713 | 20241028134615_q53Mv | NZ0026 | 2024-10-31T12:12:23.692Z | 2024-11-06T14:27:10.560Z |
5422523 | 5422523 | 20241028131100_r7Cut | NZ0026 | 2024-10-30T12:20:27.479Z | 2024-11-06T14:27:10.276Z |
5422487 | 5422487 | 20241028130757_jldP7 | NZ0026 | 2024-10-30T12:20:27.158Z | 2024-11-06T14:27:10.237Z |
5422354 | 5422354 | 20241028125350_MdVpL | NZ0026 | 2024-10-30T12:20:25.814Z | 2024-11-06T14:27:10.095Z |
5422218 | 5422218 | 20241028123307_mQsOv | NZ0026 | 2024-10-30T12:20:23.913Z | 2024-11-06T14:27:09.643Z |
5422188 | 5422188 | 20241028122707_Mx3rj | NZ0026 | 2024-10-30T12:20:23.603Z | 2024-11-06T14:27:09.540Z |
5421759 | 5421759 | 20241028113416_TQavB | NZ0026 | 2024-10-30T12:20:14.515Z | 2024-11-06T14:27:08.385Z |
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);