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

4,462 rows where station_code = "UK008S" 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
8683283 8683283 20251203065114_JU8xK UK008S 2025-12-04T14:19:04.431Z 2025-12-06T14:29:49.356Z
8683271 8683271 20251203064853_1u66r UK008S 2025-12-04T14:19:02.917Z 2025-12-06T14:29:48.859Z
8683235 8683235 20251203064415_MOYcr UK008S 2025-12-04T14:18:58.637Z 2025-12-06T14:29:47.033Z
8683157 8683157 20251203063341_RLR8q UK008S 2025-12-04T14:18:39.722Z 2025-12-06T14:29:43.228Z
8683117 8683117 20251203062811_Si9IK UK008S 2025-12-04T14:18:35.205Z 2025-12-06T14:29:41.809Z
8683099 8683099 20251203062758_uq4if UK008S 2025-12-04T14:18:34.878Z 2025-12-06T14:29:41.691Z
8682935 8682935 20251203061642_2fjWY UK008S 2025-12-04T14:18:22.461Z 2025-12-06T14:29:32.752Z
8682902 8682902 20251203061549_HKz8r UK008S 2025-12-04T14:18:19.780Z 2025-12-06T14:29:31.172Z
8682212 8682212 20251203050241_a6tc6 UK008S 2025-12-04T14:16:38.074Z 2025-12-06T14:28:50.185Z
8682039 8682039 20251203044255_Ks5T8 UK008S 2025-12-04T14:16:16.195Z 2025-12-06T14:28:44.769Z
8681997 8681997 20251203043607_xLu8s UK008S 2025-12-04T14:16:07.419Z 2025-12-06T14:28:42.385Z
8681908 8681908 20251203042704_QSlR0 UK008S 2025-12-04T14:15:59.382Z 2025-12-06T14:28:39.694Z
8681873 8681873 20251203041836_arPv5 UK008S 2025-12-04T14:15:49.944Z 2025-12-06T14:28:38.398Z
8681699 8681699 20251203034848_tB74B UK008S 2025-12-04T14:15:18.606Z 2025-12-06T14:28:26.474Z
8680263 8680263 20251202225144_4QGWf UK008S 2025-12-04T14:11:31.030Z 2025-12-06T14:26:59.685Z
8680218 8680218 20251202223522_leIuZ UK008S 2025-12-04T14:11:26.286Z 2025-12-06T14:26:56.867Z
8676953 8676953 20251202063438_2Pqjs UK008S 2025-12-03T14:25:57.935Z 2025-12-06T14:35:31.776Z
8676678 8676678 20251202061146_hjmEM UK008S 2025-12-03T14:25:25.849Z 2025-12-06T14:35:26.959Z
8675522 8675522 20251202045502_Hhe5v UK008S 2025-12-03T14:23:50.038Z 2025-12-06T14:34:55.702Z
8675328 8675328 20251202042845_MpkPe UK008S 2025-12-03T14:23:31.298Z 2025-12-06T14:34:49.534Z
8674652 8674652 20251202030352_gWsbT UK008S 2025-12-03T14:22:10.944Z 2025-12-06T14:34:14.798Z
8667462 8667462 20251130013948_EPBfu UK008S 2025-12-02T14:38:19.653Z 2025-12-06T14:47:43.661Z
8658115 8658115 20251130064213_NU3HU UK008S 2025-12-01T14:34:55.479Z 2025-12-06T14:50:26.771Z
8658102 8658102 20251130063819_L3nXN UK008S 2025-12-01T14:34:54.801Z 2025-12-06T14:50:26.460Z
8657889 8657889 20251130061417_O8PyF UK008S 2025-12-01T14:34:44.661Z 2025-12-06T14:50:23.473Z
8657681 8657681 20251130055922_zmZVu UK008S 2025-12-01T14:34:37.895Z 2025-12-06T14:50:19.554Z
8657575 8657575 20251130055308_K8OsG UK008S 2025-12-01T14:34:33.566Z 2025-12-06T14:50:12.261Z
8657267 8657267 20251130053750_du4EE UK008S 2025-12-01T14:34:02.933Z 2025-12-06T14:49:50.702Z
8656299 8656299 20251130044853_7hH8l UK008S 2025-12-01T14:28:19.358Z 2025-12-06T14:49:33.357Z
8656280 8656280 20251130044642_OQl3y UK008S 2025-12-01T14:28:16.061Z 2025-12-06T14:49:33.113Z
8654664 8654664 20251130032455_hrwcX UK008S 2025-12-01T14:25:42.517Z 2025-12-06T14:48:45.491Z
8653708 8653708 20251130023717_prTPi UK008S 2025-12-01T14:23:58.446Z 2025-12-06T14:48:30.178Z
8653647 8653647 20251130023317_5nbeo UK008S 2025-12-01T14:23:54.015Z 2025-12-06T14:48:24.331Z
8653534 8653534 20251130022407_WGzYC UK008S 2025-12-01T14:23:40.034Z 2025-12-06T14:48:11.974Z
8653419 8653419 20251130021507_VJrBr UK008S 2025-12-01T14:23:22.170Z 2025-12-06T14:47:57.842Z
8653119 8653119 20251130015909_Nwr2f UK008S 2025-12-01T14:22:51.251Z 2025-12-06T14:47:50.469Z
8652858 8652858 20251130013948_2BKfQ UK008S 2025-12-01T14:22:15.598Z 2025-12-06T14:47:43.622Z
8652802 8652802 20251130013459_cjUBZ UK008S 2025-12-01T14:22:08.444Z 2025-12-06T14:47:42.718Z
8652764 8652764 20251130013220_0Jyfw UK008S 2025-12-01T14:22:06.351Z 2025-12-06T14:47:42.248Z
8652670 8652670 20251130012638_rz8ke UK008S 2025-12-01T14:21:57.422Z 2025-12-06T14:47:40.805Z
8652437 8652437 20251130010923_CsMTu UK008S 2025-12-01T14:21:23.718Z 2025-12-06T14:47:37.110Z
8652037 8652037 20251130004255_EBx6X UK008S 2025-12-01T14:20:30.976Z 2025-12-06T14:47:06.227Z
8651823 8651823 20251130002431_NGX61 UK008S 2025-12-01T14:20:05.648Z 2025-12-06T14:46:54.769Z
8651753 8651753 20251130001635_FDdU7 UK008S 2025-12-01T14:19:49.199Z 2025-12-06T14:46:53.384Z
8651577 8651577 20251129235738_j0XV4 UK008S 2025-12-01T14:19:23.659Z 2025-12-06T14:46:48.732Z
8651508 8651508 20251129235113_JX9FE UK008S 2025-12-01T14:19:14.511Z 2025-12-06T14:46:47.635Z
8651272 8651272 20251129232008_cGawW UK008S 2025-12-01T14:18:31.651Z 2025-12-06T14:46:43.020Z
8651265 8651265 20251129231602_W20Oe UK008S 2025-12-01T14:18:30.504Z 2025-12-06T14:46:42.843Z
8644931 8644931 20251128201652_YVnge UK008S 2025-11-30T14:22:53.284Z 2025-12-06T14:54:49.157Z
8644114 8644114 20251128185931_XCOFs UK008S 2025-11-30T14:21:21.560Z 2025-12-06T14:54:38.381Z
8643585 8643585 20251128180802_8crWN UK008S 2025-11-30T14:20:14.834Z 2025-12-06T14:53:51.696Z
8637737 8637737 20251128062841_P3ig0 UK008S 2025-11-29T14:27:47.122Z 2025-12-06T15:04:03.644Z
8637431 8637431 20251128054001_CUn6G UK008S 2025-11-29T14:27:14.680Z 2025-12-06T15:04:00.087Z
8637217 8637217 20251128051634_2GqEc UK008S 2025-11-29T14:26:58.600Z 2025-12-06T15:03:57.756Z
8636516 8636516 20251128035515_39ifw UK008S 2025-11-29T14:25:36.713Z 2025-12-06T15:03:22.992Z
8636479 8636479 20251128035008_I8Zkr UK008S 2025-11-29T14:25:33.257Z 2025-12-06T15:03:20.068Z
8636329 8636329 20251128033722_TWEYv UK008S 2025-11-29T14:25:23.249Z 2025-12-06T15:03:07.429Z
8636252 8636252 20251128032951_mmBG3 UK008S 2025-11-29T14:25:14.735Z 2025-12-06T15:03:02.069Z
8636245 8636245 20251128032951_1ZC2V UK008S 2025-11-29T14:25:11.547Z 2025-12-06T15:03:01.683Z
8636202 8636202 20251128032753_X1jun UK008S 2025-11-29T14:25:04.593Z 2025-12-06T15:02:59.402Z
8635978 8635978 20251128030353_wZsdA UK008S 2025-11-29T14:24:43.218Z 2025-12-06T15:02:54.737Z
8634872 8634872 20251128012422_vI2WA UK008S 2025-11-29T14:22:08.625Z 2025-12-06T15:02:36.821Z
8634524 8634524 20251128005508_sbodq UK008S 2025-11-29T14:21:27.787Z 2025-12-06T15:02:08.732Z
8634243 8634243 20251128003132_Kc7VB UK008S 2025-11-29T14:21:07.135Z 2025-12-06T15:01:53.409Z
8634195 8634195 20251128003023_HX8Ht UK008S 2025-11-29T14:20:54.590Z 2025-12-06T15:01:52.049Z
8633050 8633050 20251127223328_SdwI0 UK008S 2025-11-29T14:18:54.866Z 2025-12-06T15:01:39.362Z
8632756 8632756 20251127215037_Kt0TE UK008S 2025-11-29T14:18:19.355Z 2025-12-06T15:01:33.110Z
8632531 8632531 20251127211733_kXJdc UK008S 2025-11-29T14:17:46.095Z 2025-12-06T15:01:25.260Z
8632476 8632476 20251127211126_pyNOp UK008S 2025-11-29T14:17:42.457Z 2025-12-06T15:01:20.339Z
8632337 8632337 20251127205303_uYB6k UK008S 2025-11-29T14:17:17.590Z 2025-12-06T15:01:12.987Z
8632311 8632311 20251127205021_tcAQe UK008S 2025-11-29T14:17:15.539Z 2025-12-06T15:01:11.211Z
8631930 8631930 20251127201530_7cXFk UK008S 2025-11-29T14:16:35.008Z 2025-12-06T15:00:47.238Z
8625333 8625333 20251125183856_LmLLy UK008S 2025-11-28T14:31:01.410Z 2025-12-04T15:06:44.236Z
8625301 8625301 20251125173215_YP2Gz UK008S 2025-11-28T14:30:17.907Z 2025-12-04T15:05:53.395Z
8616763 8616763 20251126062533_SwUEw UK008S 2025-11-27T14:31:48.565Z 2025-12-04T15:11:43.146Z
8616706 8616706 20251126061720_3NhYp UK008S 2025-11-27T14:31:33.332Z 2025-12-04T15:11:42.069Z
8616607 8616607 20251126061359_q29Cn UK008S 2025-11-27T14:31:22.720Z 2025-12-04T15:11:41.301Z
8616422 8616422 20251126055824_IIvOc UK008S 2025-11-27T14:31:10.879Z 2025-12-04T15:11:39.352Z
8616285 8616285 20251126054902_lC72I UK008S 2025-11-27T14:31:01.082Z 2025-12-04T15:11:37.431Z
8616020 8616020 20251126053201_mC3iS UK008S 2025-11-27T14:30:21.707Z 2025-12-04T15:11:34.561Z
8615909 8615909 20251126052734_RRBDH UK008S 2025-11-27T14:30:16.708Z 2025-12-04T15:11:33.701Z
8615899 8615899 20251126052648_nGcvn UK008S 2025-11-27T14:30:16.148Z 2025-12-04T15:11:33.598Z
8615876 8615876 20251126052541_p5P4M UK008S 2025-11-27T14:30:14.795Z 2025-12-04T15:11:33.282Z
8615448 8615448 20251126050325_tCTYl UK008S 2025-11-27T14:29:32.645Z 2025-12-04T15:11:28.980Z
8615282 8615282 20251126045245_BMr2y UK008S 2025-11-27T14:29:24.358Z 2025-12-04T15:11:27.371Z
8615274 8615274 20251126045244_J0jb3 UK008S 2025-11-27T14:29:23.827Z 2025-12-04T15:11:27.294Z
8614021 8614021 20251126034740_hFAbl UK008S 2025-11-27T14:27:06.146Z 2025-12-04T15:10:11.132Z
8613618 8613618 20251126032609_aULMQ UK008S 2025-11-27T14:26:18.144Z 2025-12-04T15:09:49.893Z
8613454 8613454 20251126031829_fhM0a UK008S 2025-11-27T14:26:06.094Z 2025-12-04T15:09:40.700Z
8613281 8613281 20251126031303_KWTui UK008S 2025-11-27T14:25:36.336Z 2025-12-04T15:09:39.521Z
8613152 8613152 20251126030635_MoVDY UK008S 2025-11-27T14:25:27.162Z 2025-12-04T15:09:37.994Z
8613065 8613065 20251126030042_FHUw1 UK008S 2025-11-27T14:25:21.699Z 2025-12-04T15:09:36.902Z
8612290 8612290 20251126022443_ZbvRw UK008S 2025-11-27T14:23:44.050Z 2025-12-04T15:09:29.201Z
8612255 8612255 20251126022342_yY0in UK008S 2025-11-27T14:23:40.529Z 2025-12-04T15:09:28.650Z
8611943 8611943 20251126020956_33R24 UK008S 2025-11-27T14:23:06.431Z 2025-12-04T15:09:25.956Z
8611769 8611769 20251126015826_Ez6uO UK008S 2025-11-27T14:22:39.014Z 2025-12-04T15:09:24.016Z
8611702 8611702 20251126015713_0cN0L UK008S 2025-11-27T14:22:31.357Z 2025-12-04T15:09:23.563Z
8611636 8611636 20251126015343_zf9HP UK008S 2025-11-27T14:22:23.101Z 2025-12-04T15:09:23.003Z
8611603 8611603 20251126015237_XVhJ6 UK008S 2025-11-27T14:22:21.770Z 2025-12-04T15:09:22.885Z
8611431 8611431 20251126014229_M167G UK008S 2025-11-27T14:22:07.941Z 2025-12-04T15:09:15.124Z

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