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

7,475 rows where station_code = "UK003E" 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
9590017 9590017 20260328042847_Ada8V UK003E 2026-03-29T12:01:52.246Z 2026-04-06T12:37:47.184Z
9589964 9589964 20260328042327_2QLAP UK003E 2026-03-29T12:01:47.280Z 2026-04-06T12:37:39.324Z
9589894 9589894 20260328041638_sujJt UK003E 2026-03-29T12:01:42.574Z 2026-04-06T12:37:37.350Z
9589747 9589747 20260328040520_ZnYMU UK003E 2026-03-29T12:01:36.749Z 2026-04-06T12:37:32.685Z
9589707 9589707 20260328040002_2LibW UK003E 2026-03-29T12:01:34.347Z 2026-04-06T12:37:31.818Z
9589543 9589543 20260328034547_g3jvD UK003E 2026-03-29T12:01:24.992Z 2026-04-06T12:37:27.326Z
9589403 9589403 20260328032804_PTXSO UK003E 2026-03-29T12:01:12.251Z 2026-04-06T12:37:22.565Z
9588990 9588990 20260328020912_NqTCp UK003E 2026-03-29T12:00:36.405Z 2026-04-06T12:36:58.726Z
9588858 9588858 20260328013746_r2kYs UK003E 2026-03-29T12:00:23.341Z 2026-04-06T12:36:54.318Z
9585137 9585137 20260325233302_zGkxv UK003E 2026-03-27T12:16:50.374Z 2026-04-03T12:39:50.346Z
9584806 9584806 20260325222001_W7A5z UK003E 2026-03-27T12:16:09.973Z 2026-04-03T12:39:41.547Z
9582032 9582032 20260326042255_ceDiy UK003E 2026-03-27T12:04:26.564Z 2026-04-04T12:39:35.492Z
9581930 9581930 20260326041231_UAES2 UK003E 2026-03-27T12:04:12.887Z 2026-04-04T12:39:31.855Z
9581712 9581712 20260326034812_3Koyf UK003E 2026-03-27T12:03:44.413Z 2026-04-04T12:39:16.599Z
9581166 9581166 20260326023147_XEwy5 UK003E 2026-03-27T12:02:17.154Z 2026-04-04T12:38:44.586Z
9581039 9581039 20260326021450_zKwN1 UK003E 2026-03-27T12:01:57.926Z 2026-04-04T12:38:40.447Z
9580501 9580501 20260326005712_yqcNF UK003E 2026-03-27T12:00:40.046Z 2026-04-04T12:38:12.553Z
9580383 9580383 20260326004243_1O7cj UK003E 2026-03-27T12:00:19.889Z 2026-04-04T12:38:08.084Z
9580148 9580148 20260325001258_ixOx7 UK003E 2026-03-26T12:15:10.613Z 2026-04-02T12:37:43.949Z
9576707 9576707 20260325025747_QHkG9 UK003E 2026-03-26T12:03:03.988Z 2026-04-03T12:36:18.436Z
9576398 9576398 20260325020121_hyQ3V UK003E 2026-03-26T12:02:07.200Z 2026-04-03T12:35:57.394Z
9576247 9576247 20260325014434_Akk2c UK003E 2026-03-26T12:01:43.073Z 2026-04-03T12:35:50.260Z
9576178 9576178 20260325013153_usdti UK003E 2026-03-26T12:01:30.111Z 2026-04-03T12:35:47.424Z
9575854 9575854 20260325002822_LPGW8 UK003E 2026-03-26T12:00:25.843Z 2026-04-03T12:35:26.576Z
9561238 9561238 20260321231207_9SltZ UK003E 2026-03-23T12:12:14.742Z 2026-03-29T12:21:05.902Z
9561121 9561121 20260321230307_yNYQL UK003E 2026-03-23T12:12:11.993Z 2026-03-29T12:21:05.261Z
9561061 9561061 20260321225158_dsu3T UK003E 2026-03-23T12:12:10.918Z 2026-03-29T12:21:04.963Z
9555441 9555441 20260322045624_1jO2C UK003E 2026-03-23T12:03:26.165Z 2026-03-30T12:28:26.623Z
9554798 9554798 20260322033609_nit2u UK003E 2026-03-23T12:02:51.412Z 2026-03-30T12:28:09.053Z
9554789 9554789 20260322033455_L3FIy UK003E 2026-03-23T12:02:51.131Z 2026-03-30T12:28:08.968Z
9554227 9554227 20260322025057_E2rLN UK003E 2026-03-23T12:02:21.724Z 2026-03-30T12:28:01.016Z
9554195 9554195 20260322024831_Dpf34 UK003E 2026-03-23T12:02:19.803Z 2026-03-30T12:28:00.272Z
9553756 9553756 20260322021227_CDB9I UK003E 2026-03-23T12:01:50.417Z 2026-03-30T12:27:52.157Z
9553221 9553221 20260322012641_RmJwb UK003E 2026-03-23T12:01:19.905Z 2026-03-30T12:27:38.175Z
9552976 9552976 20260322010055_k1Kr8 UK003E 2026-03-23T12:01:06.650Z 2026-03-30T12:27:33.290Z
9552920 9552920 20260322005617_aTSgu UK003E 2026-03-23T12:01:00.724Z 2026-03-30T12:27:32.290Z
9552889 9552889 20260322005112_2Glao UK003E 2026-03-23T12:00:58.639Z 2026-03-30T12:27:31.842Z
9534911 9534911 20260320043952_lafVe UK003E 2026-03-21T12:09:10.192Z 2026-03-28T12:34:23.497Z
9534552 9534552 20260320035746_NwaKN UK003E 2026-03-21T12:08:14.036Z 2026-03-28T12:34:19.187Z
9534402 9534402 20260320034810_hTyEj UK003E 2026-03-21T12:07:54.646Z 2026-03-28T12:34:17.985Z
9534265 9534265 20260320033853_7va3B UK003E 2026-03-21T12:07:35.514Z 2026-03-28T12:34:16.788Z
9534014 9534014 20260320031730_2mXct UK003E 2026-03-21T12:06:54.881Z 2026-03-28T12:34:03.672Z
9533729 9533729 20260320025356_fWoUf UK003E 2026-03-21T12:06:08.420Z 2026-03-28T12:33:59.931Z
9533607 9533607 20260320024602_B074O UK003E 2026-03-21T12:05:52.717Z 2026-03-28T12:33:56.950Z
9533479 9533479 20260320023226_SA1E2 UK003E 2026-03-21T12:05:30.048Z 2026-03-28T12:33:53.349Z
9533451 9533451 20260320023056_5I7mS UK003E 2026-03-21T12:05:27.322Z 2026-03-28T12:33:53.108Z
9533404 9533404 20260320022902_Fm8W4 UK003E 2026-03-21T12:05:22.135Z 2026-03-28T12:33:52.825Z
9533322 9533322 20260320022427_19dRJ UK003E 2026-03-21T12:05:10.686Z 2026-03-28T12:33:52.019Z
9533152 9533152 20260320020416_PQ3U2 UK003E 2026-03-21T12:04:36.043Z 2026-03-28T12:33:49.317Z
9532647 9532647 20260320011637_2Gpip UK003E 2026-03-21T12:03:20.335Z 2026-03-28T12:33:34.983Z
9532455 9532455 20260320005919_MLo0H UK003E 2026-03-21T12:02:47.048Z 2026-03-28T12:33:31.634Z
9532130 9532130 20260320002127_6l1Kc UK003E 2026-03-21T12:01:47.315Z 2026-03-28T12:33:24.806Z
9531645 9531645 20260319233358_NY2Ue UK003E 2026-03-21T12:00:25.494Z 2026-03-28T12:33:19.832Z
9531615 9531615 20260319232805_BjyUV UK003E 2026-03-21T12:00:21.634Z 2026-03-28T12:33:19.210Z
9531599 9531599 20260319232805_650yr UK003E 2026-03-21T12:00:21.227Z 2026-03-28T12:33:19.153Z
9531557 9531557 20260319232509_sJjT7 UK003E 2026-03-21T12:00:13.678Z 2026-03-28T12:33:18.381Z
9531238 9531238 20260318224833_30WIw UK003E 2026-03-20T12:25:02.833Z 2026-03-26T12:39:18.278Z
9530563 9530563 20260318211124_DR3f7 UK003E 2026-03-20T12:24:29.890Z 2026-03-26T12:39:13.870Z
9520687 9520687 20260319033158_JwEQ1 UK003E 2026-03-20T12:06:48.662Z 2026-03-27T12:40:46.330Z
9519955 9519955 20260319024528_6Ogo6 UK003E 2026-03-20T12:05:25.360Z 2026-03-27T12:40:37.258Z
9519920 9519920 20260319024326_ScdVs UK003E 2026-03-20T12:05:23.119Z 2026-03-27T12:40:37.041Z
9518266 9518266 20260319004719_QPFk5 UK003E 2026-03-20T12:02:14.621Z 2026-03-27T12:40:08.131Z
9512292 9512292 20260318050406_FkVXi UK003E 2026-03-19T12:12:06.713Z 2026-03-26T12:37:43.651Z
9512136 9512136 20260318044558_L09e1 UK003E 2026-03-19T12:11:46.684Z 2026-03-26T12:37:42.637Z
9510816 9510816 20260318031640_kAHwD UK003E 2026-03-19T12:08:44.504Z 2026-03-26T12:37:16.894Z
9510809 9510809 20260318031640_ScN0b UK003E 2026-03-19T12:08:43.988Z 2026-03-26T12:37:16.865Z
9510802 9510802 20260318031640_Jh5aP UK003E 2026-03-19T12:08:43.452Z 2026-03-26T12:37:16.841Z
9510250 9510250 20260318024025_6Q8aE UK003E 2026-03-19T12:07:13.567Z 2026-03-26T12:37:11.053Z
9510239 9510239 20260318024025_va3gD UK003E 2026-03-19T12:07:12.810Z 2026-03-26T12:37:11.028Z
9510074 9510074 20260318023159_llYXR UK003E 2026-03-19T12:06:51.358Z 2026-03-26T12:37:09.767Z
9510056 9510056 20260318023159_YDQcJ UK003E 2026-03-19T12:06:50.001Z 2026-03-26T12:37:09.625Z
9509714 9509714 20260318020942_7UeYc UK003E 2026-03-19T12:06:01.842Z 2026-03-26T12:37:07.340Z
9508626 9508626 20260318010711_lrL3K UK003E 2026-03-19T12:03:32.792Z 2026-03-26T12:36:59.876Z
9508539 9508539 20260318010244_oUwja UK003E 2026-03-19T12:03:18.239Z 2026-03-26T12:36:59.208Z
9508446 9508446 20260318005536_2lzpc UK003E 2026-03-19T12:03:06.957Z 2026-03-26T12:36:58.550Z
9507511 9507511 20260317231136_ceK5g UK003E 2026-03-19T12:00:19.634Z 2026-03-26T12:36:37.570Z
9501070 9501070 20260315205115_24sZ2 UK003E 2026-03-17T12:24:22.471Z 2026-03-23T12:22:42.919Z
9494764 9494764 20260316025817_XGEFi UK003E 2026-03-17T12:04:53.111Z 2026-03-24T12:40:49.869Z
9492369 9492369 20260314203617_ahxFv UK003E 2026-03-16T12:28:29.691Z 2026-03-22T12:42:52.026Z
9492315 9492315 20260314202000_scx2H UK003E 2026-03-16T12:28:22.424Z 2026-03-22T12:42:51.626Z
9492289 9492289 20260314200915_4dJ7U UK003E 2026-03-16T12:28:16.303Z 2026-03-22T12:42:51.533Z
9492274 9492274 20260314200512_DBh16 UK003E 2026-03-16T12:28:15.415Z 2026-03-22T12:42:51.455Z
9492111 9492111 20260314192628_9vfqi UK003E 2026-03-16T12:28:03.686Z 2026-03-22T12:42:50.406Z
9485120 9485120 20260315023124_RXqDa UK003E 2026-03-16T12:05:20.797Z 2026-03-23T12:21:50.093Z
9483008 9483008 20260313201720_w24Zg UK003E 2026-03-15T12:25:44.533Z 2026-03-21T12:50:16.479Z
9477453 9477453 20260314045805_8UURL UK003E 2026-03-15T12:08:20.265Z 2026-03-22T12:42:02.874Z
9477448 9477448 20260314045805_DHql3 UK003E 2026-03-15T12:08:19.785Z 2026-03-22T12:42:02.849Z
9477438 9477438 20260314045715_EgyVl UK003E 2026-03-15T12:08:17.589Z 2026-03-22T12:42:02.782Z
9477388 9477388 20260314045232_u4kWc UK003E 2026-03-15T12:08:13.601Z 2026-03-22T12:42:02.597Z
9477049 9477049 20260314040903_JihCo UK003E 2026-03-15T12:07:30.734Z 2026-03-22T12:42:00.854Z
9477037 9477037 20260314040823_mhRMC UK003E 2026-03-15T12:07:30.333Z 2026-03-22T12:42:00.822Z
9476872 9476872 20260314035048_yZm3X UK003E 2026-03-15T12:07:06.958Z 2026-03-22T12:41:59.874Z
9476672 9476672 20260314033003_seIdg UK003E 2026-03-15T12:06:37.678Z 2026-03-22T12:41:58.514Z
9476543 9476543 20260314031457_3SYmF UK003E 2026-03-15T12:06:16.378Z 2026-03-22T12:41:57.553Z
9476409 9476409 20260314030329_HpiPa UK003E 2026-03-15T12:05:54.087Z 2026-03-22T12:41:56.557Z
9476064 9476064 20260314023604_f9YvG UK003E 2026-03-15T12:04:59.208Z 2026-03-22T12:41:54.030Z
9476021 9476021 20260314023215_Gseih UK003E 2026-03-15T12:04:54.518Z 2026-03-22T12:41:53.814Z
9474816 9474816 20260314000155_vx9YZ UK003E 2026-03-15T12:01:26.437Z 2026-03-22T12:41:24.545Z
9467094 9467094 20260311200253_rNdNP UK003E 2026-03-13T12:18:18.650Z 2026-03-19T12:45:48.057Z
9462324 9462324 20260311225413_bPgYS UK003E 2026-03-13T12:00:31.199Z 2026-03-20T12:36:15.163Z

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