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

641 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
9536585 9536585 20260320100614_XAq27 US0067 2026-03-21T12:13:48.753Z 2026-03-28T12:35:04.059Z
9512481 9512481 20260318063023_rZ8QA US0067 2026-03-19T12:12:41.500Z 2026-03-26T12:37:45.907Z
9512368 9512368 20260318054032_2gbpk US0067 2026-03-19T12:12:19.939Z 2026-03-26T12:37:44.450Z
9512330 9512330 20260318051737_7tYLn US0067 2026-03-19T12:12:12.414Z 2026-03-26T12:37:44.095Z
9511023 9511023 20260318033326_s0rtc US0067 2026-03-19T12:09:18.048Z 2026-03-26T12:37:18.846Z
9510456 9510456 20260318025329_Dbq49 US0067 2026-03-19T12:07:41.618Z 2026-03-26T12:37:12.611Z
9485924 9485924 20260315041349_RZurg US0067 2026-03-16T12:08:04.929Z 2026-03-23T12:21:54.562Z
9485922 9485922 20260315041313_7aJ0k US0067 2026-03-16T12:08:04.439Z 2026-03-23T12:21:54.543Z
9484906 9484906 20260315015710_e6Hl7 US0067 2026-03-16T12:04:34.460Z 2026-03-23T12:21:48.937Z
9471171 9471171 20260313091553_y8Ofd US0067 2026-03-14T12:09:35.642Z 2026-03-21T12:49:18.383Z
9471064 9471064 20260313085401_XsnBa US0067 2026-03-14T12:09:18.692Z 2026-03-21T12:49:17.355Z
9470922 9470922 20260313081850_aKiAD US0067 2026-03-14T12:08:54.547Z 2026-03-21T12:49:15.500Z
9470537 9470537 20260313061553_WWH13 US0067 2026-03-14T12:07:39.651Z 2026-03-21T12:49:10.703Z
9470346 9470346 20260313052003_PF3RS US0067 2026-03-14T12:07:05.917Z 2026-03-21T12:49:07.729Z
9452054 9452054 20260310064207_nobnc US0067 2026-03-11T12:04:35.957Z 2026-03-18T12:39:08.974Z
9447772 9447772 20260309084752_vhG0r US0067 2026-03-10T12:07:46.029Z 2026-03-17T12:41:56.473Z
9447482 9447482 20260309074130_45Vx2 US0067 2026-03-10T12:06:41.748Z 2026-03-17T12:41:52.347Z
9447223 9447223 20260309060311_n2dSw US0067 2026-03-10T12:05:38.323Z 2026-03-17T12:41:49.127Z
9446974 9446974 20260309035410_E8ae4 US0067 2026-03-10T12:04:41.385Z 2026-03-17T12:41:45.700Z
9416235 9416235 20260302093744_e145j US0067 2026-03-03T14:03:08.713Z 2026-03-10T12:36:01.208Z
9416151 9416151 20260302090242_DPrY9 US0067 2026-03-03T14:02:53.763Z 2026-03-10T12:35:59.786Z
9320505 9320505 20260213104539_1sYBM US0067 2026-02-14T14:07:06.316Z 2026-02-22T14:42:05.659Z
9308008 9308008 20260209085225_7LDgz US0067 2026-02-10T14:05:25.496Z 2026-02-18T14:59:19.726Z
9294967 9294967 20260206065648_WS3Q7 US0067 2026-02-07T14:01:26.659Z 2026-02-15T14:55:50.380Z
9278702 9278702 20260130103341_4qn44 US0067 2026-01-31T14:02:55.786Z 2026-02-08T14:46:41.375Z
9256087 9256087 20260124055107_tdWiX US0067 2026-01-25T14:15:45.319Z 2026-02-01T14:51:08.723Z
9255906 9255906 20260124051644_42KGS US0067 2026-01-25T14:15:07.082Z 2026-02-01T14:51:02.201Z
9255438 9255438 20260124033350_Jcuch US0067 2026-01-25T14:13:27.634Z 2026-02-01T14:50:35.392Z
9252873 9252873 20260123072011_lMxVS US0067 2026-01-24T14:17:34.690Z 2026-01-31T15:02:20.875Z
9252841 9252841 20260123064830_lVkpS US0067 2026-01-24T14:17:27.975Z 2026-01-31T15:02:19.279Z
9252677 9252677 20260123051241_mxSVr US0067 2026-01-24T14:16:41.249Z 2026-01-31T15:02:01.523Z
9252669 9252669 20260123050920_OnzWU US0067 2026-01-24T14:16:37.507Z 2026-01-31T15:01:58.012Z
9245214 9245214 20260122111741_tavo9 US0067 2026-01-23T14:01:05.256Z 2026-01-31T14:57:47.832Z
9245200 9245200 20260122111227_dYvvv US0067 2026-01-23T14:01:00.096Z 2026-01-31T14:57:46.938Z
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-30T14:51:45.141Z
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

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