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

6,193 rows where station_code = "NZ001X" 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
9626929 9626929 20260408152535_cUNhf NZ001X 2026-04-09T12:09:33.771Z 2026-04-10T12:14:22.436Z
9626852 9626852 20260408151533_lxKYe NZ001X 2026-04-09T12:09:21.077Z 2026-04-10T12:14:22.426Z
9604090 9604090 20260402154002_GGwXV NZ001X 2026-04-03T12:05:53.700Z 2026-04-10T12:34:29.033Z
9604026 9604026 20260402150442_9TrtN NZ001X 2026-04-03T12:05:36.719Z 2026-04-10T12:34:17.888Z
9603985 9603985 20260402143827_ZYDlH NZ001X 2026-04-03T12:05:26.183Z 2026-04-10T12:34:16.984Z
9603929 9603929 20260402135100_VqRau NZ001X 2026-04-03T12:05:07.526Z 2026-04-10T12:34:15.817Z
9601814 9601814 20260401170800_ZK8aR NZ001X 2026-04-02T12:03:48.898Z 2026-04-10T12:35:47.954Z
9601802 9601802 20260401170552_cMeF5 NZ001X 2026-04-02T12:03:45.087Z 2026-04-10T12:35:47.653Z
9601740 9601740 20260401164654_KDtnG NZ001X 2026-04-02T12:03:33.855Z 2026-04-10T12:35:46.578Z
9601561 9601561 20260401154830_LvW3i NZ001X 2026-04-02T12:03:06.316Z 2026-04-10T12:35:41.196Z
9601330 9601330 20260401141806_rtnBD NZ001X 2026-04-02T12:02:26.426Z 2026-04-10T12:35:37.034Z
9601282 9601282 20260401134708_inAPQ NZ001X 2026-04-02T12:02:15.361Z 2026-04-10T12:35:36.138Z
9601209 9601209 20260401131310_bjdyT NZ001X 2026-04-02T12:02:00.361Z 2026-04-10T12:35:34.944Z
9601183 9601183 20260401124019_RZYGZ NZ001X 2026-04-02T12:01:53.415Z 2026-04-10T12:35:34.560Z
9601107 9601107 20260401115445_t2Izk NZ001X 2026-04-02T12:01:37.204Z 2026-04-10T12:35:33.262Z
9601054 9601054 20260401110521_gXhax NZ001X 2026-04-02T12:01:25.626Z 2026-04-10T12:35:32.317Z
9599812 9599812 20260331165907_bIJ3j NZ001X 2026-04-01T12:04:56.414Z 2026-04-09T12:47:33.137Z
9599556 9599556 20260331153805_lRgw5 NZ001X 2026-04-01T12:04:02.688Z 2026-04-09T12:46:57.980Z
9599533 9599533 20260331153218_GfhOM NZ001X 2026-04-01T12:03:58.475Z 2026-04-09T12:46:55.221Z
9596527 9596527 20260330130202_R35KY NZ001X 2026-03-31T12:04:27.724Z 2026-04-08T12:43:18.982Z
9596511 9596511 20260330125741_vaJ9T NZ001X 2026-03-31T12:04:26.439Z 2026-04-08T12:43:18.625Z
9593883 9593883 20260329162510_7KNRY NZ001X 2026-03-30T12:05:23.122Z 2026-04-07T12:27:38.811Z
9593869 9593869 20260329162103_5mdBr NZ001X 2026-03-30T12:05:20.665Z 2026-04-07T12:27:38.529Z
9593838 9593838 20260329160614_yZZOo NZ001X 2026-03-30T12:05:14.917Z 2026-04-07T12:27:37.481Z
9593759 9593759 20260329150120_7DWR8 NZ001X 2026-03-30T12:05:02.379Z 2026-04-07T12:27:35.083Z
9593734 9593734 20260329142957_UqYqr NZ001X 2026-03-30T12:04:56.745Z 2026-04-07T12:27:34.319Z
9591072 9591072 20260328130808_aLec4 NZ001X 2026-03-29T12:03:47.986Z 2026-04-06T12:38:58.118Z
9590299 9590299 20260328080708_TYW8x NZ001X 2026-03-29T12:02:23.615Z 2026-04-06T12:38:00.377Z
9587997 9587997 20260327171535_GyMti NZ001X 2026-03-28T12:06:53.224Z 2026-04-05T12:35:03.173Z
9587944 9587944 20260327165716_Wrp73 NZ001X 2026-03-28T12:06:46.455Z 2026-04-05T12:35:00.765Z
9587929 9587929 20260327165555_Lo3B3 NZ001X 2026-03-28T12:06:44.680Z 2026-04-05T12:34:59.925Z
9587827 9587827 20260327161842_KWqD0 NZ001X 2026-03-28T12:06:28.503Z 2026-04-05T12:34:45.498Z
9587806 9587806 20260327160842_AE7b5 NZ001X 2026-03-28T12:06:23.290Z 2026-04-05T12:34:44.342Z
9569059 9569059 20260322130013_lf6fa NZ001X 2026-03-24T12:19:36.183Z 2026-03-30T12:29:29.611Z
9569017 9569017 20260322122556_e7VZU NZ001X 2026-03-24T12:19:24.320Z 2026-03-30T12:29:17.649Z
9568775 9568775 20260322074610_ppnoB NZ001X 2026-03-24T12:17:50.855Z 2026-03-30T12:28:33.806Z
9563853 9563853 20260323092103_XzSuf NZ001X 2026-03-24T12:06:52.143Z 2026-03-31T12:26:58.019Z
9559489 9559489 20260321172852_96VWO NZ001X 2026-03-23T12:11:07.794Z 2026-03-29T12:20:39.936Z
9559437 9559437 20260321171842_NakXk NZ001X 2026-03-23T12:11:05.828Z 2026-03-29T12:20:39.213Z
9559277 9559277 20260321165249_vVp3U NZ001X 2026-03-23T12:11:00.601Z 2026-03-29T12:20:36.181Z
9559151 9559151 20260321164036_5tUMH NZ001X 2026-03-23T12:10:55.876Z 2026-03-29T12:20:34.613Z
9559021 9559021 20260321161955_gHq23 NZ001X 2026-03-23T12:10:51.543Z 2026-03-29T12:20:33.223Z
9558947 9558947 20260321160851_CHfDD NZ001X 2026-03-23T12:10:41.294Z 2026-03-29T12:20:32.231Z
9558931 9558931 20260321160528_kT8B8 NZ001X 2026-03-23T12:10:40.037Z 2026-03-29T12:20:31.836Z
9558831 9558831 20260321155114_YH30w NZ001X 2026-03-23T12:10:36.043Z 2026-03-29T12:20:30.585Z
9550734 9550734 20260320170740_oseVM NZ001X 2026-03-22T12:25:40.523Z 2026-03-28T12:36:35.536Z
9550661 9550661 20260320165807_M2iAa NZ001X 2026-03-22T12:25:35.133Z 2026-03-28T12:36:33.925Z
9550584 9550584 20260320165251_BkqIH NZ001X 2026-03-22T12:25:31.203Z 2026-03-28T12:36:32.854Z
9550299 9550299 20260320162855_Z40PF NZ001X 2026-03-22T12:25:07.423Z 2026-03-28T12:36:29.367Z
9550282 9550282 20260320162744_M7JgD NZ001X 2026-03-22T12:25:06.404Z 2026-03-28T12:36:29.151Z
9549785 9549785 20260320153941_Qr9ub NZ001X 2026-03-22T12:24:29.246Z 2026-03-28T12:36:21.449Z
9549761 9549761 20260320153656_k96PM NZ001X 2026-03-22T12:24:27.547Z 2026-03-28T12:36:20.405Z
9549660 9549660 20260320152518_a9U32 NZ001X 2026-03-22T12:24:21.598Z 2026-03-28T12:36:09.687Z
9549501 9549501 20260320150551_DyPVK NZ001X 2026-03-22T12:24:04.207Z 2026-03-28T12:36:04.973Z
9549459 9549459 20260320150029_9y9at NZ001X 2026-03-22T12:24:01.260Z 2026-03-28T12:36:04.394Z
9548742 9548742 20260321153131_66v23 NZ001X 2026-03-22T12:15:54.744Z 2026-03-29T12:20:28.570Z
9548488 9548488 20260321150915_UW2aV NZ001X 2026-03-22T12:15:29.196Z 2026-03-29T12:20:26.778Z
9548446 9548446 20260321150444_uADfl NZ001X 2026-03-22T12:15:25.669Z 2026-03-29T12:20:26.488Z
9548273 9548273 20260321144937_SXLd5 NZ001X 2026-03-22T12:15:09.089Z 2026-03-22T12:27:38.647Z
9548024 9548024 20260321142613_zyn6a NZ001X 2026-03-22T12:14:46.013Z 2026-03-29T12:20:23.426Z
9547598 9547598 20260321134448_fBCHu NZ001X 2026-03-22T12:13:57.618Z 2026-03-29T12:20:10.412Z
9547245 9547245 20260321130724_Y2TXJ NZ001X 2026-03-22T12:13:16.929Z 2026-03-29T12:20:08.121Z
9546794 9546794 20260321122839_7dzk3 NZ001X 2026-03-22T12:12:24.737Z 2026-03-29T12:20:04.355Z
9546674 9546674 20260321121750_JWmRj NZ001X 2026-03-22T12:12:12.890Z 2026-03-29T12:20:03.159Z
9544764 9544764 20260321091919_Bc9i2 NZ001X 2026-03-22T12:07:43.083Z 2026-03-29T12:19:33.711Z
9544492 9544492 20260321084542_FVFTw NZ001X 2026-03-22T12:07:00.488Z 2026-03-29T12:19:30.539Z
9544327 9544327 20260321081910_2kaWA NZ001X 2026-03-22T12:06:29.517Z 2026-03-29T12:19:28.439Z
9539096 9539096 20260320140957_d3Wyf NZ001X 2026-03-21T12:18:56.531Z 2026-03-21T12:30:06.756Z
9538645 9538645 20260320132830_pzFx9 NZ001X 2026-03-21T12:18:05.901Z 2026-03-28T12:35:51.195Z
9538618 9538618 20260320132451_6TYxZ NZ001X 2026-03-21T12:18:02.739Z 2026-03-21T12:30:06.530Z
9538323 9538323 20260320125202_t6qUE NZ001X 2026-03-21T12:17:30.478Z 2026-03-21T12:30:06.440Z
9538235 9538235 20260320124311_K3YIE NZ001X 2026-03-21T12:17:22.182Z 2026-03-21T12:30:06.414Z
9538001 9538001 20260320122319_v5WpD NZ001X 2026-03-21T12:16:56.237Z 2026-03-28T12:35:33.449Z
9537430 9537430 20260320113745_O7t6Q NZ001X 2026-03-21T12:15:46.389Z 2026-03-21T12:30:06.164Z
9537118 9537118 20260320110737_eW0yo NZ001X 2026-03-21T12:15:07.350Z 2026-03-28T12:35:21.812Z
9529233 9529233 20260318173013_RBjDC NZ001X 2026-03-20T12:22:58.996Z 2026-03-26T12:38:51.684Z
9528791 9528791 20260318164620_cxBdB NZ001X 2026-03-20T12:22:31.722Z 2026-03-26T12:38:38.165Z
9527800 9527800 20260318151559_auWnU NZ001X 2026-03-20T12:21:44.307Z 2026-03-26T12:38:31.390Z
9505054 9505054 20260317131511_UG1er NZ001X 2026-03-18T12:09:26.510Z 2026-03-25T12:42:26.085Z
9504927 9504927 20260317125001_7mWzn NZ001X 2026-03-18T12:09:12.324Z 2026-03-25T12:42:25.515Z
9504898 9504898 20260317124256_2lftq NZ001X 2026-03-18T12:09:08.915Z 2026-03-25T12:42:25.359Z
9503914 9503914 20260317101032_uClw6 NZ001X 2026-03-18T12:06:46.378Z 2026-03-25T12:42:18.667Z
9503439 9503439 20260317085335_onyTl NZ001X 2026-03-18T12:05:40.266Z 2026-03-25T12:42:16.006Z
9498026 9498026 20260316143216_GGuom NZ001X 2026-03-17T12:13:06.587Z 2026-03-24T12:41:24.869Z
9497403 9497403 20260316133013_2A1sF NZ001X 2026-03-17T12:11:55.799Z 2026-03-24T12:41:23.123Z
9496054 9496054 20260316101845_324mP NZ001X 2026-03-17T12:08:55.470Z 2026-03-24T12:41:18.008Z
9495829 9495829 20260316092701_EhMPC NZ001X 2026-03-17T12:08:22.545Z 2026-03-24T12:41:16.936Z
9491599 9491599 20260315171359_B2jvU NZ001X 2026-03-16T12:21:19.680Z 2026-03-23T12:22:39.994Z
9491431 9491431 20260315164645_2jQGd NZ001X 2026-03-16T12:20:57.607Z 2026-03-23T12:22:39.478Z
9491367 9491367 20260315164010_SJrhf NZ001X 2026-03-16T12:20:51.675Z 2026-03-23T12:22:39.305Z
9491265 9491265 20260315162749_uKHpk NZ001X 2026-03-16T12:20:41.200Z 2026-03-23T12:22:39.040Z
9491242 9491242 20260315162156_7X7X9 NZ001X 2026-03-16T12:20:37.696Z 2026-03-23T12:22:38.902Z
9491163 9491163 20260315161226_a69fm NZ001X 2026-03-16T12:20:25.602Z 2026-03-23T12:22:38.710Z
9490923 9490923 20260315154651_yjKBp NZ001X 2026-03-16T12:20:00.667Z 2026-03-23T12:22:38.096Z
9490651 9490651 20260315151732_mvG9w NZ001X 2026-03-16T12:19:26.700Z 2026-03-23T12:22:37.189Z
9490330 9490330 20260315144430_7SBil NZ001X 2026-03-16T12:18:53.859Z 2026-03-23T12:22:36.304Z
9490100 9490100 20260315141840_hsKYA NZ001X 2026-03-16T12:18:26.736Z 2026-03-23T12:22:35.598Z
9490086 9490086 20260315141619_s0MiE NZ001X 2026-03-16T12:18:25.575Z 2026-03-23T12:22:35.582Z
9488683 9488683 20260315120841_WpFW6 NZ001X 2026-03-16T12:15:38.967Z 2026-03-23T12:22:32.130Z
9481397 9481397 20260314150945_hFCmD NZ001X 2026-03-15T12:17:47.065Z 2026-03-22T12:42:44.456Z

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