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

976 rows where station_code = "UK00C3" 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
7188578 7188578 20250724230138_5SfMo UK00C3 2025-07-26T12:33:07.386Z 2025-08-01T12:16:20.549Z
7188295 7188295 20250724223816_kxYhY UK00C3 2025-07-26T12:32:54.643Z 2025-08-01T12:16:19.910Z
7176345 7176345 20250725013931_2hEIV UK00C3 2025-07-26T12:02:17.688Z 2025-08-03T13:03:40.146Z
7175592 7175592 20250725003855_09drv UK00C3 2025-07-26T12:00:11.576Z 2025-08-03T13:03:07.221Z
7140687 7140687 20250722015547_3D2CO UK00C3 2025-07-23T12:00:47.578Z 2025-07-30T12:09:01.228Z
7140347 7140347 20250722012152_5DxE3 UK00C3 2025-07-23T12:00:43.804Z 2025-07-30T12:09:00.068Z
7140280 7140280 20250722011610_dM8V1 UK00C3 2025-07-23T12:00:42.854Z 2025-07-30T12:08:59.938Z
7139815 7139815 20250722003000_itFcX UK00C3 2025-07-23T12:00:33.290Z 2025-07-30T12:08:58.897Z
7139292 7139292 20250721233223_JeIsD UK00C3 2025-07-23T12:00:21.910Z 2025-07-30T12:08:57.458Z
7139143 7139143 20250721231241_C4AHT UK00C3 2025-07-23T12:00:19.367Z 2025-07-30T12:08:56.786Z
7109259 7109259 20250717235542_2sWy4 UK00C3 2025-07-20T12:14:09.486Z 2025-07-26T12:45:45.448Z
7109202 7109202 20250717235035_GN4Zk UK00C3 2025-07-20T12:14:04.337Z 2025-07-26T12:45:45.293Z
7099015 7099015 20250717013358_KMglf UK00C3 2025-07-18T12:10:14.726Z 2025-07-25T12:03:02.373Z
7097836 7097836 20250716231001_A3fKL UK00C3 2025-07-18T12:07:13.339Z 2025-07-25T12:02:59.591Z
7089552 7089552 20250715010823_CVx5M UK00C3 2025-07-16T12:13:30.034Z 2025-07-23T12:05:02.235Z
7089428 7089428 20250715005155_6bMMo UK00C3 2025-07-16T12:13:09.714Z 2025-07-23T12:05:01.939Z
7089360 7089360 20250715004749_6GBzp UK00C3 2025-07-16T12:13:05.166Z 2025-07-23T12:05:01.889Z
7088412 7088412 20250714223807_juFmN UK00C3 2025-07-16T12:10:45.659Z 2025-07-23T12:04:59.792Z
7081581 7081581 20250710232624_OAaCR UK00C3 2025-07-14T12:24:58.083Z 2025-07-18T12:35:47.779Z
7080045 7080045 20250713004253_ZqJiX UK00C3 2025-07-14T12:12:13.192Z 2025-07-21T12:03:03.278Z
7080028 7080028 20250713004124_6dmtR UK00C3 2025-07-14T12:12:11.245Z 2025-07-21T12:03:03.254Z
7079809 7079809 20250713001922_oaTf2 UK00C3 2025-07-14T12:11:33.721Z 2025-07-21T12:03:02.490Z
7079696 7079696 20250713000804_vhOY0 UK00C3 2025-07-14T12:11:12.780Z 2025-07-21T12:03:02.193Z
7076118 7076118 20250712011136_eYLKW UK00C3 2025-07-13T12:11:54.243Z 2025-07-20T12:25:15.701Z
7075985 7075985 20250712005817_NKLHm UK00C3 2025-07-13T12:11:31.546Z 2025-07-20T12:25:14.712Z
7075292 7075292 20250711234418_8sZeO UK00C3 2025-07-13T12:09:47.570Z 2025-07-20T12:25:08.115Z
7075195 7075195 20250711233253_2IJVW UK00C3 2025-07-13T12:09:28.688Z 2025-07-20T12:25:07.326Z
7074976 7074976 20250711230821_QUv8W UK00C3 2025-07-13T12:08:56.595Z 2025-07-20T12:25:04.307Z
7072194 7072194 20250711010639_MzdK9 UK00C3 2025-07-12T12:12:46.373Z 2025-07-18T12:36:14.057Z
7071604 7071604 20250711000048_bSfLQ UK00C3 2025-07-12T12:11:19.730Z 2025-07-18T12:35:57.442Z
7071157 7071157 20250710225357_fFcFi UK00C3 2025-07-12T12:09:59.915Z 2025-07-18T12:35:41.832Z
7068245 7068245 20250710011013_10oat UK00C3 2025-07-11T12:14:44.280Z 2025-07-18T12:38:17.580Z
7068216 7068216 20250710010509_amxAm UK00C3 2025-07-11T12:14:38.727Z 2025-07-18T12:38:16.946Z
7067595 7067595 20250710001519_PJqvM UK00C3 2025-07-11T12:13:14.220Z 2025-07-18T12:38:08.973Z
7067430 7067430 20250710000002_bTEKS UK00C3 2025-07-11T12:12:44.315Z 2025-07-18T12:38:06.084Z
7067244 7067244 20250709234839_qwUdr UK00C3 2025-07-11T12:12:16.264Z 2025-07-18T12:38:03.632Z
7067127 7067127 20250709233718_gEwBS UK00C3 2025-07-11T12:12:02.406Z 2025-07-18T12:38:02.251Z
7066969 7066969 20250709231358_VXBhN UK00C3 2025-07-11T12:11:36.884Z 2025-07-18T12:38:00.045Z
7066899 7066899 20250709230802_t6vc0 UK00C3 2025-07-11T12:11:29.347Z 2025-07-18T12:37:59.080Z
7054574 7054574 20250707000401_3ViFG UK00C3 2025-07-08T12:20:25.447Z 2025-07-15T12:49:15.752Z
7028887 7028887 20250702233103_BTm3e UK00C3 2025-07-04T12:14:24.107Z 2025-07-10T12:26:01.361Z
7028768 7028768 20250702232431_nmplE UK00C3 2025-07-04T12:14:17.013Z 2025-07-10T12:26:01.002Z
7028753 7028753 20250702232406_2gzDj UK00C3 2025-07-04T12:14:16.523Z 2025-07-10T12:26:00.968Z
7025741 7025741 20250703005545_av9m4 UK00C3 2025-07-04T12:02:42.380Z 2025-07-12T12:56:00.227Z
7025371 7025371 20250703004000_ZGAdY UK00C3 2025-07-04T12:01:46.470Z 2025-07-12T12:55:48.839Z
7025168 7025168 20250703003325_nKXe2 UK00C3 2025-07-04T12:01:07.759Z 2025-07-12T12:55:44.197Z
6987515 6987515 20250628003650_73KZr UK00C3 2025-06-29T12:12:00.825Z 2025-07-06T12:42:36.045Z
6947734 6947734 20250622002344_c0P1X UK00C3 2025-06-23T12:24:02.931Z 2025-06-30T12:35:49.417Z
6935818 6935818 20250621002405_942Eg UK00C3 2025-06-22T12:13:07.098Z 2025-06-29T12:36:37.422Z
6915015 6915015 20250618001333_ZvVpz UK00C3 2025-06-19T12:16:12.000Z 2025-06-26T12:36:42.348Z
6914908 6914908 20250617235521_6w3cj UK00C3 2025-06-19T12:15:50.876Z 2025-06-26T12:36:41.978Z
6914830 6914830 20250617234247_BEwIL UK00C3 2025-06-19T12:15:38.246Z 2025-06-26T12:36:41.581Z
6914725 6914725 20250617233336_qCYYR UK00C3 2025-06-19T12:15:27.280Z 2025-06-26T12:36:40.969Z
6903018 6903018 20250615235514_WebJz UK00C3 2025-06-17T12:17:22.356Z 2025-06-24T12:59:26.144Z
6885568 6885568 20250613010338_hPgRS UK00C3 2025-06-13T12:08:21.925Z 2025-06-21T12:37:06.726Z
6885408 6885408 20250613001854_tg0OU UK00C3 2025-06-13T12:07:45.360Z 2025-06-21T12:37:04.165Z
6884978 6884978 20250612225457_F4u8p UK00C3 2025-06-13T12:06:26.849Z 2025-06-21T12:37:00.184Z
6848291 6848291 20250602000433_5vnRR UK00C3 2025-06-03T12:10:42.988Z 2025-06-10T12:29:07.983Z
6814193 6814193 20250527015128_g42mJ UK00C3 2025-05-28T12:16:29.044Z 2025-06-04T13:02:59.492Z
6814138 6814138 20250527013116_8fR3x UK00C3 2025-05-28T12:16:13.595Z 2025-06-04T13:02:54.950Z
6809756 6809756 20250526010837_oaCv7 UK00C3 2025-05-27T12:17:17.412Z 2025-06-03T13:03:34.888Z
6809567 6809567 20250526004147_6mgDY UK00C3 2025-05-27T12:16:54.354Z 2025-06-03T13:03:18.857Z
6808845 6808845 20250525224025_MZade UK00C3 2025-05-27T12:15:09.528Z 2025-06-03T13:02:58.496Z
6787915 6787915 20250523010426_LtXPo UK00C3 2025-05-24T12:21:40.352Z 2025-05-31T13:14:48.468Z
6707226 6707226 20250511021405_3w01H UK00C3 2025-05-12T12:06:58.861Z 2025-05-19T12:36:37.010Z
6706512 6706512 20250511002934_rzZpt UK00C3 2025-05-12T12:05:16.715Z 2025-05-19T12:36:18.774Z
6700129 6700129 20250510020207_sA3U2 UK00C3 2025-05-11T12:09:16.935Z 2025-05-18T12:34:06.792Z
6691092 6691092 20250508234843_0CZSX UK00C3 2025-05-10T12:08:23.905Z 2025-05-17T12:35:35.993Z
6669300 6669300 20250506005556_s5pNv UK00C3 2025-05-07T12:17:17.436Z 2025-05-14T12:41:10.051Z
6668783 6668783 20250505234816_gvEcZ UK00C3 2025-05-07T12:16:24.186Z 2025-05-14T12:40:53.793Z
6668653 6668653 20250505233059_AmwHS UK00C3 2025-05-07T12:16:15.808Z 2025-05-14T12:40:48.227Z
6668341 6668341 20250505223133_Numzq UK00C3 2025-05-07T12:15:23.484Z 2025-05-14T12:40:37.296Z
6646802 6646802 20250504014858_7GocT UK00C3 2025-05-05T12:14:12.207Z 2025-05-12T12:35:06.047Z
6646699 6646699 20250504014045_Vp4iV UK00C3 2025-05-05T12:13:52.178Z 2025-05-12T12:35:05.131Z
6637534 6637534 20250503001002_ZPb0G UK00C3 2025-05-04T12:14:58.268Z 2025-05-11T12:36:59.010Z
6630350 6630350 20250502024328_28C1x UK00C3 2025-05-03T12:17:00.351Z 2025-05-10T12:37:32.679Z
6622867 6622867 20250501030148_9jSoD UK00C3 2025-05-02T12:18:24.104Z 2025-05-09T12:38:34.462Z
6622567 6622567 20250501024029_cq7uf UK00C3 2025-05-02T12:18:01.343Z 2025-05-09T12:38:32.907Z
6621404 6621404 20250501012604_RGP1Q UK00C3 2025-05-02T12:16:12.790Z 2025-05-09T12:38:23.528Z
6620543 6620543 20250501002852_EMx5p UK00C3 2025-05-02T12:14:41.939Z 2025-05-09T12:38:13.699Z
6619584 6619584 20250430232945_E2w8h UK00C3 2025-05-02T12:13:01.186Z 2025-05-09T12:38:05.035Z
6619129 6619129 20250430225715_2RQVL UK00C3 2025-05-02T12:12:10.259Z 2025-05-09T12:37:58.566Z
6613831 6613831 20250430020222_PjuIX UK00C3 2025-05-01T12:18:10.752Z 2025-05-08T12:35:12.007Z
6613155 6613155 20250430011327_hjgVa UK00C3 2025-05-01T12:17:10.625Z 2025-05-08T12:35:08.406Z
6612809 6612809 20250430005356_4yBBI UK00C3 2025-05-01T12:16:36.379Z 2025-05-08T12:35:06.595Z
6605207 6605207 20250429022836_dOdH0 UK00C3 2025-04-30T12:21:19.536Z 2025-05-07T12:35:08.539Z
6604660 6604660 20250429015504_Gf06T UK00C3 2025-04-30T12:20:23.213Z 2025-05-07T12:35:05.928Z
6592453 6592453 20250427215441_c3OMo UK00C3 2025-04-29T12:17:27.525Z 2025-05-06T12:36:32.304Z
6585360 6585360 20250427013754_21EG4 UK00C3 2025-04-28T12:21:51.639Z 2025-05-05T12:31:28.932Z
6585264 6585264 20250427012616_7rSd9 UK00C3 2025-04-28T12:21:46.315Z 2025-05-05T12:31:28.673Z
6585082 6585082 20250427010641_MWuB0 UK00C3 2025-04-28T12:21:12.575Z 2025-05-05T12:31:28.162Z
6552762 6552762 20250423025503_yVD2D UK00C3 2025-04-24T12:21:23.063Z 2025-05-01T12:38:45.348Z
6552629 6552629 20250423022218_hxuJ3 UK00C3 2025-04-24T12:21:10.694Z 2025-05-01T12:38:44.541Z
6552520 6552520 20250423020044_y6INC UK00C3 2025-04-24T12:20:57.672Z 2025-05-01T12:38:43.938Z
6550894 6550894 20250422210822_nt6dR UK00C3 2025-04-24T12:17:47.805Z 2025-05-01T12:38:35.132Z
6544457 6544457 20250422014612_3Kayb UK00C3 2025-04-23T12:20:22.665Z 2025-04-30T12:41:32.164Z
6543790 6543790 20250422005848_39uJ9 UK00C3 2025-04-23T12:19:31.920Z 2025-04-30T12:41:29.377Z
6543702 6543702 20250422005309_dqdPj UK00C3 2025-04-23T12:19:27.288Z 2025-04-30T12:41:28.706Z
6535541 6535541 20250420224827_toXw8 UK00C3 2025-04-22T12:18:00.311Z 2025-04-29T12:36:24.084Z
6522441 6522441 20250418002542_pgsI6 UK00C3 2025-04-19T12:10:50.509Z 2025-04-26T12:34:48.329Z

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