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 = "NZ003E" 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
9610331 9610331 20260405162602_72ylp NZ003E 2026-04-06T12:07:07.798Z 2026-04-08T12:26:41.068Z
9610252 9610252 20260405152348_zFDyQ NZ003E 2026-04-06T12:06:42.781Z 2026-04-08T12:26:34.680Z
9610244 9610244 20260405151744_MJLfx NZ003E 2026-04-06T12:06:35.694Z 2026-04-08T12:26:34.024Z
9610132 9610132 20260405133232_SUgY5 NZ003E 2026-04-06T12:05:58.515Z 2026-04-08T12:26:27.010Z
9606335 9606335 20260403171144_8oAJb NZ003E 2026-04-04T12:06:29.903Z 2026-04-08T12:34:13.918Z
9606262 9606262 20260403164328_koVO0 NZ003E 2026-04-04T12:06:12.120Z 2026-04-08T12:34:01.609Z
9606248 9606248 20260403163724_K7NFV NZ003E 2026-04-04T12:06:09.597Z 2026-04-08T12:34:01.070Z
9606141 9606141 20260403153147_FU2jB NZ003E 2026-04-04T12:05:34.698Z 2026-04-08T12:33:53.535Z
9605936 9605936 20260403131813_BOAkY NZ003E 2026-04-04T12:04:31.707Z 2026-04-08T12:33:43.094Z
9605905 9605905 20260403124418_Ok9OU NZ003E 2026-04-04T12:04:24.296Z 2026-04-08T12:33:39.480Z
9605882 9605882 20260403123509_nYFDj NZ003E 2026-04-04T12:04:20.254Z 2026-04-08T12:33:31.422Z
9605835 9605835 20260403121441_FbfSj NZ003E 2026-04-04T12:04:05.475Z 2026-04-08T12:33:29.821Z
9605828 9605828 20260403121054_hjxwI NZ003E 2026-04-04T12:04:03.464Z 2026-04-08T12:33:29.511Z
9605793 9605793 20260403120616_UqoaL NZ003E 2026-04-04T12:03:57.124Z 2026-04-08T12:33:27.975Z
9605200 9605200 20260403075000_O3H5g NZ003E 2026-04-04T12:01:07.004Z 2026-04-08T12:32:51.611Z
9604362 9604362 20260402172127_ac2v8 NZ003E 2026-04-03T12:07:04.197Z 2026-04-08T12:37:12.757Z
9604223 9604223 20260402164117_ChLV4 NZ003E 2026-04-03T12:06:26.207Z 2026-04-08T12:36:54.037Z
9602205 9602205 20260331105830_zgItP NZ003E 2026-04-02T12:06:06.306Z 2026-04-08T12:40:01.911Z
9601947 9601947 20260401173402_kPYoH NZ003E 2026-04-02T12:04:16.865Z 2026-04-08T12:38:44.870Z
9601856 9601856 20260401171538_hRJ13 NZ003E 2026-04-02T12:03:57.024Z 2026-04-08T12:38:42.118Z
9601688 9601688 20260401162922_FCR5B NZ003E 2026-04-02T12:03:27.742Z 2026-04-08T12:38:35.286Z
9601668 9601668 20260401162823_TN3dt NZ003E 2026-04-02T12:03:25.706Z 2026-04-08T12:38:34.749Z
9601655 9601655 20260401162647_etFZq NZ003E 2026-04-02T12:03:23.538Z 2026-04-08T12:38:34.215Z
9601572 9601572 20260401155117_1JdZg NZ003E 2026-04-02T12:03:08.697Z 2026-04-08T12:38:31.351Z
9601334 9601334 20260401142258_of4zX NZ003E 2026-04-02T12:02:27.522Z 2026-04-08T12:38:09.950Z
9599085 9599085 20260331113214_NLz8R NZ003E 2026-04-01T12:02:19.032Z 2026-04-08T12:40:03.646Z
9599070 9599070 20260331112938_kHzNC NZ003E 2026-04-01T12:02:15.286Z 2026-04-08T12:40:03.198Z
9598046 9598046 20260330173507_lWfdb NZ003E 2026-03-31T12:07:30.277Z 2026-04-08T12:44:24.254Z
9597920 9597920 20260330171512_kyPtt NZ003E 2026-03-31T12:07:17.125Z 2026-04-08T12:44:20.666Z
9597878 9597878 20260330171157_PqQfh NZ003E 2026-03-31T12:07:10.671Z 2026-04-08T12:44:19.759Z
9596954 9596954 20260330144457_3SulO NZ003E 2026-03-31T12:05:21.568Z 2026-04-08T12:43:29.015Z
9596692 9596692 20260330134230_64pZW NZ003E 2026-03-31T12:04:44.612Z 2026-04-08T12:43:22.482Z
9596574 9596574 20260330131622_0WSd0 NZ003E 2026-03-31T12:04:32.394Z 2026-04-08T12:43:19.861Z
9596341 9596341 20260330122042_Mmq3a NZ003E 2026-03-31T12:04:04.077Z 2026-04-08T12:42:50.069Z
9595849 9595849 20260330092721_La2V8 NZ003E 2026-03-31T12:02:42.113Z 2026-04-08T12:42:34.470Z
9594143 9594143 20260328131657_UfE1W NZ003E 2026-03-30T12:08:14.126Z 2026-04-06T12:39:00.553Z
9594137 9594137 20260328084829_GDCdu NZ003E 2026-03-30T12:07:31.087Z 2026-04-06T12:38:04.899Z
9591551 9591551 20260328170802_7kxcb NZ003E 2026-03-29T12:04:36.091Z 2026-04-06T12:39:22.645Z
9591537 9591537 20260328170358_7DWjY NZ003E 2026-03-29T12:04:33.725Z 2026-04-06T12:39:22.009Z
9591451 9591451 20260328164335_tzIWS NZ003E 2026-03-29T12:04:26.542Z 2026-04-06T12:39:16.242Z
9591421 9591421 20260328162649_SXgql NZ003E 2026-03-29T12:04:23.372Z 2026-04-06T12:39:14.866Z
9591419 9591419 20260328162557_15H3f NZ003E 2026-03-29T12:04:23.164Z 2026-04-06T12:39:14.717Z
9591415 9591415 20260328162553_3Ujc5 NZ003E 2026-03-29T12:04:22.874Z 2026-04-06T12:39:14.612Z
9591369 9591369 20260328155846_BCcid NZ003E 2026-03-29T12:04:18.973Z 2026-04-06T12:39:12.737Z
9591352 9591352 20260328155009_4uZcQ NZ003E 2026-03-29T12:04:17.736Z 2026-04-06T12:39:12.132Z
9591337 9591337 20260328154456_sgSge NZ003E 2026-03-29T12:04:16.539Z 2026-04-06T12:39:11.485Z
9591336 9591336 20260328154252_bXww2 NZ003E 2026-03-29T12:04:16.199Z 2026-04-06T12:39:11.354Z
9591326 9591326 20260328153657_7YmzC NZ003E 2026-03-29T12:04:15.173Z 2026-04-06T12:39:10.946Z
9591306 9591306 20260328153140_5BUMp NZ003E 2026-03-29T12:04:11.779Z 2026-04-06T12:39:10.352Z
9591231 9591231 20260328144700_2XV2k NZ003E 2026-03-29T12:04:03.495Z 2026-04-06T12:39:06.616Z
9591139 9591139 20260328134552_ifcqN NZ003E 2026-03-29T12:03:54.673Z 2026-04-06T12:39:02.650Z
9591134 9591134 20260328133913_KO0lg NZ003E 2026-03-29T12:03:54.126Z 2026-04-06T12:39:02.429Z
9591115 9591115 20260328132749_USXVL NZ003E 2026-03-29T12:03:51.846Z 2026-04-06T12:39:01.361Z
9590769 9590769 20260328111259_gDIr3 NZ003E 2026-03-29T12:03:16.590Z 2026-04-06T12:38:34.072Z
9590240 9590240 20260328074503_HWcyN NZ003E 2026-03-29T12:02:18.546Z 2026-04-06T12:37:58.010Z
9587700 9587700 20260327151012_PKv2j NZ003E 2026-03-28T12:06:09.896Z 2026-04-05T12:34:37.802Z
9587674 9587674 20260327150156_e6BqO NZ003E 2026-03-28T12:06:06.453Z 2026-04-05T12:34:36.454Z
9587603 9587603 20260327142832_Dte9g NZ003E 2026-03-28T12:05:53.891Z 2026-04-05T12:34:33.284Z
9587559 9587559 20260327140646_dMJpl NZ003E 2026-03-28T12:05:49.504Z 2026-04-05T12:34:31.560Z
9587530 9587530 20260327134527_iNUf8 NZ003E 2026-03-28T12:05:45.261Z 2026-04-05T12:34:30.226Z
9587495 9587495 20260327132843_chmsm NZ003E 2026-03-28T12:05:40.343Z 2026-04-05T12:34:28.891Z
9587485 9587485 20260327131959_s8DkV NZ003E 2026-03-28T12:05:39.009Z 2026-04-05T12:34:28.471Z
9587479 9587479 20260327131640_em6sC NZ003E 2026-03-28T12:05:38.325Z 2026-04-05T12:34:28.231Z
9587466 9587466 20260327130322_wsKF7 NZ003E 2026-03-28T12:05:34.293Z 2026-04-05T12:34:27.512Z
9587458 9587458 20260327130003_s7hHN NZ003E 2026-03-28T12:05:33.636Z 2026-04-05T12:34:27.282Z
9587418 9587418 20260327123815_kpt6z NZ003E 2026-03-28T12:05:28.458Z 2026-04-05T12:34:25.853Z
9587294 9587294 20260327120024_smkw3 NZ003E 2026-03-28T12:05:12.781Z 2026-04-05T12:34:11.819Z
9587258 9587258 20260327115628_zBLFu NZ003E 2026-03-28T12:05:09.226Z 2026-04-05T12:34:10.521Z
9587135 9587135 20260327112238_d2dT4 NZ003E 2026-03-28T12:04:51.771Z 2026-04-05T12:34:03.642Z
9587111 9587111 20260327111543_eGvly NZ003E 2026-03-28T12:04:47.209Z 2026-04-05T12:34:02.032Z
9586899 9586899 20260327101020_KLv2d NZ003E 2026-03-28T12:04:19.178Z 2026-04-05T12:33:53.507Z
9586403 9586403 20260327071012_Y5K6n NZ003E 2026-03-28T12:03:00.285Z 2026-04-05T12:33:23.806Z
9574658 9574658 20260323111347_ZFqBe NZ003E 2026-03-25T12:14:25.075Z 2026-03-31T12:27:16.541Z
9567128 9567128 20260323144217_3KQHy NZ003E 2026-03-24T12:13:02.442Z 2026-03-31T12:28:08.806Z
9566908 9566908 20260323142424_Nfp9q NZ003E 2026-03-24T12:12:41.323Z 2026-03-31T12:28:05.941Z
9566627 9566627 20260323135820_akcWL NZ003E 2026-03-24T12:12:13.601Z 2026-03-31T12:27:54.782Z
9566607 9566607 20260323135654_jZLhc NZ003E 2026-03-24T12:12:11.944Z 2026-03-31T12:27:54.533Z
9566316 9566316 20260323132433_UI88L NZ003E 2026-03-24T12:11:40.039Z 2026-03-31T12:27:48.707Z
9566022 9566022 20260323125927_rm6WT NZ003E 2026-03-24T12:11:13.715Z 2026-03-31T12:27:44.953Z
9566019 9566019 20260323125845_rHEoK NZ003E 2026-03-24T12:11:13.109Z 2026-03-31T12:27:44.907Z
9565974 9565974 20260323125545_DsIcZ NZ003E 2026-03-24T12:11:07.582Z 2026-03-31T12:27:44.292Z
9565717 9565717 20260323123522_r23sL NZ003E 2026-03-24T12:10:43.589Z 2026-03-31T12:27:40.152Z
9565691 9565691 20260323123315_wEilM NZ003E 2026-03-24T12:10:39.329Z 2026-03-31T12:27:39.826Z
9565289 9565289 20260323115759_LY1cV NZ003E 2026-03-24T12:09:49.335Z 2026-03-31T12:27:32.585Z
9565105 9565105 20260323114518_Mor4O NZ003E 2026-03-24T12:09:25.865Z 2026-03-31T12:27:23.049Z
9564508 9564508 20260323104240_ZBXDY NZ003E 2026-03-24T12:08:15.089Z 2026-03-31T12:27:10.365Z
9558818 9558818 20260321154935_zfleO NZ003E 2026-03-23T12:10:34.628Z 2026-03-29T12:20:30.415Z
9558655 9558655 20260322171932_r8kLo NZ003E 2026-03-23T12:06:53.296Z 2026-03-30T12:30:19.590Z
9558542 9558542 20260322165516_DmPej NZ003E 2026-03-23T12:06:48.363Z 2026-03-30T12:30:16.335Z
9557128 9557128 20260322125955_LRgbS NZ003E 2026-03-23T12:05:37.629Z 2026-03-30T12:29:29.460Z
9557125 9557125 20260322125955_oTqYG NZ003E 2026-03-23T12:05:37.454Z 2026-03-30T12:29:29.382Z
9557036 9557036 20260322123803_Tn1o7 NZ003E 2026-03-23T12:05:29.418Z 2026-03-30T12:29:19.432Z
9557030 9557030 20260322123750_MycGD NZ003E 2026-03-23T12:05:29.231Z 2026-03-30T12:29:19.295Z
9556781 9556781 20260322113858_TxnK7 NZ003E 2026-03-23T12:05:12.770Z 2026-03-30T12:29:10.769Z
9556759 9556759 20260322113428_QYF81 NZ003E 2026-03-23T12:05:11.571Z 2026-03-30T12:29:10.327Z
9556650 9556650 20260322111555_AVNRE NZ003E 2026-03-23T12:05:04.751Z 2026-03-30T12:29:06.981Z
9556598 9556598 20260322111249_xFdJf NZ003E 2026-03-23T12:04:59.313Z 2026-03-30T12:29:05.958Z
9556166 9556166 20260322092926_F3pgM NZ003E 2026-03-23T12:04:26.274Z 2026-03-30T12:28:46.442Z
9550759 9550759 20260320171036_i2VyV NZ003E 2026-03-22T12:25:42.418Z 2026-03-28T12:36:35.845Z
9550421 9550421 20260320163724_SUU35 NZ003E 2026-03-22T12:25:14.241Z 2026-03-28T12:36:30.569Z

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