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 = "NZ004R" 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
8685564 8685564 20251203150203_b13pv NZ004R 2025-12-05T14:09:11.282Z 2025-12-05T14:14:35.122Z
8685140 8685140 20251204152705_tOfQ6 NZ004R 2025-12-05T14:05:45.566Z 2025-12-05T14:05:45.566Z
8685042 8685042 20251204150511_cF3ct NZ004R 2025-12-05T14:05:28.394Z 2025-12-05T14:05:28.394Z
8685039 8685039 20251204150504_8ULLW NZ004R 2025-12-05T14:05:28.041Z 2025-12-05T14:05:28.041Z
8685032 8685032 20251204150400_3TaeC NZ004R 2025-12-05T14:05:27.577Z 2025-12-05T14:05:27.577Z
8685030 8685030 20251204150317_UQrpi NZ004R 2025-12-05T14:05:26.744Z 2025-12-05T14:05:26.744Z
8685015 8685015 20251204150135_7p2Di NZ004R 2025-12-05T14:05:19.739Z 2025-12-05T14:05:19.739Z
8685003 8685003 20251204145519_nLmOB NZ004R 2025-12-05T14:05:18.546Z 2025-12-05T14:05:18.546Z
8685000 8685000 20251204145440_JeEUf NZ004R 2025-12-05T14:05:17.998Z 2025-12-05T14:05:17.998Z
8684984 8684984 20251204145011_Q3mlq NZ004R 2025-12-05T14:05:12.261Z 2025-12-05T14:05:12.261Z
8684930 8684930 20251204143728_PJEl3 NZ004R 2025-12-05T14:05:02.344Z 2025-12-05T14:05:02.344Z
8684829 8684829 20251204141643_aoT4e NZ004R 2025-12-05T14:04:38.339Z 2025-12-05T14:04:38.339Z
8684762 8684762 20251204141051_GkP8q NZ004R 2025-12-05T14:04:32.729Z 2025-12-05T14:04:32.729Z
8684735 8684735 20251204140400_AWZMY NZ004R 2025-12-05T14:04:29.124Z 2025-12-05T14:04:29.124Z
8684722 8684722 20251204140000_T3QCX NZ004R 2025-12-05T14:04:27.326Z 2025-12-05T14:04:27.326Z
8684602 8684602 20251204132201_gXUk3 NZ004R 2025-12-05T14:04:01.078Z 2025-12-05T14:04:01.078Z
8684593 8684593 20251204132022_7MR4J NZ004R 2025-12-05T14:03:59.450Z 2025-12-05T14:03:59.450Z
8684565 8684565 20251204131515_stFWs NZ004R 2025-12-05T14:03:46.135Z 2025-12-05T14:03:46.135Z
8684542 8684542 20251204130751_Pc0U6 NZ004R 2025-12-05T14:03:39.942Z 2025-12-05T14:03:39.942Z
8684392 8684392 20251204122633_is3Lt NZ004R 2025-12-05T14:02:54.665Z 2025-12-05T14:02:54.665Z
8684381 8684381 20251204122348_6pFNG NZ004R 2025-12-05T14:02:52.358Z 2025-12-05T14:02:52.358Z
8684376 8684376 20251204122223_iu8Fd NZ004R 2025-12-05T14:02:51.192Z 2025-12-05T14:02:51.192Z
8684366 8684366 20251204122101_d77Q7 NZ004R 2025-12-05T14:02:49.565Z 2025-12-05T14:02:49.565Z
8684214 8684214 20251204112937_093a6 NZ004R 2025-12-05T14:02:11.482Z 2025-12-05T14:02:11.482Z
8684190 8684190 20251204111909_W85lI NZ004R 2025-12-05T14:02:08.801Z 2025-12-05T14:02:08.801Z
8684162 8684162 20251204110248_2K5st NZ004R 2025-12-05T14:02:04.150Z 2025-12-05T14:02:04.150Z
8684065 8684065 20251204103046_qtId3 NZ004R 2025-12-05T14:01:42.406Z 2025-12-05T14:01:42.406Z
8684039 8684039 20251204102534_q9yuC NZ004R 2025-12-05T14:01:36.351Z 2025-12-05T14:01:36.351Z
8678210 8678210 20251203152751_3eTHN NZ004R 2025-12-04T14:03:52.101Z 2025-12-05T14:14:35.150Z
8678199 8678199 20251203152505_MIjaD NZ004R 2025-12-04T14:03:47.557Z 2025-12-05T14:14:35.148Z
8678150 8678150 20251203150410_RX7Ed NZ004R 2025-12-04T14:03:38.911Z 2025-12-05T14:14:35.125Z
8678139 8678139 20251203150203_Z73Jh NZ004R 2025-12-04T14:03:37.885Z 2025-12-05T14:14:35.120Z
8678115 8678115 20251203145228_Y8HhR NZ004R 2025-12-04T14:03:34.148Z 2025-12-05T14:14:35.110Z
8678108 8678108 20251203144810_dCjnH NZ004R 2025-12-04T14:03:33.448Z 2025-12-05T14:14:35.105Z
8678102 8678102 20251203144756_ZZGLa NZ004R 2025-12-04T14:03:33.016Z 2025-12-05T14:14:35.105Z
8677996 8677996 20251203135829_wZCIG NZ004R 2025-12-04T14:03:10.705Z 2025-12-05T14:14:35.042Z
8672693 8672693 20251201150851_qhU0U NZ004R 2025-12-03T14:16:10.479Z 2025-12-05T14:25:38.845Z
8672601 8672601 20251201145326_l9wJi NZ004R 2025-12-03T14:15:58.599Z 2025-12-05T14:25:36.045Z
8668957 8668957 20251202094029_wVwKE NZ004R 2025-12-03T14:01:44.065Z 2025-12-05T14:16:23.785Z
8661396 8661396 20251130151600_yvSey NZ004R 2025-12-02T14:11:18.494Z 2025-12-05T14:31:59.670Z
8661272 8661272 20251130150440_SOnNl NZ004R 2025-12-02T14:10:59.534Z 2025-12-05T14:31:55.641Z
8660827 8660827 20251130135819_lGGFn NZ004R 2025-12-02T14:09:19.414Z 2025-12-05T14:31:27.323Z
8660721 8660721 20251130133915_pfXv3 NZ004R 2025-12-02T14:08:59.066Z 2025-12-05T14:31:21.126Z
8660626 8660626 20251130131821_WtpGq NZ004R 2025-12-02T14:08:34.984Z 2025-12-05T14:31:17.056Z
8660380 8660380 20251130124337_6h4dz NZ004R 2025-12-02T14:07:41.789Z 2025-12-05T14:31:07.805Z
8660290 8660290 20251130122412_qK1EB NZ004R 2025-12-02T14:07:14.295Z 2025-12-05T14:31:03.105Z
8660207 8660207 20251130120450_V3Gz9 NZ004R 2025-12-02T14:06:54.750Z 2025-12-05T14:30:48.878Z
8659962 8659962 20251130113314_m22Ep NZ004R 2025-12-02T14:05:55.348Z 2025-12-05T14:30:38.255Z
8659793 8659793 20251130111602_bp25E NZ004R 2025-12-02T14:05:19.645Z 2025-12-05T14:30:31.330Z
8659632 8659632 20251130105734_DmG29 NZ004R 2025-12-02T14:04:41.118Z 2025-12-05T14:30:25.818Z
8659297 8659297 20251130100500_uGe05 NZ004R 2025-12-02T14:03:24.527Z 2025-12-05T14:30:00.616Z
8659107 8659107 20251130093447_RfT8Z NZ004R 2025-12-02T14:02:35.691Z 2025-12-05T14:29:53.160Z
8642153 8642153 20251128153520_Gs4Lb NZ004R 2025-11-30T14:17:37.312Z 2025-12-05T14:48:56.498Z
8642106 8642106 20251128153215_gJhuy NZ004R 2025-11-30T14:17:24.040Z 2025-12-05T14:48:55.825Z
8642099 8642099 20251128153125_h1o56 NZ004R 2025-11-30T14:17:23.246Z 2025-12-05T14:48:55.654Z
8642094 8642094 20251128153111_3DBGb NZ004R 2025-11-30T14:17:21.965Z 2025-12-05T14:48:55.603Z
8642060 8642060 20251128152827_1O9zG NZ004R 2025-11-30T14:17:18.060Z 2025-12-05T14:48:54.975Z
8641864 8641864 20251128151720_KQdxT NZ004R 2025-11-30T14:17:05.384Z 2025-12-05T14:48:52.493Z
8641486 8641486 20251128145556_Iu3P3 NZ004R 2025-11-30T14:16:27.596Z 2025-12-05T14:48:41.778Z
8641279 8641279 20251128142057_cfItT NZ004R 2025-11-30T14:15:23.000Z 2025-12-05T14:48:07.168Z
8641164 8641164 20251128135941_XTjfh NZ004R 2025-11-30T14:14:38.659Z 2025-12-05T14:47:58.988Z
8641037 8641037 20251128132253_KUxbd NZ004R 2025-11-30T14:13:42.895Z 2025-12-05T14:47:52.484Z
8640623 8640623 20251129150938_2gIlX NZ004R 2025-11-30T14:08:58.360Z 2025-12-05T14:39:22.446Z
8640481 8640481 20251129143426_2IXfP NZ004R 2025-11-30T14:08:31.195Z 2025-11-30T14:08:31.195Z
8640399 8640399 20251129140720_IX5Z8 NZ004R 2025-11-30T14:08:16.338Z 2025-12-05T14:39:12.515Z
8640278 8640278 20251129132625_NRdWj NZ004R 2025-11-30T14:07:44.206Z 2025-12-05T14:39:07.815Z
8629909 8629909 20251128144358_NAOcY NZ004R 2025-11-29T14:09:18.083Z 2025-12-05T14:48:29.663Z
8629859 8629859 20251128144128_qK40U NZ004R 2025-11-29T14:09:14.333Z 2025-12-05T14:48:23.019Z
8629718 8629718 20251128143114_QFJw8 NZ004R 2025-11-29T14:08:55.661Z 2025-12-05T14:48:09.416Z
8629695 8629695 20251128142949_G3HsL NZ004R 2025-11-29T14:08:53.521Z 2025-12-05T14:48:09.205Z
8629634 8629634 20251128142531_liDOr NZ004R 2025-11-29T14:08:48.136Z 2025-12-05T14:48:08.369Z
8629565 8629565 20251128141847_TE4YH NZ004R 2025-11-29T14:08:42.222Z 2025-12-05T14:48:06.563Z
8629479 8629479 20251128140959_6vAV2 NZ004R 2025-11-29T14:08:28.074Z 2025-12-05T14:48:04.858Z
8629448 8629448 20251128140848_llGWL NZ004R 2025-11-29T14:08:24.068Z 2025-11-29T14:08:24.068Z
8629445 8629445 20251128140834_oNZFr NZ004R 2025-11-29T14:08:23.754Z 2025-12-05T14:48:01.058Z
8629323 8629323 20251128135941_QMry8 NZ004R 2025-11-29T14:08:16.331Z 2025-11-29T14:08:16.331Z
8629209 8629209 20251128134904_1iImK NZ004R 2025-11-29T14:08:07.985Z 2025-12-05T14:47:57.306Z
8629185 8629185 20251128134737_J5KzM NZ004R 2025-11-29T14:08:05.302Z 2025-12-05T14:47:56.925Z
8629128 8629128 20251128134418_Gg533 NZ004R 2025-11-29T14:07:52.317Z 2025-12-05T14:47:55.794Z
8628923 8628923 20251128132531_wzAzS NZ004R 2025-11-29T14:07:32.338Z 2025-12-05T14:47:52.898Z
8628914 8628914 20251128132253_Si303 NZ004R 2025-11-29T14:07:31.126Z 2025-12-05T14:47:52.471Z
8628784 8628784 20251128131028_K833h NZ004R 2025-11-29T14:07:07.224Z 2025-12-05T14:47:50.271Z
8628670 8628670 20251128130311_j32b0 NZ004R 2025-11-29T14:06:55.979Z 2025-12-05T14:47:48.323Z
8628596 8628596 20251128125920_db214 NZ004R 2025-11-29T14:06:49.612Z 2025-12-05T14:47:46.825Z
8628359 8628359 20251128123814_80Fzw NZ004R 2025-11-29T14:05:57.663Z 2025-12-05T14:47:41.535Z
8628318 8628318 20251128123401_OSGa0 NZ004R 2025-11-29T14:05:51.077Z 2025-12-05T14:47:40.874Z
8628313 8628313 20251128123354_II2V6 NZ004R 2025-11-29T14:05:50.808Z 2025-11-29T14:05:50.808Z
8628110 8628110 20251128121503_3BLwo NZ004R 2025-11-29T14:05:22.785Z 2025-12-05T14:47:14.281Z
8627919 8627919 20251128115156_2gSkc NZ004R 2025-11-29T14:04:54.819Z 2025-12-05T14:47:08.345Z
8627707 8627707 20251128113146_lN7ya NZ004R 2025-11-29T14:04:21.936Z 2025-12-05T14:47:05.191Z
8627418 8627418 20251128105633_PX3AT NZ004R 2025-11-29T14:03:29.958Z 2025-12-05T14:46:58.842Z
8627371 8627371 20251128105416_0SAQ0 NZ004R 2025-11-29T14:03:26.409Z 2025-12-05T14:46:58.263Z
8627341 8627341 20251128105151_og57A NZ004R 2025-11-29T14:03:21.946Z 2025-12-05T14:46:57.883Z
8627269 8627269 20251128104118_T2WVu NZ004R 2025-11-29T14:03:09.416Z 2025-12-05T14:46:56.513Z
8627208 8627208 20251128103710_9FI98 NZ004R 2025-11-29T14:02:58.763Z 2025-12-05T14:46:55.620Z
8626907 8626907 20251128095615_LAoTh NZ004R 2025-11-29T14:01:53.482Z 2025-12-05T14:46:23.714Z
8626742 8626742 20251128093207_fosKG NZ004R 2025-11-29T14:01:25.650Z 2025-12-05T14:46:18.087Z
8626649 8626649 20251128091503_1Uc3X NZ004R 2025-11-29T14:01:06.189Z 2025-12-05T14:46:15.444Z
8619972 8619972 20251126112628_oXbEp NZ004R 2025-11-28T14:11:11.570Z 2025-12-05T15:01:16.367Z
8619720 8619720 20251126105100_5ekfi NZ004R 2025-11-28T14:10:04.185Z 2025-12-05T15:01:05.580Z

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