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 = "US000U" 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
9267952 9267952 20260127071622_tjSq0 US000U 2026-01-28T14:24:00.090Z 2026-01-29T14:35:58.741Z
9267949 9267949 20260127071122_V83xy US000U 2026-01-28T14:23:59.637Z 2026-01-29T14:35:58.587Z
9267946 9267946 20260127070649_CAT2f US000U 2026-01-28T14:23:59.207Z 2026-01-29T14:35:58.322Z
9267930 9267930 20260127065632_LHv2J US000U 2026-01-28T14:23:55.740Z 2026-01-29T14:35:54.739Z
9267890 9267890 20260127063328_TajzL US000U 2026-01-28T14:23:46.581Z 2026-01-29T14:35:51.188Z
9267707 9267707 20260127043023_22Dx2 US000U 2026-01-28T14:22:57.560Z 2026-01-29T14:35:32.928Z
9264799 9264799 20260127131352_Ons6k US000U 2026-01-28T14:07:43.110Z 2026-01-29T14:30:24.294Z
9264782 9264782 20260127131127_AsAtK US000U 2026-01-28T14:07:36.800Z 2026-01-29T14:30:24.291Z
9264697 9264697 20260127125809_fQ2NY US000U 2026-01-28T14:07:13.201Z 2026-01-29T14:30:24.257Z
9264609 9264609 20260127125021_QRFuJ US000U 2026-01-28T14:06:51.385Z 2026-01-29T14:30:24.229Z
9264539 9264539 20260127124415_S4QzA US000U 2026-01-28T14:06:37.201Z 2026-01-29T14:30:24.207Z
9264488 9264488 20260127123401_jQfPq US000U 2026-01-28T14:06:20.065Z 2026-01-29T14:30:24.185Z
9264427 9264427 20260127122029_DmRqv US000U 2026-01-28T14:06:05.662Z 2026-01-29T14:30:21.704Z
9264286 9264286 20260127115659_zs4LT US000U 2026-01-28T14:05:19.378Z 2026-01-29T14:30:20.578Z
9264252 9264252 20260127114936_RU2rg US000U 2026-01-28T14:05:11.561Z 2026-01-29T14:30:20.569Z
9264131 9264131 20260127111848_RoT8z US000U 2026-01-28T14:04:32.784Z 2026-01-29T14:30:20.069Z
9264082 9264082 20260127111132_mFaqF US000U 2026-01-28T14:04:18.453Z 2026-01-29T14:30:20.046Z
9264023 9264023 20260127105928_A2317 US000U 2026-01-28T14:03:59.686Z 2026-01-29T14:30:20.004Z
9263985 9263985 20260127104912_mnIJk US000U 2026-01-28T14:03:47.049Z 2026-01-29T14:30:19.985Z
9263936 9263936 20260127104445_aDum4 US000U 2026-01-28T14:03:36.046Z 2026-01-29T14:30:19.973Z
9263913 9263913 20260127104050_EPE6x US000U 2026-01-28T14:03:30.993Z 2026-01-29T14:30:19.968Z
9263875 9263875 20260127102819_5Ddal US000U 2026-01-28T14:03:17.282Z 2026-01-29T14:30:19.512Z
9263762 9263762 20260127100901_x6xq7 US000U 2026-01-28T14:02:39.842Z 2026-01-29T14:30:18.928Z
9263737 9263737 20260127100208_mz3lx US000U 2026-01-28T14:02:32.636Z 2026-01-29T14:30:18.923Z
9263688 9263688 20260127094917_ZbfPd US000U 2026-01-28T14:02:15.732Z 2026-01-29T14:30:18.029Z
9263659 9263659 20260127093727_8Q6dU US000U 2026-01-28T14:02:02.878Z 2026-01-29T14:30:17.618Z
9263535 9263535 20260127090410_8OEFw US000U 2026-01-28T14:01:13.947Z 2026-01-29T14:30:16.554Z
9263518 9263518 20260127085044_jcUXf US000U 2026-01-28T14:01:07.704Z 2026-01-29T14:30:16.550Z
9263465 9263465 20260127081829_mruM7 US000U 2026-01-28T14:00:47.428Z 2026-01-29T14:30:16.519Z
9263411 9263411 20260127073953_mHTRG US000U 2026-01-28T14:00:21.608Z 2026-01-29T14:30:16.489Z
9263131 9263131 20260126073520_cCZRx US000U 2026-01-27T14:17:09.490Z 2026-01-29T14:39:18.496Z
9263089 9263089 20260126070535_DMKWs US000U 2026-01-27T14:16:57.032Z 2026-01-29T14:39:16.070Z
9263001 9263001 20260126055524_ukXhe US000U 2026-01-27T14:16:33.224Z 2026-01-29T14:39:08.662Z
9262988 9262988 20260126055347_4PDn2 US000U 2026-01-27T14:16:24.755Z 2026-01-29T14:39:08.148Z
9262943 9262943 20260126052049_FYbDh US000U 2026-01-27T14:16:13.875Z 2026-01-29T14:39:05.396Z
9261647 9261647 20260126124030_Sgugg US000U 2026-01-27T14:04:51.036Z 2026-01-29T14:32:45.838Z
9261518 9261518 20260126120629_wLMkd US000U 2026-01-27T14:04:10.580Z 2026-01-29T14:32:37.487Z
9261389 9261389 20260126112311_26F5O US000U 2026-01-27T14:03:33.307Z 2026-01-29T14:32:15.678Z
9261318 9261318 20260126110734_tlpwR US000U 2026-01-27T14:03:11.968Z 2026-01-29T14:32:11.850Z
9261269 9261269 20260126105500_n346K US000U 2026-01-27T14:02:56.534Z 2026-01-29T14:32:09.209Z
9261084 9261084 20260126094657_r2UMD US000U 2026-01-27T14:01:48.831Z 2026-01-29T14:31:48.079Z
9260867 9260867 20260126082738_OP4Kn US000U 2026-01-27T14:00:34.620Z 2026-01-29T14:31:03.277Z
9260799 9260799 20260126075553_cZjEW US000U 2026-01-27T14:00:15.870Z 2026-01-29T14:30:34.354Z
9260727 9260727 20260125075056_rY3sw US000U 2026-01-26T14:23:10.107Z 2026-01-29T14:44:38.021Z
9260720 9260720 20260125073823_AUKzH US000U 2026-01-26T14:23:09.359Z 2026-01-29T14:44:37.759Z
9260702 9260702 20260125072414_wU3Sm US000U 2026-01-26T14:23:06.232Z 2026-01-29T14:44:36.625Z
9260695 9260695 20260125071817_Qg3t7 US000U 2026-01-26T14:23:04.542Z 2026-01-29T14:44:36.133Z
9260686 9260686 20260125070839_ebkvQ US000U 2026-01-26T14:23:03.121Z 2026-01-29T14:44:35.651Z
9260578 9260578 20260125053701_GOhhg US000U 2026-01-26T14:22:27.785Z 2026-01-29T14:44:28.658Z
9260474 9260474 20260125044335_klkIg US000U 2026-01-26T14:21:56.313Z 2026-01-29T14:44:17.276Z
9260471 9260471 20260125044334_jw1jH US000U 2026-01-26T14:21:55.916Z 2026-01-29T14:44:17.086Z
9257238 9257238 20260125123014_5TppY US000U 2026-01-26T14:04:20.398Z 2026-01-29T14:37:00.874Z
9257144 9257144 20260125121019_3B6zM US000U 2026-01-26T14:03:55.813Z 2026-01-29T14:36:51.086Z
9257137 9257137 20260125120634_j0VxG US000U 2026-01-26T14:03:51.112Z 2026-01-29T14:36:50.713Z
9257085 9257085 20260125115001_2X3vU US000U 2026-01-26T14:03:36.838Z 2026-01-29T14:36:45.608Z
9257080 9257080 20260125115000_vPaqw US000U 2026-01-26T14:03:36.177Z 2026-01-29T14:36:45.493Z
9257063 9257063 20260125114742_2SFKY US000U 2026-01-26T14:03:32.048Z 2026-01-29T14:36:44.495Z
9257032 9257032 20260125114105_9hVCj US000U 2026-01-26T14:03:16.782Z 2026-01-29T14:36:42.548Z
9257001 9257001 20260125113316_6l4jw US000U 2026-01-26T14:03:09.466Z 2026-01-29T14:36:41.228Z
9256954 9256954 20260125111833_d3eBu US000U 2026-01-26T14:02:58.185Z 2026-01-29T14:36:38.260Z
9256915 9256915 20260125110637_AsfLl US000U 2026-01-26T14:02:42.783Z 2026-01-29T14:36:36.118Z
9256877 9256877 20260125105603_73O2j US000U 2026-01-26T14:02:31.079Z 2026-01-29T14:36:33.740Z
9256847 9256847 20260125104319_w3kmv US000U 2026-01-26T14:02:15.230Z 2026-01-29T14:36:27.224Z
9256842 9256842 20260125104236_2KEWv US000U 2026-01-26T14:02:14.488Z 2026-01-29T14:36:27.026Z
9256810 9256810 20260125103510_rC2MQ US000U 2026-01-26T14:02:07.957Z 2026-01-29T14:36:25.522Z
9256779 9256779 20260125102532_h8Ek2 US000U 2026-01-26T14:01:57.398Z 2026-01-29T14:36:24.133Z
9256764 9256764 20260125102227_yaxDC US000U 2026-01-26T14:01:47.885Z 2026-01-29T14:36:20.838Z
9256760 9256760 20260125102215_8Ofoa US000U 2026-01-26T14:01:47.268Z 2026-01-29T14:36:20.626Z
9256747 9256747 20260125101733_2Sepl US000U 2026-01-26T14:01:43.993Z 2026-01-29T14:36:19.853Z
9256741 9256741 20260125101620_YBmCf US000U 2026-01-26T14:01:42.415Z 2026-01-29T14:36:19.514Z
9256703 9256703 20260125100602_0ZIU6 US000U 2026-01-26T14:01:32.718Z 2026-01-29T14:36:17.596Z
9256670 9256670 20260125095800_osUKo US000U 2026-01-26T14:01:17.664Z 2026-01-29T14:36:15.552Z
9256657 9256657 20260125095040_M8NY6 US000U 2026-01-26T14:01:13.679Z 2026-01-29T14:36:14.885Z
9256611 9256611 20260125093105_znZGX US000U 2026-01-26T14:00:57.630Z 2026-01-29T14:36:12.035Z
9256504 9256504 20260125081341_1TVmM US000U 2026-01-26T14:00:12.387Z 2026-01-29T14:36:01.885Z
9253379 9253379 20260124112313_D9g2i US000U 2026-01-25T14:02:22.167Z 2026-01-29T14:40:45.865Z
9253338 9253338 20260124110411_SHQBH US000U 2026-01-25T14:02:08.771Z 2026-01-29T14:40:39.225Z
9253329 9253329 20260124105733_EsjqK US000U 2026-01-25T14:02:06.349Z 2026-01-29T14:40:38.215Z
9253265 9253265 20260124103719_Qtdv0 US000U 2026-01-25T14:01:44.303Z 2026-01-29T14:40:31.447Z
9253247 9253247 20260124102947_e3qWh US000U 2026-01-25T14:01:38.138Z 2026-01-29T14:40:30.017Z
9253220 9253220 20260124101820_ocAXN US000U 2026-01-25T14:01:24.783Z 2026-01-29T14:40:28.631Z
9253189 9253189 20260124100338_P8PdF US000U 2026-01-25T14:01:13.127Z 2026-01-29T14:40:25.135Z
9253183 9253183 20260124100109_DM26M US000U 2026-01-25T14:01:10.823Z 2026-01-29T14:40:24.658Z
9253179 9253179 20260124095747_KA1Yq US000U 2026-01-25T14:01:09.443Z 2026-01-29T14:40:24.051Z
9253123 9253123 20260124093031_khm7f US000U 2026-01-25T14:00:48.922Z 2026-01-29T14:40:19.063Z
9253033 9253033 20260124083908_QvnyT US000U 2026-01-25T14:00:13.247Z 2026-01-29T14:40:11.173Z
9244480 9244480 20260121083821_ruisw US000U 2026-01-22T14:25:48.138Z 2026-01-29T15:06:21.338Z
9244451 9244451 20260121083219_ch7tG US000U 2026-01-22T14:25:34.338Z 2026-01-29T15:06:09.942Z
9244398 9244398 20260121081503_Rvvp3 US000U 2026-01-22T14:25:22.865Z 2026-01-29T15:06:07.200Z
9244120 9244120 20260121061539_GYQTv US000U 2026-01-22T14:24:11.886Z 2026-01-29T15:05:52.397Z
9244016 9244016 20260121055600_y60bd US000U 2026-01-22T14:23:56.426Z 2026-01-29T15:05:47.805Z
9243734 9243734 20260121051134_lpuGC US000U 2026-01-22T14:22:52.379Z 2026-01-29T15:05:25.400Z
9243554 9243554 20260121044758_5QoLJ US000U 2026-01-22T14:22:12.498Z 2026-01-29T15:05:17.929Z
9243435 9243435 20260121043225_sYJ8s US000U 2026-01-22T14:21:47.270Z 2026-01-29T15:05:02.427Z
9239734 9239734 20260121120310_zfjMs US000U 2026-01-22T14:02:56.902Z 2026-01-29T14:54:38.353Z
9239671 9239671 20260121113754_FXpxS US000U 2026-01-22T14:02:33.077Z 2026-01-29T14:54:35.067Z
9239669 9239669 20260121113713_6vcF6 US000U 2026-01-22T14:02:32.401Z 2026-01-29T14:54:34.906Z
9238881 9238881 20260120100748_qhKbO US000U 2026-01-21T14:30:46.214Z 2026-01-28T15:03:05.319Z
9238869 9238869 20260120100336_dZ9qh US000U 2026-01-21T14:30:45.093Z 2026-01-28T15:03:04.973Z
9238823 9238823 20260120095759_hcNN3 US000U 2026-01-21T14:30:38.575Z 2026-01-28T15:03:03.127Z

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