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 = "NZ002K" 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
9607506 9607506 20260404100512_Sb9Dh NZ002K 2026-04-05T12:02:39.025Z 2026-04-09T12:39:24.125Z
9605895 9605895 20260403124331_PlBlI NZ002K 2026-04-04T12:04:23.138Z 2026-04-09T12:42:03.280Z
9605736 9605736 20260403114521_7mz8K NZ002K 2026-04-04T12:03:39.351Z 2026-04-09T12:41:30.356Z
9603464 9603464 20260402103117_pzx8f NZ002K 2026-04-03T12:03:10.367Z 2026-04-09T12:43:49.733Z
9603362 9603362 20260402094402_mDEZA NZ002K 2026-04-03T12:02:43.146Z 2026-04-09T12:43:30.187Z
9603320 9603320 20260402093201_mV4Et NZ002K 2026-04-03T12:02:36.294Z 2026-04-09T12:43:24.957Z
9603236 9603236 20260402090108_ffPqb NZ002K 2026-04-03T12:02:15.512Z 2026-04-09T12:43:23.634Z
9603205 9603205 20260402084341_HvYD1 NZ002K 2026-04-03T12:02:08.430Z 2026-04-09T12:43:23.042Z
9603199 9603199 20260402084146_xVpOT NZ002K 2026-04-03T12:02:07.370Z 2026-04-09T12:43:22.872Z
9603133 9603133 20260402075939_psLYX NZ002K 2026-04-03T12:01:55.788Z 2026-04-09T12:43:21.547Z
9599774 9599774 20260331164704_lxy6t NZ002K 2026-04-01T12:04:48.108Z 2026-04-09T12:47:30.218Z
9599238 9599238 20260331131001_Yi0W8 NZ002K 2026-04-01T12:02:51.333Z 2026-04-09T12:46:44.528Z
9599218 9599218 20260331125619_btF02 NZ002K 2026-04-01T12:02:46.733Z 2026-04-09T12:46:44.188Z
9599193 9599193 20260331124235_C6S2w NZ002K 2026-04-01T12:02:42.317Z 2026-04-09T12:46:43.858Z
9599169 9599169 20260331122432_cDW6S NZ002K 2026-04-01T12:02:36.746Z 2026-04-09T12:46:42.694Z
9599038 9599038 20260331110804_K6qWV NZ002K 2026-04-01T12:02:09.243Z 2026-04-09T12:46:40.496Z
9599029 9599029 20260331105448_XS5H3 NZ002K 2026-04-01T12:02:06.688Z 2026-04-09T12:46:40.230Z
9598996 9598996 20260331102919_sgaNw NZ002K 2026-04-01T12:01:58.626Z 2026-04-09T12:46:39.581Z
9598905 9598905 20260331084725_x71tS NZ002K 2026-04-01T12:01:30.688Z 2026-04-09T12:46:37.757Z
9598873 9598873 20260331081912_SjNVS NZ002K 2026-04-01T12:01:22.818Z 2026-04-09T12:46:37.274Z
9598827 9598827 20260331074144_cXo3j NZ002K 2026-04-01T12:01:13.873Z 2026-04-09T12:46:36.530Z
9598820 9598820 20260331074010_p6EmH NZ002K 2026-04-01T12:01:13.030Z 2026-04-09T12:46:36.405Z
9597928 9597928 20260330171611_NcC6J NZ002K 2026-03-31T12:07:17.837Z 2026-04-08T12:44:20.857Z
9597889 9597889 20260330171322_AB56p NZ002K 2026-03-31T12:07:10.963Z 2026-04-08T12:44:19.871Z
9597747 9597747 20260330165534_uvBvk NZ002K 2026-03-31T12:06:57.499Z 2026-04-08T12:44:16.566Z
9597740 9597740 20260330165520_59I4d NZ002K 2026-03-31T12:06:57.127Z 2026-04-08T12:44:16.512Z
9597721 9597721 20260330165223_tzsQU NZ002K 2026-03-31T12:06:55.454Z 2026-04-08T12:44:16.088Z
9597701 9597701 20260330165055_BL53F NZ002K 2026-03-31T12:06:53.778Z 2026-04-08T12:44:15.661Z
9597691 9597691 20260330165016_wPxrN NZ002K 2026-03-31T12:06:53.027Z 2026-04-08T12:44:15.527Z
9597626 9597626 20260330164620_ci3GE NZ002K 2026-03-31T12:06:48.330Z 2026-04-08T12:44:06.775Z
9597567 9597567 20260330163620_oL4gl NZ002K 2026-03-31T12:06:38.882Z 2026-04-08T12:43:50.144Z
9597521 9597521 20260330162926_Xqrx4 NZ002K 2026-03-31T12:06:31.900Z 2026-04-08T12:43:44.798Z
9597514 9597514 20260330162725_ZT6mg NZ002K 2026-03-31T12:06:31.089Z 2026-04-08T12:43:44.631Z
9597488 9597488 20260330162528_jdEUf NZ002K 2026-03-31T12:06:28.543Z 2026-04-08T12:43:44.106Z
9597364 9597364 20260330161126_EogyG NZ002K 2026-03-31T12:06:14.484Z 2026-04-08T12:43:41.416Z
9597283 9597283 20260330155616_vf0y3 NZ002K 2026-03-31T12:06:04.366Z 2026-04-08T12:43:37.613Z
9597241 9597241 20260330154712_8cA27 NZ002K 2026-03-31T12:06:00.526Z 2026-04-08T12:43:36.822Z
9597188 9597188 20260330153333_2KGJs NZ002K 2026-03-31T12:05:52.191Z 2026-04-08T12:43:35.100Z
9597113 9597113 20260330151847_UR6A0 NZ002K 2026-03-31T12:05:41.194Z 2026-04-08T12:43:33.155Z
9597064 9597064 20260330150902_bFsuf NZ002K 2026-03-31T12:05:35.887Z 2026-04-08T12:43:31.877Z
9597033 9597033 20260330150311_y8r71 NZ002K 2026-03-31T12:05:32.292Z 2026-04-08T12:43:31.149Z
9596984 9596984 20260330145228_X2oAh NZ002K 2026-03-31T12:05:24.888Z 2026-04-08T12:43:29.529Z
9596315 9596315 20260330121858_Nnfrt NZ002K 2026-03-31T12:04:01.325Z 2026-04-08T12:42:49.390Z
9596226 9596226 20260330115209_8xk85 NZ002K 2026-03-31T12:03:48.000Z 2026-04-08T12:42:46.982Z
9596207 9596207 20260330114641_lTXtr NZ002K 2026-03-31T12:03:44.188Z 2026-04-08T12:42:44.192Z
9596165 9596165 20260330113027_QCYwi NZ002K 2026-03-31T12:03:37.856Z 2026-04-08T12:42:42.928Z
9596152 9596152 20260330112833_7gPs3 NZ002K 2026-03-31T12:03:36.652Z 2026-04-08T12:42:42.631Z
9596131 9596131 20260330112241_1h68t NZ002K 2026-03-31T12:03:33.735Z 2026-04-08T12:42:42.170Z
9596129 9596129 20260330112241_dJ04C NZ002K 2026-03-31T12:03:33.515Z 2026-04-08T12:42:42.126Z
9596022 9596022 20260330104514_EPh82 NZ002K 2026-03-31T12:03:09.881Z 2026-04-08T12:42:38.763Z
9595973 9595973 20260330102021_ZFUwA NZ002K 2026-03-31T12:03:02.082Z 2026-04-08T12:42:37.675Z
9595947 9595947 20260330101330_ntm0y NZ002K 2026-03-31T12:02:58.347Z 2026-04-08T12:42:37.023Z
9595923 9595923 20260330101101_9ouOz NZ002K 2026-03-31T12:02:51.923Z 2026-04-08T12:42:36.317Z
9595917 9595917 20260330100551_Wpdqf NZ002K 2026-03-31T12:02:50.925Z 2026-04-08T12:42:36.154Z
9595898 9595898 20260330095706_MdsUe NZ002K 2026-03-31T12:02:46.787Z 2026-04-08T12:42:35.514Z
9595763 9595763 20260330083057_nMvqt NZ002K 2026-03-31T12:02:25.582Z 2026-04-08T12:42:31.451Z
9595644 9595644 20260330073807_ZR39V NZ002K 2026-03-31T12:02:04.334Z 2026-04-08T12:42:28.154Z
9591200 9591200 20260328142246_knARe NZ002K 2026-03-29T12:04:00.298Z 2026-04-06T12:39:05.123Z
9591176 9591176 20260328140003_2CxH7 NZ002K 2026-03-29T12:03:58.024Z 2026-04-06T12:39:04.175Z
9591150 9591150 20260328135256_BOsvM NZ002K 2026-03-29T12:03:56.123Z 2026-04-06T12:39:03.236Z
9590376 9590376 20260328084158_FOp92 NZ002K 2026-03-29T12:02:30.796Z 2026-04-06T12:38:03.999Z
9590344 9590344 20260328082112_Sx2m2 NZ002K 2026-03-29T12:02:27.303Z 2026-04-06T12:38:02.297Z
9590319 9590319 20260328081431_Ko3BZ NZ002K 2026-03-29T12:02:24.988Z 2026-04-06T12:38:01.212Z
9590165 9590165 20260328071856_9mgIK NZ002K 2026-03-29T12:02:08.647Z 2026-04-06T12:37:54.510Z
9574794 9574794 20260323172153_xVHpv NZ002K 2026-03-25T12:19:42.054Z 2026-03-31T12:28:42.168Z
9568764 9568764 20260323171942_2qvxN NZ002K 2026-03-24T12:15:41.846Z 2026-03-31T12:28:41.639Z
9568569 9568569 20260323165639_lZR9E NZ002K 2026-03-24T12:15:18.345Z 2026-03-31T12:28:31.026Z
9568385 9568385 20260323163935_0tPTl NZ002K 2026-03-24T12:15:02.842Z 2026-03-24T12:24:25.448Z
9568290 9568290 20260323162727_w7mdI NZ002K 2026-03-24T12:14:50.402Z 2026-03-31T12:28:26.892Z
9568280 9568280 20260323162645_BTAyW NZ002K 2026-03-24T12:14:50.039Z 2026-03-31T12:28:26.839Z
9568225 9568225 20260323162136_uDyrS NZ002K 2026-03-24T12:14:44.974Z 2026-03-31T12:28:25.982Z
9568134 9568134 20260323161604_xztOJ NZ002K 2026-03-24T12:14:36.657Z 2026-03-31T12:28:23.426Z
9568058 9568058 20260323161056_08MI3 NZ002K 2026-03-24T12:14:28.065Z 2026-03-31T12:28:22.456Z
9568035 9568035 20260323160807_MHf3v NZ002K 2026-03-24T12:14:26.360Z 2026-03-31T12:28:21.986Z
9568012 9568012 20260323160635_TNvon NZ002K 2026-03-24T12:14:23.587Z 2026-03-31T12:28:21.604Z
9567654 9567654 20260323153845_1WRlq NZ002K 2026-03-24T12:13:55.014Z 2026-03-31T12:28:17.212Z
9567152 9567152 20260323144626_r18GB NZ002K 2026-03-24T12:13:08.074Z 2026-03-31T12:28:09.370Z
9567073 9567073 20260323143631_hHo0O NZ002K 2026-03-24T12:12:55.683Z 2026-03-31T12:28:07.910Z
9566975 9566975 20260323143115_VS830 NZ002K 2026-03-24T12:12:47.627Z 2026-03-31T12:28:06.732Z
9566916 9566916 20260323142446_b5ttO NZ002K 2026-03-24T12:12:42.590Z 2026-03-24T12:24:25.180Z
9566819 9566819 20260323141542_k3mxy NZ002K 2026-03-24T12:12:30.026Z 2026-03-31T12:28:04.730Z
9566585 9566585 20260323135557_znGF4 NZ002K 2026-03-24T12:12:09.673Z 2026-03-31T12:27:54.216Z
9566570 9566570 20260323135529_KxwMN NZ002K 2026-03-24T12:12:08.060Z 2026-03-31T12:27:53.887Z
9565328 9565328 20260323120107_5HDc2 NZ002K 2026-03-24T12:09:53.819Z 2026-03-31T12:27:33.299Z
9564982 9564982 20260323113402_UVMCh NZ002K 2026-03-24T12:09:11.817Z 2026-03-31T12:27:20.332Z
9555775 9555775 20260322075427_3G7Js NZ002K 2026-03-23T12:03:53.636Z 2026-03-30T12:28:34.686Z
9550869 9550869 20260320171927_G1PVg NZ002K 2026-03-22T12:25:48.871Z 2026-03-28T12:36:37.190Z
9550829 9550829 20260320171605_SBxOs NZ002K 2026-03-22T12:25:47.485Z 2026-03-28T12:36:36.367Z
9550784 9550784 20260320171147_1j5It NZ002K 2026-03-22T12:25:44.973Z 2026-03-28T12:36:36.047Z
9550173 9550173 20260320161448_jobus NZ002K 2026-03-22T12:24:59.926Z 2026-03-28T12:36:27.919Z
9549957 9549957 20260320155708_F7OJ0 NZ002K 2026-03-22T12:24:39.639Z 2026-03-28T12:36:24.885Z
9549947 9549947 20260320155638_lsLi9 NZ002K 2026-03-22T12:24:39.022Z 2026-03-28T12:36:24.695Z
9549885 9549885 20260320155220_28Mra NZ002K 2026-03-22T12:24:34.654Z 2026-03-28T12:36:23.240Z
9549648 9549648 20260320152220_d7cxN NZ002K 2026-03-22T12:24:20.595Z 2026-03-28T12:36:07.778Z
9548432 9548432 20260321150437_0bZ3j NZ002K 2026-03-22T12:15:25.028Z 2026-03-29T12:20:26.403Z
9544908 9544908 20260321094112_x6jBb NZ002K 2026-03-22T12:08:06.756Z 2026-03-29T12:19:35.215Z
9540488 9540488 20260319155003_l3tYJ NZ002K 2026-03-21T12:27:03.971Z 2026-03-27T12:42:22.714Z
9540396 9540396 20260319153256_lDhUC NZ002K 2026-03-21T12:26:56.997Z 2026-03-27T12:42:21.069Z
9540174 9540174 20260319140850_SI7Gh NZ002K 2026-03-21T12:26:24.637Z 2026-03-27T12:42:02.608Z
9540074 9540074 20260319124650_VFY76 NZ002K 2026-03-21T12:26:01.878Z 2026-03-27T12:41:57.811Z

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