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

9,848 rows where station_code = "UK008X" 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
9609217 9609217 20260405040105_PLv2O UK008X 2026-04-06T12:00:45.274Z 2026-04-06T12:00:45.274Z
9608456 9608456 20260403231116_uFEEK UK008X 2026-04-05T12:10:28.861Z 2026-04-06T12:20:13.611Z
9608381 9608381 20260403224258_l1YSD UK008X 2026-04-05T12:10:18.013Z 2026-04-06T12:20:09.534Z
9608112 9608112 20260403200004_d5yJ0 UK008X 2026-04-05T12:08:44.827Z 2026-04-06T12:19:42.219Z
9607175 9607175 20260404041743_v6kVy UK008X 2026-04-05T12:00:45.001Z 2026-04-06T12:16:14.378Z
9602891 9602891 20260402035614_78DAU UK008X 2026-04-03T12:01:05.340Z 2026-04-06T12:21:19.419Z
9602436 9602436 20260331211040_n0E28 UK008X 2026-04-02T12:08:51.144Z 2026-04-06T12:29:08.524Z
9598536 9598536 20260330010243_B6K0I UK008X 2026-03-31T12:10:49.747Z 2026-04-06T12:36:44.747Z
9598534 9598534 20260330010242_ypJZR UK008X 2026-03-31T12:10:49.422Z 2026-04-06T12:36:44.559Z
9598523 9598523 20260330005639_VGsUG UK008X 2026-03-31T12:10:47.966Z 2026-04-06T12:36:44.047Z
9598423 9598423 20260330000527_Kv5c4 UK008X 2026-03-31T12:10:34.668Z 2026-04-06T12:36:31.908Z
9595524 9595524 20260330043144_wwqH4 UK008X 2026-03-31T12:01:38.418Z 2026-04-06T12:30:07.590Z
9595016 9595016 20260330013758_ibmrg UK008X 2026-03-31T12:00:11.613Z 2026-04-06T12:29:34.953Z
9594842 9594842 20260329004326_13a1j UK008X 2026-03-30T12:10:25.042Z 2026-04-06T12:40:17.773Z
9594485 9594485 20260328223709_LpHpF UK008X 2026-03-30T12:09:40.388Z 2026-04-06T12:39:54.142Z
9594322 9594322 20260328212525_ajrol UK008X 2026-03-30T12:09:18.101Z 2026-04-06T12:39:47.924Z
9592044 9592044 20260328000336_BWFVg UK008X 2026-03-29T12:07:07.775Z 2026-04-05T12:35:25.119Z
9589981 9589981 20260328042557_LybRl UK008X 2026-03-29T12:01:48.360Z 2026-04-06T12:37:39.961Z
9589953 9589953 20260328042300_swGSF UK008X 2026-03-29T12:01:46.951Z 2026-04-06T12:37:39.149Z
9589911 9589911 20260328041950_mrS0i UK008X 2026-03-29T12:01:44.465Z 2026-04-06T12:37:38.051Z
9589899 9589899 20260328041640_2fScY UK008X 2026-03-29T12:01:42.790Z 2026-04-06T12:37:37.483Z
9589775 9589775 20260328040838_drdWD UK008X 2026-03-29T12:01:37.589Z 2026-04-06T12:37:33.171Z
9589754 9589754 20260328040521_c2MCt UK008X 2026-03-29T12:01:36.869Z 2026-04-06T12:37:32.722Z
9589689 9589689 20260328035907_e6h6C UK008X 2026-03-29T12:01:33.862Z 2026-04-06T12:37:31.524Z
9589563 9589563 20260328034710_c7n7h UK008X 2026-03-29T12:01:26.057Z 2026-04-06T12:37:27.707Z
9589549 9589549 20260328034548_v3o6J UK008X 2026-03-29T12:01:25.335Z 2026-04-06T12:37:27.451Z
9589409 9589409 20260328032804_L72Mn UK008X 2026-03-29T12:01:12.452Z 2026-04-06T12:37:22.697Z
9584809 9584809 20260325222001_W7A5z UK008X 2026-03-27T12:16:09.973Z 2026-04-03T12:39:41.547Z
9584780 9584780 20260325220438_7ybu0 UK008X 2026-03-27T12:16:06.392Z 2026-04-03T12:39:40.841Z
9584760 9584760 20260325220033_f4VW6 UK008X 2026-03-27T12:16:04.664Z 2026-04-03T12:39:39.957Z
9584665 9584665 20260325213321_sVcPV UK008X 2026-03-27T12:15:56.276Z 2026-04-03T12:39:25.967Z
9584529 9584529 20260325202956_SjQdj UK008X 2026-03-27T12:15:35.335Z 2026-04-03T12:39:18.843Z
9584503 9584503 20260325201728_bv2zj UK008X 2026-03-27T12:15:30.375Z 2026-04-03T12:39:17.273Z
9584429 9584429 20260325195058_5UwN2 UK008X 2026-03-27T12:15:17.913Z 2026-04-03T12:39:13.866Z
9582006 9582006 20260326042119_sEyfU UK008X 2026-03-27T12:04:24.688Z 2026-04-04T12:39:34.888Z
9581150 9581150 20260326023003_rdGbr UK008X 2026-03-27T12:02:15.146Z 2026-04-04T12:38:44.123Z
9581043 9581043 20260326021450_zKwN1 UK008X 2026-03-27T12:01:57.926Z 2026-04-04T12:38:40.447Z
9581031 9581031 20260326021450_6yOQx UK008X 2026-03-27T12:01:57.564Z 2026-04-04T12:38:40.327Z
9580989 9580989 20260326020700_huQ5o UK008X 2026-03-27T12:01:50.842Z 2026-04-04T12:38:38.338Z
9580977 9580977 20260326020134_Feno5 UK008X 2026-03-27T12:01:48.074Z 2026-04-04T12:38:37.249Z
9580821 9580821 20260326013932_5Qy36 UK008X 2026-03-27T12:01:30.037Z 2026-04-04T12:38:30.553Z
9580734 9580734 20260326012413_CAkZh UK008X 2026-03-27T12:01:17.316Z 2026-04-04T12:38:21.932Z
9580003 9580003 20260324234713_RVRxY UK008X 2026-03-26T12:14:52.018Z 2026-04-02T12:37:38.634Z
9579917 9579917 20260324231924_z8CKO UK008X 2026-03-26T12:14:40.269Z 2026-04-02T12:37:34.405Z
9579621 9579621 20260324215923_7XMxc UK008X 2026-03-26T12:14:05.502Z 2026-04-02T12:37:18.141Z
9576199 9576199 20260325013410_5E5vj UK008X 2026-03-26T12:01:32.782Z 2026-04-03T12:35:48.185Z
9576181 9576181 20260325013153_usdti UK008X 2026-03-26T12:01:30.111Z 2026-04-03T12:35:47.424Z
9575969 9575969 20260325005101_EUp0t UK008X 2026-03-26T12:00:50.376Z 2026-04-03T12:35:38.405Z
9575856 9575856 20260325002822_LPGW8 UK008X 2026-03-26T12:00:25.862Z 2026-04-03T12:35:26.576Z
9562465 9562465 20260323022326_fPrOw UK008X 2026-03-24T12:03:12.003Z 2026-03-31T12:26:10.840Z
9561872 9561872 20260323005158_aZn5w UK008X 2026-03-24T12:01:29.744Z 2026-03-31T12:25:55.459Z
9561860 9561860 20260323005124_fgZtu UK008X 2026-03-24T12:01:28.594Z 2026-03-31T12:25:55.219Z
9561787 9561787 20260323004340_i2GGL UK008X 2026-03-24T12:01:18.139Z 2026-03-31T12:25:53.738Z
9560842 9560842 20260321222614_lzjh9 UK008X 2026-03-23T12:12:05.063Z 2026-03-29T12:21:03.292Z
9560766 9560766 20260321221143_6YjtN UK008X 2026-03-23T12:12:02.969Z 2026-03-29T12:21:02.738Z
9560652 9560652 20260321215623_wHXNZ UK008X 2026-03-23T12:12:00.264Z 2026-03-29T12:21:01.940Z
9560602 9560602 20260321214859_2wIsD UK008X 2026-03-23T12:11:59.004Z 2026-03-29T12:21:01.647Z
9560594 9560594 20260321214811_uJgqv UK008X 2026-03-23T12:11:58.734Z 2026-03-29T12:21:01.596Z
9560474 9560474 20260321213018_yiETv UK008X 2026-03-23T12:11:48.642Z 2026-03-29T12:21:00.636Z
9560386 9560386 20260321210738_7ftQb UK008X 2026-03-23T12:11:44.917Z 2026-03-29T12:20:59.805Z
9560133 9560133 20260321203354_Wf1Cn UK008X 2026-03-23T12:11:38.752Z 2026-03-29T12:20:58.138Z
9560122 9560122 20260321203342_RJYD2 UK008X 2026-03-23T12:11:38.573Z 2026-03-29T12:20:58.113Z
9560093 9560093 20260321203220_AUC3J UK008X 2026-03-23T12:11:37.964Z 2026-03-29T12:20:57.951Z
9559950 9559950 20260321201411_0cmkt UK008X 2026-03-23T12:11:34.464Z 2026-03-29T12:20:56.782Z
9559909 9559909 20260321200834_7cfrS UK008X 2026-03-23T12:11:33.524Z 2026-03-29T12:20:56.523Z
9559834 9559834 20260321195745_7jKq8 UK008X 2026-03-23T12:11:31.706Z 2026-03-29T12:20:56.026Z
9555379 9555379 20260322044706_WGEn4 UK008X 2026-03-23T12:03:23.132Z 2026-03-30T12:28:25.747Z
9555093 9555093 20260322040324_FGCGC UK008X 2026-03-23T12:03:09.716Z 2026-03-30T12:28:14.351Z
9554910 9554910 20260322034329_2pm2k UK008X 2026-03-23T12:02:56.343Z 2026-03-30T12:28:11.413Z
9554877 9554877 20260322034012_284C6 UK008X 2026-03-23T12:02:54.226Z 2026-03-30T12:28:10.695Z
9554793 9554793 20260322033455_L3FIy UK008X 2026-03-23T12:02:51.131Z 2026-03-30T12:28:08.968Z
9554635 9554635 20260322032216_3fuyd UK008X 2026-03-23T12:02:44.026Z 2026-03-30T12:28:06.610Z
9554481 9554481 20260322031255_IFGQv UK008X 2026-03-23T12:02:34.738Z 2026-03-30T12:28:04.587Z
9554277 9554277 20260322025436_fI5js UK008X 2026-03-23T12:02:24.123Z 2026-03-30T12:28:01.562Z
9553801 9553801 20260322021514_CrcFW UK008X 2026-03-23T12:01:52.653Z 2026-03-30T12:27:52.801Z
9553719 9553719 20260322020906_pQ5zU UK008X 2026-03-23T12:01:47.894Z 2026-03-30T12:27:51.506Z
9553631 9553631 20260322020225_xjoJh UK008X 2026-03-23T12:01:43.859Z 2026-03-30T12:27:50.390Z
9553444 9553444 20260322014255_g1Jnl UK008X 2026-03-23T12:01:30.462Z 2026-03-30T12:27:41.195Z
9553312 9553312 20260322013003_EdXIT UK008X 2026-03-23T12:01:23.691Z 2026-03-30T12:27:39.257Z
9553295 9553295 20260322012958_oa3PH UK008X 2026-03-23T12:01:23.428Z 2026-03-30T12:27:39.182Z
9553200 9553200 20260322012356_ZKK0y UK008X 2026-03-23T12:01:18.971Z 2026-03-30T12:27:36.325Z
9553160 9553160 20260322012215_eitRi UK008X 2026-03-23T12:01:17.726Z 2026-03-30T12:27:35.898Z
9552893 9552893 20260322005112_2Glao UK008X 2026-03-23T12:00:58.653Z 2026-03-30T12:27:31.842Z
9552315 9552315 20260321235023_zPilT UK008X 2026-03-23T12:00:13.931Z 2026-03-30T12:27:22.181Z
9551697 9551697 20260320210129_s3Rg2 UK008X 2026-03-22T12:26:56.715Z 2026-03-28T12:37:00.345Z
9549135 9549135 20260319234912_zGaBY UK008X 2026-03-22T12:16:49.354Z 2026-03-28T12:33:21.534Z
9543658 9543658 20260321043807_gOAY5 UK008X 2026-03-22T12:04:21.889Z 2026-03-29T12:19:09.832Z
9543596 9543596 20260321042503_QgH7F UK008X 2026-03-22T12:04:14.400Z 2026-03-29T12:19:09.215Z
9543570 9543570 20260321042424_Gpa3r UK008X 2026-03-22T12:04:11.039Z 2026-03-29T12:19:08.993Z
9543538 9543538 20260321041851_caUve UK008X 2026-03-22T12:04:07.135Z 2026-03-29T12:19:08.787Z
9543492 9543492 20260321040442_yWsgU UK008X 2026-03-22T12:03:58.929Z 2026-03-29T12:19:08.297Z
9543457 9543457 20260321035857_5hzu6 UK008X 2026-03-22T12:03:52.774Z 2026-03-29T12:19:07.848Z
9542341 9542341 20260319231330_DECVW UK008X 2026-03-21T12:29:58.466Z 2026-03-27T12:42:57.486Z
9542208 9542208 20260319225945_Q8mCQ UK008X 2026-03-21T12:29:51.586Z 2026-03-27T12:42:49.740Z
9541990 9541990 20260319222411_Bi6Ho UK008X 2026-03-21T12:29:33.756Z 2026-03-27T12:42:43.840Z
9534966 9534966 20260320044843_KPYN1 UK008X 2026-03-21T12:09:19.157Z 2026-03-28T12:34:24.177Z
9534921 9534921 20260320043952_7S3vx UK008X 2026-03-21T12:09:10.594Z 2026-03-28T12:34:23.512Z
9534899 9534899 20260320043859_E6ipb UK008X 2026-03-21T12:09:08.470Z 2026-03-28T12:34:23.401Z
9534259 9534259 20260320033853_bnSjm UK008X 2026-03-21T12:07:35.038Z 2026-03-28T12:34:16.733Z
9533852 9533852 20260320030621_5xFvV UK008X 2026-03-21T12:06:29.276Z 2026-03-28T12:34:01.599Z

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