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

4,498 rows where station_code = "US005D" 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
9605820 9605820 20260403121031_pTgul US005D 2026-04-04T12:04:02.443Z 2026-04-06T12:18:26.122Z
9605796 9605796 20260403120648_r372f US005D 2026-04-04T12:03:57.606Z 2026-04-06T12:18:23.438Z
9605671 9605671 20260403112437_pLNSN US005D 2026-04-04T12:03:24.180Z 2026-04-06T12:18:11.539Z
9605040 9605040 20260403045001_ipbdI US005D 2026-04-04T12:00:26.435Z 2026-04-06T12:16:24.156Z
9596338 9596338 20260330121956_V2o16 US005D 2026-03-31T12:04:03.694Z 2026-04-06T12:31:09.913Z
9596243 9596243 20260330115609_uc9p3 US005D 2026-03-31T12:03:49.650Z 2026-04-06T12:31:05.297Z
9590088 9590088 20260328050447_3pocZ US005D 2026-03-29T12:01:58.918Z 2026-04-06T12:37:50.082Z
9587166 9587166 20260327113031_MUQBH US005D 2026-03-28T12:04:55.647Z 2026-04-05T12:34:04.938Z
9587108 9587108 20260327111434_NYCTS US005D 2026-03-28T12:04:46.886Z 2026-04-05T12:34:01.928Z
9587049 9587049 20260327105753_xoUlo US005D 2026-03-28T12:04:41.228Z 2026-04-05T12:34:00.162Z
9586844 9586844 20260327095643_EWptG US005D 2026-03-28T12:04:13.044Z 2026-04-05T12:33:51.603Z
9586702 9586702 20260327091519_ROQ24 US005D 2026-03-28T12:03:47.987Z 2026-04-05T12:33:38.273Z
9586394 9586394 20260327070625_Oe6kB US005D 2026-03-28T12:02:58.672Z 2026-04-05T12:33:23.387Z
9583285 9583285 20260326120855_he4e1 US005D 2026-03-27T12:08:17.327Z 2026-04-04T12:41:00.408Z
9583244 9583244 20260326115102_mGki5 US005D 2026-03-27T12:08:10.244Z 2026-04-04T12:40:58.052Z
9582657 9582657 20260326085643_WQuOW US005D 2026-03-27T12:06:28.054Z 2026-04-04T12:40:17.659Z
9582485 9582485 20260326075729_gNIF2 US005D 2026-03-27T12:05:56.869Z 2026-04-04T12:40:03.963Z
9582398 9582398 20260326071744_IVCoM US005D 2026-03-27T12:05:39.598Z 2026-04-04T12:39:59.425Z
9582366 9582366 20260326070533_B8wYF US005D 2026-03-27T12:05:33.385Z 2026-04-04T12:39:58.050Z
9578452 9578452 20260325115327_dmOfd US005D 2026-03-26T12:07:40.545Z 2026-04-03T12:38:04.089Z
9578421 9578421 20260325114832_UXjp9 US005D 2026-03-26T12:07:35.287Z 2026-04-03T12:38:02.952Z
9578259 9578259 20260325110117_JYTKm US005D 2026-03-26T12:07:09.534Z 2026-04-03T12:37:45.539Z
9578224 9578224 20260325104845_O8KUe US005D 2026-03-26T12:07:03.115Z 2026-04-03T12:37:43.772Z
9578164 9578164 20260325103702_9SQHd US005D 2026-03-26T12:06:53.040Z 2026-04-03T12:37:41.766Z
9578155 9578155 20260325103200_rgUy6 US005D 2026-03-26T12:06:51.683Z 2026-04-03T12:37:41.487Z
9578041 9578041 20260325093853_1JCt4 US005D 2026-03-26T12:06:37.222Z 2026-04-03T12:37:34.638Z
9577783 9577783 20260325083623_WoNJy US005D 2026-03-26T12:06:04.619Z 2026-04-03T12:37:26.931Z
9577664 9577664 20260325080254_4Dbv2 US005D 2026-03-26T12:05:48.021Z 2026-04-03T12:37:12.771Z
9577634 9577634 20260325075408_G2JLW US005D 2026-03-26T12:05:41.534Z 2026-04-03T12:37:11.454Z
9577604 9577604 20260325074243_1m2VZ US005D 2026-03-26T12:05:37.064Z 2026-04-03T12:37:10.196Z
9577419 9577419 20260325060218_VK98T US005D 2026-03-26T12:05:05.627Z 2026-04-03T12:37:00.933Z
9573510 9573510 20260324123340_jQbli US005D 2026-03-25T12:08:11.441Z 2026-04-02T12:36:12.147Z
9573483 9573483 20260324122029_Nk6G1 US005D 2026-03-25T12:08:06.973Z 2026-04-02T12:36:10.984Z
9573460 9573460 20260324121540_SMi1S US005D 2026-03-25T12:08:03.903Z 2026-04-02T12:36:10.222Z
9573455 9573455 20260324121151_2K5q4 US005D 2026-03-25T12:08:02.922Z 2026-04-02T12:36:09.863Z
9573194 9573194 20260324113217_U4MqM US005D 2026-03-25T12:07:23.473Z 2026-04-02T12:35:59.355Z
9572934 9572934 20260324105748_tMlZO US005D 2026-03-25T12:06:46.377Z 2026-04-02T12:35:44.201Z
9572923 9572923 20260324105131_awhNK US005D 2026-03-25T12:06:43.746Z 2026-04-02T12:35:43.646Z
9572662 9572662 20260324094453_ojo6v US005D 2026-03-25T12:05:53.299Z 2026-04-02T12:35:33.222Z
9572100 9572100 20260324073518_8yBUy US005D 2026-03-25T12:03:49.241Z 2026-04-02T12:35:03.394Z
9572001 9572001 20260324065541_1j15W US005D 2026-03-25T12:03:28.203Z 2026-04-02T12:34:58.789Z
9565761 9565761 20260323123937_WCJhN US005D 2026-03-24T12:10:48.588Z 2026-03-31T12:27:40.924Z
9564938 9564938 20260323113010_HEBW7 US005D 2026-03-24T12:09:05.077Z 2026-03-31T12:27:19.577Z
9557012 9557012 20260322123521_REkrU US005D 2026-03-23T12:05:28.106Z 2026-03-30T12:29:18.810Z
9556967 9556967 20260322122624_px9ab US005D 2026-03-23T12:05:25.496Z 2026-03-30T12:29:17.733Z
9556789 9556789 20260322114108_Xay53 US005D 2026-03-23T12:05:13.089Z 2026-03-30T12:29:11.009Z
9556763 9556763 20260322113434_RdymQ US005D 2026-03-23T12:05:11.751Z 2026-03-30T12:29:10.385Z
9556483 9556483 20260322104117_omg3C US005D 2026-03-23T12:04:50.715Z 2026-03-30T12:29:02.193Z
9556213 9556213 20260322093501_oVAZq US005D 2026-03-23T12:04:29.042Z 2026-03-30T12:28:47.516Z
9556211 9556211 20260322093459_8yDLB US005D 2026-03-23T12:04:28.851Z 2026-03-30T12:28:47.485Z
9555866 9555866 20260322082532_6zvpv US005D 2026-03-23T12:04:04.661Z 2026-03-30T12:28:37.710Z
9555843 9555843 20260322081622_HwRAk US005D 2026-03-23T12:04:00.018Z 2026-03-30T12:28:36.780Z
9555633 9555633 20260322071147_V0NGo US005D 2026-03-23T12:03:43.047Z 2026-03-30T12:28:30.905Z
9545908 9545908 20260321112101_QJn3W US005D 2026-03-22T12:10:37.859Z 2026-03-29T12:19:45.452Z
9545758 9545758 20260321110452_XsABM US005D 2026-03-22T12:10:09.839Z 2026-03-29T12:19:43.086Z
9545366 9545366 20260321102636_MvUbq US005D 2026-03-22T12:09:12.894Z 2026-03-29T12:19:39.492Z
9544844 9544844 20260321092940_ffnl2 US005D 2026-03-22T12:07:57.839Z 2026-03-29T12:19:34.510Z
9544757 9544757 20260321091848_nh1bp US005D 2026-03-22T12:07:41.982Z 2026-03-29T12:19:33.683Z
9544389 9544389 20260321082752_yBguP US005D 2026-03-22T12:06:39.300Z 2026-03-29T12:19:29.251Z
9544240 9544240 20260321080615_PU6Lu US005D 2026-03-22T12:06:12.336Z 2026-03-29T12:19:24.543Z
9544221 9544221 20260321080154_z5jbo US005D 2026-03-22T12:06:07.642Z 2026-03-29T12:19:17.897Z
9544062 9544062 20260321071637_g042m US005D 2026-03-22T12:05:36.534Z 2026-03-29T12:19:15.806Z
9544013 9544013 20260321065958_DiGyj US005D 2026-03-22T12:05:28.342Z 2026-03-29T12:19:15.210Z
9544003 9544003 20260321065909_vElGn US005D 2026-03-22T12:05:27.334Z 2026-03-29T12:19:15.115Z
9537665 9537665 20260320115452_90X4J US005D 2026-03-21T12:16:13.954Z 2026-03-28T12:35:28.196Z
9537525 9537525 20260320114443_MZXqh US005D 2026-03-21T12:15:58.157Z 2026-03-28T12:35:26.915Z
9537489 9537489 20260320114141_WtjXe US005D 2026-03-21T12:15:55.198Z 2026-03-28T12:35:26.557Z
9537300 9537300 20260320112710_G3zBl US005D 2026-03-21T12:15:30.858Z 2026-03-28T12:35:24.468Z
9537246 9537246 20260320111818_1QS9O US005D 2026-03-21T12:15:23.615Z 2026-03-28T12:35:23.732Z
9537113 9537113 20260320110640_lncc3 US005D 2026-03-21T12:15:06.488Z 2026-03-28T12:35:21.661Z
9536353 9536353 20260320093748_vtLLa US005D 2026-03-21T12:13:11.069Z 2026-03-28T12:35:00.686Z
9535741 9535741 20260320082858_Dn2oM US005D 2026-03-21T12:11:44.633Z 2026-03-28T12:34:50.351Z
9535412 9535412 20260320072720_fn3v1 US005D 2026-03-21T12:10:41.967Z 2026-03-28T12:34:34.529Z
9535399 9535399 20260320072254_e1nWB US005D 2026-03-21T12:10:38.890Z 2026-03-28T12:34:34.277Z
9535359 9535359 20260320071700_HiUft US005D 2026-03-21T12:10:30.646Z 2026-03-28T12:34:33.607Z
9535313 9535313 20260320070049_ebdIT US005D 2026-03-21T12:10:21.569Z 2026-03-28T12:34:32.646Z
9535114 9535114 20260320054036_tjRz0 US005D 2026-03-21T12:09:48.005Z 2026-03-28T12:34:27.743Z
9535075 9535075 20260320052742_SG6jF US005D 2026-03-21T12:09:40.602Z 2026-03-28T12:34:26.808Z
9533719 9533719 20260320025343_pKw7H US005D 2026-03-21T12:06:07.389Z 2026-03-28T12:33:59.649Z
9524709 9524709 20260319122628_WW52R US005D 2026-03-20T12:13:23.698Z 2026-03-27T12:41:55.630Z
9524559 9524559 20260319121241_38ZUR US005D 2026-03-20T12:13:09.245Z 2026-03-27T12:41:54.138Z
9524422 9524422 20260319115516_jkbID US005D 2026-03-20T12:12:58.812Z 2026-03-27T12:41:52.542Z
9524338 9524338 20260319114604_jecs4 US005D 2026-03-20T12:12:51.921Z 2026-03-27T12:41:51.575Z
9523956 9523956 20260319110806_LUtFz US005D 2026-03-20T12:12:17.950Z 2026-03-27T12:41:47.533Z
9523945 9523945 20260319110626_RzRd0 US005D 2026-03-20T12:12:16.177Z 2026-03-27T12:41:47.271Z
9523871 9523871 20260319105607_eYxNj US005D 2026-03-20T12:12:07.681Z 2026-03-27T12:41:46.333Z
9523675 9523675 20260319103204_gFasm US005D 2026-03-20T12:11:50.334Z 2026-03-27T12:41:31.362Z
9523591 9523591 20260319102109_uyGVh US005D 2026-03-20T12:11:42.403Z 2026-03-27T12:41:30.455Z
9523372 9523372 20260319095333_v08OJ US005D 2026-03-20T12:11:17.563Z 2026-03-27T12:41:28.204Z
9523329 9523329 20260319094957_4yU6G US005D 2026-03-20T12:11:13.908Z 2026-03-27T12:41:27.760Z
9522460 9522460 20260319075227_X1wpz US005D 2026-03-20T12:09:50.748Z 2026-03-27T12:41:18.423Z
9522297 9522297 20260319071845_j88eX US005D 2026-03-20T12:09:31.273Z 2026-03-27T12:41:16.432Z
9522261 9522261 20260319070522_xbylt US005D 2026-03-20T12:09:25.223Z 2026-03-27T12:41:15.824Z
9522178 9522178 20260319064102_ctbTs US005D 2026-03-20T12:09:14.222Z 2026-03-27T12:41:14.729Z
9522146 9522146 20260319061736_A3uWs US005D 2026-03-20T12:09:09.597Z 2026-03-27T12:41:14.313Z
9514961 9514961 20260318122203_Q1P60 US005D 2026-03-19T12:18:44.391Z 2026-03-26T12:38:20.868Z
9514798 9514798 20260318120640_CMh9x US005D 2026-03-19T12:18:23.164Z 2026-03-26T12:38:19.583Z
9514332 9514332 20260318111216_yL22V US005D 2026-03-19T12:17:12.948Z 2026-03-26T12:38:15.368Z
9514243 9514243 20260318110143_qFW5Y US005D 2026-03-19T12:17:00.184Z 2026-03-26T12:38:14.734Z
9514151 9514151 20260318105337_vw34I US005D 2026-03-19T12:16:52.962Z 2026-03-26T12:38:14.307Z

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