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 = "US0003" 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
9609475 9609475 20260405071050_ONpHl US0003 2026-04-06T12:01:54.712Z 2026-04-06T12:01:54.712Z
9609409 9609409 20260405060428_EJT2U US0003 2026-04-06T12:01:40.453Z 2026-04-06T12:01:40.453Z
9607650 9607650 20260404113219_nhxhA US0003 2026-04-05T12:03:21.127Z 2026-04-06T12:16:14.484Z
9607572 9607572 20260404110003_NBeHS US0003 2026-04-05T12:02:58.292Z 2026-04-06T12:16:14.466Z
9607265 9607265 20260404062556_yTVyZ US0003 2026-04-05T12:01:19.784Z 2026-04-06T12:16:14.398Z
9607191 9607191 20260404043005_bsUPM US0003 2026-04-05T12:00:49.003Z 2026-04-06T12:16:14.381Z
9605654 9605654 20260403111845_dKjax US0003 2026-04-04T12:03:19.876Z 2026-04-06T12:18:10.430Z
9605585 9605585 20260403105333_kNuBQ US0003 2026-04-04T12:02:58.076Z 2026-04-06T12:18:06.384Z
9605473 9605473 20260403101133_dFzaU US0003 2026-04-04T12:02:29.856Z 2026-04-06T12:17:54.956Z
9605250 9605250 20260403081453_tjYt5 US0003 2026-04-04T12:01:26.257Z 2026-04-06T12:17:37.435Z
9603457 9603457 20260402102824_cWd5a US0003 2026-04-03T12:03:08.805Z 2026-04-06T12:22:03.793Z
9598999 9598999 20260331103008_flCrU US0003 2026-04-01T12:01:59.306Z 2026-04-06T12:27:19.026Z
9593601 9593601 20260329120746_SmbZD US0003 2026-03-30T12:04:29.245Z 2026-04-06T12:35:29.720Z
9593544 9593544 20260329114741_wdnYK US0003 2026-03-30T12:04:20.738Z 2026-04-06T12:35:25.451Z
9593500 9593500 20260329112605_UcWvA US0003 2026-03-30T12:04:11.718Z 2026-04-06T12:35:22.461Z
9593408 9593408 20260329102313_2YNTW US0003 2026-03-30T12:03:52.686Z 2026-04-06T12:35:17.092Z
9593362 9593362 20260329095128_vmAu3 US0003 2026-03-30T12:03:44.446Z 2026-04-06T12:35:14.600Z
9593299 9593299 20260329085609_fCJM4 US0003 2026-03-30T12:03:31.523Z 2026-04-06T12:35:02.382Z
9593293 9593293 20260329085553_jGHc6 US0003 2026-03-30T12:03:31.025Z 2026-04-06T12:35:02.256Z
9593281 9593281 20260329085539_vNa3Q US0003 2026-03-30T12:03:30.027Z 2026-04-06T12:35:02.052Z
9593255 9593255 20260329083551_GNMgM US0003 2026-03-30T12:03:24.561Z 2026-04-06T12:35:00.427Z
9593210 9593210 20260329080303_JazVE US0003 2026-03-30T12:03:17.558Z 2026-04-06T12:34:56.563Z
9590860 9590860 20260328113516_jnEbT US0003 2026-03-29T12:03:24.339Z 2026-04-06T12:38:37.716Z
9590777 9590777 20260328111442_JcQsD US0003 2026-03-29T12:03:17.258Z 2026-04-06T12:38:34.362Z
9590687 9590687 20260328104326_0EJIO US0003 2026-03-29T12:03:07.166Z 2026-04-06T12:38:30.492Z
9590661 9590661 20260328103632_9dd8e US0003 2026-03-29T12:03:05.481Z 2026-04-06T12:38:29.617Z
9590633 9590633 20260328103055_7TYnt US0003 2026-03-29T12:03:02.954Z 2026-04-06T12:38:28.233Z
9590596 9590596 20260328102052_XME82 US0003 2026-03-29T12:02:58.894Z 2026-04-06T12:38:26.386Z
9590515 9590515 20260328094831_Qtx04 US0003 2026-03-29T12:02:50.504Z 2026-04-06T12:38:13.867Z
9590336 9590336 20260328081957_BYZc4 US0003 2026-03-29T12:02:26.586Z 2026-04-06T12:38:01.991Z
9590205 9590205 20260328073220_S8j60 US0003 2026-03-29T12:02:13.073Z 2026-04-06T12:37:56.180Z
9590198 9590198 20260328073109_n3Zy4 US0003 2026-03-29T12:02:12.754Z 2026-04-06T12:37:56.068Z
9590180 9590180 20260328072109_vYYXj US0003 2026-03-29T12:02:09.843Z 2026-04-06T12:37:54.926Z
9590110 9590110 20260328062052_lPvBW US0003 2026-03-29T12:02:01.396Z 2026-04-06T12:37:51.145Z
9589197 9589197 20260328024713_11yu3 US0003 2026-03-29T12:00:51.161Z 2026-04-06T12:37:06.952Z
9587321 9587321 20260327120521_7skvl US0003 2026-03-28T12:05:16.618Z 2026-04-05T12:34:13.054Z
9587275 9587275 20260327115856_1yNoQ US0003 2026-03-28T12:05:10.940Z 2026-04-05T12:34:11.147Z
9587202 9587202 20260327114034_sbh6R US0003 2026-03-28T12:04:59.520Z 2026-04-05T12:34:06.604Z
9587180 9587180 20260327113801_wIALI US0003 2026-03-28T12:04:57.367Z 2026-04-05T12:34:05.568Z
9587007 9587007 20260327104440_qyy5M US0003 2026-03-28T12:04:33.387Z 2026-04-05T12:33:58.265Z
9586956 9586956 20260327102738_GrkuU US0003 2026-03-28T12:04:26.707Z 2026-04-05T12:33:55.904Z
9586888 9586888 20260327100549_G8TP6 US0003 2026-03-28T12:04:18.000Z 2026-04-05T12:33:53.136Z
9586876 9586876 20260327100355_qbq22 US0003 2026-03-28T12:04:16.593Z 2026-04-05T12:33:52.790Z
9586816 9586816 20260327094522_O6N6V US0003 2026-03-28T12:04:06.934Z 2026-04-05T12:33:50.269Z
9586676 9586676 20260327090709_IsgVc US0003 2026-03-28T12:03:45.384Z 2026-04-05T12:33:37.296Z
9586652 9586652 20260327085643_M602J US0003 2026-03-28T12:03:39.836Z 2026-04-05T12:33:36.115Z
9586538 9586538 20260327081337_Afc1G US0003 2026-03-28T12:03:22.401Z 2026-04-05T12:33:29.836Z
9586476 9586476 20260327075738_W9tcw US0003 2026-03-28T12:03:13.332Z 2026-04-05T12:33:27.510Z
9586390 9586390 20260327065958_XxFim US0003 2026-03-28T12:02:57.718Z 2026-04-05T12:33:23.116Z
9586386 9586386 20260327065544_W7nk8 US0003 2026-03-28T12:02:57.370Z 2026-04-05T12:33:22.897Z
9586341 9586341 20260327063143_unXFp US0003 2026-03-28T12:02:51.945Z 2026-04-05T12:33:21.443Z
9586321 9586321 20260327062215_IDjd3 US0003 2026-03-28T12:02:50.003Z 2026-04-05T12:33:20.711Z
9586286 9586286 20260327055329_Z2jJY US0003 2026-03-28T12:02:43.904Z 2026-04-05T12:33:19.226Z
9586206 9586206 20260327045746_h7SAH US0003 2026-03-28T12:02:31.903Z 2026-04-05T12:33:08.222Z
9585789 9585789 20260327023203_ieG3F US0003 2026-03-28T12:01:20.139Z 2026-04-05T12:32:45.566Z
9583289 9583289 20260326120931_4dMVy US0003 2026-03-27T12:08:18.036Z 2026-04-04T12:41:00.604Z
9583231 9583231 20260326114540_7YB3G US0003 2026-03-27T12:08:08.875Z 2026-04-04T12:40:57.753Z
9583166 9583166 20260326113018_60HJT US0003 2026-03-27T12:07:56.355Z 2026-04-04T12:40:54.961Z
9583148 9583148 20260326112101_Y5bXa US0003 2026-03-27T12:07:52.698Z 2026-04-04T12:40:54.052Z
9583011 9583011 20260326103513_4VU5d US0003 2026-03-27T12:07:26.100Z 2026-04-04T12:40:39.650Z
9582911 9582911 20260326095944_ue9e8 US0003 2026-03-27T12:07:12.254Z 2026-04-04T12:40:36.342Z
9582880 9582880 20260326095548_hJcS4 US0003 2026-03-27T12:07:05.530Z 2026-04-04T12:40:34.267Z
9582762 9582762 20260326092122_wRiK4 US0003 2026-03-27T12:06:43.553Z 2026-04-04T12:40:27.511Z
9582611 9582611 20260326084040_u3Rxw US0003 2026-03-27T12:06:21.511Z 2026-04-04T12:40:15.750Z
9582428 9582428 20260326072457_0wwyy US0003 2026-03-27T12:05:45.075Z 2026-04-04T12:40:00.755Z
9582317 9582317 20260326064711_HHfRG US0003 2026-03-27T12:05:23.657Z 2026-04-04T12:39:50.490Z
9582292 9582292 20260326062406_7lzoS US0003 2026-03-27T12:05:16.894Z 2026-04-04T12:39:48.900Z
9582281 9582281 20260326061854_8Swyz US0003 2026-03-27T12:05:15.051Z 2026-04-04T12:39:48.381Z
9578483 9578483 20260325120048_J1923 US0003 2026-03-26T12:07:43.731Z 2026-04-03T12:38:05.306Z
9578390 9578390 20260325114112_l0b1i US0003 2026-03-26T12:07:29.633Z 2026-04-03T12:38:01.713Z
9578182 9578182 20260325104102_2zo09 US0003 2026-03-26T12:06:57.123Z 2026-04-03T12:37:42.643Z
9578117 9578117 20260325101018_eLMxa US0003 2026-03-26T12:06:46.879Z 2026-04-03T12:37:38.006Z
9578090 9578090 20260325095928_zWDFb US0003 2026-03-26T12:06:43.961Z 2026-04-03T12:37:36.834Z
9578006 9578006 20260325092914_Ib9td US0003 2026-03-26T12:06:32.415Z 2026-04-03T12:37:33.738Z
9577913 9577913 20260325091353_XjBoO US0003 2026-03-26T12:06:20.602Z 2026-04-03T12:37:30.885Z
9577697 9577697 20260325080933_FQxUY US0003 2026-03-26T12:05:53.671Z 2026-04-03T12:37:21.853Z
9577690 9577690 20260325080923_TsCqz US0003 2026-03-26T12:05:53.135Z 2026-04-03T12:37:13.931Z
9577684 9577684 20260325080915_A2ncZ US0003 2026-03-26T12:05:52.615Z 2026-04-03T12:37:13.514Z
9577531 9577531 20260325070917_fxCPN US0003 2026-03-26T12:05:26.635Z 2026-04-03T12:37:05.414Z
9577483 9577483 20260325063249_KRmnX US0003 2026-03-26T12:05:15.531Z 2026-04-03T12:37:03.434Z
9572870 9572870 20260324104341_xj4Fs US0003 2026-03-25T12:06:34.187Z 2026-04-02T12:35:41.840Z
9572622 9572622 20260324094020_G1hGS US0003 2026-03-25T12:05:47.881Z 2026-04-02T12:35:32.276Z
9572488 9572488 20260324091319_IGQi7 US0003 2026-03-25T12:05:19.808Z 2026-04-02T12:35:26.780Z
9572199 9572199 20260324080439_l6vcO US0003 2026-03-25T12:04:13.924Z 2026-04-02T12:35:07.603Z
9404662 9404662 20260227124809_EaFzI US0003 2026-02-28T14:11:24.200Z 2026-03-07T14:49:04.247Z
9404590 9404590 20260227123805_DXreN US0003 2026-02-28T14:11:12.946Z 2026-03-07T14:48:57.126Z
9404493 9404493 20260227122545_kXS42 US0003 2026-02-28T14:10:58.465Z 2026-03-07T14:48:53.434Z
9404348 9404348 20260227120323_qUcEH US0003 2026-02-28T14:10:37.254Z 2026-03-07T14:48:45.941Z
9404331 9404331 20260227120124_Vbyi6 US0003 2026-02-28T14:10:34.491Z 2026-03-07T14:48:45.224Z
9404212 9404212 20260227114632_a7F0v US0003 2026-02-28T14:10:16.676Z 2026-03-07T14:48:40.117Z
9404145 9404145 20260227114132_Wlj9O US0003 2026-02-28T14:10:06.123Z 2026-03-07T14:48:37.061Z
9404125 9404125 20260227113852_BmKdG US0003 2026-02-28T14:10:03.588Z 2026-03-07T14:48:35.325Z
9404107 9404107 20260227113713_1KO28 US0003 2026-02-28T14:10:01.044Z 2026-03-07T14:48:33.972Z
9404017 9404017 20260227112001_lIdFp US0003 2026-02-28T14:09:47.146Z 2026-03-07T14:48:25.751Z
9403996 9403996 20260227111550_W0cQd US0003 2026-02-28T14:09:43.319Z 2026-03-07T14:48:23.481Z
9403992 9403992 20260227111510_RsSKO US0003 2026-02-28T14:09:42.509Z 2026-03-07T14:48:23.202Z
9403768 9403768 20260227104206_6zblY US0003 2026-02-28T14:09:08.517Z 2026-03-07T14:48:13.160Z
9403762 9403762 20260227104157_2zqYI US0003 2026-02-28T14:09:08.025Z 2026-03-07T14:48:12.931Z
9403727 9403727 20260227103948_l5ckq US0003 2026-02-28T14:09:03.642Z 2026-03-07T14:48:11.728Z
9403483 9403483 20260227095530_XImIS US0003 2026-02-28T14:08:25.666Z 2026-03-07T14:47:54.577Z

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