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 = "NZ0046" 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
9270705 9270705 20260128163659_7RshP NZ0046 2026-01-29T14:13:24.624Z 2026-01-29T14:13:24.624Z
9270633 9270633 20260128161510_ugdp3 NZ0046 2026-01-29T14:13:04.213Z 2026-01-29T14:13:04.213Z
9270579 9270579 20260128160704_sgj2r NZ0046 2026-01-29T14:12:50.919Z 2026-01-29T14:12:50.919Z
9270491 9270491 20260128155615_Y1lpt NZ0046 2026-01-29T14:12:25.472Z 2026-01-29T14:12:25.472Z
9270487 9270487 20260128155611_33by3 NZ0046 2026-01-29T14:12:24.948Z 2026-01-29T14:12:24.948Z
9270291 9270291 20260128152803_CSDOt NZ0046 2026-01-29T14:11:39.245Z 2026-01-29T14:11:39.245Z
9270264 9270264 20260128152307_khMC5 NZ0046 2026-01-29T14:11:28.331Z 2026-01-29T14:11:28.331Z
9270174 9270174 20260128150547_zw4vW NZ0046 2026-01-29T14:11:10.922Z 2026-01-29T14:11:10.922Z
9270129 9270129 20260128145833_0YH1e NZ0046 2026-01-29T14:10:57.595Z 2026-01-29T14:10:57.595Z
9270108 9270108 20260128145723_1roOU NZ0046 2026-01-29T14:10:54.635Z 2026-01-29T14:10:54.635Z
9269939 9269939 20260128143459_XBPy6 NZ0046 2026-01-29T14:10:17.201Z 2026-01-29T14:10:17.201Z
9269898 9269898 20260128142959_IgGct NZ0046 2026-01-29T14:10:08.837Z 2026-01-29T14:10:08.837Z
9269765 9269765 20260128141048_YjVv7 NZ0046 2026-01-29T14:09:33.505Z 2026-01-29T14:09:33.505Z
9269476 9269476 20260128132530_Ro4Iw NZ0046 2026-01-29T14:08:08.825Z 2026-01-29T14:08:08.825Z
9269285 9269285 20260128125612_YnisA NZ0046 2026-01-29T14:07:21.598Z 2026-01-29T14:07:21.598Z
9269260 9269260 20260128125218_xC0Tc NZ0046 2026-01-29T14:07:10.426Z 2026-01-29T14:07:10.426Z
9269252 9269252 20260128125025_Qtvvf NZ0046 2026-01-29T14:07:06.260Z 2026-01-29T14:07:06.260Z
9269108 9269108 20260128122947_Kzfqx NZ0046 2026-01-29T14:06:32.668Z 2026-01-29T14:06:32.668Z
9269063 9269063 20260128121514_96PRD NZ0046 2026-01-29T14:06:13.568Z 2026-01-29T14:06:13.568Z
9268873 9268873 20260128113556_DrzzI NZ0046 2026-01-29T14:05:15.898Z 2026-01-29T14:05:15.898Z
9268605 9268605 20260128105159_3Hu5B NZ0046 2026-01-29T14:03:57.010Z 2026-01-29T14:03:57.010Z
9268536 9268536 20260128104322_bzc7L NZ0046 2026-01-29T14:03:35.169Z 2026-01-29T14:03:35.169Z
9264918 9264918 20260127133528_YuuH2 NZ0046 2026-01-28T14:08:15.921Z 2026-01-29T14:30:24.392Z
9261781 9261781 20260126131859_otUKo NZ0046 2026-01-27T14:05:37.618Z 2026-01-29T14:32:57.658Z
9257831 9257831 20260125160513_jwV1D NZ0046 2026-01-26T14:07:58.152Z 2026-01-29T14:37:43.710Z
9257451 9257451 20260125134201_KsU3a NZ0046 2026-01-26T14:05:41.158Z 2026-01-29T14:37:13.049Z
9256669 9256669 20260125095712_Slq2r NZ0046 2026-01-26T14:01:16.722Z 2026-01-29T14:36:15.363Z
9256621 9256621 20260125093110_ZLqbv NZ0046 2026-01-26T14:00:58.618Z 2026-01-29T14:36:12.248Z
9253901 9253901 20260124153839_7NYWs NZ0046 2026-01-25T14:04:54.625Z 2026-01-29T14:41:46.674Z
9253704 9253704 20260124135705_xdFU2 NZ0046 2026-01-25T14:04:02.321Z 2026-01-29T14:41:18.458Z
9253643 9253643 20260124131825_tUFLj NZ0046 2026-01-25T14:03:42.766Z 2026-01-29T14:41:12.265Z
9253537 9253537 20260124123716_4XZSc NZ0046 2026-01-25T14:03:14.089Z 2026-01-29T14:40:56.719Z
9253519 9253519 20260124122712_RlivI NZ0046 2026-01-25T14:03:07.142Z 2026-01-29T14:40:55.122Z
9253493 9253493 20260124121220_ZeyfU NZ0046 2026-01-25T14:02:59.722Z 2026-01-29T14:40:53.291Z
9253424 9253424 20260124114158_3jHEp NZ0046 2026-01-25T14:02:39.084Z 2026-01-29T14:40:48.712Z
9253292 9253292 20260124104730_k2kKo NZ0046 2026-01-25T14:01:51.479Z 2026-01-29T14:40:33.160Z
9253235 9253235 20260124102046_4rY2H NZ0046 2026-01-25T14:01:32.879Z 2026-01-29T14:40:29.220Z
9253230 9253230 20260124102037_3jvUu NZ0046 2026-01-25T14:01:31.882Z 2026-01-29T14:40:29.084Z
9253153 9253153 20260124094426_WGwd2 NZ0046 2026-01-25T14:00:57.540Z 2026-01-29T14:40:21.442Z
9253133 9253133 20260124093346_xX2vB NZ0046 2026-01-25T14:00:51.589Z 2026-01-29T14:40:19.891Z
9250437 9250437 20260123145906_WXNcb NZ0046 2026-01-24T14:02:56.822Z 2026-01-29T14:45:34.676Z
9250412 9250412 20260123142905_4moNe NZ0046 2026-01-24T14:02:49.062Z 2026-01-29T14:45:32.008Z
9249798 9249798 20260122085413_i9s23 NZ0046 2026-01-23T14:16:15.676Z 2026-01-29T14:58:58.154Z
9249793 9249793 20260122085040_3rMMM NZ0046 2026-01-23T14:16:14.896Z 2026-01-29T14:58:56.457Z
9245734 9245734 20260122140506_hDyTR NZ0046 2026-01-23T14:03:11.767Z 2026-01-29T14:50:04.295Z
9245686 9245686 20260122134505_ZXHz9 NZ0046 2026-01-23T14:02:59.450Z 2026-01-29T14:49:57.311Z
9245580 9245580 20260122131123_9EIhZ NZ0046 2026-01-23T14:02:27.253Z 2026-01-29T14:49:48.797Z
9245388 9245388 20260122120824_qfIgK NZ0046 2026-01-23T14:01:48.369Z 2026-01-29T14:49:29.953Z
9245297 9245297 20260122114207_FzabE NZ0046 2026-01-23T14:01:22.565Z 2026-01-29T14:49:22.239Z
9245277 9245277 20260122113407_gO5Dd NZ0046 2026-01-23T14:01:17.987Z 2026-01-29T14:49:20.478Z
9245251 9245251 20260122112525_PFHgA NZ0046 2026-01-23T14:01:12.369Z 2026-01-29T14:49:17.950Z
9245247 9245247 20260122112511_TVptF NZ0046 2026-01-23T14:01:11.959Z 2026-01-29T14:49:17.737Z
9245155 9245155 20260122103949_xfbgS NZ0046 2026-01-23T14:00:48.817Z 2026-01-29T14:49:05.417Z
9245104 9245104 20260122101225_OqOLz NZ0046 2026-01-23T14:00:34.272Z 2026-01-29T14:49:01.697Z
9245076 9245076 20260122095640_e34TD NZ0046 2026-01-23T14:00:25.137Z 2026-01-29T14:48:56.191Z
9245051 9245051 20260122093759_moECk NZ0046 2026-01-23T14:00:18.006Z 2026-01-29T14:48:53.825Z
9245048 9245048 20260122093758_UxMkR NZ0046 2026-01-23T14:00:17.534Z 2026-01-29T14:48:53.602Z
9215629 9215629 20260116103738_oX829 NZ0046 2026-01-17T14:26:19.447Z 2026-01-24T15:15:05.660Z
9215553 9215553 20260116102959_2MY23 NZ0046 2026-01-17T14:26:06.762Z 2026-01-24T15:15:03.033Z
9215536 9215536 20260116102602_552Pc NZ0046 2026-01-17T14:26:03.565Z 2026-01-24T15:15:02.220Z
9205600 9205600 20260114121650_td0Id NZ0046 2026-01-15T14:31:38.831Z 2026-01-22T15:11:15.678Z
9193162 9193162 20260112134320_QfmTl NZ0046 2026-01-13T14:30:19.378Z 2026-01-20T15:27:01.706Z
9193154 9193154 20260112134207_sBLwp NZ0046 2026-01-13T14:30:17.659Z 2026-01-20T15:27:01.294Z
9192501 9192501 20260112123905_hfO9u NZ0046 2026-01-13T14:28:29.911Z 2026-01-20T15:26:23.567Z
9192401 9192401 20260112123129_w5PJA NZ0046 2026-01-13T14:28:15.694Z 2026-01-20T15:26:21.065Z
9192043 9192043 20260112120316_jFjyy NZ0046 2026-01-13T14:27:16.232Z 2026-01-20T15:25:57.570Z
9192015 9192015 20260112120004_MUi5q NZ0046 2026-01-13T14:27:11.672Z 2026-01-20T15:25:56.553Z
9191834 9191834 20260112114627_B1OMV NZ0046 2026-01-13T14:26:38.575Z 2026-01-20T15:25:48.117Z
9191790 9191790 20260112114534_kVmun NZ0046 2026-01-13T14:26:24.171Z 2026-01-20T15:25:47.041Z
9191511 9191511 20260112111510_02Ihn NZ0046 2026-01-13T14:25:38.557Z 2026-01-20T15:25:36.789Z
9191216 9191216 20260112104550_KgSe0 NZ0046 2026-01-13T14:24:44.655Z 2026-01-20T15:25:14.682Z
9190677 9190677 20260112093801_Dkqo2 NZ0046 2026-01-13T14:23:02.407Z 2026-01-20T15:24:42.970Z
9190497 9190497 20260112091301_XoYYl NZ0046 2026-01-13T14:22:26.409Z 2026-01-20T15:24:35.902Z
9190472 9190472 20260112091051_3lWKX NZ0046 2026-01-13T14:22:22.182Z 2026-01-20T15:24:34.620Z
9187220 9187220 20260111154359_GnPON NZ0046 2026-01-13T14:06:14.438Z 2026-01-20T15:20:09.886Z
9187215 9187215 20260111154146_TclhB NZ0046 2026-01-13T14:06:10.688Z 2026-01-20T15:20:09.683Z
9187208 9187208 20260111153953_xB37L NZ0046 2026-01-13T14:06:09.173Z 2026-01-20T15:20:09.342Z
9187053 9187053 20260111145350_zTk07 NZ0046 2026-01-13T14:05:08.950Z 2026-01-20T15:19:55.674Z
9186991 9186991 20260111143807_viatU NZ0046 2026-01-13T14:04:47.840Z 2026-01-20T15:19:41.548Z
9186810 9186810 20260112154335_mcAwN NZ0046 2026-01-13T14:03:35.924Z 2026-01-21T15:03:00.678Z
9186466 9186466 20260112144107_wEZjx NZ0046 2026-01-13T14:02:07.662Z 2026-01-21T15:02:34.932Z
9186406 9186406 20260112143139_As91s NZ0046 2026-01-13T14:01:48.331Z 2026-01-21T15:02:28.314Z
9186316 9186316 20260112141848_7lseZ NZ0046 2026-01-13T14:01:23.523Z 2026-01-21T15:02:20.755Z
9186176 9186176 20260112135624_u7Q52 NZ0046 2026-01-13T14:00:40.979Z 2026-01-21T15:02:12.819Z
9185905 9185905 20260111135115_cLMOF NZ0046 2026-01-12T14:26:15.733Z 2026-01-19T15:22:04.441Z
9185892 9185892 20260111134457_qYBvg NZ0046 2026-01-12T14:26:14.085Z 2026-01-19T15:22:02.240Z
9185874 9185874 20260111133253_KjZ72 NZ0046 2026-01-12T14:26:10.944Z 2026-01-19T15:21:59.485Z
9185865 9185865 20260111133108_gVBuu NZ0046 2026-01-12T14:26:09.747Z 2026-01-19T15:21:58.878Z
9185841 9185841 20260111132450_o9RNl NZ0046 2026-01-12T14:26:06.827Z 2026-01-19T15:21:56.676Z
9185783 9185783 20260111130848_YbmQG NZ0046 2026-01-12T14:25:51.948Z 2026-01-19T15:21:50.258Z
9185723 9185723 20260111125349_Z5ssp NZ0046 2026-01-12T14:25:45.281Z 2026-01-19T15:21:44.355Z
9185701 9185701 20260111124004_aPnDJ NZ0046 2026-01-12T14:25:42.555Z 2026-01-19T15:21:34.598Z
9185665 9185665 20260111122611_swu26 NZ0046 2026-01-12T14:25:25.908Z 2026-01-19T15:21:17.469Z
9185619 9185619 20260111121455_0pubH NZ0046 2026-01-12T14:25:18.588Z 2026-01-19T15:21:11.353Z
9185586 9185586 20260111120820_kjGY2 NZ0046 2026-01-12T14:25:14.695Z 2026-01-19T15:21:08.188Z
9185536 9185536 20260111114224_2depI NZ0046 2026-01-12T14:25:08.862Z 2026-01-19T15:21:00.970Z
9184033 9184033 20260111103806_OzcDX NZ0046 2026-01-12T14:19:32.255Z 2026-01-19T15:20:20.221Z
9183974 9183974 20260111103219_IHUBR NZ0046 2026-01-12T14:19:19.947Z 2026-01-19T15:20:18.445Z
9183764 9183764 20260111101125_dcKkl NZ0046 2026-01-12T14:18:45.071Z 2026-01-19T15:20:10.971Z
9183561 9183561 20260111094436_qA2q1 NZ0046 2026-01-12T14:18:10.589Z 2026-01-19T15:19:45.962Z

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