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
9270496 9270496 20260128155625_jB3oL NZ002K 2026-01-29T14:12:26.823Z 2026-01-29T14:12:26.823Z
9270458 9270458 20260128155303_qIBzs NZ002K 2026-01-29T14:12:20.445Z 2026-01-29T14:12:20.445Z
9270420 9270420 20260128154803_iUa22 NZ002K 2026-01-29T14:12:13.219Z 2026-01-29T14:12:13.219Z
9270246 9270246 20260128152023_CkuUd NZ002K 2026-01-29T14:11:24.261Z 2026-01-29T14:11:24.261Z
9270181 9270181 20260128150824_Cp1Nx NZ002K 2026-01-29T14:11:13.070Z 2026-01-29T14:11:13.070Z
9270125 9270125 20260128145826_2Npm8 NZ002K 2026-01-29T14:10:56.995Z 2026-01-29T14:10:56.995Z
9269996 9269996 20260128144245_pzPgu NZ002K 2026-01-29T14:10:29.513Z 2026-01-29T14:10:29.513Z
9269864 9269864 20260128142543_y0Cs4 NZ002K 2026-01-29T14:09:55.041Z 2026-01-29T14:09:55.041Z
9269757 9269757 20260128140907_d6SDl NZ002K 2026-01-29T14:09:31.418Z 2026-01-29T14:09:31.418Z
9269680 9269680 20260128135451_eRfj7 NZ002K 2026-01-29T14:09:04.026Z 2026-01-29T14:09:04.026Z
9269577 9269577 20260128133916_gtzN1 NZ002K 2026-01-29T14:08:32.752Z 2026-01-29T14:08:32.752Z
9269529 9269529 20260128132953_LLO4F NZ002K 2026-01-29T14:08:23.501Z 2026-01-29T14:08:23.501Z
9269350 9269350 20260128130403_wXb5d NZ002K 2026-01-29T14:07:31.572Z 2026-01-29T14:07:31.572Z
9269337 9269337 20260128130321_RQd97 NZ002K 2026-01-29T14:07:29.785Z 2026-01-29T14:07:29.785Z
9269007 9269007 20260128120025_v5vbG NZ002K 2026-01-29T14:06:00.456Z 2026-01-29T14:06:00.456Z
9268688 9268688 20260128110253_rfD7u NZ002K 2026-01-29T14:04:21.792Z 2026-01-29T14:04:21.792Z
9268392 9268392 20260128100541_m3cCI NZ002K 2026-01-29T14:02:47.494Z 2026-01-29T14:02:47.494Z
9268389 9268389 20260128100539_L9tLJ NZ002K 2026-01-29T14:02:46.545Z 2026-01-29T14:02:46.545Z
9268268 9268268 20260128093610_V7jY2 NZ002K 2026-01-29T14:02:09.343Z 2026-01-29T14:02:09.343Z
9268201 9268201 20260128091857_BdZZP NZ002K 2026-01-29T14:01:39.433Z 2026-01-29T14:01:39.433Z
9268076 9268076 20260128084338_YGIgB NZ002K 2026-01-29T14:00:56.490Z 2026-01-29T14:00:56.490Z
9265554 9265554 20260127153203_RMX5L NZ002K 2026-01-28T14:10:33.380Z 2026-01-29T14:30:24.605Z
9265540 9265540 20260127153049_u0CtK NZ002K 2026-01-28T14:10:29.861Z 2026-01-29T14:30:24.602Z
9265533 9265533 20260127153034_VytHo NZ002K 2026-01-28T14:10:28.371Z 2026-01-29T14:30:24.600Z
9265499 9265499 20260127152200_g12Ku NZ002K 2026-01-28T14:10:23.151Z 2026-01-29T14:30:24.593Z
9265495 9265495 20260127152147_gWM2v NZ002K 2026-01-28T14:10:22.421Z 2026-01-29T14:30:24.592Z
9262102 9262102 20260126161039_M9hjz NZ002K 2026-01-27T14:07:33.960Z 2026-01-29T14:33:41.175Z
9261201 9261201 20260126102702_p6TeH NZ002K 2026-01-27T14:02:32.529Z 2026-01-29T14:32:04.083Z
9261191 9261191 20260126102204_Lj0Sv NZ002K 2026-01-27T14:02:26.841Z 2026-01-29T14:32:03.207Z
9261034 9261034 20260126093357_s6pic NZ002K 2026-01-27T14:01:35.569Z 2026-01-29T14:31:30.513Z
9257420 9257420 20260125133104_b3TwB NZ002K 2026-01-26T14:05:31.939Z 2026-01-29T14:37:11.407Z
9253743 9253743 20260124142053_VOHeP NZ002K 2026-01-25T14:04:13.187Z 2026-01-29T14:41:23.128Z
9253731 9253731 20260124140739_g6nYw NZ002K 2026-01-25T14:04:09.276Z 2026-01-29T14:41:21.031Z
9253622 9253622 20260124131101_LppAl NZ002K 2026-01-25T14:03:36.601Z 2026-01-29T14:41:04.561Z
9253532 9253532 20260124123309_exgqo NZ002K 2026-01-25T14:03:13.273Z 2026-01-29T14:40:56.094Z
9250258 9250258 20260123115449_R3qOa NZ002K 2026-01-24T14:02:00.386Z 2026-01-29T14:45:11.241Z
9246034 9246034 20260122160506_5w5Hk NZ002K 2026-01-23T14:04:31.650Z 2026-01-29T14:50:38.296Z
9245862 9245862 20260122150423_0r2L8 NZ002K 2026-01-23T14:03:46.845Z 2026-01-29T14:50:18.950Z
9216143 9216143 20260116115646_YFnqI NZ002K 2026-01-17T14:28:02.569Z 2026-01-24T15:15:39.441Z
9216129 9216129 20260116115435_hI9d3 NZ002K 2026-01-17T14:28:00.195Z 2026-01-24T15:15:34.689Z
9215935 9215935 20260116112639_JLa12 NZ002K 2026-01-17T14:27:17.934Z 2026-01-24T15:15:18.872Z
9215842 9215842 20260116110928_8KZxe NZ002K 2026-01-17T14:27:04.326Z 2026-01-24T15:15:15.036Z
9215816 9215816 20260116110411_UhH3X NZ002K 2026-01-17T14:27:00.060Z 2026-01-24T15:15:14.322Z
9215778 9215778 20260116110007_W2liJ NZ002K 2026-01-17T14:26:50.576Z 2026-01-24T15:15:13.090Z
9215766 9215766 20260116105935_sH3a7 NZ002K 2026-01-17T14:26:48.709Z 2026-01-24T15:15:12.826Z
9215712 9215712 20260116105034_j9hrI NZ002K 2026-01-17T14:26:39.591Z 2026-01-24T15:15:10.609Z
9215605 9215605 20260116103516_hzA0C NZ002K 2026-01-17T14:26:16.003Z 2026-01-24T15:15:04.867Z
9215512 9215512 20260116102311_cHeUx NZ002K 2026-01-17T14:25:57.404Z 2026-01-24T15:15:00.841Z
9215319 9215319 20260116095423_u0Sa2 NZ002K 2026-01-17T14:25:10.653Z 2026-01-24T15:14:41.079Z
9215312 9215312 20260116095354_Y9TgM NZ002K 2026-01-17T14:25:09.826Z 2026-01-24T15:14:40.970Z
9215013 9215013 20260116085944_wDjva NZ002K 2026-01-17T14:24:05.770Z 2026-01-24T15:14:26.888Z
9211083 9211083 20260116154458_vHSFj NZ002K 2026-01-17T14:04:14.173Z 2026-01-25T14:57:19.626Z
9211074 9211074 20260116153833_atNI0 NZ002K 2026-01-17T14:04:11.630Z 2026-01-25T14:57:19.109Z
9210988 9210988 20260116142751_LRCsd NZ002K 2026-01-17T14:03:42.853Z 2026-01-25T14:57:13.664Z
9210951 9210951 20260116141524_OXEXp NZ002K 2026-01-17T14:03:32.679Z 2026-01-25T14:57:12.631Z
9210941 9210941 20260116141314_L3Sjx NZ002K 2026-01-17T14:03:29.353Z 2026-01-25T14:57:12.422Z
9210916 9210916 20260116140627_vK6M5 NZ002K 2026-01-17T14:03:24.366Z 2026-01-25T14:57:11.678Z
9210899 9210899 20260116135525_CzRNA NZ002K 2026-01-17T14:03:21.562Z 2026-01-25T14:57:11.280Z
9210883 9210883 20260116134637_3FeiW NZ002K 2026-01-17T14:03:15.028Z 2026-01-25T14:57:10.552Z
9210869 9210869 20260116134337_uq8Mx NZ002K 2026-01-17T14:03:12.774Z 2026-01-25T14:57:10.168Z
9210852 9210852 20260116133922_zECUS NZ002K 2026-01-17T14:03:10.361Z 2026-01-25T14:57:09.639Z
9210844 9210844 20260116133415_93Wv2 NZ002K 2026-01-17T14:03:05.751Z 2026-01-25T14:57:09.450Z
9210765 9210765 20260116131347_wBV6M NZ002K 2026-01-17T14:02:43.103Z 2026-01-25T14:56:55.218Z
9210757 9210757 20260116130855_JB2kK NZ002K 2026-01-17T14:02:40.987Z 2026-01-25T14:56:54.685Z
9210742 9210742 20260116130544_3aGRp NZ002K 2026-01-17T14:02:35.598Z 2026-01-25T14:56:54.282Z
9210688 9210688 20260116125619_TCeii NZ002K 2026-01-17T14:02:21.966Z 2026-01-25T14:56:52.643Z
9210591 9210591 20260116123904_gt5f3 NZ002K 2026-01-17T14:01:54.090Z 2026-01-25T14:56:48.455Z
9210540 9210540 20260116123106_pS3EX NZ002K 2026-01-17T14:01:33.370Z 2026-01-25T14:56:46.252Z
9210504 9210504 20260116122631_uoCZr NZ002K 2026-01-17T14:01:19.215Z 2026-01-25T14:56:45.297Z
9210457 9210457 20260116122358_BTANR NZ002K 2026-01-17T14:01:06.590Z 2026-01-25T14:56:43.872Z
9210438 9210438 20260116122035_0gc4X NZ002K 2026-01-17T14:00:59.167Z 2026-01-25T14:56:43.202Z
9210303 9210303 20260116120008_R0B16 NZ002K 2026-01-17T14:00:11.008Z 2026-01-25T14:56:39.441Z
9193208 9193208 20260112091853_XIdce NZ002K 2026-01-13T14:30:41.976Z 2026-01-20T15:24:38.321Z
9191286 9191286 20260112105540_75n53 NZ002K 2026-01-13T14:24:59.758Z 2026-01-20T15:25:18.058Z
9191148 9191148 20260112103957_QTX3b NZ002K 2026-01-13T14:24:33.849Z 2026-01-20T15:25:12.164Z
9191017 9191017 20260112102747_5NHkr NZ002K 2026-01-13T14:24:13.291Z 2026-01-20T15:25:07.614Z
9190984 9190984 20260112102419_YFq86 NZ002K 2026-01-13T14:24:06.108Z 2026-01-20T15:25:06.527Z
9190766 9190766 20260112095511_S9qKn NZ002K 2026-01-13T14:23:25.454Z 2026-01-20T15:24:47.393Z
9190731 9190731 20260112094632_i13XY NZ002K 2026-01-13T14:23:18.597Z 2026-01-20T15:24:45.725Z
9190720 9190720 20260112094620_zJVeb NZ002K 2026-01-13T14:23:17.017Z 2026-01-20T15:24:45.310Z
9190666 9190666 20260112093605_JMjES NZ002K 2026-01-13T14:23:00.956Z 2026-01-20T15:24:42.733Z
9190609 9190609 20260112092912_530s7 NZ002K 2026-01-13T14:22:52.606Z 2026-01-20T15:24:40.667Z
9190421 9190421 20260112090236_n00QP NZ002K 2026-01-13T14:22:08.748Z 2026-01-20T15:24:21.914Z
9190389 9190389 20260112085742_oecHF NZ002K 2026-01-13T14:22:03.080Z 2026-01-20T15:24:20.773Z
9185175 9185175 20260111131917_j85Gs NZ002K 2026-01-12T14:22:38.752Z 2026-01-19T15:21:54.837Z
9185016 9185016 20260111125647_qp2Ow NZ002K 2026-01-12T14:22:12.065Z 2026-01-19T15:21:45.617Z
9184883 9184883 20260111123256_CTe7P NZ002K 2026-01-12T14:21:49.642Z 2026-01-19T15:21:19.990Z
9184666 9184666 20260111120644_9Z1jt NZ002K 2026-01-12T14:21:14.916Z 2026-01-19T15:21:07.698Z
9184654 9184654 20260111120502_E9Mn7 NZ002K 2026-01-12T14:21:13.644Z 2026-01-19T15:21:07.145Z
9184611 9184611 20260111115702_lIsan NZ002K 2026-01-12T14:21:08.289Z 2026-01-19T15:21:05.569Z
9184604 9184604 20260111115642_UXM3r NZ002K 2026-01-12T14:21:07.587Z 2026-01-19T15:21:05.427Z
9184445 9184445 20260111112957_TXJpf NZ002K 2026-01-12T14:20:37.937Z 2026-01-19T15:20:58.887Z
9184359 9184359 20260111111807_WAzSz NZ002K 2026-01-12T14:20:23.027Z 2026-01-19T15:20:47.666Z
9184305 9184305 20260111110938_X7GbK NZ002K 2026-01-12T14:20:14.498Z 2026-01-19T15:20:32.854Z
9184224 9184224 20260111105802_MjWAj NZ002K 2026-01-12T14:20:03.633Z 2026-01-19T15:20:28.230Z
9184003 9184003 20260111103505_23KkC NZ002K 2026-01-12T14:19:25.547Z 2026-01-19T15:20:19.532Z
9183962 9183962 20260111103119_m6R8u NZ002K 2026-01-12T14:19:18.642Z 2026-01-19T15:20:18.093Z
9183699 9183699 20260111100208_tmsDU NZ002K 2026-01-12T14:18:35.255Z 2026-01-19T15:20:08.704Z
9183675 9183675 20260111095716_WDrke NZ002K 2026-01-12T14:18:29.929Z 2026-01-19T15:20:07.718Z
9183572 9183572 20260111094622_QjIUE NZ002K 2026-01-12T14:18:12.912Z 2026-01-19T15:19:46.519Z

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