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,735 rows where station_code = "RU0008" 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
9162488 9162488 20260107030602_M6y6n RU0008 2026-01-08T14:05:28.926Z 2026-01-13T15:02:13.831Z
9162470 9162470 20260107030233_JQD0Z RU0008 2026-01-08T14:05:23.431Z 2026-01-13T15:02:12.307Z
9162441 9162441 20260107025136_e5UTe RU0008 2026-01-08T14:05:10.249Z 2026-01-13T15:02:10.158Z
9162384 9162384 20260107023550_QlNpi RU0008 2026-01-08T14:04:54.820Z 2026-01-13T15:02:05.671Z
9162296 9162296 20260107014419_lg5qB RU0008 2026-01-08T14:04:21.776Z 2026-01-13T15:01:59.489Z
9162264 9162264 20260107012238_wGkQ4 RU0008 2026-01-08T14:04:04.326Z 2026-01-13T15:01:57.117Z
9074045 9074045 20251225190534_c3lR3 RU0008 2025-12-29T15:00:03.633Z 2026-01-02T15:48:06.293Z
9073957 9073957 20251225185330_6h3iN RU0008 2025-12-29T15:00:00.132Z 2026-01-02T15:48:01.781Z
9073101 9073101 20251225163616_RZE2l RU0008 2025-12-29T14:59:01.346Z 2026-01-02T15:47:44.994Z
9073050 9073050 20251225160106_LUjvK RU0008 2025-12-29T14:58:59.007Z 2026-01-02T15:47:43.672Z
9060115 9060115 20251225232756_Coubw RU0008 2025-12-29T14:28:55.202Z 2026-01-03T15:32:35.018Z
9050572 9050572 20251226223816_OB1iV RU0008 2025-12-29T14:03:48.634Z 2026-01-04T15:23:45.709Z
9023860 9023860 20251220224900_H9j2G RU0008 2025-12-27T15:10:00.819Z 2025-12-29T15:26:23.730Z
9023804 9023804 20251220222024_s6CDk RU0008 2025-12-27T15:09:45.047Z 2025-12-29T15:26:22.964Z
9023786 9023786 20251220221442_JvN2I RU0008 2025-12-27T15:09:42.431Z 2025-12-29T15:26:22.756Z
9023115 9023115 20251220192023_uX2Nz RU0008 2025-12-27T15:08:46.075Z 2025-12-29T15:26:16.408Z
9022874 9022874 20251220185132_Ds6jl RU0008 2025-12-27T15:08:40.911Z 2025-12-27T15:08:40.911Z
9022709 9022709 20251220182856_uBbrk RU0008 2025-12-27T15:08:37.363Z 2025-12-29T15:26:12.828Z
9005839 9005839 20251221033112_SC3MY RU0008 2025-12-27T14:36:02.108Z 2025-12-27T14:36:02.108Z
9005784 9005784 20251221031246_0aDm4 RU0008 2025-12-27T14:35:40.684Z 2025-12-27T14:35:40.684Z
9005662 9005662 20251221023504_9TXj9 RU0008 2025-12-27T14:35:08.389Z 2025-12-27T14:35:08.389Z
9005600 9005600 20251221021846_F48EY RU0008 2025-12-27T14:34:58.027Z 2025-12-27T14:34:58.027Z
9005437 9005437 20251221014059_BzkVv RU0008 2025-12-27T14:34:18.809Z 2025-12-27T14:34:18.809Z
9005307 9005307 20251221005611_HiPC2 RU0008 2025-12-27T14:33:58.752Z 2025-12-27T14:33:58.752Z
9005267 9005267 20251221004036_gwD9r RU0008 2025-12-27T14:33:36.018Z 2025-12-27T14:33:36.018Z
9005163 9005163 20251220235755_33IL6 RU0008 2025-12-27T14:33:18.913Z 2025-12-27T14:33:18.913Z
8994143 8994143 20251219002713_vB753 RU0008 2025-12-26T14:54:21.149Z 2025-12-27T15:28:51.776Z
8994031 8994031 20251219000836_Onxkd RU0008 2025-12-26T14:54:00.928Z 2025-12-27T15:28:47.273Z
8993959 8993959 20251219000312_eYbYC RU0008 2025-12-26T14:53:55.824Z 2025-12-27T15:28:45.582Z
8993527 8993527 20251218223159_02dvE RU0008 2025-12-26T14:53:11.524Z 2025-12-27T15:27:49.736Z
8993472 8993472 20251218221838_6VJYJ RU0008 2025-12-26T14:53:01.068Z 2025-12-27T15:27:37.951Z
8993273 8993273 20251218211514_zogmj RU0008 2025-12-26T14:52:37.483Z 2025-12-27T15:27:26.502Z
8993227 8993227 20251218210459_7aYkq RU0008 2025-12-26T14:52:25.395Z 2025-12-27T15:27:22.001Z
8993222 8993222 20251218210353_6GYvg RU0008 2025-12-26T14:52:24.915Z 2025-12-27T15:27:21.980Z
8992739 8992739 20251218194713_M5WGd RU0008 2025-12-26T14:51:38.764Z 2025-12-27T15:26:50.637Z
8992417 8992417 20251218191155_N3lPE RU0008 2025-12-26T14:51:01.555Z 2025-12-27T15:26:13.658Z
8984890 8984890 20251220001010_D25R0 RU0008 2025-12-26T14:31:29.472Z 2025-12-28T15:23:56.214Z
8984885 8984885 20251220000948_dngOc RU0008 2025-12-26T14:31:28.951Z 2025-12-28T15:23:56.042Z
8984679 8984679 20251219235044_MlHqx RU0008 2025-12-26T14:31:06.982Z 2025-12-28T15:23:53.588Z
8984333 8984333 20251219232257_3xXT0 RU0008 2025-12-26T14:30:39.577Z 2025-12-28T15:23:50.112Z
8983444 8983444 20251219215202_rN5t9 RU0008 2025-12-26T14:29:04.846Z 2025-12-27T15:17:52.405Z
8982364 8982364 20251219193446_aLXu8 RU0008 2025-12-26T14:26:53.630Z 2025-12-28T15:22:08.245Z
8982263 8982263 20251219191914_AyLWu RU0008 2025-12-26T14:26:39.497Z 2025-12-28T15:22:06.958Z
8980731 8980731 20251219150626_0OS6Q RU0008 2025-12-26T14:22:39.011Z 2025-12-28T15:20:21.075Z
8980668 8980668 20251219145100_pjHnF RU0008 2025-12-26T14:22:23.393Z 2025-12-28T15:20:14.674Z
8975936 8975936 20251219021309_3JZS5 RU0008 2025-12-26T14:08:24.520Z 2025-12-28T15:17:21.461Z
8975061 8975061 20251220031101_xtm6Z RU0008 2025-12-26T14:06:02.701Z 2025-12-29T15:22:55.827Z
8971104 8971104 20251216234235_Ry3HN RU0008 2025-12-25T14:53:36.169Z 2025-12-25T14:53:36.169Z
8970693 8970693 20251216230648_AMmPx RU0008 2025-12-25T14:52:55.559Z 2025-12-25T14:52:55.559Z
8970659 8970659 20251216230327_3aamz RU0008 2025-12-25T14:52:53.802Z 2025-12-25T14:52:53.802Z
8969367 8969367 20251216193254_Rsjeb RU0008 2025-12-25T14:50:56.390Z 2025-12-25T14:50:56.390Z
8969051 8969051 20251216182018_HARL9 RU0008 2025-12-25T14:50:17.803Z 2025-12-25T14:50:17.803Z
8968772 8968772 20251216170638_eKFrQ RU0008 2025-12-25T14:49:55.493Z 2025-12-25T14:49:55.493Z
8968681 8968681 20251216163157_vXgsJ RU0008 2025-12-25T14:49:26.440Z 2025-12-25T14:49:26.440Z
8891753 8891753 20251214020328_vb0Qr RU0008 2025-12-22T14:11:46.548Z 2025-12-23T14:27:47.136Z
8891025 8891025 20251214015759_NU34E RU0008 2025-12-22T14:11:43.549Z 2025-12-23T14:27:46.305Z
8889982 8889982 20251214014922_rM7KZ RU0008 2025-12-22T14:11:39.945Z 2025-12-23T14:27:44.808Z
8889620 8889620 20251214014613_0H2rF RU0008 2025-12-22T14:11:37.886Z 2025-12-23T14:27:44.029Z
8889425 8889425 20251214014436_U5ACF RU0008 2025-12-22T14:11:36.864Z 2025-12-23T14:27:43.669Z
8889400 8889400 20251214014416_fuoRt RU0008 2025-12-22T14:11:36.740Z 2025-12-23T14:27:43.601Z
8889241 8889241 20251214014259_b82a7 RU0008 2025-12-22T14:11:36.221Z 2025-12-23T14:27:43.349Z
8888773 8888773 20251214013920_Us1uG RU0008 2025-12-22T14:11:33.882Z 2025-12-23T14:27:42.443Z
8887081 8887081 20251214012549_4OCsk RU0008 2025-12-22T14:11:23.389Z 2025-12-23T14:27:39.772Z
8885660 8885660 20251214011423_cJTta RU0008 2025-12-22T14:11:12.083Z 2025-12-23T14:27:37.702Z
8874381 8874381 20251214011215_21Jfb RU0008 2025-12-21T14:11:10.114Z 2025-12-23T14:27:37.267Z
8873554 8873554 20251214010618_U3OiZ RU0008 2025-12-21T14:11:02.196Z 2025-12-23T14:27:36.343Z
8873186 8873186 20251214010351_kZ0rO RU0008 2025-12-21T14:10:59.756Z 2025-12-23T14:27:35.952Z
8873145 8873145 20251214010346_LAE24 RU0008 2025-12-21T14:10:59.560Z 2025-12-23T14:27:35.904Z
8871784 8871784 20251214005438_qQGpZ RU0008 2025-12-21T14:10:46.579Z 2025-12-23T14:27:34.545Z
8871289 8871289 20251214005129_WOu32 RU0008 2025-12-21T14:10:43.271Z 2025-12-23T14:27:33.803Z
8870601 8870601 20251214004637_3938J RU0008 2025-12-21T14:10:36.477Z 2025-12-21T14:17:16.341Z
8870103 8870103 20251214004331_112Ae RU0008 2025-12-21T14:10:29.857Z 2025-12-23T14:27:31.783Z
8869849 8869849 20251214004206_UWMEg RU0008 2025-12-21T14:10:27.180Z 2025-12-23T14:27:31.496Z
8869823 8869823 20251214004200_tmBK3 RU0008 2025-12-21T14:10:27.105Z 2025-12-23T14:27:31.485Z
8869632 8869632 20251214004006_1G8H7 RU0008 2025-12-21T14:10:24.986Z 2025-12-23T14:27:31.327Z
8868603 8868603 20251214003252_fvjC7 RU0008 2025-12-21T14:10:11.051Z 2025-12-23T14:27:30.158Z
8866962 8866962 20251214001809_hhcr8 RU0008 2025-12-21T14:10:01.767Z 2025-12-23T14:27:15.568Z
8866531 8866531 20251214001217_Sk11e RU0008 2025-12-21T14:09:58.848Z 2025-12-23T14:27:04.631Z
8866104 8866104 20251214000456_bslyM RU0008 2025-12-21T14:09:55.529Z 2025-12-23T14:26:51.534Z
8866085 8866085 20251214000410_YTy9d RU0008 2025-12-21T14:09:55.348Z 2025-12-23T14:26:51.295Z
8865689 8865689 20251213235733_dOpgY RU0008 2025-12-21T14:09:52.397Z 2025-12-23T14:26:41.549Z
8865525 8865525 20251213235432_aTf8n RU0008 2025-12-21T14:09:50.945Z 2025-12-23T14:26:38.169Z
8865466 8865466 20251213235334_xWdj7 RU0008 2025-12-21T14:09:50.298Z 2025-12-23T14:26:35.576Z
8864612 8864612 20251213234021_3bLUi RU0008 2025-12-21T14:09:44.156Z 2025-12-23T14:26:13.485Z
8863524 8863524 20251213231935_NCJTN RU0008 2025-12-21T14:09:23.527Z 2025-12-23T14:25:42.900Z
8863272 8863272 20251213231443_K1EMG RU0008 2025-12-21T14:09:14.805Z 2025-12-23T14:25:36.755Z
8863185 8863185 20251213231311_xVMa3 RU0008 2025-12-21T14:09:13.322Z 2025-12-23T14:25:35.101Z
8863026 8863026 20251213230956_x3v0H RU0008 2025-12-21T14:09:06.734Z 2025-12-23T14:25:31.683Z
8862564 8862564 20251213225928_3qU23 RU0008 2025-12-21T14:08:56.040Z 2025-12-23T14:25:24.296Z
8862531 8862531 20251213225806_8XX2S RU0008 2025-12-21T14:08:55.217Z 2025-12-23T14:25:24.080Z
8862450 8862450 20251213225523_33WhW RU0008 2025-12-21T14:08:52.193Z 2025-12-23T14:25:23.541Z
8862155 8862155 20251213224735_Mo2AH RU0008 2025-12-21T14:08:42.674Z 2025-12-23T14:25:22.231Z
8862061 8862061 20251213224545_61624 RU0008 2025-12-21T14:08:39.355Z 2025-12-23T14:25:22.033Z
8861862 8861862 20251213224048_axqDq RU0008 2025-12-21T14:08:33.835Z 2025-12-23T14:25:21.288Z
8790262 8790262 20251213032733_a68oN RU0008 2025-12-16T14:01:23.013Z 2025-12-23T14:16:20.529Z
8790004 8790004 20251213031614_hc2uS RU0008 2025-12-15T14:40:35.773Z 2025-12-21T14:17:38.373Z
8789357 8789357 20251213030929_T0kih RU0008 2025-12-15T14:39:40.452Z 2025-12-21T14:17:38.194Z
8789353 8789353 20251213030922_obDqR RU0008 2025-12-15T14:39:39.620Z 2025-12-21T14:17:38.191Z
8786661 8786661 20251213023315_a1hcU RU0008 2025-12-15T14:37:41.633Z 2025-12-21T14:17:36.861Z
8768557 8768557 20251213032512_jyumc RU0008 2025-12-15T14:01:29.017Z 2025-12-23T14:16:20.130Z

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