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

6,596 rows where station_code = "UK006T" 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
9611759 9611759 20260405032145_CXpOP UK006T 2026-04-06T12:15:55.259Z 2026-04-06T12:16:14.859Z
9611701 9611701 20260405031620_8vqGv UK006T 2026-04-06T12:15:46.975Z 2026-04-06T12:16:14.850Z
9611326 9611326 20260405012738_dw303 UK006T 2026-04-06T12:14:01.825Z 2026-04-06T12:16:14.779Z
9609270 9609270 20260405040957_rJSM8 UK006T 2026-04-06T12:00:51.721Z 2026-04-06T12:00:51.721Z
9609207 9609207 20260405035809_vJGv9 UK006T 2026-04-06T12:00:42.382Z 2026-04-06T12:00:42.382Z
9609204 9609204 20260405035807_zxhQ6 UK006T 2026-04-06T12:00:42.048Z 2026-04-06T12:00:42.048Z
9609149 9609149 20260405034523_52EQl UK006T 2026-04-06T12:00:26.853Z 2026-04-06T12:00:26.853Z
9609129 9609129 20260405034238_hHVKf UK006T 2026-04-06T12:00:23.531Z 2026-04-06T12:00:23.531Z
9609124 9609124 20260405034212_fExkc UK006T 2026-04-06T12:00:22.697Z 2026-04-06T12:00:22.697Z
9609096 9609096 20260405033346_sQXrr UK006T 2026-04-06T12:00:14.583Z 2026-04-06T12:00:14.583Z
9608282 9608282 20260403212957_Enk12 UK006T 2026-04-05T12:09:54.160Z 2026-04-06T12:20:03.501Z
9607099 9607099 20260404033157_ChdnX UK006T 2026-04-05T12:00:25.125Z 2026-04-06T12:16:14.360Z
9604990 9604990 20260402022411_P9CjI UK006T 2026-04-03T12:12:31.111Z 2026-04-06T12:26:37.129Z
9604849 9604849 20260402011935_jK43Y UK006T 2026-04-03T12:11:54.225Z 2026-04-06T12:26:27.342Z
9604811 9604811 20260402005423_xJ3eZ UK006T 2026-04-03T12:11:38.207Z 2026-04-06T12:26:20.460Z
9602963 9602963 20260402042124_5hGY7 UK006T 2026-04-03T12:01:20.889Z 2026-04-06T12:21:22.681Z
9602799 9602799 20260402032058_l6boj UK006T 2026-04-03T12:00:38.738Z 2026-04-06T12:21:13.169Z
9594442 9594442 20260328222427_3PAlz UK006T 2026-03-30T12:09:33.773Z 2026-04-06T12:39:52.253Z
9594209 9594209 20260328200751_VJ7Np UK006T 2026-03-30T12:08:58.807Z 2026-04-06T12:39:42.874Z
9594170 9594170 20260328194224_ImLr8 UK006T 2026-03-30T12:08:53.491Z 2026-04-06T12:39:40.956Z
9592573 9592573 20260329023627_tk9U3 UK006T 2026-03-30T12:01:20.788Z 2026-04-06T12:34:15.874Z
9592329 9592329 20260329015318_xquoK UK006T 2026-03-30T12:00:41.591Z 2026-04-06T12:34:00.806Z
9592293 9592293 20260329014016_1P5zN UK006T 2026-03-30T12:00:35.014Z 2026-04-06T12:33:58.992Z
9592133 9592133 20260328005440_yo3rT UK006T 2026-03-29T12:07:12.605Z 2026-04-05T12:35:38.349Z
9589935 9589935 20260328042212_JwjiF UK006T 2026-03-29T12:01:46.002Z 2026-04-06T12:37:38.717Z
9588905 9588905 20260328015404_mhwyo UK006T 2026-03-29T12:00:28.468Z 2026-04-06T12:36:56.099Z
9584883 9584883 20260325223308_23Dpq UK006T 2026-03-27T12:16:18.246Z 2026-04-03T12:39:43.198Z
9584643 9584643 20260325212604_oMeeI UK006T 2026-03-27T12:15:54.318Z 2026-04-03T12:39:25.453Z
9584588 9584588 20260325205140_2FQwk UK006T 2026-03-27T12:15:43.274Z 2026-04-03T12:39:22.886Z
9582104 9582104 20260326043808_P6Unj UK006T 2026-03-27T12:04:38.614Z 2026-04-04T12:39:37.748Z
9581815 9581815 20260326035940_F2gJr UK006T 2026-03-27T12:03:53.964Z 2026-04-04T12:39:21.355Z
9581621 9581621 20260326033505_96EFy UK006T 2026-03-27T12:03:29.830Z 2026-04-04T12:39:12.190Z
9581524 9581524 20260326032447_Ejt3U UK006T 2026-03-27T12:03:21.580Z 2026-04-04T12:39:09.692Z
9580964 9580964 20260326020015_KxAx3 UK006T 2026-03-27T12:01:46.972Z 2026-04-04T12:38:36.691Z
9580842 9580842 20260326014447_1R1N3 UK006T 2026-03-27T12:01:32.539Z 2026-04-04T12:38:31.183Z
9580773 9580773 20260326012859_SdjcB UK006T 2026-03-27T12:01:22.795Z 2026-04-04T12:38:28.910Z
9555392 9555392 20260322044806_rffy2 UK006T 2026-03-23T12:03:23.468Z 2026-03-30T12:28:25.894Z
9554173 9554173 20260322024547_Nb4jt UK006T 2026-03-23T12:02:18.215Z 2026-03-30T12:27:59.739Z
9552880 9552880 20260322005048_Y2DTm UK006T 2026-03-23T12:00:58.350Z 2026-03-30T12:27:31.745Z
9531703 9531703 20260319233707_mEtWk UK006T 2026-03-21T12:00:34.883Z 2026-03-28T12:33:20.494Z
9530982 9530982 20260318221136_GvKlv UK006T 2026-03-20T12:24:53.654Z 2026-03-26T12:39:16.806Z
9530848 9530848 20260318215321_torbX UK006T 2026-03-20T12:24:49.564Z 2026-03-26T12:39:16.199Z
9521977 9521977 20260319050159_m4Isz UK006T 2026-03-20T12:08:47.714Z 2026-03-27T12:41:12.286Z
9521447 9521447 20260319041613_qhyKa UK006T 2026-03-20T12:08:01.422Z 2026-03-27T12:40:54.884Z
9521254 9521254 20260319040033_22T0m UK006T 2026-03-20T12:07:45.464Z 2026-03-27T12:40:53.056Z
9521222 9521222 20260319035824_TWp68 UK006T 2026-03-20T12:07:43.619Z 2026-03-27T12:40:52.799Z
9520268 9520268 20260319030722_dWWnb UK006T 2026-03-20T12:06:06.535Z 2026-03-27T12:40:41.358Z
9519217 9519217 20260319015432_3gs1n UK006T 2026-03-20T12:04:06.587Z 2026-03-27T12:40:19.057Z
9519202 9519202 20260319015419_qA2vv UK006T 2026-03-20T12:04:05.822Z 2026-03-27T12:40:18.977Z
9518851 9518851 20260319012947_K0v1B UK006T 2026-03-20T12:03:30.265Z 2026-03-27T12:40:15.737Z
9518629 9518629 20260319011413_ea633 UK006T 2026-03-20T12:03:01.434Z 2026-03-27T12:40:12.215Z
9518586 9518586 20260319011156_LtDqZ UK006T 2026-03-20T12:02:54.830Z 2026-03-27T12:40:11.674Z
9517994 9517994 20260319001926_dAHJR UK006T 2026-03-20T12:01:40.229Z 2026-03-27T12:40:05.202Z
9517243 9517243 20260317225851_nDE2k UK006T 2026-03-19T12:27:21.856Z 2026-03-25T12:43:09.528Z
9517003 9517003 20260317222503_bqdfI UK006T 2026-03-19T12:27:04.867Z 2026-03-25T12:43:08.044Z
9516222 9516222 20260317201549_m3CNR UK006T 2026-03-19T12:25:47.671Z 2026-03-25T12:42:51.749Z
9511440 9511440 20260318035449_QJwtO UK006T 2026-03-19T12:10:13.162Z 2026-03-26T12:37:36.995Z
9510404 9510404 20260318024929_l2M0D UK006T 2026-03-19T12:07:32.343Z 2026-03-26T12:37:12.174Z
9509850 9509850 20260318021934_3ex93 UK006T 2026-03-19T12:06:22.774Z 2026-03-26T12:37:08.325Z
9509477 9509477 20260318015122_27F13 UK006T 2026-03-19T12:05:22.517Z 2026-03-26T12:37:05.594Z
9509467 9509467 20260318015122_wpXaI UK006T 2026-03-19T12:05:22.038Z 2026-03-26T12:37:05.544Z
9509385 9509385 20260318014735_E3ScC UK006T 2026-03-19T12:05:14.895Z 2026-03-26T12:37:05.279Z
9509328 9509328 20260318014342_wPgb9 UK006T 2026-03-19T12:05:07.808Z 2026-03-26T12:37:04.969Z
9508861 9508861 20260318011244_gUUFY UK006T 2026-03-19T12:03:56.838Z 2026-03-26T12:37:01.287Z
9507938 9507938 20260317235640_Tt2sG UK006T 2026-03-19T12:01:45.006Z 2026-03-26T12:36:54.580Z
9507709 9507709 20260317233615_udzgX UK006T 2026-03-19T12:01:02.866Z 2026-03-26T12:36:52.706Z
9507649 9507649 20260317233012_DAjAO UK006T 2026-03-19T12:00:51.691Z 2026-03-26T12:36:51.462Z
9501530 9501530 20260315223629_xc6Ln UK006T 2026-03-17T12:25:12.762Z 2026-03-23T12:22:44.806Z
9501466 9501466 20260315222630_qfn3j UK006T 2026-03-17T12:25:04.053Z 2026-03-23T12:22:44.666Z
9500997 9500997 20260315203453_KOERs UK006T 2026-03-17T12:24:16.904Z 2026-03-23T12:22:42.706Z
9494622 9494622 20260316023725_MRs3z UK006T 2026-03-17T12:04:24.744Z 2026-03-24T12:40:48.784Z
9477273 9477273 20260314043717_9x5sB UK006T 2026-03-15T12:07:59.336Z 2026-03-22T12:42:02.061Z
9477267 9477267 20260314043639_6aIVY UK006T 2026-03-15T12:07:58.637Z 2026-03-22T12:42:02.025Z
9476904 9476904 20260314035427_1gtwr UK006T 2026-03-15T12:07:11.723Z 2026-03-22T12:42:00.088Z
9470353 9470353 20260313052013_LvNz0 UK006T 2026-03-14T12:07:07.264Z 2026-03-21T12:49:07.882Z
9470163 9470163 20260313044604_aGF27 UK006T 2026-03-14T12:06:36.403Z 2026-03-21T12:49:06.269Z
9470137 9470137 20260313043937_MqNfz UK006T 2026-03-14T12:06:32.853Z 2026-03-21T12:49:06.127Z
9470076 9470076 20260313042931_ruEQR UK006T 2026-03-14T12:06:24.162Z 2026-03-21T12:49:05.689Z
9470053 9470053 20260313042422_RRueO UK006T 2026-03-14T12:06:20.679Z 2026-03-21T12:49:05.447Z
9470000 9470000 20260313041906_2urxU UK006T 2026-03-14T12:06:12.393Z 2026-03-21T12:49:05.005Z
9469870 9469870 20260313035543_2FHk9 UK006T 2026-03-14T12:05:47.710Z 2026-03-21T12:49:03.469Z
9469694 9469694 20260313033140_Yq2S2 UK006T 2026-03-14T12:05:14.862Z 2026-03-21T12:49:00.861Z
9457749 9457749 20260311051019_RtAqm UK006T 2026-03-12T12:04:28.513Z 2026-03-19T12:44:51.591Z
9457566 9457566 20260311042012_6cXr8 UK006T 2026-03-12T12:04:05.135Z 2026-03-19T12:44:47.468Z
9457352 9457352 20260311033948_CI1C3 UK006T 2026-03-12T12:03:38.046Z 2026-03-19T12:44:39.876Z
9451262 9451262 20260310013115_9z4Du UK006T 2026-03-11T12:02:17.745Z 2026-03-18T12:38:43.972Z
9415203 9415203 20260228204806_wb9u5 UK006T 2026-03-02T14:07:33.553Z 2026-03-08T12:43:05.567Z
9395138 9395138 20260224230413_0XEZA UK006T 2026-02-26T14:21:06.828Z 2026-03-04T14:19:29.987Z
9395072 9395072 20260224224851_NLGuQ UK006T 2026-02-26T14:21:02.761Z 2026-03-04T14:19:29.479Z
9394747 9394747 20260224214010_DXDUY UK006T 2026-02-26T14:20:35.607Z 2026-03-04T14:19:26.909Z
9394331 9394331 20260224195413_3bLuu UK006T 2026-02-26T14:19:36.807Z 2026-03-04T14:19:20.439Z
9390722 9390722 20260225011021_PoyH2 UK006T 2026-02-26T14:02:15.423Z 2026-03-05T14:35:54.223Z
9390532 9390532 20260225004212_t3X7X UK006T 2026-02-26T14:01:39.659Z 2026-03-05T14:35:49.030Z
9381579 9381579 20260222233156_mEQFL UK006T 2026-02-24T14:24:56.513Z 2026-02-24T14:24:56.513Z
9381247 9381247 20260222212643_LnrlT UK006T 2026-02-24T14:24:27.042Z 2026-02-24T14:24:27.042Z
9381191 9381191 20260222211157_nayQi UK006T 2026-02-24T14:24:21.976Z 2026-02-24T14:24:21.976Z
9374086 9374086 20260223053513_2QcDj UK006T 2026-02-24T14:04:50.016Z 2026-03-03T14:31:14.301Z
9374072 9374072 20260223053157_mBHWk UK006T 2026-02-24T14:04:47.458Z 2026-03-03T14:31:14.138Z
9373920 9373920 20260223045432_IdTpw UK006T 2026-02-24T14:04:20.110Z 2026-03-03T14:31:11.631Z
9373837 9373837 20260223043009_6nBtU UK006T 2026-02-24T14:04:04.506Z 2026-03-03T14:31:10.442Z

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