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

237 rows where station_code = "US005V" 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
9267600 9267600 20260127033156_tomoS US005V 2026-01-28T14:22:28.284Z 2026-01-29T14:35:21.214Z
9256392 9256392 20260124081402_Hi773 US005V 2026-01-25T14:16:54.803Z 2026-01-29T14:48:47.176Z
9252923 9252923 20260123081337_3aw3U US005V 2026-01-24T14:17:48.386Z 2026-01-29T14:53:42.483Z
9252863 9252863 20260123071644_kqHEZ US005V 2026-01-24T14:17:32.856Z 2026-01-29T14:53:38.427Z
9249943 9249943 20260123090824_oXHZt US005V 2026-01-24T14:00:15.074Z 2026-01-29T14:44:44.148Z
9245194 9245194 20260122110758_FMu6Q US005V 2026-01-23T14:00:58.626Z 2026-01-29T14:49:13.658Z
9243214 9243214 20260121035924_yiVgT US005V 2026-01-22T14:20:57.885Z 2026-01-29T15:04:51.203Z
9239176 9239176 20260121095705_RQbVl US005V 2026-01-22T14:00:16.613Z 2026-01-29T14:53:52.858Z
9215058 9215058 20260116090542_Ns24k US005V 2026-01-17T14:24:12.629Z 2026-01-24T15:14:28.233Z
9215056 9215056 20260116090351_yKTBI US005V 2026-01-17T14:24:11.998Z 2026-01-24T15:14:28.110Z
9214881 9214881 20260116083353_IjqmG US005V 2026-01-17T14:23:36.050Z 2026-01-24T15:14:11.223Z
9214758 9214758 20260116075702_3GqHZ US005V 2026-01-17T14:23:06.373Z 2026-01-24T15:14:04.342Z
9197284 9197284 20260113104149_u9tHk US005V 2026-01-14T14:22:14.375Z 2026-01-21T15:06:16.259Z
9196280 9196280 20260113055242_xew3Y US005V 2026-01-14T14:17:32.776Z 2026-01-21T15:05:30.814Z
9195736 9195736 20260113023600_CpVQX US005V 2026-01-14T14:14:40.937Z 2026-01-21T15:04:46.609Z
9189962 9189962 20260112071131_9WVSN US005V 2026-01-13T14:20:07.789Z 2026-01-20T15:23:49.723Z
9189886 9189886 20260112064448_HvVNI US005V 2026-01-13T14:19:46.291Z 2026-01-20T15:23:45.622Z
9189546 9189546 20260112050012_93ORk US005V 2026-01-13T14:18:09.134Z 2026-01-20T15:23:17.436Z
9168396 9168396 20260108105238_TmatK US005V 2026-01-09T14:11:00.428Z 2026-01-16T15:12:33.424Z
9132771 9132771 20260103102615_G3F1I US005V 2026-01-04T14:18:12.443Z 2026-01-10T15:01:57.981Z
9037684 9037684 20251224093634_ax4oX US005V 2025-12-28T14:37:44.480Z 2026-01-01T15:54:52.091Z
9036858 9036858 20251224053314_OgD1H US005V 2025-12-28T14:36:08.284Z 2026-01-01T15:54:41.122Z
9019028 9019028 20251220085342_1QAXx US005V 2025-12-27T15:03:00.382Z 2025-12-29T15:24:28.040Z
9018576 9018576 20251220071606_n2BbO US005V 2025-12-27T15:02:41.988Z 2025-12-29T15:23:48.492Z
9007628 9007628 20251221101335_vy2Lo US005V 2025-12-27T14:40:50.189Z 2025-12-27T14:40:50.189Z
9001984 9001984 20251222105918_4uDeK US005V 2025-12-27T14:23:43.766Z 2025-12-30T15:48:03.756Z
9001227 9001227 20251222095916_lnWi3 US005V 2025-12-27T14:21:23.680Z 2025-12-30T15:47:55.952Z
9001065 9001065 20251222094533_sblbK US005V 2025-12-27T14:21:13.896Z 2025-12-30T15:47:54.661Z
9000707 9000707 20251222091952_DqY2M US005V 2025-12-27T14:19:59.424Z 2025-12-30T15:47:50.935Z
9000697 9000697 20251222091854_29K0l US005V 2025-12-27T14:19:58.495Z 2025-12-30T15:47:50.789Z
9000294 9000294 20251222085432_WXnMY US005V 2025-12-27T14:19:03.820Z 2025-12-30T15:47:46.929Z
9000143 9000143 20251222084433_uPFHJ US005V 2025-12-27T14:18:34.174Z 2025-12-30T15:47:45.643Z
9000131 9000131 20251222084356_8bLXO US005V 2025-12-27T14:18:32.952Z 2025-12-28T15:00:16.746Z
8999869 8999869 20251222082622_Q9DFK US005V 2025-12-27T14:18:00.778Z 2025-12-30T15:47:42.987Z
8999715 8999715 20251222081106_LjWDY US005V 2025-12-27T14:17:40.022Z 2025-12-30T15:47:38.463Z
8999666 8999666 20251222080551_XS4Pr US005V 2025-12-27T14:17:22.818Z 2025-12-28T15:00:07.118Z
8999606 8999606 20251222075853_eYgI4 US005V 2025-12-27T14:17:14.604Z 2025-12-30T15:47:22.437Z
8999170 8999170 20251222070744_cLJhV US005V 2025-12-27T14:15:48.052Z 2025-12-30T15:46:55.337Z
8997620 8997620 20251222043501_dABbT US005V 2025-12-27T14:10:31.134Z 2025-12-30T15:46:38.643Z
8996784 8996784 20251222025609_B1WAo US005V 2025-12-27T14:06:27.392Z 2025-12-30T15:46:08.296Z
8988719 8988719 20251218104641_dPWOm US005V 2025-12-26T14:42:59.810Z 2025-12-27T15:22:02.044Z
8988447 8988447 20251218102305_vt9v2 US005V 2025-12-26T14:42:24.807Z 2025-12-27T15:21:46.618Z
8987664 8987664 20251218085807_J0wq0 US005V 2025-12-26T14:40:46.530Z 2025-12-27T15:20:49.254Z
8987630 8987630 20251218085519_E9drw US005V 2025-12-26T14:40:43.023Z 2025-12-27T15:20:48.556Z
8954074 8954074 20251217052909_NBQGL US005V 2025-12-25T14:09:05.064Z 2025-12-25T14:55:19.191Z
8825839 8825839 20251213023956_a5dyR US005V 2025-12-17T14:59:42.984Z 2025-12-21T14:17:37.166Z
8825694 8825694 20251213022438_RS2ZE US005V 2025-12-17T14:58:43.439Z 2025-12-21T14:17:36.527Z
8825631 8825631 20251213021253_IYSTt US005V 2025-12-17T14:58:28.517Z 2025-12-21T14:17:36.060Z
8825517 8825517 20251213015349_RHT6t US005V 2025-12-17T14:58:15.449Z 2025-12-21T14:17:35.344Z
8825344 8825344 20251213011936_21lt3 US005V 2025-12-17T14:57:00.772Z 2025-12-21T14:17:33.993Z
8824925 8824925 20251212234035_lm2C5 US005V 2025-12-17T14:54:30.679Z 2025-12-21T14:17:30.689Z
8811550 8811550 20251213070623_63qeD US005V 2025-12-17T14:16:52.473Z 2025-12-23T14:19:27.292Z
8810780 8810780 20251213062712_Ir4O2 US005V 2025-12-17T14:14:35.782Z 2025-12-23T14:19:22.343Z
8810661 8810661 20251213061916_09WX2 US005V 2025-12-17T14:14:02.584Z 2025-12-23T14:19:21.009Z
8810517 8810517 20251213061016_GsaSx US005V 2025-12-17T14:13:42.482Z 2025-12-23T14:19:19.376Z
8809935 8809935 20251213053603_AN4U8 US005V 2025-12-17T14:11:12.687Z 2025-12-23T14:18:34.904Z
8809601 8809601 20251213051300_gpdcR US005V 2025-12-17T14:09:38.059Z 2025-12-23T14:18:10.972Z
8809546 8809546 20251213050744_xW2Gl US005V 2025-12-17T14:09:27.267Z 2025-12-23T14:18:04.239Z
8808739 8808739 20251213040146_DX9Xe US005V 2025-12-17T14:04:15.822Z 2025-12-23T14:16:35.831Z
8808685 8808685 20251213035758_H5rpU US005V 2025-12-17T14:03:54.377Z 2025-12-23T14:16:30.041Z
8808581 8808581 20251213035021_chHkd US005V 2025-12-17T14:03:07.205Z 2025-12-23T14:16:24.869Z
8808420 8808420 20251213033146_25iUH US005V 2025-12-17T14:01:26.909Z 2025-12-23T14:16:21.394Z
8729359 8729359 20251212103413_5Js9V US005V 2025-12-13T14:17:26.856Z 2025-12-21T14:17:23.438Z
8728973 8728973 20251212094509_m4F29 US005V 2025-12-13T14:15:18.877Z 2025-12-21T14:17:23.053Z
8727757 8727757 20251212073637_8672E US005V 2025-12-13T14:09:36.407Z 2025-12-21T14:17:21.963Z
8727234 8727234 20251212063524_NbBvo US005V 2025-12-13T14:07:14.637Z 2025-12-21T14:17:21.576Z
8726094 8726094 20251212040321_GRDPA US005V 2025-12-13T14:01:51.134Z 2025-12-21T14:17:20.757Z
8720315 8720315 20251211045527_PTRIi US005V 2025-12-12T14:02:29.130Z 2025-12-20T14:21:59.565Z
8710392 8710392 20251209103931_JnzrT US005V 2025-12-10T14:04:50.619Z 2025-12-17T15:24:09.892Z
8710161 8710161 20251209100700_SxExL US005V 2025-12-10T14:04:12.808Z 2025-12-17T15:23:47.338Z
8710017 8710017 20251209093901_qQbqG US005V 2025-12-10T14:03:55.518Z 2025-12-17T15:23:20.020Z
8709621 8709621 20251209082441_VVRBH US005V 2025-12-10T14:02:54.774Z 2025-12-17T15:22:48.263Z
8683853 8683853 20251204090019_FAx2g US005V 2025-12-05T14:00:52.579Z 2025-12-13T16:03:00.786Z
8683730 8683730 20251204072521_9CyyR US005V 2025-12-05T14:00:22.758Z 2025-12-13T16:02:47.406Z
8677534 8677534 20251203103701_TeTwq US005V 2025-12-04T14:01:36.529Z 2025-12-11T14:39:48.407Z
8670852 8670852 20251201103238_0IAID US005V 2025-12-03T14:10:32.807Z 2025-12-10T14:36:54.557Z
8670412 8670412 20251201084440_Cm0xO US005V 2025-12-03T14:08:38.700Z 2025-12-10T14:36:36.320Z
8670396 8670396 20251201083353_huZxJ US005V 2025-12-03T14:08:31.644Z 2025-12-10T14:36:35.917Z
8670392 8670392 20251201082906_k25De US005V 2025-12-03T14:08:29.625Z 2025-12-10T14:36:35.635Z
8658736 8658736 20251201094826_7oKpZ US005V 2025-12-02T14:00:31.027Z 2025-12-10T14:36:42.233Z
8647343 8647343 20251129042424_X68Ut US005V 2025-11-30T14:28:00.956Z 2025-12-07T14:58:42.477Z
8646744 8646744 20251129024658_Ad97H US005V 2025-11-30T14:26:46.315Z 2025-12-07T14:58:18.689Z
8639126 8639126 20251129103041_xQ28Z US005V 2025-11-30T14:03:48.744Z 2025-12-08T14:50:24.610Z
8638893 8638893 20251129095948_KQEpP US005V 2025-11-30T14:02:48.920Z 2025-11-30T14:02:48.920Z
8638327 8638327 20251129082738_ZCsYl US005V 2025-11-30T14:00:32.103Z 2025-12-08T14:49:48.802Z
8636297 8636297 20251128033317_TgPeo US005V 2025-11-29T14:25:21.137Z 2025-12-06T15:03:04.289Z
8627216 8627216 20251128103853_tsVRq US005V 2025-11-29T14:03:00.939Z 2025-12-07T14:52:55.529Z
8626896 8626896 20251128095551_AjWOm US005V 2025-11-29T14:01:52.628Z 2025-12-07T14:52:47.297Z
8624118 8624118 20251127031212_0Qhxa US005V 2025-11-28T14:23:49.212Z 2025-12-05T15:04:45.760Z
8583139 8583139 20251124094221_nMR1T US005V 2025-11-25T14:00:25.062Z 2025-12-02T15:05:25.925Z
8582801 8582801 20251123083529_N32i8 US005V 2025-11-24T14:34:31.216Z 2025-12-01T15:22:28.072Z
8582706 8582706 20251123080255_KXW55 US005V 2025-11-24T14:34:25.993Z 2025-12-01T15:22:26.743Z
8582677 8582677 20251123075040_Nry9V US005V 2025-11-24T14:34:24.789Z 2025-12-01T15:22:26.445Z
8582565 8582565 20251123070626_sxp7S US005V 2025-11-24T14:34:04.375Z 2025-12-01T15:22:25.285Z
8582519 8582519 20251123065045_HMn91 US005V 2025-11-24T14:33:50.537Z 2025-12-01T15:22:24.769Z
8581272 8581272 20251122224521_iUvqS US005V 2025-11-24T14:31:23.470Z 2025-12-01T15:20:07.787Z
8554043 8554043 20251120065140_o9gIb US005V 2025-11-22T14:34:40.755Z 2025-11-28T14:58:44.744Z
8552944 8552944 20251120044241_O9U1G US005V 2025-11-22T14:33:13.188Z 2025-11-28T14:57:46.564Z
8541167 8541167 20251120020205_4hBAV US005V 2025-11-21T14:37:09.549Z 2025-11-28T14:56:39.455Z
8516435 8516435 20251118065110_4HXjU US005V 2025-11-19T14:41:28.478Z 2025-11-26T15:08:07.630Z

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