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

2,119 rows where station_code = "RU000Q" 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
8645764 8645764 20251128234516_bmxhW RU000Q 2025-11-30T14:24:30.008Z 2025-12-06T14:55:05.774Z
8645378 8645378 20251128213547_KyV98 RU000Q 2025-11-30T14:23:38.511Z 2025-12-06T14:54:55.120Z
8632597 8632597 20251127212323_tqtF6 RU000Q 2025-11-29T14:17:49.936Z 2025-12-06T15:01:31.152Z
8631709 8631709 20251127195021_mvbre RU000Q 2025-11-29T14:16:05.325Z 2025-12-06T15:00:37.999Z
8597724 8597724 20251125000443_pKfD6 RU000Q 2025-11-26T14:17:26.803Z 2025-12-02T15:07:40.251Z
8590605 8590605 20251124025547_pqZoI RU000Q 2025-11-25T14:22:17.008Z 2025-12-02T15:12:52.829Z
8589917 8589917 20251124020529_T3Sww RU000Q 2025-11-25T14:20:56.271Z 2025-12-02T15:12:40.091Z
8589816 8589816 20251124015651_x422U RU000Q 2025-11-25T14:20:46.190Z 2025-12-02T15:12:36.588Z
8588757 8588757 20251124002930_qoLx2 RU000Q 2025-11-25T14:18:15.591Z 2025-12-02T15:11:54.860Z
8587797 8587797 20251123224728_AHK4N RU000Q 2025-11-25T14:16:06.839Z 2025-12-02T15:11:20.142Z
8587517 8587517 20251123221134_eSAp4 RU000Q 2025-11-25T14:15:26.134Z 2025-12-02T15:11:16.659Z
8587020 8587020 20251123211405_3a7HL RU000Q 2025-11-25T14:14:24.357Z 2025-12-02T15:11:05.598Z
8529819 8529819 20251118012408_soB67 RU000Q 2025-11-20T14:45:50.317Z 2025-11-26T15:07:51.802Z
8509602 8509602 20251118030821_4QOfl RU000Q 2025-11-19T14:20:00.388Z 2025-11-26T15:07:57.088Z
8508061 8508061 20251118002425_jmFSg RU000Q 2025-11-19T14:16:43.460Z 2025-11-26T15:07:49.112Z
8507702 8507702 20251117235044_83U2U RU000Q 2025-11-19T14:15:56.811Z 2025-11-26T15:07:47.630Z
8507539 8507539 20251117233222_BL2Gw RU000Q 2025-11-19T14:15:27.398Z 2025-11-26T15:07:46.880Z
8507106 8507106 20251117224532_FklnR RU000Q 2025-11-19T14:14:26.606Z 2025-11-26T15:07:44.950Z
8506528 8506528 20251117214251_ZiYHP RU000Q 2025-11-19T14:13:07.226Z 2025-11-26T15:07:42.294Z
8503998 8503998 20251117182143_SUS7n RU000Q 2025-11-19T14:06:51.006Z 2025-11-26T15:07:06.549Z
8491439 8491439 20251116223302_Ns5Jc RU000Q 2025-11-18T14:17:30.267Z 2025-11-25T15:08:37.528Z
8469564 8469564 20251115025954_7XXl3 RU000Q 2025-11-16T14:20:37.851Z 2025-11-23T15:17:44.831Z
8469357 8469357 20251115023507_P2Sgz RU000Q 2025-11-16T14:20:00.311Z 2025-11-23T15:17:38.829Z
8465708 8465708 20251114170151_BgkBh RU000Q 2025-11-16T14:09:54.224Z 2025-11-23T15:16:57.762Z
8401729 8401729 20251108165722_vXutK RU000Q 2025-11-10T14:04:12.460Z 2025-11-17T14:58:00.176Z
8370694 8370694 20251104024653_jOsWg RU000Q 2025-11-05T14:12:00.446Z 2025-11-12T15:10:49.327Z
8370402 8370402 20251104015322_rcUPp RU000Q 2025-11-05T14:10:50.420Z 2025-11-12T15:10:38.200Z
8370251 8370251 20251104011827_wFl7y RU000Q 2025-11-05T14:10:10.991Z 2025-11-12T15:10:25.397Z
8343378 8343378 20251101021429_iX4n0 RU000Q 2025-11-02T14:40:40.797Z 2025-11-09T15:02:23.726Z
8342523 8342523 20251031235257_c4xzn RU000Q 2025-11-02T14:38:47.580Z 2025-11-09T15:00:37.020Z
8332984 8332984 20251030232011_faxfS RU000Q 2025-11-02T14:21:30.679Z 2025-11-08T15:12:45.949Z
8331429 8331429 20251101020532_76ygv RU000Q 2025-11-02T14:10:16.335Z 2025-11-09T15:02:12.154Z
8331160 8331160 20251101012502_WUxHe RU000Q 2025-11-02T14:09:14.200Z 2025-11-09T15:01:17.810Z
8331149 8331149 20251101012308_cJsEc RU000Q 2025-11-02T14:09:05.274Z 2025-11-09T15:01:16.458Z
8330930 8330930 20251101003913_z3lHC RU000Q 2025-11-02T14:08:17.259Z 2025-11-09T15:00:45.898Z
8330719 8330719 20251101000045_Gca1l RU000Q 2025-11-02T14:07:33.418Z 2025-11-09T15:00:38.332Z
8330284 8330284 20251031221026_vd28j RU000Q 2025-11-02T14:06:06.154Z 2025-11-09T15:00:23.777Z
8330248 8330248 20251031215632_csc3d RU000Q 2025-11-02T14:05:53.550Z 2025-11-09T15:00:20.638Z
8317996 8317996 20251030212900_9v3Xr RU000Q 2025-11-01T12:12:08.063Z 2025-11-08T15:11:56.392Z
8316336 8316336 20251030163704_R0Oq2 RU000Q 2025-11-01T12:05:11.919Z 2025-11-08T15:10:29.510Z
8250872 8250872 20251026195922_VE451 RU000Q 2025-10-28T12:10:02.213Z 2025-11-04T15:41:06.535Z
8161556 8161556 20251020202356_1gJ4n RU000Q 2025-10-22T12:11:22.121Z 2025-10-29T13:07:02.508Z
8161537 8161537 20251020201828_pgkKS RU000Q 2025-10-22T12:11:17.630Z 2025-10-29T13:07:02.422Z
8132504 8132504 20251018012211_IuWGK RU000Q 2025-10-19T12:10:39.661Z 2025-10-26T13:15:22.025Z
8131050 8131050 20251017204305_5s3w9 RU000Q 2025-10-19T12:06:24.722Z 2025-10-26T13:14:58.102Z
8130822 8130822 20251017183249_GAR3N RU000Q 2025-10-19T12:05:42.515Z 2025-10-26T13:14:56.452Z
8130755 8130755 20251017175342_i3FOc RU000Q 2025-10-19T12:05:32.097Z 2025-10-26T13:14:55.208Z
8120405 8120405 20251016201507_mnVco RU000Q 2025-10-18T12:16:34.121Z 2025-10-25T13:26:23.985Z
8111648 8111648 20251016013744_GBgOk RU000Q 2025-10-17T12:10:42.556Z 2025-10-24T13:16:24.299Z
8110698 8110698 20251015231448_fNKo9 RU000Q 2025-10-17T12:08:30.500Z 2025-10-24T13:16:05.084Z
8110601 8110601 20251015225247_o0U5W RU000Q 2025-10-17T12:08:22.865Z 2025-10-24T13:16:02.974Z
8110549 8110549 20251015223008_w3xsJ RU000Q 2025-10-17T12:08:08.546Z 2025-10-24T13:16:01.906Z
8110436 8110436 20251015215617_OHjQk RU000Q 2025-10-17T12:07:47.414Z 2025-10-24T13:15:57.816Z
8110062 8110062 20251015201013_fUlnL RU000Q 2025-10-17T12:06:53.411Z 2025-10-24T13:15:45.861Z
8098699 8098699 20251014013020_G2kK3 RU000Q 2025-10-15T12:16:54.195Z 2025-10-22T13:09:57.933Z
8098185 8098185 20251013232106_87Bhp RU000Q 2025-10-15T12:15:13.858Z 2025-10-22T13:09:50.726Z
8098103 8098103 20251013230243_tALu2 RU000Q 2025-10-15T12:15:05.784Z 2025-10-22T13:09:47.681Z
8098011 8098011 20251013224422_9iRSr RU000Q 2025-10-15T12:14:55.735Z 2025-10-22T13:09:46.656Z
8097915 8097915 20251013222840_BtHDt RU000Q 2025-10-15T12:14:26.422Z 2025-10-22T13:09:45.459Z
8097745 8097745 20251013213917_07ZWT RU000Q 2025-10-15T12:14:07.119Z 2025-10-22T13:09:40.303Z
8097467 8097467 20251013200816_XSDKH RU000Q 2025-10-15T12:12:54.794Z 2025-10-22T13:09:36.709Z
8092161 8092161 20251012225246_lukDr RU000Q 2025-10-14T12:09:45.996Z 2025-10-21T13:09:17.714Z
8070241 8070241 20251006191953_P4Ngo RU000Q 2025-10-08T12:07:26.579Z 2025-10-15T12:44:06.512Z
8070175 8070175 20251006183746_eKz2A RU000Q 2025-10-08T12:07:12.554Z 2025-10-15T12:44:00.469Z
8055627 8055627 20251004022631_CVlym RU000Q 2025-10-05T12:14:27.329Z 2025-10-12T12:32:22.715Z
8055130 8055130 20251004005917_sEFxH RU000Q 2025-10-05T12:12:33.420Z 2025-10-12T12:32:14.066Z
8054600 8054600 20251003213057_UUzcP RU000Q 2025-10-05T12:10:25.051Z 2025-10-12T12:32:00.306Z
8054299 8054299 20251003180750_vkEQw RU000Q 2025-10-05T12:08:58.827Z 2025-10-12T12:31:30.999Z
8050266 8050266 20251002233402_w9QYt RU000Q 2025-10-04T12:40:47.523Z 2025-10-11T12:39:58.618Z
8050127 8050127 20251002224108_wJlen RU000Q 2025-10-04T12:40:25.526Z 2025-10-11T12:39:42.197Z
8048950 8048950 20251003011959_Hz0dX RU000Q 2025-10-04T12:19:19.478Z 2025-10-11T12:40:48.494Z
8048734 8048734 20251003002955_YZDvK RU000Q 2025-10-04T12:18:32.854Z 2025-10-11T12:40:22.307Z
8048675 8048675 20251003001830_A9gc3 RU000Q 2025-10-04T12:18:21.090Z 2025-10-11T12:40:20.159Z
8048245 8048245 20251002224114_iq4Dw RU000Q 2025-10-04T12:16:46.597Z 2025-10-11T12:39:42.248Z
8048243 8048243 20251002224108_IUTBM RU000Q 2025-10-04T12:16:45.961Z 2025-10-04T12:16:45.961Z
8041258 8041258 20251002015429_S2deY RU000Q 2025-10-03T12:36:17.050Z 2025-10-10T12:40:57.710Z
7996045 7996045 20250928015349_CCOd3 RU000Q 2025-09-29T12:25:26.430Z 2025-10-05T13:07:26.841Z
7995993 7995993 20250928015032_3GSpW RU000Q 2025-09-29T12:25:20.036Z 2025-10-05T13:07:26.594Z
7994060 7994060 20250927220415_SojaJ RU000Q 2025-09-29T12:20:07.795Z 2025-10-05T13:06:48.270Z
7993056 7993056 20250927185910_QACTG RU000Q 2025-09-29T12:17:06.973Z 2025-10-05T13:06:15.229Z
7987495 7987495 20250926020752_Mcd1S RU000Q 2025-09-28T12:35:27.640Z 2025-10-04T13:07:12.688Z
7973102 7973102 20250925225315_FspM9 RU000Q 2025-09-27T12:12:22.530Z 2025-10-04T13:06:54.807Z
7961698 7961698 20250925014201_Fwb8a RU000Q 2025-09-26T12:26:28.116Z 2025-10-03T13:04:16.891Z
7961639 7961639 20250925013932_H6wsN RU000Q 2025-09-26T12:26:14.901Z 2025-10-03T13:04:16.769Z
7959649 7959649 20250924234916_SHd3B RU000Q 2025-09-26T12:23:27.312Z 2025-10-03T13:04:05.234Z
7959578 7959578 20250924234437_OnTBG RU000Q 2025-09-26T12:23:21.503Z 2025-10-03T13:04:05.008Z
7959281 7959281 20250924232437_uTz0q RU000Q 2025-09-26T12:22:43.522Z 2025-10-03T13:04:04.161Z
7947777 7947777 20250924002505_zcT7l RU000Q 2025-09-25T12:31:04.644Z 2025-10-02T13:26:53.747Z
7946864 7946864 20250923233106_YX4xT RU000Q 2025-09-25T12:29:41.526Z 2025-10-02T13:26:43.618Z
7946522 7946522 20250923231352_5sOzL RU000Q 2025-09-25T12:29:06.567Z 2025-10-02T13:26:41.199Z
7945931 7945931 20250923224018_Xd295 RU000Q 2025-09-25T12:27:56.398Z 2025-10-02T13:26:35.775Z
7945720 7945720 20250923222838_ogJBV RU000Q 2025-09-25T12:27:40.928Z 2025-10-02T13:26:34.481Z
7945193 7945193 20250923215047_3VDUf RU000Q 2025-09-25T12:26:51.892Z 2025-10-02T13:26:31.296Z
7945110 7945110 20250923214355_u1Vub RU000Q 2025-09-25T12:26:30.225Z 2025-10-02T13:26:30.833Z
7943022 7943022 20250923191942_G2flS RU000Q 2025-09-25T12:21:44.769Z 2025-10-02T13:26:05.977Z
7942710 7942710 20250923183951_HVqEW RU000Q 2025-09-25T12:20:52.482Z 2025-10-02T13:25:54.565Z
7942501 7942501 20250923181019_6aBb0 RU000Q 2025-09-25T12:20:09.599Z 2025-10-02T13:25:48.087Z
7942022 7942022 20250923164033_RToZY RU000Q 2025-09-25T12:18:19.137Z 2025-10-02T13:25:28.384Z
7935210 7935210 20250922012241_Fl6Tg RU000Q 2025-09-24T12:53:44.652Z 2025-09-30T13:03:22.782Z
7934713 7934713 20250922010612_3HCSu RU000Q 2025-09-24T12:52:37.529Z 2025-09-30T13:03:14.044Z

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