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,119 rows where station_code = "HR001K" 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
8673764 8673764 20251201225332_t8SyW HR001K 2025-12-03T14:20:00.073Z 2025-12-05T14:27:05.281Z
8673266 8673266 20251201175720_gEaGZ HR001K 2025-12-03T14:18:08.415Z 2025-12-05T14:26:21.390Z
8667777 8667777 20251130035506_13oZt HR001K 2025-12-02T14:40:20.388Z 2025-12-05T14:44:32.168Z
8667152 8667152 20251129174229_wUlIK HR001K 2025-12-02T14:35:12.403Z 2025-12-05T14:40:12.207Z
8656278 8656278 20251130044636_s2yrR HR001K 2025-12-01T14:28:15.791Z 2025-12-05T14:44:56.420Z
8655886 8655886 20251130042245_vJVxY HR001K 2025-12-01T14:27:35.658Z 2025-12-05T14:44:40.715Z
8654775 8654775 20251130033226_A2R2p HR001K 2025-12-01T14:26:00.194Z 2025-12-05T14:44:23.445Z
8653881 8653881 20251130024549_2iDki HR001K 2025-12-01T14:24:25.207Z 2025-12-05T14:43:41.996Z
8652634 8652634 20251130012510_ymhQW HR001K 2025-12-01T14:21:53.477Z 2025-12-05T14:42:49.019Z
8651967 8651967 20251130003758_oFkWa HR001K 2025-12-01T14:20:21.216Z 2025-12-05T14:42:12.574Z
8649838 8649838 20251129183732_mWZKi HR001K 2025-12-01T14:14:05.913Z 2025-12-05T14:40:24.374Z
8649521 8649521 20251129173836_3k8rg HR001K 2025-12-01T14:12:55.544Z 2025-12-05T14:40:11.382Z
8647436 8647436 20251129043538_F0hCN HR001K 2025-11-30T14:28:23.120Z 2025-12-05T14:52:40.184Z
8647225 8647225 20251129040707_f7c0r HR001K 2025-11-30T14:27:52.069Z 2025-12-05T14:52:35.654Z
8647135 8647135 20251129034902_iAdv9 HR001K 2025-11-30T14:27:44.102Z 2025-12-05T14:52:33.799Z
8646861 8646861 20251129030323_9VQpt HR001K 2025-11-30T14:27:02.477Z 2025-12-05T14:51:55.511Z
8646803 8646803 20251129025724_SG2yC HR001K 2025-11-30T14:26:58.958Z 2025-12-05T14:51:54.641Z
8646571 8646571 20251129022327_brzuu HR001K 2025-11-30T14:26:12.430Z 2025-12-05T14:51:44.789Z
8645952 8645952 20251129003350_ZyuTQ HR001K 2025-11-30T14:24:58.671Z 2025-12-05T14:51:29.624Z
8645438 8645438 20251128221047_e118Y HR001K 2025-11-30T14:23:44.038Z 2025-12-05T14:50:38.928Z
8645405 8645405 20251128215817_JptI3 HR001K 2025-11-30T14:23:40.555Z 2025-12-05T14:50:38.332Z
8645328 8645328 20251128212050_2NO23 HR001K 2025-11-30T14:23:34.398Z 2025-12-05T14:50:36.603Z
8635496 8635496 20251128021905_qXSuB HR001K 2025-11-29T14:23:29.652Z 2025-12-05T14:58:47.544Z
8634434 8634434 20251128005054_NxUnq HR001K 2025-11-29T14:21:21.512Z 2025-12-05T14:58:20.699Z
8633123 8633123 20251127224013_500Dj HR001K 2025-11-29T14:19:00.025Z 2025-12-05T14:57:09.229Z
8632016 8632016 20251127202252_z3PhA HR001K 2025-11-29T14:16:40.605Z 2025-12-05T14:56:14.473Z
8622596 8622596 20251126201342_shPnN HR001K 2025-11-28T14:19:27.394Z 2025-12-05T15:03:03.877Z
8580023 8580023 20251123021724_lk7z7 HR001K 2025-11-24T14:15:52.478Z 2025-12-01T15:21:34.102Z
8579940 8579940 20251123015539_vVja2 HR001K 2025-11-24T14:15:40.249Z 2025-12-01T15:21:20.550Z
8579626 8579626 20251123002824_tEkC3 HR001K 2025-11-24T14:14:52.302Z 2025-12-01T15:20:49.016Z
8527105 8527105 20251119010636_OmYF0 HR001K 2025-11-20T14:40:47.222Z 2025-11-27T15:12:07.668Z
8526585 8526585 20251118233100_T1hun HR001K 2025-11-20T14:40:00.361Z 2025-11-27T15:11:56.531Z
8524700 8524700 20251119041142_3MZXJ HR001K 2025-11-20T14:21:17.790Z 2025-11-27T15:13:03.166Z
8523190 8523190 20251119014044_X8QUX HR001K 2025-11-20T14:17:45.096Z 2025-11-27T15:12:10.198Z
8522901 8522901 20251119010635_bo5JN HR001K 2025-11-20T14:16:54.709Z 2025-11-27T15:12:07.629Z
8521346 8521346 20251118205350_dJgoQ HR001K 2025-11-20T14:12:09.717Z 2025-11-27T15:11:38.395Z
8519789 8519789 20251118181124_pa0m8 HR001K 2025-11-20T14:08:02.102Z 2025-11-27T15:11:29.017Z
8519092 8519092 20251118163547_pHmPt HR001K 2025-11-20T14:05:50.301Z 2025-11-27T15:11:25.300Z
8456621 8456621 20251113190337_AIJG7 HR001K 2025-11-15T14:11:45.540Z 2025-11-22T15:20:45.191Z
8442582 8442582 20251111042211_GWeZp HR001K 2025-11-13T14:47:40.590Z 2025-11-19T15:17:48.756Z
8442504 8442504 20251111011218_2mM9t HR001K 2025-11-13T14:46:02.487Z 2025-11-19T15:16:33.248Z
8439784 8439784 20251112043654_Ch8mL HR001K 2025-11-13T14:27:20.093Z 2025-11-20T15:25:33.587Z
8438813 8438813 20251112024307_6Pbe6 HR001K 2025-11-13T14:24:57.819Z 2025-11-20T15:24:48.356Z
8438693 8438693 20251112022920_xXWI6 HR001K 2025-11-13T14:24:30.631Z 2025-11-20T15:24:45.714Z
8438653 8438653 20251112022345_Sf9Wg HR001K 2025-11-13T14:24:26.103Z 2025-11-20T15:24:44.866Z
8438012 8438012 20251112010915_fjc3P HR001K 2025-11-13T14:22:30.972Z 2025-11-20T15:24:08.708Z
8437790 8437790 20251112004512_030tk HR001K 2025-11-13T14:22:05.995Z 2025-11-20T15:23:53.634Z
8435464 8435464 20251111194012_02SgB HR001K 2025-11-13T14:15:36.267Z 2025-11-20T15:22:18.665Z
8433569 8433569 20251111170737_JHPcc HR001K 2025-11-13T14:10:28.011Z 2025-11-20T15:20:52.293Z
8433322 8433322 20251111165054_21U3u HR001K 2025-11-13T14:09:51.857Z 2025-11-20T15:20:40.960Z
8426951 8426951 20251111035717_BveRZ HR001K 2025-11-12T14:26:42.672Z 2025-11-19T15:17:36.429Z
8425169 8425169 20251111011928_u5MH5 HR001K 2025-11-12T14:22:10.790Z 2025-11-19T15:16:35.198Z
8423257 8423257 20251110230351_2bNYb HR001K 2025-11-12T14:18:11.494Z 2025-11-19T15:15:49.426Z
8423244 8423244 20251110230249_RDah3 HR001K 2025-11-12T14:18:10.615Z 2025-11-19T15:15:49.183Z
8422735 8422735 20251110222601_Ax4Wp HR001K 2025-11-12T14:16:59.987Z 2025-11-19T15:15:31.409Z
8422307 8422307 20251110215004_vTv3x HR001K 2025-11-12T14:16:04.929Z 2025-11-19T15:15:15.146Z
8421438 8421438 20251110204117_fOXTU HR001K 2025-11-12T14:14:03.504Z 2025-11-19T15:14:33.633Z
8421056 8421056 20251110200137_RKZa3 HR001K 2025-11-12T14:12:55.245Z 2025-11-19T15:14:22.276Z
8420936 8420936 20251110194910_cxSoq HR001K 2025-11-12T14:12:28.585Z 2025-11-19T15:14:17.641Z
8419686 8419686 20251110172022_iyDGw HR001K 2025-11-12T14:07:52.243Z 2025-11-19T15:13:20.737Z
8414953 8414953 20251110040503_kIVYh HR001K 2025-11-11T14:22:11.310Z 2025-11-18T15:21:15.271Z
8413696 8413696 20251110002107_XXZEZ HR001K 2025-11-11T14:18:07.845Z 2025-11-18T15:20:23.543Z
8413520 8413520 20251109234107_s3nwv HR001K 2025-11-11T14:17:38.321Z 2025-11-18T15:20:22.157Z
8413172 8413172 20251109222405_Zupz8 HR001K 2025-11-11T14:16:32.592Z 2025-11-18T15:20:19.102Z
8411504 8411504 20251109185616_hz8jC HR001K 2025-11-11T14:11:07.517Z 2025-11-18T15:19:41.097Z
8398433 8398433 20251108042740_ln5Ru HR001K 2025-11-09T14:15:20.190Z 2025-11-16T15:04:47.471Z
8398092 8398092 20251108033053_0abvo HR001K 2025-11-09T14:14:05.667Z 2025-11-16T15:04:35.225Z
8397043 8397043 20251108001449_qsf0s HR001K 2025-11-09T14:10:39.592Z 2025-11-16T15:03:59.304Z
8397037 8397037 20251108001258_jMtId HR001K 2025-11-09T14:10:37.950Z 2025-11-16T15:03:58.401Z
8395648 8395648 20251107173651_8RbZV HR001K 2025-11-09T14:05:20.776Z 2025-11-16T15:02:38.207Z
8168287 8168287 20251020033627_2BW3r HR001K 2025-10-22T12:35:29.233Z 2025-10-28T13:08:51.622Z
8168191 8168191 20251020032848_Ug72b HR001K 2025-10-22T12:35:07.492Z 2025-10-28T13:08:49.443Z
8167739 8167739 20251020025255_NitUv HR001K 2025-10-22T12:34:14.621Z 2025-10-28T13:08:40.832Z
8167625 8167625 20251020024209_m0w4X HR001K 2025-10-22T12:33:41.635Z 2025-10-28T13:08:40.071Z
8167621 8167621 20251020024207_lMb9q HR001K 2025-10-22T12:33:41.321Z 2025-10-28T13:08:39.837Z
8165961 8165961 20251020000807_t3bWM HR001K 2025-10-22T12:29:42.046Z 2025-10-28T13:08:12.253Z
8164357 8164357 20251019200042_e3o4c HR001K 2025-10-22T12:25:00.301Z 2025-10-28T13:07:52.265Z
8164252 8164252 20251019191034_ZQ12t HR001K 2025-10-22T12:24:17.423Z 2025-10-28T13:07:49.706Z
8164232 8164232 20251019190324_SsNlN HR001K 2025-10-22T12:24:12.070Z 2025-10-28T13:07:48.933Z
8164067 8164067 20251019175007_f9A7V HR001K 2025-10-22T12:23:05.817Z 2025-10-28T13:07:35.582Z
8144502 8144502 20251019011248_pDbwp HR001K 2025-10-20T12:17:33.611Z 2025-10-27T13:10:13.431Z
8143795 8143795 20251019000529_r8sft HR001K 2025-10-20T12:15:30.126Z 2025-10-27T13:10:07.057Z
8143635 8143635 20251018234837_MVaOF HR001K 2025-10-20T12:14:57.430Z 2025-10-27T13:10:05.024Z
8142953 8142953 20251018223956_TxFQ1 HR001K 2025-10-20T12:12:46.347Z 2025-10-27T13:10:02.492Z
8133888 8133888 20251018034505_ZeLxn HR001K 2025-10-19T12:14:33.756Z 2025-10-26T13:15:48.151Z
8123714 8123714 20251017040703_3FDHH HR001K 2025-10-18T12:27:10.385Z 2025-10-25T13:29:11.478Z
8122645 8122645 20251017021604_rkq3u HR001K 2025-10-18T12:24:26.878Z 2025-10-25T13:28:43.018Z
8122496 8122496 20251017020209_B9qxl HR001K 2025-10-18T12:23:52.097Z 2025-10-25T13:28:35.646Z
8122086 8122086 20251017011808_GbDTq HR001K 2025-10-18T12:22:26.014Z 2025-10-25T13:28:11.933Z
8121197 8121197 20251016230810_GEn3x HR001K 2025-10-18T12:19:20.919Z 2025-10-25T13:27:20.441Z
8120613 8120613 20251016205446_j20Lg HR001K 2025-10-18T12:17:13.866Z 2025-10-25T13:26:32.836Z
8120476 8120476 20251016202637_PRT2v HR001K 2025-10-18T12:16:44.738Z 2025-10-25T13:26:27.040Z
8120427 8120427 20251016202018_AsF2m HR001K 2025-10-18T12:16:38.315Z 2025-10-25T13:26:25.657Z
8119949 8119949 20251016191456_v3ihe HR001K 2025-10-18T12:14:57.774Z 2025-10-25T13:25:53.766Z
8119390 8119390 20251016175646_tHqZT HR001K 2025-10-18T12:12:58.393Z 2025-10-25T13:25:41.021Z
8113146 8113146 20251016042222_ut9do HR001K 2025-10-17T12:14:18.476Z 2025-10-24T13:16:50.873Z
8110821 8110821 20251015233257_b23FV HR001K 2025-10-17T12:08:40.076Z 2025-10-24T13:16:07.431Z
8110778 8110778 20251015232625_rj4pW HR001K 2025-10-17T12:08:35.896Z 2025-10-24T13:16:06.070Z
8110737 8110737 20251015231936_OsRvw HR001K 2025-10-17T12:08:33.194Z 2025-10-24T13:16:05.558Z
8104613 8104613 20251015022904_WzZyS HR001K 2025-10-16T12:16:45.402Z 2025-10-23T13:08:51.422Z

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