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 = "US0006" 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
8688825 8688825 20251205125627_33ofg US0006 2025-12-06T14:05:55.575Z 2025-12-06T14:05:55.575Z
8688823 8688823 20251205125626_9L6sQ US0006 2025-12-06T14:05:54.909Z 2025-12-06T14:05:54.909Z
8688756 8688756 20251205123742_TerFk US0006 2025-12-06T14:05:40.917Z 2025-12-06T14:05:40.917Z
8688720 8688720 20251205122958_nvlvU US0006 2025-12-06T14:05:34.873Z 2025-12-06T14:05:34.873Z
8688591 8688591 20251205120705_HNxXZ US0006 2025-12-06T14:05:06.398Z 2025-12-06T14:05:06.398Z
8688586 8688586 20251205120641_1LIBf US0006 2025-12-06T14:05:05.467Z 2025-12-06T14:05:05.467Z
8688557 8688557 20251205120017_4NrwO US0006 2025-12-06T14:05:01.686Z 2025-12-06T14:05:01.686Z
8688512 8688512 20251205114843_SmdOW US0006 2025-12-06T14:04:46.114Z 2025-12-06T14:04:46.114Z
8688505 8688505 20251205114717_dA7e1 US0006 2025-12-06T14:04:45.459Z 2025-12-06T14:04:45.459Z
8688448 8688448 20251205113236_GBAGn US0006 2025-12-06T14:04:37.839Z 2025-12-06T14:04:37.839Z
8688445 8688445 20251205113111_2HZO2 US0006 2025-12-06T14:04:37.174Z 2025-12-06T14:04:37.174Z
8688331 8688331 20251205110652_s3eKp US0006 2025-12-06T14:04:07.392Z 2025-12-06T14:04:07.392Z
8688303 8688303 20251205110400_n1Aeb US0006 2025-12-06T14:04:03.013Z 2025-12-06T14:04:03.013Z
8688229 8688229 20251205104828_hXTft US0006 2025-12-06T14:03:44.011Z 2025-12-06T14:03:44.011Z
8688202 8688202 20251205104447_ETmLu US0006 2025-12-06T14:03:38.391Z 2025-12-06T14:03:38.391Z
8688171 8688171 20251205103932_5YM7x US0006 2025-12-06T14:03:32.395Z 2025-12-06T14:03:32.395Z
8688057 8688057 20251205100859_K457H US0006 2025-12-06T14:02:56.527Z 2025-12-06T14:02:56.527Z
8687950 8687950 20251205095015_jOPjL US0006 2025-12-06T14:02:30.338Z 2025-12-06T14:02:30.338Z
8687948 8687948 20251205094954_F0kCZ US0006 2025-12-06T14:02:29.771Z 2025-12-06T14:02:29.771Z
8687937 8687937 20251205094804_Et5nP US0006 2025-12-06T14:02:27.835Z 2025-12-06T14:02:27.835Z
8687893 8687893 20251205092949_q3EhN US0006 2025-12-06T14:02:13.010Z 2025-12-06T14:02:13.010Z
8687859 8687859 20251205092030_hwY3l US0006 2025-12-06T14:02:02.623Z 2025-12-06T14:02:02.623Z
8687806 8687806 20251205091224_DcVdi US0006 2025-12-06T14:01:53.991Z 2025-12-06T14:01:53.991Z
8687799 8687799 20251205090824_srwQK US0006 2025-12-06T14:01:51.593Z 2025-12-06T14:01:51.593Z
8687742 8687742 20251205084801_EogKz US0006 2025-12-06T14:01:35.147Z 2025-12-06T14:01:35.147Z
8687715 8687715 20251205083955_u33rw US0006 2025-12-06T14:01:29.879Z 2025-12-06T14:01:29.879Z
8687682 8687682 20251205082725_1cZnL US0006 2025-12-06T14:01:22.176Z 2025-12-06T14:01:22.176Z
8687661 8687661 20251205081854_FiRgh US0006 2025-12-06T14:01:17.716Z 2025-12-06T14:01:17.716Z
8687657 8687657 20251205081759_fLw0Z US0006 2025-12-06T14:01:15.292Z 2025-12-06T14:01:15.292Z
8687652 8687652 20251205081634_tbKg5 US0006 2025-12-06T14:01:10.866Z 2025-12-06T14:01:10.866Z
8687649 8687649 20251205081542_BYAfl US0006 2025-12-06T14:01:10.138Z 2025-12-06T14:01:10.138Z
8687611 8687611 20251205080357_j232E US0006 2025-12-06T14:01:00.558Z 2025-12-06T14:01:00.558Z
8687558 8687558 20251205072948_D3uSW US0006 2025-12-06T14:00:45.781Z 2025-12-06T14:00:45.781Z
8684441 8684441 20251204123851_Eix6m US0006 2025-12-05T14:03:20.867Z 2025-12-06T14:18:00.512Z
8682176 8682176 20251203045647_uZSUw US0006 2025-12-04T14:16:33.707Z 2025-12-06T14:28:49.014Z
8681252 8681252 20251203025021_mpM8f US0006 2025-12-04T14:14:10.794Z 2025-12-06T14:27:58.229Z
8677073 8677073 20251202064423_CAqEn US0006 2025-12-03T14:26:16.513Z 2025-12-06T14:35:34.180Z
8676767 8676767 20251202062307_fSu1L US0006 2025-12-03T14:25:33.770Z 2025-12-06T14:35:28.451Z
8676720 8676720 20251202061830_6oOzc US0006 2025-12-03T14:25:28.288Z 2025-12-06T14:35:27.605Z
8675844 8675844 20251202051851_C8Aaq US0006 2025-12-03T14:24:25.898Z 2025-12-06T14:35:03.297Z
8675704 8675704 20251202051032_vsYYX US0006 2025-12-03T14:24:11.509Z 2025-12-06T14:34:59.012Z
8675490 8675490 20251202044950_qtgsh US0006 2025-12-03T14:23:46.929Z 2025-12-06T14:34:54.599Z
8674984 8674984 20251202034525_TT4lI US0006 2025-12-03T14:22:48.013Z 2025-12-06T14:34:26.490Z
8674453 8674453 20251202022611_nnR6H US0006 2025-12-03T14:21:39.667Z 2025-12-06T14:34:09.502Z
8674001 8674001 20251202010351_HxDJc US0006 2025-12-03T14:20:43.057Z 2025-12-06T14:33:44.626Z
8669929 8669929 20251202122929_YzjRi US0006 2025-12-03T14:06:04.531Z 2025-12-06T14:24:27.673Z
8669910 8669910 20251202122609_2RFBC US0006 2025-12-03T14:06:01.272Z 2025-12-06T14:24:26.801Z
8669802 8669802 20251202121258_5eZcg US0006 2025-12-03T14:05:32.473Z 2025-12-06T14:24:21.382Z
8669775 8669775 20251202121018_jywCJ US0006 2025-12-03T14:05:25.569Z 2025-12-06T14:24:20.068Z
8669527 8669527 20251202112707_nVc0d US0006 2025-12-03T14:04:19.761Z 2025-12-06T14:23:59.738Z
8669354 8669354 20251202105918_S4VF2 US0006 2025-12-03T14:03:27.289Z 2025-12-06T14:23:50.405Z
8669336 8669336 20251202105548_KQMlr US0006 2025-12-03T14:03:24.428Z 2025-12-06T14:23:49.714Z
8669313 8669313 20251202105245_bsHM9 US0006 2025-12-03T14:03:21.205Z 2025-12-06T14:23:48.888Z
8669280 8669280 20251202104532_aDrMw US0006 2025-12-03T14:03:16.094Z 2025-12-06T14:23:47.367Z
8669204 8669204 20251202103157_TfqZZ US0006 2025-12-03T14:02:51.760Z 2025-12-06T14:23:40.102Z
8669178 8669178 20251202102924_G6VBI US0006 2025-12-03T14:02:48.302Z 2025-12-06T14:23:39.141Z
8669171 8669171 20251202102910_2qncN US0006 2025-12-03T14:02:47.796Z 2025-12-06T14:23:38.978Z
8668901 8668901 20251202092007_HSiPy US0006 2025-12-03T14:01:33.969Z 2025-12-06T14:23:20.777Z
8668890 8668890 20251202091808_Xu9LF US0006 2025-12-03T14:01:32.703Z 2025-12-06T14:23:19.724Z
8668822 8668822 20251202090827_oJuhu US0006 2025-12-03T14:01:23.915Z 2025-12-06T14:23:13.094Z
8668797 8668797 20251202090130_NgKpG US0006 2025-12-03T14:01:20.238Z 2025-12-06T14:23:10.340Z
8668719 8668719 20251202084046_Lmq4W US0006 2025-12-03T14:00:56.489Z 2025-12-06T14:23:06.734Z
8668665 8668665 20251202081315_qNub4 US0006 2025-12-03T14:00:46.643Z 2025-12-06T14:23:01.862Z
8668586 8668586 20251202074958_uUcAx US0006 2025-12-03T14:00:30.174Z 2025-12-06T14:22:56.254Z
8668580 8668580 20251202074711_Q180s US0006 2025-12-03T14:00:29.733Z 2025-12-06T14:22:56.135Z
8668514 8668514 20251202072257_ptcEt US0006 2025-12-03T14:00:12.088Z 2025-12-06T14:22:46.535Z
8668200 8668200 20251130063837_omSXi US0006 2025-12-02T14:42:10.898Z 2025-12-06T14:50:26.566Z
8668134 8668134 20251130061438_gkDbA US0006 2025-12-02T14:42:04.024Z 2025-12-06T14:50:23.549Z
8668087 8668087 20251130060027_gaaEt US0006 2025-12-02T14:42:00.165Z 2025-12-06T14:50:21.186Z
8667973 8667973 20251130053331_yZhYC US0006 2025-12-02T14:41:25.831Z 2025-12-06T14:49:45.686Z
8667892 8667892 20251130050010_U3vI9 US0006 2025-12-02T14:41:13.709Z 2025-12-06T14:49:36.559Z
8667845 8667845 20251130043741_rSfr7 US0006 2025-12-02T14:40:38.139Z 2025-12-06T14:49:30.873Z
8667811 8667811 20251130041143_zRxIl US0006 2025-12-02T14:40:27.870Z 2025-12-06T14:49:26.549Z
8667783 8667783 20251130040200_MiAjC US0006 2025-12-02T14:40:22.300Z 2025-12-06T14:49:15.900Z
8667668 8667668 20251130031436_S7fPz US0006 2025-12-02T14:39:40.128Z 2025-12-06T14:48:41.918Z
8667619 8667619 20251130025010_XOFuK US0006 2025-12-02T14:39:27.777Z 2025-12-06T14:48:35.439Z
8667612 8667612 20251130024939_5SBAM US0006 2025-12-02T14:39:27.450Z 2025-12-06T14:48:35.226Z
8667603 8667603 20251130024434_wInnE US0006 2025-12-02T14:39:24.568Z 2025-12-06T14:48:33.665Z
8667573 8667573 20251130021828_pO8Nd US0006 2025-12-02T14:38:56.003Z 2025-12-06T14:48:02.714Z
8667532 8667532 20251130020604_sXHuR US0006 2025-12-02T14:38:48.466Z 2025-12-06T14:47:53.455Z
8660510 8660510 20251130130102_zR9As US0006 2025-12-02T14:08:11.651Z 2025-12-06T14:37:18.110Z
8660474 8660474 20251130125745_aogAR US0006 2025-12-02T14:07:58.897Z 2025-12-06T14:37:16.967Z
8660461 8660461 20251130125422_F7Qvj US0006 2025-12-02T14:07:55.662Z 2025-12-06T14:37:16.534Z
8660363 8660363 20251130123942_waWqS US0006 2025-12-02T14:07:34.040Z 2025-12-06T14:37:05.196Z
8660323 8660323 20251130122824_7QxI4 US0006 2025-12-02T14:07:22.929Z 2025-12-06T14:37:00.148Z
8660301 8660301 20251130122642_hIYQX US0006 2025-12-02T14:07:18.510Z 2025-12-06T14:36:59.581Z
8660264 8660264 20251130121642_6yN8A US0006 2025-12-02T14:07:09.185Z 2025-12-06T14:36:58.376Z
8660048 8660048 20251130114831_auEnP US0006 2025-12-02T14:06:22.038Z 2025-12-06T14:36:51.312Z
8660019 8660019 20251130114306_NjgN5 US0006 2025-12-02T14:06:14.732Z 2025-12-06T14:36:50.232Z
8659951 8659951 20251130113258_Saptm US0006 2025-12-02T14:05:54.471Z 2025-12-06T14:36:48.283Z
8659931 8659931 20251130113116_oJRJc US0006 2025-12-02T14:05:51.458Z 2025-12-06T14:36:47.659Z
8659853 8659853 20251130112315_59fWO US0006 2025-12-02T14:05:37.321Z 2025-12-06T14:36:44.642Z
8659796 8659796 20251130111637_yEQ1x US0006 2025-12-02T14:05:20.726Z 2025-12-06T14:36:42.279Z
8659765 8659765 20251130111337_f9JB4 US0006 2025-12-02T14:05:15.903Z 2025-12-06T14:36:41.743Z
8659758 8659758 20251130111330_RADC7 US0006 2025-12-02T14:05:15.287Z 2025-12-06T14:36:41.639Z
8659752 8659752 20251130111248_Cfe6J US0006 2025-12-02T14:05:14.083Z 2025-12-06T14:36:41.457Z
8659744 8659744 20251130111146_yUVow US0006 2025-12-02T14:05:12.764Z 2025-12-06T14:36:41.296Z
8659647 8659647 20251130110118_VPqIR US0006 2025-12-02T14:04:44.992Z 2025-12-06T14:36:26.585Z
8659514 8659514 20251130104004_HebfR US0006 2025-12-02T14:04:16.206Z 2025-12-06T14:36:22.533Z
8659384 8659384 20251130101827_G9VFY US0006 2025-12-02T14:03:46.372Z 2025-12-06T14:36:16.952Z

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