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

5,273 rows where station_code = "US001Q" 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
8688973 8688973 20251205132938_mGd2j US001Q 2025-12-06T14:06:38.019Z 2025-12-06T14:06:38.019Z
8688965 8688965 20251205132445_2KcUZ US001Q 2025-12-06T14:06:30.977Z 2025-12-06T14:06:30.977Z
8688869 8688869 20251205130429_vdjFl US001Q 2025-12-06T14:06:09.636Z 2025-12-06T14:06:09.636Z
8688701 8688701 20251205122751_GjBHl US001Q 2025-12-06T14:05:27.593Z 2025-12-06T14:05:27.593Z
8688549 8688549 20251205115827_k8ZY9 US001Q 2025-12-06T14:04:54.763Z 2025-12-06T14:04:54.763Z
8688534 8688534 20251205115652_gQmax US001Q 2025-12-06T14:04:51.483Z 2025-12-06T14:04:51.483Z
8688461 8688461 20251205113619_A6PYb US001Q 2025-12-06T14:04:40.329Z 2025-12-06T14:04:40.329Z
8688423 8688423 20251205112726_0JYoM US001Q 2025-12-06T14:04:31.189Z 2025-12-06T14:04:31.189Z
8688345 8688345 20251205110853_3zREP US001Q 2025-12-06T14:04:09.439Z 2025-12-06T14:04:09.439Z
8688327 8688327 20251205110635_is3a8 US001Q 2025-12-06T14:04:06.322Z 2025-12-06T14:04:06.322Z
8688302 8688302 20251205110237_TCaYn US001Q 2025-12-06T14:04:02.408Z 2025-12-06T14:04:02.408Z
8688240 8688240 20251205105050_XkCJD US001Q 2025-12-06T14:03:45.070Z 2025-12-06T14:03:45.070Z
8688064 8688064 20251205101022_0IiM2 US001Q 2025-12-06T14:02:58.511Z 2025-12-06T14:02:58.511Z
8687841 8687841 20251205091748_InJAI US001Q 2025-12-06T14:01:59.099Z 2025-12-06T14:01:59.099Z
8687702 8687702 20251205083548_Td7k0 US001Q 2025-12-06T14:01:26.304Z 2025-12-06T14:01:26.304Z
8687599 8687599 20251205075601_yd2Vf US001Q 2025-12-06T14:00:55.949Z 2025-12-06T14:00:55.949Z
8684319 8684319 20251204120403_B4r7h US001Q 2025-12-05T14:02:42.239Z 2025-12-06T14:18:00.475Z
8683871 8683871 20251204090730_3u9j1 US001Q 2025-12-05T14:00:57.621Z 2025-12-06T14:18:00.356Z
8683847 8683847 20251204085826_1YNgH US001Q 2025-12-05T14:00:51.658Z 2025-12-06T14:18:00.349Z
8683834 8683834 20251204085232_HUWwo US001Q 2025-12-05T14:00:50.327Z 2025-12-06T14:18:00.345Z
8683831 8683831 20251204085204_ruUAM US001Q 2025-12-05T14:00:49.860Z 2025-12-06T14:18:00.344Z
8683824 8683824 20251204084630_ffIHc US001Q 2025-12-05T14:00:48.410Z 2025-12-06T14:18:00.342Z
8683711 8683711 20251204070615_lwRO3 US001Q 2025-12-05T14:00:18.171Z 2025-12-06T14:18:00.309Z
8677093 8677093 20251202064809_Mrq9k US001Q 2025-12-03T14:26:17.093Z 2025-12-06T14:35:34.513Z
8671256 8671256 20251201114718_DxPGy US001Q 2025-12-03T14:11:56.043Z 2025-12-06T14:30:49.251Z
8671033 8671033 20251201110556_0b724 US001Q 2025-12-03T14:11:08.256Z 2025-12-06T14:30:40.577Z
8670840 8670840 20251201102722_N2hLD US001Q 2025-12-03T14:10:30.711Z 2025-12-06T14:30:26.834Z
8670148 8670148 20251202133800_5MJSV US001Q 2025-12-03T14:07:03.207Z 2025-12-06T14:24:43.227Z
8670134 8670134 20251202131804_jtLiv US001Q 2025-12-03T14:07:00.923Z 2025-12-06T14:24:38.417Z
8670126 8670126 20251202131541_VvA1B US001Q 2025-12-03T14:06:59.545Z 2025-12-06T14:24:37.873Z
8670104 8670104 20251202130857_AwjU3 US001Q 2025-12-03T14:06:55.456Z 2025-12-06T14:24:36.611Z
8670021 8670021 20251202124626_wHQIV US001Q 2025-12-03T14:06:30.679Z 2025-12-06T14:24:31.001Z
8669962 8669962 20251202123726_b1mB3 US001Q 2025-12-03T14:06:12.516Z 2025-12-06T14:24:28.697Z
8669959 8669959 20251202123610_wVJ26 US001Q 2025-12-03T14:06:11.777Z 2025-12-06T14:24:28.560Z
8669908 8669908 20251202122520_AfbhI US001Q 2025-12-03T14:06:00.500Z 2025-12-06T14:24:26.661Z
8669895 8669895 20251202122343_8zLOu US001Q 2025-12-03T14:05:57.403Z 2025-12-06T14:24:25.334Z
8669833 8669833 20251202121441_rEgdu US001Q 2025-12-03T14:05:45.036Z 2025-12-06T14:24:22.490Z
8669733 8669733 20251202120633_4Se9l US001Q 2025-12-03T14:05:18.870Z 2025-12-06T14:24:17.832Z
8669641 8669641 20251202114841_V0Fbf US001Q 2025-12-03T14:04:47.550Z 2025-12-06T14:24:12.440Z
8669631 8669631 20251202114559_u4Jgp US001Q 2025-12-03T14:04:45.610Z 2025-12-06T14:24:07.746Z
8669544 8669544 20251202112908_C2g3z US001Q 2025-12-03T14:04:27.959Z 2025-12-06T14:24:00.596Z
8669498 8669498 20251202112144_6vW7V US001Q 2025-12-03T14:04:10.464Z 2025-12-06T14:23:58.235Z
8669486 8669486 20251202112036_15AGw US001Q 2025-12-03T14:04:07.920Z 2025-12-06T14:23:57.677Z
8669369 8669369 20251202110028_gar3v US001Q 2025-12-03T14:03:28.672Z 2025-12-06T14:23:50.734Z
8669249 8669249 20251202103955_W6irt US001Q 2025-12-03T14:03:03.252Z 2025-12-06T14:23:44.977Z
8669152 8669152 20251202102226_zsKEa US001Q 2025-12-03T14:02:44.380Z 2025-12-06T14:23:37.940Z
8669150 8669150 20251202102209_a0bPH US001Q 2025-12-03T14:02:43.824Z 2025-12-06T14:23:37.790Z
8669077 8669077 20251202100917_DYCJv US001Q 2025-12-03T14:02:15.224Z 2025-12-06T14:23:30.832Z
8669020 8669020 20251202095404_IPkOz US001Q 2025-12-03T14:02:02.278Z 2025-12-06T14:23:26.135Z
8668807 8668807 20251202090215_IFYfm US001Q 2025-12-03T14:01:21.428Z 2025-12-06T14:23:12.413Z
8668669 8668669 20251202081726_K2Rt8 US001Q 2025-12-03T14:00:47.113Z 2025-12-06T14:23:02.050Z
8668649 8668649 20251202080911_yEQm2 US001Q 2025-12-03T14:00:42.986Z 2025-12-06T14:23:00.024Z
8668567 8668567 20251202073727_qXdUf US001Q 2025-12-03T14:00:25.393Z 2025-12-06T14:22:53.764Z
8660558 8660558 20251130130357_O7d49 US001Q 2025-12-02T14:08:16.693Z 2025-12-06T14:37:18.907Z
8660553 8660553 20251130130249_F2N4M US001Q 2025-12-02T14:08:15.741Z 2025-12-06T14:37:18.774Z
8660034 8660034 20251130114650_DFIvK US001Q 2025-12-02T14:06:18.669Z 2025-12-06T14:36:50.750Z
8659750 8659750 20251130111232_tqPEa US001Q 2025-12-02T14:05:13.414Z 2025-12-06T14:36:41.358Z
8658981 8658981 20251130091257_ZoEfK US001Q 2025-12-02T14:02:00.840Z 2025-12-06T14:36:01.587Z
8648399 8648399 20251129074349_FdcFx US001Q 2025-11-30T14:30:08.207Z 2025-12-06T14:57:36.820Z
8640132 8640132 20251129125622_aXJGN US001Q 2025-11-30T14:07:21.333Z 2025-11-30T14:07:21.333Z
8639864 8639864 20251129121742_S3gO7 US001Q 2025-11-30T14:06:18.599Z 2025-11-30T14:06:18.599Z
8639787 8639787 20251129120235_bi1vL US001Q 2025-11-30T14:06:07.693Z 2025-12-06T14:43:50.446Z
8639579 8639579 20251129112435_H22vW US001Q 2025-11-30T14:05:24.695Z 2025-11-30T14:05:24.695Z
8638879 8638879 20251129095801_crz66 US001Q 2025-11-30T14:02:41.719Z 2025-12-06T14:43:04.715Z
8638821 8638821 20251129094820_EfV6J US001Q 2025-11-30T14:02:31.468Z 2025-12-06T14:43:01.647Z
8638729 8638729 20251129093355_HxtqN US001Q 2025-11-30T14:02:00.247Z 2025-12-06T14:42:59.400Z
8638019 8638019 20251128080506_DwD86 US001Q 2025-11-29T14:28:24.981Z 2025-12-06T15:04:06.984Z
8637986 8637986 20251128074952_qW7HB US001Q 2025-11-29T14:28:22.247Z 2025-12-06T15:04:06.531Z
8637413 8637413 20251128053818_jpiVO US001Q 2025-11-29T14:27:13.262Z 2025-12-06T15:03:59.881Z
8628698 8628698 20251128130554_ptJHN US001Q 2025-11-29T14:06:59.069Z 2025-12-06T14:52:13.143Z
8628676 8628676 20251128130406_fzcFq US001Q 2025-11-29T14:06:56.786Z 2025-12-06T14:52:11.644Z
8628244 8628244 20251128123050_USXxI US001Q 2025-11-29T14:05:45.321Z 2025-12-06T14:51:38.377Z
8628157 8628157 20251128122224_Jza4C US001Q 2025-11-29T14:05:36.367Z 2025-12-06T14:51:34.631Z
8628130 8628130 20251128121725_eihTx US001Q 2025-11-29T14:05:32.067Z 2025-12-06T14:51:33.967Z
8627980 8627980 20251128115839_xI9uQ US001Q 2025-11-29T14:05:02.326Z 2025-12-06T14:51:29.795Z
8627741 8627741 20251128113424_xS2Vr US001Q 2025-11-29T14:04:25.139Z 2025-12-06T14:51:24.452Z
8627681 8627681 20251128112853_ZWoIn US001Q 2025-11-29T14:04:14.019Z 2025-12-06T14:51:23.783Z
8627526 8627526 20251128111038_L3fUF US001Q 2025-11-29T14:03:54.020Z 2025-12-06T14:51:19.686Z
8627354 8627354 20251128105304_EGydU US001Q 2025-11-29T14:03:24.599Z 2025-12-06T14:51:16.886Z
8627345 8627345 20251128105230_UzpR3 US001Q 2025-11-29T14:03:23.101Z 2025-12-06T14:51:16.800Z
8627168 8627168 20251128103206_u2Vuo US001Q 2025-11-29T14:02:52.117Z 2025-12-06T14:51:13.765Z
8627121 8627121 20251128102340_06XC6 US001Q 2025-11-29T14:02:45.150Z 2025-12-06T14:51:13.179Z
8626978 8626978 20251128100735_hXEfA US001Q 2025-11-29T14:02:12.013Z 2025-12-06T14:51:10.508Z
8626476 8626476 20251128084702_BKy4q US001Q 2025-11-29T14:00:25.839Z 2025-12-06T14:50:34.584Z
8626289 8626289 20251126084543_12sEm US001Q 2025-11-28T14:38:33.601Z 2025-12-04T15:12:10.938Z
8626054 8626054 20251126071706_Tt8va US001Q 2025-11-28T14:37:33.626Z 2025-12-04T15:11:51.072Z
8626020 8626020 20251126070237_KuUQu US001Q 2025-11-28T14:37:31.434Z 2025-12-04T15:11:50.211Z
8626006 8626006 20251126065812_8lOKc US001Q 2025-11-28T14:37:30.747Z 2025-12-04T15:11:49.902Z
8625823 8625823 20251126054251_rX5Il US001Q 2025-11-28T14:37:11.638Z 2025-12-04T15:11:36.094Z
8625818 8625818 20251126053916_7LFwm US001Q 2025-11-28T14:37:11.100Z 2025-12-04T15:11:35.838Z
8625637 8625637 20251126034931_aOig3 US001Q 2025-11-28T14:35:27.803Z 2025-12-04T15:10:16.484Z
8625595 8625595 20251126032802_RZJse US001Q 2025-11-28T14:35:18.844Z 2025-12-04T15:09:50.393Z
8625522 8625522 20251126023740_KdoFK US001Q 2025-11-28T14:34:33.050Z 2025-12-04T15:09:31.886Z
8624994 8624994 20251127073133_evy33 US001Q 2025-11-28T14:26:07.078Z 2025-12-05T15:05:36.334Z
8624917 8624917 20251127071009_o0Wcn US001Q 2025-11-28T14:25:59.502Z 2025-12-05T15:05:32.587Z
8624788 8624788 20251127063251_EWsn3 US001Q 2025-11-28T14:25:29.974Z 2025-12-05T15:05:28.386Z
8624421 8624421 20251127044523_w2ZD3 US001Q 2025-11-28T14:24:38.930Z 2025-12-05T15:05:04.751Z
8624121 8624121 20251127031245_LyQBR US001Q 2025-11-28T14:23:49.533Z 2025-12-05T15:04:45.922Z
8620815 8620815 20251126133416_8lsKh US001Q 2025-11-28T14:13:57.559Z 2025-12-05T15:02:37.636Z
8620721 8620721 20251126132400_jhSnE US001Q 2025-11-28T14:13:47.721Z 2025-12-05T15:02:35.262Z

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