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

2,638 rows where station_code = "UK00D9" 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
9611656 9611656 20260405025821_Zns0Q UK00D9 2026-04-06T12:15:29.998Z 2026-04-06T12:16:14.841Z
9611605 9611605 20260405024651_ZgFsd UK00D9 2026-04-06T12:15:15.902Z 2026-04-06T12:16:14.831Z
9611410 9611410 20260405015120_nE0M1 UK00D9 2026-04-06T12:14:31.064Z 2026-04-06T12:16:14.796Z
9611175 9611175 20260405003907_GvnAl UK00D9 2026-04-06T12:13:23.101Z 2026-04-06T12:16:14.747Z
9611137 9611137 20260405003002_vBGoD UK00D9 2026-04-06T12:13:09.684Z 2026-04-06T12:16:14.740Z
9611131 9611131 20260405002520_qdSas UK00D9 2026-04-06T12:13:08.151Z 2026-04-06T12:16:14.739Z
9611129 9611129 20260405002502_IgS8w UK00D9 2026-04-06T12:13:07.479Z 2026-04-06T12:16:14.738Z
9611122 9611122 20260405002254_QUBOj UK00D9 2026-04-06T12:13:03.631Z 2026-04-06T12:16:14.737Z
9611108 9611108 20260405001125_OuQvo UK00D9 2026-04-06T12:13:00.936Z 2026-04-06T12:16:14.733Z
9611050 9611050 20260404233823_AVwQL UK00D9 2026-04-06T12:12:49.259Z 2026-04-06T12:16:14.719Z
9608864 9608864 20260404020309_Wwi4b UK00D9 2026-04-05T12:11:59.794Z 2026-04-06T12:20:44.412Z
9608542 9608542 20260403233238_eK4nX UK00D9 2026-04-05T12:10:46.406Z 2026-04-06T12:20:19.282Z
9608408 9608408 20260403225849_ezHtU UK00D9 2026-04-05T12:10:22.106Z 2026-04-06T12:20:11.216Z
9608375 9608375 20260403224039_lXkxl UK00D9 2026-04-05T12:10:16.446Z 2026-04-06T12:20:08.903Z
9608364 9608364 20260403223154_IERbU UK00D9 2026-04-05T12:10:14.199Z 2026-04-06T12:20:08.361Z
9608271 9608271 20260403212753_bhoYp UK00D9 2026-04-05T12:09:52.216Z 2026-04-06T12:20:02.880Z
9608234 9608234 20260403210909_8sPq4 UK00D9 2026-04-05T12:09:38.133Z 2026-04-06T12:19:59.094Z
9604815 9604815 20260402005423_xJ3eZ UK00D9 2026-04-03T12:11:38.207Z 2026-04-06T12:26:20.460Z
9604704 9604704 20260401235521_LRxQC UK00D9 2026-04-03T12:11:17.613Z 2026-04-06T12:26:12.639Z
9604657 9604657 20260401231135_qRb0X UK00D9 2026-04-03T12:11:03.174Z 2026-04-06T12:26:09.697Z
9604627 9604627 20260401222924_onYYC UK00D9 2026-04-03T12:10:54.900Z 2026-04-06T12:26:07.746Z
9598394 9598394 20260329234642_8MGe3 UK00D9 2026-03-31T12:10:31.563Z 2026-04-06T12:36:28.885Z
9598357 9598357 20260329232218_OSl5O UK00D9 2026-03-31T12:10:26.752Z 2026-04-06T12:36:27.029Z
9598337 9598337 20260329224753_35yZg UK00D9 2026-03-31T12:10:20.927Z 2026-04-06T12:36:25.663Z
9598235 9598235 20260329211250_Ms8xe UK00D9 2026-03-31T12:10:03.004Z 2026-04-06T12:36:18.928Z
9594636 9594636 20260328233756_T23TM UK00D9 2026-03-30T12:10:00.965Z 2026-04-06T12:40:02.047Z
9592001 9592001 20260327234015_tksYF UK00D9 2026-03-29T12:07:05.303Z 2026-04-05T12:35:23.684Z
9591992 9591992 20260327233915_UZAny UK00D9 2026-03-29T12:07:04.322Z 2026-04-05T12:35:23.325Z
9591865 9591865 20260327225400_hhi9k UK00D9 2026-03-29T12:06:53.054Z 2026-04-05T12:35:18.020Z
9591842 9591842 20260327223007_86vd3 UK00D9 2026-03-29T12:06:50.665Z 2026-04-05T12:35:16.445Z
9590071 9590071 20260328044527_ZAn1i UK00D9 2026-03-29T12:01:57.056Z 2026-04-06T12:37:49.343Z
9589863 9589863 20260328041138_OPIPt UK00D9 2026-03-29T12:01:40.776Z 2026-04-06T12:37:36.457Z
9589296 9589296 20260328031126_7RXaJ UK00D9 2026-03-29T12:01:03.992Z 2026-04-06T12:37:19.040Z
9589193 9589193 20260328024434_XH6YV UK00D9 2026-03-29T12:00:50.355Z 2026-04-06T12:37:06.393Z
9589138 9589138 20260328023159_xczG2 UK00D9 2026-03-29T12:00:45.289Z 2026-04-06T12:37:02.716Z
9585113 9585113 20260325233122_7OcGh UK00D9 2026-03-27T12:16:45.928Z 2026-04-03T12:39:49.814Z
9581975 9581975 20260326041812_0hVeF UK00D9 2026-03-27T12:04:18.546Z 2026-04-04T12:39:33.557Z
9581957 9581957 20260326041429_07fzY UK00D9 2026-03-27T12:04:14.827Z 2026-04-04T12:39:32.426Z
9581806 9581806 20260326035927_aH004 UK00D9 2026-03-27T12:03:52.970Z 2026-04-04T12:39:21.065Z
9581596 9581596 20260326033330_2l25U UK00D9 2026-03-27T12:03:28.036Z 2026-04-04T12:39:11.569Z
9581318 9581318 20260326025211_7FGmu UK00D9 2026-03-27T12:02:41.849Z 2026-04-04T12:38:52.356Z
9580478 9580478 20260326005350_gli32 UK00D9 2026-03-27T12:00:33.489Z 2026-04-04T12:38:11.515Z
9571103 9571103 20260322234512_0WTgQ UK00D9 2026-03-24T12:24:20.552Z 2026-03-30T12:30:55.170Z
9571022 9571022 20260322233813_Ae6Vi UK00D9 2026-03-24T12:24:10.319Z 2026-03-30T12:30:53.964Z
9570948 9570948 20260322232024_Y3pV8 UK00D9 2026-03-24T12:24:03.971Z 2026-03-30T12:30:52.562Z
9561694 9561694 20260323002656_9J9RS UK00D9 2026-03-24T12:00:57.554Z 2026-03-31T12:25:50.902Z
9561504 9561504 20260322235400_K0W1Q UK00D9 2026-03-24T12:00:12.460Z 2026-03-31T12:25:45.469Z
9561473 9561473 20260321233804_NdLMi UK00D9 2026-03-23T12:12:20.021Z 2026-03-29T12:21:07.518Z
9561089 9561089 20260321225532_iJNAV UK00D9 2026-03-23T12:12:11.405Z 2026-03-29T12:21:05.123Z
9560862 9560862 20260321222953_3jXF0 UK00D9 2026-03-23T12:12:05.851Z 2026-03-29T12:21:03.466Z
9560611 9560611 20260321215030_HH2Cq UK00D9 2026-03-23T12:11:59.192Z 2026-03-29T12:21:01.705Z
9560045 9560045 20260321202522_0sNKt UK00D9 2026-03-23T12:11:36.480Z 2026-03-29T12:20:57.499Z
9559853 9559853 20260321200157_nvpeH UK00D9 2026-03-23T12:11:31.979Z 2026-03-29T12:20:56.085Z
9555473 9555473 20260322050621_tS2Ya UK00D9 2026-03-23T12:03:27.991Z 2026-03-30T12:28:26.957Z
9555414 9555414 20260322044950_j56uh UK00D9 2026-03-23T12:03:24.467Z 2026-03-30T12:28:26.109Z
9555372 9555372 20260322044656_awcgq UK00D9 2026-03-23T12:03:22.967Z 2026-03-30T12:28:25.661Z
9555219 9555219 20260322042617_42wSc UK00D9 2026-03-23T12:03:15.761Z 2026-03-30T12:28:23.013Z
9554939 9554939 20260322034613_bBE3F UK00D9 2026-03-23T12:02:57.410Z 2026-03-30T12:28:11.854Z
9554712 9554712 20260322032910_sDCqq UK00D9 2026-03-23T12:02:47.650Z 2026-03-30T12:28:07.775Z
9554459 9554459 20260322031131_kLynh UK00D9 2026-03-23T12:02:33.507Z 2026-03-30T12:28:04.198Z
9553993 9553993 20260322023008_IzhMY UK00D9 2026-03-23T12:02:04.925Z 2026-03-30T12:27:56.403Z
9553912 9553912 20260322022426_Wgy2G UK00D9 2026-03-23T12:01:59.770Z 2026-03-30T12:27:54.998Z
9553858 9553858 20260322022107_fXomb UK00D9 2026-03-23T12:01:55.440Z 2026-03-30T12:27:53.549Z
9553782 9553782 20260322021301_KfKho UK00D9 2026-03-23T12:01:51.362Z 2026-03-30T12:27:52.440Z
9553366 9553366 20260322013243_np373 UK00D9 2026-03-23T12:01:25.334Z 2026-03-30T12:27:39.752Z
9553340 9553340 20260322013144_r1lAU UK00D9 2026-03-23T12:01:24.545Z 2026-03-30T12:27:39.556Z
9553118 9553118 20260322011534_oXd50 UK00D9 2026-03-23T12:01:13.992Z 2026-03-30T12:27:35.273Z
9553113 9553113 20260322011453_o6HiA UK00D9 2026-03-23T12:01:13.814Z 2026-03-30T12:27:35.195Z
9553022 9553022 20260322010440_AGWP8 UK00D9 2026-03-23T12:01:09.490Z 2026-03-30T12:27:33.767Z
9553009 9553009 20260322010440_umfJ3 UK00D9 2026-03-23T12:01:09.214Z 2026-03-30T12:27:33.732Z
9552741 9552741 20260322003817_ASO9R UK00D9 2026-03-23T12:00:47.739Z 2026-03-30T12:27:29.313Z
9552638 9552638 20260322002508_ldDiX UK00D9 2026-03-23T12:00:38.524Z 2026-03-30T12:27:27.273Z
9543638 9543638 20260321043314_nP39g UK00D9 2026-03-22T12:04:19.449Z 2026-03-29T12:19:09.607Z
9543627 9543627 20260321043133_i5WYf UK00D9 2026-03-22T12:04:18.296Z 2026-03-29T12:19:09.538Z
9543621 9543621 20260321043120_AyajD UK00D9 2026-03-22T12:04:17.704Z 2026-03-29T12:19:09.502Z
9543516 9543516 20260321040836_EXNVr UK00D9 2026-03-22T12:04:02.879Z 2026-03-29T12:19:08.472Z
9543021 9543021 20260321022011_A2JDz UK00D9 2026-03-22T12:02:24.266Z 2026-03-29T12:19:01.497Z
9542959 9542959 20260321020418_NEywX UK00D9 2026-03-22T12:02:11.862Z 2026-03-29T12:19:00.771Z
9542748 9542748 20260321011352_To6Ey UK00D9 2026-03-22T12:01:29.576Z 2026-03-29T12:18:57.878Z
9542313 9542313 20260319230930_YeWW0 UK00D9 2026-03-21T12:29:57.221Z 2026-03-27T12:42:55.216Z
9542085 9542085 20260319224751_16XbN UK00D9 2026-03-21T12:29:39.503Z 2026-03-27T12:42:45.107Z
9541888 9541888 20260319220051_wevVD UK00D9 2026-03-21T12:29:28.037Z 2026-03-27T12:42:42.727Z
9541489 9541489 20260319204410_hUM5o UK00D9 2026-03-21T12:29:00.386Z 2026-03-27T12:42:38.210Z
9535000 9535000 20260320045917_0FWy3 UK00D9 2026-03-21T12:09:26.925Z 2026-03-28T12:34:25.093Z
9534975 9534975 20260320045124_eSqhP UK00D9 2026-03-21T12:09:21.555Z 2026-03-28T12:34:24.446Z
9534961 9534961 20260320044806_YCvW5 UK00D9 2026-03-21T12:09:18.276Z 2026-03-28T12:34:24.130Z
9534839 9534839 20260320042917_8QcH7 UK00D9 2026-03-21T12:09:00.654Z 2026-03-28T12:34:22.750Z
9534713 9534713 20260320041429_72jD5 UK00D9 2026-03-21T12:08:41.679Z 2026-03-28T12:34:21.190Z
9534705 9534705 20260320041421_MbJHE UK00D9 2026-03-21T12:08:40.909Z 2026-03-28T12:34:21.126Z
9534653 9534653 20260320041017_7uMuA UK00D9 2026-03-21T12:08:33.350Z 2026-03-28T12:34:20.519Z
9534633 9534633 20260320040924_GAA27 UK00D9 2026-03-21T12:08:31.626Z 2026-03-28T12:34:20.382Z
9534519 9534519 20260320035730_IrqqO UK00D9 2026-03-21T12:08:11.253Z 2026-03-28T12:34:18.995Z
9534110 9534110 20260320032517_AlR3G UK00D9 2026-03-21T12:07:09.227Z 2026-03-28T12:34:13.813Z
9533922 9533922 20260320030919_J2NfQ UK00D9 2026-03-21T12:06:39.280Z 2026-03-28T12:34:02.261Z
9533883 9533883 20260320030700_YpHUA UK00D9 2026-03-21T12:06:32.827Z 2026-03-28T12:34:01.801Z
9533775 9533775 20260320025730_xfiQE UK00D9 2026-03-21T12:06:14.772Z 2026-03-28T12:34:00.376Z
9533767 9533767 20260320025607_xvsct UK00D9 2026-03-21T12:06:13.568Z 2026-03-28T12:34:00.303Z
9533706 9533706 20260320025224_fQ9qU UK00D9 2026-03-21T12:06:04.493Z 2026-03-28T12:33:58.905Z
9533537 9533537 20260320024020_aLJ3C UK00D9 2026-03-21T12:05:39.030Z 2026-03-28T12:33:55.232Z
9533374 9533374 20260320022606_PR29b UK00D9 2026-03-21T12:05:16.562Z 2026-03-28T12:33:52.472Z

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