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

761 rows where station_code = "US006L" 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
9607322 9607322 20260404073430_Kfph1 US006L 2026-04-05T12:01:35.999Z 2026-04-06T12:16:14.410Z
9607289 9607289 20260404070611_j4iFs US006L 2026-04-05T12:01:25.812Z 2026-04-06T12:16:14.402Z
9607275 9607275 20260404065442_WcFh6 US006L 2026-04-05T12:01:23.157Z 2026-04-06T12:16:14.400Z
9607266 9607266 20260404062556_yTVyZ US006L 2026-04-05T12:01:19.784Z 2026-04-06T12:16:14.398Z
9607231 9607231 20260404055732_nOcwM US006L 2026-04-05T12:01:01.447Z 2026-04-06T12:16:14.389Z
9607165 9607165 20260404041034_5gV2j US006L 2026-04-05T12:00:39.822Z 2026-04-06T12:16:14.376Z
9607163 9607163 20260404041034_pIXzy US006L 2026-04-05T12:00:39.347Z 2026-04-06T12:16:14.375Z
9605709 9605709 20260403113257_An0mN US006L 2026-04-04T12:03:31.643Z 2026-04-06T12:18:13.971Z
9605698 9605698 20260403112936_IV0H1 US006L 2026-04-04T12:03:30.309Z 2026-04-06T12:18:13.570Z
9605683 9605683 20260403112800_NwLi3 US006L 2026-04-04T12:03:27.660Z 2026-04-06T12:18:12.520Z
9605681 9605681 20260403112738_moJNO US006L 2026-04-04T12:03:27.120Z 2026-04-06T12:18:12.274Z
9605611 9605611 20260403110217_zG2rM US006L 2026-04-04T12:03:03.830Z 2026-04-06T12:18:07.768Z
9605594 9605594 20260403105358_SiOpC US006L 2026-04-04T12:02:59.115Z 2026-04-06T12:18:06.718Z
9605592 9605592 20260403105352_3b1E2 US006L 2026-04-04T12:02:58.514Z 2026-04-06T12:18:06.551Z
9605559 9605559 20260403104158_tbXdJ US006L 2026-04-04T12:02:53.988Z 2026-04-06T12:18:04.779Z
9605515 9605515 20260403102917_9QNuz US006L 2026-04-04T12:02:42.812Z 2026-04-06T12:18:00.639Z
9605511 9605511 20260403102847_NMZ4z US006L 2026-04-04T12:02:39.469Z 2026-04-06T12:18:00.160Z
9605487 9605487 20260403101657_5iuj0 US006L 2026-04-04T12:02:31.863Z 2026-04-06T12:17:55.473Z
9605430 9605430 20260403095629_6fFEF US006L 2026-04-04T12:02:17.706Z 2026-04-06T12:17:49.576Z
9605339 9605339 20260403084912_8bga0 US006L 2026-04-04T12:01:50.864Z 2026-04-06T12:17:43.203Z
9605312 9605312 20260403083506_UFtic US006L 2026-04-04T12:01:45.003Z 2026-04-06T12:17:41.383Z
9605292 9605292 20260403082656_I1jkk US006L 2026-04-04T12:01:38.636Z 2026-04-06T12:17:40.223Z
9605274 9605274 20260403081831_B6lgc US006L 2026-04-04T12:01:30.433Z 2026-04-06T12:17:38.674Z
9605253 9605253 20260403081453_tjYt5 US006L 2026-04-04T12:01:26.271Z 2026-04-06T12:17:37.435Z
9605233 9605233 20260403080549_oPUIU US006L 2026-04-04T12:01:20.513Z 2026-04-06T12:17:34.267Z
9605105 9605105 20260403064348_z42ZZ US006L 2026-04-04T12:00:45.762Z 2026-04-06T12:16:38.708Z
9605017 9605017 20260403033524_jq52u US006L 2026-04-04T12:00:18.842Z 2026-04-06T12:16:18.469Z
9605003 9605003 20260403031703_3Ok33 US006L 2026-04-04T12:00:14.892Z 2026-04-06T12:16:17.358Z
9605001 9605001 20260403031514_jMm8M US006L 2026-04-04T12:00:14.298Z 2026-04-06T12:16:17.134Z
9603724 9603724 20260402115752_k6jN3 US006L 2026-04-03T12:04:18.352Z 2026-04-06T12:22:24.456Z
9603679 9603679 20260402114513_ws4UH US006L 2026-04-03T12:04:10.203Z 2026-04-06T12:22:21.912Z
9603638 9603638 20260402112955_IUDoS US006L 2026-04-03T12:03:53.066Z 2026-04-06T12:22:18.454Z
9603586 9603586 20260402110912_zDc3B US006L 2026-04-03T12:03:42.849Z 2026-04-06T12:22:14.646Z
9603523 9603523 20260402104627_4ogtB US006L 2026-04-03T12:03:19.679Z 2026-04-06T12:22:07.806Z
9603402 9603402 20260402100024_a6OwD US006L 2026-04-03T12:02:49.874Z 2026-04-06T12:21:58.024Z
9603309 9603309 20260402092757_A8bwF US006L 2026-04-03T12:02:34.462Z 2026-04-06T12:21:52.451Z
9603305 9603305 20260402092642_SEbph US006L 2026-04-03T12:02:33.452Z 2026-04-06T12:21:52.118Z
9603254 9603254 20260402090427_2sc2v US006L 2026-04-03T12:02:18.972Z 2026-04-06T12:21:49.300Z
9603234 9603234 20260402085829_Xe3Om US006L 2026-04-03T12:02:14.894Z 2026-04-06T12:21:48.418Z
9603224 9603224 20260402085051_9yg0C US006L 2026-04-03T12:02:11.165Z 2026-04-06T12:21:47.717Z
9603161 9603161 20260402081852_MqZgg US006L 2026-04-03T12:02:00.371Z 2026-04-06T12:21:40.549Z
9603039 9603039 20260402070814_qwJA7 US006L 2026-04-03T12:01:32.619Z 2026-04-06T12:21:29.539Z
9603016 9603016 20260402061718_3WbYn US006L 2026-04-03T12:01:30.148Z 2026-04-06T12:21:26.731Z
9603009 9603009 20260402061151_gBOV0 US006L 2026-04-03T12:01:29.002Z 2026-04-06T12:21:26.319Z
9599090 9599090 20260331113245_32RZo US006L 2026-04-01T12:02:19.704Z 2026-04-06T12:27:25.029Z
9599023 9599023 20260331104716_apMx4 US006L 2026-04-01T12:02:04.743Z 2026-04-06T12:27:20.653Z
9599000 9599000 20260331103008_flCrU US006L 2026-04-01T12:01:59.327Z 2026-04-06T12:27:19.026Z
9598991 9598991 20260331102426_EPzVJ US006L 2026-04-01T12:01:56.623Z 2026-04-06T12:27:14.237Z
9598986 9598986 20260331102203_hDk9a US006L 2026-04-01T12:01:55.173Z 2026-04-06T12:27:13.946Z
9598972 9598972 20260331100434_1YjtM US006L 2026-04-01T12:01:50.144Z 2026-04-06T12:27:12.860Z
9598963 9598963 20260331094803_0HWm8 US006L 2026-04-01T12:01:47.383Z 2026-04-06T12:27:12.200Z
9598930 9598930 20260331091520_HowG9 US006L 2026-04-01T12:01:37.970Z 2026-04-06T12:27:09.763Z
9598901 9598901 20260331084452_xYFDh US006L 2026-04-01T12:01:28.679Z 2026-04-06T12:27:05.464Z
9598864 9598864 20260331080756_XpVvn US006L 2026-04-01T12:01:20.786Z 2026-04-06T12:27:02.998Z
9598845 9598845 20260331074816_TwpIm US006L 2026-04-01T12:01:17.098Z 2026-04-06T12:27:02.007Z
9598680 9598680 20260331024614_qCIOo US006L 2026-04-01T12:00:30.561Z 2026-04-06T12:26:46.386Z
9596239 9596239 20260330115313_Ssnzf US006L 2026-03-31T12:03:48.933Z 2026-04-06T12:31:05.008Z
9596098 9596098 20260330111002_Ux6iE US006L 2026-03-31T12:03:27.268Z 2026-04-06T12:30:57.410Z
9593553 9593553 20260329114851_PscW8 US006L 2026-03-30T12:04:21.827Z 2026-04-06T12:35:25.778Z
9593528 9593528 20260329114355_WQbwX US006L 2026-03-30T12:04:16.790Z 2026-04-06T12:35:24.177Z
9593483 9593483 20260329111233_ugV5L US006L 2026-03-30T12:04:07.487Z 2026-04-06T12:35:21.369Z
9593476 9593476 20260329111108_WDOYj US006L 2026-03-30T12:04:06.058Z 2026-04-06T12:35:20.913Z
9593376 9593376 20260329095319_kHjcx US006L 2026-03-30T12:03:46.007Z 2026-04-06T12:35:15.088Z
9593357 9593357 20260329094134_aQBFU US006L 2026-03-30T12:03:42.820Z 2026-04-06T12:35:14.185Z
9593287 9593287 20260329085539_vNa3Q US006L 2026-03-30T12:03:30.027Z 2026-04-06T12:35:02.052Z
9593186 9593186 20260329074600_NCzV2 US006L 2026-03-30T12:03:14.171Z 2026-04-06T12:34:55.403Z
9593178 9593178 20260329073737_Q0r9M US006L 2026-03-30T12:03:12.560Z 2026-04-06T12:34:54.941Z
9593152 9593152 20260329065527_DtH6f US006L 2026-03-30T12:03:07.987Z 2026-04-06T12:34:53.507Z
9593130 9593130 20260329064930_r2lmG US006L 2026-03-30T12:03:02.804Z 2026-04-06T12:34:51.947Z
9593096 9593096 20260329055443_7Pw8J US006L 2026-03-30T12:02:55.944Z 2026-04-06T12:34:50.175Z
9592903 9592903 20260329035241_zQylY US006L 2026-03-30T12:02:16.703Z 2026-04-06T12:34:39.908Z
9592774 9592774 20260329032018_m3QQe US006L 2026-03-30T12:01:55.084Z 2026-04-06T12:34:27.982Z
9590957 9590957 20260328120529_CHHaf US006L 2026-03-29T12:03:32.867Z 2026-04-06T12:38:42.197Z
9590954 9590954 20260328120529_SyiGV US006L 2026-03-29T12:03:32.619Z 2026-04-06T12:38:42.074Z
9590939 9590939 20260328120216_OVuES US006L 2026-03-29T12:03:31.355Z 2026-04-06T12:38:41.378Z
9590916 9590916 20260328115246_ANQsR US006L 2026-03-29T12:03:29.508Z 2026-04-06T12:38:40.501Z
9590913 9590913 20260328115207_NK8h2 US006L 2026-03-29T12:03:29.239Z 2026-04-06T12:38:40.236Z
9590910 9590910 20260328115110_g2qFx US006L 2026-03-29T12:03:29.029Z 2026-04-06T12:38:40.151Z
9590887 9590887 20260328114419_TLz4j US006L 2026-03-29T12:03:26.635Z 2026-04-06T12:38:39.005Z
9590875 9590875 20260328113705_L2EmX US006L 2026-03-29T12:03:25.441Z 2026-04-06T12:38:38.327Z
9590842 9590842 20260328113134_wYKmt US006L 2026-03-29T12:03:22.426Z 2026-04-06T12:38:36.789Z
9590826 9590826 20260328112714_a8NNN US006L 2026-03-29T12:03:20.607Z 2026-04-06T12:38:35.968Z
9590795 9590795 20260328111612_Dqj2N US006L 2026-03-29T12:03:17.981Z 2026-04-06T12:38:34.851Z
9590775 9590775 20260328111303_p9DvM US006L 2026-03-29T12:03:16.838Z 2026-04-06T12:38:34.213Z
9590768 9590768 20260328111239_zFulE US006L 2026-03-29T12:03:16.029Z 2026-04-06T12:38:33.948Z
9590753 9590753 20260328110844_kSIPQ US006L 2026-03-29T12:03:13.227Z 2026-04-06T12:38:33.146Z
9590744 9590744 20260328110325_jwhUe US006L 2026-03-29T12:03:12.054Z 2026-04-06T12:38:32.372Z
9590732 9590732 20260328105803_LvJym US006L 2026-03-29T12:03:11.403Z 2026-04-06T12:38:31.940Z
9590691 9590691 20260328104326_0EJIO US006L 2026-03-29T12:03:07.166Z 2026-04-06T12:38:30.492Z
9590679 9590679 20260328104118_NI94H US006L 2026-03-29T12:03:06.530Z 2026-04-06T12:38:30.114Z
9590665 9590665 20260328103822_42HDe US006L 2026-03-29T12:03:05.737Z 2026-04-06T12:38:29.760Z
9590614 9590614 20260328102250_O7DQA US006L 2026-03-29T12:03:00.396Z 2026-04-06T12:38:27.171Z
9590572 9590572 20260328100614_YdUh3 US006L 2026-03-29T12:02:55.797Z 2026-04-06T12:38:24.681Z
9590562 9590562 20260328100321_tnaX3 US006L 2026-03-29T12:02:54.652Z 2026-04-06T12:38:24.154Z
9590558 9590558 20260328100256_U7T61 US006L 2026-03-29T12:02:54.439Z 2026-04-06T12:38:23.990Z
9590534 9590534 20260328095215_nH5gL US006L 2026-03-29T12:02:52.054Z 2026-04-06T12:38:22.826Z
9587308 9587308 20260327120202_JXcxu US006L 2026-03-28T12:05:14.694Z 2026-04-05T12:34:12.553Z
9587274 9587274 20260327115855_T3S8x US006L 2026-03-28T12:05:10.627Z 2026-04-05T12:34:11.009Z
9587268 9587268 20260327115745_TpuOL US006L 2026-03-28T12:05:09.903Z 2026-04-05T12:34:10.780Z
9587237 9587237 20260327115157_iZf0t US006L 2026-03-28T12:05:05.724Z 2026-04-05T12:34:09.665Z

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