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,820 rows where station_code = "HR002X" 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
8675425 8675425 20251202043751_fKzt3 HR002X 2025-12-03T14:23:42.343Z 2025-12-06T14:34:52.457Z
8675244 8675244 20251202042252_2Owjs HR002X 2025-12-03T14:23:23.667Z 2025-12-06T14:34:48.027Z
8667183 8667183 20251129182242_YaxXr HR002X 2025-12-02T14:35:22.358Z 2025-12-06T14:45:39.119Z
8665705 8665705 20251201035113_LZWJE HR002X 2025-12-02T14:24:20.993Z 2025-12-06T14:41:46.634Z
8665666 8665666 20251201034901_kxzlt HR002X 2025-12-02T14:24:17.907Z 2025-12-06T14:41:45.362Z
8656875 8656875 20251130051509_ywCzN HR002X 2025-12-01T14:33:47.716Z 2025-12-06T14:49:42.658Z
8656820 8656820 20251130051057_o5ZGM HR002X 2025-12-01T14:29:03.143Z 2025-12-06T14:49:41.832Z
8656781 8656781 20251130050927_l8BiZ HR002X 2025-12-01T14:29:00.124Z 2025-12-06T14:49:41.223Z
8656718 8656718 20251130050659_9KJrR HR002X 2025-12-01T14:28:57.595Z 2025-12-06T14:49:39.181Z
8656612 8656612 20251130050138_L6QYH HR002X 2025-12-01T14:28:48.073Z 2025-12-01T14:28:48.073Z
8656414 8656414 20251130045423_wfr54 HR002X 2025-12-01T14:28:37.090Z 2025-12-06T14:49:34.584Z
8656407 8656407 20251130045422_DwRpC HR002X 2025-12-01T14:28:36.832Z 2025-12-06T14:49:34.521Z
8656288 8656288 20251130044755_Z5zrh HR002X 2025-12-01T14:28:18.163Z 2025-12-06T14:49:33.200Z
8656248 8656248 20251130044521_bRlH2 HR002X 2025-12-01T14:28:13.481Z 2025-12-01T14:28:13.481Z
8656228 8656228 20251130044436_Mlg2m HR002X 2025-12-01T14:28:12.117Z 2025-12-01T14:28:12.117Z
8656219 8656219 20251130044359_BBO42 HR002X 2025-12-01T14:28:11.183Z 2025-12-06T14:49:32.323Z
8656168 8656168 20251130044126_zRduq HR002X 2025-12-01T14:28:07.979Z 2025-12-06T14:49:31.830Z
8656143 8656143 20251130043954_FVPL1 HR002X 2025-12-01T14:28:06.341Z 2025-12-06T14:49:31.476Z
8656104 8656104 20251130043704_mdSur HR002X 2025-12-01T14:28:03.305Z 2025-12-06T14:49:30.774Z
8656088 8656088 20251130043641_uNedL HR002X 2025-12-01T14:28:02.539Z 2025-12-06T14:49:30.615Z
8656053 8656053 20251130043227_31Vw1 HR002X 2025-12-01T14:27:59.323Z 2025-12-01T14:27:59.323Z
8655965 8655965 20251130042804_Gvs3m HR002X 2025-12-01T14:27:42.457Z 2025-12-06T14:49:29.358Z
8655920 8655920 20251130042511_nTfMM HR002X 2025-12-01T14:27:40.830Z 2025-12-06T14:49:29.149Z
8655916 8655916 20251130042439_X0u0e HR002X 2025-12-01T14:27:40.442Z 2025-12-06T14:49:29.136Z
8655896 8655896 20251130042336_i2vk3 HR002X 2025-12-01T14:27:38.387Z 2025-12-06T14:49:28.927Z
8655887 8655887 20251130042313_y6wqk HR002X 2025-12-01T14:27:36.036Z 2025-12-01T14:27:36.036Z
8655783 8655783 20251130041756_s32Ui HR002X 2025-12-01T14:27:28.741Z 2025-12-06T14:49:27.829Z
8655778 8655778 20251130041732_GFJgr HR002X 2025-12-01T14:27:28.244Z 2025-12-06T14:49:27.738Z
8655756 8655756 20251130041634_su0d3 HR002X 2025-12-01T14:27:26.602Z 2025-12-06T14:49:27.270Z
8655735 8655735 20251130041407_lFYXJ HR002X 2025-12-01T14:27:24.032Z 2025-12-06T14:49:26.949Z
8655511 8655511 20251130040544_WHyeY HR002X 2025-12-01T14:27:01.534Z 2025-12-06T14:49:24.613Z
8655478 8655478 20251130040345_YTGLb HR002X 2025-12-01T14:26:58.940Z 2025-12-06T14:49:21.846Z
8655379 8655379 20251130035947_31sw4 HR002X 2025-12-01T14:26:52.023Z 2025-12-01T14:26:52.023Z
8655350 8655350 20251130035629_2lXpR HR002X 2025-12-01T14:26:49.415Z 2025-12-06T14:49:09.071Z
8655197 8655197 20251130034827_IsYwG HR002X 2025-12-01T14:26:38.245Z 2025-12-06T14:48:53.308Z
8655075 8655075 20251130034256_ytO3H HR002X 2025-12-01T14:26:22.067Z 2025-12-06T14:48:51.342Z
8655062 8655062 20251130034233_hpBgu HR002X 2025-12-01T14:26:20.887Z 2025-12-06T14:48:51.175Z
8654984 8654984 20251130034017_mV7Yd HR002X 2025-12-01T14:26:14.075Z 2025-12-06T14:48:50.592Z
8654939 8654939 20251130033846_W3RN7 HR002X 2025-12-01T14:26:11.572Z 2025-12-06T14:48:50.231Z
8654924 8654924 20251130033838_LEoOj HR002X 2025-12-01T14:26:10.879Z 2025-12-06T14:48:50.123Z
8654811 8654811 20251130033339_OYF4A HR002X 2025-12-01T14:26:03.534Z 2025-12-06T14:48:48.728Z
8654772 8654772 20251130033224_jaBFJ HR002X 2025-12-01T14:25:59.920Z 2025-12-01T14:25:59.920Z
8654707 8654707 20251130032807_NAdg1 HR002X 2025-12-01T14:25:46.414Z 2025-12-06T14:48:46.144Z
8654696 8654696 20251130032635_TJexY HR002X 2025-12-01T14:25:45.102Z 2025-12-01T14:25:45.102Z
8654692 8654692 20251130032617_iUmGo HR002X 2025-12-01T14:25:44.702Z 2025-12-06T14:48:45.796Z
8654675 8654675 20251130032514_tSNd4 HR002X 2025-12-01T14:25:43.075Z 2025-12-06T14:48:45.579Z
8654643 8654643 20251130032439_pSqc3 HR002X 2025-12-01T14:25:40.371Z 2025-12-01T14:25:40.371Z
8654634 8654634 20251130032402_3WXfF HR002X 2025-12-01T14:25:39.312Z 2025-12-06T14:48:45.212Z
8654584 8654584 20251130032056_727Uf HR002X 2025-12-01T14:25:35.602Z 2025-12-06T14:48:44.216Z
8654446 8654446 20251130031707_ivCKo HR002X 2025-12-01T14:25:26.390Z 2025-12-06T14:48:42.778Z
8654375 8654375 20251130031218_y6O7E HR002X 2025-12-01T14:25:19.665Z 2025-12-06T14:48:41.309Z
8654330 8654330 20251130031105_pa9tC HR002X 2025-12-01T14:25:09.597Z 2025-12-06T14:48:40.922Z
8654320 8654320 20251130031045_T7lN5 HR002X 2025-12-01T14:25:09.041Z 2025-12-06T14:48:40.791Z
8654316 8654316 20251130031031_bvoai HR002X 2025-12-01T14:25:08.791Z 2025-12-06T14:48:40.757Z
8654223 8654223 20251130030359_Gx08N HR002X 2025-12-01T14:24:59.496Z 2025-12-06T14:48:39.143Z
8654174 8654174 20251130030234_nZv7p HR002X 2025-12-01T14:24:56.669Z 2025-12-06T14:48:38.457Z
8654170 8654170 20251130030231_nOzmI HR002X 2025-12-01T14:24:56.156Z 2025-12-06T14:48:38.392Z
8654164 8654164 20251130030141_Fxm8N HR002X 2025-12-01T14:24:55.568Z 2025-12-06T14:48:38.270Z
8654094 8654094 20251130025746_Jm4T7 HR002X 2025-12-01T14:24:50.647Z 2025-12-06T14:48:37.252Z
8653993 8653993 20251130025108_ycoQ1 HR002X 2025-12-01T14:24:36.637Z 2025-12-06T14:48:35.625Z
8653944 8653944 20251130024835_mWCO7 HR002X 2025-12-01T14:24:31.291Z 2025-12-06T14:48:34.844Z
8653798 8653798 20251130024058_7IRhN HR002X 2025-12-01T14:24:15.878Z 2025-12-06T14:48:32.295Z
8653573 8653573 20251130022558_fmrzD HR002X 2025-12-01T14:23:43.014Z 2025-12-06T14:48:16.046Z
8653563 8653563 20251130022545_nY8x3 HR002X 2025-12-01T14:23:42.217Z 2025-12-06T14:48:14.976Z
8653556 8653556 20251130022514_aqVJC HR002X 2025-12-01T14:23:41.779Z 2025-12-06T14:48:13.870Z
8653530 8653530 20251130022324_Qn329 HR002X 2025-12-01T14:23:39.568Z 2025-12-06T14:48:11.511Z
8653525 8653525 20251130022234_7JZY0 HR002X 2025-12-01T14:23:38.744Z 2025-12-06T14:48:08.214Z
8653503 8653503 20251130022124_LKCfT HR002X 2025-12-01T14:23:37.079Z 2025-12-06T14:48:04.390Z
8653202 8653202 20251130020201_axh4v HR002X 2025-12-01T14:23:03.705Z 2025-12-06T14:47:51.454Z
8653181 8653181 20251130020129_6l2GW HR002X 2025-12-01T14:23:02.427Z 2025-12-06T14:47:51.165Z
8653003 8653003 20251130014958_6m70S HR002X 2025-12-01T14:22:38.061Z 2025-12-06T14:47:47.522Z
8652996 8652996 20251130014955_F7lVr HR002X 2025-12-01T14:22:37.574Z 2025-12-06T14:47:47.465Z
8652960 8652960 20251130014722_La89u HR002X 2025-12-01T14:22:35.109Z 2025-12-06T14:47:46.974Z
8652934 8652934 20251130014602_XhrNG HR002X 2025-12-01T14:22:33.264Z 2025-12-06T14:47:46.474Z
8652926 8652926 20251130014558_66flg HR002X 2025-12-01T14:22:32.176Z 2025-12-06T14:47:46.315Z
8652918 8652918 20251130014557_UiAHD HR002X 2025-12-01T14:22:31.089Z 2025-12-06T14:47:46.003Z
8652806 8652806 20251130013525_ovCkU HR002X 2025-12-01T14:22:08.941Z 2025-12-06T14:47:42.770Z
8652797 8652797 20251130013438_tKL3x HR002X 2025-12-01T14:22:07.803Z 2025-12-06T14:47:42.611Z
8652789 8652789 20251130013437_VdUCD HR002X 2025-12-01T14:22:07.459Z 2025-12-06T14:47:42.571Z
8652678 8652678 20251130012647_X7tjv HR002X 2025-12-01T14:21:58.405Z 2025-12-06T14:47:40.947Z
8652425 8652425 20251130010829_tY1Y2 HR002X 2025-12-01T14:21:22.567Z 2025-12-06T14:47:36.862Z
8652404 8652404 20251130010652_srzaH HR002X 2025-12-01T14:21:21.079Z 2025-12-06T14:47:36.674Z
8652399 8652399 20251130010640_u4Xae HR002X 2025-12-01T14:21:20.777Z 2025-12-06T14:47:36.636Z
8652359 8652359 20251130010401_QbYxw HR002X 2025-12-01T14:21:18.070Z 2025-12-06T14:47:36.130Z
8652291 8652291 20251130010208_gCKke HR002X 2025-12-01T14:21:14.044Z 2025-12-06T14:47:34.153Z
8652248 8652248 20251130005840_DQ45j HR002X 2025-12-01T14:21:02.550Z 2025-12-06T14:47:32.792Z
8652232 8652232 20251130005703_QCgpF HR002X 2025-12-01T14:20:57.606Z 2025-12-06T14:47:32.365Z
8652223 8652223 20251130005551_J00Jx HR002X 2025-12-01T14:20:56.475Z 2025-12-06T14:47:31.814Z
8652171 8652171 20251130005123_2yVnb HR002X 2025-12-01T14:20:51.107Z 2025-12-06T14:47:26.892Z
8652144 8652144 20251130005046_oYB08 HR002X 2025-12-01T14:20:48.488Z 2025-12-06T14:47:23.601Z
8652140 8652140 20251130004916_gaP5F HR002X 2025-12-01T14:20:47.539Z 2025-12-06T14:47:23.401Z
8652136 8652136 20251130004916_3358G HR002X 2025-12-01T14:20:47.232Z 2025-12-06T14:47:22.697Z
8652072 8652072 20251130004425_qX3GI HR002X 2025-12-01T14:20:39.733Z 2025-12-06T14:47:11.275Z
8652051 8652051 20251130004331_fdDIn HR002X 2025-12-01T14:20:31.993Z 2025-12-06T14:47:07.027Z
8651837 8651837 20251130002505_wYs2W HR002X 2025-12-01T14:20:06.942Z 2025-12-06T14:46:54.923Z
8651797 8651797 20251130001939_rn83b HR002X 2025-12-01T14:19:56.410Z 2025-12-06T14:46:54.167Z
8651616 8651616 20251130000207_uG1jL HR002X 2025-12-01T14:19:32.502Z 2025-12-06T14:46:49.516Z
8651582 8651582 20251129235752_LVd0M HR002X 2025-12-01T14:19:24.038Z 2025-12-06T14:46:48.842Z
8651552 8651552 20251129235422_BXHVk HR002X 2025-12-01T14:19:19.675Z 2025-12-06T14:46:48.257Z
8651544 8651544 20251129235402_5skyE HR002X 2025-12-01T14:19:17.969Z 2025-12-06T14:46:48.018Z

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