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

8,049 rows where station_code = "UK0057" 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
9234360 9234360 20260119210002_uPH2x UK0057 2026-01-21T14:13:58.514Z 2026-01-28T14:57:33.153Z
9234056 9234056 20260119192642_0RzNu UK0057 2026-01-21T14:12:03.299Z 2026-01-28T14:57:01.448Z
9233902 9233902 20260119184225_TiqNZ UK0057 2026-01-21T14:11:17.376Z 2026-01-28T14:56:51.948Z
9231252 9231252 20260119065453_v4b9Q UK0057 2026-01-20T14:32:01.959Z 2026-01-27T15:06:09.890Z
9231249 9231249 20260119065245_Z3SVy UK0057 2026-01-20T14:32:01.457Z 2026-01-27T15:06:09.720Z
9231224 9231224 20260119063938_tvoAX UK0057 2026-01-20T14:31:54.992Z 2026-01-27T15:06:07.822Z
9231175 9231175 20260119062036_f7u74 UK0057 2026-01-20T14:31:40.922Z 2026-01-27T15:06:03.612Z
9231145 9231145 20260119061137_mcbCD UK0057 2026-01-20T14:31:33.019Z 2026-01-27T15:06:01.346Z
9231141 9231141 20260119061104_OG23g UK0057 2026-01-20T14:31:31.760Z 2026-01-27T15:06:01.059Z
9231109 9231109 20260119060418_BMIRp UK0057 2026-01-20T14:31:21.475Z 2026-01-27T15:05:58.955Z
9230896 9230896 20260119052650_uhZcm UK0057 2026-01-20T14:30:17.354Z 2026-01-27T15:05:35.358Z
9230826 9230826 20260119051447_26xAY UK0057 2026-01-20T14:29:58.837Z 2026-01-27T15:05:29.101Z
9224921 9224921 20260118064413_fpu9e UK0057 2026-01-19T14:26:49.468Z 2026-01-26T15:03:54.735Z
9224902 9224902 20260118064048_NWnET UK0057 2026-01-19T14:26:44.868Z 2026-01-26T15:03:53.974Z
9224887 9224887 20260118063647_koLU1 UK0057 2026-01-19T14:26:35.304Z 2026-01-26T15:03:53.232Z
9224815 9224815 20260118060839_BfyBR UK0057 2026-01-19T14:26:15.316Z 2026-01-26T15:03:49.943Z
9224770 9224770 20260118060109_LX4Rt UK0057 2026-01-19T14:25:54.475Z 2026-01-26T15:03:48.610Z
9224666 9224666 20260118053553_xjfKW UK0057 2026-01-19T14:25:25.499Z 2026-01-26T15:03:44.899Z
9224654 9224654 20260118053053_NLT94 UK0057 2026-01-19T14:25:23.234Z 2026-01-26T15:03:44.337Z
9224650 9224650 20260118053018_gq1GG UK0057 2026-01-19T14:25:18.884Z 2026-01-26T15:03:44.064Z
9224546 9224546 20260118051108_3gkn1 UK0057 2026-01-19T14:24:51.974Z 2026-01-26T15:03:23.240Z
9224336 9224336 20260118042148_ypVjU UK0057 2026-01-19T14:23:55.220Z 2026-01-26T15:03:14.666Z
9224315 9224315 20260118041630_FHqcv UK0057 2026-01-19T14:23:48.900Z 2026-01-26T15:03:13.169Z
9217834 9217834 20260116200444_lOQWd UK0057 2026-01-18T14:09:12.483Z 2026-01-25T14:57:49.218Z
9217780 9217780 20260116194554_B8Xpu UK0057 2026-01-18T14:08:59.060Z 2026-01-25T14:57:47.564Z
9217776 9217776 20260116194431_CDbmr UK0057 2026-01-18T14:08:57.530Z 2026-01-25T14:57:47.327Z
9217770 9217770 20260116194059_mVBnt UK0057 2026-01-18T14:08:55.812Z 2026-01-25T14:57:47.127Z
9217655 9217655 20260116185513_U4Z31 UK0057 2026-01-18T14:08:23.253Z 2026-01-25T14:57:35.477Z
9217561 9217561 20260116175627_MGok2 UK0057 2026-01-18T14:07:54.878Z 2026-01-25T14:57:26.197Z
9214515 9214515 20260116064727_Ot2i6 UK0057 2026-01-17T14:21:50.439Z 2026-01-24T15:13:46.540Z
9214464 9214464 20260116063910_XmhNe UK0057 2026-01-17T14:21:37.462Z 2026-01-24T15:13:38.588Z
9214431 9214431 20260116063354_xQvgz UK0057 2026-01-17T14:21:31.544Z 2026-01-24T15:13:37.099Z
9214422 9214422 20260116063238_41OeR UK0057 2026-01-17T14:21:29.247Z 2026-01-24T15:13:36.495Z
9214403 9214403 20260116062817_uyKA1 UK0057 2026-01-17T14:21:21.642Z 2026-01-24T15:13:35.027Z
9214315 9214315 20260116061503_h2LSN UK0057 2026-01-17T14:21:03.397Z 2026-01-24T15:13:29.650Z
9214313 9214313 20260116061339_Eeq7c UK0057 2026-01-17T14:21:02.597Z 2026-01-24T15:13:29.543Z
9214262 9214262 20260116060249_CbUy8 UK0057 2026-01-17T14:20:48.424Z 2026-01-24T15:13:26.806Z
9214144 9214144 20260116054721_CoxSV UK0057 2026-01-17T14:20:19.481Z 2026-01-24T15:13:17.823Z
9214078 9214078 20260116053223_oPsSG UK0057 2026-01-17T14:19:59.210Z 2026-01-24T15:13:04.473Z
9214073 9214073 20260116053137_WKbUx UK0057 2026-01-17T14:19:58.051Z 2026-01-24T15:13:04.132Z
9213934 9213934 20260116050243_uvwOG UK0057 2026-01-17T14:19:13.873Z 2026-01-24T15:12:52.199Z
9213771 9213771 20260116043807_8Pc28 UK0057 2026-01-17T14:18:25.435Z 2026-01-24T15:12:45.894Z
9213569 9213569 20260116040455_N6oTM UK0057 2026-01-17T14:17:38.524Z 2026-01-24T15:12:23.019Z
9213565 9213565 20260116040242_l1SUu UK0057 2026-01-17T14:17:37.516Z 2026-01-24T15:12:22.794Z
9213546 9213546 20260116040031_ngsFH UK0057 2026-01-17T14:17:28.631Z 2026-01-24T15:12:21.314Z
9213463 9213463 20260116034311_jlED6 UK0057 2026-01-17T14:17:01.999Z 2026-01-24T15:12:15.844Z
9213445 9213445 20260116033328_3RwRH UK0057 2026-01-17T14:16:56.616Z 2026-01-24T15:12:14.605Z
9213427 9213427 20260116033004_fm3cu UK0057 2026-01-17T14:16:51.647Z 2026-01-24T15:12:13.485Z
9213349 9213349 20260116031634_366Kb UK0057 2026-01-17T14:16:34.694Z 2026-01-24T15:12:10.337Z
9213246 9213246 20260116024656_BO6Ac UK0057 2026-01-17T14:16:04.973Z 2026-01-24T15:11:51.368Z
9213157 9213157 20260116022848_SzxnO UK0057 2026-01-17T14:15:42.787Z 2026-01-24T15:11:47.363Z
9213138 9213138 20260116022423_IbYxP UK0057 2026-01-17T14:15:36.619Z 2026-01-24T15:11:44.195Z
9213128 9213128 20260116021940_na5ow UK0057 2026-01-17T14:15:33.628Z 2026-01-24T15:11:43.367Z
9213115 9213115 20260116021642_fHk9k UK0057 2026-01-17T14:15:30.687Z 2026-01-24T15:11:42.559Z
9213089 9213089 20260116020928_UcRYr UK0057 2026-01-17T14:15:23.360Z 2026-01-24T15:11:40.218Z
9213057 9213057 20260116020424_yZbxx UK0057 2026-01-17T14:15:12.140Z 2026-01-24T15:11:38.892Z
9212916 9212916 20260116013753_zytaH UK0057 2026-01-17T14:14:32.702Z 2026-01-24T15:11:34.004Z
9212794 9212794 20260116010204_Pcw1t UK0057 2026-01-17T14:13:57.263Z 2026-01-24T15:11:26.984Z
9212764 9212764 20260116005301_YkSty UK0057 2026-01-17T14:13:44.274Z 2026-01-24T15:11:25.576Z
9212758 9212758 20260116005246_31Quh UK0057 2026-01-17T14:13:41.918Z 2026-01-24T15:11:25.325Z
9212737 9212737 20260116004318_xeMNm UK0057 2026-01-17T14:13:33.470Z 2026-01-24T15:11:24.326Z
9212701 9212701 20260116002922_fCMBE UK0057 2026-01-17T14:13:24.694Z 2026-01-24T15:11:10.729Z
9212646 9212646 20260116000333_gxxhz UK0057 2026-01-17T14:13:07.038Z 2026-01-24T15:11:08.781Z
9212569 9212569 20260115231430_rBvzg UK0057 2026-01-17T14:12:44.297Z 2026-01-24T15:11:03.760Z
9212497 9212497 20260115221847_osoZZ UK0057 2026-01-17T14:12:15.103Z 2026-01-24T15:10:58.012Z
9212455 9212455 20260115213334_jaT3Q UK0057 2026-01-17T14:11:57.805Z 2026-01-24T15:10:55.416Z
9212299 9212299 20260115202424_A7WSa UK0057 2026-01-17T14:11:05.477Z 2026-01-24T15:10:46.587Z
9212256 9212256 20260115201058_slfOH UK0057 2026-01-17T14:10:53.964Z 2026-01-24T15:10:44.987Z
9211944 9211944 20260115182932_V7Gjp UK0057 2026-01-17T14:09:08.495Z 2026-01-24T15:10:12.952Z
9211919 9211919 20260115182214_n67Jr UK0057 2026-01-17T14:09:02.193Z 2026-01-24T15:10:11.045Z
9208832 9208832 20260115070306_wvgrG UK0057 2026-01-16T14:14:09.809Z 2026-01-22T15:04:41.451Z
9208830 9208830 20260115070127_kBR2B UK0057 2026-01-16T14:14:09.341Z 2026-01-22T15:04:41.369Z
9201819 9201819 20260114025731_6xEVw UK0057 2026-01-15T14:19:48.304Z 2026-01-22T15:09:10.194Z
9201320 9201320 20260114021016_eaFLM UK0057 2026-01-15T14:18:15.551Z 2026-01-22T15:09:01.869Z
9200996 9200996 20260114012855_N5Gy9 UK0057 2026-01-15T14:17:11.202Z 2026-01-22T15:08:47.459Z
9200976 9200976 20260114012625_N9Ty2 UK0057 2026-01-15T14:17:07.754Z 2026-01-22T15:08:41.138Z
9200937 9200937 20260114012405_Tzu73 UK0057 2026-01-15T14:17:04.005Z 2026-01-22T15:08:39.891Z
9200720 9200720 20260114005702_N8VNO UK0057 2026-01-15T14:16:13.442Z 2026-01-22T15:08:24.634Z
9200625 9200625 20260114003805_YdDKk UK0057 2026-01-15T14:15:48.920Z 2026-01-22T15:08:22.153Z
9200466 9200466 20260114001245_KFdjq UK0057 2026-01-15T14:15:16.099Z 2026-01-22T15:08:16.406Z
9200396 9200396 20260113235851_KpKtW UK0057 2026-01-15T14:15:00.452Z 2026-01-22T15:08:15.308Z
9200212 9200212 20260113231135_7durH UK0057 2026-01-15T14:14:12.482Z 2026-01-22T15:08:11.421Z
9200036 9200036 20260113223849_NjL15 UK0057 2026-01-15T14:13:36.962Z 2026-01-22T15:08:08.407Z
9199727 9199727 20260113210809_HBYqb UK0057 2026-01-15T14:12:09.008Z 2026-01-22T15:08:00.592Z
9199553 9199553 20260113202339_rZY3C UK0057 2026-01-15T14:11:27.393Z 2026-01-22T15:07:29.041Z
9199547 9199547 20260113202118_fqzUp UK0057 2026-01-15T14:11:26.348Z 2026-01-22T15:07:26.596Z
9199410 9199410 20260113195614_Dd2tP UK0057 2026-01-15T14:10:45.233Z 2026-01-22T15:07:23.675Z
9198889 9198889 20260113182403_Fchhz UK0057 2026-01-15T14:07:57.653Z 2026-01-22T15:07:07.988Z
9195949 9195949 20260113033835_fvBip UK0057 2026-01-14T14:15:42.299Z 2026-01-21T15:04:50.704Z
9195583 9195583 20260113015402_tn2r0 UK0057 2026-01-14T14:13:56.283Z 2026-01-21T15:04:42.641Z
9195007 9195007 20260112235831_3VMHz UK0057 2026-01-14T14:11:41.471Z 2026-01-21T15:04:35.085Z
9194073 9194073 20260112173055_28Lt4 UK0057 2026-01-14T14:07:06.542Z 2026-01-21T15:03:27.934Z
9188865 9188865 20260112020825_egbSk UK0057 2026-01-13T14:14:35.436Z 2026-01-20T15:22:27.018Z
9188741 9188741 20260112013813_mpICv UK0057 2026-01-13T14:13:59.998Z 2026-01-20T15:22:09.536Z
9179789 9179789 20260110174341_O8iHZ UK0057 2026-01-12T14:04:19.866Z 2026-01-19T15:15:16.109Z
9171629 9171629 20260109000238_Cf38n UK0057 2026-01-10T14:08:33.254Z 2026-01-17T15:24:11.693Z
9171120 9171120 20260108192444_dlVsU UK0057 2026-01-10T14:05:24.981Z 2026-01-17T15:23:24.702Z
9167900 9167900 20260108063916_vVUfi UK0057 2026-01-09T14:09:45.064Z 2026-01-16T15:11:59.666Z
9167858 9167858 20260108054858_UtLvy UK0057 2026-01-09T14:09:33.093Z 2026-01-16T15:11:56.699Z
9167856 9167856 20260108054845_NU1DV UK0057 2026-01-09T14:09:32.545Z 2026-01-16T15:11:56.531Z

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