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 = "ES000F" 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
6824573 6824573 20250529030434_1R5YS ES000F 2025-05-30T12:18:17.369Z 2025-06-06T13:02:20.321Z
6824570 6824570 20250529025740_HvNO4 ES000F 2025-05-30T12:18:17.019Z 2025-06-06T13:02:20.183Z
6824564 6824564 20250529025631_cazu5 ES000F 2025-05-30T12:18:16.340Z 2025-06-06T13:02:19.766Z
6824559 6824559 20250529025112_Nt3q4 ES000F 2025-05-30T12:18:15.603Z 2025-06-06T13:02:19.396Z
6824553 6824553 20250529024439_FcNNH ES000F 2025-05-30T12:18:15.001Z 2025-06-06T13:02:19.057Z
6824547 6824547 20250529023151_At9qG ES000F 2025-05-30T12:18:13.704Z 2025-06-06T13:02:18.453Z
6824545 6824545 20250529023016_4v31w ES000F 2025-05-30T12:18:13.210Z 2025-06-06T13:02:18.316Z
6824543 6824543 20250529022354_oe3S6 ES000F 2025-05-30T12:18:12.678Z 2025-06-06T13:02:17.976Z
6824540 6824540 20250529020932_Lc3SA ES000F 2025-05-30T12:18:12.129Z 2025-06-06T13:02:17.697Z
6824537 6824537 20250529020846_arWPj ES000F 2025-05-30T12:18:11.409Z 2025-06-06T13:02:17.518Z
6824523 6824523 20250529015954_I9vaZ ES000F 2025-05-30T12:18:07.041Z 2025-06-06T13:02:16.619Z
6824518 6824518 20250529015444_g9oSn ES000F 2025-05-30T12:18:05.929Z 2025-06-06T13:02:16.234Z
6824460 6824460 20250529012700_3rAwg ES000F 2025-05-30T12:17:43.021Z 2025-06-06T13:02:13.195Z
6824413 6824413 20250529011359_EZqr0 ES000F 2025-05-30T12:17:38.117Z 2025-06-06T13:02:11.283Z
6824400 6824400 20250529010848_UiSvU ES000F 2025-05-30T12:17:36.258Z 2025-06-06T13:02:10.661Z
6824372 6824372 20250529005346_TcDk2 ES000F 2025-05-30T12:17:31.886Z 2025-06-06T13:02:09.037Z
6824363 6824363 20250529005158_LR1jj ES000F 2025-05-30T12:17:30.222Z 2025-06-06T13:02:08.469Z
6824358 6824358 20250529005128_X3UxB ES000F 2025-05-30T12:17:29.531Z 2025-06-06T13:02:08.206Z
6824349 6824349 20250529004459_fxonn ES000F 2025-05-30T12:17:28.491Z 2025-06-06T13:02:07.817Z
6824347 6824347 20250529004452_lvHiQ ES000F 2025-05-30T12:17:28.035Z 2025-06-06T13:02:07.670Z
6824118 6824118 20250528234121_xrPjo ES000F 2025-05-30T12:16:40.797Z 2025-06-06T13:01:35.358Z
6824030 6824030 20250528225656_zkg2R ES000F 2025-05-30T12:16:15.637Z 2025-06-06T13:01:30.588Z
6824026 6824026 20250528225611_A8Yim ES000F 2025-05-30T12:16:14.433Z 2025-06-06T13:01:30.381Z
6823955 6823955 20250528222446_9J3ML ES000F 2025-05-30T12:16:00.667Z 2025-06-06T13:01:27.559Z
6823939 6823939 20250528221640_tod56 ES000F 2025-05-30T12:15:57.428Z 2025-06-06T13:01:26.697Z
6823896 6823896 20250528215906_OLlhL ES000F 2025-05-30T12:15:52.352Z 2025-06-06T13:01:24.533Z
6823888 6823888 20250528215430_MylF1 ES000F 2025-05-30T12:15:47.215Z 2025-06-06T13:01:24.158Z
6823881 6823881 20250528215322_i2ylU ES000F 2025-05-30T12:15:41.375Z 2025-06-06T13:01:23.734Z
6819115 6819115 20250528030522_59c7g ES000F 2025-05-29T12:15:50.899Z 2025-06-05T12:55:05.411Z
6819110 6819110 20250528025925_SCGML ES000F 2025-05-29T12:15:49.698Z 2025-06-05T12:55:05.137Z
6819105 6819105 20250528025540_IRtCr ES000F 2025-05-29T12:15:47.088Z 2025-06-05T12:55:04.699Z
6819100 6819100 20250528025258_6OinE ES000F 2025-05-29T12:15:45.181Z 2025-06-05T12:55:04.434Z
6819095 6819095 20250528024403_YQeug ES000F 2025-05-29T12:15:44.277Z 2025-06-05T12:55:04.156Z
6819090 6819090 20250528023516_mg6Lp ES000F 2025-05-29T12:15:43.412Z 2025-06-05T12:55:03.919Z
6819088 6819088 20250528022948_qUc62 ES000F 2025-05-29T12:15:43.036Z 2025-06-05T12:55:03.793Z
6819075 6819075 20250528021924_Ck8jL ES000F 2025-05-29T12:15:41.659Z 2025-06-05T12:55:03.467Z
6819054 6819054 20250528020901_RPoz7 ES000F 2025-05-29T12:15:38.553Z 2025-06-05T12:55:02.620Z
6819033 6819033 20250528020248_ne0ce ES000F 2025-05-29T12:15:34.562Z 2025-06-05T12:55:01.587Z
6819008 6819008 20250528014435_Iwj63 ES000F 2025-05-29T12:15:29.623Z 2025-06-05T12:55:00.366Z
6818950 6818950 20250528012410_u4I5G ES000F 2025-05-29T12:15:10.085Z 2025-06-05T12:54:57.788Z
6818917 6818917 20250528010415_Z4S2F ES000F 2025-05-29T12:15:03.073Z 2025-06-05T12:54:56.278Z
6818790 6818790 20250528002200_1HXF2 ES000F 2025-05-29T12:14:38.166Z 2025-06-05T12:54:36.501Z
6818783 6818783 20250528001708_c8MTl ES000F 2025-05-29T12:14:29.152Z 2025-06-05T12:54:36.218Z
6818739 6818739 20250527235043_V6cjJ ES000F 2025-05-29T12:14:19.117Z 2025-06-05T12:54:33.989Z
6818736 6818736 20250527234623_Pgsz6 ES000F 2025-05-29T12:14:18.563Z 2025-06-05T12:54:33.782Z
6818677 6818677 20250527231206_o2hW3 ES000F 2025-05-29T12:14:06.587Z 2025-06-05T12:54:28.487Z
6818674 6818674 20250527231146_B01a2 ES000F 2025-05-29T12:14:06.241Z 2025-06-05T12:54:28.393Z
6818659 6818659 20250527225925_lFISR ES000F 2025-05-29T12:14:03.500Z 2025-06-05T12:54:27.573Z
6818645 6818645 20250527225555_LhSrT ES000F 2025-05-29T12:14:00.860Z 2025-06-05T12:54:27.047Z
6818518 6818518 20250527215423_6oTUE ES000F 2025-05-29T12:13:27.453Z 2025-06-05T12:54:21.179Z
6818418 6818418 20250527211257_OCUuE ES000F 2025-05-29T12:12:56.862Z 2025-06-05T12:54:13.450Z
6818363 6818363 20250527205014_A4zi8 ES000F 2025-05-29T12:12:45.387Z 2025-06-05T12:54:00.182Z
6814291 6814291 20250527031806_RFry8 ES000F 2025-05-28T12:16:49.364Z 2025-06-04T13:03:08.321Z
6814276 6814276 20250527030618_mwGtU ES000F 2025-05-28T12:16:45.258Z 2025-06-04T13:03:07.731Z
6814218 6814218 20250527020609_rmzFt ES000F 2025-05-28T12:16:33.635Z 2025-06-04T13:03:02.899Z
6814186 6814186 20250527014550_MCx57 ES000F 2025-05-28T12:16:27.846Z 2025-06-04T13:02:59.213Z
6814179 6814179 20250527014302_2dOpJ ES000F 2025-05-28T12:16:26.672Z 2025-06-04T13:02:58.911Z
6814150 6814150 20250527013539_l2piN ES000F 2025-05-28T12:16:18.790Z 2025-06-04T13:02:55.484Z
6814106 6814106 20250527011808_2iCaa ES000F 2025-05-28T12:16:05.740Z 2025-06-04T13:02:51.141Z
6814062 6814062 20250527010740_EUMuc ES000F 2025-05-28T12:15:55.093Z 2025-06-04T13:02:45.893Z
6814018 6814018 20250527005018_3K6TG ES000F 2025-05-28T12:15:46.739Z 2025-06-04T13:02:37.245Z
6813989 6813989 20250527003958_MY4jq ES000F 2025-05-28T12:15:41.921Z 2025-06-04T13:02:36.239Z
6813981 6813981 20250527003744_mm6GH ES000F 2025-05-28T12:15:32.231Z 2025-06-04T13:02:35.918Z
6813945 6813945 20250527002712_xOi2t ES000F 2025-05-28T12:15:20.535Z 2025-06-04T13:02:34.597Z
6813799 6813799 20250526234226_JW92Q ES000F 2025-05-28T12:14:41.476Z 2025-06-04T13:02:24.846Z
6813787 6813787 20250526233606_ZhMY7 ES000F 2025-05-28T12:14:39.564Z 2025-06-04T13:02:24.406Z
6813784 6813784 20250526233457_sdtee ES000F 2025-05-28T12:14:39.133Z 2025-06-04T13:02:24.254Z
6813762 6813762 20250526232713_taouU ES000F 2025-05-28T12:14:32.073Z 2025-06-04T13:02:20.601Z
6813759 6813759 20250526232624_YdPy4 ES000F 2025-05-28T12:14:31.476Z 2025-06-04T13:02:19.788Z
6813687 6813687 20250526225808_GNdEw ES000F 2025-05-28T12:14:17.462Z 2025-06-04T13:02:14.364Z
6813673 6813673 20250526225002_rCvcU ES000F 2025-05-28T12:14:10.455Z 2025-06-04T13:02:12.349Z
6813650 6813650 20250526223248_tqOXl ES000F 2025-05-28T12:14:00.539Z 2025-06-04T13:02:11.382Z
6810318 6810318 20250526032744_z9ruE ES000F 2025-05-27T12:18:51.110Z 2025-06-03T13:04:10.943Z
6810303 6810303 20250526030756_o9Jum ES000F 2025-05-27T12:18:48.202Z 2025-06-03T13:04:10.005Z
6810293 6810293 20250526030404_GkVfm ES000F 2025-05-27T12:18:42.801Z 2025-06-03T13:04:09.195Z
6810274 6810274 20250526023258_2dLzU ES000F 2025-05-27T12:18:35.272Z 2025-06-03T13:04:07.862Z
6810254 6810254 20250526022808_a3u3V ES000F 2025-05-27T12:18:31.104Z 2025-06-03T13:04:07.082Z
6810251 6810251 20250526022706_Zyigo ES000F 2025-05-27T12:18:30.487Z 2025-06-03T13:04:06.946Z
6809304 6809304 20250525235014_gTJMj ES000F 2025-05-27T12:16:09.154Z 2025-06-03T13:03:09.653Z
6809298 6809298 20250525234925_L7KAA ES000F 2025-05-27T12:16:08.482Z 2025-06-03T13:03:09.417Z
6809271 6809271 20250525234521_Iyfm3 ES000F 2025-05-27T12:16:05.662Z 2025-06-03T13:03:08.678Z
6804272 6804272 20250525032059_haNgi ES000F 2025-05-26T12:21:55.799Z 2025-06-02T13:03:32.148Z
6804262 6804262 20250525031538_2wjHc ES000F 2025-05-26T12:21:54.722Z 2025-06-02T13:03:31.717Z
6804249 6804249 20250525030901_yovuN ES000F 2025-05-26T12:21:53.490Z 2025-06-02T13:03:31.283Z
6804243 6804243 20250525030320_pmQW4 ES000F 2025-05-26T12:21:52.381Z 2025-06-02T13:03:31.018Z
6804219 6804219 20250525022831_Ylskf ES000F 2025-05-26T12:21:47.883Z 2025-06-02T13:03:30.086Z
6804215 6804215 20250525022626_BeR9V ES000F 2025-05-26T12:21:47.341Z 2025-06-02T13:03:29.941Z
6804213 6804213 20250525022620_J2Yzp ES000F 2025-05-26T12:21:47.196Z 2025-06-02T13:03:29.831Z
6804211 6804211 20250525022533_KTGUY ES000F 2025-05-26T12:21:46.933Z 2025-06-02T13:03:29.737Z
6804159 6804159 20250525015632_Y3kTF ES000F 2025-05-26T12:21:41.602Z 2025-06-02T13:03:25.055Z
6804156 6804156 20250525015630_3BLIJ ES000F 2025-05-26T12:21:41.452Z 2025-06-02T13:03:24.889Z
6804152 6804152 20250525015417_v2MJE ES000F 2025-05-26T12:21:40.942Z 2025-06-02T13:03:22.098Z
6804147 6804147 20250525015135_QgWWM ES000F 2025-05-26T12:21:40.379Z 2025-06-02T13:03:21.637Z
6804140 6804140 20250525014744_loXKf ES000F 2025-05-26T12:21:39.654Z 2025-06-02T13:03:20.579Z
6804138 6804138 20250525014726_CWnY5 ES000F 2025-05-26T12:21:39.445Z 2025-06-02T13:03:18.396Z
6804125 6804125 20250525014444_eX43z ES000F 2025-05-26T12:21:30.023Z 2025-06-02T13:03:14.004Z
6804040 6804040 20250525012600_d7CSP ES000F 2025-05-26T12:21:09.745Z 2025-06-02T13:03:02.484Z
6803985 6803985 20250525011332_L7Vkp ES000F 2025-05-26T12:20:56.284Z 2025-06-02T13:03:00.837Z
6803958 6803958 20250525010606_zYwYW ES000F 2025-05-26T12:20:49.523Z 2025-06-02T13:02:59.848Z
6803870 6803870 20250525004056_7TOip ES000F 2025-05-26T12:20:41.024Z 2025-06-02T13:02:55.766Z

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