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,539 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
8688079 8688079 20251205101405_bOS6p NZ004S 2025-12-06T14:03:03.854Z 2025-12-06T14:03:03.854Z
8688012 8688012 20251205095707_vW14f NZ004S 2025-12-06T14:02:43.539Z 2025-12-06T14:02:43.539Z
8683988 8683988 20251204100321_neZNJ NZ004S 2025-12-05T14:01:28.455Z 2025-12-06T14:18:00.388Z
8670235 8670235 20251202153555_WORcW NZ004S 2025-12-03T14:07:33.717Z 2025-12-06T14:24:56.290Z
8670225 8670225 20251202153231_lnML8 NZ004S 2025-12-03T14:07:31.850Z 2025-12-06T14:24:55.864Z
8670187 8670187 20251202150421_7Ff2W NZ004S 2025-12-03T14:07:20.833Z 2025-12-06T14:24:49.883Z
8670185 8670185 20251202150316_dD04a NZ004S 2025-12-03T14:07:20.370Z 2025-12-06T14:24:49.531Z
8661474 8661474 20251130152852_NIatH NZ004S 2025-12-02T14:11:35.361Z 2025-12-06T14:38:06.554Z
8661350 8661350 20251130151038_3bun2 NZ004S 2025-12-02T14:11:08.760Z 2025-12-06T14:38:02.833Z
8661304 8661304 20251130150649_L53kc NZ004S 2025-12-02T14:11:02.873Z 2025-12-06T14:38:01.406Z
8661229 8661229 20251130150140_5b22V NZ004S 2025-12-02T14:10:53.417Z 2025-12-06T14:37:53.328Z
8661201 8661201 20251130145818_GL0tD NZ004S 2025-12-02T14:10:43.379Z 2025-12-06T14:37:45.744Z
8661168 8661168 20251130145340_BDsfP NZ004S 2025-12-02T14:10:35.874Z 2025-12-06T14:37:39.551Z
8661051 8661051 20251130143242_2TF7R NZ004S 2025-12-02T14:10:12.369Z 2025-12-06T14:37:36.241Z
8642067 8642067 20251128152931_3QvEv NZ004S 2025-11-30T14:17:19.002Z 2025-12-06T14:53:15.070Z
8641838 8641838 20251128151619_Xh6FL NZ004S 2025-11-30T14:17:03.458Z 2025-12-06T14:52:58.126Z
8641791 8641791 20251128151341_Tm3c3 NZ004S 2025-11-30T14:17:00.786Z 2025-12-06T14:52:53.902Z
8641538 8641538 20251128145838_E2PbH NZ004S 2025-11-30T14:16:31.207Z 2025-12-06T14:52:38.465Z
8640544 8640544 20251129144759_q2eLc NZ004S 2025-11-30T14:08:46.664Z 2025-11-30T14:08:46.664Z
8640195 8640195 20251129130416_2B6MF NZ004S 2025-11-30T14:07:30.759Z 2025-12-06T14:44:01.164Z
8629957 8629957 20251128144825_DYkDW NZ004S 2025-11-29T14:09:21.254Z 2025-12-06T14:52:36.029Z
8629914 8629914 20251128144413_8qDrs NZ004S 2025-11-29T14:09:18.428Z 2025-12-06T14:52:35.381Z
8629902 8629902 20251128144345_TrrNf NZ004S 2025-11-29T14:09:17.730Z 2025-12-06T14:52:35.327Z
8629060 8629060 20251128134128_QI5VY NZ004S 2025-11-29T14:07:46.035Z 2025-12-06T14:52:21.795Z
8628962 8628962 20251128133052_LWi22 NZ004S 2025-11-29T14:07:37.411Z 2025-11-29T14:07:37.411Z
8628858 8628858 20251128131438_9IJZ1 NZ004S 2025-11-29T14:07:14.499Z 2025-12-06T14:52:18.709Z
8628718 8628718 20251128130602_6D5ZU NZ004S 2025-11-29T14:06:59.767Z 2025-12-06T14:52:16.649Z
8628588 8628588 20251128125804_yxk72 NZ004S 2025-11-29T14:06:48.577Z 2025-12-06T14:52:01.916Z
8628466 8628466 20251128124649_VWSRO NZ004S 2025-11-29T14:06:22.155Z 2025-11-29T14:06:22.155Z
8604569 8604569 20251124090111_hCJq0 NZ004S 2025-11-26T14:37:27.272Z 2025-12-02T15:13:06.481Z
8595380 8595380 20251124152307_Uangc NZ004S 2025-11-26T14:10:56.730Z 2025-12-02T15:05:54.503Z
8594899 8594899 20251124130936_4GiEz NZ004S 2025-11-26T14:09:13.947Z 2025-12-02T15:05:39.175Z
8594496 8594496 20251124113106_EyW7q NZ004S 2025-11-26T14:07:04.687Z 2025-12-02T15:05:32.289Z
8594349 8594349 20251124105515_2pUCr NZ004S 2025-11-26T14:06:04.855Z 2025-12-02T15:05:29.833Z
8594203 8594203 20251124100503_s9QJz NZ004S 2025-11-26T14:05:03.065Z 2025-12-02T15:05:27.266Z
8594200 8594200 20251124100502_FwRmE NZ004S 2025-11-26T14:05:02.759Z 2025-12-02T15:05:27.189Z
8593076 8593076 20251125095459_yaVnk NZ004S 2025-11-26T14:00:45.540Z 2025-12-04T15:05:10.572Z
8593054 8593054 20251125094712_qsr0u NZ004S 2025-11-26T14:00:40.781Z 2025-12-04T15:05:09.009Z
8584591 8584591 20251123124612_iMYz6 NZ004S 2025-11-25T14:06:54.147Z 2025-12-02T15:09:50.648Z
8570244 8570244 20251121084213_YJEvF NZ004S 2025-11-23T14:33:12.097Z 2025-11-29T14:54:55.929Z
8570183 8570183 20251121082313_JKXeJ NZ004S 2025-11-23T14:33:08.234Z 2025-11-29T14:54:55.238Z
8563102 8563102 20251121151522_UheOt NZ004S 2025-11-23T14:07:22.256Z 2025-11-30T15:03:35.548Z
8563021 8563021 20251121150802_z5SRt NZ004S 2025-11-23T14:07:05.304Z 2025-11-30T15:03:34.753Z
8561352 8561352 20251121120749_XhiUR NZ004S 2025-11-23T14:02:30.475Z 2025-11-30T15:02:55.697Z
8560679 8560679 20251121103732_pdgPx NZ004S 2025-11-23T14:00:34.549Z 2025-11-30T15:02:35.206Z
8560567 8560567 20251121102102_pVDc8 NZ004S 2025-11-23T14:00:10.134Z 2025-11-30T15:02:32.765Z
8543451 8543451 20251120135531_ydKu4 NZ004S 2025-11-22T14:05:15.543Z 2025-11-29T14:53:25.856Z
8542947 8542947 20251120131222_rNNMQ NZ004S 2025-11-22T14:03:41.551Z 2025-11-29T14:53:16.810Z
8542536 8542536 20251120122418_oczeE NZ004S 2025-11-22T14:02:24.942Z 2025-11-29T14:53:12.741Z
8541738 8541738 20251120103959_pcKyB NZ004S 2025-11-22T14:00:16.944Z 2025-11-29T14:52:52.544Z
8531569 8531569 20251119144154_OYzz6 NZ004S 2025-11-21T14:05:37.473Z 2025-11-28T14:53:36.675Z
8530751 8530751 20251119124914_jQpOb NZ004S 2025-11-21T14:02:48.588Z 2025-11-28T14:53:20.364Z
8530522 8530522 20251119121642_PPefi NZ004S 2025-11-21T14:01:52.282Z 2025-11-28T14:53:15.168Z
8530503 8530503 20251119121343_ZaB1i NZ004S 2025-11-21T14:01:49.122Z 2025-11-28T14:53:13.902Z
8530133 8530133 20251119110704_PVsX1 NZ004S 2025-11-21T14:00:32.972Z 2025-11-28T14:53:00.625Z
8529634 8529634 20251119101304_RaVP6 NZ004S 2025-11-20T14:45:07.117Z 2025-11-27T15:13:34.488Z
8489254 8489254 20251116154405_c3VYs NZ004S 2025-11-18T14:09:17.965Z 2025-11-25T15:07:22.113Z
8486144 8486144 20251115111853_iL3AU NZ004S 2025-11-17T14:34:11.757Z 2025-11-23T15:20:23.748Z
8485937 8485937 20251115111100_7YU70 NZ004S 2025-11-17T14:34:07.498Z 2025-11-23T15:20:15.844Z
8485596 8485596 20251115105519_q7RpH NZ004S 2025-11-17T14:33:57.982Z 2025-11-23T15:20:09.687Z
8484996 8484996 20251115101924_1EM3q NZ004S 2025-11-17T14:33:04.978Z 2025-11-23T15:19:53.102Z
8477765 8477765 20251115160131_rfO8k NZ004S 2025-11-17T14:11:57.401Z 2025-11-24T15:03:48.421Z
8477123 8477123 20251115151640_U9co2 NZ004S 2025-11-17T14:10:32.835Z 2025-11-24T15:03:24.787Z
8476838 8476838 20251115150300_y6RGJ NZ004S 2025-11-17T14:09:52.421Z 2025-11-24T15:03:14.399Z
8476744 8476744 20251115145848_sFfkT NZ004S 2025-11-17T14:09:35.130Z 2025-11-24T15:03:13.404Z
8475877 8475877 20251115141903_NdhKK NZ004S 2025-11-17T14:07:43.473Z 2025-11-24T15:03:05.481Z
8475658 8475658 20251115140705_huB7A NZ004S 2025-11-17T14:07:11.084Z 2025-11-24T15:03:03.937Z
8475492 8475492 20251115135906_dSaFa NZ004S 2025-11-17T14:06:42.489Z 2025-11-24T15:03:02.661Z
8475357 8475357 20251115135207_mDwya NZ004S 2025-11-17T14:06:30.740Z 2025-11-24T15:03:01.770Z
8475198 8475198 20251115134229_DA2vk NZ004S 2025-11-17T14:06:06.552Z 2025-11-24T15:03:00.873Z
8475178 8475178 20251115134148_xpsms NZ004S 2025-11-17T14:06:04.537Z 2025-11-24T15:03:00.794Z
8474907 8474907 20251115133039_5JqVT NZ004S 2025-11-17T14:05:43.177Z 2025-11-24T15:02:59.248Z
8474725 8474725 20251115131929_ONgzA NZ004S 2025-11-17T14:05:15.636Z 2025-11-24T15:02:57.859Z
8473987 8473987 20251115124053_L0PrS NZ004S 2025-11-17T14:03:28.260Z 2025-11-24T15:02:53.280Z
8472834 8472834 20251115114352_M5A7J NZ004S 2025-11-17T14:00:29.298Z 2025-11-24T15:02:17.177Z
8472428 8472428 20251114112754_mxfMe NZ004S 2025-11-16T14:33:44.536Z 2025-11-22T15:24:17.382Z
8472374 8472374 20251114112053_diBfG NZ004S 2025-11-16T14:33:18.331Z 2025-11-22T15:24:14.784Z
8472288 8472288 20251114111026_bbETu NZ004S 2025-11-16T14:33:11.083Z 2025-11-22T15:24:10.266Z
8472218 8472218 20251114110311_WtsCD NZ004S 2025-11-16T14:33:07.385Z 2025-11-22T15:24:07.054Z
8471982 8471982 20251114103134_euMkb NZ004S 2025-11-16T14:32:45.913Z 2025-11-22T15:23:54.393Z
8471747 8471747 20251114094855_vMcSr NZ004S 2025-11-16T14:31:56.995Z 2025-11-22T15:23:36.074Z
8471521 8471521 20251114091127_2Ts6l NZ004S 2025-11-16T14:31:16.670Z 2025-11-22T15:23:20.504Z
8471410 8471410 20251114083453_Z1P6X NZ004S 2025-11-16T14:31:05.596Z 2025-11-22T15:23:06.259Z
8471331 8471331 20251114080925_d3L3X NZ004S 2025-11-16T14:30:40.251Z 2025-11-22T15:22:55.745Z
8465195 8465195 20251114160238_ds6T0 NZ004S 2025-11-16T14:08:34.594Z 2025-11-23T15:16:49.948Z
8464764 8464764 20251114151942_JIrjh NZ004S 2025-11-16T14:07:16.017Z 2025-11-23T15:16:31.110Z
8464406 8464406 20251114144437_eE2mu NZ004S 2025-11-16T14:06:18.238Z 2025-11-23T15:16:18.254Z
8464402 8464402 20251114144409_BxWZh NZ004S 2025-11-16T14:06:16.776Z 2025-11-23T15:16:18.101Z
8464392 8464392 20251114144303_hkKKN NZ004S 2025-11-16T14:06:07.512Z 2025-11-23T15:16:17.761Z
8464081 8464081 20251114141517_DlKHw NZ004S 2025-11-16T14:05:13.382Z 2025-11-23T15:16:09.817Z
8463991 8463991 20251114140743_2Kj70 NZ004S 2025-11-16T14:05:03.081Z 2025-11-23T15:16:07.301Z
8463598 8463598 20251114132318_6RsET NZ004S 2025-11-16T14:03:37.448Z 2025-11-23T15:15:59.252Z
8463075 8463075 20251114122614_243Y5 NZ004S 2025-11-16T14:01:45.218Z 2025-11-23T15:15:40.807Z
8462824 8462824 20251114120443_2emwR NZ004S 2025-11-16T14:00:46.739Z 2025-11-23T15:15:34.212Z
8454120 8454120 20251113145002_duok3 NZ004S 2025-11-15T14:05:13.092Z 2025-11-22T15:19:07.431Z
8454046 8454046 20251113144328_xpmlp NZ004S 2025-11-15T14:04:53.328Z 2025-11-22T15:19:05.431Z
8453955 8453955 20251113143338_HFz1D NZ004S 2025-11-15T14:04:24.448Z 2025-11-22T15:18:58.907Z
8453771 8453771 20251113141421_LVXxf NZ004S 2025-11-15T14:03:40.968Z 2025-11-22T15:18:49.386Z
8453638 8453638 20251113135343_eMs2i NZ004S 2025-11-15T14:03:12.960Z 2025-11-22T15:18:41.319Z
8453582 8453582 20251113134126_yOMkO NZ004S 2025-11-15T14:02:52.176Z 2025-11-22T15:18:39.048Z

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