home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,086 rows where station_code = "NZ001W" sorted by created_at descending

✎ View and edit SQL

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
9270665 9270665 20260128162011_DH3FW NZ001W 2026-01-29T14:13:14.882Z 2026-01-29T14:13:14.882Z
9270652 9270652 20260128161827_Au0WD NZ001W 2026-01-29T14:13:12.936Z 2026-01-29T14:13:12.936Z
9270219 9270219 20260128151739_PX98F NZ001W 2026-01-29T14:11:20.901Z 2026-01-29T14:11:20.901Z
9269895 9269895 20260128142959_IgGct NZ001W 2026-01-29T14:10:08.837Z 2026-01-29T14:10:08.837Z
9269850 9269850 20260128142513_pM1Rj NZ001W 2026-01-29T14:09:53.441Z 2026-01-29T14:09:53.441Z
9269817 9269817 20260128141730_CFpgr NZ001W 2026-01-29T14:09:44.507Z 2026-01-29T14:09:44.507Z
9269742 9269742 20260128140553_hvTXJ NZ001W 2026-01-29T14:09:27.244Z 2026-01-29T14:09:27.244Z
9269642 9269642 20260128134906_3WIsl NZ001W 2026-01-29T14:08:55.959Z 2026-01-29T14:08:55.959Z
9269638 9269638 20260128134906_V7h89 NZ001W 2026-01-29T14:08:55.551Z 2026-01-29T14:08:55.551Z
9269584 9269584 20260128133951_WYdX3 NZ001W 2026-01-29T14:08:34.243Z 2026-01-29T14:08:34.243Z
9269447 9269447 20260128131929_t911d NZ001W 2026-01-29T14:08:01.861Z 2026-01-29T14:08:01.861Z
9269418 9269418 20260128131412_gcaF2 NZ001W 2026-01-29T14:07:55.238Z 2026-01-29T14:07:55.238Z
9269398 9269398 20260128131229_Lol2t NZ001W 2026-01-29T14:07:51.123Z 2026-01-29T14:07:51.123Z
9268777 9268777 20260128111754_wfxIB NZ001W 2026-01-29T14:04:50.573Z 2026-01-29T14:04:50.573Z
9268774 9268774 20260128111753_g6PA2 NZ001W 2026-01-29T14:04:50.323Z 2026-01-29T14:04:50.323Z
9268601 9268601 20260128105159_3Hu5B NZ001W 2026-01-29T14:03:57.003Z 2026-01-29T14:03:57.003Z
9265862 9265862 20260127160650_45VsP NZ001W 2026-01-28T14:11:37.094Z 2026-01-29T14:30:24.703Z
9265853 9265853 20260127160510_yT6qZ NZ001W 2026-01-28T14:11:36.073Z 2026-01-29T14:30:24.692Z
9265778 9265778 20260127155903_J4LJA NZ001W 2026-01-28T14:11:19.132Z 2026-01-29T14:30:24.674Z
9265124 9265124 20260127142341_af6Ji NZ001W 2026-01-28T14:09:10.250Z 2026-01-29T14:30:24.455Z
9265096 9265096 20260127141555_IaJuH NZ001W 2026-01-28T14:09:01.787Z 2026-01-29T14:30:24.447Z
9265091 9265091 20260127141512_sYJ5F NZ001W 2026-01-28T14:09:00.441Z 2026-01-29T14:30:24.435Z
9257788 9257788 20260125155753_dFe1m NZ001W 2026-01-26T14:07:45.448Z 2026-01-29T14:37:40.121Z
9257016 9257016 20260125113545_ZixjN NZ001W 2026-01-26T14:03:11.311Z 2026-01-29T14:36:41.689Z
9253891 9253891 20260124153406_TQ3xe NZ001W 2026-01-25T14:04:53.303Z 2026-01-29T14:41:46.262Z
9253858 9253858 20260124152055_su022 NZ001W 2026-01-25T14:04:44.033Z 2026-01-29T14:41:43.518Z
9253760 9253760 20260124142801_bc5Xa NZ001W 2026-01-25T14:04:16.486Z 2026-01-29T14:41:25.309Z
9253585 9253585 20260124125216_9IYVS NZ001W 2026-01-25T14:03:25.026Z 2026-01-29T14:40:59.332Z
9253563 9253563 20260124124754_6vY1Q NZ001W 2026-01-25T14:03:20.891Z 2026-01-29T14:40:57.914Z
9253470 9253470 20260124120549_d827q NZ001W 2026-01-25T14:02:55.857Z 2026-01-29T14:40:52.223Z
9253439 9253439 20260124114753_CViNH NZ001W 2026-01-25T14:02:44.089Z 2026-01-29T14:40:50.148Z
9253372 9253372 20260124111916_gv1Hq NZ001W 2026-01-25T14:02:19.423Z 2026-01-29T14:40:45.023Z
9253234 9253234 20260124102046_4rY2H NZ001W 2026-01-25T14:01:32.847Z 2026-01-29T14:40:29.220Z
9250368 9250368 20260123140018_0jfyo NZ001W 2026-01-24T14:02:32.840Z 2026-01-29T14:45:27.351Z
9250012 9250012 20260123093538_8colr NZ001W 2026-01-24T14:00:37.071Z 2026-01-29T14:44:47.683Z
9246787 9246787 20260121142953_54HED NZ001W 2026-01-23T14:07:58.202Z 2026-01-29T14:55:11.511Z
9245826 9245826 20260122144829_EfIqW NZ001W 2026-01-23T14:03:37.793Z 2026-01-29T14:50:15.598Z
9245810 9245810 20260122144217_gBnAY NZ001W 2026-01-23T14:03:34.166Z 2026-01-29T14:50:13.962Z
9245798 9245798 20260122143643_ereSF NZ001W 2026-01-23T14:03:31.651Z 2026-01-29T14:50:13.160Z
9245516 9245516 20260122125340_8R2Xt NZ001W 2026-01-23T14:02:16.297Z 2026-01-29T14:49:45.144Z
9192148 9192148 20260112120918_q8QF6 NZ001W 2026-01-13T14:27:36.522Z 2026-01-20T15:26:00.642Z
9190590 9190590 20260112092622_3aXD0 NZ001W 2026-01-13T14:22:49.429Z 2026-01-20T15:24:40.095Z
9190559 9190559 20260112092256_mjQoU NZ001W 2026-01-13T14:22:42.860Z 2026-01-20T15:24:39.258Z
9185001 9185001 20260111125558_9jbHB NZ001W 2026-01-12T14:22:10.918Z 2026-01-19T15:21:45.003Z
9184745 9184745 20260111121512_0R5ZL NZ001W 2026-01-12T14:21:30.526Z 2026-01-19T15:21:11.671Z
9184117 9184117 20260111104615_vrDTV NZ001W 2026-01-12T14:19:43.517Z 2026-01-19T15:20:23.531Z
9184038 9184038 20260111103806_QiT8m NZ001W 2026-01-12T14:19:32.631Z 2026-01-19T15:20:20.326Z
9183977 9183977 20260111103219_ABJ1t NZ001W 2026-01-12T14:19:20.388Z 2026-01-19T15:20:18.562Z
9183810 9183810 20260111101732_LiZrq NZ001W 2026-01-12T14:18:52.905Z 2026-01-19T15:20:12.446Z
9183664 9183664 20260111095643_2MnQh NZ001W 2026-01-12T14:18:28.568Z 2026-01-19T15:20:05.646Z
9183295 9183295 20260111091005_eboE2 NZ001W 2026-01-12T14:17:22.765Z 2026-01-19T15:19:34.559Z
9179318 9179318 20260111154359_rbJF7 NZ001W 2026-01-12T14:01:08.188Z 2026-01-20T15:20:10.074Z
9179314 9179314 20260111153952_YdGDi NZ001W 2026-01-12T14:01:07.467Z 2026-01-20T15:20:09.215Z
9179277 9179277 20260111151916_cmQMI NZ001W 2026-01-12T14:00:57.921Z 2026-01-20T15:20:01.559Z
9179263 9179263 20260111151250_MLJ28 NZ001W 2026-01-12T14:00:54.628Z 2026-01-20T15:20:00.158Z
9178763 9178763 20260110140504_SGYrs NZ001W 2026-01-11T14:15:41.902Z 2026-01-18T15:11:16.122Z
9178748 9178748 20260110140136_35VGZ NZ001W 2026-01-11T14:15:39.580Z 2026-01-18T15:11:15.398Z
9178712 9178712 20260110134918_Reajm NZ001W 2026-01-11T14:15:35.800Z 2026-01-18T15:11:12.729Z
9178126 9178126 20260110122157_vw9h9 NZ001W 2026-01-11T14:14:05.391Z 2026-01-18T15:10:35.333Z
9174247 9174247 20260110155458_kg6UO NZ001W 2026-01-11T14:01:54.875Z 2026-01-19T15:14:44.735Z
9173969 9173969 20260110151222_dRc0s NZ001W 2026-01-11T14:00:52.061Z 2026-01-19T15:14:29.949Z
9173945 9173945 20260110150644_AsJF1 NZ001W 2026-01-11T14:00:47.945Z 2026-01-19T15:14:28.746Z
9173910 9173910 20260110150112_IS065 NZ001W 2026-01-11T14:00:41.562Z 2026-01-19T15:14:27.192Z
9173820 9173820 20260110144913_ga1lq NZ001W 2026-01-11T14:00:23.074Z 2026-01-19T15:14:12.433Z
9169685 9169685 20260108152411_qu798 NZ001W 2026-01-09T14:14:21.581Z 2026-01-16T15:14:25.060Z
9169393 9169393 20260108142329_p706W NZ001W 2026-01-09T14:13:28.679Z 2026-01-16T15:13:55.842Z
9169254 9169254 20260108135235_uglsO NZ001W 2026-01-09T14:13:08.159Z 2026-01-16T15:13:47.784Z
9169215 9169215 20260108134523_rwA7w NZ001W 2026-01-09T14:13:00.407Z 2026-01-16T15:13:36.051Z
9169183 9169183 20260108133906_chUsK NZ001W 2026-01-09T14:12:55.582Z 2026-01-16T15:13:34.301Z
9168544 9168544 20260108112009_UzHwK NZ001W 2026-01-09T14:11:22.884Z 2026-01-16T15:12:50.397Z
9168484 9168484 20260108110802_Hch44 NZ001W 2026-01-09T14:11:13.818Z 2026-01-16T15:12:47.191Z
9168373 9168373 20260108104944_huCEm NZ001W 2026-01-09T14:10:58.514Z 2026-01-16T15:12:32.796Z
9168302 9168302 20260108103401_Y2qZy NZ001W 2026-01-09T14:10:47.638Z 2026-01-16T15:12:28.267Z
9168097 9168097 20260108095246_wRTOE NZ001W 2026-01-09T14:10:18.958Z 2026-01-16T15:12:18.412Z
9168058 9168058 20260108094509_L513D NZ001W 2026-01-09T14:10:14.038Z 2026-01-16T15:12:16.993Z
9167963 9167963 20260108090335_4MRbh NZ001W 2026-01-09T14:09:58.671Z 2026-01-16T15:12:04.213Z
9164599 9164599 20260107135050_eXdrz NZ001W 2026-01-08T14:13:47.081Z 2026-01-13T15:04:53.640Z
9164557 9164557 20260107134335_xFAzD NZ001W 2026-01-08T14:13:35.522Z 2026-01-13T15:04:51.676Z
9164118 9164118 20260107121007_QQPMG NZ001W 2026-01-08T14:11:59.861Z 2026-01-13T15:04:06.672Z
9163820 9163820 20260107104053_a2hPI NZ001W 2026-01-08T14:10:39.606Z 2026-01-13T15:03:41.323Z
9163778 9163778 20260107103113_89fz9 NZ001W 2026-01-08T14:10:31.012Z 2026-01-13T15:03:37.975Z
9163672 9163672 20260107095619_4p68g NZ001W 2026-01-08T14:10:03.544Z 2026-01-13T15:03:32.176Z
9163646 9163646 20260107094605_Pbo7D NZ001W 2026-01-08T14:09:59.586Z 2026-01-13T15:03:30.973Z
9163555 9163555 20260107090432_cGiTD NZ001W 2026-01-08T14:09:38.371Z 2026-01-13T15:03:27.227Z
9122953 9122953 20260101153616_7XU5h NZ001W 2026-01-02T14:15:57.089Z 2026-01-09T14:54:04.858Z
9122948 9122948 20260101153112_L23m6 NZ001W 2026-01-02T14:15:55.999Z 2026-01-09T14:54:04.486Z
9122891 9122891 20260101150422_n2rpO NZ001W 2026-01-02T14:15:39.618Z 2026-01-09T14:54:00.405Z
9106099 9106099 20251230153321_UuM5U NZ001W 2025-12-31T14:27:42.111Z 2026-01-07T15:11:46.158Z
9097295 9097295 20251227155222_GY4kt NZ001W 2025-12-30T15:08:31.501Z 2026-01-04T15:33:48.810Z
9097289 9097289 20251227155051_nb2eX NZ001W 2025-12-30T15:08:31.391Z 2026-01-04T15:33:48.704Z
9095934 9095934 20251227141836_cWwqW NZ001W 2025-12-30T15:07:06.453Z 2026-01-04T15:32:47.127Z
9095724 9095724 20251227140702_eKhP3 NZ001W 2025-12-30T15:06:44.574Z 2025-12-30T15:06:44.574Z
9095681 9095681 20251227140504_mn2kq NZ001W 2025-12-30T15:06:43.235Z 2026-01-04T15:32:41.117Z
9094681 9094681 20251227124621_pGujg NZ001W 2025-12-30T15:05:44.717Z 2026-01-04T15:32:01.126Z
9094396 9094396 20251227122104_NwhD2 NZ001W 2025-12-30T15:05:14.004Z 2026-01-04T15:31:40.588Z
9093973 9093973 20251227111924_1Q9yg NZ001W 2025-12-30T15:04:36.049Z 2026-01-04T15:31:28.126Z
9093822 9093822 20251227104902_rfN9P NZ001W 2025-12-30T15:04:24.930Z 2026-01-04T15:31:12.371Z
9093811 9093811 20251227104823_JnyQf NZ001W 2025-12-30T15:04:24.381Z 2025-12-30T15:04:24.381Z
9093756 9093756 20251227104228_A2CWV NZ001W 2025-12-30T15:04:21.342Z 2026-01-04T15:31:10.160Z
9093737 9093737 20251227103852_3TFlJ NZ001W 2025-12-30T15:04:20.199Z 2026-01-04T15:31:08.025Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network