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

6,748 rows where station_code = "US003T" 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
8691424 8691424 20251205052625_QhIw0 US003T 2025-12-06T14:17:43.461Z 2025-12-06T14:18:01.110Z
8688847 8688847 20251205130020_EyBWJ US003T 2025-12-06T14:06:05.707Z 2025-12-06T14:06:05.707Z
8688827 8688827 20251205125627_33ofg US003T 2025-12-06T14:05:55.575Z 2025-12-06T14:05:55.575Z
8688824 8688824 20251205125626_9L6sQ US003T 2025-12-06T14:05:54.909Z 2025-12-06T14:05:54.909Z
8688446 8688446 20251205113111_2HZO2 US003T 2025-12-06T14:04:37.174Z 2025-12-06T14:04:37.174Z
8688059 8688059 20251205100859_K457H US003T 2025-12-06T14:02:56.527Z 2025-12-06T14:02:56.527Z
8687952 8687952 20251205095015_jOPjL US003T 2025-12-06T14:02:30.338Z 2025-12-06T14:02:30.338Z
8687894 8687894 20251205092949_q3EhN US003T 2025-12-06T14:02:13.010Z 2025-12-06T14:02:13.010Z
8687810 8687810 20251205091224_DcVdi US003T 2025-12-06T14:01:53.991Z 2025-12-06T14:01:53.991Z
8687744 8687744 20251205084801_EogKz US003T 2025-12-06T14:01:35.147Z 2025-12-06T14:01:35.147Z
8687718 8687718 20251205084244_5fFx0 US003T 2025-12-06T14:01:30.531Z 2025-12-06T14:01:30.531Z
8687658 8687658 20251205081759_fLw0Z US003T 2025-12-06T14:01:15.292Z 2025-12-06T14:01:15.292Z
8687612 8687612 20251205080357_j232E US003T 2025-12-06T14:01:00.558Z 2025-12-06T14:01:00.558Z
8687559 8687559 20251205072948_D3uSW US003T 2025-12-06T14:00:45.781Z 2025-12-06T14:00:45.781Z
8682180 8682180 20251203045647_uZSUw US003T 2025-12-04T14:16:33.741Z 2025-12-06T14:28:49.014Z
8677140 8677140 20251202070214_dAK1T US003T 2025-12-03T14:26:21.355Z 2025-12-06T14:35:36.706Z
8676722 8676722 20251202061830_6oOzc US003T 2025-12-03T14:25:28.288Z 2025-12-06T14:35:27.605Z
8676705 8676705 20251202061458_3Bty2 US003T 2025-12-03T14:25:26.843Z 2025-12-06T14:35:27.207Z
8676512 8676512 20251202055734_oeL0x US003T 2025-12-03T14:25:15.828Z 2025-12-06T14:35:22.709Z
8675997 8675997 20251202053021_YWt0U US003T 2025-12-03T14:24:35.362Z 2025-12-06T14:35:06.357Z
8675839 8675839 20251202051745_SC1b1 US003T 2025-12-03T14:24:25.249Z 2025-12-06T14:35:01.849Z
8675423 8675423 20251202043723_hCJvy US003T 2025-12-03T14:23:42.102Z 2025-12-06T14:34:52.281Z
8669685 8669685 20251202115722_flD7i US003T 2025-12-03T14:05:08.262Z 2025-12-06T14:24:14.935Z
8669345 8669345 20251202105629_j30Co US003T 2025-12-03T14:03:25.875Z 2025-12-06T14:23:50.116Z
8669283 8669283 20251202104532_aDrMw US003T 2025-12-03T14:03:16.094Z 2025-12-06T14:23:47.367Z
8669208 8669208 20251202103157_TfqZZ US003T 2025-12-03T14:02:51.760Z 2025-12-06T14:23:40.102Z
8669176 8669176 20251202102910_2qncN US003T 2025-12-03T14:02:47.796Z 2025-12-06T14:23:38.978Z
8668906 8668906 20251202092007_HSiPy US003T 2025-12-03T14:01:33.969Z 2025-12-06T14:23:20.777Z
8668786 8668786 20251202085954_ZEfkd US003T 2025-12-03T14:01:14.453Z 2025-12-06T14:23:09.937Z
8668723 8668723 20251202084046_Lmq4W US003T 2025-12-03T14:00:56.489Z 2025-12-06T14:23:06.734Z
8668690 8668690 20251202082402_GoxQD US003T 2025-12-03T14:00:51.633Z 2025-12-06T14:23:04.497Z
8668688 8668688 20251202082306_HGyKg US003T 2025-12-03T14:00:51.147Z 2025-12-06T14:23:04.249Z
8668667 8668667 20251202081315_qNub4 US003T 2025-12-03T14:00:46.643Z 2025-12-06T14:23:01.862Z
8668584 8668584 20251202074711_Q180s US003T 2025-12-03T14:00:29.733Z 2025-12-06T14:22:56.135Z
8668422 8668422 20251129025448_oCYuJ US003T 2025-12-02T14:48:06.615Z 2025-12-06T14:56:25.237Z
8668201 8668201 20251130063837_omSXi US003T 2025-12-02T14:42:10.898Z 2025-12-06T14:50:26.566Z
8668076 8668076 20251130055531_qohP4 US003T 2025-12-02T14:41:58.379Z 2025-12-06T14:50:16.263Z
8667849 8667849 20251130043741_rSfr7 US003T 2025-12-02T14:40:38.139Z 2025-12-06T14:49:30.873Z
8667784 8667784 20251130040200_MiAjC US003T 2025-12-02T14:40:22.301Z 2025-12-06T14:49:15.900Z
8667653 8667653 20251130030918_2zzdH US003T 2025-12-02T14:39:37.222Z 2025-12-06T14:48:40.411Z
8667381 8667381 20251130004057_0bcrs US003T 2025-12-02T14:37:35.368Z 2025-12-06T14:46:57.803Z
8666937 8666937 20251129090806_IjErw US003T 2025-12-02T14:31:47.691Z 2025-12-06T14:42:54.921Z
8666855 8666855 20251201052834_Twbqh US003T 2025-12-02T14:30:17.988Z 2025-12-06T14:42:20.369Z
8666804 8666804 20251201034103_h808D US003T 2025-12-02T14:27:57.366Z 2025-12-06T14:41:41.336Z
8660514 8660514 20251130130102_zR9As US003T 2025-12-02T14:08:11.651Z 2025-12-06T14:37:18.110Z
8660364 8660364 20251130123942_waWqS US003T 2025-12-02T14:07:34.040Z 2025-12-06T14:37:05.196Z
8660362 8660362 20251130123919_tiJFC US003T 2025-12-02T14:07:33.409Z 2025-12-06T14:37:03.001Z
8660324 8660324 20251130122824_7QxI4 US003T 2025-12-02T14:07:22.930Z 2025-12-06T14:37:00.148Z
8660268 8660268 20251130121642_6yN8A US003T 2025-12-02T14:07:09.185Z 2025-12-06T14:36:58.376Z
8660052 8660052 20251130114831_auEnP US003T 2025-12-02T14:06:22.038Z 2025-12-06T14:36:51.312Z
8659935 8659935 20251130113116_oJRJc US003T 2025-12-02T14:05:51.458Z 2025-12-06T14:36:47.659Z
8659878 8659878 20251130112506_ipQ3Y US003T 2025-12-02T14:05:40.976Z 2025-12-06T14:36:45.636Z
8659753 8659753 20251130111248_Cfe6J US003T 2025-12-02T14:05:14.083Z 2025-12-06T14:36:41.457Z
8659748 8659748 20251130111146_yUVow US003T 2025-12-02T14:05:12.765Z 2025-12-06T14:36:41.296Z
8659516 8659516 20251130104004_HebfR US003T 2025-12-02T14:04:16.206Z 2025-12-06T14:36:22.533Z
8658884 8658884 20251130084916_Sb0aO US003T 2025-12-02T14:01:23.308Z 2025-12-06T14:35:44.737Z
8658858 8658858 20251130084105_2VDvR US003T 2025-12-02T14:01:14.536Z 2025-12-06T14:35:43.687Z
8658834 8658834 20251130083052_YzS74 US003T 2025-12-02T14:01:04.711Z 2025-12-06T14:35:42.689Z
8648324 8648324 20251129073124_127cK US003T 2025-11-30T14:30:03.935Z 2025-12-06T14:57:32.075Z
8648289 8648289 20251129072017_3U3ql US003T 2025-11-30T14:30:02.075Z 2025-12-06T14:57:31.110Z
8648247 8648247 20251129071237_xlYuY US003T 2025-11-30T14:29:59.388Z 2025-12-06T14:57:27.129Z
8648182 8648182 20251129065208_XIv7X US003T 2025-11-30T14:29:51.538Z 2025-12-06T14:57:17.804Z
8647165 8647165 20251129035452_pTktI US003T 2025-11-30T14:27:46.684Z 2025-12-06T14:56:33.125Z
8639962 8639962 20251129123037_u7Bs0 US003T 2025-11-30T14:06:45.273Z 2025-11-30T14:06:45.273Z
8639888 8639888 20251129122004_tbPVN US003T 2025-11-30T14:06:21.589Z 2025-11-30T14:06:21.589Z
8639590 8639590 20251129112605_XAiAq US003T 2025-11-30T14:05:26.731Z 2025-11-30T14:05:26.731Z
8639560 8639560 20251129112328_RQz5S US003T 2025-11-30T14:05:18.743Z 2025-12-06T14:43:44.692Z
8639470 8639470 20251129110928_Rx9Gd US003T 2025-11-30T14:05:05.994Z 2025-11-30T14:05:05.994Z
8639366 8639366 20251129105900_9i3Lk US003T 2025-11-30T14:04:41.792Z 2025-11-30T14:04:41.792Z
8639276 8639276 20251129105029_gtb7R US003T 2025-11-30T14:04:20.106Z 2025-12-06T14:43:37.694Z
8639229 8639229 20251129104450_8cCZ6 US003T 2025-11-30T14:04:11.579Z 2025-12-06T14:43:36.662Z
8638991 8638991 20251129101441_MTe3k US003T 2025-11-30T14:03:18.215Z 2025-12-06T14:43:07.522Z
8638939 8638939 20251129100548_qGOJx US003T 2025-11-30T14:03:02.860Z 2025-11-30T14:03:02.860Z
8638733 8638733 20251129093432_YxHK3 US003T 2025-11-30T14:02:01.218Z 2025-12-06T14:42:59.560Z
8638275 8638275 20251129081736_xwD1t US003T 2025-11-30T14:00:20.154Z 2025-12-06T14:42:46.531Z
8638268 8638268 20251129081353_5hozL US003T 2025-11-30T14:00:18.183Z 2025-12-06T14:42:46.303Z
8637953 8637953 20251128073703_HHjwj US003T 2025-11-29T14:28:19.465Z 2025-12-06T15:04:06.039Z
8637743 8637743 20251128062846_anw1f US003T 2025-11-29T14:27:47.349Z 2025-12-06T15:04:03.729Z
8637670 8637670 20251128060828_lrjbJ US003T 2025-11-29T14:27:41.683Z 2025-12-06T15:04:02.423Z
8636514 8636514 20251128035453_ZqAT8 US003T 2025-11-29T14:25:36.311Z 2025-12-06T15:03:22.990Z
8627949 8627949 20251128115624_3dR2Y US003T 2025-11-29T14:04:59.384Z 2025-12-06T14:51:28.437Z
8625984 8625984 20251126065035_YXZIi US003T 2025-11-28T14:37:28.541Z 2025-12-04T15:11:49.236Z
8625166 8625166 20251127081847_JMNmn US003T 2025-11-28T14:26:19.792Z 2025-12-05T15:05:45.906Z
8625083 8625083 20251127075925_XCLg0 US003T 2025-11-28T14:26:13.138Z 2025-12-05T15:05:41.665Z
8625048 8625048 20251127074354_Cusvl US003T 2025-11-28T14:26:10.569Z 2025-12-05T15:05:40.961Z
8624803 8624803 20251127064032_ov800 US003T 2025-11-28T14:25:30.933Z 2025-12-05T15:05:28.578Z
8624772 8624772 20251127063011_IkYVd US003T 2025-11-28T14:25:28.642Z 2025-12-05T15:05:27.981Z
8624708 8624708 20251127060904_xzJ6D US003T 2025-11-28T14:25:21.672Z 2025-12-05T15:05:24.149Z
8620528 8620528 20251126125240_pfpe0 US003T 2025-11-28T14:13:08.169Z 2025-12-05T15:02:11.695Z
8619342 8619342 20251126095420_h2wA3 US003T 2025-11-28T14:08:27.389Z 2025-12-05T15:00:56.609Z
8618552 8618552 20251127123620_H8839 US003T 2025-11-28T14:04:55.893Z 2025-12-06T14:58:47.109Z
8618403 8618403 20251127121314_C9gEL US003T 2025-11-28T14:04:25.739Z 2025-12-06T14:58:44.416Z
8618390 8618390 20251127121059_O0ahs US003T 2025-11-28T14:04:23.647Z 2025-12-06T14:58:44.096Z
8618319 8618319 20251127120032_xgtQM US003T 2025-11-28T14:04:14.345Z 2025-12-06T14:58:43.284Z
8618257 8618257 20251127115226_2f0Ei US003T 2025-11-28T14:03:58.087Z 2025-12-06T14:58:42.025Z
8618165 8618165 20251127114139_8u4du US003T 2025-11-28T14:03:43.252Z 2025-12-06T14:58:40.882Z
8617923 8617923 20251127105419_RY37U US003T 2025-11-28T14:02:48.635Z 2025-12-06T14:58:26.854Z
8617910 8617910 20251127105129_wM3tn US003T 2025-11-28T14:02:46.862Z 2025-12-06T14:58:26.653Z
8617901 8617901 20251127104952_CgY2O US003T 2025-11-28T14:02:45.528Z 2025-12-06T14:58:26.479Z
8617688 8617688 20251127101553_zpTj8 US003T 2025-11-28T14:01:58.849Z 2025-12-06T14:58:19.488Z

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