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 = "US000S" 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
8688971 8688971 20251205132741_yO3ry US000S 2025-12-06T14:06:37.328Z 2025-12-06T14:06:37.328Z
8688964 8688964 20251205132445_2KcUZ US000S 2025-12-06T14:06:30.977Z 2025-12-06T14:06:30.977Z
8688902 8688902 20251205131041_bPCji US000S 2025-12-06T14:06:15.985Z 2025-12-06T14:06:15.985Z
8688868 8688868 20251205130429_vdjFl US000S 2025-12-06T14:06:09.636Z 2025-12-06T14:06:09.636Z
8688700 8688700 20251205122751_GjBHl US000S 2025-12-06T14:05:27.593Z 2025-12-06T14:05:27.593Z
8688533 8688533 20251205115652_gQmax US000S 2025-12-06T14:04:51.483Z 2025-12-06T14:04:51.483Z
8688460 8688460 20251205113619_A6PYb US000S 2025-12-06T14:04:40.329Z 2025-12-06T14:04:40.329Z
8688422 8688422 20251205112726_0JYoM US000S 2025-12-06T14:04:31.189Z 2025-12-06T14:04:31.189Z
8688344 8688344 20251205110853_3zREP US000S 2025-12-06T14:04:09.439Z 2025-12-06T14:04:09.439Z
8688326 8688326 20251205110635_is3a8 US000S 2025-12-06T14:04:06.322Z 2025-12-06T14:04:06.322Z
8688301 8688301 20251205110237_TCaYn US000S 2025-12-06T14:04:02.408Z 2025-12-06T14:04:02.408Z
8688284 8688284 20251205105900_zpemg US000S 2025-12-06T14:03:58.655Z 2025-12-06T14:03:58.655Z
8688253 8688253 20251205105259_2T4yn US000S 2025-12-06T14:03:48.122Z 2025-12-06T14:03:48.122Z
8688239 8688239 20251205105050_XkCJD US000S 2025-12-06T14:03:45.070Z 2025-12-06T14:03:45.070Z
8688190 8688190 20251205104426_8udpM US000S 2025-12-06T14:03:36.359Z 2025-12-06T14:03:36.359Z
8688154 8688154 20251205103622_mVhxf US000S 2025-12-06T14:03:27.796Z 2025-12-06T14:03:27.796Z
8688097 8688097 20251205102034_fLRTk US000S 2025-12-06T14:03:08.554Z 2025-12-06T14:03:08.554Z
8688065 8688065 20251205101032_bPjwg US000S 2025-12-06T14:02:59.078Z 2025-12-06T14:02:59.078Z
8688063 8688063 20251205101022_0IiM2 US000S 2025-12-06T14:02:58.511Z 2025-12-06T14:02:58.511Z
8687979 8687979 20251205095306_8Ke2U US000S 2025-12-06T14:02:34.595Z 2025-12-06T14:02:34.595Z
8687933 8687933 20251205094722_Ljb0U US000S 2025-12-06T14:02:26.945Z 2025-12-06T14:02:26.945Z
8687871 8687871 20251205092336_uQhHc US000S 2025-12-06T14:02:06.001Z 2025-12-06T14:02:06.001Z
8687840 8687840 20251205091748_InJAI US000S 2025-12-06T14:01:59.099Z 2025-12-06T14:01:59.099Z
8687820 8687820 20251205091310_hvrKk US000S 2025-12-06T14:01:55.568Z 2025-12-06T14:01:55.568Z
8687701 8687701 20251205083548_Td7k0 US000S 2025-12-06T14:01:26.304Z 2025-12-06T14:01:26.304Z
8687598 8687598 20251205075601_yd2Vf US000S 2025-12-06T14:00:55.928Z 2025-12-06T14:00:55.928Z
8687174 8687174 20251204053026_nK2sc US000S 2025-12-05T14:14:11.979Z 2025-12-06T14:22:35.276Z
8687042 8687042 20251204021202_xKz1D US000S 2025-12-05T14:13:42.812Z 2025-12-06T14:22:26.341Z
8684318 8684318 20251204120403_B4r7h US000S 2025-12-05T14:02:42.239Z 2025-12-06T14:18:00.475Z
8684090 8684090 20251204103638_92O7i US000S 2025-12-05T14:01:50.348Z 2025-12-06T14:18:00.414Z
8683919 8683919 20251204092350_xylZL US000S 2025-12-05T14:01:04.429Z 2025-12-06T14:18:00.367Z
8683870 8683870 20251204090730_3u9j1 US000S 2025-12-05T14:00:57.621Z 2025-12-06T14:18:00.356Z
8683846 8683846 20251204085826_1YNgH US000S 2025-12-05T14:00:51.657Z 2025-12-06T14:18:00.349Z
8683833 8683833 20251204085232_HUWwo US000S 2025-12-05T14:00:50.327Z 2025-12-06T14:18:00.345Z
8683744 8683744 20251204073958_70XEd US000S 2025-12-05T14:00:25.533Z 2025-12-06T14:18:00.318Z
8683740 8683740 20251204073602_EBIyV US000S 2025-12-05T14:00:24.620Z 2025-12-06T14:18:00.317Z
8683737 8683737 20251204073335_MWAbu US000S 2025-12-05T14:00:24.099Z 2025-12-06T14:18:00.316Z
8683710 8683710 20251204070615_lwRO3 US000S 2025-12-05T14:00:18.160Z 2025-12-06T14:18:00.309Z
8682657 8682657 20251203055557_M0q5a US000S 2025-12-04T14:17:52.235Z 2025-12-06T14:29:21.464Z
8682608 8682608 20251203055109_x6tZO US000S 2025-12-04T14:17:42.134Z 2025-12-06T14:29:18.283Z
8677937 8677937 20251203132515_8c2w8 US000S 2025-12-04T14:03:03.576Z 2025-12-06T14:20:19.462Z
8677930 8677930 20251203132302_b0wrU US000S 2025-12-04T14:03:02.312Z 2025-12-06T14:20:18.961Z
8677912 8677912 20251203131327_2tvb3 US000S 2025-12-04T14:02:59.228Z 2025-12-06T14:20:14.737Z
8677874 8677874 20251203125044_UFcmm US000S 2025-12-04T14:02:50.984Z 2025-12-06T14:20:10.828Z
8677791 8677791 20251203123530_fJT4U US000S 2025-12-04T14:02:39.923Z 2025-12-06T14:20:06.116Z
8677785 8677785 20251203123303_aNTJh US000S 2025-12-04T14:02:37.618Z 2025-12-06T14:20:05.506Z
8677776 8677776 20251203122945_aTJkZ US000S 2025-12-04T14:02:31.602Z 2025-12-06T14:20:04.831Z
8677632 8677632 20251203111442_hq3jf US000S 2025-12-04T14:02:06.029Z 2025-12-06T14:19:49.878Z
8677617 8677617 20251203110735_WHL43 US000S 2025-12-04T14:02:00.326Z 2025-12-06T14:19:45.501Z
8677523 8677523 20251203103407_q80ap US000S 2025-12-04T14:01:34.629Z 2025-12-06T14:19:35.716Z
8677516 8677516 20251203103043_k3Q6w US000S 2025-12-04T14:01:31.024Z 2025-12-06T14:19:34.869Z
8677443 8677443 20251203100236_dGZUJ US000S 2025-12-04T14:01:16.101Z 2025-12-06T14:19:28.387Z
8677429 8677429 20251203095338_zrJYt US000S 2025-12-04T14:01:12.921Z 2025-12-06T14:19:26.617Z
8677337 8677337 20251203085545_R3w2l US000S 2025-12-04T14:00:49.844Z 2025-12-06T14:19:17.680Z
8677330 8677330 20251203084746_HdMR9 US000S 2025-12-04T14:00:48.534Z 2025-12-06T14:19:15.082Z
8677324 8677324 20251203084416_mSfdI US000S 2025-12-04T14:00:47.240Z 2025-12-06T14:19:11.668Z
8677092 8677092 20251202064809_Mrq9k US000S 2025-12-03T14:26:17.093Z 2025-12-06T14:35:34.513Z
8670147 8670147 20251202133800_5MJSV US000S 2025-12-03T14:07:03.207Z 2025-12-06T14:24:43.227Z
8670144 8670144 20251202133051_v3FLh US000S 2025-12-03T14:07:02.840Z 2025-12-06T14:24:39.184Z
8670137 8670137 20251202133041_QBOWi US000S 2025-12-03T14:07:01.644Z 2025-12-06T14:24:38.795Z
8670133 8670133 20251202131804_jtLiv US000S 2025-12-03T14:07:00.923Z 2025-12-06T14:24:38.417Z
8670125 8670125 20251202131541_VvA1B US000S 2025-12-03T14:06:59.545Z 2025-12-06T14:24:37.873Z
8670103 8670103 20251202130857_AwjU3 US000S 2025-12-03T14:06:55.456Z 2025-12-06T14:24:36.611Z
8670060 8670060 20251202125829_BOWLa US000S 2025-12-03T14:06:39.221Z 2025-12-06T14:24:33.007Z
8670020 8670020 20251202124626_wHQIV US000S 2025-12-03T14:06:30.679Z 2025-12-06T14:24:31.001Z
8669961 8669961 20251202123726_b1mB3 US000S 2025-12-03T14:06:12.515Z 2025-12-06T14:24:28.697Z
8669958 8669958 20251202123610_wVJ26 US000S 2025-12-03T14:06:11.777Z 2025-12-06T14:24:28.560Z
8669907 8669907 20251202122520_AfbhI US000S 2025-12-03T14:06:00.500Z 2025-12-06T14:24:26.661Z
8669893 8669893 20251202122343_8zLOu US000S 2025-12-03T14:05:57.402Z 2025-12-06T14:24:25.334Z
8669859 8669859 20251202121832_3tGuv US000S 2025-12-03T14:05:51.212Z 2025-12-06T14:24:23.597Z
8669832 8669832 20251202121441_rEgdu US000S 2025-12-03T14:05:45.036Z 2025-12-06T14:24:22.490Z
8669823 8669823 20251202121313_AZIIM US000S 2025-12-03T14:05:35.962Z 2025-12-06T14:24:21.874Z
8669796 8669796 20251202121243_U8UB0 US000S 2025-12-03T14:05:28.932Z 2025-12-06T14:24:21.235Z
8669732 8669732 20251202120633_4Se9l US000S 2025-12-03T14:05:18.870Z 2025-12-06T14:24:17.832Z
8669704 8669704 20251202120125_1NdSd US000S 2025-12-03T14:05:12.922Z 2025-12-06T14:24:16.456Z
8669640 8669640 20251202114841_V0Fbf US000S 2025-12-03T14:04:47.550Z 2025-12-06T14:24:12.440Z
8669630 8669630 20251202114559_u4Jgp US000S 2025-12-03T14:04:45.610Z 2025-12-06T14:24:07.746Z
8669543 8669543 20251202112908_C2g3z US000S 2025-12-03T14:04:27.959Z 2025-12-06T14:24:00.596Z
8669510 8669510 20251202112324_2WSl0 US000S 2025-12-03T14:04:13.215Z 2025-12-06T14:23:58.874Z
8669497 8669497 20251202112144_6vW7V US000S 2025-12-03T14:04:10.464Z 2025-12-06T14:23:58.235Z
8669485 8669485 20251202112036_15AGw US000S 2025-12-03T14:04:07.920Z 2025-12-06T14:23:57.677Z
8669414 8669414 20251202110932_IylAF US000S 2025-12-03T14:03:40.149Z 2025-12-06T14:23:53.118Z
8669368 8669368 20251202110028_gar3v US000S 2025-12-03T14:03:28.672Z 2025-12-06T14:23:50.734Z
8669359 8669359 20251202110001_NOli5 US000S 2025-12-03T14:03:27.700Z 2025-12-06T14:23:50.492Z
8669248 8669248 20251202103955_W6irt US000S 2025-12-03T14:03:03.252Z 2025-12-06T14:23:44.977Z
8669240 8669240 20251202103821_faROG US000S 2025-12-03T14:02:58.814Z 2025-12-06T14:23:41.835Z
8669167 8669167 20251202102840_JHOHG US000S 2025-12-03T14:02:46.925Z 2025-12-06T14:23:38.651Z
8669151 8669151 20251202102226_zsKEa US000S 2025-12-03T14:02:44.380Z 2025-12-06T14:23:37.940Z
8669149 8669149 20251202102209_a0bPH US000S 2025-12-03T14:02:43.824Z 2025-12-06T14:23:37.790Z
8669076 8669076 20251202100917_DYCJv US000S 2025-12-03T14:02:15.224Z 2025-12-06T14:23:30.832Z
8669019 8669019 20251202095404_IPkOz US000S 2025-12-03T14:02:02.278Z 2025-12-06T14:23:26.135Z
8668806 8668806 20251202090215_IFYfm US000S 2025-12-03T14:01:21.427Z 2025-12-06T14:23:12.413Z
8668735 8668735 20251202084428_xMun3 US000S 2025-12-03T14:00:59.438Z 2025-12-06T14:23:07.490Z
8668729 8668729 20251202084234_ri2LR US000S 2025-12-03T14:00:58.422Z 2025-12-06T14:23:07.137Z
8668668 8668668 20251202081726_K2Rt8 US000S 2025-12-03T14:00:47.113Z 2025-12-06T14:23:02.050Z
8668642 8668642 20251202080536_RVnBN US000S 2025-12-03T14:00:39.148Z 2025-12-06T14:22:59.281Z
8668633 8668633 20251202080331_ObWUI US000S 2025-12-03T14:00:37.708Z 2025-12-06T14:22:58.513Z
8668617 8668617 20251202080111_pDtAa US000S 2025-12-03T14:00:35.931Z 2025-12-06T14:22:57.824Z
8668566 8668566 20251202073727_qXdUf US000S 2025-12-03T14:00:25.361Z 2025-12-06T14:22:53.764Z
8638079 8638079 20251128081935_AKRM3 US000S 2025-11-29T14:28:28.794Z 2025-12-06T15:04:07.645Z

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