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

1,906 rows where station_code = "HR001N" 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
8653854 8653854 20251130024433_GHvRm HR001N 2025-12-01T14:24:23.046Z 2025-12-06T14:48:33.620Z
8653789 8653789 20251130024025_6Y5Yv HR001N 2025-12-01T14:24:14.729Z 2025-12-06T14:48:32.097Z
8647020 8647020 20251129032814_LBiOh HR001N 2025-11-30T14:27:19.397Z 2025-12-06T14:56:29.944Z
8644481 8644481 20251128192829_iVUq4 HR001N 2025-11-30T14:22:01.850Z 2025-12-06T14:54:42.811Z
8634257 8634257 20251128003215_QzhNG HR001N 2025-11-29T14:21:08.053Z 2025-12-06T15:01:53.943Z
8631668 8631668 20251127194227_gbJRB HR001N 2025-11-29T14:15:58.843Z 2025-12-06T15:00:34.636Z
8623486 8623486 20251127005214_CLpTy HR001N 2025-11-28T14:22:00.231Z 2025-12-05T15:03:56.241Z
8580246 8580246 20251123031443_hUexk HR001N 2025-11-24T14:16:29.107Z 2025-12-01T15:22:03.412Z
8580103 8580103 20251123023116_LMlD6 HR001N 2025-11-24T14:16:09.239Z 2025-12-01T15:21:39.462Z
8446252 8446252 20251112170624_ekeGY HR001N 2025-11-14T14:10:02.414Z 2025-11-21T15:11:08.587Z
8436931 8436931 20251111225041_gA7h5 HR001N 2025-11-13T14:19:41.260Z 2025-11-20T15:23:05.261Z
8436926 8436926 20251111225024_sPe7y HR001N 2025-11-13T14:19:40.503Z 2025-11-20T15:23:04.912Z
8434346 8434346 20251111180923_oRKUP HR001N 2025-11-13T14:12:34.912Z 2025-11-20T15:21:38.076Z
8434166 8434166 20251111175455_NCMuy HR001N 2025-11-13T14:12:16.445Z 2025-11-20T15:21:26.802Z
8426735 8426735 20251111033800_BPRDG HR001N 2025-11-12T14:26:15.536Z 2025-11-19T15:17:25.248Z
8425749 8425749 20251111021113_EnHBG HR001N 2025-11-12T14:23:33.615Z 2025-11-19T15:16:46.332Z
8420012 8420012 20251110180845_S0ekO HR001N 2025-11-12T14:09:09.344Z 2025-11-19T15:13:33.336Z
8381306 8381306 20251105044038_1JvZz HR001N 2025-11-06T14:14:46.365Z 2025-11-13T15:15:26.635Z
8381199 8381199 20251105042206_9EYp5 HR001N 2025-11-06T14:14:12.699Z 2025-11-13T15:15:20.963Z
8371369 8371369 20251104041556_7jQMf HR001N 2025-11-05T14:14:42.896Z 2025-11-12T15:11:00.585Z
8297075 8297075 20251028224202_CO3cR HR001N 2025-10-30T12:49:01.268Z 2025-11-06T15:12:25.473Z
8289018 8289018 20251028181129_8YJwP HR001N 2025-10-30T12:12:10.625Z 2025-11-06T15:11:37.235Z
8168069 8168069 20251020032009_BINru HR001N 2025-10-22T12:34:54.326Z 2025-10-28T13:08:46.240Z
8167249 8167249 20251020020827_dlhP5 HR001N 2025-10-22T12:33:02.236Z 2025-10-28T13:08:35.806Z
8167187 8167187 20251020020404_jwwsD HR001N 2025-10-22T12:32:37.694Z 2025-10-28T13:08:34.184Z
8166351 8166351 20251020004655_SLC3r HR001N 2025-10-22T12:30:38.429Z 2025-10-28T13:08:20.729Z
8147022 8147022 20251019043035_E23uh HR001N 2025-10-20T12:23:59.337Z 2025-10-27T13:10:47.088Z
8134010 8134010 20251018035449_2bVyp HR001N 2025-10-19T12:14:43.566Z 2025-10-26T13:15:50.847Z
8112935 8112935 20251016040000_Sqynk HR001N 2025-10-17T12:13:44.620Z 2025-10-24T13:16:49.821Z
8112628 8112628 20251016033210_477mQ HR001N 2025-10-17T12:13:23.412Z 2025-10-24T13:16:47.667Z
8112524 8112524 20251016032105_t4fhs HR001N 2025-10-17T12:12:55.651Z 2025-10-24T13:16:46.989Z
8103841 8103841 20251014235720_0AlRI HR001N 2025-10-16T12:13:47.708Z 2025-10-23T13:08:34.920Z
8099040 8099040 20251014025503_7ZG7Y HR001N 2025-10-15T12:17:56.454Z 2025-10-22T13:10:02.807Z
8008634 8008634 20250929024956_ani3L HR001N 2025-09-30T12:30:22.046Z 2025-10-07T13:01:14.513Z
8003426 8003426 20250928225126_tiyxQ HR001N 2025-09-30T12:20:26.885Z 2025-10-07T13:00:40.153Z
8002890 8002890 20250928222529_nr0km HR001N 2025-09-30T12:19:12.768Z 2025-10-07T13:00:37.249Z
7934634 7934634 20250922010056_4E3fU HR001N 2025-09-24T12:52:28.366Z 2025-09-30T13:03:13.638Z
7928521 7928521 20250921195938_uAwNA HR001N 2025-09-24T12:45:57.693Z 2025-09-30T13:02:11.482Z
7914899 7914899 20250922192125_0ms5u HR001N 2025-09-24T12:18:59.546Z 2025-10-01T13:23:06.340Z
7898120 7898120 20250921032105_1PldB HR001N 2025-09-22T12:05:00.750Z 2025-09-30T13:01:02.627Z
7897955 7897955 20250921030911_oih3o HR001N 2025-09-22T12:04:21.157Z 2025-09-30T13:00:59.859Z
7896060 7896060 20250920003107_v2q28 HR001N 2025-09-21T12:39:31.427Z 2025-09-28T12:54:47.231Z
7892530 7892530 20250919200546_Dc8ZC HR001N 2025-09-21T12:33:53.594Z 2025-09-28T12:54:18.586Z
7891619 7891619 20250919181827_dD74q HR001N 2025-09-21T12:32:03.129Z 2025-09-28T12:54:10.925Z
7882666 7882666 20250919001552_9mABh HR001N 2025-09-20T12:36:54.608Z 2025-09-27T12:47:56.334Z
7880135 7880135 20250918205936_vQiSp HR001N 2025-09-20T12:32:16.094Z 2025-09-27T12:47:37.333Z
7880073 7880073 20250918205158_hp6oB HR001N 2025-09-20T12:32:10.975Z 2025-09-27T12:47:37.081Z
7870873 7870873 20250917223548_3Arrv HR001N 2025-09-19T12:29:51.980Z 2025-09-25T13:13:00.552Z
7870789 7870789 20250917222755_eSp4z HR001N 2025-09-19T12:29:42.730Z 2025-09-25T13:12:59.885Z
7870526 7870526 20250917215829_sIJDN HR001N 2025-09-19T12:29:00.327Z 2025-09-25T13:12:58.231Z
7870328 7870328 20250917213718_3LjwH HR001N 2025-09-19T12:28:38.199Z 2025-09-25T13:12:56.664Z
7865082 7865082 20250918014726_2JP6R HR001N 2025-09-19T12:04:33.743Z 2025-09-27T12:46:02.423Z
7854921 7854921 20250915205331_DJRaz HR001N 2025-09-17T12:35:46.993Z 2025-09-22T13:05:45.912Z
7842779 7842779 20250914213005_uLT0t HR001N 2025-09-16T12:34:47.408Z 2025-09-22T13:09:23.990Z
7842635 7842635 20250914210844_jbpTa HR001N 2025-09-16T12:34:40.951Z 2025-09-22T13:09:21.277Z
7823873 7823873 20250912194139_uGfxt HR001N 2025-09-14T12:28:59.128Z 2025-09-20T13:03:04.328Z
7823782 7823782 20250912191616_vrHn3 HR001N 2025-09-14T12:28:50.932Z 2025-09-20T13:03:00.615Z
7809546 7809546 20250911213747_cFAhM HR001N 2025-09-13T12:02:15.791Z 2025-09-20T13:01:14.054Z
7809201 7809201 20250911205104_bxZVJ HR001N 2025-09-13T12:00:38.886Z 2025-09-20T13:01:04.791Z
7783153 7783153 20250906214319_scPo9 HR001N 2025-09-08T12:05:03.130Z 2025-09-15T12:43:09.096Z
7770404 7770404 20250905004829_WYJoz HR001N 2025-09-06T13:04:37.080Z 2025-09-13T12:56:42.232Z
7742133 7742133 20250902020241_FSTZE HR001N 2025-09-03T12:21:38.165Z 2025-09-10T12:47:08.488Z
7740704 7740704 20250902004038_yDBKi HR001N 2025-09-03T12:18:39.977Z 2025-09-10T12:46:38.275Z
7739706 7739706 20250901233446_DO7ye HR001N 2025-09-03T12:16:29.193Z 2025-09-10T12:46:16.882Z
7738574 7738574 20250901220358_re0ga HR001N 2025-09-03T12:13:08.927Z 2025-09-10T12:45:50.280Z
7737679 7737679 20250901203318_ZnsQw HR001N 2025-09-03T12:10:08.143Z 2025-09-10T12:45:30.720Z
7728653 7728653 20250901004633_GXvL2 HR001N 2025-09-02T12:23:19.620Z 2025-09-09T12:48:19.212Z
7727299 7727299 20250831232607_KWrQ3 HR001N 2025-09-02T12:20:39.225Z 2025-09-09T12:47:47.536Z
7727032 7727032 20250831230944_KlVDV HR001N 2025-09-02T12:20:01.679Z 2025-09-09T12:47:41.299Z
7725324 7725324 20250831204744_35RHo HR001N 2025-09-02T12:15:18.822Z 2025-09-09T12:46:51.770Z
7725101 7725101 20250831203425_bcHAM HR001N 2025-09-02T12:14:35.017Z 2025-09-09T12:46:40.314Z
7673302 7673302 20250827012903_FWY9t HR001N 2025-08-28T12:24:07.498Z 2025-09-04T12:56:27.052Z
7669603 7669603 20250826202353_5hciQ HR001N 2025-08-28T12:16:08.664Z 2025-09-04T12:55:36.414Z
7669508 7669508 20250826200950_66uDd HR001N 2025-08-28T12:15:35.809Z 2025-09-04T12:55:35.969Z
7663194 7663194 20250826030317_lyOEJ HR001N 2025-08-27T12:29:55.803Z 2025-09-03T12:53:05.798Z
7662339 7662339 20250826021845_X2HuG HR001N 2025-08-27T12:28:11.622Z 2025-09-03T12:53:02.041Z
7659750 7659750 20250826001701_xsgU9 HR001N 2025-08-27T12:22:45.342Z 2025-09-03T12:52:48.350Z
7659236 7659236 20250825235120_qTOLJ HR001N 2025-08-27T12:21:42.385Z 2025-09-03T12:52:42.170Z
7656876 7656876 20250825212713_hoGTL HR001N 2025-08-27T12:16:15.123Z 2025-09-03T12:52:14.928Z
7656750 7656750 20250825211813_iZrq3 HR001N 2025-08-27T12:15:58.344Z 2025-09-03T12:52:13.998Z
7655541 7655541 20250825193512_Hvg8B HR001N 2025-08-27T12:12:47.300Z 2025-09-03T12:52:06.417Z
7655522 7655522 20250825193153_9zP27 HR001N 2025-08-27T12:12:43.661Z 2025-09-03T12:52:06.238Z
7643885 7643885 20250824195536_8N8zL HR001N 2025-08-26T12:18:35.355Z 2025-09-02T12:51:22.442Z
7622255 7622255 20250822193730_h3n2o HR001N 2025-08-24T12:19:07.531Z 2025-08-31T12:53:51.860Z
7589150 7589150 20250819000601_b2uBN HR001N 2025-08-21T12:36:42.924Z 2025-08-27T13:15:28.883Z
7585350 7585350 20250820020813_Za9T1 HR001N 2025-08-21T12:23:52.005Z 2025-08-28T12:52:42.041Z
7561792 7561792 20250816222155_oh2g3 HR001N 2025-08-19T13:00:12.921Z 2025-08-24T12:48:55.344Z
7559635 7559635 20250816194334_G5Osa HR001N 2025-08-19T12:55:53.188Z 2025-08-24T12:48:44.177Z
7550206 7550206 20250817001135_ZiKse HR001N 2025-08-19T12:04:40.661Z 2025-08-25T12:51:40.319Z
7532493 7532493 20250816015445_PZlCF HR001N 2025-08-18T12:09:58.978Z 2025-08-24T12:47:38.747Z
7530971 7530971 20250816001707_24NBY HR001N 2025-08-18T12:05:17.384Z 2025-08-24T12:47:30.827Z
7529947 7529947 20250815231804_y7qi8 HR001N 2025-08-18T12:01:47.647Z 2025-08-24T12:47:26.425Z
7528899 7528899 20250814213911_tpClb HR001N 2025-08-17T12:49:42.061Z 2025-08-22T12:47:34.898Z
7505112 7505112 20250814010139_3KtK8 HR001N 2025-08-16T12:49:01.131Z 2025-08-22T12:46:47.345Z
7504372 7504372 20250814001900_0Jhjj HR001N 2025-08-16T12:48:01.947Z 2025-08-22T12:46:44.196Z
7503680 7503680 20250813201431_6urVT HR001N 2025-08-16T12:45:22.515Z 2025-08-21T12:48:27.312Z
7496280 7496280 20250813215838_EfI3u HR001N 2025-08-16T12:05:41.660Z 2025-08-22T12:46:38.005Z
7496141 7496141 20250813215226_EUIzo HR001N 2025-08-16T12:05:12.336Z 2025-08-22T12:46:37.802Z
7496090 7496090 20250813214920_uZ9xY HR001N 2025-08-16T12:04:59.938Z 2025-08-22T12:46:37.714Z
7495429 7495429 20250813211047_6tszX HR001N 2025-08-16T12:01:54.996Z 2025-08-22T12:46:35.163Z

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