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

952 rows where station_code = "UK000B" 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
9213110 9213110 20260116021530_tEcLJ UK000B 2026-01-17T14:15:29.255Z 2026-01-24T15:11:42.225Z
9212496 9212496 20260115221847_osoZZ UK000B 2026-01-17T14:12:15.103Z 2026-01-24T15:10:58.012Z
9212434 9212434 20260115212709_VRriW UK000B 2026-01-17T14:11:47.599Z 2026-01-24T15:10:52.784Z
9212014 9212014 20260115184450_QNszs UK000B 2026-01-17T14:09:28.105Z 2026-01-24T15:10:18.923Z
9202068 9202068 20260114031439_A9zEE UK000B 2026-01-15T14:20:21.979Z 2026-01-22T15:09:12.892Z
9201818 9201818 20260114025731_6xEVw UK000B 2026-01-15T14:19:48.304Z 2026-01-22T15:09:10.194Z
9200975 9200975 20260114012625_N9Ty2 UK000B 2026-01-15T14:17:07.754Z 2026-01-22T15:08:41.138Z
9199610 9199610 20260113203615_m7IIF UK000B 2026-01-15T14:11:40.056Z 2026-01-22T15:07:47.828Z
9199458 9199458 20260113200304_wFsW1 UK000B 2026-01-15T14:10:58.780Z 2026-01-22T15:07:24.731Z
9198972 9198972 20260113184321_0Ezk5 UK000B 2026-01-15T14:08:36.260Z 2026-01-22T15:07:10.709Z
9124381 9124381 20251231060813_TTREO UK000B 2026-01-02T14:45:03.061Z 2026-01-08T15:11:47.103Z
9124267 9124267 20251231053944_wcEQs UK000B 2026-01-02T14:43:48.164Z 2026-01-08T15:11:20.345Z
9115015 9115015 20251231044054_9oOFQ UK000B 2026-01-01T14:24:07.822Z 2026-01-08T15:10:19.323Z
9043961 9043961 20251224214353_KCJPO UK000B 2025-12-28T14:48:15.406Z 2026-01-01T15:57:25.311Z
9042127 9042127 20251224171126_7AdPP UK000B 2025-12-28T14:45:08.229Z 2026-01-01T15:56:34.494Z
9025294 9025294 20251224235008_X0v6s UK000B 2025-12-28T14:04:06.677Z 2026-01-02T15:42:14.939Z
9023837 9023837 20251220223758_80CPS UK000B 2025-12-27T15:09:56.583Z 2025-12-29T15:26:23.412Z
8983037 8983037 20251219210839_OhRb1 UK000B 2025-12-26T14:28:25.983Z 2025-12-28T15:23:17.578Z
8978123 8978123 20251219061827_W2tKg UK000B 2025-12-26T14:14:24.176Z 2025-12-28T15:17:37.378Z
8976741 8976741 20251219033735_3Kgvv UK000B 2025-12-26T14:10:39.784Z 2025-12-28T15:17:27.906Z
8976661 8976661 20251219032640_BPY3J UK000B 2025-12-26T14:10:25.425Z 2025-12-28T15:17:27.148Z
8973341 8973341 20251220011125_djLoE UK000B 2025-12-26T14:01:57.760Z 2025-12-27T14:56:02.110Z
8971450 8971450 20251217001558_akGok UK000B 2025-12-25T14:53:51.407Z 2025-12-25T14:53:51.407Z
8971270 8971270 20251216235653_Bpl8D UK000B 2025-12-25T14:53:42.461Z 2025-12-25T14:53:42.461Z
8970807 8970807 20251216231700_mLbC1 UK000B 2025-12-25T14:53:24.934Z 2025-12-25T14:53:24.934Z
8970698 8970698 20251216230714_33PeR UK000B 2025-12-25T14:52:55.709Z 2025-12-25T14:52:55.709Z
8969937 8969937 20251216212518_c2mPg UK000B 2025-12-25T14:51:55.851Z 2025-12-25T14:51:55.851Z
8969832 8969832 20251216205842_GMGvq UK000B 2025-12-25T14:51:46.933Z 2025-12-25T14:51:46.933Z
8969793 8969793 20251216204931_XryXN UK000B 2025-12-25T14:51:43.808Z 2025-12-25T14:51:43.808Z
8969693 8969693 20251216203244_WOq5o UK000B 2025-12-25T14:51:37.678Z 2025-12-25T14:51:37.678Z
8969593 8969593 20251216201741_DP2PV UK000B 2025-12-25T14:51:12.105Z 2025-12-25T14:51:12.105Z
8969357 8969357 20251216193152_Q4kqK UK000B 2025-12-25T14:50:55.942Z 2025-12-25T14:50:55.942Z
8969248 8969248 20251216190820_R55fj UK000B 2025-12-25T14:50:48.851Z 2025-12-25T14:50:48.851Z
8968871 8968871 20251216173108_amSDn UK000B 2025-12-25T14:50:04.184Z 2025-12-25T14:50:04.184Z
8962821 8962821 20251216035434_UXstX UK000B 2025-12-25T14:37:03.553Z 2025-12-25T14:37:03.553Z
8961711 8961711 20251216020614_D6z2A UK000B 2025-12-25T14:33:31.311Z 2025-12-25T14:33:31.311Z
8938989 8938989 20251214174426_3wDZY UK000B 2025-12-24T14:55:09.646Z 2025-12-24T14:55:09.646Z
8908560 8908560 20251214062051_Nthrl UK000B 2025-12-23T14:08:41.520Z 2025-12-24T14:22:39.498Z
8905496 8905496 20251214053055_0Qnvp UK000B 2025-12-23T14:07:59.342Z 2025-12-24T14:20:40.282Z
8905454 8905454 20251214053019_EomAi UK000B 2025-12-23T14:07:58.804Z 2025-12-24T14:20:39.649Z
8905285 8905285 20251214052838_o8eZm UK000B 2025-12-23T14:07:57.709Z 2025-12-24T14:20:37.958Z
8904539 8904539 20251214051924_nQ0OB UK000B 2025-12-23T14:07:24.734Z 2025-12-24T14:20:28.524Z
8826049 8826049 20251213030202_b6Xmu UK000B 2025-12-17T15:00:08.889Z 2025-12-21T14:17:37.899Z
8825741 8825741 20251213023041_KDsxV UK000B 2025-12-17T14:59:15.494Z 2025-12-21T14:17:36.739Z
8825451 8825451 20251213014539_2TjlQ UK000B 2025-12-17T14:57:43.178Z 2025-12-21T14:17:34.983Z
8825449 8825449 20251213014329_Kl3Dk UK000B 2025-12-17T14:57:39.530Z 2025-12-21T14:17:34.953Z
8825417 8825417 20251213013738_cLF2l UK000B 2025-12-17T14:57:17.783Z 2025-12-21T14:17:34.698Z
8824850 8824850 20251212231513_aGXP3 UK000B 2025-12-17T14:53:33.390Z 2025-12-21T14:17:30.029Z
8824233 8824233 20251212195053_h3O3S UK000B 2025-12-17T14:50:28.478Z 2025-12-21T14:17:26.963Z
8824196 8824196 20251212190432_k0gcN UK000B 2025-12-17T14:49:46.471Z 2025-12-21T14:17:26.692Z
8809405 8809405 20251213050040_AV6JM UK000B 2025-12-17T14:08:52.041Z 2025-12-23T14:17:52.385Z
8808671 8808671 20251213035737_UfJQj UK000B 2025-12-17T14:03:51.245Z 2025-12-23T14:16:30.004Z
8808669 8808669 20251213035734_Z2BNB UK000B 2025-12-17T14:03:49.772Z 2025-12-23T14:16:29.965Z
8808393 8808393 20251213032915_M6S1W UK000B 2025-12-17T14:01:13.315Z 2025-12-23T14:16:20.820Z
8798744 8798744 20251213053028_7pipq UK000B 2025-12-16T14:11:12.492Z 2025-12-23T14:18:30.863Z
8795537 8795537 20251213043826_O3TCG UK000B 2025-12-16T14:08:09.169Z 2025-12-23T14:17:31.191Z
8787947 8787947 20251213025059_yDA6s UK000B 2025-12-15T14:38:32.484Z 2025-12-21T14:17:37.547Z
8784111 8784111 20251213015619_cso7S UK000B 2025-12-15T14:35:36.233Z 2025-12-21T14:17:35.408Z
8783857 8783857 20251213015220_j3Msf UK000B 2025-12-15T14:35:31.299Z 2025-12-21T14:17:35.241Z
8782796 8782796 20251213013358_vk2Gn UK000B 2025-12-15T14:34:24.463Z 2025-12-21T14:17:34.536Z
8782744 8782744 20251213013305_26vBw UK000B 2025-12-15T14:34:23.440Z 2025-12-21T14:17:34.500Z
8782433 8782433 20251213012901_fzpnG UK000B 2025-12-15T14:34:16.976Z 2025-12-21T14:17:34.309Z
8782212 8782212 20251213012522_TgVXk UK000B 2025-12-15T14:34:09.570Z 2025-12-21T14:17:34.197Z
8781412 8781412 20251213011313_EvNkZ UK000B 2025-12-15T14:33:28.626Z 2025-12-21T14:17:33.774Z
8774626 8774626 20251212230839_sdFiD UK000B 2025-12-15T14:27:32.912Z 2025-12-21T14:17:29.854Z
8774242 8774242 20251212225913_s0s4O UK000B 2025-12-15T14:26:58.387Z 2025-12-21T14:17:29.607Z
8774169 8774169 20251212225704_uO6l0 UK000B 2025-12-15T14:26:55.549Z 2025-12-21T14:17:29.561Z
8773941 8773941 20251212225111_pm5Jb UK000B 2025-12-15T14:26:48.608Z 2025-12-21T14:17:29.411Z
8773121 8773121 20251212222912_b23ll UK000B 2025-12-15T14:25:52.467Z 2025-12-21T14:17:28.868Z
8772532 8772532 20251212220725_IZVMl UK000B 2025-12-15T14:25:06.765Z 2025-12-21T14:17:28.518Z
8772135 8772135 20251212215846_jVe9I UK000B 2025-12-15T14:24:36.375Z 2025-12-21T14:17:28.328Z
8771681 8771681 20251212214225_jZl1I UK000B 2025-12-15T14:23:54.272Z 2025-12-21T14:17:28.038Z
8771504 8771504 20251212213154_020nf UK000B 2025-12-15T14:23:47.775Z 2025-12-21T14:17:27.898Z
8771357 8771357 20251212212049_znhzm UK000B 2025-12-15T14:23:17.369Z 2025-12-21T14:17:27.767Z
8771295 8771295 20251212211750_QSWZw UK000B 2025-12-15T14:23:12.443Z 2025-12-21T14:17:27.723Z
8771131 8771131 20251212210952_MBXn6 UK000B 2025-12-15T14:23:04.917Z 2025-12-21T14:17:27.626Z
8770794 8770794 20251212205334_xjglG UK000B 2025-12-15T14:22:27.412Z 2025-12-21T14:17:27.404Z
8770170 8770170 20251212201122_LpHZV UK000B 2025-12-15T14:21:38.870Z 2025-12-21T14:17:27.083Z
8770041 8770041 20251212200249_EGJ63 UK000B 2025-12-15T14:21:32.919Z 2025-12-21T14:17:27.034Z
8769783 8769783 20251212194254_7EpMP UK000B 2025-12-15T14:21:00.475Z 2025-12-21T14:17:26.916Z
8769164 8769164 20251212183345_hRiI7 UK000B 2025-12-15T14:19:35.140Z 2025-12-21T14:17:26.575Z
8768143 8768143 20251213032046_lGCwu UK000B 2025-12-15T14:00:32.897Z 2025-12-23T14:16:18.969Z
8752663 8752663 20251209232414_uyfa4 UK000B 2025-12-13T15:40:58.102Z 2025-12-17T15:27:31.279Z
8752025 8752025 20251209221538_t1oCz UK000B 2025-12-13T15:40:07.040Z 2025-12-17T15:27:25.190Z
8740127 8740127 20251210183259_Y61q9 UK000B 2025-12-13T15:18:03.534Z 2025-12-19T15:11:13.995Z
8740016 8740016 20251210181908_DSESc UK000B 2025-12-13T15:17:39.191Z 2025-12-19T15:11:09.287Z
8739969 8739969 20251210180217_ORao3 UK000B 2025-12-13T15:17:35.246Z 2025-12-19T15:11:06.844Z
8736355 8736355 20251211222715_D2ou2 UK000B 2025-12-13T14:56:04.368Z 2025-12-20T14:25:20.294Z
8736012 8736012 20251211213035_UHhey UK000B 2025-12-13T14:55:11.873Z 2025-12-20T14:25:18.590Z
8711757 8711757 20251208172442_rp8nf UK000B 2025-12-10T14:11:41.765Z 2025-12-17T15:32:02.362Z
8663400 8663400 20251130204348_2jFOp UK000B 2025-12-02T14:18:14.700Z 2025-12-09T14:57:31.424Z
8648663 8648663 20251128032822_yeIsk UK000B 2025-11-30T14:37:20.173Z 2025-12-06T15:03:00.423Z
8635558 8635558 20251128022554_jgJYR UK000B 2025-11-29T14:23:40.779Z 2025-12-06T15:02:46.482Z
8632737 8632737 20251127214614_w0Opp UK000B 2025-11-29T14:18:09.580Z 2025-12-06T15:01:32.918Z
8632615 8632615 20251127212546_eaVb2 UK000B 2025-11-29T14:17:51.843Z 2025-12-06T15:01:31.508Z
8614528 8614528 20251126041640_DxAjn UK000B 2025-11-27T14:27:59.066Z 2025-12-04T15:10:48.279Z
8613816 8613816 20251126033511_L8OZf UK000B 2025-11-27T14:26:48.891Z 2025-12-04T15:09:52.093Z
8613670 8613670 20251126032809_36jFM UK000B 2025-11-27T14:26:22.153Z 2025-12-04T15:09:50.421Z
8613358 8613358 20251126031434_CItmi UK000B 2025-11-27T14:25:43.748Z 2025-12-04T15:09:39.910Z
8613231 8613231 20251126031146_wHv44 UK000B 2025-11-27T14:25:34.449Z 2025-12-04T15:09:39.188Z

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