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

>10,000 rows count all where station_code = "NZ002X" 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
9270460 9270460 20260128155303_qIBzs NZ002X 2026-01-29T14:12:20.445Z 2026-01-29T14:12:20.445Z
9269999 9269999 20260128144245_pzPgu NZ002X 2026-01-29T14:10:29.513Z 2026-01-29T14:10:29.513Z
9269981 9269981 20260128144046_Nifj7 NZ002X 2026-01-29T14:10:26.415Z 2026-01-29T14:10:26.415Z
9269795 9269795 20260128141516_9es8O NZ002X 2026-01-29T14:09:40.350Z 2026-01-29T14:09:40.350Z
9269683 9269683 20260128135451_eRfj7 NZ002X 2026-01-29T14:09:04.026Z 2026-01-29T14:09:04.026Z
9269578 9269578 20260128133916_gtzN1 NZ002X 2026-01-29T14:08:32.752Z 2026-01-29T14:08:32.752Z
9269428 9269428 20260128131625_RYQ7t NZ002X 2026-01-29T14:07:57.759Z 2026-01-29T14:07:57.759Z
9269008 9269008 20260128120025_v5vbG NZ002X 2026-01-29T14:06:00.456Z 2026-01-29T14:06:00.456Z
9257353 9257353 20260125130050_wSqjM NZ002X 2026-01-26T14:05:02.407Z 2026-01-29T14:37:06.842Z
9257347 9257347 20260125125908_Y6Ge2 NZ002X 2026-01-26T14:04:54.628Z 2026-01-29T14:37:06.584Z
9253774 9253774 20260124143320_dKhSD NZ002X 2026-01-25T14:04:22.514Z 2026-01-29T14:41:26.663Z
9253725 9253725 20260124140335_F8zNt NZ002X 2026-01-25T14:04:07.233Z 2026-01-29T14:41:19.985Z
9253710 9253710 20260124135855_88rJT NZ002X 2026-01-25T14:04:04.096Z 2026-01-29T14:41:19.237Z
9253662 9253662 20260124132759_OK3gY NZ002X 2026-01-25T14:03:50.216Z 2026-01-29T14:41:14.190Z
9253533 9253533 20260124123309_exgqo NZ002X 2026-01-25T14:03:13.281Z 2026-01-29T14:40:56.094Z
9250509 9250509 20260123155032_k3Zk2 NZ002X 2026-01-24T14:03:18.560Z 2026-01-29T14:45:43.983Z
9250454 9250454 20260123151149_JxKu5 NZ002X 2026-01-24T14:03:01.085Z 2026-01-29T14:45:36.364Z
9250411 9250411 20260123142905_4moNe NZ002X 2026-01-24T14:02:49.061Z 2026-01-29T14:45:32.008Z
9250396 9250396 20260123141820_sjboN NZ002X 2026-01-24T14:02:41.197Z 2026-01-29T14:45:30.624Z
9250394 9250394 20260123141722_537CQ NZ002X 2026-01-24T14:02:40.513Z 2026-01-29T14:45:30.341Z
9250338 9250338 20260123131038_2HM2q NZ002X 2026-01-24T14:02:25.443Z 2026-01-29T14:45:24.552Z
9250299 9250299 20260123123427_kx2Xm NZ002X 2026-01-24T14:02:10.911Z 2026-01-29T14:45:13.910Z
9250291 9250291 20260123122954_beJtR NZ002X 2026-01-24T14:02:08.922Z 2026-01-29T14:45:13.499Z
9250279 9250279 20260123120133_33uPi NZ002X 2026-01-24T14:02:05.159Z 2026-01-29T14:45:12.506Z
9250267 9250267 20260123115756_km738 NZ002X 2026-01-24T14:02:02.255Z 2026-01-29T14:45:11.717Z
9250259 9250259 20260123115449_R3qOa NZ002X 2026-01-24T14:02:00.386Z 2026-01-29T14:45:11.242Z
9250196 9250196 20260123110335_TxrWK NZ002X 2026-01-24T14:01:38.644Z 2026-01-29T14:45:05.003Z
9250154 9250154 20260123105048_xsZA1 NZ002X 2026-01-24T14:01:28.875Z 2026-01-29T14:45:02.409Z
9250127 9250127 20260123103722_H3WYn NZ002X 2026-01-24T14:01:19.447Z 2026-01-29T14:45:00.910Z
9250113 9250113 20260123102456_eaaAh NZ002X 2026-01-24T14:01:13.276Z 2026-01-29T14:44:59.861Z
9250086 9250086 20260123101018_fypz1 NZ002X 2026-01-24T14:01:04.365Z 2026-01-29T14:44:57.789Z
9250081 9250081 20260123100711_csQ5h NZ002X 2026-01-24T14:01:03.759Z 2026-01-29T14:44:57.639Z
9250073 9250073 20260123100605_2mQsC NZ002X 2026-01-24T14:01:00.386Z 2026-01-29T14:44:57.120Z
9250036 9250036 20260123095317_FwbLK NZ002X 2026-01-24T14:00:46.146Z 2026-01-29T14:44:54.729Z
9250028 9250028 20260123095104_RC83l NZ002X 2026-01-24T14:00:42.925Z 2026-01-29T14:44:54.260Z
9249964 9249964 20260123091648_fAe5z NZ002X 2026-01-24T14:00:21.690Z 2026-01-29T14:44:45.307Z
9249956 9249956 20260123091518_SQrcy NZ002X 2026-01-24T14:00:20.239Z 2026-01-29T14:44:45.044Z
9249837 9249837 20260122092014_5YeOu NZ002X 2026-01-23T14:16:21.019Z 2026-01-29T14:59:00.510Z
9246035 9246035 20260122160506_5w5Hk NZ002X 2026-01-23T14:04:31.651Z 2026-01-29T14:50:38.296Z
9245927 9245927 20260122153554_2hyAK NZ002X 2026-01-23T14:04:03.903Z 2026-01-29T14:50:25.339Z
9245926 9245926 20260122153552_dLsVj NZ002X 2026-01-23T14:04:03.602Z 2026-01-29T14:50:25.264Z
9245901 9245901 20260122152330_dawHP NZ002X 2026-01-23T14:03:59.368Z 2026-01-29T14:50:21.519Z
9245886 9245886 20260122151533_P2MKe NZ002X 2026-01-23T14:03:57.227Z 2026-01-29T14:50:20.780Z
9245870 9245870 20260122150618_TMNx2 NZ002X 2026-01-23T14:03:48.072Z 2026-01-29T14:50:19.291Z
9245598 9245598 20260122131940_2mK3n NZ002X 2026-01-23T14:02:34.830Z 2026-01-29T14:49:50.045Z
9245567 9245567 20260122130750_aw22G NZ002X 2026-01-23T14:02:25.033Z 2026-01-23T14:02:25.033Z
9245555 9245555 20260122130425_a5noJ NZ002X 2026-01-23T14:02:22.986Z 2026-01-23T14:02:22.986Z
9245530 9245530 20260122125420_6ZVsg NZ002X 2026-01-23T14:02:17.943Z 2026-01-29T14:49:45.339Z
9245475 9245475 20260122123845_v2NNi NZ002X 2026-01-23T14:02:05.928Z 2026-01-29T14:49:42.745Z
9245414 9245414 20260122121818_yIjxv NZ002X 2026-01-23T14:01:52.778Z 2026-01-29T14:49:32.356Z
9245381 9245381 20260122120520_p92bF NZ002X 2026-01-23T14:01:46.868Z 2026-01-29T14:49:29.610Z
9245369 9245369 20260122120250_Y1wnR NZ002X 2026-01-23T14:01:43.992Z 2026-01-29T14:49:28.505Z
9245354 9245354 20260122115646_M10bY NZ002X 2026-01-23T14:01:41.160Z 2026-01-29T14:49:25.918Z
9245317 9245317 20260122114546_UYyWZ NZ002X 2026-01-23T14:01:29.288Z 2026-01-29T14:49:23.809Z
9245289 9245289 20260122113657_zTyl2 NZ002X 2026-01-23T14:01:21.595Z 2026-01-29T14:49:21.420Z
9245257 9245257 20260122112908_AEaRH NZ002X 2026-01-23T14:01:13.696Z 2026-01-29T14:49:18.702Z
9245248 9245248 20260122112525_PFHgA NZ002X 2026-01-23T14:01:12.369Z 2026-01-29T14:49:17.950Z
9245235 9245235 20260122112347_VV62y NZ002X 2026-01-23T14:01:09.898Z 2026-01-29T14:49:17.042Z
9245177 9245177 20260122105716_V0iMq NZ002X 2026-01-23T14:00:52.745Z 2026-01-29T14:49:11.304Z
9245148 9245148 20260122103654_L2qRo NZ002X 2026-01-23T14:00:47.791Z 2026-01-29T14:49:04.653Z
9245138 9245138 20260122103424_DpIFH NZ002X 2026-01-23T14:00:45.965Z 2026-01-29T14:49:04.110Z
9245124 9245124 20260122102016_JFQly NZ002X 2026-01-23T14:00:42.605Z 2026-01-29T14:49:03.112Z
9245073 9245073 20260122095607_Zarjn NZ002X 2026-01-23T14:00:24.537Z 2026-01-29T14:48:56.041Z
9245044 9245044 20260122093758_UxMkR NZ002X 2026-01-23T14:00:17.515Z 2026-01-29T14:48:53.602Z
9196960 9196960 20260113094700_myquS NZ002X 2026-01-14T14:20:52.123Z 2026-01-21T15:06:11.661Z
9187244 9187244 20260111155332_07fOp NZ002X 2026-01-13T14:06:23.466Z 2026-01-20T15:20:11.553Z
9187225 9187225 20260111154818_HX6yr NZ002X 2026-01-13T14:06:16.395Z 2026-01-20T15:20:10.414Z
9187223 9187223 20260111154638_I9X7N NZ002X 2026-01-13T14:06:15.521Z 2026-01-20T15:20:10.217Z
9187164 9187164 20260111152914_ZROqf NZ002X 2026-01-13T14:05:51.176Z 2026-01-20T15:20:04.606Z
9187101 9187101 20260111150824_NksWp NZ002X 2026-01-13T14:05:26.966Z 2026-01-20T15:19:59.461Z
9187098 9187098 20260111150816_TZEgu NZ002X 2026-01-13T14:05:26.242Z 2026-01-20T15:19:59.324Z
9187078 9187078 20260111150259_C3QoC NZ002X 2026-01-13T14:05:20.041Z 2026-01-20T15:19:57.860Z
9187033 9187033 20260111144733_U9yb1 NZ002X 2026-01-13T14:05:01.854Z 2026-01-20T15:19:54.269Z
9186983 9186983 20260111143528_BSNoS NZ002X 2026-01-13T14:04:42.102Z 2026-01-20T15:19:40.034Z
9186921 9186921 20260111142059_oeFGI NZ002X 2026-01-13T14:04:15.104Z 2026-01-20T15:19:32.832Z
9185958 9185958 20260111140153_sKg3o NZ002X 2026-01-12T14:26:23.851Z 2026-01-19T15:22:08.251Z
9185944 9185944 20260111135949_NCFAL NZ002X 2026-01-12T14:26:21.128Z 2026-01-19T15:22:07.745Z
9185931 9185931 20260111135705_Y3bx2 NZ002X 2026-01-12T14:26:19.606Z 2026-01-19T15:22:06.830Z
9185858 9185858 20260111132853_whxBO NZ002X 2026-01-12T14:26:09.110Z 2026-01-19T15:21:58.731Z
9185821 9185821 20260111131917_DL5GW NZ002X 2026-01-12T14:26:04.120Z 2026-01-19T15:21:54.718Z
9185796 9185796 20260111131356_EapCt NZ002X 2026-01-12T14:26:01.400Z 2026-01-19T15:21:52.681Z
9185758 9185758 20260111130438_3mYUj NZ002X 2026-01-12T14:25:49.322Z 2026-01-19T15:21:48.288Z
9185747 9185747 20260111125649_F1Iin NZ002X 2026-01-12T14:25:47.844Z 2026-01-19T15:21:45.753Z
9185742 9185742 20260111125612_nzs9e NZ002X 2026-01-12T14:25:47.271Z 2026-01-19T15:21:45.376Z
9185673 9185673 20260111122822_YLTt9 NZ002X 2026-01-12T14:25:35.052Z 2026-01-19T15:21:18.497Z
9185654 9185654 20260111122300_0Ty74 NZ002X 2026-01-12T14:25:24.675Z 2026-01-19T15:21:15.027Z
9185606 9185606 20260111121255_OS2uG NZ002X 2026-01-12T14:25:17.349Z 2026-01-19T15:21:10.740Z
9185579 9185579 20260111120646_Nzntv NZ002X 2026-01-12T14:25:14.328Z 2026-01-19T15:21:07.787Z
9185574 9185574 20260111120502_m3SFs NZ002X 2026-01-12T14:25:13.377Z 2026-01-19T15:21:07.250Z
9185553 9185553 20260111115642_gPB3L NZ002X 2026-01-12T14:25:11.117Z 2026-01-19T15:21:05.353Z
9185427 9185427 20260111105802_5I9Oe NZ002X 2026-01-12T14:24:41.241Z 2026-01-19T15:20:28.128Z
9184137 9184137 20260111104714_lDYeg NZ002X 2026-01-12T14:19:46.339Z 2026-01-19T15:20:24.670Z
9184124 9184124 20260111104636_hOYHw NZ002X 2026-01-12T14:19:44.179Z 2026-01-19T15:20:23.821Z
9184065 9184065 20260111103842_tjbxC NZ002X 2026-01-12T14:19:36.134Z 2026-01-19T15:20:20.969Z
9184000 9184000 20260111103504_WoiCG NZ002X 2026-01-12T14:19:25.111Z 2026-01-19T15:20:19.417Z
9183960 9183960 20260111103119_YU1L1 NZ002X 2026-01-12T14:19:18.205Z 2026-01-19T15:20:17.939Z
9183836 9183836 20260111102050_RPNKc NZ002X 2026-01-12T14:18:57.956Z 2026-01-19T15:20:13.635Z
9183745 9183745 20260111101028_kSt8q NZ002X 2026-01-12T14:18:43.373Z 2026-01-12T14:18:43.373Z
9183669 9183669 20260111095716_oAwk9 NZ002X 2026-01-12T14:18:29.544Z 2026-01-19T15:20:07.304Z
9183568 9183568 20260111094622_yhkRW NZ002X 2026-01-12T14:18:12.497Z 2026-01-19T15:19:46.428Z

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