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

5,026 rows where station_code = "USL011" 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
7815356 7815356 20250912102739_ia8bV USL011 2025-09-13T12:21:46.728Z 2025-09-20T13:02:34.341Z
7814043 7814043 20250912062154_uWqkf USL011 2025-09-13T12:17:48.861Z 2025-09-20T13:02:17.187Z
7814030 7814030 20250912061957_Udd4Y USL011 2025-09-13T12:17:47.070Z 2025-09-20T13:02:17.143Z
7813904 7813904 20250912053801_szuKL USL011 2025-09-13T12:17:18.065Z 2025-09-20T13:02:15.261Z
7813884 7813884 20250912052614_Q6Luy USL011 2025-09-13T12:17:14.258Z 2025-09-20T13:02:15.199Z
7807223 7807223 20250911111933_2RyW2 USL011 2025-09-12T12:13:06.253Z 2025-09-19T12:57:43.239Z
7806677 7806677 20250911085513_A4JyY USL011 2025-09-12T12:11:18.951Z 2025-09-19T12:57:27.990Z
7806651 7806651 20250911084749_NWuZQ USL011 2025-09-12T12:11:13.486Z 2025-09-19T12:57:27.822Z
7806460 7806460 20250911073544_h81J9 USL011 2025-09-12T12:10:29.337Z 2025-09-19T12:57:24.186Z
7806319 7806319 20250911064305_Nf7XZ USL011 2025-09-12T12:09:56.035Z 2025-09-19T12:57:21.665Z
7806316 7806316 20250911064006_Euo1Y USL011 2025-09-12T12:09:55.799Z 2025-09-19T12:57:21.529Z
7806299 7806299 20250911062925_XBtRV USL011 2025-09-12T12:09:53.046Z 2025-09-19T12:57:20.782Z
7806167 7806167 20250911051356_cyiH6 USL011 2025-09-12T12:09:16.870Z 2025-09-19T12:57:17.905Z
7806131 7806131 20250911045011_xXeuW USL011 2025-09-12T12:09:04.328Z 2025-09-19T12:57:17.144Z
7806105 7806105 20250911043906_34bdX USL011 2025-09-12T12:08:54.851Z 2025-09-19T12:57:16.026Z
7806090 7806090 20250911043352_ovBOP USL011 2025-09-12T12:08:51.519Z 2025-09-19T12:57:15.590Z
7805847 7805847 20250911033309_TMZWP USL011 2025-09-12T12:07:49.266Z 2025-09-19T12:57:02.509Z
7800939 7800939 20250910074032_TAmxz USL011 2025-09-11T12:10:41.359Z 2025-09-18T12:59:44.424Z
7800691 7800691 20250910051310_i8xxO USL011 2025-09-11T12:09:42.569Z 2025-09-18T12:59:39.291Z
7797331 7797331 20250909095630_dGnHH USL011 2025-09-10T12:12:53.822Z 2025-09-17T12:57:05.579Z
7797286 7797286 20250909093857_MrRcg USL011 2025-09-10T12:12:45.404Z 2025-09-17T12:57:05.322Z
7797226 7797226 20250909092430_iECu6 USL011 2025-09-10T12:12:31.292Z 2025-09-17T12:57:04.863Z
7796923 7796923 20250909074004_yGxY3 USL011 2025-09-10T12:11:25.880Z 2025-09-17T12:56:58.347Z
7796885 7796885 20250909072329_TMDm1 USL011 2025-09-10T12:11:18.094Z 2025-09-17T12:56:57.285Z
7796811 7796811 20250909064331_MyyVK USL011 2025-09-10T12:10:58.020Z 2025-09-17T12:56:56.714Z
7796286 7796286 20250909033132_Fp3yM USL011 2025-09-10T12:09:25.309Z 2025-09-17T12:56:52.270Z
7791776 7791776 20250908074835_DSYni USL011 2025-09-09T12:11:05.584Z 2025-09-16T12:51:29.074Z
7791599 7791599 20250908062230_njDF0 USL011 2025-09-09T12:10:24.091Z 2025-09-16T12:51:23.878Z
7786557 7786557 20250907115641_6JmKl USL011 2025-09-08T12:16:20.908Z 2025-09-15T12:45:05.887Z
7781418 7781418 20250906113423_fdZ2U USL011 2025-09-07T12:16:08.389Z 2025-09-14T12:50:58.644Z
7781378 7781378 20250906111635_DsPU2 USL011 2025-09-07T12:15:57.961Z 2025-09-14T12:50:57.278Z
7774971 7774971 20250905083335_1cJVt USL011 2025-09-06T13:21:08.146Z 2025-09-13T12:58:30.739Z
7755820 7755820 20250902113615_Qbizy USL011 2025-09-04T12:31:22.119Z 2025-09-10T12:48:03.715Z
7752562 7752562 20250903083734_cOXxX USL011 2025-09-04T12:19:52.140Z 2025-09-11T12:45:09.841Z
7733613 7733613 20250901114723_tFlXL USL011 2025-09-02T12:33:19.769Z 2025-09-09T12:49:46.975Z
7720772 7720772 20250830110503_2Zg7q USL011 2025-09-01T12:40:28.007Z 2025-09-07T12:59:25.477Z
7720698 7720698 20250830105504_AZY4w USL011 2025-09-01T12:40:22.356Z 2025-09-07T12:59:24.951Z
7720583 7720583 20250830103205_MOY9P USL011 2025-09-01T12:40:15.281Z 2025-09-07T12:59:24.284Z
7720556 7720556 20250830102804_J0tbE USL011 2025-09-01T12:40:14.219Z 2025-09-07T12:59:24.137Z
7720468 7720468 20250830100906_DUvfI USL011 2025-09-01T12:40:10.931Z 2025-09-07T12:59:23.364Z
7720424 7720424 20250830095859_e16Tz USL011 2025-09-01T12:40:09.312Z 2025-09-07T12:59:23.104Z
7717491 7717491 20250831071151_08t5p USL011 2025-09-01T12:24:54.006Z 2025-09-08T12:53:37.309Z
7717437 7717437 20250831070341_lU5Ha USL011 2025-09-01T12:24:40.117Z 2025-09-08T12:53:34.398Z
7708481 7708481 20250830114242_5wYl2 USL011 2025-09-01T12:00:37.630Z 2025-09-08T12:50:55.630Z
7708412 7708412 20250830113313_N5Anx USL011 2025-09-01T12:00:24.755Z 2025-09-08T12:50:51.272Z
7686811 7686811 20250827033057_53khO USL011 2025-08-29T12:39:23.149Z 2025-09-04T12:56:46.659Z
7676717 7676717 20250827113630_AzaLl USL011 2025-08-29T12:04:15.496Z 2025-09-05T13:03:50.843Z
7676435 7676435 20250827103813_LZkHS USL011 2025-08-29T12:03:33.095Z 2025-09-05T13:03:48.480Z
7676353 7676353 20250827101259_JxHWv USL011 2025-08-29T12:03:21.895Z 2025-09-05T13:03:45.739Z
7676349 7676349 20250827101245_B2kYQ USL011 2025-08-29T12:03:20.804Z 2025-09-05T13:03:43.276Z
7663966 7663966 20250826080052_DByVj USL011 2025-08-27T12:31:50.770Z 2025-09-03T12:53:08.975Z
7663877 7663877 20250826071725_aAW2n USL011 2025-08-27T12:31:38.820Z 2025-09-03T12:53:08.160Z
7663702 7663702 20250826051539_kq0Uj USL011 2025-08-27T12:31:10.136Z 2025-09-03T12:53:07.491Z
7663693 7663693 20250826050824_Tp2Wo USL011 2025-08-27T12:31:09.333Z 2025-09-03T12:53:07.452Z
7652053 7652053 20250826082121_CctOk USL011 2025-08-27T12:00:20.935Z 2025-09-04T12:55:00.034Z
7651660 7651660 20250825042510_ejIws USL011 2025-08-26T12:33:18.405Z 2025-09-02T12:52:22.517Z
7638358 7638358 20250824061112_2wStq USL011 2025-08-25T12:31:11.451Z 2025-09-01T12:56:13.444Z
7627472 7627472 20250824111229_xtQQV USL011 2025-08-25T12:02:19.555Z 2025-09-02T12:50:52.242Z
7627394 7627394 20250824101720_FIjTb USL011 2025-08-25T12:02:00.731Z 2025-09-02T12:50:49.283Z
7627261 7627261 20250824090254_LRz8q USL011 2025-08-25T12:01:26.282Z 2025-09-02T12:50:47.598Z
7627234 7627234 20250824084941_FbwiF USL011 2025-08-25T12:01:21.270Z 2025-09-02T12:50:47.408Z
7627202 7627202 20250824082723_DhVmA USL011 2025-08-25T12:01:15.330Z 2025-09-02T12:50:46.807Z
7627186 7627186 20250824081839_hYfzk USL011 2025-08-25T12:01:09.070Z 2025-09-02T12:50:46.339Z
7627095 7627095 20250824072411_bot9o USL011 2025-08-25T12:00:43.627Z 2025-09-02T12:50:41.192Z
7627074 7627074 20250824071744_6XcGt USL011 2025-08-25T12:00:36.874Z 2025-09-02T12:50:41.057Z
7626650 7626650 20250823051755_se3X1 USL011 2025-08-24T12:27:59.630Z 2025-08-31T12:54:22.475Z
7615733 7615733 20250823091421_xOqlB USL011 2025-08-24T12:02:31.567Z 2025-09-01T12:55:26.497Z
7615531 7615531 20250823074311_C3vpg USL011 2025-08-24T12:01:36.169Z 2025-09-01T12:55:22.046Z
7615470 7615470 20250823071512_gghYX USL011 2025-08-24T12:01:20.807Z 2025-09-01T12:55:20.979Z
7615236 7615236 20250823053817_s4mmP USL011 2025-08-24T12:00:14.675Z 2025-09-01T12:55:16.539Z
7605100 7605100 20250821061152_SYd52 USL011 2025-08-23T12:05:24.017Z 2025-08-30T12:58:32.829Z
7594881 7594881 20250820114140_1eNr2 USL011 2025-08-22T12:11:45.811Z 2025-08-29T12:55:54.561Z
7594730 7594730 20250820113158_SXd9F USL011 2025-08-22T12:11:16.090Z 2025-08-29T12:55:49.852Z
7592630 7592630 20250821114037_H9lht USL011 2025-08-22T12:04:11.035Z 2025-08-22T12:04:11.035Z
7568758 7568758 20250818112507_mN2dU USL011 2025-08-20T12:16:16.880Z 2025-08-27T13:13:31.500Z
7568578 7568578 20250818105057_nwwef USL011 2025-08-20T12:15:44.100Z 2025-08-27T13:13:30.606Z
7568553 7568553 20250818104813_KNHnU USL011 2025-08-20T12:15:37.525Z 2025-08-20T12:38:25.977Z
7557350 7557350 20250817105915_2G1IR USL011 2025-08-19T12:36:51.177Z 2025-08-25T12:51:56.489Z
7557347 7557347 20250817105844_EjWhe USL011 2025-08-19T12:36:50.144Z 2025-08-25T12:51:56.484Z
7556584 7556584 20250817093217_dmxaH USL011 2025-08-19T12:32:56.241Z 2025-08-25T12:51:54.355Z
7556482 7556482 20250817091255_xo9hQ USL011 2025-08-19T12:32:28.107Z 2025-08-25T12:51:54.014Z
7535598 7535598 20250816113736_ouico USL011 2025-08-18T12:20:10.366Z 2025-08-24T12:48:12.401Z
7535461 7535461 20250816111647_ryqDI USL011 2025-08-18T12:19:39.556Z 2025-08-24T12:48:11.335Z
7535321 7535321 20250816104921_2wyGu USL011 2025-08-18T12:19:15.076Z 2025-08-24T12:48:10.582Z
7535318 7535318 20250816104914_snjOA USL011 2025-08-18T12:19:12.601Z 2025-08-24T12:48:10.562Z
7534885 7534885 20250816092258_CpMQ0 USL011 2025-08-18T12:17:45.396Z 2025-08-24T12:48:00.572Z
7534635 7534635 20250816081516_4FaEr USL011 2025-08-18T12:16:51.166Z 2025-08-24T12:47:57.158Z
7398167 7398167 20250806082625_29BSU USL011 2025-08-08T12:24:49.908Z 2025-08-14T12:59:17.552Z
7271506 7271506 20250730112204_CUrrV USL011 2025-08-01T12:02:00.769Z 2025-08-08T12:55:43.042Z
7271265 7271265 20250730111034_rGtrG USL011 2025-08-01T12:01:51.397Z 2025-08-08T12:55:40.215Z
7255319 7255319 20250729112651_1tsiT USL011 2025-07-31T12:03:28.168Z 2025-08-07T12:48:16.929Z
7255180 7255180 20250729110856_3e6lf USL011 2025-07-31T12:03:22.186Z 2025-08-07T12:48:16.338Z
7255152 7255152 20250729110329_4FTbO USL011 2025-07-31T12:03:21.178Z 2025-08-07T12:48:16.250Z
7254974 7254974 20250729103736_i8mVD USL011 2025-07-31T12:03:05.990Z 2025-08-07T12:48:14.484Z
7254843 7254843 20250729101908_58WkD USL011 2025-07-31T12:03:00.318Z 2025-08-07T12:48:14.036Z
7252686 7252686 20250729060643_h1Byl USL011 2025-07-31T12:00:39.989Z 2025-08-07T12:48:02.596Z
7252650 7252650 20250729055843_nBOyO USL011 2025-07-31T12:00:36.108Z 2025-08-07T12:48:02.439Z
7252643 7252643 20250729055750_Q6XUw USL011 2025-07-31T12:00:35.608Z 2025-08-07T12:48:02.406Z
7252615 7252615 20250729055228_fjWTj USL011 2025-07-31T12:00:32.792Z 2025-08-07T12:48:02.284Z
7252564 7252564 20250729054108_tJXFh USL011 2025-07-31T12:00:27.787Z 2025-08-07T12:48:02.144Z

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