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 = "NZ0019" 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
9233469 9233469 20260120154236_tEiwI NZ0019 2026-01-21T14:05:52.050Z 2026-01-29T15:01:20.664Z
9233395 9233395 20260120150532_9fu79 NZ0019 2026-01-21T14:05:40.433Z 2026-01-29T15:01:04.668Z
9233216 9233216 20260120133839_gRRCo NZ0019 2026-01-21T14:04:52.276Z 2026-01-29T15:00:49.891Z
9232993 9232993 20260120130345_AEN26 NZ0019 2026-01-21T14:04:11.227Z 2026-01-29T15:00:34.575Z
9232902 9232902 20260120124742_Aop6F NZ0019 2026-01-21T14:03:42.877Z 2026-01-29T15:00:23.808Z
9232705 9232705 20260120121202_tgp8Q NZ0019 2026-01-21T14:02:56.168Z 2026-01-29T14:59:59.537Z
9227358 9227358 20260119155607_TnfXr NZ0019 2026-01-20T14:07:56.735Z 2026-01-28T14:56:16.448Z
9227264 9227264 20260119152440_CnFTx NZ0019 2026-01-20T14:07:28.512Z 2026-01-28T14:56:01.787Z
9227218 9227218 20260119151354_9JM8c NZ0019 2026-01-20T14:07:12.355Z 2026-01-28T14:55:59.662Z
9225482 9225482 20260118095619_5qygP NZ0019 2026-01-19T14:29:05.518Z 2026-01-26T15:04:36.024Z
9225451 9225451 20260118094724_rhjj0 NZ0019 2026-01-19T14:28:59.994Z 2026-01-26T15:04:34.771Z
9221544 9221544 20260118155646_j1DMo NZ0019 2026-01-19T14:08:19.673Z 2026-01-27T15:00:31.353Z
9221535 9221535 20260118155142_J1Aw1 NZ0019 2026-01-19T14:08:13.353Z 2026-01-27T15:00:30.223Z
9221514 9221514 20260118154918_afDLx NZ0019 2026-01-19T14:08:08.971Z 2026-01-27T15:00:28.859Z
9221432 9221432 20260118153933_stU3g NZ0019 2026-01-19T14:07:53.998Z 2026-01-27T15:00:21.940Z
9221356 9221356 20260118152656_uP1wX NZ0019 2026-01-19T14:07:38.869Z 2026-01-27T15:00:07.325Z
9221251 9221251 20260118151121_0suAv NZ0019 2026-01-19T14:07:16.296Z 2026-01-27T14:59:59.036Z
9221195 9221195 20260118150134_0UFPy NZ0019 2026-01-19T14:07:02.666Z 2026-01-27T14:59:56.798Z
9221178 9221178 20260118145751_rnNYM NZ0019 2026-01-19T14:06:57.512Z 2026-01-27T14:59:56.128Z
9221163 9221163 20260118145625_e1h2n NZ0019 2026-01-19T14:06:55.517Z 2026-01-27T14:59:55.660Z
9221101 9221101 20260118145011_RfLKc NZ0019 2026-01-19T14:06:47.974Z 2026-01-27T14:59:53.802Z
9221077 9221077 20260118144858_alL1u NZ0019 2026-01-19T14:06:43.800Z 2026-01-27T14:59:52.751Z
9221004 9221004 20260118144231_yEGKz NZ0019 2026-01-19T14:06:27.073Z 2026-01-27T14:59:50.518Z
9220802 9220802 20260118135416_fTSuJ NZ0019 2026-01-19T14:05:42.758Z 2026-01-27T14:59:30.790Z
9220713 9220713 20260118133323_5wGhP NZ0019 2026-01-19T14:05:17.965Z 2026-01-27T14:59:25.615Z
9210290 9210290 20260112150102_FsdIk NZ0019 2026-01-16T14:32:04.227Z 2026-01-21T15:02:45.416Z
9187044 9187044 20260111145102_mt3bv NZ0019 2026-01-13T14:05:06.611Z 2026-01-20T15:19:55.043Z
9186854 9186854 20260112155148_k8rVY NZ0019 2026-01-13T14:03:44.907Z 2026-01-21T15:03:04.558Z
9186764 9186764 20260112153324_IQw0z NZ0019 2026-01-13T14:03:24.129Z 2026-01-21T15:02:56.881Z
9186748 9186748 20260112153228_2p2M5 NZ0019 2026-01-13T14:03:21.757Z 2026-01-21T15:02:56.549Z
9186724 9186724 20260112152747_3vlo2 NZ0019 2026-01-13T14:03:15.284Z 2026-01-21T15:02:55.756Z
9186669 9186669 20260112151701_g9xNN NZ0019 2026-01-13T14:03:02.460Z 2026-01-21T15:02:51.133Z
9186657 9186657 20260112151507_j7siK NZ0019 2026-01-13T14:02:58.281Z 2026-01-21T15:02:49.785Z
9186650 9186650 20260112151439_GqIqQ NZ0019 2026-01-13T14:02:52.093Z 2026-01-21T15:02:49.222Z
9186629 9186629 20260112151335_FmbWF NZ0019 2026-01-13T14:02:47.164Z 2026-01-21T15:02:48.722Z
9186622 9186622 20260112151056_zKhzs NZ0019 2026-01-13T14:02:45.513Z 2026-01-21T15:02:48.486Z
9186589 9186589 20260112150059_gUaIW NZ0019 2026-01-13T14:02:39.252Z 2026-01-21T15:02:45.324Z
9186498 9186498 20260112144521_jyzBc NZ0019 2026-01-13T14:02:16.811Z 2026-01-21T15:02:37.696Z
9186268 9186268 20260112140714_fGjYH NZ0019 2026-01-13T14:01:09.570Z 2026-01-21T15:02:16.463Z
9185792 9185792 20260111131034_H8Ejn NZ0019 2026-01-12T14:26:00.399Z 2026-01-19T15:21:51.595Z
9185370 9185370 20260111140945_OYvqN NZ0019 2026-01-12T14:23:08.784Z 2026-01-19T15:22:27.558Z
9185284 9185284 20260111134823_QcXGQ NZ0019 2026-01-12T14:22:57.457Z 2026-01-19T15:22:03.560Z
9185148 9185148 20260111131142_dd692 NZ0019 2026-01-12T14:22:34.982Z 2026-01-19T15:21:52.297Z
9184278 9184278 20260111110336_CrlRY NZ0019 2026-01-12T14:20:10.077Z 2026-01-19T15:20:31.394Z
9184155 9184155 20260111104951_Qri7b NZ0019 2026-01-12T14:19:48.602Z 2026-01-19T15:20:25.288Z
9183721 9183721 20260111100547_l4AT2 NZ0019 2026-01-12T14:18:39.319Z 2026-01-19T15:20:09.520Z
9179268 9179268 20260111151442_yMrRu NZ0019 2026-01-12T14:00:55.457Z 2026-01-20T15:20:00.488Z
9179232 9179232 20260111150059_3sPV1 NZ0019 2026-01-12T14:00:47.000Z 2026-01-20T15:19:57.082Z
9179226 9179226 20260111145515_fLN05 NZ0019 2026-01-12T14:00:45.405Z 2026-01-20T15:19:56.045Z
9179064 9179064 20260107114918_Kaa40 NZ0019 2026-01-11T14:28:00.607Z 2026-01-13T15:04:01.499Z
9178833 9178833 20260110141706_vm8gN NZ0019 2026-01-11T14:15:48.743Z 2026-01-18T15:11:19.237Z
9178696 9178696 20260110134619_P0imH NZ0019 2026-01-11T14:15:33.798Z 2026-01-18T15:11:11.819Z
9178680 9178680 20260110134429_ZmnH7 NZ0019 2026-01-11T14:15:31.856Z 2026-01-18T15:11:11.220Z
9178633 9178633 20260110133512_53WUk NZ0019 2026-01-11T14:15:22.004Z 2026-01-18T15:11:09.369Z
9178224 9178224 20260110123226_KDdnN NZ0019 2026-01-11T14:14:18.426Z 2026-01-18T15:10:39.563Z
9178160 9178160 20260110122639_pfI1u NZ0019 2026-01-11T14:14:09.751Z 2026-01-18T15:10:36.979Z
9177958 9177958 20260110115214_1GqEN NZ0019 2026-01-11T14:13:39.471Z 2026-01-18T15:10:16.574Z
9177905 9177905 20260110114232_pQUly NZ0019 2026-01-11T14:13:29.455Z 2026-01-18T15:10:14.404Z
9174222 9174222 20260110155327_jFYHR NZ0019 2026-01-11T14:01:51.873Z 2026-01-19T15:14:43.807Z
9174195 9174195 20260110155113_wIDop NZ0019 2026-01-11T14:01:44.733Z 2026-01-19T15:14:41.352Z
9174176 9174176 20260110154839_aB1zV NZ0019 2026-01-11T14:01:39.778Z 2026-01-19T15:14:40.246Z
9174136 9174136 20260110153912_sFSQ0 NZ0019 2026-01-11T14:01:31.885Z 2026-01-19T15:14:37.509Z
9174093 9174093 20260110152834_NSu4q NZ0019 2026-01-11T14:01:21.148Z 2026-01-19T15:14:35.086Z
9174028 9174028 20260110151802_GC52Y NZ0019 2026-01-11T14:01:04.151Z 2026-01-19T15:14:32.031Z
9173795 9173795 20260110144702_DXx4M NZ0019 2026-01-11T14:00:17.723Z 2026-01-19T15:14:11.602Z
9168327 9168327 20260108103846_XW6Sp NZ0019 2026-01-09T14:10:51.971Z 2026-01-16T15:12:30.569Z
9168249 9168249 20260108102352_SOE2n NZ0019 2026-01-09T14:10:41.906Z 2026-01-16T15:12:25.374Z
9168223 9168223 20260108101944_mjuw4 NZ0019 2026-01-09T14:10:37.668Z 2026-01-16T15:12:24.086Z
9165407 9165407 20260107154202_G3RiG NZ0019 2026-01-08T14:16:19.194Z 2026-01-13T15:05:53.487Z
9165375 9165375 20260107153655_xv4gs NZ0019 2026-01-08T14:16:15.103Z 2026-01-13T15:05:50.925Z
9164586 9164586 20260107134755_gYhiV NZ0019 2026-01-08T14:13:45.820Z 2026-01-13T15:04:53.412Z
9164485 9164485 20260107132845_Sy0hV NZ0019 2026-01-08T14:13:23.560Z 2026-01-13T15:04:40.141Z
9164450 9164450 20260107131818_f4drV NZ0019 2026-01-08T14:13:11.890Z 2026-01-13T15:04:37.984Z
9164405 9164405 20260107130952_fG8So NZ0019 2026-01-08T14:13:03.664Z 2026-01-13T15:04:33.471Z
9164340 9164340 20260107125226_dascG NZ0019 2026-01-08T14:12:51.920Z 2026-01-13T15:04:28.530Z
9164238 9164238 20260107123922_2ODLO NZ0019 2026-01-08T14:12:27.806Z 2026-01-13T15:04:22.286Z
9164106 9164106 20260107120823_mUdTO NZ0019 2026-01-08T14:11:56.852Z 2026-01-13T15:04:06.096Z
9133819 9133819 20260103154106_k1y1z NZ0019 2026-01-04T14:23:01.373Z 2026-01-10T15:03:45.862Z
9133806 9133806 20260103152905_yBeVQ NZ0019 2026-01-04T14:22:55.320Z 2026-01-10T15:03:44.685Z
9133762 9133762 20260103151326_jKVHm NZ0019 2026-01-04T14:22:38.463Z 2026-01-10T15:03:39.176Z
9133735 9133735 20260103150342_d06ub NZ0019 2026-01-04T14:22:32.546Z 2026-01-10T15:03:37.724Z
9133692 9133692 20260103143805_0Tvn6 NZ0019 2026-01-04T14:22:09.539Z 2026-01-10T15:03:28.115Z
9133667 9133667 20260103142807_cCatK NZ0019 2026-01-04T14:22:03.710Z 2026-01-10T15:03:24.522Z
9133622 9133622 20260103140955_lbqaz NZ0019 2026-01-04T14:21:47.428Z 2026-01-10T15:03:21.274Z
9133610 9133610 20260103140443_2pCF2 NZ0019 2026-01-04T14:21:43.842Z 2026-01-10T15:03:20.452Z
9133592 9133592 20260103135039_2zBqh NZ0019 2026-01-04T14:21:38.446Z 2026-01-10T15:03:19.569Z
9133489 9133489 20260103131303_4Xvcp NZ0019 2026-01-04T14:21:03.164Z 2026-01-10T15:03:00.605Z
9097119 9097119 20251227153351_snUw5 NZ0019 2025-12-30T15:08:23.542Z 2026-01-04T15:33:43.210Z
9096953 9096953 20251227152046_Q2Ttp NZ0019 2025-12-30T15:08:05.444Z 2025-12-30T15:08:05.444Z
9096798 9096798 20251227150727_FnNdD NZ0019 2025-12-30T15:07:57.422Z 2026-01-04T15:33:23.732Z
9096638 9096638 20251227145756_BiBG2 NZ0019 2025-12-30T15:07:51.481Z 2026-01-04T15:33:19.522Z
9096391 9096391 20251227144755_QVjM4 NZ0019 2025-12-30T15:07:25.783Z 2026-01-04T15:33:13.116Z
9096359 9096359 20251227144501_T277A NZ0019 2025-12-30T15:07:24.537Z 2026-01-04T15:33:12.153Z
9095716 9095716 20251227140627_2YR2w NZ0019 2025-12-30T15:06:44.207Z 2026-01-04T15:32:42.066Z
9095699 9095699 20251227140516_AZeSl NZ0019 2025-12-30T15:06:43.699Z 2026-01-04T15:32:41.682Z
9095674 9095674 20251227140455_3qBy3 NZ0019 2025-12-30T15:06:42.995Z 2026-01-04T15:32:40.960Z
9095557 9095557 20251227135632_GaHvr NZ0019 2025-12-30T15:06:37.169Z 2026-01-04T15:32:37.418Z
9095241 9095241 20251227133853_XsP3d NZ0019 2025-12-30T15:06:25.764Z 2026-01-04T15:32:19.032Z
9095209 9095209 20251227133636_i2h5p NZ0019 2025-12-30T15:06:24.825Z 2025-12-30T15:06:24.825Z
9094982 9094982 20251227132137_WYIVP NZ0019 2025-12-30T15:06:00.962Z 2026-01-04T15:32:11.463Z

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