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

526 rows where station_code = "US004U" 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
8683832 8683832 20251204085204_ruUAM US004U 2025-12-05T14:00:49.860Z 2025-12-05T14:00:49.860Z
8683825 8683825 20251204084630_ffIHc US004U 2025-12-05T14:00:48.410Z 2025-12-05T14:00:48.410Z
8669153 8669153 20251202102226_zsKEa US004U 2025-12-03T14:02:44.380Z 2025-12-05T14:16:54.992Z
8618469 8618469 20251127122408_6rPY7 US004U 2025-11-28T14:04:43.586Z 2025-12-05T14:54:16.084Z
8618464 8618464 20251127122342_tFWJI US004U 2025-11-28T14:04:42.620Z 2025-12-05T14:54:15.982Z
8617656 8617656 20251127100929_jhpwx US004U 2025-11-28T14:01:50.146Z 2025-12-05T14:54:02.303Z
8584554 8584554 20251123124036_5o8a6 US004U 2025-11-25T14:06:46.344Z 2025-12-02T15:09:50.344Z
8584346 8584346 20251123114655_MxVd3 US004U 2025-11-25T14:05:58.569Z 2025-12-02T15:09:47.995Z
8554156 8554156 20251120085113_7OyGB US004U 2025-11-22T14:34:49.139Z 2025-11-28T14:58:47.341Z
8530175 8530175 20251119111109_5PpWb US004U 2025-11-21T14:00:42.933Z 2025-11-28T14:53:02.320Z
8529474 8529474 20251119084501_UvZmL US004U 2025-11-20T14:44:57.492Z 2025-11-27T15:13:30.695Z
8451414 8451414 20251113081205_beMKf US004U 2025-11-14T14:25:45.324Z 2025-11-21T15:13:14.599Z
8451096 8451096 20251113063430_iM3Hu US004U 2025-11-14T14:24:56.567Z 2025-11-21T15:13:00.771Z
8429075 8429075 20251111082626_YZbOj US004U 2025-11-12T14:43:14.948Z 2025-11-19T15:18:26.442Z
8407549 8407549 20251109110959_Lu4t1 US004U 2025-11-10T14:19:26.290Z 2025-11-17T14:59:26.522Z
8407369 8407369 20251109103123_Ip24b US004U 2025-11-10T14:19:09.182Z 2025-11-17T14:59:24.499Z
8401060 8401060 20251109123607_ZzkKu US004U 2025-11-10T14:00:18.756Z 2025-11-18T15:18:26.137Z
8400318 8400318 20251108111204_HLQ5D US004U 2025-11-09T14:20:25.661Z 2025-11-16T15:05:58.917Z
8400208 8400208 20251108105415_RrP96 US004U 2025-11-09T14:20:14.577Z 2025-11-16T15:05:58.029Z
8399938 8399938 20251108101459_yWGYS US004U 2025-11-09T14:19:31.171Z 2025-11-16T15:05:55.612Z
8394841 8394841 20251108131331_0S7SJ US004U 2025-11-09T14:00:46.492Z 2025-11-17T14:57:45.196Z
8393970 8393970 20251107103351_xKtry US004U 2025-11-08T14:22:31.617Z 2025-11-15T15:01:02.310Z
8388202 8388202 20251107123852_yNLMt US004U 2025-11-08T14:00:10.984Z 2025-11-16T15:01:53.367Z
8326894 8326894 20251030102112_66PCW US004U 2025-11-01T12:36:28.750Z 2025-11-07T15:18:31.079Z
8324870 8324870 20251030063843_U9Y0x US004U 2025-11-01T12:33:08.695Z 2025-11-07T15:17:14.507Z
8295782 8295782 20251028121115_ercNA US004U 2025-10-30T12:43:10.157Z 2025-11-05T15:25:24.437Z
8291901 8291901 20251028074422_Ir7oC US004U 2025-10-30T12:36:32.566Z 2025-11-05T15:23:22.233Z
8291876 8291876 20251028074156_3Xa6f US004U 2025-10-30T12:36:30.601Z 2025-11-05T15:23:21.644Z
8284636 8284636 20251028050203_DGXi0 US004U 2025-10-29T12:46:18.891Z 2025-11-05T15:22:53.149Z
8204886 8204886 20251023113705_qaUwp US004U 2025-10-25T12:28:36.207Z 2025-10-31T13:09:15.859Z
8204812 8204812 20251023112822_3d2W0 US004U 2025-10-25T12:28:11.277Z 2025-10-31T13:09:15.007Z
8204373 8204373 20251023103836_R9ghI US004U 2025-10-25T12:27:18.232Z 2025-10-31T13:09:06.514Z
8203992 8203992 20251023100109_3ZZ3k US004U 2025-10-25T12:26:19.015Z 2025-10-31T13:09:03.417Z
8203542 8203542 20251023091507_fzbcj US004U 2025-10-25T12:24:55.036Z 2025-10-31T13:09:00.125Z
8183563 8183563 20251021073839_Toepc US004U 2025-10-23T12:33:02.593Z 2025-10-29T13:07:51.113Z
8139039 8139039 20251017104457_tzCI0 US004U 2025-10-19T12:32:56.330Z 2025-10-25T13:31:17.028Z
8129146 8129146 20251017130454_oXN9Q US004U 2025-10-19T12:02:06.879Z 2025-10-26T13:14:32.458Z
8126714 8126714 20251017091528_A8OL4 US004U 2025-10-18T12:34:02.228Z 2025-10-25T13:30:29.001Z
8126439 8126439 20251017085831_FcMvt US004U 2025-10-18T12:33:46.172Z 2025-10-25T13:30:20.749Z
8088346 8088346 20251012064807_yZBGo US004U 2025-10-13T12:13:16.592Z 2025-10-20T13:04:00.268Z
8084116 8084116 20251012122755_8Lams US004U 2025-10-13T12:01:13.499Z 2025-10-21T13:08:16.572Z
8076246 8076246 20251009084144_EJgnk US004U 2025-10-10T12:11:55.296Z 2025-10-17T12:38:06.419Z
8073066 8073066 20251009112542_3zjvB US004U 2025-10-10T12:00:48.743Z 2025-10-18T12:59:28.389Z
8052816 8052816 20251003090726_EcHZR US004U 2025-10-05T12:02:46.039Z 2025-10-12T12:29:49.448Z
7696458 7696458 20250829041035_fjvwx US004U 2025-08-30T12:28:51.538Z 2025-09-06T14:13:20.229Z
7579422 7579422 20250819121412_GrATr US004U 2025-08-21T12:11:24.168Z 2025-08-28T12:52:08.042Z
7080975 7080975 20250713055124_dSCpO US004U 2025-07-14T12:14:59.629Z 2025-07-21T12:03:05.000Z
7042547 7042547 20250706052936_o4mkJ US004U 2025-07-07T12:01:11.903Z 2025-07-15T12:46:02.250Z
7027197 7027197 20250703061512_4tvEu US004U 2025-07-04T12:07:02.887Z 2025-07-12T12:57:21.674Z
7004347 7004347 20250630053223_Dlk2v US004U 2025-07-01T12:14:02.056Z 2025-07-08T12:51:43.772Z
7004262 7004262 20250630045751_CE3Sk US004U 2025-07-01T12:13:48.230Z 2025-07-08T12:51:41.533Z
6988439 6988439 20250628053907_RVJUL US004U 2025-06-29T12:14:54.230Z 2025-07-06T12:42:48.851Z
6922416 6922416 20250619053207_tSHdy US004U 2025-06-20T12:17:14.035Z 2025-06-27T12:40:01.184Z
6911792 6911792 20250618080954_YQNxR US004U 2025-06-19T12:00:14.767Z 2025-06-27T12:39:09.647Z
6911642 6911642 20250617062937_jABi3 US004U 2025-06-18T12:23:11.324Z 2025-06-25T12:36:49.706Z
6903888 6903888 20250617073602_uNJg1 US004U 2025-06-18T12:00:51.917Z 2025-06-26T12:36:18.016Z
6897838 6897838 20250615043840_TPVMO US004U 2025-06-16T12:16:21.859Z 2025-06-23T13:01:17.081Z
6870929 6870929 20250607112341_9PIrS US004U 2025-06-08T12:08:33.165Z 2025-06-15T12:27:40.699Z
6870925 6870925 20250607112230_mNVYS US004U 2025-06-08T12:08:32.468Z 2025-06-15T12:27:40.424Z
6869741 6869741 20250607072025_bOAao US004U 2025-06-08T12:05:10.180Z 2025-06-15T12:27:08.186Z
6843162 6843162 20250601100743_oOGMh US004U 2025-06-02T12:17:07.412Z 2025-06-09T12:47:19.324Z
6843125 6843125 20250601095536_qXAhx US004U 2025-06-02T12:17:03.053Z 2025-06-09T12:47:17.352Z
6843110 6843110 20250601095249_WC9pB US004U 2025-06-02T12:17:01.734Z 2025-06-09T12:47:16.782Z
6842850 6842850 20250601082105_wlOYN US004U 2025-06-02T12:16:16.386Z 2025-06-09T12:46:48.285Z
6842483 6842483 20250601060635_T2wyB US004U 2025-06-02T12:15:07.348Z 2025-06-09T12:46:17.263Z
6842468 6842468 20250601055528_iawCx US004U 2025-06-02T12:15:04.424Z 2025-06-09T12:46:16.583Z
6842411 6842411 20250601051626_opzXC US004U 2025-06-02T12:14:57.439Z 2025-06-09T12:46:14.666Z
6838953 6838953 20250531110045_o67sT US004U 2025-06-01T12:22:30.750Z 2025-06-08T12:32:56.637Z
6838949 6838949 20250531105850_MbLqo US004U 2025-06-01T12:22:30.133Z 2025-06-08T12:32:56.553Z
6838890 6838890 20250531104501_X333a US004U 2025-06-01T12:22:24.989Z 2025-06-08T12:32:56.306Z
6838613 6838613 20250531100045_F8Gr5 US004U 2025-06-01T12:22:09.002Z 2025-06-08T12:32:54.782Z
6772317 6772317 20250522085542_3uuu3 US004U 2025-05-23T12:03:16.933Z 2025-05-31T13:09:59.864Z
6763999 6763999 20250521084330_hOKvR US004U 2025-05-22T12:03:39.387Z 2025-05-30T13:03:12.462Z
6715466 6715466 20250512120007_k3XDS US004U 2025-05-13T12:08:17.892Z 2025-05-20T12:33:53.323Z
6715429 6715429 20250512114642_vG51n US004U 2025-05-13T12:08:11.646Z 2025-05-20T12:33:53.233Z
6715410 6715410 20250512113541_ZciDt US004U 2025-05-13T12:08:08.391Z 2025-05-20T12:33:53.059Z
6708920 6708920 20250511114929_cm1Mb US004U 2025-05-12T12:11:26.495Z 2025-05-19T12:37:28.269Z
6702112 6702112 20250510114134_qJJwE US004U 2025-05-11T12:13:32.711Z 2025-05-18T12:34:50.520Z
6702038 6702038 20250510111832_IggXS US004U 2025-05-11T12:13:26.565Z 2025-05-18T12:34:48.634Z
6701601 6701601 20250510101331_cq3uB US004U 2025-05-11T12:12:38.973Z 2025-05-18T12:34:36.899Z
6694585 6694585 20250509115344_TDTWd US004U 2025-05-10T12:15:47.721Z 2025-05-17T12:36:38.799Z
6694569 6694569 20250509113532_X6Vxe US004U 2025-05-10T12:15:45.222Z 2025-05-17T12:36:38.035Z
6694546 6694546 20250509112552_PkAJN US004U 2025-05-10T12:15:41.451Z 2025-05-17T12:36:37.525Z
6694535 6694535 20250509112453_xAjq5 US004U 2025-05-10T12:15:40.350Z 2025-05-17T12:36:37.468Z
6693811 6693811 20250509100340_MryA3 US004U 2025-05-10T12:14:43.279Z 2025-05-17T12:36:22.938Z
6693217 6693217 20250509080040_52FeW US004U 2025-05-10T12:13:35.855Z 2025-05-17T12:36:13.170Z
6687434 6687434 20250508082522_oon8K US004U 2025-05-09T12:14:13.052Z 2025-05-16T12:35:17.185Z
6687364 6687364 20250508075629_hq37A US004U 2025-05-09T12:14:04.259Z 2025-05-16T12:35:16.481Z
6687172 6687172 20250508062337_2JS1W US004U 2025-05-09T12:13:35.267Z 2025-05-16T12:35:12.395Z
6680878 6680878 20250507115041_G6pud US004U 2025-05-08T12:19:51.202Z 2025-05-15T12:38:25.141Z
6680874 6680874 20250507114804_NgYU8 US004U 2025-05-08T12:19:50.861Z 2025-05-15T12:38:24.860Z
6680790 6680790 20250507112505_H6ABK US004U 2025-05-08T12:19:47.182Z 2025-05-15T12:38:22.915Z
6680750 6680750 20250507111839_tNMc2 US004U 2025-05-08T12:19:45.034Z 2025-05-15T12:38:20.215Z
6680738 6680738 20250507111716_1R3U6 US004U 2025-05-08T12:19:44.578Z 2025-05-15T12:38:20.102Z
6671081 6671081 20250506103531_6Ob3l US004U 2025-05-07T12:20:02.289Z 2025-05-14T12:41:54.434Z
6670915 6670915 20250506084201_4By6D US004U 2025-05-07T12:19:27.369Z 2025-05-14T12:41:48.238Z
6670798 6670798 20250506061033_6eNPa US004U 2025-05-07T12:19:09.627Z 2025-05-14T12:41:41.874Z
6670764 6670764 20250506041848_5zbKi US004U 2025-05-07T12:19:06.818Z 2025-05-14T12:41:40.918Z
6586927 6586927 20250427074737_SXcil US004U 2025-04-28T12:24:54.615Z 2025-05-05T12:31:35.899Z
6546625 6546625 20250422051052_Q0IaQ US004U 2025-04-23T12:22:15.982Z 2025-04-30T12:41:40.751Z

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