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,252 rows where station_code = "UK001S" 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
9272480 9272480 20260128021329_vLEln UK001S 2026-01-29T14:26:50.417Z 2026-01-29T14:30:25.353Z
9271896 9271896 20260127214256_dZAVh UK001S 2026-01-29T14:24:53.408Z 2026-01-29T14:30:25.227Z
9254534 9254534 20260123195942_ugjxM UK001S 2026-01-25T14:09:40.693Z 2026-01-29T14:46:29.069Z
9252704 9252704 20260123052832_h7NMQ UK001S 2026-01-24T14:16:52.036Z 2026-01-29T14:53:17.522Z
9252503 9252503 20260123034216_rTeWc UK001S 2026-01-24T14:15:54.392Z 2026-01-29T14:53:04.827Z
9207477 9207477 20260115014649_zqQc6 UK001S 2026-01-16T14:08:56.716Z 2026-01-22T15:03:22.990Z
9207461 9207461 20260115014357_An0LJ UK001S 2026-01-16T14:08:51.313Z 2026-01-22T15:03:22.510Z
9207432 9207432 20260115013949_okTV9 UK001S 2026-01-16T14:08:44.903Z 2026-01-22T15:03:21.898Z
9207179 9207179 20260114232719_OJc2W UK001S 2026-01-16T14:07:33.414Z 2026-01-22T15:03:13.318Z
9202616 9202616 20260114035448_Mv7CJ UK001S 2026-01-15T14:21:47.207Z 2026-01-22T15:09:23.712Z
9202303 9202303 20260114032713_xoe10 UK001S 2026-01-15T14:21:02.377Z 2026-01-22T15:09:16.135Z
9202273 9202273 20260114032506_iolXY UK001S 2026-01-15T14:20:50.562Z 2026-01-22T15:09:15.443Z
9202255 9202255 20260114032446_0IWZl UK001S 2026-01-15T14:20:45.183Z 2026-01-22T15:09:15.216Z
9202237 9202237 20260114032429_gSKye UK001S 2026-01-15T14:20:44.073Z 2026-01-22T15:09:15.124Z
9202215 9202215 20260114032347_GpkHq UK001S 2026-01-15T14:20:43.008Z 2026-01-22T15:09:15.001Z
9202110 9202110 20260114031742_13ncE UK001S 2026-01-15T14:20:33.474Z 2026-01-22T15:09:13.789Z
9201989 9201989 20260114030932_9LW35 UK001S 2026-01-15T14:20:13.560Z 2026-01-22T15:09:11.989Z
9201862 9201862 20260114030251_IHKaC UK001S 2026-01-15T14:19:56.713Z 2026-01-22T15:09:10.841Z
9201842 9201842 20260114025833_77bBR UK001S 2026-01-15T14:19:53.953Z 2026-01-22T15:09:10.470Z
9201649 9201649 20260114023743_A0fL9 UK001S 2026-01-15T14:19:14.186Z 2026-01-22T15:09:07.010Z
9201626 9201626 20260114023654_8O5e2 UK001S 2026-01-15T14:19:13.097Z 2026-01-22T15:09:06.883Z
9201481 9201481 20260114022028_Yi6z0 UK001S 2026-01-15T14:18:42.930Z 2026-01-22T15:09:04.277Z
9201373 9201373 20260114021150_2tZvb UK001S 2026-01-15T14:18:23.311Z 2026-01-22T15:09:02.584Z
9201185 9201185 20260114015341_crS3U UK001S 2026-01-15T14:17:45.040Z 2026-01-22T15:08:59.204Z
9201048 9201048 20260114013751_SnET0 UK001S 2026-01-15T14:17:20.760Z 2026-01-22T15:08:55.406Z
9200874 9200874 20260114011555_77WQ1 UK001S 2026-01-15T14:16:44.800Z 2026-01-22T15:08:32.112Z
9200729 9200729 20260114005733_L6PKz UK001S 2026-01-15T14:16:14.536Z 2026-01-22T15:08:24.740Z
9200582 9200582 20260114002902_upvX2 UK001S 2026-01-15T14:15:41.361Z 2026-01-22T15:08:19.992Z
9200500 9200500 20260114001412_WUk6Y UK001S 2026-01-15T14:15:21.245Z 2026-01-22T15:08:17.091Z
9200369 9200369 20260113235347_FHAUQ UK001S 2026-01-15T14:14:52.388Z 2026-01-22T15:08:14.768Z
9200277 9200277 20260113233312_Vrt0K UK001S 2026-01-15T14:14:35.475Z 2026-01-22T15:08:13.125Z
9200221 9200221 20260113231654_2A30x UK001S 2026-01-15T14:14:14.786Z 2026-01-22T15:08:11.690Z
9200031 9200031 20260113223142_DLVic UK001S 2026-01-15T14:13:35.731Z 2026-01-22T15:08:08.218Z
9199231 9199231 20260113193054_FLTIr UK001S 2026-01-15T14:10:03.101Z 2026-01-22T15:07:17.651Z
9199217 9199217 20260113192725_USTZG UK001S 2026-01-15T14:09:51.092Z 2026-01-22T15:07:17.113Z
9194136 9194136 20260112181848_jDZlh UK001S 2026-01-14T14:07:34.310Z 2026-01-21T15:03:33.458Z
9180310 9180310 20260110195624_g80G6 UK001S 2026-01-12T14:06:39.681Z 2026-01-19T15:15:55.985Z
9175298 9175298 20260110015930_FcKvx UK001S 2026-01-11T14:05:59.871Z 2026-01-18T15:07:40.147Z
9162191 9162191 20260107001048_K1BY4 UK001S 2026-01-08T14:03:27.287Z 2026-01-13T15:01:44.238Z
9162174 9162174 20260107000243_k9nY0 UK001S 2026-01-08T14:03:22.692Z 2026-01-13T15:01:42.297Z
9162087 9162087 20260106205555_L1MRL UK001S 2026-01-08T14:02:45.113Z 2026-01-13T15:01:34.665Z
9148182 9148182 20260103173316_3XK3s UK001S 2026-01-05T14:30:20.204Z 2026-01-10T15:04:19.542Z
9148035 9148035 20260103172810_TLmft UK001S 2026-01-05T14:30:15.029Z 2026-01-10T15:04:13.327Z
9147771 9147771 20260104065245_bF6Dh UK001S 2026-01-05T14:24:50.683Z 2026-01-12T15:11:39.605Z
9147750 9147750 20260104064311_wNGd0 UK001S 2026-01-05T14:24:48.016Z 2026-01-12T15:11:37.045Z
9147547 9147547 20260104060653_V2No7 UK001S 2026-01-05T14:24:22.244Z 2026-01-12T15:11:20.218Z
9147154 9147154 20260104051044_Usktc UK001S 2026-01-05T14:23:35.545Z 2026-01-12T15:10:17.233Z
9140086 9140086 20260103235857_a32gC UK001S 2026-01-05T14:12:27.933Z 2026-01-12T15:03:58.063Z
9140031 9140031 20260103235500_CFWzz UK001S 2026-01-05T14:12:23.315Z 2026-01-12T15:03:56.307Z
9139907 9139907 20260103235100_6ctcF UK001S 2026-01-05T14:12:17.035Z 2026-01-12T15:03:53.520Z
9139840 9139840 20260103234858_9thJA UK001S 2026-01-05T14:12:14.369Z 2026-01-12T15:03:52.159Z
9139809 9139809 20260103234803_2npcf UK001S 2026-01-05T14:12:13.528Z 2026-01-12T15:03:51.712Z
9139747 9139747 20260103234404_NCq6g UK001S 2026-01-05T14:12:01.098Z 2026-01-12T15:03:49.892Z
9139531 9139531 20260103233347_12u0e UK001S 2026-01-05T14:11:45.833Z 2026-01-12T15:03:32.818Z
9139392 9139392 20260103233032_D8GAC UK001S 2026-01-05T14:11:36.051Z 2026-01-12T15:03:27.025Z
9139176 9139176 20260103231702_YeRTu UK001S 2026-01-05T14:11:19.437Z 2026-01-12T15:03:22.756Z
9139168 9139168 20260103231604_CyeVa UK001S 2026-01-05T14:11:18.865Z 2026-01-12T15:03:22.478Z
9138982 9138982 20260103230634_qgqxw UK001S 2026-01-05T14:11:01.544Z 2026-01-12T15:03:17.451Z
9138827 9138827 20260103225646_3cFbw UK001S 2026-01-05T14:10:41.367Z 2026-01-12T15:03:06.063Z
9138418 9138418 20260103222511_jDRg8 UK001S 2026-01-05T14:09:55.321Z 2026-01-12T15:02:48.925Z
9138058 9138058 20260103215712_lVlo9 UK001S 2026-01-05T14:09:20.474Z 2026-01-12T15:02:28.875Z
9138051 9138051 20260103215536_plr24 UK001S 2026-01-05T14:09:19.887Z 2026-01-12T15:02:28.554Z
9137982 9137982 20260103215106_2uRqx UK001S 2026-01-05T14:09:15.926Z 2026-01-12T15:02:26.945Z
9137905 9137905 20260103214640_bNW4L UK001S 2026-01-05T14:09:10.690Z 2026-01-12T15:02:24.072Z
9137881 9137881 20260103214227_RBc3m UK001S 2026-01-05T14:09:08.135Z 2026-01-12T15:02:21.993Z
9137725 9137725 20260103212740_B3Jar UK001S 2026-01-05T14:08:53.011Z 2026-01-12T15:02:17.718Z
9137582 9137582 20260103211952_pT2ZB UK001S 2026-01-05T14:08:38.297Z 2026-01-12T15:02:14.538Z
9137545 9137545 20260103211755_BNJE3 UK001S 2026-01-05T14:08:36.324Z 2026-01-12T15:02:13.692Z
9137333 9137333 20260103210246_krCaq UK001S 2026-01-05T14:08:19.682Z 2026-01-12T15:02:05.714Z
9137178 9137178 20260103204729_C7Hdo UK001S 2026-01-05T14:07:58.859Z 2026-01-12T15:01:52.080Z
9137127 9137127 20260103204328_37aqM UK001S 2026-01-05T14:07:55.442Z 2026-01-12T15:01:49.572Z
9137040 9137040 20260103203512_fDy51 UK001S 2026-01-05T14:07:45.971Z 2026-01-12T15:01:46.442Z
9136846 9136846 20260103202201_OdlVC UK001S 2026-01-05T14:07:21.475Z 2026-01-12T15:01:41.217Z
9136802 9136802 20260103201602_Vxl5T UK001S 2026-01-05T14:07:16.081Z 2026-01-12T15:01:39.518Z
9136778 9136778 20260103201539_EVzNK UK001S 2026-01-05T14:07:15.315Z 2026-01-12T15:01:38.854Z
9136715 9136715 20260103201300_YrKG2 UK001S 2026-01-05T14:07:11.633Z 2026-01-12T15:01:37.320Z
9136668 9136668 20260103201032_ti2LU UK001S 2026-01-05T14:07:09.837Z 2026-01-12T15:01:36.365Z
9136538 9136538 20260103200127_v2vfr UK001S 2026-01-05T14:06:54.025Z 2026-01-12T15:01:22.482Z
9136397 9136397 20260103195311_W5E4q UK001S 2026-01-05T14:06:38.360Z 2026-01-12T15:01:16.644Z
9136347 9136347 20260103195056_hgcrk UK001S 2026-01-05T14:06:35.973Z 2026-01-12T15:01:15.915Z
9136271 9136271 20260103194428_Siyv5 UK001S 2026-01-05T14:06:29.850Z 2026-01-12T15:01:13.618Z
9136225 9136225 20260103194340_FEkZG UK001S 2026-01-05T14:06:22.987Z 2026-01-12T15:01:12.957Z
9136175 9136175 20260103194138_1FYVh UK001S 2026-01-05T14:06:17.069Z 2026-01-12T15:01:11.569Z
9136144 9136144 20260103193948_8VEEp UK001S 2026-01-05T14:06:13.685Z 2026-01-12T15:01:10.791Z
9136039 9136039 20260103193107_TmkGp UK001S 2026-01-05T14:06:00.336Z 2026-01-12T15:01:05.063Z
9136004 9136004 20260103192927_9AJsX UK001S 2026-01-05T14:05:53.418Z 2026-01-12T15:01:04.247Z
9135839 9135839 20260103191642_Drosw UK001S 2026-01-05T14:05:28.056Z 2026-01-12T15:00:48.704Z
9135731 9135731 20260103190933_S7Wfm UK001S 2026-01-05T14:05:10.125Z 2026-01-12T15:00:45.213Z
9135701 9135701 20260103190755_b63L6 UK001S 2026-01-05T14:05:07.867Z 2026-01-12T15:00:44.420Z
9135543 9135543 20260103185817_wxX3J UK001S 2026-01-05T14:04:45.127Z 2026-01-12T15:00:40.138Z
9135481 9135481 20260103185634_Xgx69 UK001S 2026-01-05T14:04:40.443Z 2026-01-12T15:00:38.112Z
9135402 9135402 20260103185441_IkNE9 UK001S 2026-01-05T14:04:27.479Z 2026-01-12T15:00:29.673Z
9135177 9135177 20260103184441_VQ0t0 UK001S 2026-01-05T14:03:52.830Z 2026-01-12T15:00:14.315Z
9135126 9135126 20260103184145_TeJLG UK001S 2026-01-05T14:03:45.336Z 2026-01-12T15:00:10.948Z
9135009 9135009 20260103183513_3uWT2 UK001S 2026-01-05T14:03:25.278Z 2026-01-12T14:59:59.607Z
9134851 9134851 20260103182514_rJPUo UK001S 2026-01-05T14:03:01.413Z 2026-01-12T14:59:52.648Z
9134722 9134722 20260103181901_Rw8UE UK001S 2026-01-05T14:02:42.943Z 2026-01-12T14:59:48.608Z
9134606 9134606 20260103181342_pokpj UK001S 2026-01-05T14:02:27.717Z 2026-01-12T14:59:42.218Z
9134534 9134534 20260103181124_3ZwKi UK001S 2026-01-05T14:02:13.450Z 2026-01-12T14:59:36.525Z
9134433 9134433 20260103180703_uAgOX UK001S 2026-01-05T14:01:54.814Z 2026-01-12T14:59:32.661Z

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