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 = "USV003" 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
9267817 9267817 20260127052112_PNgNB USV003 2026-01-28T14:23:25.993Z 2026-01-29T14:35:45.556Z
9264754 9264754 20260127130603_yeuK1 USV003 2026-01-28T14:07:29.302Z 2026-01-29T14:30:24.277Z
9264558 9264558 20260127124544_3w2Eq USV003 2026-01-28T14:06:40.046Z 2026-01-29T14:30:24.210Z
9264454 9264454 20260127122420_jBGQJ USV003 2026-01-28T14:06:11.668Z 2026-01-29T14:30:21.767Z
9264355 9264355 20260127120541_47j7D USV003 2026-01-28T14:05:39.315Z 2026-01-29T14:30:20.875Z
9264213 9264213 20260127114003_qTdBn USV003 2026-01-28T14:04:58.772Z 2026-01-29T14:30:20.551Z
9264165 9264165 20260127112809_6jTPC USV003 2026-01-28T14:04:44.580Z 2026-01-29T14:30:20.508Z
9264153 9264153 20260127112312_lLvuG USV003 2026-01-28T14:04:40.679Z 2026-01-29T14:30:20.075Z
9264013 9264013 20260127105510_1Nm98 USV003 2026-01-28T14:03:56.664Z 2026-01-29T14:30:19.998Z
9263894 9263894 20260127103522_13d10 USV003 2026-01-28T14:03:25.292Z 2026-01-29T14:30:19.957Z
9263461 9263461 20260127081242_kUX7b USV003 2026-01-28T14:00:44.872Z 2026-01-29T14:30:16.511Z
9263438 9263438 20260127075804_k1J23 USV003 2026-01-28T14:00:34.185Z 2026-01-29T14:30:16.504Z
9263130 9263130 20260126073436_dZ5s4 USV003 2026-01-27T14:17:08.853Z 2026-01-29T14:39:18.354Z
9263126 9263126 20260126073042_lNrPC USV003 2026-01-27T14:17:07.484Z 2026-01-29T14:39:18.025Z
9263085 9263085 20260126070309_mer5p USV003 2026-01-27T14:16:56.075Z 2026-01-29T14:39:15.711Z
9263041 9263041 20260126064006_InQmk USV003 2026-01-27T14:16:43.464Z 2026-01-29T14:39:11.255Z
9263028 9263028 20260126062118_sIln1 USV003 2026-01-27T14:16:40.490Z 2026-01-29T14:39:10.414Z
9263023 9263023 20260126061818_ITOXo USV003 2026-01-27T14:16:39.251Z 2026-01-29T14:39:10.115Z
9263016 9263016 20260126061425_ABlJ4 USV003 2026-01-27T14:16:37.358Z 2026-01-29T14:39:09.639Z
9263000 9263000 20260126055449_HHE2F USV003 2026-01-27T14:16:31.116Z 2026-01-29T14:39:08.497Z
9262960 9262960 20260126053136_YhyZW USV003 2026-01-27T14:16:16.065Z 2026-01-29T14:39:06.200Z
9262911 9262911 20260126044648_LBVj6 USV003 2026-01-27T14:16:05.740Z 2026-01-29T14:39:00.946Z
9262888 9262888 20260126041931_NTumS USV003 2026-01-27T14:16:00.048Z 2026-01-29T14:38:59.084Z
9261470 9261470 20260126114857_KNM1o USV003 2026-01-27T14:03:50.856Z 2026-01-29T14:32:27.019Z
9261466 9261466 20260126114834_yWz7C USV003 2026-01-27T14:03:49.734Z 2026-01-29T14:32:26.391Z
9261372 9261372 20260126111721_ZSTHz USV003 2026-01-27T14:03:24.875Z 2026-01-29T14:32:14.096Z
9261327 9261327 20260126110859_yH22T USV003 2026-01-27T14:03:13.461Z 2026-01-29T14:32:12.164Z
9261240 9261240 20260126104126_EXoJq USV003 2026-01-27T14:02:45.790Z 2026-01-29T14:32:06.768Z
9261217 9261217 20260126103139_MZB3V USV003 2026-01-27T14:02:39.905Z 2026-01-29T14:32:05.445Z
9261207 9261207 20260126102726_1JP7M USV003 2026-01-27T14:02:33.361Z 2026-01-29T14:32:04.229Z
9260994 9260994 20260126091356_KLnEG USV003 2026-01-27T14:01:17.808Z 2026-01-29T14:31:17.925Z
9260895 9260895 20260126083037_mxYAk USV003 2026-01-27T14:00:40.364Z 2026-01-29T14:31:06.240Z
9260866 9260866 20260126082441_fR2dA USV003 2026-01-27T14:00:33.571Z 2026-01-29T14:31:02.145Z
9260833 9260833 20260126080624_OcriE USV003 2026-01-27T14:00:24.291Z 2026-01-29T14:30:41.664Z
9260819 9260819 20260126075858_L6eL5 USV003 2026-01-27T14:00:21.197Z 2026-01-29T14:30:37.453Z
9249755 9249755 20260122082350_dfseI USV003 2026-01-23T14:16:10.423Z 2026-01-29T14:58:53.494Z
9245649 9245649 20260122133229_egZZd USV003 2026-01-23T14:02:51.951Z 2026-01-29T14:49:53.034Z
9244445 9244445 20260121083058_s6kc5 USV003 2026-01-22T14:25:33.330Z 2026-01-29T15:06:09.657Z
9244397 9244397 20260121081413_15GLH USV003 2026-01-22T14:25:22.403Z 2026-01-29T15:06:07.073Z
9244382 9244382 20260121081022_mawFA USV003 2026-01-22T14:25:19.067Z 2026-01-29T15:06:06.238Z
9244225 9244225 20260121065120_cqcV3 USV003 2026-01-22T14:24:38.648Z 2026-01-29T15:05:56.429Z
9244023 9244023 20260121055645_ATOtX USV003 2026-01-22T14:23:57.757Z 2026-01-29T15:05:48.890Z
9244003 9244003 20260121055103_oYiff USV003 2026-01-22T14:23:54.221Z 2026-01-29T15:05:38.228Z
9243922 9243922 20260121053409_TQEEl USV003 2026-01-22T14:23:31.530Z 2026-01-29T15:05:34.577Z
9243806 9243806 20260121051909_WwmL4 USV003 2026-01-22T14:23:05.572Z 2026-01-29T15:05:28.132Z
9243588 9243588 20260121045005_uv13X USV003 2026-01-22T14:22:16.600Z 2026-01-29T15:05:18.871Z
9242943 9242943 20260121031955_KU5l7 USV003 2026-01-22T14:19:55.873Z 2026-01-29T15:04:31.281Z
9242937 9242937 20260121031904_Mhlwg USV003 2026-01-22T14:19:54.781Z 2026-01-29T15:04:30.747Z
9242690 9242690 20260121023416_OLaOU USV003 2026-01-22T14:18:49.667Z 2026-01-29T15:04:16.897Z
9242583 9242583 20260121021923_BNPww USV003 2026-01-22T14:18:29.272Z 2026-01-29T15:04:12.393Z
9242555 9242555 20260121021303_G75Ah USV003 2026-01-22T14:18:23.407Z 2026-01-29T15:04:09.543Z
9239858 9239858 20260121125324_xv1Vu USV003 2026-01-22T14:03:31.221Z 2026-01-29T14:54:50.519Z
9239853 9239853 20260121125040_P9jvz USV003 2026-01-22T14:03:29.931Z 2026-01-29T14:54:49.358Z
9239717 9239717 20260121115753_sSUfi USV003 2026-01-22T14:02:52.665Z 2026-01-29T14:54:37.279Z
9239711 9239711 20260121115730_mcvg6 USV003 2026-01-22T14:02:43.653Z 2026-01-29T14:54:36.993Z
9239699 9239699 20260121114810_w2eUq USV003 2026-01-22T14:02:41.349Z 2026-01-29T14:54:36.103Z
9239644 9239644 20260121112855_7B1H3 USV003 2026-01-22T14:02:22.995Z 2026-01-29T14:54:33.364Z
9239637 9239637 20260121112609_ONFlu USV003 2026-01-22T14:02:20.521Z 2026-01-29T14:54:33.003Z
9238897 9238897 20260120101136_BeQWs USV003 2026-01-21T14:30:59.350Z 2026-01-28T15:03:05.833Z
9238832 9238832 20260120095811_KpgGg USV003 2026-01-21T14:30:38.815Z 2026-01-28T15:03:03.269Z
9238594 9238594 20260120091148_badls USV003 2026-01-21T14:30:01.351Z 2026-01-28T15:02:40.192Z
9238571 9238571 20260120090441_dbWS9 USV003 2026-01-21T14:29:58.585Z 2026-01-28T15:02:39.154Z
9238530 9238530 20260120085411_2m91z USV003 2026-01-21T14:29:53.809Z 2026-01-28T15:02:37.323Z
9238455 9238455 20260120084149_9MwW4 USV003 2026-01-21T14:29:35.393Z 2026-01-28T15:02:33.905Z
9238197 9238197 20260120075439_6qAGA USV003 2026-01-21T14:28:54.378Z 2026-01-28T15:02:13.408Z
9238150 9238150 20260120073707_4VKkj USV003 2026-01-21T14:28:48.496Z 2026-01-28T15:02:10.035Z
9238091 9238091 20260120071813_3K2xn USV003 2026-01-21T14:28:38.337Z 2026-01-28T15:02:07.028Z
9237918 9237918 20260120062435_z7yjG USV003 2026-01-21T14:28:04.132Z 2026-01-28T15:01:59.236Z
9237889 9237889 20260120061829_gZqU5 USV003 2026-01-21T14:27:59.294Z 2026-01-28T15:01:57.466Z
9237864 9237864 20260120061516_sVL21 USV003 2026-01-21T14:27:48.031Z 2026-01-28T15:01:45.710Z
9237824 9237824 20260120060916_pQMay USV003 2026-01-21T14:27:42.001Z 2026-01-28T15:01:43.744Z
9237409 9237409 20260120051508_2g5Gw USV003 2026-01-21T14:26:26.868Z 2026-01-28T15:01:24.427Z
9237370 9237370 20260120050703_3GcUH USV003 2026-01-21T14:26:18.387Z 2026-01-28T15:01:22.148Z
9237015 9237015 20260120042750_rulVD USV003 2026-01-21T14:24:57.169Z 2026-01-28T15:00:53.852Z
9236950 9236950 20260120042141_Fo8hw USV003 2026-01-21T14:24:34.857Z 2026-01-28T15:00:50.192Z
9236668 9236668 20260120034455_r6i2S USV003 2026-01-21T14:23:38.795Z 2026-01-28T15:00:28.322Z
9236297 9236297 20260120025757_jdPNN USV003 2026-01-21T14:22:17.573Z 2026-01-28T14:59:53.995Z
9235882 9235882 20260120021330_rtRqx USV003 2026-01-21T14:20:39.048Z 2026-01-28T14:59:25.837Z
9235757 9235757 20260120015648_bMP2K USV003 2026-01-21T14:20:09.352Z 2026-01-28T14:59:19.195Z
9235730 9235730 20260120015323_Rq4Z0 USV003 2026-01-21T14:20:05.875Z 2026-01-28T14:59:17.898Z
9233037 9233037 20260120131140_aRAWi USV003 2026-01-21T14:04:18.321Z 2026-01-29T15:00:36.732Z
9233025 9233025 20260120130740_3aqP2 USV003 2026-01-21T14:04:16.008Z 2026-01-29T15:00:36.233Z
9232990 9232990 20260120130343_WFPJW USV003 2026-01-21T14:04:10.475Z 2026-01-29T15:00:34.439Z
9232915 9232915 20260120125018_86f5m USV003 2026-01-21T14:03:45.858Z 2026-01-29T15:00:25.007Z
9232804 9232804 20260120123109_GuKgA USV003 2026-01-21T14:03:18.612Z 2026-01-29T15:00:15.644Z
9232697 9232697 20260120121113_D3To1 USV003 2026-01-21T14:02:53.962Z 2026-01-29T14:59:57.558Z
9232667 9232667 20260120120606_Ck9EL USV003 2026-01-21T14:02:49.618Z 2026-01-29T14:59:56.118Z
9232582 9232582 20260120115201_j8g1m USV003 2026-01-21T14:02:27.244Z 2026-01-29T14:59:51.874Z
9232535 9232535 20260120114439_FI3zF USV003 2026-01-21T14:02:13.261Z 2026-01-29T14:59:49.151Z
9232454 9232454 20260120113018_4XOuO USV003 2026-01-21T14:01:56.475Z 2026-01-29T14:59:43.944Z
9232351 9232351 20260120111110_CrSVT USV003 2026-01-21T14:01:27.131Z 2026-01-29T14:59:29.829Z
9232345 9232345 20260120110915_I6z24 USV003 2026-01-21T14:01:23.760Z 2026-01-29T14:59:29.447Z
9232290 9232290 20260120105907_tp3aL USV003 2026-01-21T14:01:08.935Z 2026-01-29T14:59:23.880Z
9232093 9232093 20260120102117_R5HgK USV003 2026-01-21T14:00:18.586Z 2026-01-29T14:59:12.809Z
9231955 9231955 20260119102146_zNklG USV003 2026-01-20T14:34:53.686Z 2026-01-27T15:07:07.519Z
9231920 9231920 20260119101453_glZ2N USV003 2026-01-20T14:34:47.560Z 2026-01-27T15:07:05.777Z
9231888 9231888 20260119100938_vMjC7 USV003 2026-01-20T14:34:42.580Z 2026-01-27T15:07:04.187Z
9231426 9231426 20260119075626_NDlR1 USV003 2026-01-20T14:32:43.263Z 2026-01-27T15:06:29.034Z
9231269 9231269 20260119065812_dIgAv USV003 2026-01-20T14:32:05.690Z 2026-01-27T15:06:10.703Z
9231075 9231075 20260119055629_aeLOL USV003 2026-01-20T14:31:08.252Z 2026-01-27T15:05:56.559Z

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