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 = "NZ0011" 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
9177824 9177824 20260110112745_oh3qp NZ0011 2026-01-11T14:13:13.041Z 2026-01-18T15:10:10.684Z
9177792 9177792 20260110111921_3yg2z NZ0011 2026-01-11T14:13:02.937Z 2026-01-18T15:10:08.893Z
9177511 9177511 20260110100624_Rqvi4 NZ0011 2026-01-11T14:12:12.549Z 2026-01-18T15:09:46.312Z
9165590 9165590 20260107130925_6sEHN NZ0011 2026-01-08T14:17:00.179Z 2026-01-13T15:04:33.181Z
9165547 9165547 20260107122857_uFhbc NZ0011 2026-01-08T14:16:49.987Z 2026-01-13T15:04:12.308Z
9165093 9165093 20260107150506_q1nNa NZ0011 2026-01-08T14:15:24.627Z 2026-01-13T15:05:28.705Z
9164821 9164821 20260107142944_A3HSK NZ0011 2026-01-08T14:14:26.848Z 2026-01-13T15:05:06.812Z
9164449 9164449 20260107131818_f4drV NZ0011 2026-01-08T14:13:11.890Z 2026-01-13T15:04:37.984Z
9164434 9164434 20260107131432_okICl NZ0011 2026-01-08T14:13:08.834Z 2026-01-13T15:04:35.163Z
9164420 9164420 20260107131059_abVGq NZ0011 2026-01-08T14:13:05.964Z 2026-01-13T15:04:33.982Z
9164290 9164290 20260107124449_ZFrxt NZ0011 2026-01-08T14:12:34.814Z 2026-01-13T15:04:24.538Z
9164187 9164187 20260107122857_xwud0 NZ0011 2026-01-08T14:12:15.809Z 2026-01-13T15:04:12.093Z
9164145 9164145 20260107121425_ETXt3 NZ0011 2026-01-08T14:12:04.787Z 2026-01-13T15:04:07.898Z
9164013 9164013 20260107114147_krR9T NZ0011 2026-01-08T14:11:28.904Z 2026-01-13T15:03:59.777Z
9163987 9163987 20260107113734_TGHV9 NZ0011 2026-01-08T14:11:24.877Z 2026-01-13T15:03:58.709Z
9163828 9163828 20260107104204_4Zu3P NZ0011 2026-01-08T14:10:40.337Z 2026-01-13T15:03:41.548Z
9163642 9163642 20260107094548_uABMt NZ0011 2026-01-08T14:09:59.039Z 2026-01-13T15:03:30.710Z
9161396 9161396 20260106125346_0NvYn NZ0011 2026-01-07T14:16:26.655Z 2026-01-13T15:10:44.463Z
9152846 9152846 20260105140419_pVYzR NZ0011 2026-01-06T14:18:42.659Z 2026-01-13T15:16:33.620Z
9152524 9152524 20260105120517_g7LiG NZ0011 2026-01-06T14:17:32.648Z 2026-01-13T15:16:02.455Z
9152487 9152487 20260105115553_NAmLe NZ0011 2026-01-06T14:17:25.793Z 2026-01-13T15:16:00.877Z
9152444 9152444 20260105113949_tllj8 NZ0011 2026-01-06T14:17:14.666Z 2026-01-13T15:15:58.538Z
9152266 9152266 20260105103218_VdES6 NZ0011 2026-01-06T14:16:30.647Z 2026-01-13T15:15:39.887Z
9152225 9152225 20260105101354_zKnDJ NZ0011 2026-01-06T14:16:18.287Z 2026-01-13T15:15:37.629Z
9133811 9133811 20260103153252_Qp2cT NZ0011 2026-01-04T14:22:57.104Z 2026-01-10T15:03:44.853Z
9133775 9133775 20260103151657_fS2xh NZ0011 2026-01-04T14:22:47.201Z 2026-01-10T15:03:42.405Z
9133766 9133766 20260103151351_IPlEH NZ0011 2026-01-04T14:22:39.446Z 2026-01-10T15:03:39.326Z
9133759 9133759 20260103151220_lyAuE NZ0011 2026-01-04T14:22:37.258Z 2026-01-10T15:03:38.995Z
9133561 9133561 20260103133505_sYSxa NZ0011 2026-01-04T14:21:21.449Z 2026-01-10T15:03:09.603Z
9133230 9133230 20260103123617_Nypn3 NZ0011 2026-01-04T14:20:15.786Z 2026-01-10T15:02:36.657Z
9133115 9133115 20260103121644_52NlL NZ0011 2026-01-04T14:19:50.309Z 2026-01-10T15:02:28.682Z
9118239 9118239 20251231140536_dPSKh NZ0011 2026-01-01T14:34:39.701Z 2026-01-08T15:14:16.566Z
9118163 9118163 20251231131822_WVHEA NZ0011 2026-01-01T14:34:23.086Z 2026-01-08T15:14:10.241Z
9118028 9118028 20251231124852_izvdh NZ0011 2026-01-01T14:33:56.781Z 2026-01-08T15:13:52.927Z
9117468 9117468 20251231110534_B7x9l NZ0011 2026-01-01T14:31:46.190Z 2026-01-08T15:13:08.463Z
9117377 9117377 20251231104736_W62bl NZ0011 2026-01-01T14:31:19.218Z 2026-01-08T15:12:55.450Z
9106101 9106101 20251230153330_fuJpZ NZ0011 2025-12-31T14:27:42.853Z 2026-01-07T15:11:46.357Z
9097124 9097124 20251227153353_HGnaH NZ0011 2025-12-30T15:08:23.632Z 2026-01-04T15:33:43.576Z
9096968 9096968 20251227152216_cIvLH NZ0011 2025-12-30T15:08:06.027Z 2026-01-04T15:33:28.978Z
9096944 9096944 20251227152012_vseg4 NZ0011 2025-12-30T15:08:04.723Z 2026-01-04T15:33:28.393Z
9096868 9096868 20251227151239_rlpAR NZ0011 2025-12-30T15:08:00.684Z 2026-01-04T15:33:26.651Z
9096714 9096714 20251227150319_qIsFB NZ0011 2025-12-30T15:07:54.562Z 2026-01-04T15:33:21.527Z
9096280 9096280 20251227144033_gijDc NZ0011 2025-12-30T15:07:21.669Z 2026-01-04T15:33:10.015Z
9096273 9096273 20251227143942_IROOm NZ0011 2025-12-30T15:07:21.400Z 2026-01-04T15:33:09.913Z
9096261 9096261 20251227143910_uoiGA NZ0011 2025-12-30T15:07:20.764Z 2026-01-04T15:33:09.540Z
9096244 9096244 20251227143807_4Fx2u NZ0011 2025-12-30T15:07:19.542Z 2026-01-04T15:33:09.243Z
9095970 9095970 20251227142227_rzkU3 NZ0011 2025-12-30T15:07:08.559Z 2026-01-04T15:32:48.476Z
9095939 9095939 20251227141928_Q9rd8 NZ0011 2025-12-30T15:07:06.650Z 2026-01-04T15:32:47.215Z
9095922 9095922 20251227141752_4GlLs NZ0011 2025-12-30T15:07:05.841Z 2026-01-04T15:32:46.841Z
9095868 9095868 20251227141522_U22iI NZ0011 2025-12-30T15:07:03.951Z 2026-01-04T15:32:45.913Z
9095715 9095715 20251227140627_2YR2w NZ0011 2025-12-30T15:06:44.207Z 2026-01-04T15:32:42.043Z
9095643 9095643 20251227140331_rqnlt NZ0011 2025-12-30T15:06:41.386Z 2026-01-04T15:32:39.920Z
9095595 9095595 20251227140037_EjAYM NZ0011 2025-12-30T15:06:38.919Z 2026-01-04T15:32:38.427Z
9095474 9095474 20251227135116_KmOzT NZ0011 2025-12-30T15:06:34.083Z 2026-01-04T15:32:35.481Z
9094603 9094603 20251227124131_1qrPc NZ0011 2025-12-30T15:05:41.416Z 2026-01-04T15:31:58.815Z
9093672 9093672 20251227102312_AZx6N NZ0011 2025-12-30T15:04:14.690Z 2026-01-04T15:31:05.209Z
9090585 9090585 20251228154504_8wpaF NZ0011 2025-12-30T14:50:33.215Z 2026-01-05T15:13:30.468Z
9090557 9090557 20251228153442_rlM7u NZ0011 2025-12-30T14:50:30.158Z 2026-01-05T15:13:29.609Z
9090252 9090252 20251228144856_L8Chn NZ0011 2025-12-30T14:49:55.457Z 2025-12-31T14:55:47.849Z
9090217 9090217 20251228144339_wdrKq NZ0011 2025-12-30T14:49:52.988Z 2026-01-05T15:13:03.836Z
9090158 9090158 20251228144130_lAldm NZ0011 2025-12-30T14:49:48.473Z 2026-01-05T15:13:02.765Z
9090038 9090038 20251228142739_2OuKB NZ0011 2025-12-30T14:49:35.812Z 2026-01-05T15:12:59.819Z
9089912 9089912 20251228140858_aW7xo NZ0011 2025-12-30T14:49:17.749Z 2026-01-05T15:12:56.859Z
9089848 9089848 20251228140143_UDTbF NZ0011 2025-12-30T14:49:13.084Z 2026-01-05T15:12:55.548Z
9089765 9089765 20251228134732_e2ttP NZ0011 2025-12-30T14:49:06.120Z 2026-01-05T15:12:53.302Z
9089759 9089759 20251228134723_8Up22 NZ0011 2025-12-30T14:49:05.375Z 2026-01-05T15:12:53.134Z
9089591 9089591 20251228132522_smlr9 NZ0011 2025-12-30T14:48:44.291Z 2026-01-05T15:12:48.778Z
9089571 9089571 20251228132404_EmP7q NZ0011 2025-12-30T14:48:42.419Z 2025-12-31T14:55:09.843Z
9089516 9089516 20251228131806_RMHjV NZ0011 2025-12-30T14:48:38.420Z 2026-01-05T15:12:46.819Z
9088730 9088730 20251228121728_UxFoY NZ0011 2025-12-30T14:47:00.197Z 2026-01-05T15:12:10.969Z
9088713 9088713 20251228121640_TQrMA NZ0011 2025-12-30T14:46:58.599Z 2025-12-31T14:54:30.065Z
9088630 9088630 20251228120611_e0kOT NZ0011 2025-12-30T14:46:50.913Z 2026-01-05T15:12:08.255Z
9088496 9088496 20251228115608_ecA2L NZ0011 2025-12-30T14:46:31.715Z 2026-01-05T15:12:04.720Z
9088473 9088473 20251228115423_e1SrN NZ0011 2025-12-30T14:46:29.945Z 2026-01-05T15:12:02.365Z
9088020 9088020 20251228110542_6pxNB NZ0011 2025-12-30T14:45:29.531Z 2026-01-05T15:11:37.944Z
9087996 9087996 20251228110252_UDC3A NZ0011 2025-12-30T14:45:26.812Z 2026-01-05T15:11:37.037Z
9070188 9070188 20251226152849_XTUy0 NZ0011 2025-12-29T14:47:23.192Z 2026-01-03T15:41:36.885Z
9070063 9070063 20251226151023_PPpKi NZ0011 2025-12-29T14:47:02.345Z 2026-01-03T15:41:24.013Z
9069998 9069998 20251226150051_yva0g NZ0011 2025-12-29T14:46:56.304Z 2025-12-30T15:21:43.876Z
9069969 9069969 20251226145803_lXzvv NZ0011 2025-12-29T14:46:54.641Z 2026-01-03T15:41:19.221Z
9069866 9069866 20251226144743_tz2AH NZ0011 2025-12-29T14:46:48.665Z 2026-01-03T15:41:15.318Z
9069737 9069737 20251226143349_bUo0z NZ0011 2025-12-29T14:46:38.848Z 2026-01-03T15:41:10.629Z
9069528 9069528 20251226141353_bJ2YB NZ0011 2025-12-29T14:46:12.991Z 2025-12-30T15:21:36.592Z
9069511 9069511 20251226141159_hbi3r NZ0011 2025-12-29T14:46:11.672Z 2026-01-03T15:40:51.862Z
9069409 9069409 20251226140035_Ky4T7 NZ0011 2025-12-29T14:46:05.480Z 2026-01-03T15:40:46.598Z
9069321 9069321 20251226134735_3evDu NZ0011 2025-12-29T14:45:58.731Z 2025-12-30T15:21:32.970Z
9069316 9069316 20251226134551_G20Fg NZ0011 2025-12-29T14:45:58.261Z 2026-01-03T15:40:42.330Z
9069309 9069309 20251226134453_bEps3 NZ0011 2025-12-29T14:45:53.999Z 2026-01-03T15:40:42.222Z
9069290 9069290 20251226134153_vrzx2 NZ0011 2025-12-29T14:45:43.590Z 2026-01-03T15:40:41.512Z
9068883 9068883 20251226125344_4YbL2 NZ0011 2025-12-29T14:44:59.991Z 2026-01-03T15:40:17.157Z
9068004 9068004 20251226110858_9L8CK NZ0011 2025-12-29T14:43:13.905Z 2026-01-03T15:39:27.045Z
9067606 9067606 20251226100854_BRhv0 NZ0011 2025-12-29T14:42:23.373Z 2026-01-03T15:38:59.364Z
9067508 9067508 20251226095400_f6uwP NZ0011 2025-12-29T14:42:03.173Z 2026-01-03T15:38:55.673Z
9046543 9046543 20251223141319_vOstI NZ0011 2025-12-28T14:55:08.035Z 2025-12-31T15:43:16.772Z
9046444 9046444 20251223135051_tt2c9 NZ0011 2025-12-28T14:54:56.827Z 2025-12-31T15:43:05.311Z
9046383 9046383 20251223132809_XQPE3 NZ0011 2025-12-28T14:54:53.338Z 2025-12-31T15:43:04.303Z
9045560 9045560 20251223102753_wKPIp NZ0011 2025-12-28T14:53:49.348Z 2025-12-31T15:42:51.845Z
9045528 9045528 20251223102411_9nFXR NZ0011 2025-12-28T14:53:47.960Z 2025-12-31T15:42:51.484Z
9045419 9045419 20251223094937_HTCsN NZ0011 2025-12-28T14:53:24.288Z 2025-12-31T15:42:50.007Z
9041479 9041479 20251224150733_aTXJR NZ0011 2025-12-28T14:43:49.131Z 2026-01-01T15:56:23.848Z

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