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,088 rows where station_code = "RU0004" 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
8689979 8689979 20251204192021_rn4aQ RU0004 2025-12-06T14:12:50.192Z 2025-12-06T14:18:00.776Z
8689905 8689905 20251204175943_wiIXw RU0004 2025-12-06T14:12:30.745Z 2025-12-06T14:18:00.754Z
8687070 8687070 20251204030622_L0b3j RU0004 2025-12-05T14:13:48.465Z 2025-12-06T14:22:28.547Z
8654255 8654255 20251130030543_EAEPg RU0004 2025-12-01T14:25:02.053Z 2025-12-06T14:48:39.499Z
8654166 8654166 20251130030158_Dgju7 RU0004 2025-12-01T14:24:55.878Z 2025-12-06T14:48:38.296Z
8654056 8654056 20251130025517_go2bA RU0004 2025-12-01T14:24:47.310Z 2025-12-06T14:48:36.599Z
8653805 8653805 20251130024155_nSBJR RU0004 2025-12-01T14:24:17.031Z 2025-12-06T14:48:32.536Z
8653629 8653629 20251130023148_0rwsc RU0004 2025-12-01T14:23:52.211Z 2025-12-06T14:48:22.292Z
8653429 8653429 20251130021553_OVmyc RU0004 2025-12-01T14:23:30.362Z 2025-12-06T14:47:58.060Z
8653327 8653327 20251130021037_iRTF2 RU0004 2025-12-01T14:23:14.787Z 2025-12-06T14:47:55.794Z
8652878 8652878 20251130014248_VoE2i RU0004 2025-12-01T14:22:27.503Z 2025-12-06T14:47:44.283Z
8652860 8652860 20251130013956_43dhe RU0004 2025-12-01T14:22:15.962Z 2025-12-06T14:47:43.725Z
8652181 8652181 20251130005326_Cb7rE RU0004 2025-12-01T14:20:53.001Z 2025-12-06T14:47:28.156Z
8651737 8651737 20251130001535_tmJRk RU0004 2025-12-01T14:19:47.806Z 2025-12-06T14:46:53.162Z
8651697 8651697 20251130001234_7KFRA RU0004 2025-12-01T14:19:42.890Z 2025-12-06T14:46:51.102Z
8651695 8651695 20251130001202_klQ2H RU0004 2025-12-01T14:19:42.488Z 2025-12-06T14:46:50.954Z
8651334 8651334 20251129232908_rIn3n RU0004 2025-12-01T14:18:48.321Z 2025-12-06T14:46:44.111Z
8650986 8650986 20251129222105_zzBag RU0004 2025-12-01T14:17:42.922Z 2025-12-06T14:46:37.750Z
8650456 8650456 20251129202415_lg8DE RU0004 2025-12-01T14:16:15.696Z 2025-12-06T14:45:56.979Z
8650307 8650307 20251129195149_4wvZx RU0004 2025-12-01T14:15:45.945Z 2025-12-06T14:45:53.860Z
8650236 8650236 20251129194518_zlcLU RU0004 2025-12-01T14:15:31.920Z 2025-12-06T14:45:52.571Z
8649839 8649839 20251129183745_j2BBD RU0004 2025-12-01T14:14:06.378Z 2025-12-06T14:45:41.096Z
8649607 8649607 20251129175628_ch4Zc RU0004 2025-12-01T14:13:18.988Z 2025-12-06T14:45:34.263Z
8646974 8646974 20251129032145_HzKku RU0004 2025-11-30T14:27:12.722Z 2025-12-06T14:56:29.059Z
8646183 8646183 20251129012025_bWPmZ RU0004 2025-11-30T14:25:22.675Z 2025-12-06T14:55:43.049Z
8636023 8636023 20251128030829_yEORI RU0004 2025-11-29T14:24:48.212Z 2025-12-06T15:02:55.336Z
8635914 8635914 20251128025839_ymVbM RU0004 2025-11-29T14:24:23.057Z 2025-12-06T15:02:53.945Z
8635820 8635820 20251128025111_LksUh RU0004 2025-11-29T14:24:12.301Z 2025-12-06T15:02:52.549Z
8635457 8635457 20251128021423_vnlYc RU0004 2025-11-29T14:23:25.808Z 2025-12-06T15:02:44.870Z
8634695 8634695 20251128011045_x3N4q RU0004 2025-11-29T14:21:56.863Z 2025-12-06T15:02:30.590Z
8634610 8634610 20251128010352_l4no3 RU0004 2025-11-29T14:21:39.723Z 2025-12-06T15:02:25.673Z
8633714 8633714 20251127234737_kT2kd RU0004 2025-11-29T14:20:07.249Z 2025-12-06T15:01:48.039Z
8633538 8633538 20251127233020_STXQg RU0004 2025-11-29T14:19:51.869Z 2025-12-06T15:01:45.329Z
8633437 8633437 20251127231829_5y3zf RU0004 2025-11-29T14:19:43.499Z 2025-12-06T15:01:43.900Z
8633371 8633371 20251127230900_wB8HV RU0004 2025-11-29T14:19:30.244Z 2025-12-06T15:01:43.245Z
8633368 8633368 20251127230835_lPaVt RU0004 2025-11-29T14:19:30.064Z 2025-12-06T15:01:43.191Z
8633124 8633124 20251127224106_3aeWQ RU0004 2025-11-29T14:19:00.770Z 2025-12-06T15:01:40.166Z
8633018 8633018 20251127222939_D21cw RU0004 2025-11-29T14:18:50.661Z 2025-12-06T15:01:38.721Z
8632871 8632871 20251127221057_DY1C1 RU0004 2025-11-29T14:18:30.874Z 2025-12-06T15:01:34.707Z
8632743 8632743 20251127214803_3ylaH RU0004 2025-11-29T14:18:13.897Z 2025-12-06T15:01:33.036Z
8631986 8631986 20251127201745_AcGJe RU0004 2025-11-29T14:16:38.474Z 2025-12-06T15:00:48.995Z
8631082 8631082 20251127181445_K7Pjg RU0004 2025-11-29T14:14:31.962Z 2025-12-06T14:59:53.201Z
8630331 8630331 20251127155307_GcE3a RU0004 2025-11-29T14:12:20.330Z 2025-12-06T14:59:02.190Z
8623922 8623922 20251127022758_opqPj RU0004 2025-11-28T14:23:06.846Z 2025-12-05T15:04:26.183Z
8623657 8623657 20251127013819_Yp2f8 RU0004 2025-11-28T14:22:20.721Z 2025-12-05T15:04:06.203Z
8623554 8623554 20251127010538_rcLiE RU0004 2025-11-28T14:22:09.057Z 2025-12-05T15:03:59.222Z
8623437 8623437 20251127003722_aigx9 RU0004 2025-11-28T14:21:45.024Z 2025-12-05T15:03:53.768Z
8623416 8623416 20251127002732_p20JV RU0004 2025-11-28T14:21:41.873Z 2025-12-05T15:03:49.845Z
8611845 8611845 20251126020209_Z280e RU0004 2025-11-27T14:22:58.192Z 2025-12-04T15:09:24.755Z
8606573 8606573 20251125191356_ER4Kb RU0004 2025-11-27T14:10:39.890Z 2025-12-04T15:06:47.113Z
8599089 8599089 20251125014544_6fQgg RU0004 2025-11-26T14:20:21.626Z 2025-12-02T15:08:19.867Z
8598687 8598687 20251125011902_sjK0D RU0004 2025-11-26T14:19:28.721Z 2025-12-02T15:08:03.457Z
8598308 8598308 20251125004840_2lXHc RU0004 2025-11-26T14:18:36.039Z 2025-12-02T15:07:51.812Z
8598285 8598285 20251125004755_nrFog RU0004 2025-11-26T14:18:34.215Z 2025-12-02T15:07:51.194Z
8597787 8597787 20251125001234_snd41 RU0004 2025-11-26T14:17:42.473Z 2025-12-02T15:07:40.718Z
8597635 8597635 20251124235348_C5hnh RU0004 2025-11-26T14:17:14.367Z 2025-12-02T15:07:38.334Z
8596911 8596911 20251124223253_3Le9R RU0004 2025-11-26T14:15:46.060Z 2025-12-02T15:07:19.966Z
8596284 8596284 20251124203854_Vck6u RU0004 2025-11-26T14:14:07.667Z 2025-12-02T15:06:52.742Z
8595803 8595803 20251124183235_XIHjp RU0004 2025-11-26T14:12:31.580Z 2025-12-02T15:06:11.532Z
8595615 8595615 20251124171413_Hp55x RU0004 2025-11-26T14:11:46.169Z 2025-12-02T15:06:02.371Z
8595526 8595526 20251124163957_tyhbk RU0004 2025-11-26T14:11:33.035Z 2025-12-02T15:06:00.811Z
8595457 8595457 20251124160058_p3Wnb RU0004 2025-11-26T14:11:08.045Z 2025-12-02T15:05:57.766Z
8590698 8590698 20251124030409_16IOY RU0004 2025-11-25T14:22:25.194Z 2025-12-02T15:12:54.588Z
8590531 8590531 20251124025053_clO7l RU0004 2025-11-25T14:22:10.759Z 2025-12-02T15:12:49.826Z
8590133 8590133 20251124022529_WIlxr RU0004 2025-11-25T14:21:27.728Z 2025-12-02T15:12:42.829Z
8589878 8589878 20251124020141_VQ04F RU0004 2025-11-25T14:20:51.823Z 2025-12-02T15:12:38.974Z
8588855 8588855 20251124003717_3Vy2q RU0004 2025-11-25T14:18:26.255Z 2025-12-02T15:11:56.965Z
8588309 8588309 20251123234113_F1QO3 RU0004 2025-11-25T14:17:14.507Z 2025-12-02T15:11:39.148Z
8587663 8587663 20251123222703_xZ2Lg RU0004 2025-11-25T14:15:51.398Z 2025-12-02T15:11:18.842Z
8586279 8586279 20251123191303_vKwMb RU0004 2025-11-25T14:12:24.606Z 2025-12-02T15:10:45.489Z
8586115 8586115 20251123184605_PJz1t RU0004 2025-11-25T14:12:05.350Z 2025-12-02T15:10:44.064Z
8585618 8585618 20251123171730_tdq9J RU0004 2025-11-25T14:10:18.287Z 2025-12-02T15:10:05.506Z
8566719 8566719 20251122015845_gsLcq RU0004 2025-11-23T14:17:09.770Z 2025-11-30T15:06:05.802Z
8566377 8566377 20251122002040_hUfQB RU0004 2025-11-23T14:16:00.533Z 2025-11-30T15:05:43.201Z
8566080 8566080 20251121224105_uyYcz RU0004 2025-11-23T14:15:01.016Z 2025-11-30T15:05:24.827Z
8566040 8566040 20251121222926_yxvt4 RU0004 2025-11-23T14:14:54.905Z 2025-11-30T15:05:20.448Z
8566022 8566022 20251121222652_Iefru RU0004 2025-11-23T14:14:53.506Z 2025-11-30T15:05:20.213Z
8566000 8566000 20251121222128_ncnvg RU0004 2025-11-23T14:14:50.312Z 2025-11-30T15:05:20.107Z
8565881 8565881 20251121215101_jIfyp RU0004 2025-11-23T14:14:25.950Z 2025-11-30T15:05:14.512Z
8564658 8564658 20251121185345_oqwyf RU0004 2025-11-23T14:11:25.168Z 2025-11-30T15:04:25.665Z
8564272 8564272 20251121181529_9Ns4p RU0004 2025-11-23T14:10:29.542Z 2025-11-30T15:04:11.225Z
8563947 8563947 20251121174048_qEck4 RU0004 2025-11-23T14:09:38.392Z 2025-11-30T15:03:56.721Z
8563612 8563612 20251121165302_egg8w RU0004 2025-11-23T14:08:50.734Z 2025-11-30T15:03:42.047Z
8563537 8563537 20251121163836_ZsIKi RU0004 2025-11-23T14:08:33.012Z 2025-11-30T15:03:40.723Z
8563535 8563535 20251121163815_j12Yq RU0004 2025-11-23T14:08:32.560Z 2025-11-30T15:03:40.699Z
8557393 8557393 20251121024831_MUvYe RU0004 2025-11-22T14:40:05.093Z 2025-11-29T14:54:34.197Z
8557320 8557320 20251121024431_pXLaM RU0004 2025-11-22T14:39:58.961Z 2025-11-29T14:54:33.817Z
8557064 8557064 20251121023015_UTv0y RU0004 2025-11-22T14:39:50.787Z 2025-11-29T14:54:33.391Z
8556899 8556899 20251121021946_Fx2qK RU0004 2025-11-22T14:39:46.452Z 2025-11-29T14:54:33.141Z
8556578 8556578 20251121020153_h81k7 RU0004 2025-11-22T14:39:37.507Z 2025-11-29T14:54:32.542Z
8534091 8534091 20251119220023_3Qwvu RU0004 2025-11-21T14:13:04.911Z 2025-11-28T14:55:35.772Z
8531698 8531698 20251119145634_GtjMP RU0004 2025-11-21T14:05:59.259Z 2025-11-28T14:53:43.191Z
8530031 8530031 20251116024438_3OPOM RU0004 2025-11-20T15:00:15.675Z 2025-11-24T15:05:02.461Z
8530029 8530029 20251116023334_97CuV RU0004 2025-11-20T15:00:12.541Z 2025-11-24T15:05:02.117Z
8530011 8530011 20251115225545_pzCN0 RU0004 2025-11-20T15:00:02.117Z 2025-11-24T15:04:55.181Z
8530004 8530004 20251115222652_Nm3zQ RU0004 2025-11-20T15:00:01.094Z 2025-11-24T15:04:54.509Z
8508015 8508015 20251118002011_FOvdT RU0004 2025-11-19T14:16:40.040Z 2025-11-26T15:07:48.914Z
8507955 8507955 20251118001406_V37ry RU0004 2025-11-19T14:16:34.008Z 2025-11-26T15:07:48.656Z
8507489 8507489 20251117232700_IOLDD RU0004 2025-11-19T14:15:22.936Z 2025-11-26T15:07:46.741Z
8507444 8507444 20251117232127_eUD10 RU0004 2025-11-19T14:15:17.787Z 2025-11-26T15:07:46.435Z

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