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 = "NZ0045" 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
9269671 9269671 20260128135245_eiWxB NZ0045 2026-01-29T14:09:01.638Z 2026-01-29T14:09:01.638Z
9269616 9269616 20260128134516_X0sqo NZ0045 2026-01-29T14:08:51.544Z 2026-01-29T14:08:51.544Z
9269522 9269522 20260128132908_7MJjH NZ0045 2026-01-29T14:08:22.312Z 2026-01-29T14:08:22.312Z
9269494 9269494 20260128132727_RzT4r NZ0045 2026-01-29T14:08:16.665Z 2026-01-29T14:08:16.665Z
9265751 9265751 20260127155630_NdCyA NZ0045 2026-01-28T14:11:14.400Z 2026-01-29T14:30:24.668Z
9265735 9265735 20260127155430_W7vi3 NZ0045 2026-01-28T14:11:11.663Z 2026-01-29T14:30:24.665Z
9265517 9265517 20260127152403_tH2Nl NZ0045 2026-01-28T14:10:26.025Z 2026-01-29T14:30:24.597Z
9245996 9245996 20260122155615_z3PqT NZ0045 2026-01-23T14:04:14.576Z 2026-01-29T14:50:28.960Z
9245994 9245994 20260122155603_rX8T6 NZ0045 2026-01-23T14:04:13.870Z 2026-01-29T14:50:28.800Z
9233251 9233251 20260120135543_Qv3du NZ0045 2026-01-21T14:05:01.037Z 2026-01-29T15:00:51.717Z
9233247 9233247 20260120135528_x7X4X NZ0045 2026-01-21T14:04:57.735Z 2026-01-29T15:00:51.616Z
9233239 9233239 20260120135115_hfA0L NZ0045 2026-01-21T14:04:55.910Z 2026-01-29T15:00:51.212Z
9233237 9233237 20260120135038_nLGmA NZ0045 2026-01-21T14:04:55.359Z 2026-01-29T15:00:51.086Z
9232615 9232615 20260120115759_y18Ki NZ0045 2026-01-21T14:02:34.691Z 2026-01-29T14:59:53.319Z
9227377 9227377 20260119160126_ngHRQ NZ0045 2026-01-20T14:08:00.336Z 2026-01-28T14:56:17.592Z
9227362 9227362 20260119155607_TnfXr NZ0045 2026-01-20T14:07:56.735Z 2026-01-28T14:56:16.448Z
9227301 9227301 20260119153231_dK2kC NZ0045 2026-01-20T14:07:36.858Z 2026-01-28T14:56:12.521Z
9227108 9227108 20260119143742_ai4IV NZ0045 2026-01-20T14:06:39.202Z 2026-01-28T14:55:52.044Z
9227088 9227088 20260119142745_LCz69 NZ0045 2026-01-20T14:06:33.418Z 2026-01-28T14:55:50.793Z
9227011 9227011 20260119135657_Lp3X5 NZ0045 2026-01-20T14:06:10.978Z 2026-01-28T14:55:46.680Z
9226987 9226987 20260119135204_5R1CA NZ0045 2026-01-20T14:06:02.178Z 2026-01-28T14:55:45.908Z
9226984 9226984 20260119134703_QmwMH NZ0045 2026-01-20T14:06:01.471Z 2026-01-28T14:55:45.634Z
9226906 9226906 20260119132832_DibB0 NZ0045 2026-01-20T14:05:35.910Z 2026-01-28T14:55:34.428Z
9226427 9226427 20260119115940_30v9h NZ0045 2026-01-20T14:03:08.736Z 2026-01-28T14:54:59.658Z
9226256 9226256 20260119113505_2TS6n NZ0045 2026-01-20T14:02:04.982Z 2026-01-28T14:54:50.930Z
9226242 9226242 20260119113247_t6k2d NZ0045 2026-01-20T14:02:01.041Z 2026-01-28T14:54:50.062Z
9221500 9221500 20260118154602_XlQJG NZ0045 2026-01-19T14:08:05.053Z 2026-01-27T15:00:28.250Z
9221430 9221430 20260118153905_y8AKC NZ0045 2026-01-19T14:07:53.594Z 2026-01-27T15:00:21.700Z
9221417 9221417 20260118153606_qbL2C NZ0045 2026-01-19T14:07:51.467Z 2026-01-27T15:00:20.152Z
9221360 9221360 20260118152656_uP1wX NZ0045 2026-01-19T14:07:38.869Z 2026-01-27T15:00:07.325Z
9221279 9221279 20260118151249_IogSC NZ0045 2026-01-19T14:07:20.183Z 2026-01-27T14:59:59.863Z
9221253 9221253 20260118151121_0suAv NZ0045 2026-01-19T14:07:16.296Z 2026-01-27T14:59:59.036Z
9221200 9221200 20260118150134_0UFPy NZ0045 2026-01-19T14:07:02.666Z 2026-01-27T14:59:56.798Z
9221190 9221190 20260118150058_ZcrFi NZ0045 2026-01-19T14:07:00.550Z 2026-01-27T14:59:56.680Z
9221158 9221158 20260118145537_o434t NZ0045 2026-01-19T14:06:54.994Z 2026-01-27T14:59:55.516Z
9220968 9220968 20260118143034_fbi72 NZ0045 2026-01-19T14:06:18.721Z 2026-01-27T14:59:48.397Z
9220957 9220957 20260118142353_ST4M2 NZ0045 2026-01-19T14:06:16.539Z 2026-01-27T14:59:47.955Z
9220830 9220830 20260118135903_1DMM2 NZ0045 2026-01-19T14:05:47.458Z 2026-01-27T14:59:31.683Z
9220826 9220826 20260118135842_IcXiB NZ0045 2026-01-19T14:05:46.773Z 2026-01-27T14:59:31.588Z
9220805 9220805 20260118135416_fTSuJ NZ0045 2026-01-19T14:05:42.758Z 2026-01-27T14:59:30.790Z
9220711 9220711 20260118133208_GuAcg NZ0045 2026-01-19T14:05:17.200Z 2026-01-27T14:59:25.497Z
9220687 9220687 20260118132832_HUKrs NZ0045 2026-01-19T14:05:14.380Z 2026-01-27T14:59:24.895Z
9220647 9220647 20260118131827_4MXXo NZ0045 2026-01-19T14:05:05.565Z 2026-01-27T14:59:23.808Z
9220603 9220603 20260118131224_TqLvs NZ0045 2026-01-19T14:04:53.839Z 2026-01-27T14:59:21.914Z
9220114 9220114 20260118120740_74f0l NZ0045 2026-01-19T14:02:47.633Z 2026-01-27T14:58:50.276Z
9220061 9220061 20260118115936_0Jlk1 NZ0045 2026-01-19T14:02:24.948Z 2026-01-27T14:58:48.019Z
9219846 9219846 20260118113038_rIcEz NZ0045 2026-01-19T14:01:13.697Z 2026-01-27T14:58:36.134Z
9210302 9210302 20260112125539_VAHCl NZ0045 2026-01-16T14:47:47.137Z 2026-01-20T15:26:30.964Z
9210294 9210294 20260112112029_SuHWd NZ0045 2026-01-16T14:46:27.538Z 2026-01-20T15:25:38.264Z
9193050 9193050 20260112133026_9bb6U NZ0045 2026-01-13T14:30:03.465Z 2026-01-20T15:26:57.594Z
9193046 9193046 20260112132933_WbESm NZ0045 2026-01-13T14:30:03.057Z 2026-01-20T15:26:57.484Z
9192763 9192763 20260112125919_4XEjW NZ0045 2026-01-13T14:29:12.162Z 2026-01-20T15:26:32.283Z
9192696 9192696 20260112125342_c1td8 NZ0045 2026-01-13T14:29:03.659Z 2026-01-20T15:26:30.224Z
9192646 9192646 20260112125003_Oekzy NZ0045 2026-01-13T14:28:57.718Z 2026-01-20T15:26:28.194Z
9192463 9192463 20260112123656_oMdZH NZ0045 2026-01-13T14:28:26.192Z 2026-01-20T15:26:22.786Z
9192006 9192006 20260112115915_QenlT NZ0045 2026-01-13T14:27:10.707Z 2026-01-20T15:25:55.482Z
9191691 9191691 20260112113509_Ist6i NZ0045 2026-01-13T14:26:10.800Z 2026-01-15T14:49:01.388Z
9191487 9191487 20260112111214_96HxV NZ0045 2026-01-13T14:25:35.627Z 2026-01-20T15:25:35.776Z
9191319 9191319 20260112105741_rrcXH NZ0045 2026-01-13T14:25:03.051Z 2026-01-20T15:25:20.206Z
9191256 9191256 20260112104953_34IMx NZ0045 2026-01-13T14:24:53.854Z 2026-01-20T15:25:16.215Z
9191182 9191182 20260112104340_9nZxJ NZ0045 2026-01-13T14:24:38.785Z 2026-01-20T15:25:13.500Z
9190914 9190914 20260112101409_FvP1J NZ0045 2026-01-13T14:23:54.835Z 2026-01-20T15:24:54.649Z
9190812 9190812 20260112100140_YgYyQ NZ0045 2026-01-13T14:23:32.551Z 2026-01-20T15:24:50.362Z
9186858 9186858 20260112155148_k8rVY NZ0045 2026-01-13T14:03:44.907Z 2026-01-21T15:03:04.559Z
9186674 9186674 20260112151951_7bpLe NZ0045 2026-01-13T14:03:04.245Z 2026-01-21T15:02:53.143Z
9186556 9186556 20260112145715_JszZo NZ0045 2026-01-13T14:02:31.474Z 2026-01-21T15:02:44.400Z
9186508 9186508 20260112144900_5NVs0 NZ0045 2026-01-13T14:02:18.507Z 2026-01-21T15:02:38.989Z
9178740 9178740 20260110135427_k2z6d NZ0045 2026-01-11T14:15:38.140Z 2026-01-18T15:11:13.886Z
9178688 9178688 20260110134530_yjYhB NZ0045 2026-01-11T14:15:32.812Z 2026-01-18T15:11:11.478Z
9177957 9177957 20260110115214_2wJFU NZ0045 2026-01-11T14:13:39.164Z 2026-01-18T15:10:16.501Z
9174243 9174243 20260110155359_A9BVK NZ0045 2026-01-11T14:01:54.365Z 2026-01-19T15:14:44.669Z
9174231 9174231 20260110155335_Ag2uo NZ0045 2026-01-11T14:01:52.961Z 2026-01-19T15:14:44.184Z
9174169 9174169 20260110154603_rjlWW NZ0045 2026-01-11T14:01:38.085Z 2026-01-19T15:14:39.195Z
9174089 9174089 20260110152818_AP1Tm NZ0045 2026-01-11T14:01:19.586Z 2026-01-19T15:14:34.867Z
9174030 9174030 20260110151804_D7fTJ NZ0045 2026-01-11T14:01:04.685Z 2026-01-19T15:14:32.149Z
9173989 9173989 20260110151415_0EC92 NZ0045 2026-01-11T14:00:55.922Z 2026-01-19T15:14:30.693Z
9173875 9173875 20260110145450_209sL NZ0045 2026-01-11T14:00:32.995Z 2026-01-19T15:14:14.699Z
9173834 9173834 20260110144918_TJ785 NZ0045 2026-01-11T14:00:24.941Z 2026-01-19T15:14:12.769Z
9168629 9168629 20260108114056_Tr3ll NZ0045 2026-01-09T14:11:36.962Z 2026-01-16T15:12:54.838Z
9165384 9165384 20260107153751_EqR8G NZ0045 2026-01-08T14:16:16.007Z 2026-01-13T15:05:51.240Z
9165090 9165090 20260107150452_s8iTI NZ0045 2026-01-08T14:15:23.985Z 2026-01-13T15:05:28.548Z
9165031 9165031 20260107145456_SBp7c NZ0045 2026-01-08T14:15:10.747Z 2026-01-13T15:05:24.658Z
9165026 9165026 20260107145449_pjENa NZ0045 2026-01-08T14:15:10.101Z 2026-01-13T15:05:24.489Z
9164800 9164800 20260107142640_R9cRg NZ0045 2026-01-08T14:14:23.159Z 2026-01-13T15:05:04.850Z
9164731 9164731 20260107141538_jXqUA NZ0045 2026-01-08T14:14:10.715Z 2026-01-13T15:05:00.431Z
9164663 9164663 20260107140201_2DH1B NZ0045 2026-01-08T14:13:57.406Z 2026-01-13T15:04:57.241Z
9164636 9164636 20260107135802_lpzgL NZ0045 2026-01-08T14:13:52.764Z 2026-01-13T15:04:55.281Z
9152453 9152453 20260105114238_FB3Fn NZ0045 2026-01-06T14:17:16.420Z 2026-01-13T15:15:59.006Z
9133696 9133696 20260103143805_0Tvn6 NZ0045 2026-01-04T14:22:09.539Z 2026-01-10T15:03:28.115Z
9133675 9133675 20260103143246_56Oxj NZ0045 2026-01-04T14:22:05.144Z 2026-01-10T15:03:25.426Z
9096167 9096167 20251227143442_ZamCk NZ0045 2025-12-30T15:07:16.536Z 2026-01-04T15:32:55.211Z
9095773 9095773 20251227141014_liBED NZ0045 2025-12-30T15:07:00.382Z 2026-01-04T15:32:43.808Z
9095736 9095736 20251227140743_fHpGU NZ0045 2025-12-30T15:06:45.025Z 2026-01-04T15:32:42.514Z
9095709 9095709 20251227140600_bUE23 NZ0045 2025-12-30T15:06:44.023Z 2026-01-04T15:32:41.887Z
9095486 9095486 20251227135213_45iIB NZ0045 2025-12-30T15:06:34.515Z 2026-01-04T15:32:35.707Z
9095093 9095093 20251227132908_ZfjwY NZ0045 2025-12-30T15:06:05.534Z 2026-01-04T15:32:15.174Z
9094912 9094912 20251227131326_1IMmX NZ0045 2025-12-30T15:05:56.816Z 2026-01-04T15:32:08.548Z
9094816 9094816 20251227130201_J3W4j NZ0045 2025-12-30T15:05:51.757Z 2026-01-04T15:32:05.324Z
9094719 9094719 20251227125243_dIQEO NZ0045 2025-12-30T15:05:47.173Z 2025-12-30T15:05:47.173Z
9094212 9094212 20251227115304_EB2cY NZ0045 2025-12-30T15:05:04.678Z 2026-01-04T15:31:36.436Z

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