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

5,802 rows where station_code = "UK00AB" 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
8683147 8683147 20251203063337_Tapz2 UK00AB 2025-12-04T14:18:38.667Z 2025-12-06T14:29:42.950Z
8683070 8683070 20251203062422_TyjnK UK00AB 2025-12-04T14:18:32.149Z 2025-12-06T14:29:41.009Z
8682798 8682798 20251203060404_Ku29G UK00AB 2025-12-04T14:18:01.822Z 2025-12-06T14:29:25.956Z
8682778 8682778 20251203060249_3Bvti UK00AB 2025-12-04T14:18:00.166Z 2025-12-06T14:29:24.878Z
8682719 8682719 20251203060047_qr6x3 UK00AB 2025-12-04T14:17:56.390Z 2025-12-06T14:29:23.611Z
8682600 8682600 20251203054821_AGwHp UK00AB 2025-12-04T14:17:40.545Z 2025-12-06T14:29:17.337Z
8682588 8682588 20251203054707_BrJi3 UK00AB 2025-12-04T14:17:39.573Z 2025-12-06T14:29:16.781Z
8682585 8682585 20251203054659_xQ0hp UK00AB 2025-12-04T14:17:37.914Z 2025-12-06T14:29:16.441Z
8682537 8682537 20251203054352_XoNdP UK00AB 2025-12-04T14:17:25.142Z 2025-12-06T14:29:13.985Z
8682468 8682468 20251203053812_z34iS UK00AB 2025-12-04T14:17:15.922Z 2025-12-06T14:29:04.162Z
8682394 8682394 20251203052443_Mi02K UK00AB 2025-12-04T14:17:05.491Z 2025-12-06T14:28:58.418Z
8682370 8682370 20251203052149_InERM UK00AB 2025-12-04T14:17:02.221Z 2025-12-06T14:28:56.927Z
8682312 8682312 20251203051538_yalU1 UK00AB 2025-12-04T14:16:48.249Z 2025-12-06T14:28:54.115Z
8682284 8682284 20251203051053_30b2M UK00AB 2025-12-04T14:16:44.009Z 2025-12-06T14:28:52.414Z
8682264 8682264 20251203050740_LBrNP UK00AB 2025-12-04T14:16:42.173Z 2025-12-06T14:28:51.464Z
8682256 8682256 20251203050730_exemh UK00AB 2025-12-04T14:16:41.538Z 2025-12-06T14:28:51.199Z
8682229 8682229 20251203050301_DLxFB UK00AB 2025-12-04T14:16:38.976Z 2025-12-06T14:28:50.458Z
8682164 8682164 20251203045618_nk6Z2 UK00AB 2025-12-04T14:16:32.140Z 2025-12-06T14:28:48.330Z
8682090 8682090 20251203044749_ZhTZU UK00AB 2025-12-04T14:16:25.064Z 2025-12-06T14:28:45.977Z
8682022 8682022 20251203044149_Z1dfP UK00AB 2025-12-04T14:16:13.637Z 2025-12-06T14:28:43.855Z
8682012 8682012 20251203044109_4G6t2 UK00AB 2025-12-04T14:16:10.241Z 2025-12-06T14:28:43.297Z
8681989 8681989 20251203043420_om892 UK00AB 2025-12-04T14:16:05.390Z 2025-12-06T14:28:41.737Z
8681959 8681959 20251203043348_dI3i0 UK00AB 2025-12-04T14:16:03.879Z 2025-12-06T14:28:41.211Z
8681929 8681929 20251203042848_gwDaN UK00AB 2025-12-04T14:16:01.688Z 2025-12-06T14:28:40.520Z
8681850 8681850 20251203041554_3ZcMh UK00AB 2025-12-04T14:15:47.422Z 2025-12-06T14:28:33.947Z
8681815 8681815 20251203041014_6p8pw UK00AB 2025-12-04T14:15:40.445Z 2025-12-06T14:28:32.310Z
8681784 8681784 20251203040514_AhCPZ UK00AB 2025-12-04T14:15:35.907Z 2025-12-06T14:28:31.209Z
8681723 8681723 20251203035035_JUZkf UK00AB 2025-12-04T14:15:21.135Z 2025-12-06T14:28:27.279Z
8681714 8681714 20251203034946_YnL5u UK00AB 2025-12-04T14:15:19.723Z 2025-12-06T14:28:26.900Z
8681629 8681629 20251203033319_o3FO4 UK00AB 2025-12-04T14:15:10.007Z 2025-12-06T14:28:21.600Z
8681538 8681538 20251203032248_5HhVl UK00AB 2025-12-04T14:15:00.687Z 2025-12-06T14:28:17.402Z
8681529 8681529 20251203032227_FAE3q UK00AB 2025-12-04T14:14:58.780Z 2025-12-06T14:28:16.907Z
8681463 8681463 20251203031246_0J0d3 UK00AB 2025-12-04T14:14:45.648Z 2025-12-06T14:28:13.219Z
8681366 8681366 20251203025919_kuJjd UK00AB 2025-12-04T14:14:34.093Z 2025-12-06T14:28:04.728Z
8680993 8680993 20251203021010_C7WPw UK00AB 2025-12-04T14:13:31.287Z 2025-12-06T14:27:43.473Z
8680989 8680989 20251203020755_iZEKE UK00AB 2025-12-04T14:13:31.092Z 2025-12-06T14:27:43.235Z
8680928 8680928 20251203015357_RbaTv UK00AB 2025-12-04T14:13:22.978Z 2025-12-06T14:27:33.379Z
8680922 8680922 20251203015317_lvpqf UK00AB 2025-12-04T14:13:22.018Z 2025-12-06T14:27:33.134Z
8680893 8680893 20251203014256_PXI7d UK00AB 2025-12-04T14:13:11.492Z 2025-12-06T14:27:32.089Z
8680797 8680797 20251203012149_Q3AX6 UK00AB 2025-12-04T14:12:57.130Z 2025-12-06T14:27:27.194Z
8680561 8680561 20251203003035_0cDKk UK00AB 2025-12-04T14:12:21.723Z 2025-12-06T14:27:17.770Z
8679004 8679004 20251202183228_3uouj UK00AB 2025-12-04T14:08:45.348Z 2025-12-06T14:25:49.060Z
8678830 8678830 20251202174415_m82b8 UK00AB 2025-12-04T14:08:19.029Z 2025-12-06T14:25:31.252Z
8677065 8677065 20251202064407_icCFz UK00AB 2025-12-03T14:26:15.762Z 2025-12-06T14:35:33.976Z
8676862 8676862 20251202062822_oafOS UK00AB 2025-12-03T14:25:53.881Z 2025-12-06T14:35:29.909Z
8676791 8676791 20251202062616_G0bKO UK00AB 2025-12-03T14:25:39.363Z 2025-12-06T14:35:28.844Z
8676597 8676597 20251202060505_OIxQJ UK00AB 2025-12-03T14:25:20.746Z 2025-12-06T14:35:24.284Z
8676563 8676563 20251202060214_VFmHF UK00AB 2025-12-03T14:25:19.017Z 2025-12-06T14:35:23.648Z
8676552 8676552 20251202060159_H4kHu UK00AB 2025-12-03T14:25:18.415Z 2025-12-06T14:35:23.493Z
8676391 8676391 20251202055102_AvoZv UK00AB 2025-12-03T14:25:10.783Z 2025-12-06T14:35:21.092Z
8676338 8676338 20251202054738_sxLcn UK00AB 2025-12-03T14:25:07.002Z 2025-12-06T14:35:20.339Z
8676230 8676230 20251202054219_tksdK UK00AB 2025-12-03T14:24:50.054Z 2025-12-06T14:35:19.070Z
8676147 8676147 20251202053846_pR7uL UK00AB 2025-12-03T14:24:46.848Z 2025-12-06T14:35:17.114Z
8676069 8676069 20251202053432_YwFeN UK00AB 2025-12-03T14:24:39.115Z 2025-12-06T14:35:07.495Z
8675973 8675973 20251202052755_89g4R UK00AB 2025-12-03T14:24:34.479Z 2025-12-06T14:35:06.145Z
8675886 8675886 20251202052136_8LnQC UK00AB 2025-12-03T14:24:28.935Z 2025-12-06T14:35:04.189Z
8675862 8675862 20251202051859_Op3qC UK00AB 2025-12-03T14:24:26.545Z 2025-12-06T14:35:03.505Z
8675779 8675779 20251202051410_c0ChF UK00AB 2025-12-03T14:24:14.919Z 2025-12-06T14:34:59.769Z
8675766 8675766 20251202051247_kJqhV UK00AB 2025-12-03T14:24:14.300Z 2025-12-06T14:34:59.617Z
8675578 8675578 20251202045712_PzSvr UK00AB 2025-12-03T14:23:52.459Z 2025-12-06T14:34:56.548Z
8675428 8675428 20251202043834_1459X UK00AB 2025-12-03T14:23:42.595Z 2025-12-06T14:34:52.687Z
8675399 8675399 20251202043526_LkBOe UK00AB 2025-12-03T14:23:40.166Z 2025-12-06T14:34:51.242Z
8675368 8675368 20251202043223_zmvpC UK00AB 2025-12-03T14:23:34.350Z 2025-12-06T14:34:50.540Z
8675337 8675337 20251202042952_ijeLw UK00AB 2025-12-03T14:23:31.906Z 2025-12-06T14:34:49.686Z
8675268 8675268 20251202042529_Fh9Zp UK00AB 2025-12-03T14:23:27.901Z 2025-12-06T14:34:48.615Z
8673835 8673835 20251201235707_0HWib UK00AB 2025-12-03T14:20:09.985Z 2025-12-06T14:33:37.080Z
8668066 8668066 20251130055157_nDC3O UK00AB 2025-12-02T14:41:48.228Z 2025-12-06T14:50:08.781Z
8667971 8667971 20251130053258_6yC3W UK00AB 2025-12-02T14:41:25.528Z 2025-12-06T14:49:45.555Z
8667950 8667950 20251130052350_wB3yL UK00AB 2025-12-02T14:41:22.630Z 2025-12-06T14:49:43.915Z
8667842 8667842 20251130042847_nQjzY UK00AB 2025-12-02T14:40:35.540Z 2025-12-06T14:49:29.507Z
8667782 8667782 20251130040130_DwFmV UK00AB 2025-12-02T14:40:21.828Z 2025-12-06T14:49:15.053Z
8667687 8667687 20251130031909_DhZfU UK00AB 2025-12-02T14:39:44.227Z 2025-12-06T14:48:43.616Z
8667683 8667683 20251130031742_4r358 UK00AB 2025-12-02T14:39:42.312Z 2025-12-06T14:48:42.920Z
8667611 8667611 20251130024836_h7OE5 UK00AB 2025-12-02T14:39:26.888Z 2025-12-06T14:48:34.918Z
8667608 8667608 20251130024805_XJ5t7 UK00AB 2025-12-02T14:39:26.070Z 2025-12-06T14:48:34.478Z
8667553 8667553 20251130021126_I3thj UK00AB 2025-12-02T14:38:51.747Z 2025-12-06T14:47:56.229Z
8667551 8667551 20251130021121_gLH5r UK00AB 2025-12-02T14:38:51.619Z 2025-12-06T14:47:56.172Z
8667509 8667509 20251130020100_bqpj2 UK00AB 2025-12-02T14:38:44.647Z 2025-12-06T14:47:50.944Z
8667457 8667457 20251130013707_m7ssz UK00AB 2025-12-02T14:38:18.589Z 2025-12-06T14:47:43.196Z
8667398 8667398 20251130010109_YEHsy UK00AB 2025-12-02T14:37:58.544Z 2025-12-06T14:47:33.291Z
8667392 8667392 20251130005620_dNhy0 UK00AB 2025-12-02T14:37:56.491Z 2025-12-06T14:47:32.064Z
8667387 8667387 20251130004808_iy4FM UK00AB 2025-12-02T14:37:38.192Z 2025-12-06T14:47:17.796Z
8667385 8667385 20251130004507_N2Lal UK00AB 2025-12-02T14:37:37.305Z 2025-12-06T14:47:13.253Z
8667371 8667371 20251130002509_TG2j3 UK00AB 2025-12-02T14:37:28.187Z 2025-12-06T14:46:55.011Z
8667369 8667369 20251130002302_bWeFA UK00AB 2025-12-02T14:37:27.444Z 2025-12-06T14:46:54.583Z
8667328 8667328 20251129234421_9Omz7 UK00AB 2025-12-02T14:37:15.221Z 2025-12-06T14:46:47.017Z
8667318 8667318 20251129233520_6iLz3 UK00AB 2025-12-02T14:37:12.167Z 2025-12-06T14:46:45.267Z
8667312 8667312 20251129231640_3a4IW UK00AB 2025-12-02T14:36:52.797Z 2025-12-06T14:46:42.945Z
8658671 8658671 20251125052317_mezxX UK00AB 2025-12-01T15:12:23.031Z 2025-12-02T15:09:32.961Z
8636550 8636550 20251128040003_WuUlF UK00AB 2025-11-29T14:25:39.366Z 2025-12-06T15:03:26.754Z
8636414 8636414 20251128034314_XjLoW UK00AB 2025-11-29T14:25:28.378Z 2025-12-06T15:03:15.402Z
8636321 8636321 20251128033701_SiEw9 UK00AB 2025-11-29T14:25:23.094Z 2025-12-06T15:03:07.370Z
8636288 8636288 20251128033222_zsIQh UK00AB 2025-11-29T14:25:20.664Z 2025-12-06T15:03:03.622Z
8635804 8635804 20251128024917_pZkyd UK00AB 2025-11-29T14:24:10.770Z 2025-12-06T15:02:52.305Z
8635589 8635589 20251128022835_kMbrA UK00AB 2025-11-29T14:23:51.556Z 2025-12-06T15:02:46.898Z
8635112 8635112 20251128014223_BZsIc UK00AB 2025-11-29T14:22:41.252Z 2025-12-06T15:02:40.718Z
8634900 8634900 20251128012517_DKb3h UK00AB 2025-11-29T14:22:10.495Z 2025-12-06T15:02:37.283Z
8634692 8634692 20251128011041_w5NtP UK00AB 2025-11-29T14:21:56.277Z 2025-12-06T15:02:30.141Z
8634593 8634593 20251128010124_54ztf UK00AB 2025-11-29T14:21:35.679Z 2025-12-06T15:02:23.110Z
8634506 8634506 20251128005447_FQWBt UK00AB 2025-11-29T14:21:25.374Z 2025-12-06T15:02:07.245Z

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