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

965 rows where station_code = "US0046" 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
9267925 9267925 20260127065625_Wpvps US0046 2026-01-28T14:23:54.483Z 2026-01-29T14:35:54.413Z
9267665 9267665 20260127040720_m9LQa US0046 2026-01-28T14:22:48.006Z 2026-01-29T14:35:26.697Z
9267630 9267630 20260127034902_Qs3ta US0046 2026-01-28T14:22:36.429Z 2026-01-29T14:35:23.663Z
9267611 9267611 20260127034038_okRBU US0046 2026-01-28T14:22:31.975Z 2026-01-29T14:35:22.382Z
9267496 9267496 20260127021639_8y1Dq US0046 2026-01-28T14:21:57.915Z 2026-01-29T14:35:08.114Z
9252529 9252529 20260123034929_sHMBr US0046 2026-01-24T14:16:03.317Z 2026-01-29T14:53:06.308Z
9244239 9244239 20260121065713_Uu2XC US0046 2026-01-22T14:24:41.897Z 2026-01-29T15:05:57.117Z
9244142 9244142 20260121062150_hFBog US0046 2026-01-22T14:24:16.751Z 2026-01-29T15:05:53.406Z
9242918 9242918 20260121031502_QvoQN US0046 2026-01-22T14:19:46.317Z 2026-01-29T15:04:29.767Z
9242240 9242240 20260121011035_Ddoi7 US0046 2026-01-22T14:16:58.853Z 2026-01-29T15:03:38.229Z
9242224 9242224 20260121010634_Fh4pX US0046 2026-01-22T14:16:56.589Z 2026-01-29T15:03:37.631Z
9239263 9239263 20260121101823_JIAO3 US0046 2026-01-22T14:00:41.253Z 2026-01-29T14:54:04.629Z
9238908 9238908 20260120101428_2XmtQ US0046 2026-01-21T14:31:02.121Z 2026-01-28T15:03:06.436Z
9238460 9238460 20260120084226_Gb6j8 US0046 2026-01-21T14:29:37.209Z 2026-01-28T15:02:34.263Z
9235187 9235187 20260120004141_x718V US0046 2026-01-21T14:17:51.793Z 2026-01-28T14:58:42.650Z
9232539 9232539 20260120114543_zAREx US0046 2026-01-21T14:02:18.066Z 2026-01-29T14:59:49.410Z
9232432 9232432 20260120112645_8NXlI US0046 2026-01-21T14:01:49.727Z 2026-01-29T14:59:34.088Z
9232178 9232178 20260120103745_IAhQa US0046 2026-01-21T14:00:41.699Z 2026-01-29T14:59:18.441Z
9231752 9231752 20260119094618_7lU9X US0046 2026-01-20T14:34:14.575Z 2026-01-27T15:06:58.535Z
9231718 9231718 20260119094041_Jghwe US0046 2026-01-20T14:34:02.858Z 2026-01-27T15:06:56.809Z
9231628 9231628 20260119090651_vSzpD US0046 2026-01-20T14:33:40.634Z 2026-01-27T15:06:41.487Z
9231618 9231618 20260119090602_0P1as US0046 2026-01-20T14:33:35.076Z 2026-01-27T15:06:40.925Z
9231584 9231584 20260119085353_isAYq US0046 2026-01-20T14:33:27.726Z 2026-01-27T15:06:37.496Z
9231535 9231535 20260119083656_Up1Kz US0046 2026-01-20T14:33:13.111Z 2026-01-27T15:06:34.829Z
9231397 9231397 20260119075137_SFa3c US0046 2026-01-20T14:32:37.336Z 2026-01-27T15:06:27.744Z
9231257 9231257 20260119065520_ng2cm US0046 2026-01-20T14:32:02.975Z 2026-01-27T15:06:10.150Z
9231150 9231150 20260119061207_hRi5p US0046 2026-01-20T14:31:34.213Z 2026-01-27T15:06:01.649Z
9230353 9230353 20260119040626_q2nuu US0046 2026-01-20T14:27:22.625Z 2026-01-27T15:04:49.982Z
9230099 9230099 20260119032515_coULT US0046 2026-01-20T14:25:57.530Z 2026-01-27T15:04:25.411Z
9226261 9226261 20260119113622_G3v3F US0046 2026-01-20T14:02:06.559Z 2026-01-28T14:54:51.209Z
9226251 9226251 20260119113350_zYH09 US0046 2026-01-20T14:02:04.268Z 2026-01-28T14:54:50.545Z
9226073 9226073 20260119110105_n6240 US0046 2026-01-20T14:00:56.451Z 2026-01-28T14:54:33.317Z
9226070 9226070 20260119110100_yoReO US0046 2026-01-20T14:00:55.287Z 2026-01-28T14:54:33.203Z
9225546 9225546 20260118100635_X2Yfd US0046 2026-01-19T14:29:23.749Z 2026-01-26T15:04:37.729Z
9225087 9225087 20260118073050_EVpKT US0046 2026-01-19T14:27:31.554Z 2026-01-26T15:04:01.226Z
9225060 9225060 20260118072418_3KEqM US0046 2026-01-19T14:27:24.454Z 2026-01-26T15:04:00.322Z
9219977 9219977 20260118114642_mS5of US0046 2026-01-19T14:01:58.073Z 2026-01-27T14:58:44.294Z
9219646 9219646 20260117112658_DF5uj US0046 2026-01-18T14:17:19.765Z 2026-01-25T14:59:34.614Z
9214824 9214824 20260116081921_Y23tL US0046 2026-01-17T14:23:25.747Z 2026-01-24T15:14:09.178Z
9214687 9214687 20260116073905_cyt7H US0046 2026-01-17T14:22:43.188Z 2026-01-24T15:14:01.530Z
9214354 9214354 20260116062107_VjuVZ US0046 2026-01-17T14:21:10.019Z 2026-01-24T15:13:31.183Z
9209601 9209601 20260115101657_PihR6 US0046 2026-01-16T14:16:53.688Z 2026-01-22T15:05:31.268Z
9209133 9209133 20260115083717_6HGHz US0046 2026-01-16T14:15:15.482Z 2026-01-22T15:04:49.821Z
9209040 9209040 20260115081217_2WY8s US0046 2026-01-16T14:14:54.021Z 2026-01-22T15:04:47.322Z
9208961 9208961 20260115075014_aDxtz US0046 2026-01-16T14:14:37.456Z 2026-01-22T15:04:45.039Z
9208447 9208447 20260115052620_2eqXG US0046 2026-01-16T14:12:43.830Z 2026-01-22T15:04:14.260Z
9197997 9197997 20260112115618_nfcW6 US0046 2026-01-14T14:35:34.289Z 2026-01-20T15:25:53.758Z
9197474 9197474 20260113111751_plcE7 US0046 2026-01-14T14:23:02.156Z 2026-01-21T15:06:18.829Z
9197015 9197015 20260113095616_iULZ7 US0046 2026-01-14T14:21:08.252Z 2026-01-21T15:06:12.431Z
9196740 9196740 20260113085454_3GjsD US0046 2026-01-14T14:19:51.894Z 2026-01-21T15:05:38.192Z
9196554 9196554 20260113074357_iXAwz US0046 2026-01-14T14:18:53.959Z 2026-01-21T15:05:34.564Z
9196515 9196515 20260113072100_24UWa US0046 2026-01-14T14:18:42.852Z 2026-01-21T15:05:34.036Z
9196504 9196504 20260113072004_cUq00 US0046 2026-01-14T14:18:40.827Z 2026-01-21T15:05:33.930Z
9196468 9196468 20260113070918_3UaU3 US0046 2026-01-14T14:18:27.255Z 2026-01-21T15:05:33.471Z
9195100 9195100 20260113001839_Ji3y0 US0046 2026-01-14T14:12:01.421Z 2026-01-21T15:04:36.148Z
9195077 9195077 20260113001213_zlJ7V US0046 2026-01-14T14:11:53.822Z 2026-01-21T15:04:35.827Z
9190806 9190806 20260112100039_oun0f US0046 2026-01-13T14:23:32.057Z 2026-01-20T15:24:50.203Z
9190408 9190408 20260112085947_ZQ3DF US0046 2026-01-13T14:22:05.614Z 2026-01-20T15:24:21.303Z
9190346 9190346 20260112085059_a1dUn US0046 2026-01-13T14:21:51.473Z 2026-01-20T15:24:18.776Z
9190117 9190117 20260112075258_f7IW2 US0046 2026-01-13T14:20:46.433Z 2026-01-20T15:24:07.518Z
9190024 9190024 20260112073340_x9wJr US0046 2026-01-13T14:20:23.264Z 2026-01-20T15:24:03.500Z
9183796 9183796 20260111101618_57p12 US0046 2026-01-12T14:18:49.409Z 2026-01-19T15:20:12.050Z
9183781 9183781 20260111101427_mKkYB US0046 2026-01-12T14:18:47.768Z 2026-01-19T15:20:11.641Z
9183515 9183515 20260111093828_7jeUb US0046 2026-01-12T14:17:59.497Z 2026-01-19T15:19:42.692Z
9182979 9182979 20260111074726_1eP6A US0046 2026-01-12T14:16:21.573Z 2026-01-19T15:19:08.063Z
9171963 9171963 20260109054558_Vs6X2 US0046 2026-01-10T14:10:52.814Z 2026-01-17T15:24:45.287Z
9171810 9171810 20260109033430_kt3vJ US0046 2026-01-10T14:09:46.284Z 2026-01-17T15:24:35.058Z
9171794 9171794 20260109032740_Yn2iF US0046 2026-01-10T14:09:38.164Z 2026-01-17T15:24:34.233Z
9162361 9162361 20260107023007_q3THg US0046 2026-01-08T14:04:46.174Z 2026-01-13T15:02:04.328Z
9156230 9156230 20260104084840_zda1I US0046 2026-01-06T14:39:02.208Z 2026-01-12T15:11:45.957Z
9152162 9152162 20260105095108_ibKuT US0046 2026-01-06T14:16:04.285Z 2026-01-13T15:15:33.505Z
9140776 9140776 20260104003015_radWA US0046 2026-01-05T14:13:36.689Z 2026-01-12T15:04:30.307Z
9126806 9126806 20260102005353_oX3dD US0046 2026-01-03T14:06:50.243Z 2026-01-09T14:49:04.674Z
9124571 9124571 20251231112752_9vDGy US0046 2026-01-02T14:49:22.354Z 2026-01-08T15:13:15.312Z
9122683 9122683 20260101114447_7PCzX US0046 2026-01-02T14:14:30.029Z 2026-01-09T14:53:48.260Z
9122663 9122663 20260101112328_7bcJp US0046 2026-01-02T14:14:18.890Z 2026-01-09T14:53:40.596Z
9122523 9122523 20260101090338_QWqE1 US0046 2026-01-02T14:13:27.664Z 2026-01-09T14:53:31.242Z
9122521 9122521 20260101090334_a2Mrb US0046 2026-01-02T14:13:26.995Z 2026-01-09T14:53:31.057Z
9122512 9122512 20260101084412_3Olrs US0046 2026-01-02T14:13:24.746Z 2026-01-09T14:53:30.397Z
9122488 9122488 20260101073104_7dNh0 US0046 2026-01-02T14:13:17.156Z 2026-01-09T14:53:28.805Z
9122483 9122483 20260101071518_lN0eg US0046 2026-01-02T14:13:13.293Z 2026-01-09T14:53:28.451Z
9122463 9122463 20260101065151_lTUVc US0046 2026-01-02T14:13:05.619Z 2026-01-09T14:53:27.497Z
9117595 9117595 20251231112752_goSve US0046 2026-01-01T14:32:12.988Z 2026-01-01T14:57:55.588Z
9117512 9117512 20251231111453_oUamz US0046 2026-01-01T14:32:00.253Z 2026-01-08T15:13:11.300Z
9117135 9117135 20251231093000_SSxdv US0046 2026-01-01T14:30:19.194Z 2026-01-08T15:12:39.976Z
9117022 9117022 20251231084305_6Bp06 US0046 2026-01-01T14:29:54.560Z 2026-01-08T15:12:24.803Z
9116984 9116984 20251231081321_mmY8K US0046 2026-01-01T14:29:42.904Z 2026-01-08T15:12:20.673Z
9116879 9116879 20251231070456_UPh54 US0046 2026-01-01T14:29:12.301Z 2026-01-08T15:12:15.226Z
9116494 9116494 20251231061446_BIpqz US0046 2026-01-01T14:28:08.193Z 2026-01-08T15:11:50.434Z
9114332 9114332 20251231041252_EUJXt US0046 2026-01-01T14:22:09.920Z 2026-01-01T14:57:53.609Z
9111911 9111911 20251231015142_VfIHF US0046 2026-01-01T14:13:18.094Z 2026-01-08T15:07:08.992Z
9105594 9105594 20251230115237_lklbs US0046 2025-12-31T14:25:46.851Z 2026-01-07T15:10:54.552Z
9105588 9105588 20251230115126_aboTV US0046 2025-12-31T14:25:45.726Z 2026-01-07T15:10:53.258Z
9105209 9105209 20251230101009_B0EOp US0046 2025-12-31T14:24:14.022Z 2026-01-07T15:10:28.924Z
9102645 9102645 20251230032141_ggavC US0046 2025-12-31T14:14:45.505Z 2026-01-07T15:07:49.628Z
9101351 9101351 20251230000931_o6V2C US0046 2025-12-31T14:08:06.328Z 2026-01-07T15:06:15.326Z
9072738 9072738 20251225031708_yRFzE US0046 2025-12-29T14:55:22.931Z 2026-01-02T15:44:10.887Z
9033177 9033177 20251225104104_6CPXU US0046 2025-12-28T14:26:00.471Z 2026-01-02T15:46:22.072Z
9032911 9032911 20251225094505_nA5Dg US0046 2025-12-28T14:24:44.100Z 2026-01-02T15:45:55.542Z
9032846 9032846 20251225092125_TBDcs US0046 2025-12-28T14:24:25.274Z 2026-01-02T15:45:50.971Z

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