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

698 rows where station_code = "USN001" 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
8687237 8687237 20251204060111_c98vU USN001 2025-12-05T14:14:28.398Z 2025-12-05T14:14:35.661Z
8683715 8683715 20251204070812_vcAM2 USN001 2025-12-05T14:00:19.729Z 2025-12-05T14:00:19.729Z
8647970 8647970 20251129061344_zXqcW USN001 2025-11-30T14:29:26.713Z 2025-12-05T14:52:52.204Z
8646200 8646200 20251129012316_4oI5V USN001 2025-11-30T14:25:24.414Z 2025-12-05T14:51:35.678Z
8646104 8646104 20251129010616_OXq3L USN001 2025-11-30T14:25:11.955Z 2025-12-05T14:51:33.088Z
8638765 8638765 20251129093843_lHubr USN001 2025-11-30T14:02:09.571Z 2025-12-05T14:37:42.382Z
8638619 8638619 20251129091519_2mukf USN001 2025-11-30T14:01:42.247Z 2025-12-05T14:37:37.630Z
8638408 8638408 20251129083812_mpxcZ USN001 2025-11-30T14:00:48.973Z 2025-12-05T14:37:15.025Z
8637996 8637996 20251128075357_vj6l2 USN001 2025-11-29T14:28:23.167Z 2025-12-05T15:00:41.931Z
8637977 8637977 20251128074519_rg7lM USN001 2025-11-29T14:28:21.588Z 2025-12-05T15:00:38.929Z
8637904 8637904 20251128072654_TJKqe USN001 2025-11-29T14:28:01.025Z 2025-12-05T15:00:34.024Z
8637877 8637877 20251128071420_t53si USN001 2025-11-29T14:27:57.228Z 2025-12-05T15:00:33.302Z
8637777 8637777 20251128063641_jFUGg USN001 2025-11-29T14:27:50.650Z 2025-12-05T15:00:26.542Z
8637694 8637694 20251128061536_wW4Oh USN001 2025-11-29T14:27:43.446Z 2025-12-05T15:00:14.881Z
8637676 8637676 20251128061158_7vyIG USN001 2025-11-29T14:27:42.130Z 2025-12-05T15:00:13.456Z
8637250 8637250 20251128052042_GYk1t USN001 2025-11-29T14:27:00.805Z 2025-12-05T14:59:39.290Z
8636641 8636641 20251128041334_3JfmL USN001 2025-11-29T14:25:46.808Z 2025-12-05T14:59:27.179Z
8636353 8636353 20251128033807_Tz7u8 USN001 2025-11-29T14:25:24.353Z 2025-12-05T14:59:23.093Z
8636238 8636238 20251128032923_sjNt4 USN001 2025-11-29T14:25:06.859Z 2025-12-05T14:59:21.624Z
8635185 8635185 20251128015041_2PAVE USN001 2025-11-29T14:22:47.323Z 2025-12-05T14:58:31.690Z
8627013 8627013 20251128101233_167eC USN001 2025-11-29T14:02:18.200Z 2025-12-05T14:46:33.061Z
8626968 8626968 20251128100600_XL21y USN001 2025-11-29T14:02:10.683Z 2025-12-05T14:46:25.193Z
8626962 8626962 20251128100519_2EEG1 USN001 2025-11-29T14:02:09.426Z 2025-12-05T14:46:25.013Z
8626512 8626512 20251128085113_Iv5UO USN001 2025-11-29T14:00:35.704Z 2025-12-05T14:46:12.026Z
8626398 8626398 20251128083133_7jyMX USN001 2025-11-29T14:00:13.840Z 2025-12-05T14:46:10.040Z
8624340 8624340 20251127041912_OUJoe USN001 2025-11-28T14:24:29.650Z 2025-12-05T15:04:59.528Z
8624338 8624338 20251127041852_nSozm USN001 2025-11-28T14:24:29.386Z 2025-12-05T15:04:59.507Z
8624333 8624333 20251127041611_buI8L USN001 2025-11-28T14:24:28.908Z 2025-12-05T15:04:59.385Z
8624224 8624224 20251127034456_5OhuM USN001 2025-11-28T14:24:10.664Z 2025-12-05T15:04:55.351Z
8623344 8623344 20251127000600_OvWO2 USN001 2025-11-28T14:21:33.453Z 2025-12-05T15:03:43.898Z
8605052 8605052 20251126105204_UzdCt USN001 2025-11-27T14:01:45.424Z 2025-12-05T15:01:05.882Z
8604951 8604951 20251126102454_80vaG USN001 2025-11-27T14:01:15.555Z 2025-12-05T15:01:01.230Z
8604878 8604878 20251126101012_wlckr USN001 2025-11-27T14:01:00.994Z 2025-12-05T15:00:58.679Z
8592264 8592264 20251124062419_31J6B USN001 2025-11-25T14:26:10.194Z 2025-12-02T15:13:02.800Z
8591765 8591765 20251124045233_SovMd USN001 2025-11-25T14:25:06.251Z 2025-12-02T15:13:00.394Z
8591490 8591490 20251124042002_kFXOx USN001 2025-11-25T14:24:26.020Z 2025-12-02T15:12:58.919Z
8591432 8591432 20251124041406_8Bn1q USN001 2025-11-25T14:24:21.838Z 2025-12-02T15:12:58.703Z
8591374 8591374 20251124040944_823Z5 USN001 2025-11-25T14:24:07.725Z 2025-12-02T15:12:58.389Z
8590439 8590439 20251124024159_h7D53 USN001 2025-11-25T14:22:03.663Z 2025-12-02T15:12:47.704Z
8590076 8590076 20251124021944_cIEqR USN001 2025-11-25T14:21:21.236Z 2025-12-02T15:12:42.068Z
8583397 8583397 20251124105044_2GhRY USN001 2025-11-25T14:01:46.411Z 2025-12-02T15:05:29.612Z
8582065 8582065 20251123035848_nrtF8 USN001 2025-11-24T14:33:14.473Z 2025-12-01T15:22:15.315Z
8581851 8581851 20251123024810_28Nb3 USN001 2025-11-24T14:32:41.504Z 2025-12-01T15:21:45.842Z
8581776 8581776 20251123021811_qzgC3 USN001 2025-11-24T14:32:37.361Z 2025-12-01T15:21:34.190Z
8529015 8529015 20251119053534_OtbSI USN001 2025-11-20T14:44:37.212Z 2025-11-27T15:13:17.420Z
8516697 8516697 20251118081141_5ePzg USN001 2025-11-19T14:42:08.510Z 2025-11-26T15:08:08.856Z
8515521 8515521 20251118043402_QnSvN USN001 2025-11-19T14:39:48.483Z 2025-11-26T15:08:01.473Z
8514249 8514249 20251118015549_6ojoW USN001 2025-11-19T14:37:31.732Z 2025-11-26T15:07:53.425Z
8513617 8513617 20251118004804_AXde7 USN001 2025-11-19T14:36:23.712Z 2025-11-26T15:07:50.117Z
8498670 8498670 20251117110411_zz6ZM USN001 2025-11-18T14:30:47.934Z 2025-11-25T15:11:34.411Z
8498666 8498666 20251117105343_fLxXB USN001 2025-11-18T14:30:47.503Z 2025-11-25T15:11:32.651Z
8498660 8498660 20251117103742_s3Ght USN001 2025-11-18T14:30:46.863Z 2025-11-25T15:11:29.510Z
8498648 8498648 20251117101251_KHU7v USN001 2025-11-18T14:30:45.816Z 2025-11-25T15:11:27.523Z
8498625 8498625 20251117095227_nmIwA USN001 2025-11-18T14:30:42.331Z 2025-11-25T15:11:24.909Z
8498608 8498608 20251117093627_nV0ni USN001 2025-11-18T14:30:39.540Z 2025-11-25T15:11:24.275Z
8498575 8498575 20251117084658_W21kn USN001 2025-11-18T14:30:36.205Z 2025-11-25T15:11:17.357Z
8498565 8498565 20251117083626_sbKSX USN001 2025-11-18T14:30:34.641Z 2025-11-25T15:11:16.334Z
8498541 8498541 20251117081211_Wpqx6 USN001 2025-11-18T14:30:32.237Z 2025-11-25T15:11:14.515Z
8498503 8498503 20251117073703_1AK16 USN001 2025-11-18T14:30:29.459Z 2025-11-25T15:11:12.776Z
8498487 8498487 20251117073046_wk6Fu USN001 2025-11-18T14:30:28.179Z 2025-11-25T15:11:12.098Z
8498458 8498458 20251117070703_VI7CP USN001 2025-11-18T14:30:25.171Z 2025-11-25T15:11:09.369Z
8498430 8498430 20251117063941_gARyv USN001 2025-11-18T14:30:22.319Z 2025-11-25T15:11:07.574Z
8498368 8498368 20251117062435_LgSJA USN001 2025-11-18T14:30:16.055Z 2025-11-25T15:11:01.357Z
8498343 8498343 20251117062058_63g5S USN001 2025-11-18T14:30:10.953Z 2025-11-25T15:11:01.132Z
8496630 8496630 20251117044750_UjOC4 USN001 2025-11-18T14:27:50.403Z 2025-11-25T15:10:20.299Z
8496530 8496530 20251117044022_RDOvx USN001 2025-11-18T14:27:44.845Z 2025-11-25T15:10:17.124Z
8495559 8495559 20251117035623_iDOwQ USN001 2025-11-18T14:26:20.028Z 2025-11-25T15:09:55.443Z
8495543 8495543 20251117035457_b84Nb USN001 2025-11-18T14:26:18.746Z 2025-11-25T15:09:55.380Z
8495513 8495513 20251117035406_aMfN1 USN001 2025-11-18T14:26:16.276Z 2025-11-25T15:09:55.293Z
8494717 8494717 20251117030406_CIg2z USN001 2025-11-18T14:24:46.618Z 2025-11-25T15:09:39.349Z
8494231 8494231 20251117023355_coG40 USN001 2025-11-18T14:23:50.538Z 2025-11-25T15:09:31.691Z
8493814 8493814 20251117020937_0JgM4 USN001 2025-11-18T14:23:07.223Z 2025-11-25T15:09:22.354Z
8492055 8492055 20251116234937_Fz3OO USN001 2025-11-18T14:18:56.225Z 2025-11-25T15:08:45.260Z
8486599 8486599 20251117111404_eco7V USN001 2025-11-18T14:00:09.149Z 2025-11-26T15:05:53.695Z
8484985 8484985 20251115101917_kl1Pr USN001 2025-11-17T14:33:04.936Z 2025-11-23T15:19:53.080Z
8483214 8483214 20251115080913_v39MV USN001 2025-11-17T14:31:05.326Z 2025-11-23T15:18:45.673Z
8483173 8483173 20251115080604_YiUW5 USN001 2025-11-17T14:31:02.779Z 2025-11-23T15:18:44.624Z
8483051 8483051 20251115074910_CyriU USN001 2025-11-17T14:30:58.147Z 2025-11-23T15:18:40.827Z
8482731 8482731 20251115065148_HEdLV USN001 2025-11-17T14:30:32.992Z 2025-11-23T15:18:27.584Z
8481204 8481204 20251116020821_ZMhwv USN001 2025-11-17T14:20:12.223Z 2025-11-24T15:05:00.747Z
8470729 8470729 20251115053507_UZRYA USN001 2025-11-16T14:23:33.226Z 2025-11-23T15:18:18.427Z
8470481 8470481 20251115050624_tYath USN001 2025-11-16T14:22:55.329Z 2025-11-23T15:18:12.678Z
8470261 8470261 20251115044226_0MoKG USN001 2025-11-16T14:22:16.077Z 2025-11-23T15:18:02.264Z
8470256 8470256 20251115044137_TLGIh USN001 2025-11-16T14:22:15.558Z 2025-11-23T15:18:01.721Z
8470130 8470130 20251115042053_yrx54 USN001 2025-11-16T14:22:04.478Z 2025-11-23T15:18:00.510Z
8470030 8470030 20251115040341_Hp14X USN001 2025-11-16T14:21:43.276Z 2025-11-23T15:17:59.598Z
8468489 8468489 20251115002135_j9zuM USN001 2025-11-16T14:17:49.292Z 2025-11-23T15:17:16.561Z
8462194 8462194 20251114110637_Qq3Ou USN001 2025-11-15T14:25:40.528Z 2025-11-22T15:24:08.819Z
8462144 8462144 20251114105930_kwcF7 USN001 2025-11-15T14:25:36.836Z 2025-11-22T15:24:05.930Z
8462091 8462091 20251114104317_FevWd USN001 2025-11-15T14:25:31.848Z 2025-11-22T15:23:59.750Z
8461986 8461986 20251114102718_BFDTm USN001 2025-11-15T14:25:21.694Z 2025-11-22T15:23:51.164Z
8461732 8461732 20251114095629_KlQzd USN001 2025-11-15T14:24:49.095Z 2025-11-22T15:23:37.506Z
8460253 8460253 20251114062506_t7RJw USN001 2025-11-15T14:21:46.414Z 2025-11-22T15:22:29.738Z
8459984 8459984 20251114052300_XFOnm USN001 2025-11-15T14:21:11.485Z 2025-11-22T15:22:20.806Z
8459898 8459898 20251114050603_QldXt USN001 2025-11-15T14:20:46.675Z 2025-11-22T15:22:16.893Z
8459890 8459890 20251114050331_5vcoo USN001 2025-11-15T14:20:45.745Z 2025-11-22T15:22:16.676Z
8459253 8459253 20251114031852_t2zMe USN001 2025-11-15T14:19:18.811Z 2025-11-22T15:21:44.775Z
8459207 8459207 20251114030947_YzDDG USN001 2025-11-15T14:19:05.451Z 2025-11-22T15:21:42.988Z
8459138 8459138 20251114025531_Lga3N USN001 2025-11-15T14:18:56.648Z 2025-11-22T15:21:39.227Z
8452043 8452043 20251113103309_Boj2U USN001 2025-11-14T14:27:23.791Z 2025-11-21T15:13:39.406Z

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