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

>10,000 rows count all where station_code = "UK009W" 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
9608820 9608820 20260404014528_F8krG UK009W 2026-04-05T12:11:50.783Z 2026-04-06T12:20:40.663Z
9608657 9608657 20260404003006_rzQ5c UK009W 2026-04-05T12:11:13.337Z 2026-04-06T12:20:28.855Z
9608626 9608626 20260404000215_UazG0 UK009W 2026-04-05T12:11:01.941Z 2026-04-06T12:20:26.935Z
9608499 9608499 20260403231932_r1V29 UK009W 2026-04-05T12:10:35.337Z 2026-04-06T12:20:17.142Z
9608457 9608457 20260403231116_uFEEK UK009W 2026-04-05T12:10:28.861Z 2026-04-06T12:20:13.611Z
9602610 9602610 20260401002353_Fz4GO UK009W 2026-04-02T12:09:31.448Z 2026-04-06T12:29:25.917Z
9602439 9602439 20260331211040_n0E28 UK009W 2026-04-02T12:08:51.155Z 2026-04-06T12:29:08.524Z
9598424 9598424 20260330000527_Kv5c4 UK009W 2026-03-31T12:10:34.668Z 2026-04-06T12:36:31.908Z
9598285 9598285 20260329220238_gR1vY UK009W 2026-03-31T12:10:11.652Z 2026-04-06T12:36:22.425Z
9595527 9595527 20260330043144_wwqH4 UK009W 2026-03-31T12:01:38.418Z 2026-04-06T12:30:07.590Z
9594487 9594487 20260328223709_LpHpF UK009W 2026-03-30T12:09:40.388Z 2026-04-06T12:39:54.142Z
9594231 9594231 20260328202811_Vai4V UK009W 2026-03-30T12:09:02.662Z 2026-04-06T12:39:44.050Z
9592898 9592898 20260329035042_NJsVh UK009W 2026-03-30T12:02:15.672Z 2026-04-06T12:34:39.465Z
9592804 9592804 20260329032421_xz4dM UK009W 2026-03-30T12:01:57.045Z 2026-04-06T12:34:28.619Z
9592557 9592557 20260329023006_6jQhS UK009W 2026-03-30T12:01:18.063Z 2026-04-06T12:34:15.289Z
9592355 9592355 20260329015645_kLQ4f UK009W 2026-03-30T12:00:46.440Z 2026-04-06T12:34:02.062Z
9589966 9589966 20260328042327_2QLAP UK009W 2026-03-29T12:01:47.280Z 2026-04-06T12:37:39.324Z
9589957 9589957 20260328042300_swGSF UK009W 2026-03-29T12:01:46.951Z 2026-04-06T12:37:39.149Z
9589914 9589914 20260328041950_mrS0i UK009W 2026-03-29T12:01:44.465Z 2026-04-06T12:37:38.051Z
9589901 9589901 20260328041640_2fScY UK009W 2026-03-29T12:01:42.790Z 2026-04-06T12:37:37.483Z
9589879 9589879 20260328041450_3gUQ0 UK009W 2026-03-29T12:01:42.019Z 2026-04-06T12:37:37.025Z
9589777 9589777 20260328040838_drdWD UK009W 2026-03-29T12:01:37.589Z 2026-04-06T12:37:33.171Z
9589757 9589757 20260328040521_c2MCt UK009W 2026-03-29T12:01:36.869Z 2026-04-06T12:37:32.722Z
9589700 9589700 20260328040002_IHF59 UK009W 2026-03-29T12:01:34.118Z 2026-04-06T12:37:31.668Z
9589646 9589646 20260328035457_XyUJU UK009W 2026-03-29T12:01:31.545Z 2026-04-06T12:37:30.189Z
9589566 9589566 20260328034710_c7n7h UK009W 2026-03-29T12:01:26.057Z 2026-04-06T12:37:27.707Z
9589551 9589551 20260328034548_v3o6J UK009W 2026-03-29T12:01:25.335Z 2026-04-06T12:37:27.451Z
9589413 9589413 20260328032804_L72Mn UK009W 2026-03-29T12:01:12.511Z 2026-04-06T12:37:22.697Z
9589056 9589056 20260328021921_OTnDO UK009W 2026-03-29T12:00:41.225Z 2026-04-06T12:37:00.868Z
9588975 9588975 20260328020912_LvPVH UK009W 2026-03-29T12:00:36.244Z 2026-04-06T12:36:58.638Z
9584810 9584810 20260325222001_W7A5z UK009W 2026-03-27T12:16:09.973Z 2026-04-03T12:39:41.547Z
9584432 9584432 20260325195058_5UwN2 UK009W 2026-03-27T12:15:17.913Z 2026-04-03T12:39:13.866Z
9584406 9584406 20260325194702_mQMGI UK009W 2026-03-27T12:15:13.458Z 2026-04-03T12:39:13.171Z
9582063 9582063 20260326042810_3oiIY UK009W 2026-03-27T12:04:30.323Z 2026-04-04T12:39:36.414Z
9582036 9582036 20260326042255_ceDiy UK009W 2026-03-27T12:04:26.564Z 2026-04-04T12:39:35.492Z
9582010 9582010 20260326042119_sEyfU UK009W 2026-03-27T12:04:24.688Z 2026-04-04T12:39:34.888Z
9581934 9581934 20260326041231_UAES2 UK009W 2026-03-27T12:04:12.887Z 2026-04-04T12:39:31.855Z
9581532 9581532 20260326032508_43ygg UK009W 2026-03-27T12:03:22.069Z 2026-04-04T12:39:09.826Z
9581244 9581244 20260326024142_xjMFP UK009W 2026-03-27T12:02:31.186Z 2026-04-04T12:38:48.534Z
9581168 9581168 20260326023147_XEwy5 UK009W 2026-03-27T12:02:17.154Z 2026-04-04T12:38:44.586Z
9580823 9580823 20260326013932_5Qy36 UK009W 2026-03-27T12:01:30.037Z 2026-04-04T12:38:30.553Z
9580556 9580556 20260326010113_2QO2t UK009W 2026-03-27T12:00:46.930Z 2026-04-04T12:38:13.944Z
9580505 9580505 20260326005712_yqcNF UK009W 2026-03-27T12:00:40.053Z 2026-04-04T12:38:12.553Z
9580462 9580462 20260326005033_tCgan UK009W 2026-03-27T12:00:31.618Z 2026-04-04T12:38:10.931Z
9580449 9580449 20260326004951_TBMOf UK009W 2026-03-27T12:00:30.309Z 2026-04-04T12:38:10.666Z
9579698 9579698 20260324221834_Tzx92 UK009W 2026-03-26T12:14:13.306Z 2026-04-02T12:37:26.151Z
9577236 9577236 20260325042240_aVGN2 UK009W 2026-03-26T12:04:30.435Z 2026-04-03T12:36:52.741Z
9577215 9577215 20260325041714_N6Ugq UK009W 2026-03-26T12:04:26.310Z 2026-04-03T12:36:51.969Z
9577012 9577012 20260325033845_d2KA6 UK009W 2026-03-26T12:03:53.821Z 2026-04-03T12:36:29.286Z
9576867 9576867 20260325031831_XYrzy UK009W 2026-03-26T12:03:31.476Z 2026-04-03T12:36:24.039Z
9576783 9576783 20260325030754_Kk3TI UK009W 2026-03-26T12:03:16.409Z 2026-04-03T12:36:20.775Z
9576744 9576744 20260325030225_TCCMh UK009W 2026-03-26T12:03:10.120Z 2026-04-03T12:36:19.563Z
9576519 9576519 20260325022723_4aLpg UK009W 2026-03-26T12:02:30.790Z 2026-04-03T12:36:11.237Z
9576373 9576373 20260325015744_N0zrn UK009W 2026-03-26T12:02:02.636Z 2026-04-03T12:35:55.082Z
9576200 9576200 20260325013410_5E5vj UK009W 2026-03-26T12:01:32.782Z 2026-04-03T12:35:48.185Z
9576183 9576183 20260325013153_usdti UK009W 2026-03-26T12:01:30.111Z 2026-04-03T12:35:47.424Z
9575971 9575971 20260325005101_EUp0t UK009W 2026-03-26T12:00:50.383Z 2026-04-03T12:35:38.405Z
9575800 9575800 20260325001906_1doBG UK009W 2026-03-26T12:00:15.231Z 2026-04-03T12:35:22.733Z
9562444 9562444 20260323022126_tVV5A UK009W 2026-03-24T12:03:08.167Z 2026-03-31T12:26:10.507Z
9562201 9562201 20260323014749_ocJLg UK009W 2026-03-24T12:02:26.588Z 2026-03-31T12:26:03.626Z
9561257 9561257 20260321231312_sf2Lu UK009W 2026-03-23T12:12:14.943Z 2026-03-29T12:21:05.991Z
9561125 9561125 20260321230307_yNYQL UK009W 2026-03-23T12:12:11.993Z 2026-03-29T12:21:05.261Z
9561064 9561064 20260321225158_dsu3T UK009W 2026-03-23T12:12:10.919Z 2026-03-29T12:21:04.963Z
9560770 9560770 20260321221143_6YjtN UK009W 2026-03-23T12:12:02.971Z 2026-03-29T12:21:02.738Z
9560653 9560653 20260321215623_wHXNZ UK009W 2026-03-23T12:12:00.264Z 2026-03-29T12:21:01.940Z
9560596 9560596 20260321214811_uJgqv UK009W 2026-03-23T12:11:58.734Z 2026-03-29T12:21:01.596Z
9560477 9560477 20260321213018_yiETv UK009W 2026-03-23T12:11:48.642Z 2026-03-29T12:21:00.636Z
9560136 9560136 20260321203354_Wf1Cn UK009W 2026-03-23T12:11:38.752Z 2026-03-29T12:20:58.138Z
9559952 9559952 20260321201411_0cmkt UK009W 2026-03-23T12:11:34.464Z 2026-03-29T12:20:56.782Z
9555328 9555328 20260322044034_InYWt UK009W 2026-03-23T12:03:20.882Z 2026-03-30T12:28:24.918Z
9555139 9555139 20260322041001_DRLrz UK009W 2026-03-23T12:03:11.636Z 2026-03-30T12:28:14.966Z
9555094 9555094 20260322040324_FGCGC UK009W 2026-03-23T12:03:09.716Z 2026-03-30T12:28:14.351Z
9554636 9554636 20260322032216_3fuyd UK009W 2026-03-23T12:02:44.026Z 2026-03-30T12:28:06.610Z
9554623 9554623 20260322032107_k3z3X UK009W 2026-03-23T12:02:43.717Z 2026-03-30T12:28:06.586Z
9554602 9554602 20260322032009_LgRRj UK009W 2026-03-23T12:02:42.737Z 2026-03-30T12:28:06.277Z
9554232 9554232 20260322025057_E2rLN UK009W 2026-03-23T12:02:21.724Z 2026-03-30T12:28:01.016Z
9553721 9553721 20260322020906_pQ5zU UK009W 2026-03-23T12:01:47.894Z 2026-03-30T12:27:51.506Z
9553634 9553634 20260322020225_xjoJh UK009W 2026-03-23T12:01:43.859Z 2026-03-30T12:27:50.390Z
9553495 9553495 20260322014547_jLmKy UK009W 2026-03-23T12:01:34.406Z 2026-03-30T12:27:42.224Z
9553411 9553411 20260322014112_9uEEG UK009W 2026-03-23T12:01:28.463Z 2026-03-30T12:27:40.524Z
9553313 9553313 20260322013003_EdXIT UK009W 2026-03-23T12:01:23.691Z 2026-03-30T12:27:39.257Z
9553224 9553224 20260322012641_RmJwb UK009W 2026-03-23T12:01:19.905Z 2026-03-30T12:27:38.175Z
9553203 9553203 20260322012356_ZKK0y UK009W 2026-03-23T12:01:18.971Z 2026-03-30T12:27:36.325Z
9553162 9553162 20260322012215_eitRi UK009W 2026-03-23T12:01:17.726Z 2026-03-30T12:27:35.898Z
9553033 9553033 20260322010443_dKSZF UK009W 2026-03-23T12:01:09.781Z 2026-03-30T12:27:33.864Z
9552895 9552895 20260322005112_2Glao UK009W 2026-03-23T12:00:58.653Z 2026-03-30T12:27:31.842Z
9552824 9552824 20260322004554_eRESb UK009W 2026-03-23T12:00:54.613Z 2026-03-30T12:27:30.966Z
9552566 9552566 20260322002048_OOC2V UK009W 2026-03-23T12:00:32.921Z 2026-03-30T12:27:26.128Z
9552531 9552531 20260322001614_ClFZf UK009W 2026-03-23T12:00:30.540Z 2026-03-30T12:27:25.581Z
9552494 9552494 20260322001509_s5MJS UK009W 2026-03-23T12:00:28.932Z 2026-03-30T12:27:25.101Z
9552380 9552380 20260321235806_OqLBC UK009W 2026-03-23T12:00:19.135Z 2026-03-30T12:27:23.079Z
9552150 9552150 20260320230405_vu3qR UK009W 2026-03-22T12:27:29.650Z 2026-03-28T12:37:07.309Z
9552145 9552145 20260320230404_OGs4w UK009W 2026-03-22T12:27:29.503Z 2026-03-28T12:37:07.247Z
9552027 9552027 20260320224033_Xdw5W UK009W 2026-03-22T12:27:23.313Z 2026-03-28T12:37:05.648Z
9551784 9551784 20260320212841_0IWaX UK009W 2026-03-22T12:27:02.357Z 2026-03-28T12:37:01.935Z
9543659 9543659 20260321043807_gOAY5 UK009W 2026-03-22T12:04:21.889Z 2026-03-29T12:19:09.832Z
9543597 9543597 20260321042503_QgH7F UK009W 2026-03-22T12:04:14.400Z 2026-03-29T12:19:09.215Z
9543539 9543539 20260321041851_caUve UK009W 2026-03-22T12:04:07.135Z 2026-03-29T12:19:08.787Z
9543503 9543503 20260321040509_e901H UK009W 2026-03-22T12:04:00.263Z 2026-03-29T12:19:08.356Z
9543459 9543459 20260321035857_5hzu6 UK009W 2026-03-22T12:03:52.787Z 2026-03-29T12:19:07.848Z

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