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 = "NZ001R" 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
9627284 9627284 20260408170052_nvM0x NZ001R 2026-04-09T12:10:33.080Z 2026-04-09T12:10:33.080Z
9607760 9607760 20260404133101_JZS30 NZ001R 2026-04-05T12:03:54.622Z 2026-04-09T12:39:31.235Z
9607701 9607701 20260404115551_LcKbl NZ001R 2026-04-05T12:03:36.210Z 2026-04-09T12:39:29.566Z
9607681 9607681 20260404114610_eZas7 NZ001R 2026-04-05T12:03:26.831Z 2026-04-09T12:39:28.741Z
9607539 9607539 20260404103348_oo0ak NZ001R 2026-04-05T12:02:50.434Z 2026-04-09T12:39:25.023Z
9607505 9607505 20260404100512_Sb9Dh NZ001R 2026-04-05T12:02:39.025Z 2026-04-09T12:39:24.125Z
9607403 9607403 20260404084231_bpTKd NZ001R 2026-04-05T12:02:01.479Z 2026-04-09T12:39:21.158Z
9607297 9607297 20260404070954_5e2WL NZ001R 2026-04-05T12:01:28.777Z 2026-04-09T12:39:18.405Z
9606294 9606294 20260403165930_ubigM NZ001R 2026-04-04T12:06:17.770Z 2026-04-09T12:42:13.551Z
9605920 9605920 20260403131014_JZKsH NZ001R 2026-04-04T12:04:27.851Z 2026-04-09T12:42:03.795Z
9605879 9605879 20260403123509_nYFDj NZ001R 2026-04-04T12:04:20.254Z 2026-04-09T12:42:03.056Z
9605714 9605714 20260403113345_7tG2t NZ001R 2026-04-04T12:03:33.969Z 2026-04-09T12:41:29.924Z
9605563 9605563 20260403104923_fLNj4 NZ001R 2026-04-04T12:02:55.075Z 2026-04-09T12:41:25.219Z
9605499 9605499 20260403102618_fhyYO NZ001R 2026-04-04T12:02:37.764Z 2026-04-09T12:41:23.709Z
9605345 9605345 20260403085430_fOXwc NZ001R 2026-04-04T12:01:51.997Z 2026-04-09T12:41:20.462Z
9603759 9603759 20260402121309_Onnyj NZ001R 2026-04-03T12:04:27.246Z 2026-04-09T12:44:08.581Z
9603736 9603736 20260402115953_3QcxU NZ001R 2026-04-03T12:04:20.822Z 2026-04-09T12:44:07.902Z
9603566 9603566 20260402110413_9qfHO NZ001R 2026-04-03T12:03:40.985Z 2026-04-09T12:44:04.140Z
9603470 9603470 20260402103120_UgtO5 NZ001R 2026-04-03T12:03:10.699Z 2026-04-09T12:43:50.318Z
9603432 9603432 20260402101817_1PacD NZ001R 2026-04-03T12:03:04.422Z 2026-04-09T12:43:43.902Z
9603420 9603420 20260402100926_PgQYO NZ001R 2026-04-03T12:03:01.807Z 2026-04-09T12:43:41.835Z
9603327 9603327 20260402093401_hvI3C NZ001R 2026-04-03T12:02:37.351Z 2026-04-09T12:43:25.084Z
9603186 9603186 20260402083840_shEvK NZ001R 2026-04-03T12:02:05.579Z 2026-04-09T12:43:22.695Z
9603170 9603170 20260402083213_GfE9U NZ001R 2026-04-03T12:02:02.957Z 2026-04-09T12:43:22.277Z
9603090 9603090 20260402074605_YLloe NZ001R 2026-04-03T12:01:43.485Z 2026-04-09T12:43:20.683Z
9600236 9600236 20260330154140_bqawc NZ001R 2026-04-01T12:09:05.498Z 2026-04-08T12:43:36.345Z
9598028 9598028 20260330173322_qL9Xq NZ001R 2026-03-31T12:07:28.631Z 2026-04-08T12:44:23.744Z
9597990 9597990 20260330172754_Y6HR3 NZ001R 2026-03-31T12:07:24.803Z 2026-04-08T12:44:22.675Z
9597849 9597849 20260330170852_Dc8Oh NZ001R 2026-03-31T12:07:07.036Z 2026-04-08T12:44:18.836Z
9597842 9597842 20260330170804_EADZC NZ001R 2026-03-31T12:07:06.369Z 2026-04-08T12:44:18.685Z
9597777 9597777 20260330165841_IcQS0 NZ001R 2026-03-31T12:06:59.653Z 2026-04-08T12:44:17.186Z
9597772 9597772 20260330165826_iuyiC NZ001R 2026-03-31T12:06:59.372Z 2026-04-08T12:44:17.056Z
9597753 9597753 20260330165656_V2PfK NZ001R 2026-03-31T12:06:58.078Z 2026-04-08T12:44:16.642Z
9597665 9597665 20260330164947_UtEak NZ001R 2026-03-31T12:06:51.658Z 2026-04-08T12:44:14.715Z
9597646 9597646 20260330164749_2OMLu NZ001R 2026-03-31T12:06:49.982Z 2026-04-08T12:44:12.973Z
9597606 9597606 20260330164206_bTV9w NZ001R 2026-03-31T12:06:46.305Z 2026-04-08T12:43:59.146Z
9597472 9597472 20260330162312_ji33w NZ001R 2026-03-31T12:06:27.401Z 2026-04-08T12:43:43.900Z
9597362 9597362 20260330161126_EogyG NZ001R 2026-03-31T12:06:14.484Z 2026-04-08T12:43:41.416Z
9597355 9597355 20260330161106_DoVvd NZ001R 2026-03-31T12:06:14.039Z 2026-04-08T12:43:41.349Z
9597306 9597306 20260330155942_0hf2c NZ001R 2026-03-31T12:06:06.807Z 2026-04-08T12:43:40.229Z
9597279 9597279 20260330155616_vf0y3 NZ001R 2026-03-31T12:06:04.366Z 2026-04-08T12:43:37.613Z
9597263 9597263 20260330155413_bFZOK NZ001R 2026-03-31T12:06:03.090Z 2026-04-08T12:43:37.360Z
9597122 9597122 20260330152129_KRP6w NZ001R 2026-03-31T12:05:41.910Z 2026-04-08T12:43:33.267Z
9597070 9597070 20260330150918_N258C NZ001R 2026-03-31T12:05:36.785Z 2026-04-08T12:43:32.063Z
9597007 9597007 20260330145724_Fu4rK NZ001R 2026-03-31T12:05:29.216Z 2026-04-08T12:43:30.362Z
9596925 9596925 20260330143607_n3MyQ NZ001R 2026-03-31T12:05:16.860Z 2026-04-08T12:43:28.235Z
9596644 9596644 20260330133130_VvQN2 NZ001R 2026-03-31T12:04:39.412Z 2026-04-08T12:43:21.575Z
9596480 9596480 20260330124837_8WgrD NZ001R 2026-03-31T12:04:23.230Z 2026-04-08T12:43:16.929Z
9596376 9596376 20260330122544_Uaovx NZ001R 2026-03-31T12:04:08.103Z 2026-04-08T12:42:50.801Z
9596354 9596354 20260330122307_furic NZ001R 2026-03-31T12:04:05.279Z 2026-04-08T12:42:50.234Z
9596349 9596349 20260330122307_P428j NZ001R 2026-03-31T12:04:04.900Z 2026-04-08T12:42:50.176Z
9596163 9596163 20260330113027_QCYwi NZ001R 2026-03-31T12:03:37.856Z 2026-04-08T12:42:42.928Z
9596030 9596030 20260330104520_KpdCW NZ001R 2026-03-31T12:03:10.765Z 2026-04-08T12:42:38.911Z
9595964 9595964 20260330101802_pctZY NZ001R 2026-03-31T12:03:00.904Z 2026-04-08T12:42:37.385Z
9595954 9595954 20260330101551_9L6rQ NZ001R 2026-03-31T12:03:00.067Z 2026-04-08T12:42:37.269Z
9595871 9595871 20260330093547_Fx547 NZ001R 2026-03-31T12:02:44.316Z 2026-04-08T12:42:35.001Z
9595795 9595795 20260330084413_hSOLF NZ001R 2026-03-31T12:02:31.698Z 2026-04-08T12:42:32.560Z
9595757 9595757 20260330082150_D9wa7 NZ001R 2026-03-31T12:02:24.691Z 2026-04-08T12:42:31.308Z
9595626 9595626 20260330072201_vsvOt NZ001R 2026-03-31T12:01:58.926Z 2026-04-08T12:42:27.510Z
9591532 9591532 20260328170336_60pxZ NZ001R 2026-03-29T12:04:33.217Z 2026-04-06T12:39:21.813Z
9591495 9591495 20260328165257_Wco1q NZ001R 2026-03-29T12:04:30.506Z 2026-04-06T12:39:18.489Z
9591488 9591488 20260328165227_nYaVd NZ001R 2026-03-29T12:04:29.981Z 2026-04-06T12:39:17.986Z
9591414 9591414 20260328162553_3Ujc5 NZ001R 2026-03-29T12:04:22.874Z 2026-04-06T12:39:14.612Z
9591400 9591400 20260328162026_tx4ct NZ001R 2026-03-29T12:04:21.681Z 2026-04-06T12:39:14.183Z
9591305 9591305 20260328153140_5BUMp NZ001R 2026-03-29T12:04:11.779Z 2026-04-06T12:39:10.352Z
9591299 9591299 20260328153117_rVJZq NZ001R 2026-03-29T12:04:11.222Z 2026-04-06T12:39:09.923Z
9591295 9591295 20260328152506_4rquW NZ001R 2026-03-29T12:04:10.828Z 2026-04-06T12:39:09.597Z
9591269 9591269 20260328150632_9b9XB NZ001R 2026-03-29T12:04:08.464Z 2026-04-06T12:39:08.569Z
9591257 9591257 20260328150307_G7iRQ NZ001R 2026-03-29T12:04:07.196Z 2026-04-06T12:39:08.057Z
9590880 9590880 20260328113857_Zzhi1 NZ001R 2026-03-29T12:03:25.976Z 2026-04-06T12:38:38.644Z
9590723 9590723 20260328105501_Px9as NZ001R 2026-03-29T12:03:11.143Z 2026-04-06T12:38:31.841Z
9590719 9590719 20260328105500_qyoAB NZ001R 2026-03-29T12:03:10.977Z 2026-04-06T12:38:31.716Z
9590697 9590697 20260328104836_joA3r NZ001R 2026-03-29T12:03:09.182Z 2026-04-06T12:38:30.739Z
9590584 9590584 20260328101009_yq45L NZ001R 2026-03-29T12:02:57.447Z 2026-04-06T12:38:25.667Z
9590577 9590577 20260328100644_6BD6l NZ001R 2026-03-29T12:02:56.407Z 2026-04-06T12:38:25.158Z
9590443 9590443 20260328091340_sZcFP NZ001R 2026-03-29T12:02:40.880Z 2026-04-06T12:38:10.074Z
9590308 9590308 20260328080804_DGEVr NZ001R 2026-03-29T12:02:24.322Z 2026-04-06T12:38:00.806Z
9590276 9590276 20260328080013_84Ww4 NZ001R 2026-03-29T12:02:21.475Z 2026-04-06T12:37:59.345Z
9587888 9587888 20260327163800_MV7NC NZ001R 2026-03-28T12:06:39.542Z 2026-04-05T12:34:48.242Z
9587876 9587876 20260327163631_8EBT0 NZ001R 2026-03-28T12:06:38.188Z 2026-04-05T12:34:47.790Z
9587774 9587774 20260327154144_0WNpt NZ001R 2026-03-28T12:06:18.745Z 2026-04-05T12:34:41.568Z
9587473 9587473 20260327131049_26Gh5 NZ001R 2026-03-28T12:05:37.722Z 2026-04-05T12:34:28.003Z
9587422 9587422 20260327124013_oTQhw NZ001R 2026-03-28T12:05:29.722Z 2026-04-05T12:34:26.024Z
9587309 9587309 20260327120210_hrhi0 NZ001R 2026-03-28T12:05:15.016Z 2026-04-05T12:34:12.670Z
9587047 9587047 20260327105734_iaGKw NZ001R 2026-03-28T12:04:40.898Z 2026-04-05T12:33:59.988Z
9587004 9587004 20260327104340_bsMD5 NZ001R 2026-03-28T12:04:32.856Z 2026-04-05T12:33:58.137Z
9586990 9586990 20260327103815_2toDd NZ001R 2026-03-28T12:04:30.438Z 2026-04-05T12:33:57.464Z
9586793 9586793 20260327093825_Vg8Hm NZ001R 2026-03-28T12:04:01.717Z 2026-04-05T12:33:48.799Z
9586658 9586658 20260327085701_m5hxr NZ001R 2026-03-28T12:03:40.277Z 2026-04-05T12:33:36.193Z
9586563 9586563 20260327082348_YFQ36 NZ001R 2026-03-28T12:03:25.802Z 2026-04-05T12:33:30.615Z
9586557 9586557 20260327081805_YAHwK NZ001R 2026-03-28T12:03:24.615Z 2026-04-05T12:33:30.384Z
9572385 9572385 20260324085154_CgqIf NZ001R 2026-03-25T12:04:54.386Z 2026-04-02T12:35:22.403Z
9572262 9572262 20260324082208_BLed1 NZ001R 2026-03-25T12:04:28.673Z 2026-04-02T12:35:11.548Z
9572177 9572177 20260324080007_cJG3L NZ001R 2026-03-25T12:04:07.513Z 2026-04-02T12:35:06.479Z
9568548 9568548 20260323165312_GJ8R0 NZ001R 2026-03-24T12:15:16.861Z 2026-03-31T12:28:30.612Z
9568523 9568523 20260323165211_SHLWS NZ001R 2026-03-24T12:15:14.228Z 2026-03-31T12:28:30.315Z
9568515 9568515 20260323165156_vdMBY NZ001R 2026-03-24T12:15:13.629Z 2026-03-31T12:28:30.211Z
9568485 9568485 20260323164748_LC2Qs NZ001R 2026-03-24T12:15:10.622Z 2026-03-31T12:28:29.762Z
9568436 9568436 20260323164402_5ExHU NZ001R 2026-03-24T12:15:06.849Z 2026-03-31T12:28:29.249Z
9568368 9568368 20260323163508_4DJDm NZ001R 2026-03-24T12:14:58.294Z 2026-03-31T12:28:28.386Z

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