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

6,994 rows where station_code = "HR002V" 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
9267766 9267766 20260127045029_WmMe3 HR002V 2026-01-28T14:23:13.629Z 2026-01-29T14:35:41.006Z
9267671 9267671 20260127040812_T2mgI HR002V 2026-01-28T14:22:49.134Z 2026-01-29T14:35:27.125Z
9267653 9267653 20260127040030_tngbu HR002V 2026-01-28T14:22:44.919Z 2026-01-29T14:35:25.631Z
9267623 9267623 20260127034543_rSHQ1 HR002V 2026-01-28T14:22:35.236Z 2026-01-29T14:35:23.289Z
9267503 9267503 20260127022549_hiRnw HR002V 2026-01-28T14:21:59.751Z 2026-01-29T14:35:08.643Z
9267433 9267433 20260127005550_KNL1n HR002V 2026-01-28T14:21:40.033Z 2026-01-29T14:35:00.240Z
9267425 9267425 20260127005008_UcrMu HR002V 2026-01-28T14:21:38.543Z 2026-01-29T14:34:59.683Z
9267423 9267423 20260127005003_zAYXf HR002V 2026-01-28T14:21:37.957Z 2026-01-29T14:34:59.491Z
9267418 9267418 20260127004535_9KS2Y HR002V 2026-01-28T14:21:36.550Z 2026-01-29T14:34:58.886Z
9267353 9267353 20260126234454_Uhnbq HR002V 2026-01-28T14:21:16.183Z 2026-01-29T14:34:53.743Z
9267345 9267345 20260126234344_Wsk2I HR002V 2026-01-28T14:21:13.939Z 2026-01-29T14:34:53.158Z
9267296 9267296 20260126225137_fvdL6 HR002V 2026-01-28T14:20:56.071Z 2026-01-29T14:34:49.099Z
9267293 9267293 20260126225120_8mhmC HR002V 2026-01-28T14:20:55.495Z 2026-01-29T14:34:48.887Z
9267283 9267283 20260126223519_RzIEH HR002V 2026-01-28T14:20:53.588Z 2026-01-29T14:34:48.065Z
9267268 9267268 20260126221556_30fsY HR002V 2026-01-28T14:20:49.843Z 2026-01-29T14:34:47.100Z
9266972 9266972 20260126172602_3Mhum HR002V 2026-01-28T14:18:03.875Z 2026-01-29T14:33:51.260Z
9266948 9266948 20260126171045_tDY1E HR002V 2026-01-28T14:17:49.377Z 2026-01-29T14:33:47.680Z
9262599 9262599 20260125204419_Omzth HR002V 2026-01-27T14:13:59.136Z 2026-01-29T14:38:23.673Z
9262595 9262595 20260125204132_Wc2cj HR002V 2026-01-27T14:13:58.276Z 2026-01-29T14:38:23.504Z
9262557 9262557 20260125201012_ujpD9 HR002V 2026-01-27T14:13:34.138Z 2026-01-29T14:38:13.727Z
9256492 9256492 20260120044304_r38g8 HR002V 2026-01-25T14:42:01.570Z 2026-01-28T15:01:00.184Z
9256485 9256485 20260120032451_3USI9 HR002V 2026-01-25T14:41:16.909Z 2026-01-28T15:00:03.924Z
9256477 9256477 20260120021746_3FoYK HR002V 2026-01-25T14:40:35.842Z 2026-01-28T14:59:28.643Z
9256475 9256475 20260120013656_9h2sK HR002V 2026-01-25T14:40:11.435Z 2026-01-28T14:59:03.637Z
9256471 9256471 20260120010711_p33EM HR002V 2026-01-25T14:39:53.124Z 2026-01-28T14:58:53.429Z
9256465 9256465 20260119205743_JfuiA HR002V 2026-01-25T14:38:34.438Z 2026-01-28T14:57:31.540Z
9243762 9243762 20260121051248_A1ehh HR002V 2026-01-22T14:22:55.581Z 2026-01-29T15:05:26.205Z
9243130 9243130 20260121034523_CKiZh HR002V 2026-01-22T14:20:43.271Z 2026-01-29T15:04:47.385Z
9243119 9243119 20260121034344_pcu3K HR002V 2026-01-22T14:20:41.204Z 2026-01-29T15:04:46.955Z
9242806 9242806 20260121024852_cbhwJ HR002V 2026-01-22T14:19:18.016Z 2026-01-29T15:04:21.561Z
9242769 9242769 20260121023942_Y3iI1 HR002V 2026-01-22T14:19:10.107Z 2026-01-29T15:04:20.142Z
9242342 9242342 20260121013415_DM5Qt HR002V 2026-01-22T14:17:24.384Z 2026-01-29T15:03:45.136Z
9242303 9242303 20260121012453_aKSbz HR002V 2026-01-22T14:17:17.709Z 2026-01-29T15:03:43.294Z
9242258 9242258 20260121011449_UIDkw HR002V 2026-01-22T14:17:02.560Z 2026-01-29T15:03:38.964Z
9242159 9242159 20260121004712_6hKe7 HR002V 2026-01-22T14:16:37.271Z 2026-01-29T15:03:34.094Z
9241959 9241959 20260120234533_wUyen HR002V 2026-01-22T14:15:33.876Z 2026-01-29T15:03:14.669Z
9241838 9241838 20260120230401_3gydr HR002V 2026-01-22T14:14:53.301Z 2026-01-29T15:03:05.276Z
9241783 9241783 20260120222937_DFG41 HR002V 2026-01-22T14:14:31.227Z 2026-01-29T15:03:02.048Z
9241764 9241764 20260120221741_Rt7l3 HR002V 2026-01-22T14:14:25.614Z 2026-01-29T15:03:01.205Z
9241748 9241748 20260120220929_VxsES HR002V 2026-01-22T14:14:22.845Z 2026-01-29T15:03:00.530Z
9241734 9241734 20260120215919_II9m6 HR002V 2026-01-22T14:14:19.084Z 2026-01-29T15:02:59.365Z
9241519 9241519 20260120205040_u0Fd5 HR002V 2026-01-22T14:13:27.346Z 2026-01-29T15:02:42.081Z
9241196 9241196 20260120192230_hnoXQ HR002V 2026-01-22T14:12:06.054Z 2026-01-29T15:02:26.185Z
9240866 9240866 20260120180756_MN8yQ HR002V 2026-01-22T14:10:30.725Z 2026-01-29T15:01:59.297Z
9240737 9240737 20260120173659_BJu6z HR002V 2026-01-22T14:09:46.719Z 2026-01-29T15:01:52.350Z
9237368 9237368 20260120050702_rlgFH HR002V 2026-01-21T14:26:17.871Z 2026-01-28T15:01:21.988Z
9237263 9237263 20260120045556_tqwFd HR002V 2026-01-21T14:25:48.140Z 2026-01-28T15:01:06.576Z
9237261 9237261 20260120045556_q2lBA HR002V 2026-01-21T14:25:47.838Z 2026-01-28T15:01:06.414Z
9237062 9237062 20260120043211_gTJXP HR002V 2026-01-21T14:25:06.146Z 2026-01-28T15:00:56.073Z
9237004 9237004 20260120042645_Z9BbQ HR002V 2026-01-21T14:24:55.219Z 2026-01-28T15:00:53.194Z
9236932 9236932 20260120042040_DfEvi HR002V 2026-01-21T14:24:31.582Z 2026-01-28T15:00:49.423Z
9236922 9236922 20260120041915_022gI HR002V 2026-01-21T14:24:30.431Z 2026-01-28T15:00:49.052Z
9236761 9236761 20260120035628_Gk43R HR002V 2026-01-21T14:23:57.083Z 2026-01-28T15:00:33.782Z
9236653 9236653 20260120034413_XV2el HR002V 2026-01-21T14:23:37.652Z 2026-01-28T15:00:27.684Z
9236588 9236588 20260120033654_QUCqe HR002V 2026-01-21T14:23:27.632Z 2026-01-28T15:00:22.817Z
9236537 9236537 20260120033138_KjGLf HR002V 2026-01-21T14:23:10.701Z 2026-01-28T15:00:08.041Z
9236515 9236515 20260120033004_2qB0I HR002V 2026-01-21T14:23:01.672Z 2026-01-28T15:00:06.447Z
9236455 9236455 20260120032040_3Th3h HR002V 2026-01-21T14:22:52.611Z 2026-01-28T15:00:01.520Z
9236341 9236341 20260120030354_XUb9c HR002V 2026-01-21T14:22:24.442Z 2026-01-28T14:59:56.259Z
9236241 9236241 20260120024933_6iT38 HR002V 2026-01-21T14:22:06.345Z 2026-01-28T14:59:51.528Z
9236227 9236227 20260120024908_phwam HR002V 2026-01-21T14:22:01.208Z 2026-01-28T14:59:51.054Z
9236200 9236200 20260120024619_230oq HR002V 2026-01-21T14:21:56.970Z 2026-01-28T14:59:49.776Z
9236174 9236174 20260120024351_RY1rs HR002V 2026-01-21T14:21:52.969Z 2026-01-28T14:59:48.467Z
9236172 9236172 20260120024313_vg2RN HR002V 2026-01-21T14:21:52.558Z 2026-01-28T14:59:48.320Z
9236120 9236120 20260120023733_6yMr9 HR002V 2026-01-21T14:21:33.270Z 2026-01-28T14:59:45.753Z
9236095 9236095 20260120023404_x06fZ HR002V 2026-01-21T14:21:25.629Z 2026-01-28T14:59:44.508Z
9236077 9236077 20260120023224_V3VBj HR002V 2026-01-21T14:21:23.049Z 2026-01-28T14:59:43.612Z
9236064 9236064 20260120023145_U8jPo HR002V 2026-01-21T14:21:21.087Z 2026-01-28T14:59:42.964Z
9235983 9235983 20260120022425_cLpvX HR002V 2026-01-21T14:21:09.067Z 2026-01-28T14:59:31.378Z
9235925 9235925 20260120021805_Vs3ac HR002V 2026-01-21T14:20:46.008Z 2026-01-28T14:59:29.198Z
9235734 9235734 20260120015441_9RHNv HR002V 2026-01-21T14:20:06.532Z 2026-01-28T14:59:18.161Z
9235590 9235590 20260120013708_0ok3c HR002V 2026-01-21T14:19:31.986Z 2026-01-28T14:59:03.723Z
9235514 9235514 20260120012515_KTkso HR002V 2026-01-21T14:19:16.334Z 2026-01-28T14:59:00.119Z
9235500 9235500 20260120012351_xu87E HR002V 2026-01-21T14:19:06.228Z 2026-01-28T14:58:59.441Z
9235485 9235485 20260120012047_8LDJ8 HR002V 2026-01-21T14:19:03.931Z 2026-01-28T14:58:57.568Z
9235474 9235474 20260120011833_GEvM3 HR002V 2026-01-21T14:19:02.436Z 2026-01-28T14:58:57.050Z
9235433 9235433 20260120011234_szkFq HR002V 2026-01-21T14:18:53.006Z 2026-01-28T14:58:54.721Z
9235414 9235414 20260120010728_Kginx HR002V 2026-01-21T14:18:49.772Z 2026-01-28T14:58:53.723Z
9235290 9235290 20260120005051_t43iX HR002V 2026-01-21T14:18:23.177Z 2026-01-28T14:58:47.928Z
9235257 9235257 20260120004829_qOa4N HR002V 2026-01-21T14:18:17.082Z 2026-01-28T14:58:46.051Z
9235160 9235160 20260120003811_1vCte HR002V 2026-01-21T14:17:47.231Z 2026-01-28T14:58:33.524Z
9235144 9235144 20260120003600_YAVfH HR002V 2026-01-21T14:17:44.015Z 2026-01-28T14:58:32.777Z
9235128 9235128 20260120003200_AjgWO HR002V 2026-01-21T14:17:40.506Z 2026-01-28T14:58:31.825Z
9235088 9235088 20260120002715_ANNJK HR002V 2026-01-21T14:17:27.920Z 2026-01-28T14:58:30.231Z
9234965 9234965 20260119235639_HJ0XM HR002V 2026-01-21T14:16:50.564Z 2026-01-28T14:58:22.551Z
9234953 9234953 20260119235415_LmmwN HR002V 2026-01-21T14:16:48.801Z 2026-01-28T14:58:21.959Z
9234939 9234939 20260119235325_YUQhn HR002V 2026-01-21T14:16:44.581Z 2026-01-28T14:58:21.398Z
9234921 9234921 20260119235154_vAgOL HR002V 2026-01-21T14:16:41.662Z 2026-01-28T14:58:20.933Z
9234893 9234893 20260119234605_gLErD HR002V 2026-01-21T14:16:36.280Z 2026-01-28T14:58:19.268Z
9234740 9234740 20260119231327_tRJ1v HR002V 2026-01-21T14:15:56.561Z 2026-01-28T14:58:03.840Z
9234728 9234728 20260119230744_yqqCz HR002V 2026-01-21T14:15:54.348Z 2026-01-28T14:58:03.194Z
9234710 9234710 20260119230220_K7AIO HR002V 2026-01-21T14:15:50.621Z 2026-01-28T14:58:02.205Z
9234690 9234690 20260119225645_3N3aH HR002V 2026-01-21T14:15:42.460Z 2026-01-28T14:58:00.020Z
9234659 9234659 20260119224919_vAKiu HR002V 2026-01-21T14:15:35.623Z 2026-01-28T14:57:58.652Z
9234638 9234638 20260119224211_fDztG HR002V 2026-01-21T14:15:31.823Z 2026-01-28T14:57:57.697Z
9234631 9234631 20260119224110_5Ikp6 HR002V 2026-01-21T14:15:30.514Z 2026-01-28T14:57:57.422Z
9234599 9234599 20260119223447_s9V6m HR002V 2026-01-21T14:15:23.054Z 2026-01-28T14:57:55.932Z
9234578 9234578 20260119222944_KkuC1 HR002V 2026-01-21T14:15:11.148Z 2026-01-28T14:57:54.902Z
9234524 9234524 20260119220817_sCknq HR002V 2026-01-21T14:15:00.935Z 2026-01-28T14:57:52.221Z
9234512 9234512 20260119220314_o6zac HR002V 2026-01-21T14:14:51.609Z 2026-01-28T14:57:51.353Z

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