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,602 rows where station_code = "RU000F" 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
9272291 9272291 20260128012557_UmIGh RU000F 2026-01-29T14:26:20.961Z 2026-01-29T14:30:25.323Z
9248263 9248263 20260121224011_nll5c RU000F 2026-01-23T14:12:21.969Z 2026-01-29T14:57:10.894Z
9234024 9234024 20260119191925_wXCRD RU000F 2026-01-21T14:11:55.713Z 2026-01-28T14:56:59.587Z
9230114 9230114 20260119032808_mqwOC RU000F 2026-01-20T14:26:02.256Z 2026-01-27T15:04:26.167Z
9162322 9162322 20260107015756_pUUrS RU000F 2026-01-08T14:04:32.185Z 2026-01-13T15:02:01.348Z
9157479 9157479 20260105172454_E6355 RU000F 2026-01-07T14:02:12.136Z 2026-01-13T15:06:05.381Z
9147800 9147800 20260103152458_SEdSi RU000F 2026-01-05T14:29:40.184Z 2026-01-10T15:03:43.856Z
8982872 8982872 20251219204609_O0taM RU000F 2025-12-26T14:28:02.066Z 2025-12-28T15:22:22.451Z
8975580 8975580 20251219012927_X99wJ RU000F 2025-12-26T14:07:22.030Z 2025-12-28T15:17:14.103Z
8969251 8969251 20251216190910_d8Wh9 RU000F 2025-12-25T14:50:49.025Z 2025-12-25T14:50:49.025Z
8969122 8969122 20251216183902_DBE2c RU000F 2025-12-25T14:50:40.470Z 2025-12-25T14:50:40.470Z
8860375 8860375 20251213220119_yuyJC RU000F 2025-12-21T14:07:37.315Z 2025-12-23T14:25:12.539Z
8752011 8752011 20251209221432_md13D RU000F 2025-12-13T15:40:05.120Z 2025-12-17T15:27:25.072Z
8751594 8751594 20251209212848_deAaF RU000F 2025-12-13T15:39:42.051Z 2025-12-17T15:27:20.730Z
8751545 8751545 20251209212317_UjpdJ RU000F 2025-12-13T15:39:41.161Z 2025-12-17T15:27:20.276Z
8751490 8751490 20251209211526_e1oaC RU000F 2025-12-13T15:39:39.854Z 2025-12-17T15:27:19.721Z
8751239 8751239 20251209204150_kdcZ5 RU000F 2025-12-13T15:39:32.369Z 2025-12-17T15:27:16.831Z
8751202 8751202 20251209203550_Y8D0k RU000F 2025-12-13T15:39:30.841Z 2025-12-17T15:27:16.096Z
8751122 8751122 20251209202607_nsUzH RU000F 2025-12-13T15:39:21.511Z 2025-12-17T15:27:15.184Z
8751115 8751115 20251209202408_8binE RU000F 2025-12-13T15:39:16.093Z 2025-12-17T15:27:14.930Z
8751093 8751093 20251209202147_pJqqT RU000F 2025-12-13T15:39:10.033Z 2025-12-17T15:27:14.672Z
8750719 8750719 20251209191838_IHwIA RU000F 2025-12-13T15:38:40.579Z 2025-12-17T15:27:00.257Z
8750668 8750668 20251209190907_sv2VB RU000F 2025-12-13T15:38:37.931Z 2025-12-17T15:26:56.209Z
8750526 8750526 20251209184714_3m1o9 RU000F 2025-12-13T15:38:15.675Z 2025-12-17T15:26:34.089Z
8737315 8737315 20251212003453_587FV RU000F 2025-12-13T14:59:12.414Z 2025-12-20T14:25:26.655Z
8737245 8737245 20251212002316_31anK RU000F 2025-12-13T14:58:52.605Z 2025-12-20T14:25:26.209Z
8698812 8698812 20251206172757_5FbE3 RU000F 2025-12-08T14:19:02.981Z 2025-12-15T15:29:57.112Z
8698804 8698804 20251206171107_KItP0 RU000F 2025-12-08T14:19:00.994Z 2025-12-15T15:29:56.721Z
8698732 8698732 20251206161029_z8SbU RU000F 2025-12-08T14:18:46.064Z 2025-12-15T15:29:53.910Z
8694076 8694076 20251205222158_XWt5l RU000F 2025-12-07T14:13:21.806Z 2025-12-14T16:06:50.373Z
8694072 8694072 20251205221416_b0JUq RU000F 2025-12-07T14:13:18.926Z 2025-12-14T16:06:49.530Z
8694061 8694061 20251205203350_zbn2C RU000F 2025-12-07T14:13:10.873Z 2025-12-14T16:06:42.958Z
8694056 8694056 20251205201219_FsxVl RU000F 2025-12-07T14:13:06.625Z 2025-12-14T16:06:37.099Z
8694033 8694033 20251205191747_2IKA4 RU000F 2025-12-07T14:12:56.062Z 2025-12-14T16:06:21.598Z
8694024 8694024 20251205185836_ODSHm RU000F 2025-12-07T14:12:50.414Z 2025-12-14T16:06:20.224Z
8694022 8694022 20251205184330_BvmSC RU000F 2025-12-07T14:12:43.733Z 2025-12-14T16:06:19.641Z
8694011 8694011 20251205181839_cqVJg RU000F 2025-12-07T14:12:34.724Z 2025-12-14T16:06:18.241Z
8693984 8693984 20251205152217_25fuc RU000F 2025-12-07T14:12:02.403Z 2025-12-14T16:06:09.841Z
8690462 8690462 20251204234612_PY44O RU000F 2025-12-06T14:14:27.229Z 2025-12-13T16:04:07.490Z
8690107 8690107 20251204205044_B3zKt RU000F 2025-12-06T14:13:21.593Z 2025-12-13T16:03:40.354Z
8690094 8690094 20251204202417_cQXbc RU000F 2025-12-06T14:13:17.642Z 2025-12-13T16:03:39.983Z
8689984 8689984 20251204192509_fkHMW RU000F 2025-12-06T14:12:52.421Z 2025-12-13T16:03:38.796Z
8689926 8689926 20251204183210_aujqN RU000F 2025-12-06T14:12:35.494Z 2025-12-13T16:03:37.750Z
8689880 8689880 20251204174723_Fz20g RU000F 2025-12-06T14:12:26.101Z 2025-12-13T16:03:37.180Z
8689860 8689860 20251204172453_NUMRx RU000F 2025-12-06T14:12:20.880Z 2025-12-13T16:03:36.484Z
8689855 8689855 20251204172342_tS4OK RU000F 2025-12-06T14:12:20.009Z 2025-12-13T16:03:36.431Z
8689823 8689823 20251204163219_FNC3f RU000F 2025-12-06T14:12:09.853Z 2025-12-13T16:03:35.667Z
8689801 8689801 20251204150431_R0Zkw RU000F 2025-12-06T14:11:48.489Z 2025-12-13T16:03:28.326Z
8687066 8687066 20251204030216_Af3AQ RU000F 2025-12-05T14:13:47.336Z 2025-12-11T14:42:00.118Z
8687062 8687062 20251204025523_Wk6lh RU000F 2025-12-05T14:13:46.767Z 2025-12-11T14:41:59.984Z
8686647 8686647 20251203202507_2vMBr RU000F 2025-12-05T14:12:33.144Z 2025-12-11T14:41:31.380Z
8686569 8686569 20251203200223_X9OuY RU000F 2025-12-05T14:12:24.771Z 2025-12-11T14:41:29.542Z
8686560 8686560 20251203200129_oC6Zg RU000F 2025-12-05T14:12:21.988Z 2025-12-11T14:41:28.220Z
8667067 8667067 20251129161058_YRhqs RU000F 2025-12-02T14:34:32.121Z 2025-12-08T14:51:31.525Z
8654259 8654259 20251130030548_ySZUh RU000F 2025-12-01T14:25:02.838Z 2025-12-08T14:55:09.535Z
8651206 8651206 20251129230502_E96Nr RU000F 2025-12-01T14:18:23.644Z 2025-12-08T14:53:40.320Z
8650192 8650192 20251129193648_B3Til RU000F 2025-12-01T14:15:22.906Z 2025-12-08T14:52:54.829Z
8649758 8649758 20251129182049_ahY7c RU000F 2025-12-01T14:13:51.578Z 2025-12-08T14:52:29.675Z
8649737 8649737 20251129181543_AXvG1 RU000F 2025-12-01T14:13:42.799Z 2025-12-08T14:52:29.207Z
8649437 8649437 20251129172653_QGvwd RU000F 2025-12-01T14:12:33.039Z 2025-12-08T14:52:04.782Z
8649100 8649100 20251129161058_onRvv RU000F 2025-12-01T14:10:55.127Z 2025-12-01T14:35:20.529Z
8648886 8648886 20251129144201_Miy7x RU000F 2025-12-01T14:09:05.859Z 2025-12-08T14:51:22.490Z
8645258 8645258 20251128210634_bBgP5 RU000F 2025-11-30T14:23:29.723Z 2025-12-07T14:57:05.931Z
8644805 8644805 20251128195951_Y363i RU000F 2025-11-30T14:22:43.775Z 2025-12-07T14:56:44.035Z
8643715 8643715 20251128181814_ESHXh RU000F 2025-11-30T14:20:36.275Z 2025-12-07T14:56:06.928Z
8643451 8643451 20251128175827_OltRT RU000F 2025-11-30T14:20:02.471Z 2025-12-07T14:56:02.345Z
8643304 8643304 20251128174252_QtqMX RU000F 2025-11-30T14:19:52.497Z 2025-12-07T14:55:59.389Z
8642592 8642592 20251128162758_8C3MA RU000F 2025-11-30T14:18:20.417Z 2025-12-07T14:55:11.136Z
8636036 8636036 20251128030843_yXHs2 RU000F 2025-11-29T14:24:49.346Z 2025-12-06T15:02:55.462Z
8635850 8635850 20251128025341_EXw72 RU000F 2025-11-29T14:24:14.332Z 2025-12-06T15:02:52.943Z
8633378 8633378 20251127230943_yh8vH RU000F 2025-11-29T14:19:31.111Z 2025-12-06T15:01:43.332Z
8633181 8633181 20251127224916_smKwL RU000F 2025-11-29T14:19:12.065Z 2025-12-06T15:01:40.848Z
8632426 8632426 20251127210536_G74GW RU000F 2025-11-29T14:17:28.228Z 2025-12-06T15:01:17.250Z
8631918 8631918 20251127201436_SZdlc RU000F 2025-11-29T14:16:33.793Z 2025-12-06T15:00:46.414Z
8631608 8631608 20251127193208_8zdZH RU000F 2025-11-29T14:15:49.956Z 2025-12-06T15:00:25.281Z
8631018 8631018 20251127180435_EH42A RU000F 2025-11-29T14:14:25.696Z 2025-12-06T14:59:50.025Z
8630608 8630608 20251127165117_YhJT8 RU000F 2025-11-29T14:13:06.362Z 2025-12-06T14:59:14.068Z
8622213 8622213 20251126181547_XI3UX RU000F 2025-11-28T14:18:08.558Z 2025-12-05T15:02:53.579Z
8611492 8611492 20251126014741_dzmPF RU000F 2025-11-27T14:22:12.798Z 2025-12-04T15:09:21.506Z
8610170 8610170 20251126002841_0rIyn RU000F 2025-11-27T14:19:33.274Z 2025-12-04T15:08:03.136Z
8607585 8607585 20251125210427_KIcOL RU000F 2025-11-27T14:13:59.273Z 2025-12-04T15:07:04.034Z
8606973 8606973 20251125200059_ls3lr RU000F 2025-11-27T14:11:54.788Z 2025-12-04T15:06:53.135Z
8606914 8606914 20251125195331_xzjyI RU000F 2025-11-27T14:11:47.020Z 2025-12-04T15:06:52.047Z
8606414 8606414 20251125185352_XwEdZ RU000F 2025-11-27T14:10:14.666Z 2025-12-04T15:06:45.344Z
8606259 8606259 20251125182711_53YAD RU000F 2025-11-27T14:09:40.590Z 2025-12-04T15:06:43.206Z
8606192 8606192 20251125181700_tIMrL RU000F 2025-11-27T14:09:25.214Z 2025-12-04T15:06:34.249Z
8600515 8600515 20251125030318_BAgHM RU000F 2025-11-26T14:22:44.850Z 2025-12-02T15:08:45.869Z
8600484 8600484 20251125030255_DwkXO RU000F 2025-11-26T14:22:43.653Z 2025-12-02T15:08:45.755Z
8599939 8599939 20251125023134_A34Zh RU000F 2025-11-26T14:21:48.745Z 2025-12-02T15:08:32.872Z
8597459 8597459 20251124233704_92030 RU000F 2025-11-26T14:16:50.848Z 2025-12-02T15:07:33.161Z
8597155 8597155 20251124230908_6zN6W RU000F 2025-11-26T14:16:17.031Z 2025-12-02T15:07:23.720Z
8597116 8597116 20251124225808_nKjSf RU000F 2025-11-26T14:16:01.694Z 2025-12-02T15:07:23.194Z
8596913 8596913 20251124223320_BVlbw RU000F 2025-11-26T14:15:46.364Z 2025-12-02T15:07:20.093Z
8596770 8596770 20251124220324_9F1G2 RU000F 2025-11-26T14:15:16.889Z 2025-12-02T15:07:12.206Z
8596543 8596543 20251124213007_pTIoU RU000F 2025-11-26T14:14:43.854Z 2025-12-02T15:07:02.428Z
8596436 8596436 20251124210741_YJz3W RU000F 2025-11-26T14:14:33.918Z 2025-12-02T15:06:55.114Z
8596427 8596427 20251124210623_QiYKb RU000F 2025-11-26T14:14:32.653Z 2025-12-02T15:06:54.864Z
8596171 8596171 20251124201229_82AzA RU000F 2025-11-26T14:13:53.378Z 2025-12-02T15:06:48.746Z
8596086 8596086 20251124195054_ObPjW RU000F 2025-11-26T14:13:31.765Z 2025-12-02T15:06:34.096Z
8596084 8596084 20251124195003_MQd33 RU000F 2025-11-26T14:13:30.721Z 2025-12-02T15:06:34.072Z

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