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

6,553 rows where station_code = "US003P" 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
9268113 9268113 20260128085135_rBCbC US003P 2026-01-29T14:01:09.516Z 2026-01-29T14:01:09.516Z
9264129 9264129 20260127111844_kqR0O US003P 2026-01-28T14:04:32.185Z 2026-01-29T14:30:20.068Z
9263920 9263920 20260127104313_tElEI US003P 2026-01-28T14:03:32.609Z 2026-01-29T14:30:19.970Z
9263816 9263816 20260127101841_9ESgG US003P 2026-01-28T14:02:57.129Z 2026-01-29T14:30:18.948Z
9263797 9263797 20260127101427_54Kyx US003P 2026-01-28T14:02:51.524Z 2026-01-29T14:30:18.940Z
9263783 9263783 20260127101128_LQWmh US003P 2026-01-28T14:02:46.550Z 2026-01-29T14:30:18.936Z
9263590 9263590 20260127092105_F3b39 US003P 2026-01-28T14:01:37.212Z 2026-01-29T14:30:16.584Z
9263394 9263394 20260127073040_e9lG7 US003P 2026-01-28T14:00:13.288Z 2026-01-29T14:30:16.475Z
9256405 9256405 20260124081804_jVHeG US003P 2026-01-25T14:16:57.206Z 2026-01-29T14:48:47.873Z
9256375 9256375 20260124075523_3PHIE US003P 2026-01-25T14:16:50.267Z 2026-01-29T14:48:46.136Z
9256329 9256329 20260124072430_r338d US003P 2026-01-25T14:16:41.385Z 2026-01-29T14:48:41.629Z
9256324 9256324 20260124072219_gMZxl US003P 2026-01-25T14:16:40.919Z 2026-01-29T14:48:37.814Z
9256218 9256218 20260124062250_kqDpi US003P 2026-01-25T14:16:15.024Z 2026-01-29T14:48:29.627Z
9256096 9256096 20260124055307_MFz7C US003P 2026-01-25T14:15:48.067Z 2026-01-29T14:48:22.844Z
9255997 9255997 20260124053623_7t0qX US003P 2026-01-25T14:15:30.382Z 2026-01-29T14:48:17.237Z
9255844 9255844 20260124050832_fRCir US003P 2026-01-25T14:14:57.779Z 2026-01-29T14:48:01.230Z
9255806 9255806 20260124045912_XIt2m US003P 2026-01-25T14:14:46.762Z 2026-01-29T14:47:58.778Z
9255693 9255693 20260124043230_w6B3B US003P 2026-01-25T14:14:24.667Z 2026-01-29T14:47:51.967Z
9255634 9255634 20260124042243_Mg8Wd US003P 2026-01-25T14:14:09.024Z 2026-01-29T14:47:48.790Z
9255547 9255547 20260124040812_0foKq US003P 2026-01-25T14:13:55.521Z 2026-01-29T14:47:39.578Z
9255518 9255518 20260124035833_iZHTP US003P 2026-01-25T14:13:45.285Z 2026-01-29T14:47:35.629Z
9255422 9255422 20260124032803_4e4U3 US003P 2026-01-25T14:13:19.804Z 2026-01-29T14:47:29.682Z
9253212 9253212 20260124101342_4I2eZ US003P 2026-01-25T14:01:21.582Z 2026-01-29T14:40:27.611Z
9253210 9253210 20260124101252_k1AQi US003P 2026-01-25T14:01:20.818Z 2026-01-29T14:40:27.216Z
9253060 9253060 20260124085925_hm5hZ US003P 2026-01-25T14:00:26.649Z 2026-01-29T14:40:13.062Z
9253042 9253042 20260124084918_C8qpJ US003P 2026-01-25T14:00:18.331Z 2026-01-29T14:40:11.899Z
9253029 9253029 20260124083751_aEZBL US003P 2026-01-25T14:00:11.947Z 2026-01-29T14:40:11.010Z
9252969 9252969 20260123084335_3Onqa US003P 2026-01-24T14:18:01.911Z 2026-01-29T14:53:45.269Z
9252932 9252932 20260123081951_Q0rS5 US003P 2026-01-24T14:17:50.172Z 2026-01-29T14:53:42.941Z
9252916 9252916 20260123080325_PrLai US003P 2026-01-24T14:17:46.476Z 2026-01-29T14:53:42.043Z
9252849 9252849 20260123070135_cUAIw US003P 2026-01-24T14:17:29.010Z 2026-01-29T14:53:37.216Z
9252665 9252665 20260123050751_2cCFQ US003P 2026-01-24T14:16:36.516Z 2026-01-29T14:53:14.489Z
9252499 9252499 20260123033941_DKGuE US003P 2026-01-24T14:15:53.465Z 2026-01-29T14:53:04.431Z
9252420 9252420 20260123025604_HffI4 US003P 2026-01-24T14:15:29.066Z 2026-01-29T14:52:52.318Z
9251862 9251862 20260122233459_9iYxj US003P 2026-01-24T14:13:25.726Z 2026-01-29T14:52:13.853Z
9250215 9250215 20260123110654_EErbI US003P 2026-01-24T14:01:43.373Z 2026-01-29T14:45:06.153Z
9250143 9250143 20260123104423_iqwfc US003P 2026-01-24T14:01:25.655Z 2026-01-29T14:45:01.792Z
9250027 9250027 20260123094710_eNeS6 US003P 2026-01-24T14:00:42.215Z 2026-01-29T14:44:53.967Z
9249986 9249986 20260123092637_Izf4F US003P 2026-01-24T14:00:28.453Z 2026-01-29T14:44:46.462Z
9249737 9249737 20260122080536_TyXMR US003P 2026-01-23T14:16:02.710Z 2026-01-29T14:58:52.509Z
9248773 9248773 20260122020749_ofqtq US003P 2026-01-23T14:13:50.423Z 2026-01-29T14:57:46.181Z
9248446 9248446 20260121234843_LmPAZ US003P 2026-01-23T14:12:48.725Z 2026-01-29T14:57:19.279Z
9244696 9244696 20260121094807_ybLwd US003P 2026-01-22T14:26:33.118Z 2026-01-29T15:06:31.614Z
9244670 9244670 20260121093632_AJLa0 US003P 2026-01-22T14:26:29.078Z 2026-01-29T15:06:30.338Z
9244544 9244544 20260121090308_VVyYG US003P 2026-01-22T14:25:58.964Z 2026-01-29T15:06:25.112Z
9244491 9244491 20260121084217_KKv3Q US003P 2026-01-22T14:25:49.978Z 2026-01-29T15:06:22.152Z
9244455 9244455 20260121083239_nfMd2 US003P 2026-01-22T14:25:35.386Z 2026-01-29T15:06:10.101Z
9244440 9244440 20260121083021_NwRBw US003P 2026-01-22T14:25:32.444Z 2026-01-29T15:06:09.362Z
9244386 9244386 20260121081135_3cQUW US003P 2026-01-22T14:25:20.394Z 2026-01-29T15:06:06.501Z
9244154 9244154 20260121062626_nF5ld US003P 2026-01-22T14:24:20.674Z 2026-01-29T15:05:54.083Z
9243815 9243815 20260121052044_rzJ0S US003P 2026-01-22T14:23:07.137Z 2026-01-29T15:05:28.636Z
9243808 9243808 20260121051928_QdV5v US003P 2026-01-22T14:23:05.968Z 2026-01-29T15:05:28.284Z
9243800 9243800 20260121051813_tC2kI US003P 2026-01-22T14:23:04.789Z 2026-01-29T15:05:27.833Z
9242052 9242052 20260121001554_iWxh2 US003P 2026-01-22T14:16:01.576Z 2026-01-29T15:03:27.793Z
9239583 9239583 20260121111425_Go4Ld US003P 2026-01-22T14:02:05.211Z 2026-01-29T14:54:30.835Z
9239443 9239443 20260121104852_c3yYS US003P 2026-01-22T14:01:27.806Z 2026-01-29T14:54:16.103Z
9239382 9239382 20260121103711_222tV US003P 2026-01-22T14:01:14.554Z 2026-01-29T14:54:12.518Z
9239366 9239366 20260121103336_AUbNO US003P 2026-01-22T14:01:11.801Z 2026-01-29T14:54:11.563Z
9239309 9239309 20260121102501_pKqAR US003P 2026-01-22T14:00:53.234Z 2026-01-29T14:54:07.194Z
9239293 9239293 20260121102157_UCUwP US003P 2026-01-22T14:00:48.643Z 2026-01-29T14:54:06.204Z
9238866 9238866 20260120100222_ZFxZT US003P 2026-01-21T14:30:44.520Z 2026-01-28T15:03:04.631Z
9238851 9238851 20260120095935_KkHng US003P 2026-01-21T14:30:43.365Z 2026-01-28T15:03:04.217Z
9238679 9238679 20260120092747_syoxD US003P 2026-01-21T14:30:14.961Z 2026-01-28T15:02:45.724Z
9238678 9238678 20260120092733_aP90b US003P 2026-01-21T14:30:12.069Z 2026-01-28T15:02:45.578Z
9238604 9238604 20260120091245_C93Am US003P 2026-01-21T14:30:02.664Z 2026-01-28T15:02:40.552Z
9238546 9238546 20260120085638_alxkz US003P 2026-01-21T14:29:55.770Z 2026-01-28T15:02:38.090Z
9238399 9238399 20260120083121_NJzdl US003P 2026-01-21T14:29:30.100Z 2026-01-28T15:02:32.109Z
9238355 9238355 20260120082618_DSdtQ US003P 2026-01-21T14:29:25.860Z 2026-01-28T15:02:30.480Z
9238168 9238168 20260120074207_WWv8R US003P 2026-01-21T14:28:50.966Z 2026-01-28T15:02:10.967Z
9238102 9238102 20260120072054_2tqZx US003P 2026-01-21T14:28:41.476Z 2026-01-28T15:02:07.376Z
9238001 9238001 20260120065319_ak1Bb US003P 2026-01-21T14:28:14.637Z 2026-01-28T15:02:02.573Z
9237898 9237898 20260120062036_RYxih US003P 2026-01-21T14:28:01.098Z 2026-01-28T15:01:57.973Z
9237896 9237896 20260120061937_HWHID US003P 2026-01-21T14:28:00.669Z 2026-01-28T15:01:57.784Z
9237776 9237776 20260120060224_XIqsX US003P 2026-01-21T14:27:37.212Z 2026-01-28T15:01:41.474Z
9237752 9237752 20260120055925_3zNCn US003P 2026-01-21T14:27:34.993Z 2026-01-28T15:01:39.447Z
9237694 9237694 20260120055112_zUcRp US003P 2026-01-21T14:27:21.515Z 2026-01-28T15:01:36.708Z
9237604 9237604 20260120054231_bffiI US003P 2026-01-21T14:27:06.352Z 2026-01-28T15:01:32.616Z
9237551 9237551 20260120053517_RyRaE US003P 2026-01-21T14:26:59.451Z 2026-01-28T15:01:30.782Z
9235068 9235068 20260120002406_ZXhji US003P 2026-01-21T14:17:21.976Z 2026-01-28T14:58:27.951Z
9235002 9235002 20260120000532_hZ34T US003P 2026-01-21T14:17:07.632Z 2026-01-28T14:58:24.316Z
9234850 9234850 20260119234036_49gSq US003P 2026-01-21T14:16:28.819Z 2026-01-28T14:58:17.157Z
9232336 9232336 20260120110709_RIIwv US003P 2026-01-21T14:01:21.014Z 2026-01-29T14:59:26.603Z
9232326 9232326 20260120110536_ZwowT US003P 2026-01-21T14:01:18.864Z 2026-01-29T14:59:26.233Z
9232302 9232302 20260120110047_NwMo6 US003P 2026-01-21T14:01:15.647Z 2026-01-29T14:59:24.371Z
9232067 9232067 20260120101746_snQ7W US003P 2026-01-21T14:00:12.200Z 2026-01-29T14:59:05.797Z
9231972 9231972 20260119102728_5NXpn US003P 2026-01-20T14:34:57.175Z 2026-01-27T15:07:08.578Z
9231848 9231848 20260119100321_ehGN1 US003P 2026-01-20T14:34:31.241Z 2026-01-27T15:07:02.265Z
9231789 9231789 20260119095211_hEgiv US003P 2026-01-20T14:34:20.356Z 2026-01-27T15:06:59.776Z
9231676 9231676 20260119092605_ZLNwh US003P 2026-01-20T14:33:52.607Z 2026-01-27T15:06:44.195Z
9231649 9231649 20260119091458_OvTPQ US003P 2026-01-20T14:33:45.638Z 2026-01-27T15:06:42.518Z
9231648 9231648 20260119091416_mGJfT US003P 2026-01-20T14:33:45.036Z 2026-01-27T15:06:42.403Z
9230843 9230843 20260119051730_2vMQA US003P 2026-01-20T14:30:03.644Z 2026-01-27T15:05:30.224Z
9230598 9230598 20260119043826_ei7XK US003P 2026-01-20T14:28:50.108Z 2026-01-27T15:05:15.847Z
9229682 9229682 20260119021616_U1FlQ US003P 2026-01-20T14:23:41.946Z 2026-01-27T15:03:49.304Z
9214848 9214848 20260116082410_8qiKM US003P 2026-01-17T14:23:31.085Z 2026-01-24T15:14:10.190Z
9214830 9214830 20260116081953_hrZ0w US003P 2026-01-17T14:23:26.811Z 2026-01-24T15:14:09.357Z
9214803 9214803 20260116081527_L5947 US003P 2026-01-17T14:23:19.507Z 2026-01-24T15:14:08.429Z
9214739 9214739 20260116075254_aVMiz US003P 2026-01-17T14:23:01.467Z 2026-01-24T15:14:03.606Z
9214571 9214571 20260116065519_Lrrcw US003P 2026-01-17T14:22:07.588Z 2026-01-24T15:13:52.386Z
9214294 9214294 20260116061000_RkFCO US003P 2026-01-17T14:20:59.735Z 2026-01-24T15:13:28.821Z

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