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

8,956 rows where station_code = "NZ003T" 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
9627442 9627442 20260408173749_1WW72 NZ003T 2026-04-09T12:11:04.104Z 2026-04-10T12:14:22.544Z
9627194 9627194 20260408164047_l2v5C NZ003T 2026-04-09T12:10:17.074Z 2026-04-10T12:14:22.500Z
9627184 9627184 20260408163747_QCnGF NZ003T 2026-04-09T12:10:15.058Z 2026-04-10T12:14:22.496Z
9627081 9627081 20260408161125_2eJL1 NZ003T 2026-04-09T12:09:54.452Z 2026-04-10T12:14:22.477Z
9627017 9627017 20260408155457_7lI6v NZ003T 2026-04-09T12:09:45.667Z 2026-04-10T12:14:22.459Z
9626981 9626981 20260408154350_LnIPr NZ003T 2026-04-09T12:09:40.902Z 2026-04-10T12:14:22.451Z
9626943 9626943 20260408152754_SvRtR NZ003T 2026-04-09T12:09:35.329Z 2026-04-10T12:14:22.439Z
9626928 9626928 20260408152508_6ttBl NZ003T 2026-04-09T12:09:33.166Z 2026-04-10T12:14:22.436Z
9626762 9626762 20260408150100_LANIy NZ003T 2026-04-09T12:09:08.606Z 2026-04-10T12:14:22.409Z
9626631 9626631 20260408142914_sz32p NZ003T 2026-04-09T12:08:48.900Z 2026-04-10T12:14:22.385Z
9626408 9626408 20260408135925_4sYRA NZ003T 2026-04-09T12:08:17.304Z 2026-04-10T12:14:22.349Z
9626104 9626104 20260408131125_z2XNH NZ003T 2026-04-09T12:07:35.271Z 2026-04-10T12:14:22.296Z
9626039 9626039 20260408125655_MCjdI NZ003T 2026-04-09T12:07:22.846Z 2026-04-10T12:14:22.285Z
9626008 9626008 20260408125115_hqAYh NZ003T 2026-04-09T12:07:17.646Z 2026-04-10T12:14:22.280Z
9625999 9625999 20260408124745_mWx6f NZ003T 2026-04-09T12:07:16.829Z 2026-04-10T12:14:22.278Z
9625978 9625978 20260408124321_QApbb NZ003T 2026-04-09T12:07:13.582Z 2026-04-10T12:14:22.274Z
9625898 9625898 20260408122303_BTFwd NZ003T 2026-04-09T12:07:04.723Z 2026-04-10T12:14:22.261Z
9625872 9625872 20260408121946_hJNuM NZ003T 2026-04-09T12:07:01.869Z 2026-04-10T12:14:22.257Z
9625827 9625827 20260408120030_gTz1b NZ003T 2026-04-09T12:06:51.225Z 2026-04-10T12:14:22.249Z
9625803 9625803 20260408115527_0zcu3 NZ003T 2026-04-09T12:06:46.909Z 2026-04-10T12:14:22.245Z
9625530 9625530 20260408111047_KZgh7 NZ003T 2026-04-09T12:05:47.190Z 2026-04-10T12:14:22.197Z
9625444 9625444 20260408105328_svwyu NZ003T 2026-04-09T12:05:33.806Z 2026-04-10T12:14:21.926Z
9625138 9625138 20260408094454_b50zg NZ003T 2026-04-09T12:04:28.974Z 2026-04-10T12:14:21.864Z
9625130 9625130 20260408094336_QlhBy NZ003T 2026-04-09T12:04:27.380Z 2026-04-10T12:14:21.862Z
9624968 9624968 20260408090456_2nllY NZ003T 2026-04-09T12:03:36.449Z 2026-04-10T12:14:21.823Z
9610249 9610249 20260405152137_ars0x NZ003T 2026-04-06T12:06:41.350Z 2026-04-10T12:27:01.990Z
9609833 9609833 20260405102546_DRgyN NZ003T 2026-04-06T12:04:11.596Z 2026-04-10T12:26:25.860Z
9609536 9609536 20260405075348_y6SXj NZ003T 2026-04-06T12:02:24.904Z 2026-04-10T12:26:17.685Z
9606286 9606286 20260403165102_V3Eh0 NZ003T 2026-04-04T12:06:15.348Z 2026-04-10T12:32:26.640Z
9606028 9606028 20260403142641_L0L9x NZ003T 2026-04-04T12:05:01.010Z 2026-04-10T12:32:19.315Z
9605692 9605692 20260403112833_pCYj6 NZ003T 2026-04-04T12:03:29.304Z 2026-04-10T12:31:43.775Z
9605688 9605688 20260403112817_cPz8z NZ003T 2026-04-04T12:03:28.289Z 2026-04-10T12:31:43.531Z
9605650 9605650 20260403111833_IEtqM NZ003T 2026-04-04T12:03:19.006Z 2026-04-10T12:31:41.997Z
9605494 9605494 20260403101916_YmE03 NZ003T 2026-04-04T12:02:33.896Z 2026-04-10T12:31:37.044Z
9604298 9604298 20260402170241_Dq6wo NZ003T 2026-04-03T12:06:47.266Z 2026-04-10T12:34:47.287Z
9604235 9604235 20260402164317_WrG33 NZ003T 2026-04-03T12:06:27.862Z 2026-04-10T12:34:45.706Z
9604143 9604143 20260402161006_j3B9D NZ003T 2026-04-03T12:06:10.985Z 2026-04-10T12:34:43.344Z
9604140 9604140 20260402160837_ETfoB NZ003T 2026-04-03T12:06:08.921Z 2026-04-10T12:34:43.278Z
9604112 9604112 20260402155223_FXTs9 NZ003T 2026-04-03T12:05:57.665Z 2026-04-10T12:34:42.498Z
9603834 9603834 20260402130110_w5wv7 NZ003T 2026-04-03T12:04:49.866Z 2026-04-10T12:34:10.659Z
9603801 9603801 20260402124416_Z5NIY NZ003T 2026-04-03T12:04:43.037Z 2026-04-10T12:34:10.009Z
9603697 9603697 20260402115259_zVH3v NZ003T 2026-04-03T12:04:12.844Z 2026-04-10T12:34:07.537Z
9603671 9603671 20260402114421_iJgvQ NZ003T 2026-04-03T12:04:02.039Z 2026-04-10T12:34:07.052Z
9603578 9603578 20260402110909_22Tei NZ003T 2026-04-03T12:03:42.379Z 2026-04-10T12:34:04.714Z
9603481 9603481 20260402103232_W2ff8 NZ003T 2026-04-03T12:03:11.884Z 2026-04-10T12:34:02.785Z
9603341 9603341 20260402093656_fSMby NZ003T 2026-04-03T12:02:39.490Z 2026-04-10T12:34:00.264Z
9603044 9603044 20260402071210_BaPS1 NZ003T 2026-04-03T12:01:33.243Z 2026-04-10T12:33:40.009Z
9601635 9601635 20260401161532_1zlWT NZ003T 2026-04-02T12:03:19.517Z 2026-04-10T12:35:42.548Z
9601588 9601588 20260401155815_U2sW2 NZ003T 2026-04-02T12:03:12.559Z 2026-04-10T12:35:41.801Z
9601550 9601550 20260401154414_3SMh2 NZ003T 2026-04-02T12:03:04.407Z 2026-04-10T12:35:41.020Z
9601450 9601450 20260401152159_LZFmx NZ003T 2026-04-02T12:02:49.421Z 2026-04-10T12:35:39.250Z
9601298 9601298 20260401135722_2qJOh NZ003T 2026-04-02T12:02:20.041Z 2026-04-10T12:35:36.482Z
9601049 9601049 20260401110349_6My1r NZ003T 2026-04-02T12:01:24.388Z 2026-04-10T12:35:32.201Z
9600955 9600955 20260401093832_l5VNH NZ003T 2026-04-02T12:01:06.368Z 2026-04-10T12:35:30.461Z
9599126 9599126 20260331115541_Vx38h NZ003T 2026-04-01T12:02:27.896Z 2026-04-09T12:46:42.063Z
9598977 9598977 20260331101057_2IY00 NZ003T 2026-04-01T12:01:52.376Z 2026-04-09T12:46:39.261Z
9598874 9598874 20260331081912_SjNVS NZ003T 2026-04-01T12:01:22.818Z 2026-04-09T12:46:37.274Z
9598606 9598606 20260327133712_W288S NZ003T 2026-03-31T12:15:59.963Z 2026-04-05T12:34:29.654Z
9598008 9598008 20260330172924_j3K2t NZ003T 2026-03-31T12:07:26.322Z 2026-04-08T12:44:22.967Z
9597724 9597724 20260330165223_tzsQU NZ003T 2026-03-31T12:06:55.454Z 2026-04-08T12:44:16.088Z
9597713 9597713 20260330165220_jX7pp NZ003T 2026-03-31T12:06:54.879Z 2026-04-08T12:44:15.953Z
9597704 9597704 20260330165055_BL53F NZ003T 2026-03-31T12:06:53.779Z 2026-04-08T12:44:15.661Z
9597694 9597694 20260330165016_wPxrN NZ003T 2026-03-31T12:06:53.027Z 2026-04-08T12:44:15.527Z
9597599 9597599 20260330164128_qf9P9 NZ003T 2026-03-31T12:06:44.908Z 2026-04-08T12:43:56.718Z
9597569 9597569 20260330163620_oL4gl NZ003T 2026-03-31T12:06:38.882Z 2026-04-08T12:43:50.144Z
9597454 9597454 20260330162155_Eru1d NZ003T 2026-03-31T12:06:25.734Z 2026-04-08T12:43:43.480Z
9597347 9597347 20260330160830_sccsM NZ003T 2026-03-31T12:06:12.798Z 2026-04-08T12:43:40.959Z
9597234 9597234 20260330154509_4f3jB NZ003T 2026-03-31T12:05:59.787Z 2026-04-08T12:43:36.678Z
9596894 9596894 20260330142449_N3zEo NZ003T 2026-03-31T12:05:10.802Z 2026-04-08T12:43:27.169Z
9596817 9596817 20260330140709_n374D NZ003T 2026-03-31T12:05:01.296Z 2026-04-08T12:43:25.226Z
9596126 9596126 20260330111825_YPDnh NZ003T 2026-03-31T12:03:32.649Z 2026-04-08T12:42:42.020Z
9595900 9595900 20260330095706_MdsUe NZ003T 2026-03-31T12:02:46.787Z 2026-04-08T12:42:35.514Z
9574116 9574116 20260324152008_g1FX9 NZ003T 2026-03-25T12:09:41.918Z 2026-04-02T12:36:39.048Z
9573911 9573911 20260324142214_08lKg NZ003T 2026-03-25T12:09:09.838Z 2026-04-02T12:36:31.285Z
9568854 9568854 20260322101825_sZH3i NZ003T 2026-03-24T12:18:33.293Z 2026-03-30T12:28:59.138Z
9563567 9563567 20260323084250_dtfBD NZ003T 2026-03-24T12:06:15.758Z 2026-03-31T12:26:46.924Z
9563528 9563528 20260323082920_o0HCG NZ003T 2026-03-24T12:06:10.537Z 2026-03-31T12:26:46.236Z
9563376 9563376 20260323080641_aNw9f NZ003T 2026-03-24T12:05:53.074Z 2026-03-31T12:26:41.982Z
9559477 9559477 20260321172518_ZFDkq NZ003T 2026-03-23T12:11:07.210Z 2026-03-29T12:20:39.684Z
9559467 9559467 20260321172220_2Y4DA NZ003T 2026-03-23T12:11:06.934Z 2026-03-29T12:20:39.605Z
9559450 9559450 20260321172008_S5U63 NZ003T 2026-03-23T12:11:06.249Z 2026-03-29T12:20:39.355Z
9559368 9559368 20260321170158_VL89D NZ003T 2026-03-23T12:11:03.196Z 2026-03-29T12:20:38.206Z
9559313 9559313 20260321165622_b4EOZ NZ003T 2026-03-23T12:11:01.537Z 2026-03-29T12:20:36.469Z
9559284 9559284 20260321165250_zXj2d NZ003T 2026-03-23T12:11:00.754Z 2026-03-29T12:20:36.233Z
9559194 9559194 20260321164530_UQgS9 NZ003T 2026-03-23T12:10:57.355Z 2026-03-29T12:20:35.159Z
9559074 9559074 20260321162600_fZAY3 NZ003T 2026-03-23T12:10:53.030Z 2026-03-29T12:20:33.635Z
9559047 9559047 20260321162153_nTv0v NZ003T 2026-03-23T12:10:52.300Z 2026-03-29T12:20:33.466Z
9558408 9558408 20260322163325_Ylhth NZ003T 2026-03-23T12:06:42.205Z 2026-03-30T12:30:12.681Z
9558182 9558182 20260322160221_3dibS NZ003T 2026-03-23T12:06:28.523Z 2026-03-30T12:30:06.822Z
9558100 9558100 20260322154521_2U9uP NZ003T 2026-03-23T12:06:23.785Z 2026-03-30T12:30:04.443Z
9558067 9558067 20260322153919_l1gZK NZ003T 2026-03-23T12:06:21.959Z 2026-03-30T12:30:03.095Z
9557959 9557959 20260322152359_cdcSW NZ003T 2026-03-23T12:06:17.383Z 2026-03-30T12:29:53.050Z
9557947 9557947 20260322152016_r6DiE NZ003T 2026-03-23T12:06:16.995Z 2026-03-30T12:29:52.505Z
9557923 9557923 20260322151625_rf5or NZ003T 2026-03-23T12:06:15.903Z 2026-03-30T12:29:51.783Z
9557787 9557787 20260322145535_Io21W NZ003T 2026-03-23T12:06:10.012Z 2026-03-30T12:29:47.714Z
9557521 9557521 20260322141925_0dBMT NZ003T 2026-03-23T12:05:53.835Z 2026-03-30T12:29:40.394Z
9557244 9557244 20260322132101_XliZo NZ003T 2026-03-23T12:05:42.913Z 2026-03-30T12:29:32.537Z
9557215 9557215 20260322131641_ECPct NZ003T 2026-03-23T12:05:41.720Z 2026-03-30T12:29:31.849Z
9557060 9557060 20260322124415_FFkVr NZ003T 2026-03-23T12:05:33.443Z 2026-03-30T12:29:20.115Z
9556988 9556988 20260322122936_33eXG NZ003T 2026-03-23T12:05:26.621Z 2026-03-30T12:29:18.165Z

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