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

5,782 rows where station_code = "US002D" 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
9256427 9256427 20260124082843_LG4T3 US002D 2026-01-25T14:17:06.252Z 2026-01-29T14:48:49.865Z
9256422 9256422 20260124082615_2dxP2 US002D 2026-01-25T14:17:05.211Z 2026-01-29T14:48:49.440Z
9256399 9256399 20260124081800_V1A7s US002D 2026-01-25T14:16:56.819Z 2026-01-29T14:48:47.746Z
9256371 9256371 20260124075417_5ZzDv US002D 2026-01-25T14:16:49.805Z 2026-01-29T14:48:45.925Z
9256346 9256346 20260124073657_2TBY1 US002D 2026-01-25T14:16:44.650Z 2026-01-29T14:48:44.156Z
9256318 9256318 20260124072027_3TBS2 US002D 2026-01-25T14:16:39.473Z 2026-01-29T14:48:37.391Z
9255721 9255721 20260124044007_43qzN US002D 2026-01-25T14:14:29.166Z 2026-01-29T14:47:53.731Z
9255394 9255394 20260124031826_MmnVM US002D 2026-01-25T14:13:11.512Z 2026-01-29T14:47:27.972Z
9253120 9253120 20260124093015_9jJGH US002D 2026-01-25T14:00:48.074Z 2026-01-29T14:40:18.838Z
9252990 9252990 20260123085302_1OGFh US002D 2026-01-24T14:18:07.115Z 2026-01-29T14:53:46.787Z
9252963 9252963 20260123084102_dDg7m US002D 2026-01-24T14:18:00.775Z 2026-01-29T14:53:44.921Z
9252889 9252889 20260123073542_IyfHy US002D 2026-01-24T14:17:38.152Z 2026-01-29T14:53:40.260Z
9252852 9252852 20260123070241_uCJbR US002D 2026-01-24T14:17:30.059Z 2026-01-29T14:53:37.644Z
9252805 9252805 20260123063538_bbHCA US002D 2026-01-24T14:17:14.678Z 2026-01-29T14:53:34.069Z
9252626 9252626 20260123045001_3WJrA US002D 2026-01-24T14:16:29.951Z 2026-01-29T14:53:12.355Z
9252608 9252608 20260123044452_hKqCY US002D 2026-01-24T14:16:26.803Z 2026-01-29T14:53:11.521Z
9252576 9252576 20260123042306_KqAiA US002D 2026-01-24T14:16:16.236Z 2026-01-29T14:53:09.418Z
9252555 9252555 20260123041126_y613p US002D 2026-01-24T14:16:11.447Z 2026-01-29T14:53:08.460Z
9252085 9252085 20260123005512_ElAYJ US002D 2026-01-24T14:14:19.362Z 2026-01-29T14:52:27.806Z
9250222 9250222 20260123111220_C1iyD US002D 2026-01-24T14:01:44.842Z 2026-01-29T14:45:06.492Z
9250104 9250104 20260123101944_3q32D US002D 2026-01-24T14:01:10.339Z 2026-01-29T14:44:58.909Z
9250095 9250095 20260123101229_S33Q8 US002D 2026-01-24T14:01:06.464Z 2026-01-29T14:44:58.314Z
9250093 9250093 20260123101123_YLwl4 US002D 2026-01-24T14:01:05.787Z 2026-01-29T14:44:58.160Z
9215788 9215788 20260116110147_i2ipM US002D 2026-01-17T14:26:52.100Z 2026-01-24T15:15:13.373Z
9215428 9215428 20260116100956_BPwOp US002D 2026-01-17T14:25:33.004Z 2026-01-24T15:14:45.158Z
9215090 9215090 20260116091615_DK098 US002D 2026-01-17T14:24:24.319Z 2026-01-24T15:14:30.158Z
9214915 9214915 20260116084458_1M5Bo US002D 2026-01-17T14:23:45.732Z 2026-01-24T15:14:20.357Z
9214832 9214832 20260116082042_ab3Py US002D 2026-01-17T14:23:27.482Z 2026-01-24T15:14:09.468Z
9214672 9214672 20260116073427_GUK0Z US002D 2026-01-17T14:22:39.374Z 2026-01-24T15:14:00.067Z
9214588 9214588 20260116070023_05ZgK US002D 2026-01-17T14:22:11.917Z 2026-01-24T15:13:53.607Z
9197991 9197991 20260112103237_FXCzA US002D 2026-01-14T14:34:25.122Z 2026-01-20T15:25:09.563Z
9197361 9197361 20260113105851_V4wW7 US002D 2026-01-14T14:22:32.987Z 2026-01-21T15:06:17.451Z
9197295 9197295 20260113104513_MMLYI US002D 2026-01-14T14:22:17.715Z 2026-01-21T15:06:16.408Z
9197254 9197254 20260113103814_gNUrI US002D 2026-01-14T14:22:03.216Z 2026-01-21T15:06:15.887Z
9197134 9197134 20260113101714_J7aEI US002D 2026-01-14T14:21:39.411Z 2026-01-21T15:06:14.474Z
9196271 9196271 20260113055156_GGITS US002D 2026-01-14T14:17:30.905Z 2026-01-21T15:05:30.680Z
9196142 9196142 20260113045348_23jcS US002D 2026-01-14T14:16:49.917Z 2026-01-21T15:05:28.650Z
9196044 9196044 20260113041351_Vhd64 US002D 2026-01-14T14:16:18.243Z 2026-01-21T15:05:14.522Z
9195808 9195808 20260113025552_x2QHQ US002D 2026-01-14T14:15:02.914Z 2026-01-21T15:04:48.020Z
9195704 9195704 20260113022316_lahBE US002D 2026-01-14T14:14:26.833Z 2026-01-21T15:04:45.888Z
9195461 9195461 20260113012931_SOttD US002D 2026-01-14T14:13:24.927Z 2026-01-21T15:04:40.886Z
9195156 9195156 20260113003105_j05X8 US002D 2026-01-14T14:12:14.692Z 2026-01-21T15:04:37.082Z
9191550 9191550 20260112112115_n7cXO US002D 2026-01-13T14:25:44.860Z 2026-01-20T15:25:38.443Z
9191276 9191276 20260112105241_naFKw US002D 2026-01-13T14:24:57.570Z 2026-01-20T15:25:17.376Z
9190697 9190697 20260112094244_BksFq US002D 2026-01-13T14:23:08.219Z 2026-01-20T15:24:44.131Z
9190269 9190269 20260112083326_QPdto US002D 2026-01-13T14:21:33.437Z 2026-01-20T15:24:14.101Z
9190236 9190236 20260112082707_st6R0 US002D 2026-01-13T14:21:20.396Z 2026-01-20T15:24:12.575Z
9190131 9190131 20260112075808_ncMCQ US002D 2026-01-13T14:20:52.623Z 2026-01-20T15:24:08.248Z
9190101 9190101 20260112074958_3L9RG US002D 2026-01-13T14:20:43.158Z 2026-01-20T15:24:06.862Z
9190042 9190042 20260112073801_PSUGz US002D 2026-01-13T14:20:30.711Z 2026-01-20T15:24:04.444Z
9189616 9189616 20260112052247_cyZnh US002D 2026-01-13T14:18:30.989Z 2026-01-20T15:23:31.566Z
9171959 9171959 20260109053411_j2v4v US002D 2026-01-10T14:10:50.380Z 2026-01-17T15:24:44.889Z
9171946 9171946 20260109050931_2UBnJ US002D 2026-01-10T14:10:45.304Z 2026-01-17T15:24:44.204Z
9171844 9171844 20260109035733_Pl6DV US002D 2026-01-10T14:09:59.711Z 2026-01-17T15:24:37.714Z
9171827 9171827 20260109034051_18xJW US002D 2026-01-10T14:09:53.119Z 2026-01-17T15:24:36.351Z
9171624 9171624 20260109000059_aNLbT US002D 2026-01-10T14:08:31.382Z 2026-01-17T15:24:11.038Z
9087172 9087172 20251228072919_2wN5K US002D 2025-12-30T14:43:13.985Z 2026-01-05T15:10:55.477Z
9087157 9087157 20251228072310_zLhut US002D 2025-12-30T14:43:12.128Z 2026-01-05T15:10:54.990Z
9087105 9087105 20251228070326_ensrU US002D 2025-12-30T14:43:04.110Z 2026-01-05T15:10:53.187Z
9086686 9086686 20251228052649_3AKs0 US002D 2025-12-30T14:41:52.188Z 2026-01-05T15:10:26.938Z
9075517 9075517 20251224092345_UOsBU US002D 2025-12-29T15:04:22.488Z 2026-01-01T15:54:51.322Z
9067305 9067305 20251226090625_JQAa5 US002D 2025-12-29T14:41:43.828Z 2026-01-03T15:38:37.183Z
9067271 9067271 20251226085738_OJdOM US002D 2025-12-29T14:41:40.489Z 2026-01-03T15:38:35.499Z
9067192 9067192 20251226083322_OItHC US002D 2025-12-29T14:41:21.407Z 2026-01-03T15:38:30.354Z
9067145 9067145 20251226082117_KoYSW US002D 2025-12-29T14:41:16.874Z 2026-01-03T15:38:27.518Z
9067124 9067124 20251226081626_yjzFR US002D 2025-12-29T14:41:14.607Z 2026-01-03T15:38:26.238Z
9067055 9067055 20251226075418_44EyM US002D 2025-12-29T14:41:06.738Z 2026-01-03T15:38:23.391Z
9067040 9067040 20251226075018_yeRZW US002D 2025-12-29T14:41:05.109Z 2025-12-30T15:20:03.694Z
9066804 9066804 20251226065228_Mwcg2 US002D 2025-12-29T14:40:33.191Z 2026-01-03T15:38:04.286Z
9066716 9066716 20251226064110_xysc3 US002D 2025-12-29T14:40:27.565Z 2026-01-03T15:37:59.980Z
9065662 9065662 20251226052302_nm2SZ US002D 2025-12-29T14:38:56.967Z 2026-01-03T15:37:03.585Z
9065399 9065399 20251226051028_8OARY US002D 2025-12-29T14:38:31.956Z 2026-01-03T15:36:53.556Z
9064466 9064466 20251226041233_Ajqj9 US002D 2025-12-29T14:37:03.246Z 2026-01-03T15:36:14.520Z
9062268 9062268 20251226020056_arzxz US002D 2025-12-29T14:32:56.733Z 2026-01-03T15:34:14.104Z
9059975 9059975 20251225231424_yVZtC US002D 2025-12-29T14:28:33.171Z 2026-01-03T15:32:29.711Z
9037493 9037493 20251224084205_YrxtO US002D 2025-12-28T14:37:26.983Z 2026-01-01T15:54:49.265Z
9037469 9037469 20251224081430_8ST0G US002D 2025-12-28T14:37:24.872Z 2026-01-01T15:54:48.879Z
9037443 9037443 20251224074438_bZBYv US002D 2025-12-28T14:37:21.129Z 2026-01-01T15:54:48.352Z
9037431 9037431 20251224073114_JNKIL US002D 2025-12-28T14:37:19.087Z 2026-01-01T15:54:48.225Z
9037403 9037403 20251224065947_Cmpm3 US002D 2025-12-28T14:37:01.815Z 2026-01-01T15:54:47.758Z
9036926 9036926 20251224054551_0bN8V US002D 2025-12-28T14:36:15.657Z 2026-01-01T15:54:42.131Z
9036651 9036651 20251224045935_48EAh US002D 2025-12-28T14:35:31.767Z 2026-01-01T15:54:38.179Z
9023848 9023848 20251220224345_8sEvN US002D 2025-12-27T15:09:59.642Z 2025-12-29T15:26:23.578Z
9020012 9020012 20251220111443_qy12h US002D 2025-12-27T15:05:07.843Z 2025-12-29T15:24:40.940Z
9019969 9019969 20251220110516_PBOWF US002D 2025-12-27T15:05:06.827Z 2025-12-29T15:24:40.413Z
9019661 9019661 20251220102145_mze7z US002D 2025-12-27T15:04:56.693Z 2025-12-29T15:24:36.426Z
9019621 9019621 20251220101531_LHuNO US002D 2025-12-27T15:04:55.586Z 2025-12-29T15:24:35.863Z
9019314 9019314 20251220093614_7fn2M US002D 2025-12-27T15:04:02.234Z 2025-12-29T15:24:32.036Z
9019300 9019300 20251220093343_Go2k6 US002D 2025-12-27T15:03:57.229Z 2025-12-29T15:24:31.763Z
9019210 9019210 20251220091557_CK20l US002D 2025-12-27T15:03:29.716Z 2025-12-29T15:24:30.380Z
9018898 9018898 20251220082029_jLDL4 US002D 2025-12-27T15:02:51.892Z 2025-12-29T15:24:25.942Z
9018866 9018866 20251220081407_2Kl30 US002D 2025-12-27T15:02:51.298Z 2025-12-29T15:24:21.839Z
9018857 9018857 20251220081305_pNedi US002D 2025-12-27T15:02:51.137Z 2025-12-29T15:24:20.710Z
9018738 9018738 20251220075216_NoEzk US002D 2025-12-27T15:02:46.964Z 2025-12-29T15:24:02.881Z
9018610 9018610 20251220072700_WOAd8 US002D 2025-12-27T15:02:43.097Z 2025-12-29T15:23:53.365Z
9017858 9017858 20251220055653_5gtTV US002D 2025-12-27T15:01:43.006Z 2025-12-29T15:23:34.094Z
9008021 9008021 20251221105540_RhwVi US002D 2025-12-27T14:41:37.795Z 2025-12-27T14:41:37.795Z
9007953 9007953 20251221105040_cFX61 US002D 2025-12-27T14:41:32.770Z 2025-12-27T14:41:32.770Z
9007893 9007893 20251221104519_25NQ9 US002D 2025-12-27T14:41:27.250Z 2025-12-27T14:41:27.250Z
9007657 9007657 20251221101921_Kwgpu US002D 2025-12-27T14:40:53.448Z 2025-12-27T14:40:53.448Z

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