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

1,715 rows where station_code = "RU0018" 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
8658650 8658650 20251124235937_svU25 RU0018 2025-12-01T15:09:22.035Z 2025-12-02T15:07:39.220Z
8658648 8658648 20251124235638_qzkbV RU0018 2025-12-01T15:09:21.807Z 2025-12-02T15:07:38.851Z
8658646 8658646 20251124233811_coWQ7 RU0018 2025-12-01T15:09:20.517Z 2025-12-02T15:07:35.931Z
8658644 8658644 20251124213720_zYLfy RU0018 2025-12-01T15:09:12.872Z 2025-12-02T15:07:03.175Z
8658642 8658642 20251124211759_vLlDQ RU0018 2025-12-01T15:09:12.159Z 2025-12-02T15:07:01.377Z
8658639 8658639 20251124202457_Ad4vn RU0018 2025-12-01T15:09:00.241Z 2025-12-02T15:06:49.678Z
8658637 8658637 20251124201339_iv4We RU0018 2025-12-01T15:08:58.946Z 2025-12-02T15:06:48.835Z
8658635 8658635 20251124182406_J1zrB RU0018 2025-12-01T15:08:21.765Z 2025-12-02T15:06:09.231Z
8586633 8586633 20251123202316_cu15s RU0018 2025-11-25T14:13:30.985Z 2025-12-02T15:10:56.585Z
8585586 8585586 20251123171402_PLHpg RU0018 2025-11-25T14:10:13.947Z 2025-12-02T15:10:05.047Z
8551722 8551722 20251120030849_vbb0A RU0018 2025-11-22T14:31:06.977Z 2025-11-28T14:57:11.775Z
8551557 8551557 20251120025008_S4aHe RU0018 2025-11-22T14:30:52.665Z 2025-11-28T14:56:59.616Z
8539442 8539442 20251119233816_wGCs5 RU0018 2025-11-21T14:35:09.349Z 2025-11-28T14:55:48.218Z
8538935 8538935 20251119224750_r56H2 RU0018 2025-11-21T14:34:40.298Z 2025-11-28T14:55:39.999Z
8537458 8537458 20251119170809_lLzZf RU0018 2025-11-21T14:31:53.328Z 2025-11-28T14:54:02.215Z
8537438 8537438 20251119161011_YqJgv RU0018 2025-11-21T14:31:45.375Z 2025-11-28T14:53:56.615Z
8074668 8074668 20251009002412_tNKIb RU0018 2025-10-10T12:07:00.407Z 2025-10-17T12:37:36.910Z
8072409 8072409 20251008015813_4fGmC RU0018 2025-10-09T12:04:26.539Z 2025-10-16T12:48:21.795Z
8072392 8072392 20251008014752_FCX7c RU0018 2025-10-09T12:04:24.550Z 2025-10-16T12:48:21.157Z
8072236 8072236 20251008000719_c6K7L RU0018 2025-10-09T12:03:50.846Z 2025-10-16T12:48:15.623Z
8072182 8072182 20251007230724_MA2jH RU0018 2025-10-09T12:03:44.639Z 2025-10-16T12:48:12.983Z
8072112 8072112 20251007220933_vJQhL RU0018 2025-10-09T12:03:31.451Z 2025-10-16T12:48:10.149Z
8072029 8072029 20251007201044_LixhD RU0018 2025-10-09T12:03:05.627Z 2025-10-16T12:48:05.973Z
8071914 8071914 20251008184825_yzLtj RU0018 2025-10-09T12:01:46.126Z 2025-10-17T12:37:03.846Z
8071836 8071836 20251008160041_Y5eaE RU0018 2025-10-09T12:01:35.215Z 2025-10-17T12:36:59.686Z
8070624 8070624 20251007013623_1h2kz RU0018 2025-10-08T12:08:51.429Z 2025-10-15T12:44:22.525Z
8070539 8070539 20251007005047_G2Du2 RU0018 2025-10-08T12:08:42.148Z 2025-10-15T12:44:21.115Z
8070392 8070392 20251006232101_jm2c2 RU0018 2025-10-08T12:08:13.688Z 2025-10-15T12:44:15.780Z
8070246 8070246 20251006193256_v3ru7 RU0018 2025-10-08T12:07:31.112Z 2025-10-15T12:44:07.228Z
8065558 8065558 20251005015959_Jkq3J RU0018 2025-10-07T12:31:13.474Z 2025-10-13T12:33:50.289Z
8065328 8065328 20251005010257_6vACH RU0018 2025-10-07T12:30:49.641Z 2025-10-13T12:33:47.643Z
8065204 8065204 20251005003122_fo2hV RU0018 2025-10-07T12:30:23.655Z 2025-10-13T12:33:46.648Z
8065196 8065196 20251005002821_eVtwj RU0018 2025-10-07T12:30:21.413Z 2025-10-13T12:33:46.567Z
8064887 8064887 20251004225343_aaHRW RU0018 2025-10-07T12:30:01.303Z 2025-10-13T12:33:40.067Z
8064791 8064791 20251004222836_aPrK2 RU0018 2025-10-07T12:29:26.312Z 2025-10-13T12:33:33.626Z
8064586 8064586 20251004203834_fb6Z3 RU0018 2025-10-07T12:29:07.181Z 2025-10-13T12:33:28.743Z
8064571 8064571 20251004203633_GlMLJ RU0018 2025-10-07T12:29:06.204Z 2025-10-13T12:33:28.634Z
8054380 8054380 20251003185919_RTNyu RU0018 2025-10-05T12:09:20.377Z 2025-10-12T12:31:42.949Z
8054315 8054315 20251003181953_gNr3f RU0018 2025-10-05T12:09:02.383Z 2025-10-12T12:31:35.059Z
8054282 8054282 20251003180310_mRuP9 RU0018 2025-10-05T12:08:45.681Z 2025-10-12T12:31:30.621Z
8054271 8054271 20251003175603_rB7Ic RU0018 2025-10-05T12:08:41.507Z 2025-10-12T12:31:28.591Z
8054245 8054245 20251003175149_qmQZO RU0018 2025-10-05T12:08:37.536Z 2025-10-12T12:31:28.014Z
8054206 8054206 20251003172922_pZ2ol RU0018 2025-10-05T12:08:29.693Z 2025-10-12T12:31:25.357Z
8054191 8054191 20251003171145_Yu42B RU0018 2025-10-05T12:08:26.931Z 2025-10-12T12:31:24.579Z
8048988 8048988 20251003012711_cwxGg RU0018 2025-10-04T12:19:27.571Z 2025-10-11T12:40:54.272Z
7984665 7984665 20250927020733_mkiZ3 RU0018 2025-09-28T12:24:38.629Z 2025-10-05T13:10:56.841Z
7984520 7984520 20250927015052_SMfxe RU0018 2025-09-28T12:24:25.078Z 2025-10-05T13:10:54.052Z
7956387 7956387 20250924184905_U25Aj RU0018 2025-09-26T12:16:53.769Z 2025-10-03T13:03:54.114Z
7956145 7956145 20250924175005_6Jqe4 RU0018 2025-09-26T12:16:08.918Z 2025-10-03T13:03:52.339Z
7949041 7949041 20250924013101_5poHI RU0018 2025-09-25T12:32:59.793Z 2025-10-02T13:27:19.052Z
7948911 7948911 20250924012511_bx2FM RU0018 2025-09-25T12:32:43.206Z 2025-10-02T13:27:17.685Z
7947729 7947729 20250924002201_O2B4N RU0018 2025-09-25T12:30:56.842Z 2025-10-02T13:26:53.297Z
7946978 7946978 20250923234122_n29ju RU0018 2025-09-25T12:29:49.742Z 2025-10-02T13:26:45.523Z
7946866 7946866 20250923233126_FojMR RU0018 2025-09-25T12:29:41.752Z 2025-10-02T13:26:43.697Z
7946494 7946494 20250923231232_tPsd3 RU0018 2025-09-25T12:29:04.818Z 2025-10-02T13:26:41.055Z
7945996 7945996 20250923224438_x5QWU RU0018 2025-09-25T12:28:14.869Z 2025-10-02T13:26:36.272Z
7945407 7945407 20250923220737_I2cVL RU0018 2025-09-25T12:27:04.947Z 2025-10-02T13:26:32.514Z
7945106 7945106 20250923214331_Y4iD3 RU0018 2025-09-25T12:26:29.548Z 2025-10-02T13:26:30.745Z
7944875 7944875 20250923212421_Wuw3r RU0018 2025-09-25T12:26:12.693Z 2025-10-02T13:26:29.453Z
7944469 7944469 20250923205718_FfFGZ RU0018 2025-09-25T12:25:21.612Z 2025-10-02T13:26:26.178Z
7013181 7013181 20250630235654_Q7ycx RU0018 2025-07-02T12:04:17.083Z 2025-07-09T12:56:29.229Z
7000199 7000199 20250628193445_cQSBR RU0018 2025-06-30T12:27:10.637Z 2025-07-06T12:43:30.840Z
7000188 7000188 20250628191027_S8y9y RU0018 2025-06-30T12:27:09.346Z 2025-07-06T12:43:30.740Z
6993007 6993007 20250629000503_a10CB RU0018 2025-06-30T12:06:21.572Z 2025-07-07T12:30:17.318Z
6992993 6992993 20250629000242_3Havw RU0018 2025-06-30T12:06:17.701Z 2025-07-07T12:30:17.253Z
6991864 6991864 20250628213745_RH75k RU0018 2025-06-30T12:01:03.377Z 2025-07-07T12:30:07.583Z
6991757 6991757 20250628204009_Lc1qd RU0018 2025-06-30T12:00:29.100Z 2025-07-07T12:30:06.510Z
6980118 6980118 20250626191014_xfnm5 RU0018 2025-06-28T12:02:22.647Z 2025-07-05T12:55:13.637Z
6976723 6976723 20250625234830_5RL6H RU0018 2025-06-27T12:09:00.115Z 2025-07-04T12:35:37.652Z
6976604 6976604 20250625232508_OTrRM RU0018 2025-06-27T12:08:32.728Z 2025-07-04T12:35:34.569Z
6976464 6976464 20250625224533_vDVDz RU0018 2025-06-27T12:07:58.401Z 2025-07-04T12:35:30.118Z
6976421 6976421 20250625223910_c7avq RU0018 2025-06-27T12:07:51.626Z 2025-07-04T12:35:28.938Z
6976100 6976100 20250625214417_gqkSE RU0018 2025-06-27T12:06:38.017Z 2025-07-04T12:35:22.786Z
6975681 6975681 20250625201343_6nseJ RU0018 2025-06-27T12:04:39.353Z 2025-07-04T12:35:13.709Z
6934385 6934385 20250620193650_gsWyS RU0018 2025-06-22T12:08:53.971Z 2025-06-29T12:36:18.754Z
6934375 6934375 20250620184316_HoJwG RU0018 2025-06-22T12:08:47.840Z 2025-06-29T12:36:18.708Z
6921023 6921023 20250619001638_8upoV RU0018 2025-06-20T12:13:41.512Z 2025-06-27T12:39:45.949Z
6919557 6919557 20250618205238_1YbFf RU0018 2025-06-20T12:09:25.123Z 2025-06-27T12:39:30.854Z
6919527 6919527 20250618203025_Qg0Ow RU0018 2025-06-20T12:09:19.601Z 2025-06-27T12:39:30.597Z
6919521 6919521 20250618202853_BBxl9 RU0018 2025-06-20T12:09:18.265Z 2025-06-27T12:39:30.543Z
6919503 6919503 20250618201452_J9htt RU0018 2025-06-20T12:09:13.350Z 2025-06-27T12:39:30.376Z
6916824 6916824 20250615195212_4VEXQ RU0018 2025-06-19T12:33:22.032Z 2025-06-24T12:59:04.521Z
6916822 6916822 20250615191035_SzXTN RU0018 2025-06-19T12:33:19.879Z 2025-06-24T12:59:04.037Z
6916820 6916820 20250615184805_tRSQT RU0018 2025-06-19T12:33:18.864Z 2025-06-24T12:59:03.831Z
6897852 6897852 20250609223849_mQcuZ RU0018 2025-06-16T12:24:58.759Z 2025-06-17T12:29:13.491Z
6878600 6878600 20250609191006_oaJy8 RU0018 2025-06-10T12:08:07.596Z 2025-06-17T12:29:05.699Z
6878560 6878560 20250609183442_ixWLo RU0018 2025-06-10T12:07:59.535Z 2025-06-17T12:29:04.608Z
6875690 6875690 20250607203927_8LhA6 RU0018 2025-06-09T12:14:29.526Z 2025-06-15T12:28:29.632Z
6875652 6875652 20250607202459_kRimc RU0018 2025-06-09T12:14:06.361Z 2025-06-15T12:28:26.978Z
6873675 6873675 20250608002024_nMuxR RU0018 2025-06-09T12:01:56.430Z 2025-06-16T12:25:14.902Z
6873666 6873666 20250607235220_wfNSY RU0018 2025-06-09T12:01:48.824Z 2025-06-16T12:25:14.054Z
6873662 6873662 20250607233446_oUTCQ RU0018 2025-06-09T12:01:47.629Z 2025-06-16T12:25:13.355Z
6873660 6873660 20250607232853_J5ZRB RU0018 2025-06-09T12:01:43.495Z 2025-06-16T12:25:13.019Z
6873652 6873652 20250607222613_39E7R RU0018 2025-06-09T12:01:34.144Z 2025-06-16T12:25:10.791Z
6873650 6873650 20250607222231_U344I RU0018 2025-06-09T12:01:33.201Z 2025-06-16T12:25:10.670Z
6873646 6873646 20250607221858_3jl9l RU0018 2025-06-09T12:01:32.136Z 2025-06-16T12:25:10.511Z
6873642 6873642 20250607221451_fV7nN RU0018 2025-06-09T12:01:30.837Z 2025-06-16T12:25:10.428Z
6873257 6873257 20250606181636_E9CB6 RU0018 2025-06-08T12:19:20.199Z 2025-06-14T12:29:44.976Z
6869218 6869218 20250607000523_wV3F1 RU0018 2025-06-08T12:03:25.039Z 2025-06-15T12:26:50.069Z
6869209 6869209 20250607000158_EXfyF RU0018 2025-06-08T12:03:21.464Z 2025-06-15T12:26:49.880Z

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