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

3,744 rows where station_code = "HR0015" 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
9243896 9243896 20260121053127_zmh07 HR0015 2026-01-22T14:23:28.732Z 2026-01-29T15:05:33.891Z
9243759 9243759 20260121051248_A1ehh HR0015 2026-01-22T14:22:55.581Z 2026-01-29T15:05:26.205Z
9243131 9243131 20260121034528_yJANW HR0015 2026-01-22T14:20:43.893Z 2026-01-29T15:04:47.546Z
9243127 9243127 20260121034523_CKiZh HR0015 2026-01-22T14:20:43.271Z 2026-01-29T15:04:47.385Z
9243116 9243116 20260121034344_pcu3K HR0015 2026-01-22T14:20:41.204Z 2026-01-29T15:04:46.955Z
9240733 9240733 20260120173659_BJu6z HR0015 2026-01-22T14:09:46.692Z 2026-01-29T15:01:52.350Z
9237339 9237339 20260120050543_kAOGs HR0015 2026-01-21T14:26:01.608Z 2026-01-28T15:01:20.469Z
9233865 9233865 20260119182437_ku7EM HR0015 2026-01-21T14:11:00.134Z 2026-01-28T14:56:48.720Z
9230695 9230695 20260119045031_lCleh HR0015 2026-01-20T14:29:16.778Z 2026-01-20T14:29:16.778Z
9230679 9230679 20260119044834_ttB5d HR0015 2026-01-20T14:29:12.681Z 2026-01-27T15:05:20.050Z
9230640 9230640 20260119044255_mNb5U HR0015 2026-01-20T14:29:01.409Z 2026-01-27T15:05:18.093Z
9230575 9230575 20260119043612_f22LW HR0015 2026-01-20T14:28:43.081Z 2026-01-20T14:28:43.081Z
9230493 9230493 20260119042648_9YQpN HR0015 2026-01-20T14:28:08.795Z 2026-01-27T15:04:59.235Z
9189107 9189107 20260112030433_Su23P HR0015 2026-01-13T14:15:48.214Z 2026-01-20T15:22:39.618Z
9188179 9188179 20260111211332_zYPyX HR0015 2026-01-13T14:10:52.726Z 2026-01-20T15:21:25.783Z
9182322 9182322 20260111050021_bWhV8 HR0015 2026-01-12T14:14:09.447Z 2026-01-19T15:18:26.046Z
9181844 9181844 20260111032941_dqrJE HR0015 2026-01-12T14:12:19.248Z 2026-01-19T15:17:51.000Z
9181632 9181632 20260111022918_65MFg HR0015 2026-01-12T14:11:32.676Z 2026-01-19T15:17:41.256Z
9181345 9181345 20260111012656_mdM3Y HR0015 2026-01-12T14:10:28.591Z 2026-01-19T15:17:13.709Z
9181257 9181257 20260111010902_QpIG1 HR0015 2026-01-12T14:10:08.503Z 2026-01-19T15:17:09.925Z
9171537 9171537 20260108224228_PqhIA HR0015 2026-01-10T14:08:00.018Z 2026-01-17T15:24:05.835Z
9171517 9171517 20260108223340_C3Sjw HR0015 2026-01-10T14:07:50.562Z 2026-01-17T15:24:04.771Z
9170873 9170873 20260108172646_WnmnQ HR0015 2026-01-10T14:03:49.647Z 2026-01-17T15:23:08.683Z
9167495 9167495 20260108021052_Vl5QQ HR0015 2026-01-09T14:07:59.451Z 2026-01-16T15:11:22.807Z
9167014 9167014 20260107213544_hLpBS HR0015 2026-01-09T14:05:51.045Z 2026-01-16T15:10:35.831Z
9162437 9162437 20260107025046_p7CoJ HR0015 2026-01-08T14:05:07.185Z 2026-01-13T15:02:09.969Z
9162426 9162426 20260107024619_50qTj HR0015 2026-01-08T14:05:04.051Z 2026-01-13T15:02:08.701Z
9162418 9162418 20260107024417_Dk2Nn HR0015 2026-01-08T14:05:02.282Z 2026-01-13T15:02:08.277Z
9128855 9128855 20251230005049_pTgyp HR0015 2026-01-03T14:43:04.307Z 2026-01-07T15:06:34.092Z
9128790 9128790 20251230223003_rmlvC HR0015 2026-01-03T14:25:48.562Z 2026-01-08T15:05:11.699Z
9123450 9123450 20251231010845_2xK3a HR0015 2026-01-02T14:28:24.565Z 2026-01-08T15:06:38.534Z
9122072 9122072 20260101042510_UX2Iq HR0015 2026-01-02T14:10:59.308Z 2026-01-09T14:52:59.128Z
9122051 9122051 20260101041533_3DbD2 HR0015 2026-01-02T14:10:54.808Z 2026-01-09T14:52:58.250Z
9122030 9122030 20260101041102_qJdm7 HR0015 2026-01-02T14:10:48.578Z 2026-01-09T14:52:57.024Z
9122024 9122024 20260101041050_Bu4pc HR0015 2026-01-02T14:10:47.845Z 2026-01-09T14:52:56.840Z
9121974 9121974 20260101035657_5zwEE HR0015 2026-01-02T14:10:30.481Z 2026-01-09T14:52:54.454Z
9121964 9121964 20260101035434_H3fZF HR0015 2026-01-02T14:10:28.147Z 2026-01-09T14:52:53.996Z
9121932 9121932 20260101034655_ebsoM HR0015 2026-01-02T14:10:19.178Z 2026-01-09T14:52:46.950Z
9121925 9121925 20260101034546_k3p3V HR0015 2026-01-02T14:10:15.169Z 2026-01-09T14:52:46.741Z
9121881 9121881 20260101032707_zWTxP HR0015 2026-01-02T14:10:01.127Z 2026-01-09T14:52:44.346Z
9121879 9121879 20260101032707_jPkm1 HR0015 2026-01-02T14:10:00.647Z 2026-01-09T14:52:44.215Z
9121791 9121791 20260101024806_SA69Z HR0015 2026-01-02T14:09:28.079Z 2026-01-09T14:52:39.047Z
9115843 9115843 20251231053106_yOFn7 HR0015 2026-01-01T14:26:39.248Z 2026-01-08T15:11:14.666Z
9113260 9113260 20251231031922_18394 HR0015 2026-01-01T14:18:12.105Z 2026-01-01T14:57:52.865Z
9112954 9112954 20251231030201_ZS85p HR0015 2026-01-01T14:16:57.578Z 2026-01-08T15:08:15.492Z
9112947 9112947 20251231030139_ByaDM HR0015 2026-01-01T14:16:56.866Z 2026-01-08T15:08:15.378Z
9112813 9112813 20251231025307_ZNNb9 HR0015 2026-01-01T14:16:24.217Z 2026-01-08T15:08:08.979Z
9112537 9112537 20251231023610_T5izU HR0015 2026-01-01T14:15:29.020Z 2026-01-08T15:07:51.202Z
9112271 9112271 20251231021641_kpYaj HR0015 2026-01-01T14:14:34.424Z 2026-01-01T14:57:51.875Z
9112231 9112231 20251231021330_62QDo HR0015 2026-01-01T14:14:27.479Z 2026-01-08T15:07:34.462Z
9111640 9111640 20251231013053_rxX2B HR0015 2026-01-01T14:12:15.180Z 2026-01-08T15:06:48.872Z
9111571 9111571 20251231012513_QE8N0 HR0015 2026-01-01T14:12:01.721Z 2026-01-08T15:06:46.485Z
9111500 9111500 20251231011428_J7eUh HR0015 2026-01-01T14:11:45.421Z 2026-01-01T14:57:51.032Z
9111490 9111490 20251231011324_mRqxW HR0015 2026-01-01T14:11:42.211Z 2026-01-08T15:06:42.217Z
9111441 9111441 20251231010931_KpmKn HR0015 2026-01-01T14:11:27.876Z 2026-01-08T15:06:39.819Z
9111395 9111395 20251231010845_sBaKS HR0015 2026-01-01T14:11:23.177Z 2026-01-08T15:06:38.701Z
9111309 9111309 20251231010127_KGIdl HR0015 2026-01-01T14:11:00.585Z 2026-01-08T15:06:28.377Z
9110925 9110925 20251231001833_SRIAh HR0015 2026-01-01T14:09:23.982Z 2026-01-02T14:26:33.120Z
9110779 9110779 20251230235851_cZDHG HR0015 2026-01-01T14:08:43.882Z 2026-01-08T15:05:50.245Z
9110760 9110760 20251230235658_pfPIS HR0015 2026-01-01T14:08:40.496Z 2026-01-01T14:57:50.134Z
9110702 9110702 20251230235135_6VcYq HR0015 2026-01-01T14:08:27.819Z 2026-01-08T15:05:46.221Z
9110390 9110390 20251230225808_fqbc3 HR0015 2026-01-01T14:07:01.712Z 2026-01-01T14:57:49.592Z
9110237 9110237 20251230223759_3wztc HR0015 2026-01-01T14:06:27.659Z 2026-01-08T15:05:14.095Z
9110216 9110216 20251230223552_8w03r HR0015 2026-01-01T14:06:22.102Z 2026-01-08T15:05:12.918Z
9109842 9109842 20251230210303_4zbPq HR0015 2026-01-01T14:04:06.126Z 2026-01-08T15:04:33.859Z
9107975 9107975 20251229173920_4i6Ns HR0015 2025-12-31T14:42:25.914Z 2026-01-02T15:16:17.614Z
9107871 9107871 20251229172735_CvwPd HR0015 2025-12-31T14:42:14.130Z 2025-12-31T14:42:14.130Z
9107700 9107700 20251229165426_tBOP0 HR0015 2025-12-31T14:41:43.536Z 2025-12-31T14:41:43.536Z
9106845 9106845 20251229000726_ekj8q HR0015 2025-12-31T14:32:29.240Z 2025-12-31T14:32:29.240Z
9106834 9106834 20251228231254_J0yy5 HR0015 2025-12-31T14:31:56.620Z 2026-01-06T15:14:55.059Z
9106820 9106820 20251228215439_MeNQo HR0015 2025-12-31T14:31:20.829Z 2026-01-06T15:14:24.737Z
9103950 9103950 20251230052115_k9ROo HR0015 2025-12-31T14:19:53.256Z 2026-01-07T15:09:17.001Z
9101050 9101050 20251229222000_2YXuQ HR0015 2025-12-31T14:06:14.075Z 2026-01-07T15:05:50.368Z
9100982 9100982 20251229215817_i3IZd HR0015 2025-12-31T14:05:51.340Z 2025-12-31T14:29:51.809Z
9098963 9098963 20251227203629_TcEVK HR0015 2025-12-30T15:11:19.136Z 2025-12-30T15:11:19.136Z
9098892 9098892 20251227202230_mB4JH HR0015 2025-12-30T15:11:14.392Z 2026-01-04T15:35:31.060Z
9098709 9098709 20251227195742_8pt2b HR0015 2025-12-30T15:10:47.331Z 2026-01-04T15:35:24.244Z
9098674 9098674 20251227195206_brDAh HR0015 2025-12-30T15:10:45.330Z 2026-01-04T15:35:22.951Z
9098310 9098310 20251227184544_SYCku HR0015 2025-12-30T15:10:04.591Z 2026-01-04T15:34:54.867Z
9097860 9097860 20251227174002_3GclA HR0015 2025-12-30T15:09:22.434Z 2026-01-04T15:34:23.203Z
9097741 9097741 20251227172821_ccSJ3 HR0015 2025-12-30T15:09:15.469Z 2026-01-04T15:34:19.933Z
9090925 9090925 20251228171923_qPugF HR0015 2025-12-30T14:51:27.149Z 2025-12-31T14:56:37.171Z
9090831 9090831 20251228170400_0R1Qh HR0015 2025-12-30T14:51:10.370Z 2026-01-05T15:13:39.675Z
9083043 9083043 20251227224556_cUFp2 HR0015 2025-12-30T14:31:24.646Z 2026-01-05T15:07:35.463Z
9082900 9082900 20251227220409_UExwm HR0015 2025-12-30T14:30:57.071Z 2025-12-30T14:53:53.877Z
9082883 9082883 20251227220149_xrAOh HR0015 2025-12-30T14:30:55.104Z 2026-01-05T15:07:30.269Z
9082796 9082796 20251227214402_2YwrZ HR0015 2025-12-30T14:30:39.663Z 2026-01-05T15:07:18.970Z
9082650 9082650 20251227211920_YveVz HR0015 2025-12-30T14:30:09.061Z 2026-01-05T15:07:12.949Z
9077250 9077250 20251229000930_b2A8s HR0015 2025-12-30T14:07:17.773Z 2026-01-06T15:15:23.466Z
9077080 9077080 20251228234213_xQd8N HR0015 2025-12-30T14:06:24.698Z 2025-12-31T14:32:15.728Z
9077060 9077060 20251228234051_FBupO HR0015 2025-12-30T14:06:20.738Z 2025-12-31T14:32:14.644Z
9076804 9076804 20251228231254_7hz2K HR0015 2025-12-30T14:05:08.047Z 2025-12-30T14:53:43.907Z
9076791 9076791 20251228230858_EiLkr HR0015 2025-12-30T14:05:05.807Z 2026-01-06T15:14:54.496Z
9076781 9076781 20251228230708_wf2hn HR0015 2025-12-30T14:05:04.285Z 2025-12-31T14:31:55.284Z
9076701 9076701 20251228225516_GM37C HR0015 2025-12-30T14:04:43.239Z 2026-01-06T15:14:51.093Z
9076661 9076661 20251228224641_b30RB HR0015 2025-12-30T14:04:31.995Z 2026-01-06T15:14:44.242Z
9076032 9076032 20251228205046_EtKtq HR0015 2025-12-30T14:01:10.113Z 2026-01-06T15:14:11.257Z
9072308 9072308 20251226204931_tBJiL HR0015 2025-12-29T14:50:37.594Z 2025-12-29T14:51:19.283Z
9071879 9071879 20251226194554_YR2lL HR0015 2025-12-29T14:50:11.814Z 2026-01-03T15:43:31.543Z
9071876 9071876 20251226194553_UdYyz HR0015 2025-12-29T14:50:11.636Z 2026-01-03T15:43:31.438Z

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