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,127 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
9167538 9167538 20260108023551_bXrQ3 RU0004 2026-01-09T14:08:07.098Z 2026-01-16T15:11:25.204Z
8889528 8889528 20251214014532_Rsohs RU0004 2025-12-22T14:11:37.279Z 2025-12-23T14:27:43.836Z
8889008 8889008 20251214014104_qaYvt RU0004 2025-12-22T14:11:34.935Z 2025-12-23T14:27:42.834Z
8885950 8885950 20251214011629_0qKea RU0004 2025-12-22T14:11:14.200Z 2025-12-23T14:27:38.079Z
8885821 8885821 20251214011536_mTuZA RU0004 2025-12-22T14:11:13.790Z 2025-12-23T14:27:37.961Z
8874013 8874013 20251214010948_Q7nv2 RU0004 2025-12-21T14:11:07.971Z 2025-12-23T14:27:36.867Z
8873115 8873115 20251214010338_Jle39 RU0004 2025-12-21T14:10:59.511Z 2025-12-23T14:27:35.888Z
8872740 8872740 20251214010058_bCT3O RU0004 2025-12-21T14:10:55.027Z 2025-12-23T14:27:35.456Z
8872257 8872257 20251214005747_hzEd2 RU0004 2025-12-21T14:10:51.850Z 2025-12-23T14:27:34.974Z
8871636 8871636 20251214005341_2wNuE RU0004 2025-12-21T14:10:45.715Z 2025-12-23T14:27:34.299Z
8868214 8868214 20251214003019_arsrq RU0004 2025-12-21T14:10:08.864Z 2025-12-23T14:27:29.619Z
8867080 8867080 20251214001921_c5V08 RU0004 2025-12-21T14:10:02.390Z 2025-12-23T14:27:18.991Z
8865716 8865716 20251213235812_jYPqB RU0004 2025-12-21T14:09:52.703Z 2025-12-23T14:26:41.819Z
8865642 8865642 20251213235617_2PHj8 RU0004 2025-12-21T14:09:51.595Z 2025-12-23T14:26:39.904Z
8865510 8865510 20251213235418_fZLsS RU0004 2025-12-21T14:09:50.771Z 2025-12-23T14:26:38.052Z
8865196 8865196 20251213234905_0gvWv RU0004 2025-12-21T14:09:47.896Z 2025-12-23T14:26:27.962Z
8862810 8862810 20251213230526_toiaO RU0004 2025-12-21T14:09:02.075Z 2025-12-23T14:25:29.045Z
8862379 8862379 20251213225346_qm3gy RU0004 2025-12-21T14:08:49.900Z 2025-12-23T14:25:23.247Z
8861324 8861324 20251213222359_dftF5 RU0004 2025-12-21T14:08:10.811Z 2025-12-23T14:25:16.638Z
8860669 8860669 20251213220834_MucHI RU0004 2025-12-21T14:07:45.924Z 2025-12-23T14:25:13.726Z
8860486 8860486 20251213220518_ZYyOc RU0004 2025-12-21T14:07:41.340Z 2025-12-23T14:25:13.188Z
8860200 8860200 20251213215649_m5tB0 RU0004 2025-12-21T14:07:31.233Z 2025-12-23T14:25:11.732Z
8860080 8860080 20251213215223_xJZc8 RU0004 2025-12-21T14:07:27.884Z 2025-12-23T14:25:11.069Z
8859961 8859961 20251213214823_2HLjI RU0004 2025-12-21T14:07:23.268Z 2025-12-23T14:25:10.435Z
8859116 8859116 20251213212807_gJBlc RU0004 2025-12-21T14:07:01.535Z 2025-12-23T14:25:05.932Z
8753542 8753542 20251210004200_7TmO3 RU0004 2025-12-13T15:41:46.535Z 2025-12-17T15:27:52.291Z
8753132 8753132 20251210001201_hS9bs RU0004 2025-12-13T15:41:36.843Z 2025-12-17T15:27:38.672Z
8752699 8752699 20251209232852_1Nk84 RU0004 2025-12-13T15:41:00.163Z 2025-12-17T15:27:33.077Z
8752421 8752421 20251209225707_wU5u1 RU0004 2025-12-13T15:40:50.608Z 2025-12-17T15:27:28.842Z
8752278 8752278 20251209224353_dr3sE RU0004 2025-12-13T15:40:46.433Z 2025-12-17T15:27:27.318Z
8751440 8751440 20251209210916_bF0XN RU0004 2025-12-13T15:39:38.185Z 2025-12-17T15:27:19.134Z
8750935 8750935 20251209195425_t7SKu RU0004 2025-12-13T15:38:50.785Z 2025-12-17T15:27:12.259Z
8750116 8750116 20251209171805_kpZij RU0004 2025-12-13T15:37:45.311Z 2025-12-17T15:26:18.797Z
8698773 8698773 20251206164329_n4pvy RU0004 2025-12-08T14:18:54.664Z 2025-12-15T15:29:55.486Z
8694162 8694162 20251206012018_SLlld RU0004 2025-12-07T14:13:40.806Z 2025-12-14T16:07:05.941Z
8694130 8694130 20251206002432_UepfO RU0004 2025-12-07T14:13:34.786Z 2025-12-14T16:06:59.457Z
8694111 8694111 20251205234242_cBYNU RU0004 2025-12-07T14:13:30.493Z 2025-12-14T16:06:56.527Z
8694058 8694058 20251205202331_nVTDA RU0004 2025-12-07T14:13:08.359Z 2025-12-14T16:06:38.739Z
8694043 8694043 20251205194731_FmAaG RU0004 2025-12-07T14:13:02.312Z 2025-12-14T16:06:27.758Z
8689979 8689979 20251204192021_rn4aQ RU0004 2025-12-06T14:12:50.192Z 2025-12-13T16:03:38.702Z
8689905 8689905 20251204175943_wiIXw RU0004 2025-12-06T14:12:30.745Z 2025-12-13T16:03:37.427Z
8687070 8687070 20251204030622_L0b3j RU0004 2025-12-05T14:13:48.465Z 2025-12-11T14:42:00.267Z
8654255 8654255 20251130030543_EAEPg RU0004 2025-12-01T14:25:02.053Z 2025-12-08T14:55:09.447Z
8654166 8654166 20251130030158_Dgju7 RU0004 2025-12-01T14:24:55.878Z 2025-12-08T14:55:08.322Z
8654056 8654056 20251130025517_go2bA RU0004 2025-12-01T14:24:47.310Z 2025-12-08T14:55:06.789Z
8653805 8653805 20251130024155_nSBJR RU0004 2025-12-01T14:24:17.031Z 2025-12-08T14:55:02.081Z
8653629 8653629 20251130023148_0rwsc RU0004 2025-12-01T14:23:52.211Z 2025-12-08T14:54:59.913Z
8653429 8653429 20251130021553_OVmyc RU0004 2025-12-01T14:23:30.362Z 2025-12-08T14:54:56.158Z
8653327 8653327 20251130021037_iRTF2 RU0004 2025-12-01T14:23:14.787Z 2025-12-08T14:54:54.863Z
8652878 8652878 20251130014248_VoE2i RU0004 2025-12-01T14:22:27.503Z 2025-12-08T14:54:43.270Z
8652860 8652860 20251130013956_43dhe RU0004 2025-12-01T14:22:15.962Z 2025-12-08T14:54:42.683Z
8652181 8652181 20251130005326_Cb7rE RU0004 2025-12-01T14:20:53.001Z 2025-12-08T14:54:15.058Z
8651737 8651737 20251130001535_tmJRk RU0004 2025-12-01T14:19:47.806Z 2025-12-08T14:54:01.547Z
8651697 8651697 20251130001234_7KFRA RU0004 2025-12-01T14:19:42.890Z 2025-12-08T14:54:00.725Z
8651695 8651695 20251130001202_klQ2H RU0004 2025-12-01T14:19:42.488Z 2025-12-08T14:54:00.026Z
8651334 8651334 20251129232908_rIn3n RU0004 2025-12-01T14:18:48.321Z 2025-12-08T14:53:43.547Z
8650986 8650986 20251129222105_zzBag RU0004 2025-12-01T14:17:42.922Z 2025-12-08T14:53:21.884Z
8650456 8650456 20251129202415_lg8DE RU0004 2025-12-01T14:16:15.696Z 2025-12-08T14:53:00.064Z
8650307 8650307 20251129195149_4wvZx RU0004 2025-12-01T14:15:45.945Z 2025-12-08T14:52:57.312Z
8650236 8650236 20251129194518_zlcLU RU0004 2025-12-01T14:15:31.920Z 2025-12-08T14:52:56.191Z
8649839 8649839 20251129183745_j2BBD RU0004 2025-12-01T14:14:06.378Z 2025-12-08T14:52:31.561Z
8649607 8649607 20251129175628_ch4Zc RU0004 2025-12-01T14:13:18.988Z 2025-12-08T14:52:26.909Z
8646974 8646974 20251129032145_HzKku RU0004 2025-11-30T14:27:12.722Z 2025-12-07T14:58:24.439Z
8646183 8646183 20251129012025_bWPmZ RU0004 2025-11-30T14:25:22.675Z 2025-12-07T14:57:42.129Z
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

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