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

4,694 rows where station_code = "HR0021" 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
8828135 8828135 20251213184150_gx3fx HR0021 2025-12-18T14:29:33.257Z 2025-12-18T14:29:33.257Z
8767365 8767365 20251211195458_vi5OU HR0021 2025-12-14T15:09:18.806Z 2025-12-17T15:10:03.427Z
8756610 8756610 20251208225351_yxMPR HR0021 2025-12-13T15:50:30.381Z 2025-12-17T15:33:54.124Z
8699026 8699026 20251206201040_KLUa2 HR0021 2025-12-08T14:20:01.248Z 2025-12-15T15:30:04.474Z
8165150 8165150 20251019223828_u3qWT HR0021 2025-10-22T12:27:27.589Z 2025-10-28T13:08:04.040Z
8005554 8005554 20250929004555_RAMvD HR0021 2025-09-30T12:25:01.995Z 2025-10-07T13:00:55.675Z
7995693 7995693 20250928011902_rQnu2 HR0021 2025-09-29T12:24:30.013Z 2025-10-05T13:07:20.477Z
7906784 7906784 20250921012750_bJReo HR0021 2025-09-22T12:37:05.606Z 2025-09-29T13:05:35.304Z
7905932 7905932 20250921002534_sf9uJ HR0021 2025-09-22T12:35:54.291Z 2025-09-29T13:05:27.233Z
7896889 7896889 20250920012504_TJoUO HR0021 2025-09-21T12:40:38.372Z 2025-09-28T12:54:51.929Z
5544935 5544935 20241115174445_fRbjJ HR0021 2024-11-17T14:03:22.029Z 2024-11-24T14:25:41.321Z
5543715 5543715 20241115030336_aIYP4 HR0021 2024-11-16T14:07:03.871Z 2024-11-23T14:26:20.510Z
5543694 5543694 20241115030013_Njn23 HR0021 2024-11-16T14:07:02.342Z 2024-11-23T14:26:20.406Z
5543005 5543005 20241114175120_8PrfF HR0021 2024-11-16T14:05:15.437Z 2024-11-23T14:26:16.993Z
5542986 5542986 20241114171208_MhIAP HR0021 2024-11-16T14:05:12.224Z 2024-11-23T14:26:16.421Z
5542984 5542984 20241114170557_sSL2t HR0021 2024-11-16T14:05:11.707Z 2024-11-23T14:26:15.992Z
5542982 5542982 20241114164458_J1hlW HR0021 2024-11-16T14:05:10.405Z 2024-11-23T14:26:15.904Z
5538479 5538479 20241113035443_5pME2 HR0021 2024-11-14T14:13:31.380Z 2024-11-21T14:26:26.529Z
5538391 5538391 20241113032550_3mMRX HR0021 2024-11-14T14:13:22.232Z 2024-11-21T14:26:25.091Z
5538346 5538346 20241113031657_B0G7C HR0021 2024-11-14T14:13:17.271Z 2024-11-21T14:26:24.258Z
5538299 5538299 20241113030242_B3NFx HR0021 2024-11-14T14:13:12.332Z 2024-11-21T14:26:22.943Z
5536450 5536450 20241112180559_MShmU HR0021 2024-11-14T14:09:59.046Z 2024-11-21T14:26:01.043Z
5531783 5531783 20241112040847_JP93D HR0021 2024-11-13T14:15:54.925Z 2024-11-20T14:26:14.328Z
5531006 5531006 20241112030545_cvgxV HR0021 2024-11-13T14:15:00.140Z 2024-11-20T14:26:05.887Z
5524420 5524420 20241111040955_F2aGq HR0021 2024-11-12T14:17:17.591Z 2024-11-19T14:22:21.210Z
5524354 5524354 20241111035959_DWVts HR0021 2024-11-12T14:17:06.310Z 2024-11-19T14:22:20.480Z
5524217 5524217 20241111033504_FNj8p HR0021 2024-11-12T14:16:47.700Z 2024-11-19T14:22:18.884Z
5521719 5521719 20241110180818_vgQys HR0021 2024-11-12T14:11:53.766Z 2024-11-19T14:21:54.591Z
5517748 5517748 20241110044222_z5Wqm HR0021 2024-11-11T14:14:49.421Z 2024-11-18T14:26:38.042Z
5515141 5515141 20241109193448_F827U HR0021 2024-11-11T14:10:08.861Z 2024-11-18T14:26:24.491Z
5514978 5514978 20241109184655_Nv3WT HR0021 2024-11-11T14:09:50.366Z 2024-11-18T14:26:23.680Z
5511095 5511095 20241109042427_wEs3N HR0021 2024-11-10T14:16:14.186Z 2024-11-17T14:24:04.524Z
5510714 5510714 20241109032804_MpOQr HR0021 2024-11-10T14:15:35.598Z 2024-11-17T14:24:00.598Z
5510270 5510270 20241109021342_LSrOO HR0021 2024-11-10T14:14:55.252Z 2024-11-17T14:23:54.855Z
5509893 5509893 20241109010446_Ncby2 HR0021 2024-11-10T14:14:11.001Z 2024-11-17T14:23:50.490Z
5509764 5509764 20241109003010_SC9vr HR0021 2024-11-10T14:13:58.083Z 2024-11-17T14:23:48.932Z
5508664 5508664 20241108170904_iT2xW HR0021 2024-11-10T14:11:04.615Z 2024-11-17T14:23:27.009Z
5505312 5505312 20241108043427_K7pzV HR0021 2024-11-09T14:16:08.302Z 2024-11-16T14:28:29.942Z
5505281 5505281 20241108042509_nP628 HR0021 2024-11-09T14:16:03.842Z 2024-11-16T14:28:29.393Z
5502075 5502075 20241107171335_jewD6 HR0021 2024-11-09T14:10:54.850Z 2024-11-16T14:27:50.324Z
5502066 5502066 20241107170922_fF1ja HR0021 2024-11-09T14:10:54.344Z 2024-11-16T14:27:50.193Z
5497567 5497567 20241107040133_Mzwuh HR0021 2024-11-08T14:13:59.033Z 2024-11-15T14:25:04.736Z
5497560 5497560 20241107040049_EqP89 HR0021 2024-11-08T14:13:58.597Z 2024-11-15T14:25:04.707Z
5497549 5497549 20241107035845_zh1bR HR0021 2024-11-08T14:13:57.722Z 2024-11-15T14:25:04.693Z
5497035 5497035 20241107023156_5OaXP HR0021 2024-11-08T14:13:06.774Z 2024-11-15T14:25:01.414Z
5495722 5495722 20241106211403_naZk8 HR0021 2024-11-08T14:10:41.820Z 2024-11-15T14:24:52.733Z
5495593 5495593 20241106202810_m9JQS HR0021 2024-11-08T14:10:26.742Z 2024-11-15T14:24:51.032Z
5495581 5495581 20241106202518_qeTrk HR0021 2024-11-08T14:10:25.868Z 2024-11-15T14:24:50.976Z
5495515 5495515 20241106200614_uqZE3 HR0021 2024-11-08T14:10:19.827Z 2024-11-15T14:24:50.218Z
5495343 5495343 20241106193215_SWUHM HR0021 2024-11-08T14:10:03.924Z 2024-11-15T14:24:48.459Z
5495331 5495331 20241106193038_KHzsN HR0021 2024-11-08T14:10:01.301Z 2024-11-15T14:24:48.423Z
5495242 5495242 20241106190411_3Zvnz HR0021 2024-11-08T14:09:43.660Z 2024-11-15T14:24:47.831Z
5495202 5495202 20241106185700_WEwjg HR0021 2024-11-08T14:09:37.472Z 2024-11-15T14:24:47.450Z
5494729 5494729 20241106170624_YyMBg HR0021 2024-11-08T14:08:29.933Z 2024-11-15T14:24:42.005Z
5494674 5494674 20241106164822_DN2Fh HR0021 2024-11-08T14:08:18.857Z 2024-11-15T14:24:41.175Z
5492078 5492078 20241031212556_I1v35 HR0021 2024-11-07T14:25:10.954Z 2024-11-09T14:24:19.536Z
5492076 5492076 20241031211034_RyGYx HR0021 2024-11-07T14:25:10.531Z 2024-11-09T14:24:18.172Z
5492074 5492074 20241031201825_j9z9b HR0021 2024-11-07T14:25:09.095Z 2024-11-09T14:24:17.512Z
5492067 5492067 20241031165618_ATC3C HR0021 2024-11-07T14:25:00.570Z 2024-11-09T14:24:12.205Z
5492038 5492038 20241102182404_pfOs2 HR0021 2024-11-07T14:23:38.781Z 2024-11-11T14:22:42.200Z
5492022 5492022 20241103195941_t72U2 HR0021 2024-11-07T14:21:53.700Z 2024-11-12T14:27:58.427Z
5492020 5492020 20241103191450_wbKIF HR0021 2024-11-07T14:21:48.716Z 2024-11-12T14:27:57.226Z
5492018 5492018 20241103182029_mtgbJ HR0021 2024-11-07T14:21:41.234Z 2024-11-12T14:27:54.865Z
5491686 5491686 20241106042809_JmX3v HR0021 2024-11-07T14:16:45.557Z 2024-11-14T14:23:26.424Z
5491376 5491376 20241106030849_58nuN HR0021 2024-11-07T14:16:00.046Z 2024-11-14T14:23:25.455Z
5491268 5491268 20241106024157_NnfMF HR0021 2024-11-07T14:15:44.569Z 2024-11-14T14:23:25.017Z
5491057 5491057 20241106014640_F7ETv HR0021 2024-11-07T14:15:16.218Z 2024-11-14T14:23:23.522Z
5490963 5490963 20241106012328_1q2xd HR0021 2024-11-07T14:15:08.395Z 2024-11-14T14:23:23.023Z
5490885 5490885 20241106010454_i5D9u HR0021 2024-11-07T14:15:02.697Z 2024-11-14T14:23:22.697Z
5490843 5490843 20241106005112_8cqmu HR0021 2024-11-07T14:14:58.742Z 2024-11-14T14:23:22.586Z
5490605 5490605 20241105233657_ztSIz HR0021 2024-11-07T14:14:17.219Z 2024-11-14T14:23:20.932Z
5490381 5490381 20241105222948_2nDwY HR0021 2024-11-07T14:13:57.230Z 2024-11-14T14:23:19.270Z
5490290 5490290 20241105220308_3zIU6 HR0021 2024-11-07T14:13:49.336Z 2024-11-14T14:23:18.695Z
5490005 5490005 20241105204112_JOpns HR0021 2024-11-07T14:13:01.728Z 2024-11-14T14:23:17.102Z
5489863 5489863 20241105202123_NC3Bf HR0021 2024-11-07T14:12:51.021Z 2024-11-14T14:23:15.993Z
5489731 5489731 20241105195251_gQ0oL HR0021 2024-11-07T14:12:41.847Z 2024-11-14T14:23:15.416Z
5489171 5489171 20241105180048_oT678 HR0021 2024-11-07T14:11:24.817Z 2024-11-14T14:23:10.801Z
5485117 5485117 20241105040636_MZf2j HR0021 2024-11-06T14:17:46.954Z 2024-11-13T14:27:40.783Z
5478853 5478853 20241103042008_t2C2O HR0021 2024-11-05T14:21:53.484Z 2024-11-11T14:23:02.243Z
5474835 5474835 20241103182318_3du38 HR0021 2024-11-05T14:12:08.706Z 2024-11-12T14:27:54.983Z
5469791 5469791 20241103042008_OCKay HR0021 2024-11-04T14:17:03.284Z 2024-11-04T14:18:01.591Z
5461587 5461587 20241101200716_nZnkX HR0021 2024-11-03T14:15:57.244Z 2024-11-10T14:26:29.222Z
5461561 5461561 20241101195724_t836x HR0021 2024-11-03T14:15:55.553Z 2024-11-10T14:26:29.169Z
5461323 5461323 20241101175734_RPpN5 HR0021 2024-11-03T14:15:09.869Z 2024-11-10T14:26:28.107Z
5461256 5461256 20241101172253_htujm HR0021 2024-11-03T14:14:57.973Z 2024-11-10T14:26:27.761Z
5452693 5452693 20241101040932_syEeD HR0021 2024-11-02T12:19:14.702Z 2024-11-09T14:24:32.860Z
5451170 5451170 20241031225513_TypS9 HR0021 2024-11-02T12:16:40.789Z 2024-11-09T14:24:22.070Z
5450715 5450715 20241031203230_LUDOd HR0021 2024-11-02T12:15:47.035Z 2024-11-09T14:24:17.683Z
5450561 5450561 20241031194929_ZKpFS HR0021 2024-11-02T12:15:35.705Z 2024-11-09T14:24:16.498Z
5450255 5450255 20241031182644_NF443 HR0021 2024-11-02T12:14:51.503Z 2024-11-09T14:24:14.927Z
5450147 5450147 20241031180317_nKkXu HR0021 2024-11-02T12:14:38.863Z 2024-11-09T14:24:13.887Z
5450121 5450121 20241031175637_KjKoF HR0021 2024-11-02T12:14:37.014Z 2024-11-09T14:24:13.701Z
5450105 5450105 20241031175436_LFyzx HR0021 2024-11-02T12:14:34.339Z 2024-11-09T14:24:13.658Z
5441089 5441089 20241029204152_KUzHp HR0021 2024-11-01T12:18:05.599Z 2024-11-07T14:26:40.620Z
5439556 5439556 20241030200711_hpxa3 HR0021 2024-11-01T12:13:59.008Z 2024-11-08T14:23:04.090Z
5438991 5438991 20241030184128_0gzm0 HR0021 2024-11-01T12:12:57.062Z 2024-11-08T14:23:01.685Z
5438627 5438627 20241030174332_KrC2H HR0021 2024-11-01T12:12:11.472Z 2024-11-08T14:23:00.468Z
5438435 5438435 20241030171729_mVBdN HR0021 2024-11-01T12:11:41.728Z 2024-11-08T14:22:59.973Z
5433600 5433600 20241029203021_Hs3Cw HR0021 2024-10-31T12:22:24.072Z 2024-11-07T14:26:40.269Z
5433413 5433413 20241029194854_F6F85 HR0021 2024-10-31T12:22:13.635Z 2024-11-07T14:26:39.284Z

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