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 = "NZ0042" 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
9627421 9627421 20260408173310_GypmV NZ0042 2026-04-09T12:10:54.327Z 2026-04-09T12:10:54.327Z
9627404 9627404 20260408172451_nbWx4 NZ0042 2026-04-09T12:10:51.034Z 2026-04-09T12:10:51.034Z
9627107 9627107 20260408161828_Y2NOZ NZ0042 2026-04-09T12:10:04.286Z 2026-04-09T12:10:04.286Z
9627035 9627035 20260408155724_6miAC NZ0042 2026-04-09T12:09:47.595Z 2026-04-09T12:09:47.595Z
9626689 9626689 20260408145105_MKEO4 NZ0042 2026-04-09T12:09:00.879Z 2026-04-09T12:09:00.879Z
9626570 9626570 20260408141748_2jcyo NZ0042 2026-04-09T12:08:42.423Z 2026-04-09T12:08:42.423Z
9626505 9626505 20260408140657_3GegV NZ0042 2026-04-09T12:08:29.243Z 2026-04-09T12:08:29.243Z
9626476 9626476 20260408140535_hNkNu NZ0042 2026-04-09T12:08:25.248Z 2026-04-09T12:08:25.248Z
9626115 9626115 20260408131149_381qh NZ0042 2026-04-09T12:07:36.691Z 2026-04-09T12:07:36.691Z
9625549 9625549 20260408111631_5XiAa NZ0042 2026-04-09T12:05:50.253Z 2026-04-09T12:05:50.253Z
9607404 9607404 20260404084231_bpTKd NZ0042 2026-04-05T12:02:01.479Z 2026-04-09T12:39:21.158Z
9607350 9607350 20260404080555_FhFVc NZ0042 2026-04-05T12:01:49.639Z 2026-04-09T12:39:19.903Z
9606311 9606311 20260403170339_kik1r NZ0042 2026-04-04T12:06:21.976Z 2026-04-09T12:42:13.921Z
9606175 9606175 20260403155654_SqTVz NZ0042 2026-04-04T12:05:46.154Z 2026-04-09T12:42:10.328Z
9606121 9606121 20260403152136_Ir4RK NZ0042 2026-04-04T12:05:30.469Z 2026-04-09T12:42:08.767Z
9606010 9606010 20260403141130_N9txb NZ0042 2026-04-04T12:04:57.624Z 2026-04-09T12:42:05.986Z
9605937 9605937 20260403131813_BOAkY NZ0042 2026-04-04T12:04:31.707Z 2026-04-09T12:42:04.220Z
9605890 9605890 20260403123806_T9Qqk NZ0042 2026-04-04T12:04:21.593Z 2026-04-09T12:42:03.204Z
9605883 9605883 20260403123509_nYFDj NZ0042 2026-04-04T12:04:20.254Z 2026-04-09T12:42:03.056Z
9605799 9605799 20260403120805_LRDdU NZ0042 2026-04-04T12:03:58.144Z 2026-04-09T12:41:40.237Z
9605504 9605504 20260403102742_PlZfa NZ0042 2026-04-04T12:02:38.905Z 2026-04-09T12:41:23.782Z
9603766 9603766 20260402121523_5B2sP NZ0042 2026-04-03T12:04:28.549Z 2026-04-09T12:44:08.667Z
9603738 9603738 20260402115953_3QcxU NZ0042 2026-04-03T12:04:20.822Z 2026-04-09T12:44:07.902Z
9603094 9603094 20260402074605_YLloe NZ0042 2026-04-03T12:01:43.514Z 2026-04-09T12:43:20.684Z
9599248 9599248 20260331131730_UFLdw NZ0042 2026-04-01T12:02:53.583Z 2026-04-09T12:46:44.680Z
9597993 9597993 20260330172754_Y6HR3 NZ0042 2026-03-31T12:07:24.803Z 2026-04-08T12:44:22.676Z
9597881 9597881 20260330171157_PqQfh NZ0042 2026-03-31T12:07:10.671Z 2026-04-08T12:44:19.759Z
9597843 9597843 20260330170804_EADZC NZ0042 2026-03-31T12:07:06.370Z 2026-04-08T12:44:18.685Z
9597816 9597816 20260330170112_4zjeR NZ0042 2026-03-31T12:07:02.996Z 2026-04-08T12:44:17.999Z
9597809 9597809 20260330170041_Yopax NZ0042 2026-03-31T12:07:02.569Z 2026-04-08T12:44:17.956Z
9597672 9597672 20260330164947_UtEak NZ0042 2026-03-31T12:06:51.658Z 2026-04-08T12:44:14.715Z
9597651 9597651 20260330164749_2OMLu NZ0042 2026-03-31T12:06:49.982Z 2026-04-08T12:44:12.973Z
9597608 9597608 20260330164206_bTV9w NZ0042 2026-03-31T12:06:46.305Z 2026-04-08T12:43:59.146Z
9597477 9597477 20260330162312_ji33w NZ0042 2026-03-31T12:06:27.401Z 2026-04-08T12:43:43.901Z
9597376 9597376 20260330161130_a29Wx NZ0042 2026-03-31T12:06:16.436Z 2026-04-08T12:43:41.558Z
9597359 9597359 20260330161106_DoVvd NZ0042 2026-03-31T12:06:14.039Z 2026-04-08T12:43:41.349Z
9597311 9597311 20260330155942_0hf2c NZ0042 2026-03-31T12:06:06.807Z 2026-04-08T12:43:40.229Z
9597200 9597200 20260330153401_B3Y69 NZ0042 2026-03-31T12:05:53.382Z 2026-04-08T12:43:35.405Z
9597164 9597164 20260330152955_kMiWr NZ0042 2026-03-31T12:05:49.779Z 2026-04-08T12:43:34.742Z
9597011 9597011 20260330145724_Fu4rK NZ0042 2026-03-31T12:05:29.216Z 2026-04-08T12:43:30.362Z
9596946 9596946 20260330144144_IGRqS NZ0042 2026-03-31T12:05:20.703Z 2026-04-08T12:43:28.892Z
9596877 9596877 20260330142118_97JlO NZ0042 2026-03-31T12:05:08.783Z 2026-04-08T12:43:26.793Z
9596870 9596870 20260330142011_dQg30 NZ0042 2026-03-31T12:05:08.198Z 2026-04-08T12:43:26.682Z
9596808 9596808 20260330140620_keogD NZ0042 2026-03-31T12:05:00.456Z 2026-04-08T12:43:25.136Z
9596748 9596748 20260330135333_I3zM3 NZ0042 2026-03-31T12:04:53.353Z 2026-04-08T12:43:23.621Z
9596726 9596726 20260330134848_3u8Gd NZ0042 2026-03-31T12:04:51.111Z 2026-04-08T12:43:23.151Z
9596715 9596715 20260330134732_nfUvY NZ0042 2026-03-31T12:04:47.496Z 2026-04-08T12:43:22.882Z
9596626 9596626 20260330132815_Lc8e3 NZ0042 2026-03-31T12:04:37.472Z 2026-04-08T12:43:21.132Z
9596621 9596621 20260330132604_qaW6s NZ0042 2026-03-31T12:04:36.728Z 2026-04-08T12:43:20.874Z
9596577 9596577 20260330131622_0WSd0 NZ0042 2026-03-31T12:04:32.394Z 2026-04-08T12:43:19.861Z
9596566 9596566 20260330131513_43tBY NZ0042 2026-03-31T12:04:31.508Z 2026-04-08T12:43:19.713Z
9596484 9596484 20260330124837_8WgrD NZ0042 2026-03-31T12:04:23.230Z 2026-04-08T12:43:16.929Z
9596475 9596475 20260330124742_2ZFPS NZ0042 2026-03-31T12:04:22.087Z 2026-04-08T12:43:16.352Z
9596444 9596444 20260330123830_74Fjj NZ0042 2026-03-31T12:04:16.631Z 2026-04-08T12:43:09.485Z
9596324 9596324 20260330121908_MkRbf NZ0042 2026-03-31T12:04:02.336Z 2026-04-08T12:42:49.685Z
9596285 9596285 20260330120520_3iZ9B NZ0042 2026-03-31T12:03:56.147Z 2026-04-08T12:42:48.452Z
9596269 9596269 20260330120023_MuZMh NZ0042 2026-03-31T12:03:54.103Z 2026-04-08T12:42:47.975Z
9596201 9596201 20260330114500_i3Var NZ0042 2026-03-31T12:03:42.980Z 2026-04-08T12:42:43.918Z
9596082 9596082 20260330110545_RBzT8 NZ0042 2026-03-31T12:03:22.725Z 2026-04-08T12:42:40.662Z
9591566 9591566 20260328171154_wZEpk NZ0042 2026-03-29T12:04:37.300Z 2026-04-06T12:39:23.216Z
9591553 9591553 20260328170802_7kxcb NZ0042 2026-03-29T12:04:36.091Z 2026-04-06T12:39:22.645Z
9591510 9591510 20260328165837_bkDhq NZ0042 2026-03-29T12:04:31.472Z 2026-04-06T12:39:19.054Z
9591498 9591498 20260328165257_Wco1q NZ0042 2026-03-29T12:04:30.506Z 2026-04-06T12:39:18.489Z
9591489 9591489 20260328165227_nYaVd NZ0042 2026-03-29T12:04:29.981Z 2026-04-06T12:39:17.986Z
9591430 9591430 20260328162846_naPl6 NZ0042 2026-03-29T12:04:24.324Z 2026-04-06T12:39:15.210Z
9591416 9591416 20260328162553_3Ujc5 NZ0042 2026-03-29T12:04:22.874Z 2026-04-06T12:39:14.612Z
9591402 9591402 20260328162026_tx4ct NZ0042 2026-03-29T12:04:21.681Z 2026-04-06T12:39:14.183Z
9591307 9591307 20260328153140_5BUMp NZ0042 2026-03-29T12:04:11.779Z 2026-04-06T12:39:10.352Z
9591301 9591301 20260328153117_rVJZq NZ0042 2026-03-29T12:04:11.222Z 2026-04-06T12:39:09.923Z
9591284 9591284 20260328151140_ssomT NZ0042 2026-03-29T12:04:09.596Z 2026-04-06T12:39:09.019Z
9591262 9591262 20260328150407_1HdxX NZ0042 2026-03-29T12:04:07.567Z 2026-04-06T12:39:08.172Z
9591259 9591259 20260328150307_G7iRQ NZ0042 2026-03-29T12:04:07.196Z 2026-04-06T12:39:08.057Z
9591045 9591045 20260328124727_hKSQG NZ0042 2026-03-29T12:03:42.720Z 2026-04-06T12:38:48.279Z
9591037 9591037 20260328123851_Q5ZKJ NZ0042 2026-03-29T12:03:41.973Z 2026-04-06T12:38:47.829Z
9590811 9590811 20260328112306_TT3ey NZ0042 2026-03-29T12:03:19.325Z 2026-04-06T12:38:35.487Z
9590754 9590754 20260328110855_xrvKd NZ0042 2026-03-29T12:03:13.391Z 2026-04-06T12:38:33.332Z
9590700 9590700 20260328104836_joA3r NZ0042 2026-03-29T12:03:09.182Z 2026-04-06T12:38:30.739Z
9590671 9590671 20260328104003_WcTAm NZ0042 2026-03-29T12:03:06.381Z 2026-04-06T12:38:30.016Z
9590448 9590448 20260328091340_sZcFP NZ0042 2026-03-29T12:02:40.880Z 2026-04-06T12:38:10.074Z
9590310 9590310 20260328080804_DGEVr NZ0042 2026-03-29T12:02:24.326Z 2026-04-06T12:38:00.806Z
9590277 9590277 20260328080013_84Ww4 NZ0042 2026-03-29T12:02:21.475Z 2026-04-06T12:37:59.345Z
9587680 9587680 20260327150411_G8pRA NZ0042 2026-03-28T12:06:06.883Z 2026-04-05T12:34:36.555Z
9567619 9567619 20260323153620_4LZIL NZ0042 2026-03-24T12:13:52.656Z 2026-03-24T12:24:25.312Z
9567581 9567581 20260323153251_zekct NZ0042 2026-03-24T12:13:48.896Z 2026-03-24T12:24:25.304Z
9566365 9566365 20260323132914_dvqm3 NZ0042 2026-03-24T12:11:43.637Z 2026-03-31T12:27:49.440Z
9565551 9565551 20260323121841_M6XmO NZ0042 2026-03-24T12:10:23.094Z 2026-03-31T12:27:37.336Z
9565108 9565108 20260323114518_Mor4O NZ0042 2026-03-24T12:09:25.865Z 2026-03-31T12:27:23.049Z
9564188 9564188 20260323100938_gDgjp NZ0042 2026-03-24T12:07:36.284Z 2026-03-31T12:27:04.833Z
9564040 9564040 20260323095128_2U46G NZ0042 2026-03-24T12:07:17.320Z 2026-03-31T12:27:01.338Z
9556922 9556922 20260322121324_LLpQz NZ0042 2026-03-23T12:05:21.419Z 2026-03-30T12:29:15.166Z
9556098 9556098 20260322091848_j43e7 NZ0042 2026-03-23T12:04:21.249Z 2026-03-30T12:28:44.911Z
9556021 9556021 20260322090314_3Yy5H NZ0042 2026-03-23T12:04:15.362Z 2026-03-30T12:28:41.753Z
9555963 9555963 20260322085321_fTlHQ NZ0042 2026-03-23T12:04:12.630Z 2026-03-30T12:28:40.464Z
9555795 9555795 20260322080022_3UHih NZ0042 2026-03-23T12:03:55.365Z 2026-03-30T12:28:35.399Z
9550762 9550762 20260320171036_i2VyV NZ0042 2026-03-22T12:25:42.419Z 2026-03-28T12:36:35.845Z
9550654 9550654 20260320165735_i3cMg NZ0042 2026-03-22T12:25:34.678Z 2026-03-28T12:36:33.804Z
9550621 9550621 20260320165602_kjeXh NZ0042 2026-03-22T12:25:33.184Z 2026-03-28T12:36:33.388Z
9550564 9550564 20260320165124_Z35YP NZ0042 2026-03-22T12:25:30.444Z 2026-03-28T12:36:32.709Z
9550204 9550204 20260320161850_Kblfj NZ0042 2026-03-22T12:25:01.227Z 2026-03-28T12:36:28.184Z
9550115 9550115 20260320160853_5ginC NZ0042 2026-03-22T12:24:55.876Z 2026-03-28T12:36:27.153Z

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