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

>10,000 rows count all where station_code = "HR0024" 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
6829238 6829238 20250530001513_SBa3H HR0024 2025-05-31T12:17:59.976Z 2025-06-07T12:36:30.998Z
6829234 6829234 20250530001441_2cMTF HR0024 2025-05-31T12:17:57.896Z 2025-06-07T12:36:30.768Z
6638843 6638843 20250503022511_EK58g HR0024 2025-05-04T12:17:31.133Z 2025-05-11T12:37:15.478Z
6638666 6638666 20250503020450_Xhr9X HR0024 2025-05-04T12:17:17.510Z 2025-05-11T12:37:13.662Z
6638413 6638413 20250503014103_MOaYd HR0024 2025-05-04T12:16:43.470Z 2025-05-11T12:37:11.545Z
6638315 6638315 20250503013103_yx5tU HR0024 2025-05-04T12:16:34.565Z 2025-05-11T12:37:10.730Z
6638227 6638227 20250503012519_3XywC HR0024 2025-05-04T12:16:28.172Z 2025-05-11T12:37:09.532Z
6638198 6638198 20250503012223_FarHN HR0024 2025-05-04T12:16:25.876Z 2025-05-11T12:37:09.122Z
6638156 6638156 20250503011629_30l3F HR0024 2025-05-04T12:16:22.738Z 2025-05-11T12:37:08.747Z
6638097 6638097 20250503011152_W7KYG HR0024 2025-05-04T12:16:04.948Z 2025-05-11T12:37:08.217Z
6638091 6638091 20250503011146_8el2u HR0024 2025-05-04T12:16:03.854Z 2025-05-11T12:37:08.132Z
6638083 6638083 20250503011036_HMjMU HR0024 2025-05-04T12:16:02.063Z 2025-05-11T12:37:07.976Z
6638059 6638059 20250503010940_oKCBo HR0024 2025-05-04T12:16:00.374Z 2025-05-11T12:37:07.840Z
6637948 6637948 20250503005507_euwW7 HR0024 2025-05-04T12:15:50.105Z 2025-05-11T12:37:06.651Z
6637803 6637803 20250503003939_mc9vk HR0024 2025-05-04T12:15:25.203Z 2025-05-11T12:37:03.511Z
6637600 6637600 20250503001550_BbuW2 HR0024 2025-05-04T12:15:05.661Z 2025-05-11T12:37:00.364Z
6637239 6637239 20250502233649_qa96J HR0024 2025-05-04T12:14:17.482Z 2025-05-11T12:36:55.440Z
6637176 6637176 20250502232816_mNClN HR0024 2025-05-04T12:14:09.443Z 2025-05-11T12:36:54.805Z
6637034 6637034 20250502231053_vjN22 HR0024 2025-05-04T12:13:46.276Z 2025-05-11T12:36:53.145Z
6637011 6637011 20250502230923_p7u2I HR0024 2025-05-04T12:13:44.978Z 2025-05-11T12:36:53.018Z
6636944 6636944 20250502230136_G8mX2 HR0024 2025-05-04T12:13:38.903Z 2025-05-11T12:36:52.219Z
6636763 6636763 20250502223714_13eum HR0024 2025-05-04T12:13:07.631Z 2025-05-11T12:36:49.666Z
6636627 6636627 20250502220827_CYLmL HR0024 2025-05-04T12:12:49.644Z 2025-05-11T12:36:47.025Z
6636528 6636528 20250502214728_ctDPI HR0024 2025-05-04T12:12:38.763Z 2025-05-11T12:36:45.546Z
6636493 6636493 20250502214212_5Z3AJ HR0024 2025-05-04T12:12:25.083Z 2025-05-11T12:36:45.073Z
6636369 6636369 20250502212746_WvBzA HR0024 2025-05-04T12:12:07.349Z 2025-05-11T12:36:42.799Z
6636193 6636193 20250502205857_OqLrg HR0024 2025-05-04T12:11:43.013Z 2025-05-11T12:36:40.400Z
6636185 6636185 20250502205602_G4b3z HR0024 2025-05-04T12:11:38.681Z 2025-05-11T12:36:40.261Z
6636172 6636172 20250502205122_hAYss HR0024 2025-05-04T12:11:31.311Z 2025-05-11T12:36:40.022Z
6636138 6636138 20250502201434_hiKRb HR0024 2025-05-04T12:11:14.542Z 2025-05-11T12:36:38.862Z
6636123 6636123 20250502200916_7rJGT HR0024 2025-05-04T12:11:12.113Z 2025-05-11T12:36:38.582Z
6630073 6630073 20250502021713_HV6s2 HR0024 2025-05-03T12:16:44.487Z 2025-05-10T12:37:30.830Z
6630069 6630069 20250502021653_u9Fi0 HR0024 2025-05-03T12:16:44.019Z 2025-05-10T12:37:30.808Z
6629907 6629907 20250502020356_XY2qX HR0024 2025-05-03T12:16:16.737Z 2025-05-10T12:37:29.910Z
6629896 6629896 20250502020336_b1QJP HR0024 2025-05-03T12:16:15.866Z 2025-05-10T12:37:29.838Z
6629868 6629868 20250502020240_rZ8gd HR0024 2025-05-03T12:16:14.343Z 2025-05-10T12:37:29.746Z
6629857 6629857 20250502020121_NtRco HR0024 2025-05-03T12:16:12.889Z 2025-05-10T12:37:29.703Z
6629825 6629825 20250502015559_jC1OE HR0024 2025-05-03T12:16:09.971Z 2025-05-10T12:37:29.519Z
6629782 6629782 20250502015017_hij7g HR0024 2025-05-03T12:16:06.977Z 2025-05-10T12:37:29.325Z
6629714 6629714 20250502014351_U9ItY HR0024 2025-05-03T12:16:02.192Z 2025-05-10T12:37:29.050Z
6629706 6629706 20250502014348_miUUm HR0024 2025-05-03T12:16:00.090Z 2025-05-10T12:37:29.002Z
6629639 6629639 20250502013545_Tj8LL HR0024 2025-05-03T12:15:44.274Z 2025-05-10T12:37:28.659Z
6629619 6629619 20250502013306_nwXYG HR0024 2025-05-03T12:15:42.669Z 2025-05-10T12:37:28.580Z
6629544 6629544 20250502012609_agQy1 HR0024 2025-05-03T12:15:35.853Z 2025-05-10T12:37:28.212Z
6629454 6629454 20250502011823_I9XdC HR0024 2025-05-03T12:15:30.398Z 2025-05-10T12:37:27.876Z
6629380 6629380 20250502010713_3ZRdV HR0024 2025-05-03T12:15:15.590Z 2025-05-10T12:37:27.524Z
6629360 6629360 20250502010519_2KuAy HR0024 2025-05-03T12:15:13.099Z 2025-05-10T12:37:27.395Z
6629324 6629324 20250502005827_tNasX HR0024 2025-05-03T12:15:08.108Z 2025-05-10T12:37:27.017Z
6629310 6629310 20250502005625_XyWFR HR0024 2025-05-03T12:15:06.895Z 2025-05-10T12:37:26.936Z
6629256 6629256 20250502004702_RxR9E HR0024 2025-05-03T12:15:00.273Z 2025-05-10T12:37:26.305Z
6629191 6629191 20250502004037_Gb6cv HR0024 2025-05-03T12:14:55.959Z 2025-05-10T12:37:25.995Z
6629156 6629156 20250502003747_e9m42 HR0024 2025-05-03T12:14:53.214Z 2025-05-10T12:37:25.870Z
6629146 6629146 20250502003644_rTaQm HR0024 2025-05-03T12:14:52.028Z 2025-05-10T12:37:25.803Z
6628941 6628941 20250502000640_ai75K HR0024 2025-05-03T12:14:21.962Z 2025-05-10T12:37:24.082Z
6628928 6628928 20250502000541_mkmGg HR0024 2025-05-03T12:14:20.712Z 2025-05-10T12:37:23.807Z
6628851 6628851 20250501235844_2plf3 HR0024 2025-05-03T12:14:14.432Z 2025-05-10T12:37:23.246Z
6628832 6628832 20250501235648_1Gsrq HR0024 2025-05-03T12:14:12.288Z 2025-05-10T12:37:23.090Z
6628649 6628649 20250501233728_alrVQ HR0024 2025-05-03T12:13:41.811Z 2025-05-10T12:37:21.399Z
6628590 6628590 20250501232907_0IT54 HR0024 2025-05-03T12:13:34.878Z 2025-05-10T12:37:20.789Z
6628304 6628304 20250501223314_iFVb3 HR0024 2025-05-03T12:12:55.417Z 2025-05-10T12:37:18.362Z
6628288 6628288 20250501223016_sdEDx HR0024 2025-05-03T12:12:52.805Z 2025-05-10T12:37:18.315Z
6628260 6628260 20250501222414_JDjta HR0024 2025-05-03T12:12:41.786Z 2025-05-10T12:37:18.225Z
6628179 6628179 20250501220712_YIpIo HR0024 2025-05-03T12:12:26.791Z 2025-05-10T12:37:17.543Z
6628163 6628163 20250501220100_yhdcy HR0024 2025-05-03T12:12:23.325Z 2025-05-10T12:37:17.295Z
6628139 6628139 20250501215617_x6X4l HR0024 2025-05-03T12:12:20.908Z 2025-05-10T12:37:17.106Z
6628062 6628062 20250501213608_1Q7oM HR0024 2025-05-03T12:12:05.696Z 2025-05-10T12:37:16.132Z
6628053 6628053 20250501213449_1a2Sx HR0024 2025-05-03T12:12:03.696Z 2025-05-10T12:37:16.076Z
6628029 6628029 20250501212528_Jdd3k HR0024 2025-05-03T12:11:59.581Z 2025-05-10T12:37:15.678Z
6627922 6627922 20250501205014_u7HnE HR0024 2025-05-03T12:11:42.788Z 2025-05-10T12:37:14.029Z
6627865 6627865 20250501201503_atPRH HR0024 2025-05-03T12:11:23.679Z 2025-05-10T12:37:12.849Z
6627862 6627862 20250501201402_H8rBy HR0024 2025-05-03T12:11:23.098Z 2025-05-10T12:37:12.820Z
6627849 6627849 20250501200919_2uc43 HR0024 2025-05-03T12:11:20.878Z 2025-05-10T12:37:12.340Z
6627685 6627685 20250501191738_c0ypr HR0024 2025-05-03T12:10:49.136Z 2025-05-10T12:37:10.031Z
6622489 6622489 20250501023512_nP723 HR0024 2025-05-02T12:17:47.787Z 2025-05-09T12:38:31.964Z
6622034 6622034 20250501021020_HSl6k HR0024 2025-05-02T12:17:18.199Z 2025-05-09T12:38:28.648Z
6622026 6622026 20250501020938_rTqQU HR0024 2025-05-02T12:17:17.527Z 2025-05-09T12:38:28.603Z
6621862 6621862 20250501020025_rEWBa HR0024 2025-05-02T12:16:49.973Z 2025-05-09T12:38:27.639Z
6621844 6621844 20250501015907_rfu9m HR0024 2025-05-02T12:16:46.707Z 2025-05-09T12:38:27.531Z
6621826 6621826 20250501015731_tWRKR HR0024 2025-05-02T12:16:45.435Z 2025-05-09T12:38:27.458Z
6621796 6621796 20250501015506_QOTZh HR0024 2025-05-02T12:16:42.836Z 2025-05-09T12:38:27.236Z
6621698 6621698 20250501014840_blT3a HR0024 2025-05-02T12:16:36.099Z 2025-05-09T12:38:26.254Z
6621593 6621593 20250501014337_2daR5 HR0024 2025-05-02T12:16:30.755Z 2025-05-09T12:38:25.250Z
6621571 6621571 20250501014106_lBPVi HR0024 2025-05-02T12:16:29.120Z 2025-05-09T12:38:25.139Z
6621570 6621570 20250501014105_WpEuM HR0024 2025-05-02T12:16:28.922Z 2025-05-09T12:38:25.108Z
6621515 6621515 20250501013628_i4Fbj HR0024 2025-05-02T12:16:25.672Z 2025-05-09T12:38:24.831Z
6621410 6621410 20250501012717_Q2GUC HR0024 2025-05-02T12:16:14.611Z 2025-05-09T12:38:23.565Z
6621359 6621359 20250501012230_amkg1 HR0024 2025-05-02T12:15:59.225Z 2025-05-09T12:38:22.593Z
6621355 6621355 20250501012215_21839 HR0024 2025-05-02T12:15:58.323Z 2025-05-09T12:38:22.445Z
6621317 6621317 20250501012055_QHo2Z HR0024 2025-05-02T12:15:53.128Z 2025-05-09T12:38:21.842Z
6621147 6621147 20250501010833_Tlu76 HR0024 2025-05-02T12:15:41.157Z 2025-05-09T12:38:18.596Z
6621086 6621086 20250501010422_dhbnA HR0024 2025-05-02T12:15:35.832Z 2025-05-09T12:38:17.987Z
6620913 6620913 20250501005312_xgBqW HR0024 2025-05-02T12:15:21.413Z 2025-05-09T12:38:16.808Z
6620617 6620617 20250501003333_fUGj0 HR0024 2025-05-02T12:14:46.575Z 2025-05-09T12:38:14.302Z
6620483 6620483 20250501002505_dDPe5 HR0024 2025-05-02T12:14:38.728Z 2025-05-09T12:38:12.937Z
6620391 6620391 20250501002031_efCbZ HR0024 2025-05-02T12:14:20.411Z 2025-05-09T12:38:11.984Z
6620300 6620300 20250501001626_8kl0G HR0024 2025-05-02T12:14:09.698Z 2025-05-09T12:38:11.201Z
6619388 6619388 20250430231659_TO3r1 HR0024 2025-05-02T12:12:37.650Z 2025-05-09T12:38:01.833Z
6619115 6619115 20250430225438_bfqQ2 HR0024 2025-05-02T12:12:09.528Z 2025-05-09T12:37:58.368Z
6619044 6619044 20250430225007_UtMLi HR0024 2025-05-02T12:11:53.521Z 2025-05-09T12:37:57.562Z
6618990 6618990 20250430224649_gc9rK HR0024 2025-05-02T12:11:45.774Z 2025-05-09T12:37:56.915Z

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