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

7,183 rows where station_code = "US0035" 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
9268672 9268672 20260128110022_KiY4A US0035 2026-01-29T14:04:17.756Z 2026-01-29T14:04:17.756Z
9268369 9268369 20260128100235_OyW2d US0035 2026-01-29T14:02:41.727Z 2026-01-29T14:02:41.727Z
9268118 9268118 20260128085158_7t2CR US0035 2026-01-29T14:01:11.462Z 2026-01-29T14:01:11.462Z
9268026 9268026 20260128080137_knDJ8 US0035 2026-01-29T14:00:31.540Z 2026-01-29T14:00:31.540Z
9267913 9267913 20260127064920_9XCpX US0035 2026-01-28T14:23:51.842Z 2026-01-29T14:35:53.468Z
9267902 9267902 20260127064412_Y5nhz US0035 2026-01-28T14:23:49.596Z 2026-01-29T14:35:52.488Z
9263521 9263521 20260127085327_9qqka US0035 2026-01-28T14:01:08.496Z 2026-01-29T14:30:16.550Z
9263417 9263417 20260127074809_HJ5Ms US0035 2026-01-28T14:00:25.342Z 2026-01-29T14:30:16.491Z
9256416 9256416 20260124082457_tRP0K US0035 2026-01-25T14:17:03.912Z 2026-01-29T14:48:48.949Z
9256397 9256397 20260124081425_MQka3 US0035 2026-01-25T14:16:56.386Z 2026-01-29T14:48:47.573Z
9256386 9256386 20260124081131_9Twgl US0035 2026-01-25T14:16:52.821Z 2026-01-29T14:48:46.897Z
9256367 9256367 20260124074944_h8zYV US0035 2026-01-25T14:16:48.735Z 2026-01-29T14:48:45.436Z
9256338 9256338 20260124073145_rQuu7 US0035 2026-01-25T14:16:43.406Z 2026-01-29T14:48:43.762Z
9256285 9256285 20260124063920_VTkPe US0035 2026-01-25T14:16:26.544Z 2026-01-29T14:48:34.648Z
9256244 9256244 20260124062803_Pzcoo US0035 2026-01-25T14:16:17.746Z 2026-01-29T14:48:30.639Z
9256115 9256115 20260124055819_VjQSK US0035 2026-01-25T14:15:54.066Z 2026-01-29T14:48:24.107Z
9256101 9256101 20260124055627_34aed US0035 2026-01-25T14:15:51.979Z 2026-01-29T14:48:23.530Z
9255926 9255926 20260124052132_s43Ok US0035 2026-01-25T14:15:10.305Z 2026-01-29T14:48:08.416Z
9255395 9255395 20260124031826_MmnVM US0035 2026-01-25T14:13:11.512Z 2026-01-29T14:47:27.972Z
9255355 9255355 20260124030208_ScSoi US0035 2026-01-25T14:13:02.419Z 2026-01-29T14:47:25.722Z
9255345 9255345 20260124025944_kgr3e US0035 2026-01-25T14:13:00.468Z 2026-01-29T14:47:25.321Z
9252842 9252842 20260123070103_HRBGf US0035 2026-01-24T14:17:28.374Z 2026-01-29T14:53:36.977Z
9250017 9250017 20260123094142_ClNc1 US0035 2026-01-24T14:00:39.599Z 2026-01-29T14:44:51.674Z
9249987 9249987 20260123092838_bDUTi US0035 2026-01-24T14:00:29.298Z 2026-01-29T14:44:46.595Z
9249742 9249742 20260122080912_kfmt4 US0035 2026-01-23T14:16:04.536Z 2026-01-29T14:58:52.922Z
9249723 9249723 20260122074711_5LMQB US0035 2026-01-23T14:16:00.946Z 2026-01-29T14:58:51.707Z
9244420 9244420 20260121082512_lGZIU US0035 2026-01-22T14:25:27.121Z 2026-01-29T15:06:08.568Z
9244341 9244341 20260121074934_EkHuE US0035 2026-01-22T14:25:12.254Z 2026-01-29T15:06:02.425Z
9244282 9244282 20260121071808_r1kC7 US0035 2026-01-22T14:24:52.376Z 2026-01-29T15:05:59.139Z
9244251 9244251 20260121070205_9Q8Xz US0035 2026-01-22T14:24:44.091Z 2026-01-29T15:05:57.628Z
9243824 9243824 20260121052401_A6zJX US0035 2026-01-22T14:23:18.524Z 2026-01-29T15:05:29.145Z
9239623 9239623 20260121112517_LCmH2 US0035 2026-01-22T14:02:19.065Z 2026-01-29T14:54:32.601Z
9239582 9239582 20260121111425_Go4Ld US0035 2026-01-22T14:02:05.192Z 2026-01-29T14:54:30.835Z
9238683 9238683 20260120092956_Jm7HQ US0035 2026-01-21T14:30:23.501Z 2026-01-28T15:02:45.901Z
9238499 9238499 20260120084757_vh64F US0035 2026-01-21T14:29:42.040Z 2026-01-28T15:02:35.883Z
9238458 9238458 20260120084158_16LJh US0035 2026-01-21T14:29:36.036Z 2026-01-28T15:02:34.152Z
9238438 9238438 20260120084017_kpiPm US0035 2026-01-21T14:29:33.900Z 2026-01-28T15:02:33.405Z
9238386 9238386 20260120082858_X0YJG US0035 2026-01-21T14:29:29.495Z 2026-01-28T15:02:31.871Z
9238117 9238117 20260120072654_sqbMo US0035 2026-01-21T14:28:43.876Z 2026-01-28T15:02:08.200Z
9238065 9238065 20260120071510_ezK0L US0035 2026-01-21T14:28:26.419Z 2026-01-28T15:02:06.165Z
9238022 9238022 20260120065815_kBH0g US0035 2026-01-21T14:28:17.730Z 2026-01-28T15:02:03.597Z
9237907 9237907 20260120062246_yaQgm US0035 2026-01-21T14:28:02.638Z 2026-01-28T15:01:58.609Z
9237897 9237897 20260120062036_RYxih US0035 2026-01-21T14:28:01.098Z 2026-01-28T15:01:57.973Z
9237848 9237848 20260120061306_MsR8c US0035 2026-01-21T14:27:46.026Z 2026-01-28T15:01:44.708Z
9237497 9237497 20260120052505_iaKcS US0035 2026-01-21T14:26:48.686Z 2026-01-28T15:01:28.455Z
9237341 9237341 20260120050543_XtJJn US0035 2026-01-21T14:26:02.101Z 2026-01-28T15:01:20.547Z
9236894 9236894 20260120041543_svIcb US0035 2026-01-21T14:24:27.470Z 2026-01-28T15:00:45.225Z
9236722 9236722 20260120035206_mfi1F US0035 2026-01-21T14:23:46.093Z 2026-01-28T15:00:32.015Z
9236630 9236630 20260120034232_jSpI9 US0035 2026-01-21T14:23:34.820Z 2026-01-28T15:00:26.173Z
9235665 9235665 20260120014523_2D2sX US0035 2026-01-21T14:19:51.471Z 2026-01-28T14:59:15.250Z
9235543 9235543 20260120013246_AlRa8 US0035 2026-01-21T14:19:22.121Z 2026-01-28T14:59:01.607Z
9235251 9235251 20260120004804_ebsDC US0035 2026-01-21T14:18:15.294Z 2026-01-28T14:58:45.916Z
9235102 9235102 20260120003028_5bEgz US0035 2026-01-21T14:17:37.309Z 2026-01-28T14:58:30.921Z
9234958 9234958 20260119235602_3CqY0 US0035 2026-01-21T14:16:50.315Z 2026-01-28T14:58:22.418Z
9234886 9234886 20260119234558_5Z3aL US0035 2026-01-21T14:16:35.363Z 2026-01-28T14:58:18.994Z
9232341 9232341 20260120110902_GiQSH US0035 2026-01-21T14:01:22.603Z 2026-01-29T14:59:28.973Z
9232296 9232296 20260120105920_yYYqS US0035 2026-01-21T14:01:10.329Z 2026-01-29T14:59:24.071Z
9232271 9232271 20260120105459_VkYLP US0035 2026-01-21T14:01:03.216Z 2026-01-29T14:59:22.420Z
9232250 9232250 20260120105112_iYHFu US0035 2026-01-21T14:00:59.049Z 2026-01-29T14:59:21.727Z
9232142 9232142 20260120102922_TUsRo US0035 2026-01-21T14:00:28.316Z 2026-01-29T14:59:15.538Z
9231967 9231967 20260119102717_cZicd US0035 2026-01-20T14:34:56.923Z 2026-01-27T15:07:08.475Z
9231832 9231832 20260119100137_gDfK2 US0035 2026-01-20T14:34:29.149Z 2026-01-27T15:07:01.657Z
9231084 9231084 20260119055915_TG3yJ US0035 2026-01-20T14:31:10.452Z 2026-01-27T15:05:57.165Z
9231052 9231052 20260119055049_XEm3A US0035 2026-01-20T14:31:02.921Z 2026-01-27T15:05:55.090Z
9230151 9230151 20260119033504_YOYqO US0035 2026-01-20T14:26:19.584Z 2026-01-27T15:04:30.540Z
9229875 9229875 20260119024709_wCa0s US0035 2026-01-20T14:24:44.123Z 2026-01-27T15:04:12.247Z
9229680 9229680 20260119021616_U1FlQ US0035 2026-01-20T14:23:41.946Z 2026-01-27T15:03:49.304Z
9229436 9229436 20260119014544_YRPqc US0035 2026-01-20T14:22:36.406Z 2026-01-27T15:03:25.957Z
9229054 9229054 20260119004046_6Q2zX US0035 2026-01-20T14:20:45.839Z 2026-01-27T15:02:51.845Z
9226130 9226130 20260119111327_gLiRI US0035 2026-01-20T14:01:20.674Z 2026-01-28T14:54:36.314Z
9226084 9226084 20260119110414_oX3iH US0035 2026-01-20T14:01:02.164Z 2026-01-28T14:54:34.034Z
9215920 9215920 20260116112424_yIgJK US0035 2026-01-17T14:27:15.783Z 2026-01-24T15:15:17.996Z
9215798 9215798 20260116110155_xdouQ US0035 2026-01-17T14:26:53.286Z 2026-01-24T15:15:13.615Z
9215071 9215071 20260116090731_nu3xj US0035 2026-01-17T14:24:15.612Z 2026-01-24T15:14:28.731Z
9214979 9214979 20260116085332_SL858 US0035 2026-01-17T14:24:00.205Z 2026-01-24T15:14:25.667Z
9214897 9214897 20260116084112_tXNTb US0035 2026-01-17T14:23:39.832Z 2026-01-24T15:14:13.129Z
9214717 9214717 20260116074734_X0UAn US0035 2026-01-17T14:22:55.837Z 2026-01-24T15:14:02.742Z
9214615 9214615 20260116070730_92sNJ US0035 2026-01-17T14:22:21.824Z 2026-01-24T15:13:55.456Z
9214247 9214247 20260116055902_UXLwJ US0035 2026-01-17T14:20:43.847Z 2026-01-24T15:13:25.729Z
9213957 9213957 20260116050700_lEnYT US0035 2026-01-17T14:19:20.031Z 2026-01-24T15:12:53.767Z
9197385 9197385 20260113110531_icKa9 US0035 2026-01-14T14:22:43.567Z 2026-01-21T15:06:17.835Z
9197299 9197299 20260113104544_62yvX US0035 2026-01-14T14:22:18.761Z 2026-01-21T15:06:16.431Z
9197251 9197251 20260113103755_HbBHA US0035 2026-01-14T14:22:02.628Z 2026-01-21T15:06:15.835Z
9197012 9197012 20260113095600_UeCMM US0035 2026-01-14T14:21:07.721Z 2026-01-21T15:06:12.413Z
9196908 9196908 20260113093502_w5y2t US0035 2026-01-14T14:20:38.515Z 2026-01-21T15:06:05.814Z
9196403 9196403 20260113065500_q3Lwa US0035 2026-01-14T14:18:12.536Z 2026-01-21T15:05:32.714Z
9196202 9196202 20260113052104_LPP3x US0035 2026-01-14T14:17:08.429Z 2026-01-21T15:05:29.589Z
9196197 9196197 20260113051835_2c1hY US0035 2026-01-14T14:17:04.029Z 2026-01-21T15:05:29.425Z
9195638 9195638 20260113021001_tTKhE US0035 2026-01-14T14:14:14.526Z 2026-01-21T15:04:44.917Z
9195320 9195320 20260113010345_MOIe3 US0035 2026-01-14T14:12:54.481Z 2026-01-21T15:04:39.098Z
9190487 9190487 20260112091209_m4Ajf US0035 2026-01-13T14:22:24.540Z 2026-01-20T15:24:35.473Z
9190310 9190310 20260112084529_u2F8Y US0035 2026-01-13T14:21:44.201Z 2026-01-20T15:24:15.977Z
9190263 9190263 20260112083303_RB7mc US0035 2026-01-13T14:21:31.290Z 2026-01-20T15:24:13.812Z
9190243 9190243 20260112082858_lLbPT US0035 2026-01-13T14:21:24.012Z 2026-01-20T15:24:13.131Z
9190180 9190180 20260112081200_IXS64 US0035 2026-01-13T14:21:08.345Z 2026-01-20T15:24:10.339Z
9190091 9190091 20260112074935_3Hnrd US0035 2026-01-13T14:20:41.680Z 2026-01-20T15:24:06.636Z
9190053 9190053 20260112074136_rjiGQ US0035 2026-01-13T14:20:32.850Z 2026-01-20T15:24:04.882Z
9189737 9189737 20260112060910_4IFE7 US0035 2026-01-13T14:19:06.844Z 2026-01-20T15:23:37.720Z
9189723 9189723 20260112060240_9Njl9 US0035 2026-01-13T14:19:01.421Z 2026-01-20T15:23:37.153Z
9184401 9184401 20260111112504_b0LDP US0035 2026-01-12T14:20:31.707Z 2026-01-19T15:20:56.348Z

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