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 = "USL00D" 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
8430363 8430363 20251111122550_FLo7Z USL00D 2025-11-13T14:00:55.951Z 2025-11-20T15:19:29.536Z
8429880 8429880 20251111114720_93gTG USL00D 2025-11-12T14:45:11.199Z 2025-11-19T15:19:09.957Z
8429676 8429676 20251111104549_PWBp1 USL00D 2025-11-12T14:44:59.633Z 2025-11-19T15:18:52.154Z
8429443 8429443 20251111095407_LcctX USL00D 2025-11-12T14:44:25.259Z 2025-11-19T15:18:41.512Z
8429114 8429114 20251111083335_9AxTE USL00D 2025-11-12T14:43:21.924Z 2025-11-19T15:18:26.824Z
8429058 8429058 20251111082532_D0n7a USL00D 2025-11-12T14:43:13.891Z 2025-11-19T15:18:26.190Z
8428122 8428122 20251111055249_Tja33 USL00D 2025-11-12T14:29:57.759Z 2025-11-19T15:18:09.921Z
8427976 8427976 20251111053350_F7a15 USL00D 2025-11-12T14:29:45.756Z 2025-11-19T15:18:07.933Z
8427931 8427931 20251111052657_z5wx3 USL00D 2025-11-12T14:29:34.858Z 2025-11-19T15:18:07.367Z
8427870 8427870 20251111052005_kD2xs USL00D 2025-11-12T14:29:15.593Z 2025-11-19T15:18:06.619Z
8427669 8427669 20251111050019_ASGa3 USL00D 2025-11-12T14:28:55.067Z 2025-11-19T15:17:59.182Z
8427632 8427632 20251111045703_JAG6G USL00D 2025-11-12T14:28:51.044Z 2025-11-19T15:17:58.423Z
8427354 8427354 20251111043108_L1IYR USL00D 2025-11-12T14:28:00.094Z 2025-11-19T15:17:51.291Z
8426773 8426773 20251111034210_qlg80 USL00D 2025-11-12T14:26:21.684Z 2025-11-19T15:17:25.966Z
8426263 8426263 20251111024900_siSfu USL00D 2025-11-12T14:24:58.031Z 2025-11-19T15:17:02.506Z
8300870 8300870 20251026114302_w1IdB USL00D 2025-10-30T13:04:25.911Z 2025-11-03T15:17:14.329Z
8267581 8267581 20251026115255_tp0X2 USL00D 2025-10-28T12:41:17.633Z 2025-11-03T15:17:16.276Z
8266508 8266508 20251026095903_VzqB6 USL00D 2025-10-28T12:39:43.927Z 2025-11-03T15:17:08.508Z
8266476 8266476 20251026095334_J42Ux USL00D 2025-10-28T12:39:43.416Z 2025-11-03T15:17:08.484Z
8228844 8228844 20251024122824_OB3YT USL00D 2025-10-26T12:48:08.828Z 2025-11-01T13:11:34.777Z
8228665 8228665 20251024121518_LdZ7C USL00D 2025-10-26T12:48:05.131Z 2025-11-01T13:11:33.952Z
8228277 8228277 20251024114645_r0bJA USL00D 2025-10-26T12:47:33.673Z 2025-11-01T13:11:32.648Z
8228166 8228166 20251024114028_nYGq2 USL00D 2025-10-26T12:47:21.743Z 2025-11-01T13:11:32.307Z
8228123 8228123 20251024113554_KB3W9 USL00D 2025-10-26T12:47:17.021Z 2025-11-01T13:11:32.149Z
8228065 8228065 20251024113206_BarlL USL00D 2025-10-26T12:47:07.763Z 2025-11-01T13:11:31.704Z
8227581 8227581 20251024105426_upP72 USL00D 2025-10-26T12:46:13.275Z 2025-11-01T13:11:30.066Z
8227558 8227558 20251024105231_UX8lX USL00D 2025-10-26T12:46:12.736Z 2025-11-01T13:11:30.010Z
8227389 8227389 20251024104015_d54I6 USL00D 2025-10-26T12:45:51.810Z 2025-11-01T13:11:29.420Z
8227199 8227199 20251024102144_32okg USL00D 2025-10-26T12:45:28.711Z 2025-11-01T13:11:28.583Z
8227113 8227113 20251024101645_pgdP5 USL00D 2025-10-26T12:45:22.503Z 2025-11-01T13:11:28.422Z
8227077 8227077 20251024101518_zjF2A USL00D 2025-10-26T12:45:21.801Z 2025-11-01T13:11:28.358Z
8227021 8227021 20251024101146_SMyMw USL00D 2025-10-26T12:45:20.294Z 2025-11-01T13:11:28.230Z
8226788 8226788 20251024095512_Q5Ld2 USL00D 2025-10-26T12:45:11.057Z 2025-11-01T13:11:27.695Z
8226755 8226755 20251024095301_qiHJQ USL00D 2025-10-26T12:45:09.932Z 2025-11-01T13:11:27.554Z
8226748 8226748 20251024095146_ctOU0 USL00D 2025-10-26T12:45:09.637Z 2025-11-01T13:11:27.547Z
8226644 8226644 20251024094337_uCmVN USL00D 2025-10-26T12:45:07.057Z 2025-11-01T13:11:27.058Z
8226439 8226439 20251024092719_803m6 USL00D 2025-10-26T12:45:01.626Z 2025-11-01T13:11:25.631Z
8226340 8226340 20251024091747_UVUgD USL00D 2025-10-26T12:44:58.859Z 2025-11-01T13:11:25.187Z
8226277 8226277 20251024091128_J25P7 USL00D 2025-10-26T12:44:57.325Z 2025-11-01T13:11:24.902Z
8226272 8226272 20251024091126_IExRb USL00D 2025-10-26T12:44:57.152Z 2025-11-01T13:11:24.898Z
8226033 8226033 20251024085507_njR3N USL00D 2025-10-26T12:44:25.274Z 2025-11-01T13:11:23.743Z
8225785 8225785 20251024083639_rE6c2 USL00D 2025-10-26T12:43:48.354Z 2025-11-01T13:11:22.861Z
8225720 8225720 20251024083044_A3kcF USL00D 2025-10-26T12:43:40.044Z 2025-11-01T13:11:22.714Z
8225638 8225638 20251024082311_ep5L1 USL00D 2025-10-26T12:43:31.147Z 2025-11-01T13:11:22.417Z
8225575 8225575 20251024081735_hNs3P USL00D 2025-10-26T12:43:23.093Z 2025-11-01T13:11:22.228Z
8225470 8225470 20251024080802_cxHyb USL00D 2025-10-26T12:43:17.543Z 2025-11-01T13:11:21.975Z
8225406 8225406 20251024080332_ZhV5I USL00D 2025-10-26T12:43:16.011Z 2025-11-01T13:11:21.815Z
8225240 8225240 20251024074951_4tv6h USL00D 2025-10-26T12:43:08.250Z 2025-11-01T13:11:21.395Z
8225065 8225065 20251024073401_322D6 USL00D 2025-10-26T12:43:01.910Z 2025-11-01T13:11:21.010Z
8224572 8224572 20251024065047_q7phn USL00D 2025-10-26T12:42:12.476Z 2025-11-01T13:11:19.602Z
8224566 8224566 20251024065036_ldcb1 USL00D 2025-10-26T12:42:11.234Z 2025-11-01T13:11:19.563Z
8223980 8223980 20251024055157_4CFH0 USL00D 2025-10-26T12:41:12.060Z 2025-11-01T13:11:17.904Z
8223905 8223905 20251024054520_gJfyI USL00D 2025-10-26T12:41:09.569Z 2025-11-01T13:11:17.684Z
8223819 8223819 20251024053322_ipxw9 USL00D 2025-10-26T12:41:06.297Z 2025-11-01T13:11:17.333Z
8223803 8223803 20251024053310_my4dg USL00D 2025-10-26T12:41:05.436Z 2025-11-01T13:11:17.249Z
8221598 8221598 20251024043031_HLU34 USL00D 2025-10-26T12:38:30.998Z 2025-11-01T13:11:10.208Z
8221585 8221585 20251024043021_A3ia1 USL00D 2025-10-26T12:38:30.131Z 2025-11-01T13:11:10.132Z
8220434 8220434 20251024040015_6WaP5 USL00D 2025-10-26T12:37:26.233Z 2025-11-01T13:11:03.908Z
8220318 8220318 20251024035815_Tz3u9 USL00D 2025-10-26T12:37:23.986Z 2025-11-01T13:11:03.197Z
8219359 8219359 20251024032953_Wh7W5 USL00D 2025-10-26T12:36:19.127Z 2025-11-01T13:10:57.069Z
8217759 8217759 20251024024432_NMuVM USL00D 2025-10-26T12:34:16.265Z 2025-11-01T13:10:45.783Z
8205382 8205382 20251024123934_SfasP USL00D 2025-10-26T12:00:21.541Z 2025-11-02T15:04:46.594Z
8116374 8116374 20251016111312_vLdKR USL00D 2025-10-17T12:19:23.942Z 2025-10-24T13:17:11.177Z
8116292 8116292 20251016110334_2dI2Y USL00D 2025-10-17T12:19:22.015Z 2025-10-24T13:17:10.670Z
8108279 8108279 20251016121729_je40A USL00D 2025-10-17T12:00:39.584Z 2025-10-25T13:24:18.923Z
8108153 8108153 20251016115847_g0RDX USL00D 2025-10-17T12:00:25.286Z 2025-10-25T13:24:01.624Z
8108053 8108053 20251016113817_qtGp3 USL00D 2025-10-17T12:00:16.503Z 2025-10-25T13:23:53.791Z
8035038 8035038 20251001121047_YkPR1 USL00D 2025-10-03T12:11:05.320Z 2025-10-10T12:37:33.573Z
7861142 7861142 20250916110646_d2Ceo USL00D 2025-09-18T12:29:10.956Z 2025-09-24T13:16:52.047Z
7860080 7860080 20250917115623_4eCTG USL00D 2025-09-18T12:17:19.910Z 2025-09-25T13:12:00.137Z
7859653 7859653 20250917101240_4ThLw USL00D 2025-09-18T12:15:47.048Z 2025-09-25T13:11:42.149Z
7859549 7859549 20250917094450_QfCyF USL00D 2025-09-18T12:15:17.868Z 2025-09-25T13:11:38.833Z
7849334 7849334 20250916090453_u2u3d USL00D 2025-09-17T12:19:31.972Z 2025-09-24T13:16:37.925Z
7849232 7849232 20250916085206_ZIk3l USL00D 2025-09-17T12:19:05.470Z 2025-09-24T13:16:37.193Z
7848488 7848488 20250916071617_5R0Ug USL00D 2025-09-17T12:16:52.441Z 2025-09-24T13:16:18.983Z
7579136 7579136 20250819111628_dOfIS USL00D 2025-08-21T12:10:29.099Z 2025-08-28T12:52:03.663Z
7579072 7579072 20250819110104_A8HrF USL00D 2025-08-21T12:10:19.448Z 2025-08-28T12:52:03.235Z
7578967 7578967 20250819104111_nj3bs USL00D 2025-08-21T12:10:04.709Z 2025-08-28T12:52:01.210Z
7578907 7578907 20250819102712_B5OCa USL00D 2025-08-21T12:09:46.144Z 2025-08-28T12:52:00.263Z
6979067 6979067 20250625100653_zLhST USL00D 2025-06-27T12:23:36.636Z 2025-07-03T13:02:25.057Z
6978937 6978937 20250626111606_JeW4p USL00D 2025-06-27T12:15:31.079Z 2025-07-04T12:36:31.048Z
6978929 6978929 20250626111551_uB9uj USL00D 2025-06-27T12:15:30.642Z 2025-07-04T12:36:31.031Z
6978915 6978915 20250626111159_Lep4m USL00D 2025-06-27T12:15:29.301Z 2025-07-04T12:36:30.862Z
6978889 6978889 20250626111003_ogDOl USL00D 2025-06-27T12:15:27.696Z 2025-07-04T12:36:30.730Z
6978886 6978886 20250626110955_VwZTo USL00D 2025-06-27T12:15:27.282Z 2025-07-04T12:36:30.719Z
6978879 6978879 20250626110758_hAqhK USL00D 2025-06-27T12:15:26.302Z 2025-07-04T12:36:30.602Z
6978831 6978831 20250626110123_IhejG USL00D 2025-06-27T12:15:21.856Z 2025-07-04T12:36:29.706Z
6978779 6978779 20250626104210_eRJIV USL00D 2025-06-27T12:15:10.436Z 2025-07-04T12:36:26.230Z
6978707 6978707 20250626103236_KrKvc USL00D 2025-06-27T12:14:58.074Z 2025-07-04T12:36:24.641Z
6978697 6978697 20250626102847_xS2jx USL00D 2025-06-27T12:14:57.412Z 2025-07-04T12:36:23.842Z
6978683 6978683 20250626102517_o8B3y USL00D 2025-06-27T12:14:56.546Z 2025-07-04T12:36:23.654Z
6978650 6978650 20250626101713_Uxyyc USL00D 2025-06-27T12:14:52.611Z 2025-07-04T12:36:22.781Z
6978622 6978622 20250626101350_VWeo3 USL00D 2025-06-27T12:14:49.789Z 2025-07-04T12:36:22.203Z
6978606 6978606 20250626101131_X01OI USL00D 2025-06-27T12:14:48.181Z 2025-07-04T12:36:21.879Z
6978520 6978520 20250626095710_5dwhY USL00D 2025-06-27T12:14:39.676Z 2025-07-04T12:36:19.987Z
6978485 6978485 20250626094818_swcKu USL00D 2025-06-27T12:14:37.009Z 2025-07-04T12:36:19.675Z
6978473 6978473 20250626094714_3kiho USL00D 2025-06-27T12:14:36.010Z 2025-07-04T12:36:19.575Z
6978388 6978388 20250626091834_w3tdB USL00D 2025-06-27T12:14:15.201Z 2025-07-04T12:36:18.740Z
6978342 6978342 20250626090228_k7Wdo USL00D 2025-06-27T12:14:07.704Z 2025-07-04T12:36:17.910Z
6978195 6978195 20250626083742_kdaLw USL00D 2025-06-27T12:13:53.752Z 2025-07-04T12:36:15.572Z

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