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,713 rows where station_code = "UK0070" 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
9272975 9272975 20260128041333_sPwFt UK0070 2026-01-29T14:28:21.069Z 2026-01-29T14:30:25.727Z
9272848 9272848 20260128034454_3WVyt UK0070 2026-01-29T14:28:02.091Z 2026-01-29T14:30:25.581Z
9271900 9271900 20260127214256_dZAVh UK0070 2026-01-29T14:24:53.421Z 2026-01-29T14:30:25.227Z
9259565 9259565 20260124213009_0Q9Ki UK0070 2026-01-26T14:17:28.818Z 2026-01-29T14:43:06.466Z
9256236 9256236 20260124062546_CcxcZ UK0070 2026-01-25T14:16:16.802Z 2026-01-29T14:48:30.352Z
9256119 9256119 20260124055909_eXz27 UK0070 2026-01-25T14:15:55.040Z 2026-01-29T14:48:24.340Z
9255901 9255901 20260124051524_jBzms UK0070 2026-01-25T14:15:06.035Z 2026-01-29T14:48:06.701Z
9255771 9255771 20260124045257_8qjCq UK0070 2026-01-25T14:14:39.451Z 2026-01-29T14:47:56.641Z
9255655 9255655 20260124042456_qQzBV UK0070 2026-01-25T14:14:12.892Z 2026-01-29T14:47:49.520Z
9255622 9255622 20260124042222_2wggX UK0070 2026-01-25T14:14:07.908Z 2026-01-29T14:47:45.615Z
9255358 9255358 20260124030347_hrML4 UK0070 2026-01-25T14:13:03.091Z 2026-01-29T14:47:25.856Z
9255298 9255298 20260124024049_hTFCM UK0070 2026-01-25T14:12:45.588Z 2026-01-29T14:47:22.163Z
9255280 9255280 20260124023032_PYBWT UK0070 2026-01-25T14:12:39.584Z 2026-01-29T14:47:17.815Z
9255249 9255249 20260124021043_aLAI4 UK0070 2026-01-25T14:12:31.956Z 2026-01-29T14:47:12.197Z
9255226 9255226 20260124015404_4nf16 UK0070 2026-01-25T14:12:27.154Z 2026-01-29T14:47:11.209Z
9255223 9255223 20260124015400_EorFu UK0070 2026-01-25T14:12:26.536Z 2026-01-29T14:47:11.123Z
9255083 9255083 20260124004504_pQKwC UK0070 2026-01-25T14:11:50.605Z 2026-01-29T14:47:01.661Z
9255024 9255024 20260124002628_iOr35 UK0070 2026-01-25T14:11:39.553Z 2026-01-29T14:46:59.991Z
9255000 9255000 20260124001003_awVGz UK0070 2026-01-25T14:11:36.425Z 2026-01-29T14:46:59.305Z
9254935 9254935 20260123231822_Aa5QU UK0070 2026-01-25T14:11:22.475Z 2026-01-29T14:46:56.246Z
9252303 9252303 20260123020804_NDv3l UK0070 2026-01-24T14:15:00.429Z 2026-01-29T14:52:44.377Z
9244149 9244149 20260121062406_aChic UK0070 2026-01-22T14:24:17.837Z 2026-01-29T15:05:53.800Z
9243978 9243978 20260121054704_NIcR6 UK0070 2026-01-22T14:23:41.768Z 2026-01-29T15:05:37.310Z
9243904 9243904 20260121053133_WZa6G UK0070 2026-01-22T14:23:29.196Z 2026-01-29T15:05:34.041Z
9243888 9243888 20260121053025_bMU6n UK0070 2026-01-22T14:23:27.778Z 2026-01-29T15:05:32.283Z
9243861 9243861 20260121052708_2le1Y UK0070 2026-01-22T14:23:23.189Z 2026-01-29T15:05:30.551Z
9243728 9243728 20260121051126_WpNVv UK0070 2026-01-22T14:22:51.781Z 2026-01-29T15:05:25.252Z
9243722 9243722 20260121051102_9W0ME UK0070 2026-01-22T14:22:50.691Z 2026-01-29T15:05:24.967Z
9243650 9243650 20260121050052_V5oZ2 UK0070 2026-01-22T14:22:39.826Z 2026-01-29T15:05:21.751Z
9243641 9243641 20260121045829_cN4CX UK0070 2026-01-22T14:22:35.266Z 2026-01-29T15:05:21.169Z
9243613 9243613 20260121045206_B1jXo UK0070 2026-01-22T14:22:25.302Z 2026-01-29T15:05:19.995Z
9243575 9243575 20260121044842_q0H9o UK0070 2026-01-22T14:22:14.237Z 2026-01-29T15:05:18.351Z
9243541 9243541 20260121044734_RJKzb UK0070 2026-01-22T14:22:10.210Z 2026-01-29T15:05:17.350Z
9243532 9243532 20260121044644_kPC8Q UK0070 2026-01-22T14:22:09.673Z 2026-01-29T15:05:17.186Z
9243525 9243525 20260121044616_OpnF1 UK0070 2026-01-22T14:22:09.065Z 2026-01-29T15:05:17.039Z
9243241 9243241 20260121040526_QQ7iD UK0070 2026-01-22T14:21:07.194Z 2026-01-29T15:04:52.449Z
9243108 9243108 20260121034323_ZR1WR UK0070 2026-01-22T14:20:35.566Z 2026-01-29T15:04:46.812Z
9243089 9243089 20260121034149_DhFw3 UK0070 2026-01-22T14:20:32.511Z 2026-01-29T15:04:46.133Z
9243076 9243076 20260121034111_YliDK UK0070 2026-01-22T14:20:31.996Z 2026-01-29T15:04:46.042Z
9237974 9237974 20260120064237_lpgVG UK0070 2026-01-21T14:28:10.584Z 2026-01-28T15:02:01.427Z
9231111 9231111 20260119060517_P3JSQ UK0070 2026-01-20T14:31:22.121Z 2026-01-27T15:05:59.094Z
9231064 9231064 20260119055231_FZc8S UK0070 2026-01-20T14:31:05.512Z 2026-01-27T15:05:56.028Z
9230868 9230868 20260119051955_iBzoY UK0070 2026-01-20T14:30:09.144Z 2026-01-27T15:05:33.778Z
9230779 9230779 20260119050552_F3vCR UK0070 2026-01-20T14:29:43.477Z 2026-01-27T15:05:25.995Z
9222827 9222827 20260117210018_0P2WB UK0070 2026-01-19T14:16:26.236Z 2026-01-26T15:01:22.555Z
9218050 9218050 20260116225925_USlOC UK0070 2026-01-18T14:10:11.013Z 2026-01-25T14:57:56.692Z
9217823 9217823 20260116195921_UFsyy UK0070 2026-01-18T14:09:09.831Z 2026-01-25T14:57:48.943Z
9217633 9217633 20260116183938_iSV23 UK0070 2026-01-18T14:08:15.695Z 2026-01-25T14:57:28.630Z
9213814 9213814 20260116044634_f3ywz UK0070 2026-01-17T14:18:40.605Z 2026-01-24T15:12:47.729Z
9213721 9213721 20260116043043_GtwY3 UK0070 2026-01-17T14:18:15.082Z 2026-01-24T15:12:32.203Z
9213646 9213646 20260116041706_YbqUX UK0070 2026-01-17T14:17:57.295Z 2026-01-24T15:12:29.785Z
9213621 9213621 20260116040849_U1nfk UK0070 2026-01-17T14:17:47.778Z 2026-01-24T15:12:25.502Z
9213609 9213609 20260116040831_SlzSq UK0070 2026-01-17T14:17:44.882Z 2026-01-24T15:12:24.593Z
9213586 9213586 20260116040514_2TZcG UK0070 2026-01-17T14:17:40.527Z 2026-01-24T15:12:23.399Z
9213472 9213472 20260116034505_Jv1Hu UK0070 2026-01-17T14:17:06.654Z 2026-01-24T15:12:16.563Z
9213468 9213468 20260116034406_2LKeS UK0070 2026-01-17T14:17:06.052Z 2026-01-24T15:12:16.195Z
9213358 9213358 20260116031705_LhEsG UK0070 2026-01-17T14:16:36.671Z 2026-01-24T15:12:10.674Z
9213261 9213261 20260116025323_I2oLw UK0070 2026-01-17T14:16:12.231Z 2026-01-24T15:12:06.223Z
9213255 9213255 20260116025314_PdgGh UK0070 2026-01-17T14:16:11.084Z 2026-01-24T15:12:02.534Z
9212500 9212500 20260115222024_BH5OC UK0070 2026-01-17T14:12:16.059Z 2026-01-24T15:10:58.356Z
9208766 9208766 20260115064405_PJvQq UK0070 2026-01-16T14:13:54.114Z 2026-01-22T15:04:39.330Z
9208753 9208753 20260115064135_cf3Ym UK0070 2026-01-16T14:13:50.664Z 2026-01-22T15:04:38.946Z
9208389 9208389 20260115051502_Z7Jeo UK0070 2026-01-16T14:12:29.124Z 2026-01-22T15:04:12.253Z
9208357 9208357 20260115051134_6pTgb UK0070 2026-01-16T14:12:19.857Z 2026-01-22T15:04:11.197Z
9208315 9208315 20260115050204_TYqHx UK0070 2026-01-16T14:12:07.608Z 2026-01-22T15:04:07.161Z
9208294 9208294 20260115045827_7BZkW UK0070 2026-01-16T14:12:02.974Z 2026-01-22T15:04:06.731Z
9208268 9208268 20260115045010_Ujrwa UK0070 2026-01-16T14:11:57.702Z 2026-01-22T15:04:05.923Z
9208160 9208160 20260115042237_aQUxK UK0070 2026-01-16T14:11:33.819Z 2026-01-22T15:04:02.688Z
9208127 9208127 20260115041813_2FMUk UK0070 2026-01-16T14:11:24.866Z 2026-01-22T15:04:02.003Z
9208053 9208053 20260115040601_BEnzn UK0070 2026-01-16T14:11:09.000Z 2026-01-22T15:03:59.908Z
9208006 9208006 20260115035419_Vta9R UK0070 2026-01-16T14:10:58.232Z 2026-01-22T15:03:58.483Z
9207676 9207676 20260115024110_HjYKk UK0070 2026-01-16T14:09:37.874Z 2026-01-22T15:03:29.626Z
9207618 9207618 20260115022948_wcmUv UK0070 2026-01-16T14:09:25.260Z 2026-01-22T15:03:28.100Z
9207554 9207554 20260115021532_LeJ18 UK0070 2026-01-16T14:09:13.932Z 2026-01-22T15:03:24.883Z
9207484 9207484 20260115014926_W0t3D UK0070 2026-01-16T14:08:57.475Z 2026-01-22T15:03:23.023Z
9207462 9207462 20260115014357_An0LJ UK0070 2026-01-16T14:08:51.313Z 2026-01-22T15:03:22.510Z
9207381 9207381 20260115011922_C0uhy UK0070 2026-01-16T14:08:31.801Z 2026-01-22T15:03:20.422Z
9207379 9207379 20260115011829_UgBIq UK0070 2026-01-16T14:08:31.094Z 2026-01-22T15:03:20.329Z
9204452 9204452 20260114064408_fLKCd UK0070 2026-01-15T14:27:24.144Z 2026-01-22T15:10:28.522Z
9204154 9204154 20260114061059_lJIua UK0070 2026-01-15T14:26:31.491Z 2026-01-22T15:10:21.172Z
9204067 9204067 20260114060516_lC2rr UK0070 2026-01-15T14:26:20.784Z 2026-01-22T15:10:17.619Z
9204042 9204042 20260114060430_PGvrP UK0070 2026-01-15T14:26:18.936Z 2026-01-22T15:10:17.334Z
9203809 9203809 20260114053756_Wkz4u UK0070 2026-01-15T14:25:25.779Z 2026-01-22T15:10:13.710Z
9203722 9203722 20260114053054_KXRbz UK0070 2026-01-15T14:25:13.881Z 2026-01-22T15:10:12.564Z
9203319 9203319 20260114045027_qyXsS UK0070 2026-01-15T14:24:03.483Z 2026-01-22T15:10:05.701Z
9203094 9203094 20260114043249_jetAf UK0070 2026-01-15T14:23:17.615Z 2026-01-22T15:10:01.407Z
9202867 9202867 20260114041403_oVo5B UK0070 2026-01-15T14:22:40.389Z 2026-01-22T15:09:58.293Z
9202734 9202734 20260114040637_kfNnc UK0070 2026-01-15T14:22:16.406Z 2026-01-22T15:09:34.290Z
9202522 9202522 20260114034432_FOhnA UK0070 2026-01-15T14:21:34.365Z 2026-01-22T15:09:21.688Z
9202449 9202449 20260114033811_gHrAD UK0070 2026-01-15T14:21:19.310Z 2026-01-22T15:09:19.389Z
9202079 9202079 20260114031524_VA9xk UK0070 2026-01-15T14:20:23.734Z 2026-01-22T15:09:13.183Z
9202005 9202005 20260114031001_9Nbwj UK0070 2026-01-15T14:20:14.092Z 2026-01-22T15:09:12.024Z
9201259 9201259 20260114020217_TyLM9 UK0070 2026-01-15T14:18:06.102Z 2026-01-22T15:09:00.678Z
9200098 9200098 20260113225110_vvXgm UK0070 2026-01-15T14:13:45.979Z 2026-01-22T15:08:09.554Z
9199961 9199961 20260113220438_9Vpnp UK0070 2026-01-15T14:13:12.549Z 2026-01-22T15:08:06.571Z
9198729 9198729 20260113174501_x5voj UK0070 2026-01-15T14:06:46.276Z 2026-01-22T15:07:02.138Z
9195908 9195908 20260113032359_VjQxK UK0070 2026-01-14T14:15:32.685Z 2026-01-21T15:04:49.542Z
9195692 9195692 20260113022018_lmOCs UK0070 2026-01-14T14:14:24.130Z 2026-01-21T15:04:45.671Z
9195371 9195371 20260113011330_K2N2w UK0070 2026-01-14T14:13:05.908Z 2026-01-21T15:04:39.646Z
9195338 9195338 20260113010537_FL4t6 UK0070 2026-01-14T14:12:55.672Z 2026-01-21T15:04:39.191Z

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