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

3,730 rows where station_code = "UK0090" 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
9273516 9273516 20260128064756_x23gd UK0090 2026-01-29T14:30:02.475Z 2026-01-29T14:30:25.827Z
9273488 9273488 20260128063141_Px5G3 UK0090 2026-01-29T14:29:59.877Z 2026-01-29T14:30:25.823Z
9272759 9272759 20260128031704_FXCou UK0090 2026-01-29T14:27:43.513Z 2026-01-29T14:30:25.448Z
9272692 9272692 20260128030817_1ppHL UK0090 2026-01-29T14:27:29.004Z 2026-01-29T14:30:25.439Z
9272671 9272671 20260128025957_TUvSo UK0090 2026-01-29T14:27:27.176Z 2026-01-29T14:30:25.437Z
9272593 9272593 20260128024654_eW3DW UK0090 2026-01-29T14:27:13.053Z 2026-01-29T14:30:25.381Z
9214002 9214002 20260116051259_xtbtW UK0090 2026-01-17T14:19:34.739Z 2026-01-24T15:12:57.082Z
9213971 9213971 20260116051115_137GO UK0090 2026-01-17T14:19:26.088Z 2026-01-24T15:12:55.308Z
9213725 9213725 20260116043043_f6Q0L UK0090 2026-01-17T14:18:15.589Z 2026-01-24T15:12:32.338Z
9213120 9213120 20260116021839_qgbeR UK0090 2026-01-17T14:15:31.785Z 2026-01-24T15:11:42.936Z
9208079 9208079 20260115041004_X63rD UK0090 2026-01-16T14:11:14.828Z 2026-01-22T15:04:00.675Z
9203709 9203709 20260114053054_LRhQ6 UK0090 2026-01-15T14:25:13.461Z 2026-01-22T15:10:12.549Z
9203549 9203549 20260114051659_2IAbM UK0090 2026-01-15T14:24:46.587Z 2026-01-22T15:10:09.814Z
9203233 9203233 20260114044407_3b1Kl UK0090 2026-01-15T14:23:52.535Z 2026-01-22T15:10:04.181Z
9203229 9203229 20260114044353_zIIzi UK0090 2026-01-15T14:23:52.034Z 2026-01-22T15:10:04.128Z
9203218 9203218 20260114044353_65Jnx UK0090 2026-01-15T14:23:42.047Z 2026-01-22T15:10:04.011Z
9203066 9203066 20260114043113_ai005 UK0090 2026-01-15T14:23:14.691Z 2026-01-22T15:10:01.153Z
9202923 9202923 20260114041838_TSxdt UK0090 2026-01-15T14:22:48.384Z 2026-01-22T15:09:59.434Z
9202795 9202795 20260114040826_l5qbF UK0090 2026-01-15T14:22:21.995Z 2026-01-22T15:09:41.110Z
9202673 9202673 20260114035955_DWOnW UK0090 2026-01-15T14:22:05.953Z 2026-01-22T15:09:24.604Z
9202160 9202160 20260114032140_QXRa8 UK0090 2026-01-15T14:20:36.727Z 2026-01-22T15:09:14.334Z
9201546 9201546 20260114022930_sEduo UK0090 2026-01-15T14:18:55.404Z 2026-01-22T15:09:05.780Z
9201493 9201493 20260114022038_hacY7 UK0090 2026-01-15T14:18:43.889Z 2026-01-22T15:09:04.403Z
9201073 9201073 20260114014013_fMuK9 UK0090 2026-01-15T14:17:31.660Z 2026-01-22T15:08:57.508Z
9200989 9200989 20260114012749_VXZkB UK0090 2026-01-15T14:17:09.046Z 2026-01-22T15:08:41.955Z
9200952 9200952 20260114012554_VgaJw UK0090 2026-01-15T14:17:06.074Z 2026-01-22T15:08:40.649Z
9200768 9200768 20260114010205_5eWaq UK0090 2026-01-15T14:16:22.740Z 2026-01-22T15:08:25.437Z
9200751 9200751 20260114010057_7sVAy UK0090 2026-01-15T14:16:21.427Z 2026-01-22T15:08:25.315Z
9200453 9200453 20260114001234_63k2I UK0090 2026-01-15T14:15:14.526Z 2026-01-22T15:08:16.216Z
9200413 9200413 20260114000623_DX36d UK0090 2026-01-15T14:15:10.035Z 2026-01-22T15:08:15.697Z
9200407 9200407 20260114000618_pgiWz UK0090 2026-01-15T14:15:08.070Z 2026-01-22T15:08:15.593Z
9200300 9200300 20260113233756_ipWWP UK0090 2026-01-15T14:14:39.338Z 2026-01-22T15:08:13.450Z
9200077 9200077 20260113224721_e4dHi UK0090 2026-01-15T14:13:42.615Z 2026-01-22T15:08:09.127Z
9200027 9200027 20260113222608_teTHG UK0090 2026-01-15T14:13:34.622Z 2026-01-22T15:08:07.982Z
9200008 9200008 20260113222233_kAaLc UK0090 2026-01-15T14:13:31.434Z 2026-01-22T15:08:07.612Z
9199995 9199995 20260113221546_O8FtI UK0090 2026-01-15T14:13:28.384Z 2026-01-22T15:08:07.290Z
9199880 9199880 20260113214733_3XSCA UK0090 2026-01-15T14:12:56.401Z 2026-01-22T15:08:04.638Z
9199863 9199863 20260113213518_pjtZv UK0090 2026-01-15T14:12:52.648Z 2026-01-22T15:08:04.274Z
9199409 9199409 20260113195610_qrzIQ UK0090 2026-01-15T14:10:43.673Z 2026-01-22T15:07:23.600Z
9199340 9199340 20260113194737_1soDa UK0090 2026-01-15T14:10:28.080Z 2026-01-22T15:07:22.293Z
9198694 9198694 20260113173834_8cBsD UK0090 2026-01-15T14:06:30.356Z 2026-01-22T15:07:01.108Z
9195649 9195649 20260113021057_OPhUI UK0090 2026-01-14T14:14:16.454Z 2026-01-21T15:04:44.986Z
9195410 9195410 20260113012021_7qNk6 UK0090 2026-01-14T14:13:12.282Z 2026-01-21T15:04:40.104Z
9195384 9195384 20260113011606_Z6L2M UK0090 2026-01-14T14:13:07.160Z 2026-01-21T15:04:39.733Z
9195309 9195309 20260113010014_sVbac UK0090 2026-01-14T14:12:49.889Z 2026-01-21T15:04:38.906Z
9195301 9195301 20260113005831_c4Blu UK0090 2026-01-14T14:12:48.415Z 2026-01-21T15:04:38.809Z
9195252 9195252 20260113004757_ns0hq UK0090 2026-01-14T14:12:37.359Z 2026-01-21T15:04:38.162Z
9195224 9195224 20260113004227_298kX UK0090 2026-01-14T14:12:26.057Z 2026-01-21T15:04:37.653Z
9195210 9195210 20260113003847_IRcrD UK0090 2026-01-14T14:12:24.006Z 2026-01-21T15:04:37.551Z
9195179 9195179 20260113003335_3rE4F UK0090 2026-01-14T14:12:20.423Z 2026-01-21T15:04:37.353Z
9195059 9195059 20260113000854_qBOA3 UK0090 2026-01-14T14:11:51.655Z 2026-01-21T15:04:35.680Z
9194919 9194919 20260112233027_2kSKA UK0090 2026-01-14T14:11:20.145Z 2026-01-21T15:04:34.041Z
9194721 9194721 20260112221653_pm5Hh UK0090 2026-01-14T14:10:23.979Z 2026-01-21T15:04:20.310Z
9194369 9194369 20260112201256_tSEYt UK0090 2026-01-14T14:08:53.674Z 2026-01-21T15:03:53.394Z
9176435 9176435 20260110052946_p1mUg UK0090 2026-01-11T14:09:00.905Z 2026-01-18T15:08:39.098Z
9176180 9176180 20260110045843_PNX7y UK0090 2026-01-11T14:08:23.189Z 2026-01-18T15:08:23.069Z
9175607 9175607 20260110031035_SbOVW UK0090 2026-01-11T14:06:53.470Z 2026-01-18T15:07:53.262Z
9175214 9175214 20260110014005_oqcPn UK0090 2026-01-11T14:05:42.550Z 2026-01-18T15:07:37.182Z
9167171 9167171 20260107231834_PzKxu UK0090 2026-01-09T14:06:33.228Z 2026-01-16T15:10:53.763Z
9167069 9167069 20260107221950_r3Fey UK0090 2026-01-09T14:06:06.455Z 2026-01-16T15:10:47.497Z
9166437 9166437 20260107182945_mExQZ UK0090 2026-01-09T14:03:14.853Z 2026-01-16T15:09:54.922Z
9163451 9163451 20260107064421_fKw3o UK0090 2026-01-08T14:09:11.689Z 2026-01-13T15:03:16.120Z
9163401 9163401 20260107063022_YXpF9 UK0090 2026-01-08T14:09:02.454Z 2026-01-13T15:03:13.795Z
9162596 9162596 20260107033914_2KYMT UK0090 2026-01-08T14:05:56.866Z 2026-01-13T15:02:20.813Z
9162556 9162556 20260107032735_xvJC6 UK0090 2026-01-08T14:05:43.796Z 2026-01-13T15:02:18.572Z
9162539 9162539 20260107032322_cRmvJ UK0090 2026-01-08T14:05:37.663Z 2026-01-13T15:02:17.313Z
9162504 9162504 20260107031028_mdffB UK0090 2026-01-08T14:05:30.463Z 2026-01-13T15:02:14.199Z
9162163 9162163 20260106234839_Xwz11 UK0090 2026-01-08T14:03:18.376Z 2026-01-13T15:01:41.554Z
9159910 9159910 20260106041704_yB9Gw UK0090 2026-01-07T14:10:47.318Z 2026-01-13T15:08:52.658Z
9159795 9159795 20260106034741_zZvuW UK0090 2026-01-07T14:10:25.410Z 2026-01-13T15:08:47.209Z
9159637 9159637 20260106031744_1PWaU UK0090 2026-01-07T14:09:59.674Z 2026-01-13T15:08:34.835Z
9159121 9159121 20260106014647_BNUg2 UK0090 2026-01-07T14:08:21.934Z 2026-01-13T15:08:09.007Z
9159044 9159044 20260106013326_f5KQ4 UK0090 2026-01-07T14:08:10.111Z 2026-01-13T15:07:58.650Z
9159006 9159006 20260106012224_YaM8J UK0090 2026-01-07T14:07:59.918Z 2026-01-13T15:07:56.832Z
9158767 9158767 20260106002334_SLuGf UK0090 2026-01-07T14:07:15.049Z 2026-01-13T15:07:45.794Z
9158568 9158568 20260105232221_pGjux UK0090 2026-01-07T14:06:33.204Z 2026-01-13T15:07:30.004Z
9158379 9158379 20260105220633_Wxwh3 UK0090 2026-01-07T14:05:53.211Z 2026-01-13T15:07:19.813Z
9158327 9158327 20260105215558_p36mL UK0090 2026-01-07T14:05:45.678Z 2026-01-13T15:07:18.362Z
9158240 9158240 20260105211524_h07Ge UK0090 2026-01-07T14:05:28.569Z 2026-01-13T15:07:13.657Z
9157836 9157836 20260105185854_ZcSiH UK0090 2026-01-07T14:03:48.655Z 2026-01-13T15:06:33.932Z
9156123 9156123 20260104065211_kD5Lr UK0090 2026-01-06T14:38:37.860Z 2026-01-12T15:11:39.413Z
9156092 9156092 20260104064443_HnAKF UK0090 2026-01-06T14:38:32.133Z 2026-01-12T15:11:37.494Z
9156088 9156088 20260104064350_OwWri UK0090 2026-01-06T14:38:31.705Z 2026-01-12T15:11:37.389Z
9153156 9153156 20260103222718_aQk35 UK0090 2026-01-06T14:24:17.768Z 2026-01-12T15:02:50.260Z
9153138 9153138 20260103210114_EygQu UK0090 2026-01-06T14:23:18.083Z 2026-01-12T15:01:56.610Z
9150776 9150776 20260105032735_0lUW1 UK0090 2026-01-06T14:11:20.121Z 2026-01-13T15:14:00.305Z
9150734 9150734 20260105032156_wlt0o UK0090 2026-01-06T14:11:13.496Z 2026-01-13T15:13:51.900Z
9150666 9150666 20260105030442_2Hrk0 UK0090 2026-01-06T14:10:55.115Z 2026-01-13T15:13:47.813Z
9150617 9150617 20260105025835_iO8lH UK0090 2026-01-06T14:10:43.911Z 2026-01-13T15:13:44.085Z
9150590 9150590 20260105025156_hiJFA UK0090 2026-01-06T14:10:39.373Z 2026-01-13T15:13:43.214Z
9150544 9150544 20260105024525_Dw8Z8 UK0090 2026-01-06T14:10:25.615Z 2026-01-13T15:13:40.442Z
9150204 9150204 20260105012938_q9J9G UK0090 2026-01-06T14:09:03.124Z 2026-01-13T15:13:10.774Z
9150186 9150186 20260105012325_rnxLf UK0090 2026-01-06T14:09:00.350Z 2026-01-13T15:13:09.981Z
9150171 9150171 20260105012118_bmtyT UK0090 2026-01-06T14:08:56.268Z 2026-01-13T15:13:09.186Z
9150155 9150155 20260105011614_3HymE UK0090 2026-01-06T14:08:49.234Z 2026-01-13T15:13:08.304Z
9149966 9149966 20260105001957_fKLBQ UK0090 2026-01-06T14:07:59.553Z 2026-01-13T15:12:47.754Z
9149928 9149928 20260105001306_1nuB8 UK0090 2026-01-06T14:07:51.672Z 2026-01-13T15:12:45.979Z
9149845 9149845 20260104235340_MVt4B UK0090 2026-01-06T14:07:28.855Z 2026-01-13T15:12:42.385Z
9149722 9149722 20260104231320_MB2J6 UK0090 2026-01-06T14:06:53.431Z 2026-01-13T15:12:35.809Z
9148253 9148253 20260103173807_ZlGIO UK0090 2026-01-05T14:30:23.490Z 2026-01-10T15:04:24.057Z

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