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

4,941 rows where station_code = "NZ004S" 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
9270297 9270297 20260128152828_tdw4r NZ004S 2026-01-29T14:11:40.636Z 2026-01-29T14:11:40.636Z
9270258 9270258 20260128152301_I6NOk NZ004S 2026-01-29T14:11:27.700Z 2026-01-29T14:11:27.700Z
9269825 9269825 20260128141812_6GorN NZ004S 2026-01-29T14:09:45.906Z 2026-01-29T14:09:45.906Z
9269458 9269458 20260128131951_BsJy4 NZ004S 2026-01-29T14:08:03.019Z 2026-01-29T14:08:03.019Z
9269329 9269329 20260128130226_OmACH NZ004S 2026-01-29T14:07:28.636Z 2026-01-29T14:07:28.636Z
9269099 9269099 20260128122642_rhmOO NZ004S 2026-01-29T14:06:30.732Z 2026-01-29T14:06:30.732Z
9268756 9268756 20260128111535_8pryL NZ004S 2026-01-29T14:04:44.927Z 2026-01-29T14:04:44.927Z
9265986 9265986 20260127162831_xrExR NZ004S 2026-01-28T14:11:58.712Z 2026-01-29T14:30:24.806Z
9265917 9265917 20260127161607_WXRPa NZ004S 2026-01-28T14:11:45.036Z 2026-01-29T14:30:24.737Z
9265888 9265888 20260127161032_sviC5 NZ004S 2026-01-28T14:11:40.977Z 2026-01-29T14:30:24.708Z
9265561 9265561 20260127153243_yzkOU NZ004S 2026-01-28T14:10:34.435Z 2026-01-29T14:30:24.612Z
9265539 9265539 20260127153037_3FUcU NZ004S 2026-01-28T14:10:28.777Z 2026-01-29T14:30:24.601Z
9265482 9265482 20260127152116_lJeDl NZ004S 2026-01-28T14:10:20.649Z 2026-01-29T14:30:24.590Z
9265407 9265407 20260127151225_lSK4M NZ004S 2026-01-28T14:10:03.556Z 2026-01-29T14:30:24.543Z
9265182 9265182 20260127143215_lshub NZ004S 2026-01-28T14:09:21.671Z 2026-01-29T14:30:24.495Z
9265149 9265149 20260127142511_1GgGd NZ004S 2026-01-28T14:09:13.313Z 2026-01-29T14:30:24.467Z
9264274 9264274 20260127115330_82zEK NZ004S 2026-01-28T14:05:15.208Z 2026-01-29T14:30:20.574Z
9264016 9264016 20260127105701_Ajf8F NZ004S 2026-01-28T14:03:57.426Z 2026-01-29T14:30:19.999Z
9257465 9257465 20260125135651_76yVD NZ004S 2026-01-26T14:05:47.209Z 2026-01-29T14:37:14.012Z
9257367 9257367 20260125130838_2lQVe NZ004S 2026-01-26T14:05:08.054Z 2026-01-29T14:37:07.949Z
9257337 9257337 20260125125337_Q98UA NZ004S 2026-01-26T14:04:48.324Z 2026-01-29T14:37:06.137Z
9256935 9256935 20260125111111_ia7es NZ004S 2026-01-26T14:02:50.169Z 2026-01-29T14:36:37.126Z
9256687 9256687 20260125100012_MUe9g NZ004S 2026-01-26T14:01:25.411Z 2026-01-29T14:36:16.376Z
9253934 9253934 20260124160045_QN0Rc NZ004S 2026-01-25T14:05:03.547Z 2026-01-29T14:41:50.608Z
9253913 9253913 20260124154355_RGPJY NZ004S 2026-01-25T14:04:58.000Z 2026-01-29T14:41:47.839Z
9253847 9253847 20260124151115_C0C2W NZ004S 2026-01-25T14:04:38.809Z 2026-01-29T14:41:41.558Z
9253755 9253755 20260124142442_foZ6O NZ004S 2026-01-25T14:04:14.872Z 2026-01-29T14:41:24.756Z
9253134 9253134 20260124093346_xX2vB NZ004S 2026-01-25T14:00:51.592Z 2026-01-29T14:40:19.891Z
9250443 9250443 20260123150018_DVLGM NZ004S 2026-01-24T14:02:58.216Z 2026-01-29T14:45:35.122Z
9250422 9250422 20260123144020_XdBE8 NZ004S 2026-01-24T14:02:51.917Z 2026-01-29T14:45:33.071Z
9250367 9250367 20260123135906_H37zE NZ004S 2026-01-24T14:02:32.119Z 2026-01-29T14:45:27.183Z
9250363 9250363 20260123134738_4AT5i NZ004S 2026-01-24T14:02:30.403Z 2026-01-29T14:45:26.528Z
9250129 9250129 20260123103722_H3WYn NZ004S 2026-01-24T14:01:19.448Z 2026-01-29T14:45:00.910Z
9249801 9249801 20260122085416_Z733g NZ004S 2026-01-23T14:16:16.061Z 2026-01-29T14:58:58.328Z
9245766 9245766 20260122141836_s02kF NZ004S 2026-01-23T14:03:25.177Z 2026-01-29T14:50:10.132Z
9245743 9245743 20260122141022_3yTix NZ004S 2026-01-23T14:03:13.740Z 2026-01-29T14:50:07.957Z
9245736 9245736 20260122140645_y2QdH NZ004S 2026-01-23T14:03:12.192Z 2026-01-29T14:50:06.641Z
9245679 9245679 20260122134218_5xSdk NZ004S 2026-01-23T14:02:57.898Z 2026-01-29T14:49:56.891Z
9245481 9245481 20260122124009_TbZbU NZ004S 2026-01-23T14:02:10.142Z 2026-01-29T14:49:43.105Z
9245412 9245412 20260122121744_J30Nq NZ004S 2026-01-23T14:01:52.334Z 2026-01-29T14:49:32.246Z
9245406 9245406 20260122121710_5l8hX NZ004S 2026-01-23T14:01:51.557Z 2026-01-29T14:49:32.051Z
9245221 9245221 20260122111924_arntt NZ004S 2026-01-23T14:01:06.985Z 2026-01-29T14:49:15.731Z
9239934 9239934 20260121162310_SKe10 NZ004S 2026-01-22T14:03:56.807Z 2026-01-29T14:55:38.762Z
9239932 9239932 20260121154459_t9ZPO NZ004S 2026-01-22T14:03:56.147Z 2026-01-29T14:55:29.792Z
9239930 9239930 20260121153610_S90F9 NZ004S 2026-01-22T14:03:55.375Z 2026-01-29T14:55:20.112Z
9239928 9239928 20260121151414_sV9zn NZ004S 2026-01-22T14:03:54.532Z 2026-01-29T14:55:18.219Z
9239926 9239926 20260121144734_XBd5H NZ004S 2026-01-22T14:03:54.027Z 2026-01-29T14:55:12.923Z
9239924 9239924 20260121144243_pzJeR NZ004S 2026-01-22T14:03:53.347Z 2026-01-29T14:55:12.271Z
9239922 9239922 20260121143311_fAKPT NZ004S 2026-01-22T14:03:52.661Z 2026-01-29T14:55:11.721Z
9239920 9239920 20260121140446_f3fv4 NZ004S 2026-01-22T14:03:46.882Z 2026-01-29T14:55:08.299Z
9206064 9206064 20260115142638_IAxmy NZ004S 2026-01-16T14:01:37.528Z 2026-01-24T15:09:00.108Z
9193424 9193424 20260113143956_CiJko NZ004S 2026-01-14T14:01:19.459Z 2026-01-22T15:06:17.770Z
9187172 9187172 20260111153128_EVynk NZ004S 2026-01-13T14:05:54.297Z 2026-01-20T15:20:05.418Z
9187062 9187062 20260111145811_qB8OA NZ004S 2026-01-13T14:05:13.977Z 2026-01-20T15:19:56.563Z
9186979 9186979 20260111143455_j3mRD NZ004S 2026-01-13T14:04:38.571Z 2026-01-20T15:19:39.843Z
9186913 9186913 20260111141837_ystLw NZ004S 2026-01-13T14:04:11.532Z 2026-01-20T15:19:31.983Z
9185940 9185940 20260111135845_2HXRr NZ004S 2026-01-12T14:26:20.372Z 2026-01-19T15:22:07.287Z
9185878 9185878 20260111133554_w2EVb NZ004S 2026-01-12T14:26:11.983Z 2026-01-19T15:21:59.942Z
9185756 9185756 20260111130227_r2bFz NZ004S 2026-01-12T14:25:48.947Z 2026-01-19T15:21:47.292Z
9185713 9185713 20260111124946_xZZrW NZ004S 2026-01-12T14:25:44.648Z 2026-01-19T15:21:43.476Z
9185639 9185639 20260111122009_azWkq NZ004S 2026-01-12T14:25:23.114Z 2026-01-19T15:21:13.734Z
9185630 9185630 20260111121725_WBcqD NZ004S 2026-01-12T14:25:21.468Z 2026-01-19T15:21:12.560Z
9185573 9185573 20260111120235_RidSa NZ004S 2026-01-12T14:25:13.063Z 2026-01-19T15:21:06.493Z
9185569 9185569 20260111120142_giYVb NZ004S 2026-01-12T14:25:12.749Z 2026-01-19T15:21:06.396Z
9185480 9185480 20260111111845_91Fvi NZ004S 2026-01-12T14:25:02.235Z 2026-01-19T15:20:53.844Z
9185449 9185449 20260111110920_xa23m NZ004S 2026-01-12T14:24:49.346Z 2026-01-19T15:20:32.765Z
9183794 9183794 20260111101614_jhuZC NZ004S 2026-01-12T14:18:49.059Z 2026-01-19T15:20:11.944Z
9183464 9183464 20260111093159_RkR2c NZ004S 2026-01-12T14:17:51.860Z 2026-01-19T15:19:40.494Z
9183419 9183419 20260111092745_NVZ6n NZ004S 2026-01-12T14:17:45.234Z 2026-01-12T14:17:45.234Z
9183205 9183205 20260111085733_Kh1k6 NZ004S 2026-01-12T14:17:06.556Z 2026-01-19T15:19:31.744Z
9178984 9178984 20260110143804_byNSu NZ004S 2026-01-11T14:16:10.621Z 2026-01-18T15:11:31.679Z
9178821 9178821 20260110141457_Cg1nO NZ004S 2026-01-11T14:15:47.755Z 2026-01-18T15:11:18.661Z
9178757 9178757 20260110140334_RcNlV NZ004S 2026-01-11T14:15:40.646Z 2026-01-18T15:11:15.829Z
9178407 9178407 20260110130524_3A8Z3 NZ004S 2026-01-11T14:14:46.605Z 2026-01-18T15:10:48.519Z
9178269 9178269 20260110124009_INihD NZ004S 2026-01-11T14:14:25.315Z 2026-01-18T15:10:41.548Z
9178071 9178071 20260110120800_YT7Pu NZ004S 2026-01-11T14:13:55.377Z 2026-01-18T15:10:27.585Z
9177888 9177888 20260110113809_3d8OS NZ004S 2026-01-11T14:13:24.587Z 2026-01-18T15:10:13.741Z
9177753 9177753 20260110111315_VYluQ NZ004S 2026-01-11T14:12:57.328Z 2026-01-18T15:10:07.168Z
9177343 9177343 20260110092514_WefDN NZ004S 2026-01-11T14:11:41.341Z 2026-01-18T15:09:38.333Z
9174314 9174314 20260110161828_3ClXe NZ004S 2026-01-11T14:02:07.899Z 2026-01-19T15:15:02.987Z
9174290 9174290 20260110160208_0efAc NZ004S 2026-01-11T14:02:02.634Z 2026-01-19T15:14:47.401Z
9174151 9174151 20260110154041_NtPkr NZ004S 2026-01-11T14:01:34.953Z 2026-01-19T15:14:37.927Z
9174033 9174033 20260110151819_sjzL4 NZ004S 2026-01-11T14:01:05.335Z 2026-01-19T15:14:32.267Z
9173928 9173928 20260110150350_uivkW NZ004S 2026-01-11T14:00:45.374Z 2026-01-19T15:14:27.988Z
9173461 9173461 20260109141848_DCqv8 NZ004S 2026-01-10T14:17:39.537Z 2026-01-17T15:26:44.447Z
9173437 9173437 20260109140959_oifia NZ004S 2026-01-10T14:17:32.042Z 2026-01-17T15:26:43.142Z
9173076 9173076 20260109125555_CKkgX NZ004S 2026-01-10T14:16:03.023Z 2026-01-17T15:26:14.523Z
9173059 9173059 20260109125117_V0d5K NZ004S 2026-01-10T14:15:58.962Z 2026-01-17T15:26:13.586Z
9172856 9172856 20260109121252_GTOda NZ004S 2026-01-10T14:15:07.818Z 2026-01-17T15:26:05.056Z
9172744 9172744 20260109114757_nWbHv NZ004S 2026-01-10T14:14:39.978Z 2026-01-17T15:25:51.167Z
9172414 9172414 20260109103441_2VFkg NZ004S 2026-01-10T14:13:13.302Z 2026-01-17T15:25:29.209Z
9172116 9172116 20260109090327_PBKf3 NZ004S 2026-01-10T14:11:49.245Z 2026-01-17T15:25:07.458Z
9170541 9170541 20260109153859_bqJP4 NZ004S 2026-01-10T14:01:09.645Z 2026-01-18T15:06:27.098Z
9169702 9169702 20260108153112_K8YF8 NZ004S 2026-01-09T14:14:23.803Z 2026-01-16T15:14:26.383Z
9169662 9169662 20260108151924_LU2n2 NZ004S 2026-01-09T14:14:15.962Z 2026-01-16T15:14:23.675Z
9169558 9169558 20260108145752_eGieP NZ004S 2026-01-09T14:13:58.314Z 2026-01-16T15:14:07.854Z
9169465 9169465 20260108143829_xNd43 NZ004S 2026-01-09T14:13:38.196Z 2026-01-16T15:14:00.497Z
9169353 9169353 20260108141823_mzIN9 NZ004S 2026-01-09T14:13:20.552Z 2026-01-16T15:13:54.052Z
9169311 9169311 20260108140724_LROq1 NZ004S 2026-01-09T14:13:14.113Z 2026-01-16T15:13:50.930Z
9169301 9169301 20260108140632_LQbIw NZ004S 2026-01-09T14:13:13.234Z 2026-01-16T15:13:50.303Z

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