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 = "USL007" 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
8071659 8071659 20251008123903_hqZ6H USL007 2025-10-09T12:01:04.756Z 2025-10-17T12:36:54.458Z
8071622 8071622 20251008121652_M7JbN USL007 2025-10-09T12:00:59.563Z 2025-10-17T12:36:52.490Z
8071569 8071569 20251008113952_AaWnp USL007 2025-10-09T12:00:53.634Z 2025-10-17T12:36:50.944Z
8071562 8071562 20251008113327_dN8fp USL007 2025-10-09T12:00:52.793Z 2025-10-17T12:36:50.892Z
8071497 8071497 20251008110510_RfEEL USL007 2025-10-09T12:00:35.276Z 2025-10-17T12:36:47.976Z
8071438 8071438 20251008102653_GZkiy USL007 2025-10-09T12:00:28.079Z 2025-10-17T12:36:42.554Z
8071323 8071323 20251008092459_lt2Wo USL007 2025-10-09T12:00:09.936Z 2025-10-17T12:36:40.158Z
8071316 8071316 20251008092457_CxOBw USL007 2025-10-09T12:00:09.536Z 2025-10-17T12:36:40.118Z
8069744 8069744 20251006122554_uT2Ld USL007 2025-10-08T12:05:46.247Z 2025-10-15T12:43:37.716Z
8069684 8069684 20251006121043_j3uAG USL007 2025-10-08T12:05:36.257Z 2025-10-15T12:43:35.307Z
8069620 8069620 20251006115646_6LqQp USL007 2025-10-08T12:05:21.455Z 2025-10-15T12:43:29.776Z
8069567 8069567 20251006114134_CZuu2 USL007 2025-10-08T12:05:13.214Z 2025-10-15T12:43:25.415Z
8069561 8069561 20251006113722_2kQ5z USL007 2025-10-08T12:05:12.186Z 2025-10-15T12:43:25.346Z
8069479 8069479 20251006111543_XchgJ USL007 2025-10-08T12:05:03.788Z 2025-10-15T12:43:24.149Z
8069437 8069437 20251006110447_oj0rb USL007 2025-10-08T12:04:58.548Z 2025-10-15T12:43:23.228Z
8069346 8069346 20251006102932_cA3St USL007 2025-10-08T12:04:36.038Z 2025-10-15T12:43:21.875Z
8069323 8069323 20251006102058_Dmrq9 USL007 2025-10-08T12:04:33.197Z 2025-10-15T12:43:21.455Z
8069300 8069300 20251006101146_CzWVa USL007 2025-10-08T12:04:29.685Z 2025-10-15T12:43:21.009Z
8069292 8069292 20251006101124_CoXu6 USL007 2025-10-08T12:04:28.456Z 2025-10-15T12:43:20.755Z
8069289 8069289 20251006101111_WrazK USL007 2025-10-08T12:04:28.027Z 2025-10-15T12:43:20.714Z
8069258 8069258 20251006100659_BHNWo USL007 2025-10-08T12:04:24.262Z 2025-10-15T12:43:20.264Z
8069207 8069207 20251006094633_ZhByI USL007 2025-10-08T12:04:07.565Z 2025-10-15T12:43:19.230Z
8068691 8068691 20251007123207_ANKPQ USL007 2025-10-08T12:02:09.150Z 2025-10-16T12:47:46.335Z
8068624 8068624 20251007115620_RavCo USL007 2025-10-08T12:01:46.533Z 2025-10-16T12:47:42.362Z
8068612 8068612 20251007115348_zeIA2 USL007 2025-10-08T12:01:43.781Z 2025-10-16T12:47:42.040Z
8068573 8068573 20251007114134_5n3xv USL007 2025-10-08T12:01:34.128Z 2025-10-16T12:47:40.808Z
8068568 8068568 20251007114019_G4t1O USL007 2025-10-08T12:01:33.537Z 2025-10-16T12:47:40.745Z
8068455 8068455 20251007105324_ghBK2 USL007 2025-10-08T12:01:01.913Z 2025-10-16T12:47:36.165Z
8068374 8068374 20251007102236_Rhrhd USL007 2025-10-08T12:00:47.089Z 2025-10-16T12:47:33.749Z
8068311 8068311 20251007095410_Ya9sp USL007 2025-10-08T12:00:31.936Z 2025-10-16T12:47:32.460Z
8067999 8067999 20251005080055_UdzP3 USL007 2025-10-07T12:35:26.016Z 2025-10-13T12:34:25.225Z
8067946 8067946 20251005074559_gk4dN USL007 2025-10-07T12:35:22.989Z 2025-10-13T12:34:24.203Z
8067595 8067595 20251005055633_QrzEN USL007 2025-10-07T12:34:22.184Z 2025-10-13T12:34:13.710Z
8066609 8066609 20251005035206_4wyJc USL007 2025-10-07T12:33:04.193Z 2025-10-13T12:33:59.367Z
8065883 8065883 20251005024419_iDlVC USL007 2025-10-07T12:32:04.134Z 2025-10-13T12:33:53.574Z
8064150 8064150 20251004122859_4ak7t USL007 2025-10-07T12:28:01.033Z 2025-10-13T12:33:01.642Z
8064145 8064145 20251004122808_yg1xh USL007 2025-10-07T12:28:00.733Z 2025-10-13T12:33:01.599Z
8064133 8064133 20251004122002_AAckE USL007 2025-10-07T12:28:00.128Z 2025-10-13T12:33:01.448Z
8064089 8064089 20251004120520_sLI5U USL007 2025-10-07T12:27:37.887Z 2025-10-13T12:32:58.011Z
8064080 8064080 20251004120157_iHToz USL007 2025-10-07T12:27:35.495Z 2025-10-13T12:32:57.443Z
8063846 8063846 20251004111533_MpJqY USL007 2025-10-07T12:27:07.304Z 2025-10-13T12:32:45.789Z
8063803 8063803 20251004111216_fYLi1 USL007 2025-10-07T12:27:03.389Z 2025-10-13T12:32:44.828Z
8063638 8063638 20251004103929_gXi0T USL007 2025-10-07T12:26:21.983Z 2025-10-13T12:32:34.951Z
8063615 8063615 20251004103547_E42YU USL007 2025-10-07T12:26:20.201Z 2025-10-13T12:32:34.107Z
8063422 8063422 20251004100457_n42gs USL007 2025-10-07T12:26:02.191Z 2025-10-13T12:32:28.645Z
8062956 8062956 20251004085024_exj77 USL007 2025-10-07T12:24:29.362Z 2025-10-13T12:32:07.447Z
8062870 8062870 20251004083520_aeDHf USL007 2025-10-07T12:24:13.351Z 2025-10-13T12:32:04.613Z
8062816 8062816 20251004082517_M9e2f USL007 2025-10-07T12:23:52.909Z 2025-10-13T12:32:01.825Z
8062767 8062767 20251004081314_8C0wC USL007 2025-10-07T12:23:42.975Z 2025-10-13T12:31:54.567Z
8062694 8062694 20251006083607_f23hH USL007 2025-10-07T12:23:31.089Z 2025-10-14T12:35:23.771Z
8062620 8062620 20251006080214_Nlwzr USL007 2025-10-07T12:23:08.553Z 2025-10-07T12:23:08.553Z
8062492 8062492 20251006071033_IzGXo USL007 2025-10-07T12:22:46.294Z 2025-10-14T12:35:13.914Z
8062420 8062420 20251006062043_8ddUk USL007 2025-10-07T12:22:36.142Z 2025-10-14T12:35:11.627Z
8062209 8062209 20251006054136_67G3k USL007 2025-10-07T12:16:22.753Z 2025-10-14T12:35:08.327Z
8061682 8061682 20251006033107_sf2Uf USL007 2025-10-07T12:14:16.154Z 2025-10-14T12:34:44.928Z
8061578 8061578 20251006030948_XpAbe USL007 2025-10-07T12:14:01.682Z 2025-10-14T12:34:43.343Z
8059691 8059691 20251005122833_dr4lz USL007 2025-10-07T12:06:48.791Z 2025-10-14T12:33:18.219Z
8059663 8059663 20251005122431_vewp3 USL007 2025-10-07T12:06:37.789Z 2025-10-14T12:33:17.930Z
8059561 8059561 20251005120135_2vwA1 USL007 2025-10-07T12:06:20.223Z 2025-10-14T12:33:17.091Z
8059481 8059481 20251005115048_zgzUy USL007 2025-10-07T12:05:55.669Z 2025-10-14T12:33:16.222Z
8059174 8059174 20251005105853_jXxTr USL007 2025-10-07T12:04:51.457Z 2025-10-14T12:33:12.867Z
8059061 8059061 20251005104029_ZdlO2 USL007 2025-10-07T12:04:22.995Z 2025-10-14T12:33:11.480Z
8059029 8059029 20251005103240_Ii9AL USL007 2025-10-07T12:04:04.233Z 2025-10-14T12:33:11.252Z
8058622 8058622 20251005091818_ZpDO4 USL007 2025-10-07T12:02:08.566Z 2025-10-14T12:32:57.433Z
8058546 8058546 20251005090355_fGEfS USL007 2025-10-07T12:01:50.992Z 2025-10-14T12:32:54.054Z
8058527 8058527 20251005090122_BysAc USL007 2025-10-07T12:01:46.533Z 2025-10-14T12:32:52.918Z
8058402 8058402 20251005084337_qAwXB USL007 2025-10-07T12:01:00.493Z 2025-10-14T12:32:43.018Z
8057702 8057702 20251004060248_fvEK2 USL007 2025-10-05T12:31:52.344Z 2025-10-12T12:33:17.216Z
8057549 8057549 20251004045113_HI92h USL007 2025-10-05T12:30:54.410Z 2025-10-12T12:33:04.919Z
8057438 8057438 20251004034514_73GEQ USL007 2025-10-05T12:29:57.078Z 2025-10-12T12:32:44.291Z
8057328 8057328 20251004030617_l3u8O USL007 2025-10-05T12:29:30.429Z 2025-10-12T12:32:31.060Z
7023267 7023267 20250702110320_rU5vk USL007 2025-07-03T12:11:33.881Z 2025-07-10T12:25:56.311Z
7023179 7023179 20250702103436_Nu7MX USL007 2025-07-03T12:11:20.846Z 2025-07-10T12:25:56.103Z
7023062 7023062 20250702101059_93APv USL007 2025-07-03T12:10:53.158Z 2025-07-10T12:25:55.862Z
7023033 7023033 20250702100610_eDF63 USL007 2025-07-03T12:10:50.220Z 2025-07-10T12:25:55.801Z
7023020 7023020 20250702100510_fkSJw USL007 2025-07-03T12:10:49.483Z 2025-07-10T12:25:55.789Z
7023013 7023013 20250702100454_pDOQc USL007 2025-07-03T12:10:48.692Z 2025-07-10T12:25:55.767Z
7022966 7022966 20250702095310_Rfysa USL007 2025-07-03T12:10:42.256Z 2025-07-10T12:25:55.647Z
7022936 7022936 20250702094139_dib2X USL007 2025-07-03T12:10:38.577Z 2025-07-10T12:25:55.552Z
7022831 7022831 20250702091047_vT4oX USL007 2025-07-03T12:10:19.113Z 2025-07-10T12:25:55.309Z
7022786 7022786 20250702090351_6jp7H USL007 2025-07-03T12:10:13.616Z 2025-07-10T12:25:55.246Z
7022750 7022750 20250702085202_AM53A USL007 2025-07-03T12:10:08.512Z 2025-07-10T12:25:55.087Z
7022727 7022727 20250702084548_EGoPZ USL007 2025-07-03T12:10:06.281Z 2025-07-10T12:25:55.015Z
7022721 7022721 20250702084518_ewFCe USL007 2025-07-03T12:10:05.848Z 2025-07-10T12:25:55.006Z
7022559 7022559 20250702073805_kQxBG USL007 2025-07-03T12:09:33.160Z 2025-07-10T12:25:54.321Z
7022481 7022481 20250702070235_UIOvV USL007 2025-07-03T12:09:18.521Z 2025-07-10T12:25:52.862Z
7022433 7022433 20250702064527_4YyTg USL007 2025-07-03T12:09:11.450Z 2025-07-10T12:25:52.073Z
7022216 7022216 20250702045251_rnZmc USL007 2025-07-03T12:08:14.905Z 2025-07-10T12:25:49.065Z
7015656 7015656 20250701112134_ctCA5 USL007 2025-07-02T12:13:19.921Z 2025-07-09T12:59:24.217Z
7015644 7015644 20250701110846_lTKAw USL007 2025-07-02T12:13:18.670Z 2025-07-09T12:59:21.887Z
7015580 7015580 20250701105059_8XwLS USL007 2025-07-02T12:13:09.922Z 2025-07-09T12:59:17.605Z
7015531 7015531 20250701103214_38n4A USL007 2025-07-02T12:13:01.568Z 2025-07-09T12:59:15.258Z
7015525 7015525 20250701103210_uVm7J USL007 2025-07-02T12:13:01.233Z 2025-07-09T12:59:15.199Z
7015476 7015476 20250701101550_tXvj2 USL007 2025-07-02T12:12:53.957Z 2025-07-09T12:58:56.233Z
7015434 7015434 20250701100749_zjoxx USL007 2025-07-02T12:12:45.050Z 2025-07-09T12:58:52.971Z
7015345 7015345 20250701094757_XR9So USL007 2025-07-02T12:12:16.257Z 2025-07-09T12:58:48.344Z
7015308 7015308 20250701093330_qJf8l USL007 2025-07-02T12:12:07.894Z 2025-07-09T12:58:45.662Z
7015141 7015141 20250701084914_tFMdJ USL007 2025-07-02T12:11:40.860Z 2025-07-09T12:58:37.615Z
7015081 7015081 20250701082701_98Ryj USL007 2025-07-02T12:11:27.105Z 2025-07-09T12:58:33.393Z
7015033 7015033 20250701081406_JQl8x USL007 2025-07-02T12:11:19.991Z 2025-07-09T12:58:20.111Z

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