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 = "NZ003A" 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
9627403 9627403 20260408172451_nbWx4 NZ003A 2026-04-09T12:10:51.034Z 2026-04-10T12:14:22.537Z
9627349 9627349 20260408172026_lcLnM NZ003A 2026-04-09T12:10:43.906Z 2026-04-10T12:14:22.529Z
9627287 9627287 20260408170052_nvM0x NZ003A 2026-04-09T12:10:33.080Z 2026-04-10T12:14:22.516Z
9627164 9627164 20260408163257_VSD59 NZ003A 2026-04-09T12:10:12.159Z 2026-04-10T12:14:22.492Z
9626968 9626968 20260408154016_XyePe NZ003A 2026-04-09T12:09:38.714Z 2026-04-10T12:14:22.447Z
9626958 9626958 20260408153621_u6jtP NZ003A 2026-04-09T12:09:37.477Z 2026-04-10T12:14:22.444Z
9626917 9626917 20260408152239_vK3Ie NZ003A 2026-04-09T12:09:31.827Z 2026-04-10T12:14:22.434Z
9626778 9626778 20260408150342_7YVaY NZ003A 2026-04-09T12:09:10.208Z 2026-04-10T12:14:22.412Z
9626493 9626493 20260408140624_9MS0k NZ003A 2026-04-09T12:08:27.470Z 2026-04-10T12:14:22.361Z
9626350 9626350 20260408134532_Po3Wm NZ003A 2026-04-09T12:08:11.663Z 2026-04-10T12:14:22.338Z
9626295 9626295 20260408133926_FNYeo NZ003A 2026-04-09T12:07:55.724Z 2026-04-10T12:14:22.330Z
9626270 9626270 20260408133629_bNjb6 NZ003A 2026-04-09T12:07:53.904Z 2026-04-10T12:14:22.327Z
9625527 9625527 20260408110830_rz2hE NZ003A 2026-04-09T12:05:46.626Z 2026-04-10T12:14:22.196Z
9610361 9610361 20260405170326_VAdwz NZ003A 2026-04-06T12:07:20.292Z 2026-04-10T12:27:05.653Z
9609657 9609657 20260405090005_lJeAC NZ003A 2026-04-06T12:03:08.376Z 2026-04-10T12:26:20.649Z
9605350 9605350 20260403085430_fOXwc NZ003A 2026-04-04T12:01:52.013Z 2026-04-10T12:31:33.938Z
9603709 9603709 20260402115549_LmwKG NZ003A 2026-04-03T12:04:16.247Z 2026-04-10T12:34:07.763Z
9603609 9603609 20260402112229_wQN05 NZ003A 2026-04-03T12:03:48.214Z 2026-04-10T12:34:05.308Z
9603472 9603472 20260402103120_UgtO5 NZ003A 2026-04-03T12:03:10.699Z 2026-04-10T12:34:02.654Z
9603367 9603367 20260402094402_p4AXD NZ003A 2026-04-03T12:02:43.513Z 2026-04-10T12:34:00.710Z
9603238 9603238 20260402090108_ffPqb NZ003A 2026-04-03T12:02:15.512Z 2026-04-10T12:33:58.453Z
9603210 9603210 20260402084342_SVJNF NZ003A 2026-04-03T12:02:08.895Z 2026-04-10T12:33:57.976Z
9603195 9603195 20260402084145_iL5SL NZ003A 2026-04-03T12:02:06.939Z 2026-04-10T12:33:57.776Z
9601113 9601113 20260401115909_7iEr8 NZ003A 2026-04-02T12:01:38.844Z 2026-04-10T12:35:33.375Z
9599917 9599917 20260331172533_51Puy NZ003A 2026-04-01T12:05:17.173Z 2026-04-09T12:48:01.319Z
9599674 9599674 20260331161830_x7BYl NZ003A 2026-04-01T12:04:26.918Z 2026-04-09T12:47:13.988Z
9599435 9599435 20260331143909_GraaR NZ003A 2026-04-01T12:03:35.811Z 2026-04-09T12:46:47.489Z
9599220 9599220 20260331125619_btF02 NZ003A 2026-04-01T12:02:46.733Z 2026-04-09T12:46:44.188Z
9599198 9599198 20260331124537_srKqR NZ003A 2026-04-01T12:02:43.269Z 2026-04-09T12:46:43.923Z
9599194 9599194 20260331124235_C6S2w NZ003A 2026-04-01T12:02:42.317Z 2026-04-09T12:46:43.858Z
9599049 9599049 20260331111555_OwwmI NZ003A 2026-04-01T12:02:11.286Z 2026-04-09T12:46:40.643Z
9599040 9599040 20260331110804_K6qWV NZ003A 2026-04-01T12:02:09.243Z 2026-04-09T12:46:40.496Z
9598823 9598823 20260331074010_p6EmH NZ003A 2026-04-01T12:01:13.072Z 2026-04-09T12:46:36.405Z
9598030 9598030 20260330173322_qL9Xq NZ003A 2026-03-31T12:07:28.631Z 2026-04-08T12:44:23.744Z
9597891 9597891 20260330171322_AB56p NZ003A 2026-03-31T12:07:10.963Z 2026-04-08T12:44:19.871Z
9597725 9597725 20260330165340_Em5RG NZ003A 2026-03-31T12:06:55.655Z 2026-04-08T12:44:16.132Z
9597523 9597523 20260330162926_Xqrx4 NZ003A 2026-03-31T12:06:31.900Z 2026-04-08T12:43:44.798Z
9597490 9597490 20260330162528_jdEUf NZ003A 2026-03-31T12:06:28.543Z 2026-04-08T12:43:44.106Z
9597368 9597368 20260330161126_EogyG NZ003A 2026-03-31T12:06:14.484Z 2026-04-08T12:43:41.416Z
9597245 9597245 20260330154712_8cA27 NZ003A 2026-03-31T12:06:00.526Z 2026-04-08T12:43:36.822Z
9597163 9597163 20260330152955_kMiWr NZ003A 2026-03-31T12:05:49.779Z 2026-04-08T12:43:34.742Z
9597117 9597117 20260330151847_UR6A0 NZ003A 2026-03-31T12:05:41.195Z 2026-04-08T12:43:33.156Z
9597066 9597066 20260330150902_bFsuf NZ003A 2026-03-31T12:05:35.887Z 2026-04-08T12:43:31.877Z
9597047 9597047 20260330150633_o8278 NZ003A 2026-03-31T12:05:34.045Z 2026-04-08T12:43:31.537Z
9597034 9597034 20260330150311_y8r71 NZ003A 2026-03-31T12:05:32.292Z 2026-04-08T12:43:31.149Z
9596986 9596986 20260330145228_X2oAh NZ003A 2026-03-31T12:05:24.888Z 2026-04-08T12:43:29.529Z
9596782 9596782 20260330140140_C088T NZ003A 2026-03-31T12:04:56.894Z 2026-04-08T12:43:24.372Z
9596766 9596766 20260330135651_3Tgyx NZ003A 2026-03-31T12:04:55.199Z 2026-04-08T12:43:23.931Z
9596647 9596647 20260330133130_VvQN2 NZ003A 2026-03-31T12:04:39.412Z 2026-04-08T12:43:21.575Z
9596466 9596466 20260330124353_1ktyM NZ003A 2026-03-31T12:04:19.439Z 2026-04-08T12:43:13.620Z
9596375 9596375 20260330122509_sY9v5 NZ003A 2026-03-31T12:04:07.576Z 2026-04-08T12:42:50.762Z
9596357 9596357 20260330122307_furic NZ003A 2026-03-31T12:04:05.279Z 2026-04-08T12:42:50.234Z
9596351 9596351 20260330122307_P428j NZ003A 2026-03-31T12:04:04.900Z 2026-04-08T12:42:50.176Z
9596025 9596025 20260330104514_EPh82 NZ003A 2026-03-31T12:03:09.916Z 2026-04-08T12:42:38.763Z
9595974 9595974 20260330102021_ZFUwA NZ003A 2026-03-31T12:03:02.082Z 2026-04-08T12:42:37.675Z
9595948 9595948 20260330101330_ntm0y NZ003A 2026-03-31T12:02:58.347Z 2026-04-08T12:42:37.023Z
9595924 9595924 20260330101101_9ouOz NZ003A 2026-03-31T12:02:51.923Z 2026-04-08T12:42:36.317Z
9595768 9595768 20260330083115_TB3bF NZ003A 2026-03-31T12:02:26.599Z 2026-04-08T12:42:31.572Z
9595688 9595688 20260330080350_h3QJt NZ003A 2026-03-31T12:02:12.641Z 2026-04-08T12:42:29.489Z
9595647 9595647 20260330073807_ZR39V NZ003A 2026-03-31T12:02:04.380Z 2026-04-08T12:42:28.154Z
9594134 9594134 20260328071856_9Pc31 NZ003A 2026-03-30T12:07:17.227Z 2026-04-06T12:37:54.582Z
9591520 9591520 20260328170111_Yz7yH NZ003A 2026-03-29T12:04:31.991Z 2026-04-06T12:39:19.350Z
9591291 9591291 20260328152217_mroAn NZ003A 2026-03-29T12:04:10.364Z 2026-04-06T12:39:09.380Z
9591244 9591244 20260328145957_2pfVb NZ003A 2026-03-29T12:04:05.008Z 2026-04-06T12:39:07.515Z
9591223 9591223 20260328143959_SEKSB NZ003A 2026-03-29T12:04:02.788Z 2026-04-06T12:39:06.293Z
9591210 9591210 20260328142633_ajjnI NZ003A 2026-03-29T12:04:00.923Z 2026-04-06T12:39:05.506Z
9591201 9591201 20260328142246_knARe NZ003A 2026-03-29T12:04:00.298Z 2026-04-06T12:39:05.123Z
9591197 9591197 20260328141903_7mM2s NZ003A 2026-03-29T12:04:00.051Z 2026-04-06T12:39:05.033Z
9591151 9591151 20260328135256_BOsvM NZ003A 2026-03-29T12:03:56.123Z 2026-04-06T12:39:03.236Z
9591036 9591036 20260328123851_Q5ZKJ NZ003A 2026-03-29T12:03:41.973Z 2026-04-06T12:38:47.829Z
9591031 9591031 20260328123530_P7eLm NZ003A 2026-03-29T12:03:41.522Z 2026-04-06T12:38:47.525Z
9590445 9590445 20260328091340_sZcFP NZ003A 2026-03-29T12:02:40.880Z 2026-04-06T12:38:10.074Z
9590377 9590377 20260328084158_FOp92 NZ003A 2026-03-29T12:02:30.796Z 2026-04-06T12:38:03.999Z
9590345 9590345 20260328082112_Sx2m2 NZ003A 2026-03-29T12:02:27.303Z 2026-04-06T12:38:02.297Z
9590321 9590321 20260328081431_Ko3BZ NZ003A 2026-03-29T12:02:25.010Z 2026-04-06T12:38:01.212Z
9590168 9590168 20260328071856_9mgIK NZ003A 2026-03-29T12:02:08.658Z 2026-04-06T12:37:54.510Z
9583696 9583696 20260326171738_nSEuK NZ003A 2026-03-27T12:09:32.259Z 2026-04-04T12:41:31.853Z
9563686 9563686 20260323090113_A2OX5 NZ003A 2026-03-24T12:06:34.106Z 2026-03-31T12:26:49.457Z
9555984 9555984 20260322085946_6j3KR NZ003A 2026-03-23T12:04:13.982Z 2026-03-30T12:28:41.047Z
9555776 9555776 20260322075427_3G7Js NZ003A 2026-03-23T12:03:53.659Z 2026-03-30T12:28:34.686Z
9555671 9555671 20260322072725_uGOfV NZ003A 2026-03-23T12:03:45.865Z 2026-03-30T12:28:31.980Z
9549649 9549649 20260320152220_d7cxN NZ003A 2026-03-22T12:24:20.596Z 2026-03-28T12:36:07.778Z
9549167 9549167 20260320084948_DYnLC NZ003A 2026-03-22T12:19:46.745Z 2026-03-28T12:34:54.424Z
9546730 9546730 20260321122232_2O7x3 NZ003A 2026-03-22T12:12:17.920Z 2026-03-29T12:20:03.533Z
9546602 9546602 20260321121143_rd8lw NZ003A 2026-03-22T12:12:03.806Z 2026-03-29T12:20:02.575Z
9546466 9546466 20260321120156_anY60 NZ003A 2026-03-22T12:11:47.876Z 2026-03-29T12:20:01.423Z
9545963 9545963 20260321112711_dKDIv NZ003A 2026-03-22T12:10:43.878Z 2026-03-29T12:19:46.168Z
9545246 9545246 20260321101611_LOl6k NZ003A 2026-03-22T12:08:58.761Z 2026-03-29T12:19:38.500Z
9545076 9545076 20260321095916_H2euN NZ003A 2026-03-22T12:08:33.618Z 2026-03-29T12:19:36.808Z
9545057 9545057 20260321095658_WTCZQ NZ003A 2026-03-22T12:08:31.078Z 2026-03-29T12:19:36.624Z
9544934 9544934 20260321094336_jZojE NZ003A 2026-03-22T12:08:11.296Z 2026-03-29T12:19:35.390Z
9544817 9544817 20260321092632_76ePP NZ003A 2026-03-22T12:07:53.248Z 2026-03-29T12:19:34.204Z
9544732 9544732 20260321091558_LvxQF NZ003A 2026-03-22T12:07:37.526Z 2026-03-29T12:19:33.171Z
9544427 9544427 20260321083329_p4Rh9 NZ003A 2026-03-22T12:06:46.295Z 2026-03-29T12:19:29.622Z
9540241 9540241 20260319144850_HtRGx NZ003A 2026-03-21T12:26:32.863Z 2026-03-27T12:42:04.739Z
9540079 9540079 20260319124650_VFY76 NZ003A 2026-03-21T12:26:01.903Z 2026-03-27T12:41:57.811Z
9539978 9539978 20260319120014_Jhpds NZ003A 2026-03-21T12:25:41.512Z 2026-03-27T12:41:53.207Z
9536806 9536806 20260320103423_7i4nV NZ003A 2026-03-21T12:14:26.589Z 2026-03-28T12:35:16.699Z
9529277 9529277 20260318173426_IZORZ NZ003A 2026-03-20T12:23:00.936Z 2026-03-26T12:38:54.004Z
9529263 9529263 20260318173345_RSH3V NZ003A 2026-03-20T12:23:00.530Z 2026-03-26T12:38:53.799Z

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