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

1,373 rows where station_code = "UK005Y" 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
8682642 8682642 20251203055535_mDcEm UK005Y 2025-12-04T14:17:51.052Z 2025-12-06T14:29:20.767Z
8682509 8682509 20251203054155_t7uJe UK005Y 2025-12-04T14:17:19.710Z 2025-12-06T14:29:12.509Z
8680254 8680254 20251202224903_Pur9W UK005Y 2025-12-04T14:11:29.953Z 2025-12-06T14:26:59.287Z
8680120 8680120 20251202214157_2Rf9P UK005Y 2025-12-04T14:11:07.591Z 2025-12-06T14:26:51.023Z
8680012 8680012 20251202211716_A4UWq UK005Y 2025-12-04T14:10:53.615Z 2025-12-06T14:26:47.243Z
8679930 8679930 20251202211134_gm34E UK005Y 2025-12-04T14:10:47.394Z 2025-12-06T14:26:44.724Z
8677190 8677190 20251203070316_woNPx UK005Y 2025-12-04T14:00:18.289Z 2025-12-06T14:18:10.304Z
8658160 8658160 20251130065859_rBEdl UK005Y 2025-12-01T14:35:03.671Z 2025-12-06T14:50:28.744Z
8656942 8656942 20251130052017_gLVMo UK005Y 2025-12-01T14:33:49.561Z 2025-12-06T14:49:43.348Z
8654815 8654815 20251130033412_5ncyq UK005Y 2025-12-01T14:26:04.088Z 2025-12-06T14:48:48.780Z
8654678 8654678 20251130032518_F8beG UK005Y 2025-12-01T14:25:43.497Z 2025-12-01T14:25:43.497Z
8654217 8654217 20251130030346_XyRVS UK005Y 2025-12-01T14:24:58.618Z 2025-12-06T14:48:38.945Z
8650888 8650888 20251129215601_ZFjej UK005Y 2025-12-01T14:17:27.463Z 2025-12-06T14:46:35.286Z
8650210 8650210 20251129193940_spsLJ UK005Y 2025-12-01T14:15:26.523Z 2025-12-06T14:45:50.652Z
8650058 8650058 20251129191424_3M3cA UK005Y 2025-12-01T14:14:53.209Z 2025-12-06T14:45:46.695Z
8647985 8647985 20251129061649_zn2Mz UK005Y 2025-11-30T14:29:27.424Z 2025-12-06T14:57:05.634Z
8647754 8647754 20251129052030_v4uAE UK005Y 2025-11-30T14:28:51.841Z 2025-12-06T14:56:46.544Z
8636694 8636694 20251128041811_ovjUl UK005Y 2025-11-29T14:26:05.994Z 2025-12-06T15:03:38.037Z
8613313 8613313 20251126031349_WfBbv UK005Y 2025-11-27T14:25:37.774Z 2025-12-04T15:09:39.692Z
8613183 8613183 20251126030901_nVcfV UK005Y 2025-11-27T14:25:29.300Z 2025-12-04T15:09:38.350Z
8609828 8609828 20251126000839_kkjLo UK005Y 2025-11-27T14:18:59.097Z 2025-12-04T15:07:57.623Z
8609630 8609630 20251125235652_XtUmB UK005Y 2025-11-27T14:18:44.288Z 2025-12-04T15:07:56.100Z
8606919 8606919 20251125195545_2GvNs UK005Y 2025-11-27T14:11:48.091Z 2025-12-04T15:06:52.151Z
8606182 8606182 20251125181132_LZWz1 UK005Y 2025-11-27T14:09:18.469Z 2025-12-04T15:06:30.586Z
8602865 8602865 20251125052903_b48VZ UK005Y 2025-11-26T14:26:25.219Z 2025-12-02T15:09:33.263Z
8602291 8602291 20251125044614_o0R90 UK005Y 2025-11-26T14:25:30.019Z 2025-12-02T15:09:30.264Z
8600951 8600951 20251125032623_Kn17w UK005Y 2025-11-26T14:23:16.849Z 2025-12-02T15:08:53.240Z
8600564 8600564 20251125030745_Th23n UK005Y 2025-11-26T14:22:48.127Z 2025-12-02T15:08:47.006Z
8600086 8600086 20251125024155_AksAK UK005Y 2025-11-26T14:22:01.649Z 2025-12-02T15:08:34.494Z
8599626 8599626 20251125021249_03Js4 UK005Y 2025-11-26T14:21:20.192Z 2025-12-02T15:08:30.629Z
8599012 8599012 20251125014128_RnbtY UK005Y 2025-11-26T14:20:12.655Z 2025-12-02T15:08:17.074Z
8598594 8598594 20251125010735_bODth UK005Y 2025-11-26T14:19:18.551Z 2025-12-02T15:08:01.182Z
8598448 8598448 20251125005736_lmzu2 UK005Y 2025-11-26T14:19:07.355Z 2025-12-02T15:07:54.655Z
8597860 8597860 20251125001506_znKt9 UK005Y 2025-11-26T14:17:47.205Z 2025-12-02T15:07:41.184Z
8597630 8597630 20251124235322_UhF1I UK005Y 2025-11-26T14:17:13.735Z 2025-12-02T15:07:38.311Z
8597571 8597571 20251124234925_jXsTF UK005Y 2025-11-26T14:17:09.894Z 2025-12-02T15:07:37.810Z
8597134 8597134 20251124230534_xuhLn UK005Y 2025-11-26T14:16:15.189Z 2025-12-02T15:07:23.451Z
8596821 8596821 20251124221253_r2T6h UK005Y 2025-11-26T14:15:23.600Z 2025-12-02T15:07:15.145Z
8596589 8596589 20251124213617_xIThd UK005Y 2025-11-26T14:14:50.825Z 2025-12-02T15:07:03.158Z
8595951 8595951 20251124191119_N1RTC UK005Y 2025-11-26T14:13:03.107Z 2025-12-02T15:06:23.131Z
8595831 8595831 20251124183750_xvQfb UK005Y 2025-11-26T14:12:43.985Z 2025-12-02T15:06:14.495Z
8595635 8595635 20251124172634_5gnuD UK005Y 2025-11-26T14:11:50.522Z 2025-12-02T15:06:04.045Z
8592307 8592307 20251124063558_5IhFz UK005Y 2025-11-25T14:26:20.795Z 2025-12-02T15:13:03.124Z
8592302 8592302 20251124063509_LanBw UK005Y 2025-11-25T14:26:18.793Z 2025-12-02T15:13:03.100Z
8592100 8592100 20251124054801_1K8uc UK005Y 2025-11-25T14:25:52.470Z 2025-12-02T15:13:01.897Z
8588500 8588500 20251124000210_ZI0yV UK005Y 2025-11-25T14:17:39.685Z 2025-12-02T15:11:47.569Z
8569889 8569889 20251121062428_VmRVn UK005Y 2025-11-23T14:32:47.982Z 2025-11-29T14:54:49.235Z
8567983 8567983 20251121044807_3ho62 UK005Y 2025-11-23T14:30:18.139Z 2025-11-29T14:54:45.437Z
8567970 8567970 20251121044336_iRttw UK005Y 2025-11-23T14:30:10.528Z 2025-11-29T14:54:45.107Z
8567941 8567941 20251121042342_Wn6iA UK005Y 2025-11-23T14:29:31.772Z 2025-11-29T14:54:43.715Z
8567726 8567726 20251121020237_g4Zmd UK005Y 2025-11-23T14:27:36.455Z 2025-11-29T14:54:32.563Z
8567720 8567720 20251121014817_MFiq1 UK005Y 2025-11-23T14:27:16.685Z 2025-11-29T14:54:32.122Z
8567688 8567688 20251121013120_njbZr UK005Y 2025-11-23T14:27:04.892Z 2025-11-29T14:54:31.542Z
8567589 8567589 20251120234932_h0Rx3 UK005Y 2025-11-23T14:25:48.893Z 2025-11-29T14:54:27.066Z
8567509 8567509 20251120213534_SZaHJ UK005Y 2025-11-23T14:24:46.939Z 2025-11-29T14:54:23.739Z
8567493 8567493 20251120211027_FLnfa UK005Y 2025-11-23T14:24:38.218Z 2025-11-29T14:54:23.109Z
8567448 8567448 20251120193618_2W8Ln UK005Y 2025-11-23T14:23:38.735Z 2025-11-29T14:54:19.083Z
8553914 8553914 20251120061727_fzsCD UK005Y 2025-11-22T14:34:33.028Z 2025-11-28T14:58:37.876Z
8553835 8553835 20251120061020_txzH5 UK005Y 2025-11-22T14:34:30.098Z 2025-11-28T14:58:35.535Z
8553761 8553761 20251120060232_rcyfO UK005Y 2025-11-22T14:34:24.753Z 2025-11-28T14:58:34.249Z
8553716 8553716 20251120055914_T9ppF UK005Y 2025-11-22T14:34:10.407Z 2025-11-28T14:58:33.559Z
8553551 8553551 20251120054633_6UKCI UK005Y 2025-11-22T14:34:03.734Z 2025-11-28T14:58:23.237Z
8553349 8553349 20251120052607_KyK53 UK005Y 2025-11-22T14:33:51.526Z 2025-11-28T14:58:01.433Z
8552940 8552940 20251120044241_v5umZ UK005Y 2025-11-22T14:33:13.010Z 2025-11-28T14:57:46.544Z
8552936 8552936 20251120044138_Zr73G UK005Y 2025-11-22T14:33:12.833Z 2025-11-28T14:57:46.543Z
8552593 8552593 20251120041802_sGZDQ UK005Y 2025-11-22T14:32:33.000Z 2025-11-28T14:57:35.598Z
8552565 8552565 20251120041643_UCRTK UK005Y 2025-11-22T14:32:30.083Z 2025-11-28T14:57:35.165Z
8552563 8552563 20251120041628_QTrG3 UK005Y 2025-11-22T14:32:29.662Z 2025-11-28T14:57:35.114Z
8552352 8552352 20251120040130_MU33a UK005Y 2025-11-22T14:32:19.713Z 2025-11-28T14:57:30.567Z
8552267 8552267 20251120035357_Ql9iS UK005Y 2025-11-22T14:32:14.288Z 2025-11-28T14:57:28.553Z
8552189 8552189 20251120034639_JfvDH UK005Y 2025-11-22T14:31:57.240Z 2025-11-28T14:57:26.388Z
8552030 8552030 20251120032847_I86xG UK005Y 2025-11-22T14:31:43.171Z 2025-11-28T14:57:20.033Z
8552017 8552017 20251120032746_bDDNj UK005Y 2025-11-22T14:31:42.485Z 2025-11-28T14:57:19.730Z
8551966 8551966 20251120032509_TTV6y UK005Y 2025-11-22T14:31:40.514Z 2025-11-28T14:57:18.856Z
8541631 8541631 20251120023709_iNPKP UK005Y 2025-11-21T14:37:25.061Z 2025-11-28T14:56:57.322Z
8540810 8540810 20251120013432_IPlrY UK005Y 2025-11-21T14:36:58.718Z 2025-11-28T14:56:23.292Z
8540452 8540452 20251120010339_gyLbG UK005Y 2025-11-21T14:36:02.273Z 2025-11-28T14:56:12.013Z
8540175 8540175 20251120004306_ykNEA UK005Y 2025-11-21T14:35:54.163Z 2025-11-28T14:56:05.889Z
8539981 8539981 20251120002449_FIhDc UK005Y 2025-11-21T14:35:48.586Z 2025-11-28T14:56:02.738Z
8539941 8539941 20251120001728_iLate UK005Y 2025-11-21T14:35:47.190Z 2025-11-28T14:56:00.984Z
8539760 8539760 20251120000418_CXQxd UK005Y 2025-11-21T14:35:41.399Z 2025-11-28T14:55:55.324Z
8539644 8539644 20251119235401_hU4ub UK005Y 2025-11-21T14:35:37.594Z 2025-11-28T14:55:51.676Z
8539639 8539639 20251119235401_RSO7C UK005Y 2025-11-21T14:35:37.402Z 2025-11-28T14:55:51.675Z
8538765 8538765 20251119221823_n6XuZ UK005Y 2025-11-21T14:34:33.904Z 2025-11-28T14:55:37.475Z
8538634 8538634 20251119215928_B49TO UK005Y 2025-11-21T14:34:30.174Z 2025-11-28T14:55:35.659Z
8537488 8537488 20251119173752_G3Xq2 UK005Y 2025-11-21T14:32:06.366Z 2025-11-28T14:54:09.477Z
8529973 8529973 20251117043653_mtCEX UK005Y 2025-11-20T14:53:32.369Z 2025-11-25T15:10:13.449Z
8529971 8529971 20251117041319_bhMdX UK005Y 2025-11-20T14:53:24.084Z 2025-11-25T15:10:04.721Z
8529960 8529960 20251117014813_haO8K UK005Y 2025-11-20T14:52:10.345Z 2025-11-25T15:09:19.583Z
8529958 8529958 20251117014652_fB1Ls UK005Y 2025-11-20T14:52:08.512Z 2025-11-25T15:09:19.330Z
8529956 8529956 20251117011902_PXkAg UK005Y 2025-11-20T14:51:52.703Z 2025-11-25T15:09:01.891Z
8529950 8529950 20251117002649_2Tl9c UK005Y 2025-11-20T14:51:03.898Z 2025-11-25T15:08:52.055Z
8529938 8529938 20251116220735_I7oWM UK005Y 2025-11-20T14:50:38.500Z 2025-11-25T15:08:35.623Z
8529935 8529935 20251116214051_9dIO8 UK005Y 2025-11-20T14:50:36.750Z 2025-11-25T15:08:33.284Z
8529921 8529921 20251116191738_4FtYi UK005Y 2025-11-20T14:50:02.999Z 2025-11-25T15:08:13.794Z
8529203 8529203 20251119060655_ShWSw UK005Y 2025-11-20T14:44:45.053Z 2025-11-27T15:13:23.185Z
8529108 8529108 20251119055217_StCRp UK005Y 2025-11-20T14:44:41.740Z 2025-11-27T15:13:21.955Z
8529097 8529097 20251119055131_quUu2 UK005Y 2025-11-20T14:44:41.276Z 2025-11-27T15:13:21.898Z
8528944 8528944 20251119052949_l6D2G UK005Y 2025-11-20T14:44:23.729Z 2025-11-27T15:13:16.485Z
8528878 8528878 20251119051903_NwRSz UK005Y 2025-11-20T14:44:05.482Z 2025-11-27T15:13:15.827Z

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