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,321 rows where station_code = "UK0061" 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
9224443 9224443 20260118044642_FYUgi UK0061 2026-01-19T14:24:24.303Z 2026-01-26T15:03:19.132Z
9224371 9224371 20260118042811_8qlDJ UK0061 2026-01-19T14:24:07.332Z 2026-01-26T15:03:16.195Z
9224317 9224317 20260118041635_X8Wob UK0061 2026-01-19T14:23:49.331Z 2026-01-26T15:03:13.804Z
9224202 9224202 20260118035120_7HQ3T UK0061 2026-01-19T14:23:18.917Z 2026-01-26T15:03:08.697Z
9223986 9223986 20260118030536_3zKni UK0061 2026-01-19T14:22:13.127Z 2026-01-26T15:02:46.978Z
9223841 9223841 20260118023134_MA6u8 UK0061 2026-01-19T14:21:22.272Z 2026-01-26T15:02:38.198Z
9223694 9223694 20260118020422_m4Xnu UK0061 2026-01-19T14:20:40.489Z 2026-01-26T15:02:32.712Z
9223543 9223543 20260118011535_E1u2w UK0061 2026-01-19T14:19:54.024Z 2026-01-26T15:02:13.870Z
9223485 9223485 20260118005420_ImvqJ UK0061 2026-01-19T14:19:32.149Z 2026-01-26T15:02:10.464Z
9223457 9223457 20260118004925_H6oGm UK0061 2026-01-19T14:19:25.868Z 2026-01-26T15:02:07.640Z
9223280 9223280 20260118000535_DfaOI UK0061 2026-01-19T14:18:30.313Z 2026-01-26T15:02:00.811Z
9223223 9223223 20260117234955_2qPYC UK0061 2026-01-19T14:18:18.884Z 2026-01-26T15:01:58.572Z
9223083 9223083 20260117225831_XIULx UK0061 2026-01-19T14:17:34.893Z 2026-01-26T15:01:41.765Z
9222946 9222946 20260117213839_2cfHG UK0061 2026-01-19T14:16:55.382Z 2026-01-26T15:01:28.983Z
9222569 9222569 20260117195702_3h8xY UK0061 2026-01-19T14:15:18.701Z 2026-01-26T15:01:13.911Z
9217849 9217849 20260116200708_ZSI5A UK0061 2026-01-18T14:09:15.266Z 2026-01-25T14:57:49.551Z
9217639 9217639 20260116184805_3567h UK0061 2026-01-18T14:08:17.337Z 2026-01-25T14:57:28.824Z
9217554 9217554 20260116175117_AwBQm UK0061 2026-01-18T14:07:52.918Z 2026-01-25T14:57:25.916Z
9214418 9214418 20260116063006_FX3WI UK0061 2026-01-17T14:21:28.091Z 2026-01-24T15:13:35.994Z
9214321 9214321 20260116061555_9vCTc UK0061 2026-01-17T14:21:05.506Z 2026-01-24T15:13:29.991Z
9214140 9214140 20260116054546_zqoSX UK0061 2026-01-17T14:20:18.404Z 2026-01-24T15:13:17.532Z
9214131 9214131 20260116054421_dZyXl UK0061 2026-01-17T14:20:12.371Z 2026-01-24T15:13:17.162Z
9213976 9213976 20260116051117_3ZPVT UK0061 2026-01-17T14:19:27.380Z 2026-01-24T15:12:55.459Z
9213772 9213772 20260116043807_8Pc28 UK0061 2026-01-17T14:18:25.435Z 2026-01-24T15:12:45.894Z
9213750 9213750 20260116043412_tGNWq UK0061 2026-01-17T14:18:21.759Z 2026-01-24T15:12:33.432Z
9213708 9213708 20260116042950_ASqtX UK0061 2026-01-17T14:18:13.398Z 2026-01-24T15:12:31.724Z
9213680 9213680 20260116042352_7ysNa UK0061 2026-01-17T14:18:08.111Z 2026-01-24T15:12:30.954Z
9213559 9213559 20260116040136_JOkOA UK0061 2026-01-17T14:17:35.891Z 2026-01-24T15:12:22.298Z
9213507 9213507 20260116034929_fj6HD UK0061 2026-01-17T14:17:15.546Z 2026-01-24T15:12:18.959Z
9213416 9213416 20260116032500_1ifZF UK0061 2026-01-17T14:16:49.619Z 2026-01-24T15:12:12.823Z
9213272 9213272 20260116025917_yPxQl UK0061 2026-01-17T14:16:14.479Z 2026-01-24T15:12:06.781Z
9213169 9213169 20260116022925_MM8FV UK0061 2026-01-17T14:15:44.434Z 2026-01-24T15:11:47.657Z
9213079 9213079 20260116020809_92bmi UK0061 2026-01-17T14:15:18.160Z 2026-01-24T15:11:39.875Z
9213071 9213071 20260116020744_PcaE2 UK0061 2026-01-17T14:15:17.045Z 2026-01-24T15:11:39.443Z
9212848 9212848 20260116012112_fAvH4 UK0061 2026-01-17T14:14:15.478Z 2026-01-24T15:11:29.798Z
9212818 9212818 20260116010948_M2aul UK0061 2026-01-17T14:14:05.708Z 2026-01-24T15:11:28.011Z
9212721 9212721 20260116003214_i07EI UK0061 2026-01-17T14:13:29.459Z 2026-01-24T15:11:20.565Z
9212699 9212699 20260116002917_Y99gS UK0061 2026-01-17T14:13:21.796Z 2026-01-24T15:11:10.564Z
9212570 9212570 20260115231430_rBvzg UK0061 2026-01-17T14:12:44.297Z 2026-01-24T15:11:03.760Z
9212477 9212477 20260115220459_S7Peg UK0061 2026-01-17T14:12:07.772Z 2026-01-24T15:10:56.760Z
9212474 9212474 20260115215950_raINr UK0061 2026-01-17T14:12:07.077Z 2026-01-24T15:10:56.701Z
9212406 9212406 20260115210800_ajvoe UK0061 2026-01-17T14:11:39.603Z 2026-01-24T15:10:51.457Z
9212377 9212377 20260115205744_CmJx2 UK0061 2026-01-17T14:11:29.508Z 2026-01-24T15:10:50.135Z
9211984 9211984 20260115183843_iMHLR UK0061 2026-01-17T14:09:22.412Z 2026-01-24T15:10:17.315Z
9208495 9208495 20260115054210_LdqlQ UK0061 2026-01-16T14:12:54.489Z 2026-01-22T15:04:31.605Z
9201721 9201721 20260114024443_48jH9 UK0061 2026-01-15T14:19:26.924Z 2026-01-22T15:09:08.193Z
9201338 9201338 20260114021037_vSaLL UK0061 2026-01-15T14:18:17.327Z 2026-01-22T15:09:02.043Z
9200790 9200790 20260114010339_dJCFY UK0061 2026-01-15T14:16:24.562Z 2026-01-22T15:08:25.627Z
9200442 9200442 20260114001005_oBrBA UK0061 2026-01-15T14:15:13.008Z 2026-01-22T15:08:16.076Z
9200283 9200283 20260113233406_6E5kT UK0061 2026-01-15T14:14:36.682Z 2026-01-22T15:08:13.177Z
9200119 9200119 20260113225241_Pnips UK0061 2026-01-15T14:13:49.976Z 2026-01-22T15:08:09.807Z
9200055 9200055 20260113224554_iC1CH UK0061 2026-01-15T14:13:40.881Z 2026-01-22T15:08:08.887Z
9199965 9199965 20260113220559_ImfbH UK0061 2026-01-15T14:13:16.146Z 2026-01-22T15:08:06.620Z
9199907 9199907 20260113215336_26oDr UK0061 2026-01-15T14:13:01.400Z 2026-01-22T15:08:05.243Z
9195544 9195544 20260113014414_13T79 UK0061 2026-01-14T14:13:46.486Z 2026-01-21T15:04:42.090Z
9194917 9194917 20260112233018_JlOGy UK0061 2026-01-14T14:11:17.516Z 2026-01-21T15:04:34.008Z
9194831 9194831 20260112225826_Fhq13 UK0061 2026-01-14T14:10:51.075Z 2026-01-21T15:04:23.527Z
9194732 9194732 20260112222533_DTEQT UK0061 2026-01-14T14:10:26.277Z 2026-01-21T15:04:20.391Z
9194102 9194102 20260112175354_t0luZ UK0061 2026-01-14T14:07:17.737Z 2026-01-21T15:03:30.410Z
9189948 9189948 20260112070558_DYMC2 UK0061 2026-01-13T14:20:05.246Z 2026-01-20T15:23:49.057Z
9189909 9189909 20260112065423_NX9U7 UK0061 2026-01-13T14:19:52.891Z 2026-01-20T15:23:47.122Z
9189878 9189878 20260112064122_ABUwz UK0061 2026-01-13T14:19:44.503Z 2026-01-20T15:23:44.070Z
9189803 9189803 20260112062903_GY26m UK0061 2026-01-13T14:19:25.084Z 2026-01-20T15:23:40.847Z
9189764 9189764 20260112061947_01JK2 UK0061 2026-01-13T14:19:15.622Z 2026-01-20T15:23:39.140Z
9189655 9189655 20260112054131_ztblv UK0061 2026-01-13T14:18:45.881Z 2026-01-20T15:23:33.547Z
9189625 9189625 20260112052910_2VMCK UK0061 2026-01-13T14:18:33.895Z 2026-01-20T15:23:32.014Z
9189614 9189614 20260112052203_5ylPZ UK0061 2026-01-13T14:18:30.309Z 2026-01-20T15:23:31.410Z
9189565 9189565 20260112050955_FHqe0 UK0061 2026-01-13T14:18:17.986Z 2026-01-20T15:23:20.565Z
9189504 9189504 20260112044927_jbLMF UK0061 2026-01-13T14:17:54.628Z 2026-01-20T15:23:15.454Z
9189440 9189440 20260112042725_wl49f UK0061 2026-01-13T14:17:35.557Z 2026-01-20T15:23:10.258Z
9189390 9189390 20260112041359_YuVbC UK0061 2026-01-13T14:17:19.968Z 2026-01-20T15:23:07.460Z
9189112 9189112 20260112030525_pXG9M UK0061 2026-01-13T14:15:49.937Z 2026-01-20T15:22:39.982Z
9188827 9188827 20260112015649_KtFmW UK0061 2026-01-13T14:14:25.163Z 2026-01-20T15:22:20.223Z
9188767 9188767 20260112014140_iDj25 UK0061 2026-01-13T14:14:09.326Z 2026-01-20T15:22:13.448Z
9188696 9188696 20260112011717_2ee3U UK0061 2026-01-13T14:13:45.400Z 2026-01-20T15:22:06.631Z
9188665 9188665 20260112011112_iE4M1 UK0061 2026-01-13T14:13:33.908Z 2026-01-20T15:22:04.976Z
9188589 9188589 20260112005036_MMeQM UK0061 2026-01-13T14:13:10.394Z 2026-01-20T15:22:00.864Z
9167868 9167868 20260108055645_NLbhi UK0061 2026-01-09T14:09:35.361Z 2026-01-16T15:11:57.472Z
9162356 9162356 20260107022914_wpQoo UK0061 2026-01-08T14:04:44.647Z 2026-01-13T15:02:03.913Z
9162309 9162309 20260107015528_GhTh6 UK0061 2026-01-08T14:04:29.692Z 2026-01-13T15:02:00.726Z
9162138 9162138 20260106224724_fStxH UK0061 2026-01-08T14:03:09.538Z 2026-01-13T15:01:39.519Z
9162122 9162122 20260106215627_Q7p3U UK0061 2026-01-08T14:03:03.323Z 2026-01-13T15:01:37.887Z
9158151 9158151 20260105203105_DAQAt UK0061 2026-01-07T14:05:03.326Z 2026-01-13T15:06:58.598Z
9158127 9158127 20260105201326_5HSfc UK0061 2026-01-07T14:04:57.263Z 2026-01-13T15:06:56.785Z
9158028 9158028 20260105193936_R7h8K UK0061 2026-01-07T14:04:30.120Z 2026-01-13T15:06:49.830Z
9157751 9157751 20260105184333_L9kkC UK0061 2026-01-07T14:03:25.508Z 2026-01-13T15:06:27.518Z
9157737 9157737 20260105183952_8bUwI UK0061 2026-01-07T14:03:22.150Z 2026-01-13T15:06:26.842Z
9156182 9156182 20260104071252_8lUnP UK0061 2026-01-06T14:38:44.527Z 2026-01-12T15:11:43.061Z
9156178 9156178 20260104071229_2OF9M UK0061 2026-01-06T14:38:44.227Z 2026-01-12T15:11:42.924Z
9156171 9156171 20260104070935_aNMh8 UK0061 2026-01-06T14:38:43.980Z 2026-01-12T15:11:42.772Z
9156168 9156168 20260104070720_qJo2n UK0061 2026-01-06T14:38:43.562Z 2026-01-12T15:11:42.553Z
9156166 9156166 20260104070706_ESHv3 UK0061 2026-01-06T14:38:43.050Z 2026-01-12T15:11:42.233Z
9156125 9156125 20260104065211_k3akz UK0061 2026-01-06T14:38:38.085Z 2026-01-12T15:11:39.491Z
9156014 9156014 20260104063719_nYUeP UK0061 2026-01-06T14:38:25.547Z 2026-01-12T15:11:34.807Z
9155940 9155940 20260104063231_RerRr UK0061 2026-01-06T14:38:16.311Z 2026-01-12T15:11:32.667Z
9155893 9155893 20260104062859_nh1kh UK0061 2026-01-06T14:38:10.017Z 2026-01-12T15:11:31.493Z
9155644 9155644 20260104060903_B2ZAG UK0061 2026-01-06T14:37:51.335Z 2026-01-12T15:11:22.583Z
9155451 9155451 20260104055655_e9L0i UK0061 2026-01-06T14:37:24.072Z 2026-01-12T15:11:03.212Z
9154685 9154685 20260104050922_jXyH3 UK0061 2026-01-06T14:35:53.005Z 2026-01-12T15:10:15.683Z
9154524 9154524 20260104050008_GlElG UK0061 2026-01-06T14:35:39.557Z 2026-01-12T15:10:08.674Z

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