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 = "NZ004N" 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
9626910 9626910 20260408152100_9oCQy NZ004N 2026-04-09T12:09:30.796Z 2026-04-09T12:09:30.796Z
9626690 9626690 20260408145105_MKEO4 NZ004N 2026-04-09T12:09:00.879Z 2026-04-09T12:09:00.879Z
9626024 9626024 20260408125330_Gs3Yz NZ004N 2026-04-09T12:07:20.904Z 2026-04-09T12:07:20.904Z
9626022 9626022 20260408125316_Ben9S NZ004N 2026-04-09T12:07:19.218Z 2026-04-09T12:07:19.218Z
9625865 9625865 20260408121539_C8UsI NZ004N 2026-04-09T12:07:01.361Z 2026-04-09T12:07:01.361Z
9625550 9625550 20260408111631_5XiAa NZ004N 2026-04-09T12:05:50.285Z 2026-04-09T12:05:50.285Z
9607298 9607298 20260404070954_5e2WL NZ004N 2026-04-05T12:01:28.781Z 2026-04-09T12:39:18.405Z
9606173 9606173 20260403155517_2FSlK NZ004N 2026-04-04T12:05:45.608Z 2026-04-09T12:42:10.206Z
9606171 9606171 20260403155336_KFai1 NZ004N 2026-04-04T12:05:45.037Z 2026-04-09T12:42:10.120Z
9606164 9606164 20260403154956_8vqFq NZ004N 2026-04-04T12:05:40.483Z 2026-04-09T12:42:09.993Z
9606134 9606134 20260403152605_o89xi NZ004N 2026-04-04T12:05:32.709Z 2026-04-09T12:42:08.888Z
9606123 9606123 20260403152136_Ir4RK NZ004N 2026-04-04T12:05:30.469Z 2026-04-09T12:42:08.767Z
9606118 9606118 20260403152135_48mpR NZ004N 2026-04-04T12:05:30.013Z 2026-04-09T12:42:08.726Z
9606115 9606115 20260403152101_Rtn6K NZ004N 2026-04-04T12:05:29.561Z 2026-04-09T12:42:08.614Z
9606102 9606102 20260403151552_Ofx3t NZ004N 2026-04-04T12:05:26.810Z 2026-04-09T12:42:08.204Z
9606096 9606096 20260403151119_Uxzge NZ004N 2026-04-04T12:05:25.417Z 2026-04-09T12:42:08.128Z
9606094 9606094 20260403151108_MB6Xj NZ004N 2026-04-04T12:05:24.801Z 2026-04-09T12:42:08.083Z
9606085 9606085 20260403150145_a8Dgb NZ004N 2026-04-04T12:05:21.656Z 2026-04-09T12:42:07.857Z
9606078 9606078 20260403145326_7HOsA NZ004N 2026-04-04T12:05:16.837Z 2026-04-09T12:42:07.680Z
9606070 9606070 20260403145006_vqDRm NZ004N 2026-04-04T12:05:14.706Z 2026-04-09T12:42:07.471Z
9606065 9606065 20260403144658_aiXWT NZ004N 2026-04-04T12:05:11.858Z 2026-04-09T12:42:07.404Z
9606008 9606008 20260403140630_SAxnG NZ004N 2026-04-04T12:04:57.083Z 2026-04-09T12:42:05.913Z
9606006 9606006 20260403140540_2RTPx NZ004N 2026-04-04T12:04:56.477Z 2026-04-09T12:42:05.876Z
9605996 9605996 20260403135344_OQTpo NZ004N 2026-04-04T12:04:53.309Z 2026-04-09T12:42:05.674Z
9605993 9605993 20260403135124_U51ao NZ004N 2026-04-04T12:04:52.512Z 2026-04-09T12:42:05.594Z
9605972 9605972 20260403133815_gQ7sC NZ004N 2026-04-04T12:04:43.991Z 2026-04-09T12:42:05.272Z
9605933 9605933 20260403131812_0aVMH NZ004N 2026-04-04T12:04:31.284Z 2026-04-09T12:42:04.184Z
9605918 9605918 20260403131014_or8fY NZ004N 2026-04-04T12:04:27.106Z 2026-04-09T12:42:03.787Z
9605915 9605915 20260403130954_5u0Ln NZ004N 2026-04-04T12:04:26.657Z 2026-04-09T12:42:03.746Z
9605877 9605877 20260403123506_T3ZT3 NZ004N 2026-04-04T12:04:17.034Z 2026-04-09T12:42:03.032Z
9605874 9605874 20260403122945_tws3K NZ004N 2026-04-04T12:04:16.420Z 2026-04-09T12:42:02.943Z
9605830 9605830 20260403121113_v6k9J NZ004N 2026-04-04T12:04:04.069Z 2026-04-09T12:41:58.886Z
9605824 9605824 20260403121054_rURBB NZ004N 2026-04-04T12:04:02.971Z 2026-04-09T12:41:54.930Z
9605203 9605203 20260403075117_we8NO NZ004N 2026-04-04T12:01:08.026Z 2026-04-09T12:41:16.700Z
9603421 9603421 20260402100926_PgQYO NZ004N 2026-04-03T12:03:01.807Z 2026-04-09T12:43:41.835Z
9603373 9603373 20260402094414_wwIrT NZ004N 2026-04-03T12:02:43.999Z 2026-04-09T12:43:30.623Z
9603100 9603100 20260402074929_aI9o3 NZ004N 2026-04-03T12:01:44.647Z 2026-04-09T12:43:20.790Z
9598018 9598018 20260330173210_rxHA2 NZ004N 2026-03-31T12:07:27.461Z 2026-04-08T12:44:23.450Z
9597995 9597995 20260330172754_Y6HR3 NZ004N 2026-03-31T12:07:24.803Z 2026-04-08T12:44:22.676Z
9597985 9597985 20260330172726_AJPKL NZ004N 2026-03-31T12:07:24.121Z 2026-04-08T12:44:22.513Z
9597946 9597946 20260330172207_0DZ9j NZ004N 2026-03-31T12:07:19.844Z 2026-04-08T12:44:21.405Z
9597932 9597932 20260330171712_2619Z NZ004N 2026-03-31T12:07:18.145Z 2026-04-08T12:44:20.958Z
9597901 9597901 20260330171413_0k6JV NZ004N 2026-03-31T12:07:14.367Z 2026-04-08T12:44:20.114Z
9597884 9597884 20260330171157_PqQfh NZ004N 2026-03-31T12:07:10.671Z 2026-04-08T12:44:19.760Z
9597837 9597837 20260330170428_4SK2K NZ004N 2026-03-31T12:07:05.055Z 2026-04-08T12:44:18.580Z
9597812 9597812 20260330170041_Yopax NZ004N 2026-03-31T12:07:02.569Z 2026-04-08T12:44:17.956Z
9597802 9597802 20260330170028_jyxGM NZ004N 2026-03-31T12:07:01.909Z 2026-04-08T12:44:17.792Z
9597615 9597615 20260330164454_1g1Nv NZ004N 2026-03-31T12:06:47.261Z 2026-04-08T12:44:05.332Z
9597611 9597611 20260330164206_RZd4u NZ004N 2026-03-31T12:06:46.606Z 2026-04-08T12:44:04.211Z
9597557 9597557 20260330163558_fB1xl NZ004N 2026-03-31T12:06:38.121Z 2026-04-08T12:43:49.695Z
9597516 9597516 20260330162745_Wnn3g NZ004N 2026-03-31T12:06:31.553Z 2026-04-08T12:43:44.717Z
9597438 9597438 20260330161735_Ic4Ly NZ004N 2026-03-31T12:06:23.367Z 2026-04-08T12:43:42.990Z
9597353 9597353 20260330161105_TZx4Z NZ004N 2026-03-31T12:06:13.669Z 2026-04-08T12:43:41.270Z
9597304 9597304 20260330155913_5tGyX NZ004N 2026-03-31T12:06:06.492Z 2026-04-08T12:43:38.077Z
9597294 9597294 20260330155830_4uDIo NZ004N 2026-03-31T12:06:05.684Z 2026-04-08T12:43:37.906Z
9597270 9597270 20260330155414_f0N2t NZ004N 2026-03-31T12:06:03.435Z 2026-04-08T12:43:37.457Z
9597250 9597250 20260330154846_wRr3t NZ004N 2026-03-31T12:06:00.908Z 2026-04-08T12:43:36.914Z
9597225 9597225 20260330154140_XTuVg NZ004N 2026-03-31T12:05:58.162Z 2026-04-08T12:43:36.238Z
9597195 9597195 20260330153401_I3UWK NZ004N 2026-03-31T12:05:52.995Z 2026-04-08T12:43:35.295Z
9597014 9597014 20260330145724_mB1eu NZ004N 2026-03-31T12:05:29.473Z 2026-04-08T12:43:30.462Z
9597002 9597002 20260330145451_U3NuP NZ004N 2026-03-31T12:05:27.984Z 2026-04-08T12:43:30.022Z
9596934 9596934 20260330143938_aaGhQ NZ004N 2026-03-31T12:05:19.264Z 2026-04-08T12:43:28.443Z
9596911 9596911 20260330143059_YCI0P NZ004N 2026-03-31T12:05:14.665Z 2026-04-08T12:43:27.695Z
9596871 9596871 20260330142011_dQg30 NZ004N 2026-03-31T12:05:08.198Z 2026-04-08T12:43:26.682Z
9596844 9596844 20260330141538_R3PMN NZ004N 2026-03-31T12:05:04.254Z 2026-04-08T12:43:25.869Z
9596834 9596834 20260330141109_yRR3d NZ004N 2026-03-31T12:05:02.973Z 2026-04-08T12:43:25.428Z
9596805 9596805 20260330140520_rzdoQ NZ004N 2026-03-31T12:05:00.039Z 2026-04-08T12:43:25.093Z
9596801 9596801 20260330140456_2RyVZ NZ004N 2026-03-31T12:04:59.598Z 2026-04-08T12:43:24.975Z
9596792 9596792 20260330140409_8sQto NZ004N 2026-03-31T12:04:58.190Z 2026-04-08T12:43:24.706Z
9596752 9596752 20260330135334_JBXpr NZ004N 2026-03-31T12:04:53.658Z 2026-04-08T12:43:23.728Z
9596729 9596729 20260330134848_AD2ao NZ004N 2026-03-31T12:04:51.476Z 2026-04-08T12:43:23.206Z
9596717 9596717 20260330134734_eIrhf NZ004N 2026-03-31T12:04:47.924Z 2026-04-08T12:43:22.942Z
9596710 9596710 20260330134618_wEKSQ NZ004N 2026-03-31T12:04:46.975Z 2026-04-08T12:43:22.862Z
9596630 9596630 20260330132815_qghge NZ004N 2026-03-31T12:04:37.731Z 2026-04-08T12:43:21.192Z
9596448 9596448 20260330123831_L1ULH NZ004N 2026-03-31T12:04:16.917Z 2026-04-08T12:43:12.004Z
9595933 9595933 20260330101211_AdT9b NZ004N 2026-03-31T12:02:54.275Z 2026-04-08T12:42:36.638Z
9595798 9595798 20260330084413_hSOLF NZ004N 2026-03-31T12:02:31.716Z 2026-04-08T12:42:32.560Z
9591567 9591567 20260328171154_wZEpk NZ004N 2026-03-29T12:04:37.300Z 2026-04-06T12:39:23.216Z
9591555 9591555 20260328170802_7kxcb NZ004N 2026-03-29T12:04:36.091Z 2026-04-06T12:39:22.645Z
9591512 9591512 20260328165837_bkDhq NZ004N 2026-03-29T12:04:31.472Z 2026-04-06T12:39:19.054Z
9591490 9591490 20260328165227_nYaVd NZ004N 2026-03-29T12:04:29.981Z 2026-04-06T12:39:17.986Z
9591339 9591339 20260328154456_sgSge NZ004N 2026-03-29T12:04:16.539Z 2026-04-06T12:39:11.485Z
9591302 9591302 20260328153117_rVJZq NZ004N 2026-03-29T12:04:11.222Z 2026-04-06T12:39:09.923Z
9591298 9591298 20260328153012_v4czy NZ004N 2026-03-29T12:04:11.033Z 2026-04-06T12:39:09.750Z
9591286 9591286 20260328151140_ssomT NZ004N 2026-03-29T12:04:09.596Z 2026-04-06T12:39:09.019Z
9591263 9591263 20260328150407_1HdxX NZ004N 2026-03-29T12:04:07.567Z 2026-04-06T12:39:08.172Z
9591260 9591260 20260328150307_G7iRQ NZ004N 2026-03-29T12:04:07.196Z 2026-04-06T12:39:08.057Z
9591140 9591140 20260328134552_ifcqN NZ004N 2026-03-29T12:03:54.673Z 2026-04-06T12:39:02.650Z
9590980 9590980 20260328121044_NuBhc NZ004N 2026-03-29T12:03:34.794Z 2026-04-06T12:38:44.954Z
9590726 9590726 20260328105501_Px9as NZ004N 2026-03-29T12:03:11.143Z 2026-04-06T12:38:31.841Z
9590701 9590701 20260328104836_joA3r NZ004N 2026-03-29T12:03:09.182Z 2026-04-06T12:38:30.739Z
9590672 9590672 20260328104003_WcTAm NZ004N 2026-03-29T12:03:06.381Z 2026-04-06T12:38:30.016Z
9590311 9590311 20260328080804_DGEVr NZ004N 2026-03-29T12:02:24.326Z 2026-04-06T12:38:00.807Z
9574665 9574665 20260323113411_BHjzU NZ004N 2026-03-25T12:14:34.306Z 2026-03-31T12:27:20.401Z
9566318 9566318 20260323132433_UI88L NZ004N 2026-03-24T12:11:40.039Z 2026-03-31T12:27:48.707Z
9566174 9566174 20260323131116_3aUV0 NZ004N 2026-03-24T12:11:25.292Z 2026-03-31T12:27:46.845Z
9564935 9564935 20260323112827_O2OOE NZ004N 2026-03-24T12:09:04.700Z 2026-03-31T12:27:19.517Z
9564729 9564729 20260323110406_QiIYT NZ004N 2026-03-24T12:08:39.585Z 2026-03-31T12:27:14.326Z
9564722 9564722 20260323110406_4tYnQ NZ004N 2026-03-24T12:08:39.186Z 2026-03-31T12:27:14.295Z
9564008 9564008 20260323094844_x5glg NZ004N 2026-03-24T12:07:11.248Z 2026-03-31T12:27:00.772Z

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