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

616 rows where station_code = "US0067" 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
9256087 9256087 20260124055107_tdWiX US0067 2026-01-25T14:15:45.319Z 2026-01-29T14:48:22.132Z
9255906 9255906 20260124051644_42KGS US0067 2026-01-25T14:15:07.082Z 2026-01-29T14:48:07.328Z
9255438 9255438 20260124033350_Jcuch US0067 2026-01-25T14:13:27.634Z 2026-01-29T14:47:30.981Z
9252873 9252873 20260123072011_lMxVS US0067 2026-01-24T14:17:34.690Z 2026-01-29T14:53:39.066Z
9252841 9252841 20260123064830_lVkpS US0067 2026-01-24T14:17:27.975Z 2026-01-29T14:53:36.779Z
9252677 9252677 20260123051241_mxSVr US0067 2026-01-24T14:16:41.249Z 2026-01-29T14:53:15.523Z
9252669 9252669 20260123050920_OnzWU US0067 2026-01-24T14:16:37.507Z 2026-01-29T14:53:14.900Z
9245214 9245214 20260122111741_tavo9 US0067 2026-01-23T14:01:05.256Z 2026-01-29T14:49:15.310Z
9245200 9245200 20260122111227_dYvvv US0067 2026-01-23T14:01:00.096Z 2026-01-29T14:49:14.213Z
9244408 9244408 20260121081908_fIvPD US0067 2026-01-22T14:25:24.544Z 2026-01-29T15:06:07.709Z
9244369 9244369 20260121080544_tZf7K US0067 2026-01-22T14:25:17.138Z 2026-01-29T15:06:03.570Z
9244119 9244119 20260121061505_26ERL US0067 2026-01-22T14:24:11.309Z 2026-01-29T15:05:52.274Z
9243347 9243347 20260121041847_L93Q4 US0067 2026-01-22T14:21:30.329Z 2026-01-29T15:04:56.702Z
9239250 9239250 20260121101219_PoR79 US0067 2026-01-22T14:00:36.357Z 2026-01-29T14:54:02.594Z
9238159 9238159 20260120073915_kxe7b US0067 2026-01-21T14:28:49.915Z 2026-01-28T15:02:10.424Z
9238157 9238157 20260120073911_FRIMC US0067 2026-01-21T14:28:49.694Z 2026-01-28T15:02:10.324Z
9238032 9238032 20260120070710_b39N9 US0067 2026-01-21T14:28:22.435Z 2026-01-28T15:02:04.097Z
9232162 9232162 20260120103259_r3YsS US0067 2026-01-21T14:00:36.739Z 2026-01-29T14:59:17.471Z
9232129 9232129 20260120102611_69jLO US0067 2026-01-21T14:00:25.813Z 2026-01-29T14:59:14.935Z
9215549 9215549 20260116102937_Iyk8K US0067 2026-01-17T14:26:05.763Z 2026-01-24T15:15:02.873Z
9215429 9215429 20260116100956_BPwOp US0067 2026-01-17T14:25:33.004Z 2026-01-24T15:14:45.158Z
9215360 9215360 20260116095918_J0iov US0067 2026-01-17T14:25:17.215Z 2026-01-24T15:14:42.724Z
9215300 9215300 20260116094812_3i72H US0067 2026-01-17T14:25:06.945Z 2026-01-24T15:14:38.254Z
9215245 9215245 20260116094147_DVThs US0067 2026-01-17T14:24:55.751Z 2026-01-24T15:14:36.135Z
9215203 9215203 20260116093730_Dsm1F US0067 2026-01-17T14:24:43.506Z 2026-01-24T15:14:34.586Z
9214723 9214723 20260116074916_WlZ2a US0067 2026-01-17T14:22:56.925Z 2026-01-24T15:14:02.969Z
9214584 9214584 20260116065919_7lQ71 US0067 2026-01-17T14:22:10.467Z 2026-01-24T15:13:53.154Z
9214518 9214518 20260116064804_N7X34 US0067 2026-01-17T14:21:51.223Z 2026-01-24T15:13:47.676Z
9212767 9212767 20260116005410_Z9kaJ US0067 2026-01-17T14:13:44.835Z 2026-01-24T15:11:25.721Z
9197049 9197049 20260113100205_X7VKx US0067 2026-01-14T14:21:17.645Z 2026-01-21T15:06:13.260Z
9196816 9196816 20260113091015_F3IXF US0067 2026-01-14T14:20:13.405Z 2026-01-21T15:05:58.288Z
9196232 9196232 20260113053632_SUpjI US0067 2026-01-14T14:17:17.245Z 2026-01-21T15:05:30.046Z
9196097 9196097 20260113043708_PXfry US0067 2026-01-14T14:16:34.971Z 2026-01-21T15:05:27.935Z
9195783 9195783 20260113024818_jltIm US0067 2026-01-14T14:14:52.211Z 2026-01-21T15:04:47.521Z
9195780 9195780 20260113024817_jH67U US0067 2026-01-14T14:14:51.618Z 2026-01-21T15:04:47.445Z
9191271 9191271 20260112105045_9TmL4 US0067 2026-01-13T14:24:56.185Z 2026-01-20T15:25:16.866Z
9190951 9190951 20260112101737_ypSeX US0067 2026-01-13T14:23:59.386Z 2026-01-20T15:25:04.977Z
9190465 9190465 20260112090723_Dxwmg US0067 2026-01-13T14:22:21.014Z 2026-01-20T15:24:34.309Z
9190366 9190366 20260112085441_e7yYn US0067 2026-01-13T14:21:57.582Z 2026-01-20T15:24:19.755Z
9190318 9190318 20260112084539_GPAp1 US0067 2026-01-13T14:21:47.152Z 2026-01-20T15:24:17.614Z
9189934 9189934 20260112070148_JWxOx US0067 2026-01-13T14:20:02.559Z 2026-01-20T15:23:48.351Z
9189895 9189895 20260112064532_kC66e US0067 2026-01-13T14:19:48.374Z 2026-01-20T15:23:46.181Z
9189772 9189772 20260112062105_gut1x US0067 2026-01-13T14:19:16.976Z 2026-01-20T15:23:39.469Z
9171966 9171966 20260109055625_ZEf1E US0067 2026-01-10T14:10:53.680Z 2026-01-17T15:24:45.439Z
9171876 9171876 20260109041307_zy8F4 US0067 2026-01-10T14:10:12.465Z 2026-01-17T15:24:39.722Z
9171682 9171682 20260109012550_yDodU US0067 2026-01-10T14:08:54.365Z 2026-01-17T15:24:17.824Z
9167932 9167932 20260108084551_Y0qDn US0067 2026-01-09T14:09:53.859Z 2026-01-16T15:12:02.764Z
9150921 9150921 20260105035920_O83VF US0067 2026-01-06T14:11:57.515Z 2026-01-13T15:14:08.524Z
9087211 9087211 20251228074730_1LJS3 US0067 2025-12-30T14:43:19.518Z 2026-01-05T15:10:56.813Z
9087167 9087167 20251228072510_HXS7M US0067 2025-12-30T14:43:13.016Z 2026-01-05T15:10:55.313Z
9087149 9087149 20251228071920_f8qZ7 US0067 2025-12-30T14:43:10.534Z 2025-12-31T14:53:02.304Z
9087147 9087147 20251228071728_3yw3n US0067 2025-12-30T14:43:10.267Z 2026-01-05T15:10:54.828Z
9086750 9086750 20251228053302_H38yI US0067 2025-12-30T14:41:59.869Z 2026-01-05T15:10:30.521Z
9086722 9086722 20251228053014_7Oubt US0067 2025-12-30T14:41:55.704Z 2026-01-05T15:10:28.237Z
9086260 9086260 20251228044216_WNq2O US0067 2025-12-30T14:40:46.052Z 2026-01-05T15:10:08.549Z
9067451 9067451 20251226094227_cm9Au US0067 2025-12-29T14:41:56.766Z 2025-12-30T15:20:13.877Z
9067096 9067096 20251226080519_jdp1U US0067 2025-12-29T14:41:11.856Z 2026-01-03T15:38:24.909Z
9066991 9066991 20251226073742_Tmt7i US0067 2025-12-29T14:41:00.752Z 2026-01-03T15:38:20.692Z
9064596 9064596 20251226042254_2vV86 US0067 2025-12-29T14:37:13.869Z 2026-01-03T15:36:18.748Z
9023920 9023920 20251220232012_8KAM9 US0067 2025-12-27T15:10:15.238Z 2025-12-29T15:26:26.442Z
9019643 9019643 20251220101942_U72Co US0067 2025-12-27T15:04:56.511Z 2025-12-29T15:24:36.305Z
9019515 9019515 20251220100221_ak7L7 US0067 2025-12-27T15:04:32.168Z 2025-12-29T15:24:34.783Z
9018716 9018716 20251220074808_8TPRJ US0067 2025-12-27T15:02:46.192Z 2025-12-29T15:24:02.023Z
9018548 9018548 20251220071147_vGmnH US0067 2025-12-27T15:02:40.838Z 2025-12-29T15:23:44.879Z
9002146 9002146 20251222111441_3MjFg US0067 2025-12-27T14:24:14.530Z 2025-12-30T15:48:05.127Z
9001852 9001852 20251222104903_HFC5h US0067 2025-12-27T14:23:25.172Z 2025-12-30T15:48:01.861Z
9001775 9001775 20251222104103_x0BrX US0067 2025-12-27T14:23:07.063Z 2025-12-30T15:48:01.227Z
9001628 9001628 20251222102735_J8RTy US0067 2025-12-27T14:22:37.773Z 2025-12-30T15:47:59.907Z
9001052 9001052 20251222094421_GWcN1 US0067 2025-12-27T14:21:12.245Z 2025-12-30T15:47:54.445Z
9001039 9001039 20251222094353_XLL8I US0067 2025-12-27T14:21:02.957Z 2025-12-30T15:47:54.298Z
9001001 9001001 20251222094226_hd6hX US0067 2025-12-27T14:20:50.689Z 2025-12-30T15:47:53.891Z
9000954 9000954 20251222093938_4dRcI US0067 2025-12-27T14:20:44.946Z 2025-12-30T15:47:53.421Z
9000804 9000804 20251222092638_luosf US0067 2025-12-27T14:20:27.657Z 2025-12-28T15:00:52.200Z
9000686 9000686 20251222091803_RtKTb US0067 2025-12-27T14:19:57.085Z 2025-12-30T15:47:50.703Z
9000573 9000573 20251222091110_wK4Kg US0067 2025-12-27T14:19:48.427Z 2025-12-30T15:47:49.623Z
9000199 9000199 20251222084902_6ZnB9 US0067 2025-12-27T14:18:56.011Z 2025-12-30T15:47:46.090Z
9000021 9000021 20251222083653_q5H51 US0067 2025-12-27T14:18:22.556Z 2025-12-30T15:47:44.606Z
8999876 8999876 20251222082659_AFXT3 US0067 2025-12-27T14:18:08.557Z 2025-12-30T15:47:43.101Z
8999639 8999639 20251222080213_8x9eO US0067 2025-12-27T14:17:16.386Z 2025-12-30T15:47:26.050Z
8999631 8999631 20251222080112_iuROd US0067 2025-12-27T14:17:15.529Z 2025-12-30T15:47:25.181Z
8999019 8999019 20251222065056_h3tp2 US0067 2025-12-27T14:15:26.622Z 2025-12-30T15:46:53.713Z
8998966 8998966 20251222064535_1G6fu US0067 2025-12-27T14:15:10.508Z 2025-12-30T15:46:53.021Z
8998944 8998944 20251222063719_Po839 US0067 2025-12-27T14:15:06.531Z 2025-12-30T15:46:52.693Z
8998896 8998896 20251222063137_l3u1m US0067 2025-12-27T14:14:56.695Z 2025-12-28T14:59:20.076Z
8998867 8998867 20251222062853_XgiMT US0067 2025-12-27T14:14:52.946Z 2025-12-30T15:46:51.854Z
8998787 8998787 20251222061928_wQ9UL US0067 2025-12-27T14:14:33.686Z 2025-12-30T15:46:50.469Z
8998619 8998619 20251222060150_8mZ2r US0067 2025-12-27T14:14:09.809Z 2025-12-30T15:46:48.900Z
8998563 8998563 20251222055559_GfRhT US0067 2025-12-27T14:14:03.158Z 2025-12-30T15:46:48.277Z
8997217 8997217 20251222034929_72tYk US0067 2025-12-27T14:08:48.777Z 2025-12-30T15:46:34.208Z
8988632 8988632 20251218103726_SHZBa US0067 2025-12-26T14:42:41.907Z 2025-12-27T15:21:51.858Z
8988055 8988055 20251218094544_htD4u US0067 2025-12-26T14:41:30.675Z 2025-12-27T15:21:13.883Z
8988007 8988007 20251218094207_3Ppwr US0067 2025-12-26T14:41:25.996Z 2025-12-27T15:21:11.762Z
8987500 8987500 20251218083704_L8bwc US0067 2025-12-26T14:40:30.985Z 2025-12-27T15:20:37.700Z
8987396 8987396 20251218082304_L9bN8 US0067 2025-12-26T14:40:10.670Z 2025-12-27T15:20:19.688Z
8986796 8986796 20251218063824_JRl2u US0067 2025-12-26T14:38:52.193Z 2025-12-27T15:19:38.017Z
8953634 8953634 20251217042845_fBDBR US0067 2025-12-25T14:07:09.869Z 2025-12-26T14:57:14.157Z
8927436 8927436 20251215035836_U2BFa US0067 2025-12-24T14:07:58.784Z 2025-12-24T15:09:30.271Z
8843292 8843292 20251213074158_jXium US0067 2025-12-19T14:05:13.513Z 2025-12-23T14:19:36.515Z
8825922 8825922 20251213024740_BgXL3 US0067 2025-12-17T14:59:49.276Z 2025-12-21T14:17:37.442Z
8825826 8825826 20251213023907_RlELV US0067 2025-12-17T14:59:42.374Z 2025-12-21T14:17:37.114Z

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