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,329 rows where station_code = "US005H" 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
8670416 8670416 20251201084814_wEfuH US005H 2025-12-03T14:08:40.041Z 2025-12-05T14:23:21.171Z
8670401 8670401 20251201083733_MyLh3 US005H 2025-12-03T14:08:32.552Z 2025-12-05T14:23:20.263Z
8668224 8668224 20251130065037_lP3qh US005H 2025-12-02T14:42:12.779Z 2025-12-05T14:46:03.840Z
8668151 8668151 20251130062020_51cep US005H 2025-12-02T14:42:05.521Z 2025-12-05T14:45:58.886Z
8667652 8667652 20251130030728_TP9wR US005H 2025-12-02T14:39:36.207Z 2025-12-05T14:43:52.538Z
8667585 8667585 20251130022526_ArEbH US005H 2025-12-02T14:38:58.680Z 2025-12-05T14:43:34.829Z
8667479 8667479 20251130014804_ZKqrZ US005H 2025-12-02T14:38:38.247Z 2025-12-05T14:42:58.480Z
8636941 8636941 20251128043934_hp2nA US005H 2025-11-29T14:26:22.572Z 2025-12-05T14:59:32.634Z
8626206 8626206 20251126081211_3iCP4 US005H 2025-11-28T14:38:09.348Z 2025-12-04T15:12:00.059Z
8626193 8626193 20251126080926_eLoP3 US005H 2025-11-28T14:38:08.038Z 2025-12-04T15:11:59.315Z
8626127 8626127 20251126074446_QZ5Cc US005H 2025-11-28T14:37:46.720Z 2025-12-04T15:11:53.305Z
8626095 8626095 20251126073354_YHuNy US005H 2025-11-28T14:37:39.897Z 2025-12-04T15:11:52.292Z
8626041 8626041 20251126071126_x62WI US005H 2025-11-28T14:37:33.041Z 2025-12-04T15:11:50.832Z
8626025 8626025 20251126070500_31xZa US005H 2025-11-28T14:37:31.807Z 2025-12-04T15:11:50.371Z
8626015 8626015 20251126070003_2S0OJ US005H 2025-11-28T14:37:31.088Z 2025-12-04T15:11:50.031Z
8625945 8625945 20251126064106_ATbNb US005H 2025-11-28T14:37:26.266Z 2025-12-04T15:11:44.200Z
8625933 8625933 20251126063824_W3sPn US005H 2025-11-28T14:37:25.466Z 2025-12-04T15:11:43.899Z
8625838 8625838 20251126055334_hnQpU US005H 2025-11-28T14:37:15.413Z 2025-12-04T15:11:38.428Z
8625649 8625649 20251126035423_tUPRX US005H 2025-11-28T14:35:30.316Z 2025-12-04T15:10:27.128Z
8625599 8625599 20251126033059_dX7vL US005H 2025-11-28T14:35:19.912Z 2025-12-04T15:09:50.989Z
8625597 8625597 20251126032941_ky7MY US005H 2025-11-28T14:35:19.377Z 2025-12-04T15:09:50.714Z
8625432 8625432 20251126005740_AKXNM US005H 2025-11-28T14:33:26.589Z 2025-12-04T15:08:14.583Z
8624391 8624391 20251127043357_4sY8o US005H 2025-11-28T14:24:35.421Z 2025-12-05T15:05:01.857Z
8617431 8617431 20251127092508_2M7BU US005H 2025-11-28T14:00:49.391Z 2025-12-05T14:53:52.209Z
8617394 8617394 20251127091857_de4UP US005H 2025-11-28T14:00:40.931Z 2025-12-05T14:53:48.710Z
8617294 8617294 20251127085641_eRK75 US005H 2025-11-28T14:00:18.004Z 2025-12-05T14:53:40.251Z
8617292 8617292 20251127085625_cosqX US005H 2025-11-28T14:00:17.518Z 2025-12-05T14:53:40.003Z
8617022 8617022 20251126081838_dzFJ3 US005H 2025-11-27T14:32:09.737Z 2025-12-04T15:12:01.284Z
8617012 8617012 20251126081553_r3eLm US005H 2025-11-27T14:32:09.090Z 2025-12-04T15:12:00.973Z
8616904 8616904 20251126071016_EW3yE US005H 2025-11-27T14:31:59.053Z 2025-12-04T15:11:50.677Z
8616902 8616902 20251126071012_RTfyC US005H 2025-11-27T14:31:58.700Z 2025-12-04T15:11:50.648Z
8616869 8616869 20251126065703_dXywc US005H 2025-11-27T14:31:56.545Z 2025-12-04T15:11:49.736Z
8614640 8614640 20251126042124_AwbXh US005H 2025-11-27T14:28:11.891Z 2025-12-04T15:10:57.098Z
8614026 8614026 20251126034802_xFjgI US005H 2025-11-27T14:27:06.978Z 2025-12-04T15:10:11.603Z
8610978 8610978 20251126011633_6ieRQ US005H 2025-11-27T14:21:00.539Z 2025-12-04T15:08:46.194Z
8593696 8593696 20251125122759_ypH8Z US005H 2025-11-26T14:03:10.835Z 2025-12-04T15:05:22.674Z
8593671 8593671 20251125122053_tWJLz US005H 2025-11-26T14:03:01.468Z 2025-12-04T15:05:22.236Z
8593666 8593666 20251125121918_BBKmQ US005H 2025-11-26T14:03:00.185Z 2025-12-04T15:05:22.159Z
8592821 8592821 20251124092930_DQGt7 US005H 2025-11-25T14:28:03.500Z 2025-12-02T15:13:07.772Z
8592798 8592798 20251124092651_eR6SB US005H 2025-11-25T14:27:50.220Z 2025-12-02T15:13:07.617Z
8592763 8592763 20251124092053_IV6I0 US005H 2025-11-25T14:27:41.286Z 2025-12-02T15:13:07.197Z
8592731 8592731 20251124091305_hjS95 US005H 2025-11-25T14:27:32.750Z 2025-12-02T15:13:06.851Z
8592726 8592726 20251124091223_9JSqf US005H 2025-11-25T14:27:32.298Z 2025-12-02T15:13:06.802Z
8592685 8592685 20251124085827_2o4sv US005H 2025-11-25T14:27:27.872Z 2025-12-02T15:13:06.394Z
8592550 8592550 20251124081848_XXGrE US005H 2025-11-25T14:27:08.566Z 2025-12-02T15:13:05.155Z
8583765 8583765 20251124125017_gHLph US005H 2025-11-25T14:03:49.105Z 2025-12-02T15:05:37.798Z
8583730 8583730 20251124124027_5svbo US005H 2025-11-25T14:03:39.664Z 2025-11-25T14:03:39.664Z
8583709 8583709 20251124123526_dJo0h US005H 2025-11-25T14:03:29.339Z 2025-11-25T14:03:29.339Z
8583673 8583673 20251124121935_z7Unm US005H 2025-11-25T14:03:16.606Z 2025-12-02T15:05:34.868Z
8583625 8583625 20251124120436_GnI24 US005H 2025-11-25T14:03:05.555Z 2025-12-02T15:05:34.037Z
8583134 8583134 20251124094128_uePmH US005H 2025-11-25T14:00:23.011Z 2025-12-02T15:05:25.809Z
8583127 8583127 20251124094002_kPPHO US005H 2025-11-25T14:00:21.490Z 2025-12-02T15:05:25.760Z
8582779 8582779 20251123082859_VHCG2 US005H 2025-11-24T14:34:30.356Z 2025-12-01T15:22:27.859Z
8582675 8582675 20251123074844_qdqRp US005H 2025-11-24T14:34:24.720Z 2025-12-01T15:22:26.426Z
8582656 8582656 20251123073739_lW9MJ US005H 2025-11-24T14:34:23.851Z 2025-12-01T15:22:26.244Z
8582545 8582545 20251123065924_eVjqL US005H 2025-11-24T14:34:00.019Z 2025-12-01T15:22:25.082Z
8582320 8582320 20251123053319_HRz0W US005H 2025-11-24T14:33:29.329Z 2025-12-01T15:22:22.041Z
8582318 8582318 20251123053226_LKrBU US005H 2025-11-24T14:33:29.227Z 2025-12-01T15:22:21.970Z
8582196 8582196 20251123043849_ADCoq US005H 2025-11-24T14:33:22.129Z 2025-12-01T15:22:18.491Z
8582105 8582105 20251123040843_7g7XN US005H 2025-11-24T14:33:17.039Z 2025-12-01T15:22:16.235Z
8582035 8582035 20251123034833_oD7O1 US005H 2025-11-24T14:33:12.489Z 2025-12-01T15:22:14.494Z
8581806 8581806 20251123023325_wyml5 US005H 2025-11-24T14:32:39.261Z 2025-12-01T15:21:40.637Z
8581782 8581782 20251123022043_NZEBI US005H 2025-11-24T14:32:37.687Z 2025-12-01T15:21:36.567Z
8581727 8581727 20251123015437_DLP2P US005H 2025-11-24T14:32:34.382Z 2025-12-01T15:21:20.396Z
8581706 8581706 20251123014805_MtZ33 US005H 2025-11-24T14:32:33.216Z 2025-12-01T15:21:18.019Z
8581649 8581649 20251123012901_r2lj7 US005H 2025-11-24T14:32:29.389Z 2025-12-01T15:21:11.505Z
8581526 8581526 20251123004203_bVBQw US005H 2025-11-24T14:31:43.526Z 2025-12-01T15:20:52.903Z
8581063 8581063 20251122093654_suXce US005H 2025-11-24T14:29:30.074Z 2025-11-30T15:07:20.802Z
8580935 8580935 20251122085956_Xavun US005H 2025-11-24T14:29:06.691Z 2025-11-30T15:07:16.386Z
8580928 8580928 20251122085841_XTQEZ US005H 2025-11-24T14:29:06.038Z 2025-11-30T15:07:16.341Z
8580871 8580871 20251122083005_q02Tx US005H 2025-11-24T14:29:01.207Z 2025-11-30T15:07:14.137Z
8580861 8580861 20251122082228_assD6 US005H 2025-11-24T14:29:00.490Z 2025-11-30T15:07:12.732Z
8574456 8574456 20251122064734_K52iC US005H 2025-11-23T14:43:36.074Z 2025-11-23T14:43:36.074Z
8574426 8574426 20251122063724_Rv0Tr US005H 2025-11-23T14:43:34.300Z 2025-11-30T15:07:08.586Z
8574169 8574169 20251122052113_JFwtQ US005H 2025-11-23T14:42:37.163Z 2025-11-30T15:07:01.205Z
8573966 8573966 20251122045030_HzkKA US005H 2025-11-23T14:42:09.321Z 2025-11-30T15:06:53.874Z
8573891 8573891 20251122043301_3mxeW US005H 2025-11-23T14:42:05.407Z 2025-11-23T14:42:05.407Z
8573889 8573889 20251122043300_H1vk4 US005H 2025-11-23T14:42:05.269Z 2025-11-30T15:06:48.175Z
8553420 8553420 20251120053325_d9ife US005H 2025-11-22T14:33:56.914Z 2025-11-28T14:58:07.246Z
8530104 8530104 20251119105936_Eo1MK US005H 2025-11-21T14:00:23.739Z 2025-11-28T14:52:58.538Z
8530047 8530047 20251119104947_2phq2 US005H 2025-11-21T14:00:13.039Z 2025-11-28T14:52:55.039Z
8529763 8529763 20251119104141_w2Zn7 US005H 2025-11-20T14:45:37.893Z 2025-11-20T14:45:37.893Z
8529761 8529761 20251119104056_gA2Ce US005H 2025-11-20T14:45:37.632Z 2025-11-27T15:13:38.754Z
8529705 8529705 20251119103209_1vG7K US005H 2025-11-20T14:45:17.337Z 2025-11-27T15:13:37.529Z
8529693 8529693 20251119102917_pgTLr US005H 2025-11-20T14:45:14.512Z 2025-11-27T15:13:36.717Z
8529638 8529638 20251119101504_Pk8wF US005H 2025-11-20T14:45:07.223Z 2025-11-27T15:13:34.514Z
8529606 8529606 20251119100419_9o8UU US005H 2025-11-20T14:45:05.647Z 2025-11-20T14:45:05.647Z
8529567 8529567 20251119094749_hxVBm US005H 2025-11-20T14:45:03.914Z 2025-11-27T15:13:33.389Z
8529557 8529557 20251119094108_uLaSy US005H 2025-11-20T14:45:03.347Z 2025-11-27T15:13:33.176Z
8529549 8529549 20251119093905_Tz23R US005H 2025-11-20T14:45:01.897Z 2025-11-27T15:13:32.845Z
8529530 8529530 20251119092545_MH4Jo US005H 2025-11-20T14:45:00.683Z 2025-11-27T15:13:32.191Z
8529524 8529524 20251119092259_BFhis US005H 2025-11-20T14:45:00.334Z 2025-11-27T15:13:32.083Z
8529522 8529522 20251119092055_jRWoD US005H 2025-11-20T14:45:00.160Z 2025-11-27T15:13:32.025Z
8529513 8529513 20251119091453_LOStO US005H 2025-11-20T14:44:59.629Z 2025-11-27T15:13:31.807Z
8529499 8529499 20251119090402_iw4Wc US005H 2025-11-20T14:44:58.756Z 2025-11-27T15:13:31.143Z
8529491 8529491 20251119085545_Ci141 US005H 2025-11-20T14:44:58.411Z 2025-11-20T14:44:58.411Z
8529476 8529476 20251119084630_P5crf US005H 2025-11-20T14:44:57.658Z 2025-11-27T15:13:30.696Z
8529470 8529470 20251119084420_4t2kx US005H 2025-11-20T14:44:57.313Z 2025-11-27T15:13:30.607Z
8529426 8529426 20251119080559_I27ux US005H 2025-11-20T14:44:55.406Z 2025-11-27T15:13:29.000Z
8529414 8529414 20251119075939_x5RLa US005H 2025-11-20T14:44:55.153Z 2025-11-20T14:44:55.153Z

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