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,939 rows where station_code = "UK00AU" 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
9608486 9608486 20260403231833_vL3KF UK00AU 2026-04-05T12:10:34.443Z 2026-04-06T12:20:16.892Z
9608290 9608290 20260403213008_6luBq UK00AU 2026-04-05T12:09:54.824Z 2026-04-06T12:20:03.723Z
9600302 9600302 20260330195915_2sgk1 UK00AU 2026-04-01T12:10:11.645Z 2026-04-06T12:33:14.514Z
9598484 9598484 20260330003649_aBRKu UK00AU 2026-03-31T12:10:42.445Z 2026-04-06T12:36:34.572Z
9598370 9598370 20260329233732_Dszt0 UK00AU 2026-03-31T12:10:28.902Z 2026-04-06T12:36:27.862Z
9592560 9592560 20260329023006_6jQhS UK00AU 2026-03-30T12:01:18.078Z 2026-04-06T12:34:15.289Z
9589968 9589968 20260328042327_2QLAP UK00AU 2026-03-29T12:01:47.280Z 2026-04-06T12:37:39.324Z
9589703 9589703 20260328040002_IHF59 UK00AU 2026-03-29T12:01:34.118Z 2026-04-06T12:37:31.668Z
9589471 9589471 20260328033315_8nu3y UK00AU 2026-03-29T12:01:18.883Z 2026-04-06T12:37:25.170Z
9589239 9589239 20260328025759_5Y0Vl UK00AU 2026-03-29T12:00:57.915Z 2026-04-06T12:37:09.326Z
9589230 9589230 20260328025551_pPBHy UK00AU 2026-03-29T12:00:56.317Z 2026-04-06T12:37:08.693Z
9585339 9585339 20260326001930_QUSM1 UK00AU 2026-03-27T12:17:09.030Z 2026-04-03T12:39:57.187Z
9585014 9585014 20260325230611_cO53t UK00AU 2026-03-27T12:16:32.147Z 2026-04-03T12:39:46.576Z
9584653 9584653 20260325212810_SuSmQ UK00AU 2026-03-27T12:15:54.637Z 2026-04-03T12:39:25.512Z
9581936 9581936 20260326041231_UAES2 UK00AU 2026-03-27T12:04:12.887Z 2026-04-04T12:39:31.855Z
9581715 9581715 20260326034812_3Koyf UK00AU 2026-03-27T12:03:44.413Z 2026-04-04T12:39:16.599Z
9581208 9581208 20260326023731_HirHU UK00AU 2026-03-27T12:02:24.618Z 2026-04-04T12:38:46.257Z
9581088 9581088 20260326022108_Mip6C UK00AU 2026-03-27T12:02:05.833Z 2026-04-04T12:38:42.231Z
9581046 9581046 20260326021450_zKwN1 UK00AU 2026-03-27T12:01:57.926Z 2026-04-04T12:38:40.448Z
9581034 9581034 20260326021450_6yOQx UK00AU 2026-03-27T12:01:57.578Z 2026-04-04T12:38:40.327Z
9580597 9580597 20260326010538_gz7bu UK00AU 2026-03-27T12:00:53.206Z 2026-04-04T12:38:15.688Z
9580432 9580432 20260326004826_LJXB5 UK00AU 2026-03-27T12:00:28.548Z 2026-04-04T12:38:10.158Z
9576479 9576479 20260325021611_utrzE UK00AU 2026-03-26T12:02:24.275Z 2026-04-03T12:36:00.952Z
9576462 9576462 20260325021104_G3oX9 UK00AU 2026-03-26T12:02:20.335Z 2026-04-03T12:36:00.065Z
9571119 9571119 20260322234801_ksRwO UK00AU 2026-03-24T12:24:21.454Z 2026-03-30T12:30:55.418Z
9570991 9570991 20260322233135_JN2P2 UK00AU 2026-03-24T12:24:07.906Z 2026-03-30T12:30:53.410Z
9570787 9570787 20260322224751_RMCAc UK00AU 2026-03-24T12:23:49.236Z 2026-03-30T12:30:49.394Z
9562208 9562208 20260323014935_SH1qv UK00AU 2026-03-24T12:02:27.920Z 2026-03-31T12:26:03.849Z
9562021 9562021 20260323011615_ISxor UK00AU 2026-03-24T12:01:55.685Z 2026-03-31T12:25:59.577Z
9561967 9561967 20260323010218_W2825 UK00AU 2026-03-24T12:01:43.036Z 2026-03-31T12:25:57.597Z
9561250 9561250 20260321231207_Fomo6 UK00AU 2026-03-23T12:12:14.799Z 2026-03-29T12:21:05.913Z
9561242 9561242 20260321231207_9SltZ UK00AU 2026-03-23T12:12:14.742Z 2026-03-29T12:21:05.902Z
9561226 9561226 20260321231046_Y3g7h UK00AU 2026-03-23T12:12:14.457Z 2026-03-29T12:21:05.856Z
9561192 9561192 20260321230640_o7qIM UK00AU 2026-03-23T12:12:13.274Z 2026-03-29T12:21:05.566Z
9561128 9561128 20260321230307_yNYQL UK00AU 2026-03-23T12:12:11.993Z 2026-03-29T12:21:05.261Z
9561066 9561066 20260321225158_dsu3T UK00AU 2026-03-23T12:12:10.919Z 2026-03-29T12:21:04.963Z
9560974 9560974 20260321223925_H0Ls7 UK00AU 2026-03-23T12:12:08.625Z 2026-03-29T12:21:04.311Z
9560967 9560967 20260321223923_U30yk UK00AU 2026-03-23T12:12:08.525Z 2026-03-29T12:21:04.250Z
9560823 9560823 20260321222056_jRgpS UK00AU 2026-03-23T12:12:04.799Z 2026-03-29T12:21:03.189Z
9560660 9560660 20260321215737_TryhV UK00AU 2026-03-23T12:12:00.535Z 2026-03-29T12:21:02.032Z
9560524 9560524 20260321213641_D3B9O UK00AU 2026-03-23T12:11:50.529Z 2026-03-29T12:21:01.010Z
9560267 9560267 20260321205504_o8ZeS UK00AU 2026-03-23T12:11:40.790Z 2026-03-29T12:20:58.859Z
9559735 9559735 20260321193633_NvLHx UK00AU 2026-03-23T12:11:28.386Z 2026-03-29T12:20:48.433Z
9555467 9555467 20260322050025_19KMy UK00AU 2026-03-23T12:03:26.751Z 2026-03-30T12:28:26.830Z
9555449 9555449 20260322045624_1jO2C UK00AU 2026-03-23T12:03:26.165Z 2026-03-30T12:28:26.623Z
9555426 9555426 20260322045615_3bfFA UK00AU 2026-03-23T12:03:25.539Z 2026-03-30T12:28:26.470Z
9555368 9555368 20260322044625_Rn3me UK00AU 2026-03-23T12:03:22.780Z 2026-03-30T12:28:25.613Z
9555206 9555206 20260322041929_EZvp2 UK00AU 2026-03-23T12:03:15.104Z 2026-03-30T12:28:22.918Z
9554879 9554879 20260322034012_284C6 UK00AU 2026-03-23T12:02:54.226Z 2026-03-30T12:28:10.695Z
9554800 9554800 20260322033609_nit2u UK00AU 2026-03-23T12:02:51.412Z 2026-03-30T12:28:09.053Z
9554795 9554795 20260322033455_L3FIy UK00AU 2026-03-23T12:02:51.131Z 2026-03-30T12:28:08.968Z
9554740 9554740 20260322033244_D0C2d UK00AU 2026-03-23T12:02:48.605Z 2026-03-30T12:28:08.143Z
9554520 9554520 20260322031521_M5Oec UK00AU 2026-03-23T12:02:38.663Z 2026-03-30T12:28:05.033Z
9554281 9554281 20260322025436_fI5js UK00AU 2026-03-23T12:02:24.123Z 2026-03-30T12:28:01.563Z
9554197 9554197 20260322024831_Dpf34 UK00AU 2026-03-23T12:02:19.803Z 2026-03-30T12:28:00.272Z
9553763 9553763 20260322021227_CDB9I UK00AU 2026-03-23T12:01:50.417Z 2026-03-30T12:27:52.158Z
9553664 9553664 20260322020524_egWsG UK00AU 2026-03-23T12:01:45.246Z 2026-03-30T12:27:50.811Z
9553601 9553601 20260322015630_2bWMP UK00AU 2026-03-23T12:01:41.893Z 2026-03-30T12:27:49.879Z
9553511 9553511 20260322014650_bkTkH UK00AU 2026-03-23T12:01:35.036Z 2026-03-30T12:27:42.382Z
9553227 9553227 20260322012641_RmJwb UK00AU 2026-03-23T12:01:19.905Z 2026-03-30T12:27:38.175Z
9552981 9552981 20260322010055_k1Kr8 UK00AU 2026-03-23T12:01:06.650Z 2026-03-30T12:27:33.291Z
9552897 9552897 20260322005112_2Glao UK00AU 2026-03-23T12:00:58.653Z 2026-03-30T12:27:31.842Z
9552861 9552861 20260322004906_Akglb UK00AU 2026-03-23T12:00:57.112Z 2026-03-30T12:27:31.489Z
9552857 9552857 20260322004845_PaY35 UK00AU 2026-03-23T12:00:56.806Z 2026-03-30T12:27:31.408Z
9552627 9552627 20260322002504_5ctFx UK00AU 2026-03-23T12:00:38.132Z 2026-03-30T12:27:27.191Z
9552384 9552384 20260321235806_OqLBC UK00AU 2026-03-23T12:00:19.176Z 2026-03-30T12:27:23.106Z
9552259 9552259 20260319230301_uKUFa UK00AU 2026-03-22T12:31:51.975Z 2026-03-27T12:42:50.259Z
9552257 9552257 20260319212557_hM0Pw UK00AU 2026-03-22T12:31:43.989Z 2026-03-27T12:42:40.794Z
9551736 9551736 20260320211622_kaYgJ UK00AU 2026-03-22T12:26:59.609Z 2026-03-28T12:37:01.252Z
9542189 9542189 20260319225820_aoLxp UK00AU 2026-03-21T12:29:50.808Z 2026-03-27T12:42:49.218Z
9541773 9541773 20260319213951_zt4oC UK00AU 2026-03-21T12:29:20.752Z 2026-03-27T12:42:41.452Z
9541697 9541697 20260319212747_ohBii UK00AU 2026-03-21T12:29:16.874Z 2026-03-27T12:42:40.881Z
9541378 9541378 20260319202626_Z4Tgz UK00AU 2026-03-21T12:28:52.883Z 2026-03-27T12:42:37.023Z
9541222 9541222 20260319200614_ewm4M UK00AU 2026-03-21T12:28:45.212Z 2026-03-27T12:42:35.686Z
9541169 9541169 20260319194839_sZtQp UK00AU 2026-03-21T12:28:41.060Z 2026-03-27T12:42:34.842Z
9534729 9534729 20260320041639_8r0XG UK00AU 2026-03-21T12:08:44.308Z 2026-03-28T12:34:21.405Z
9534545 9534545 20260320035746_IRIPk UK00AU 2026-03-21T12:08:13.478Z 2026-03-28T12:34:19.150Z
9534022 9534022 20260320031730_WqnKb UK00AU 2026-03-21T12:06:55.371Z 2026-03-28T12:34:03.769Z
9533742 9533742 20260320025357_3ecKh UK00AU 2026-03-21T12:06:08.881Z 2026-03-28T12:33:59.956Z
9533147 9533147 20260320020416_NB2Pq UK00AU 2026-03-21T12:04:35.317Z 2026-03-28T12:33:49.218Z
9532657 9532657 20260320011637_h4fSE UK00AU 2026-03-21T12:03:20.908Z 2026-03-28T12:33:35.018Z
9532462 9532462 20260320005919_MWiSF UK00AU 2026-03-21T12:02:47.470Z 2026-03-28T12:33:31.725Z
9532141 9532141 20260320002127_KWe9U UK00AU 2026-03-21T12:01:47.963Z 2026-03-28T12:33:24.832Z
9532033 9532033 20260320001125_mTzz8 UK00AU 2026-03-21T12:01:32.182Z 2026-03-28T12:33:24.106Z
9532009 9532009 20260320000744_4JnL3 UK00AU 2026-03-21T12:01:24.616Z 2026-03-28T12:33:23.709Z
9531770 9531770 20260319234703_QYVjA UK00AU 2026-03-21T12:00:51.079Z 2026-03-28T12:33:21.456Z
9531570 9531570 20260319232509_ApZ86 UK00AU 2026-03-21T12:00:14.287Z 2026-03-28T12:33:18.486Z
9531267 9531267 20260318225018_OCytJ UK00AU 2026-03-20T12:25:03.606Z 2026-03-26T12:39:18.442Z
9531243 9531243 20260318224833_30WIw UK00AU 2026-03-20T12:25:02.833Z 2026-03-26T12:39:18.279Z
9530912 9530912 20260318220025_62mIr UK00AU 2026-03-20T12:24:51.289Z 2026-03-26T12:39:16.511Z
9530889 9530889 20260318215713_CJC7q UK00AU 2026-03-20T12:24:50.829Z 2026-03-26T12:39:16.418Z
9530808 9530808 20260318214448_cP823 UK00AU 2026-03-20T12:24:47.766Z 2026-03-26T12:39:15.705Z
9530383 9530383 20260318204608_Fhc3c UK00AU 2026-03-20T12:24:20.435Z 2026-03-26T12:39:11.747Z
9529769 9529769 20260318192801_fQY23 UK00AU 2026-03-20T12:23:38.134Z 2026-03-26T12:39:06.319Z
9522002 9522002 20260319050832_4sTjD UK00AU 2026-03-20T12:08:50.044Z 2026-03-27T12:41:12.564Z
9521926 9521926 20260319045657_Z2PMP UK00AU 2026-03-20T12:08:44.893Z 2026-03-27T12:41:11.850Z
9521890 9521890 20260319045139_ZSsrr UK00AU 2026-03-20T12:08:42.884Z 2026-03-27T12:41:11.636Z
9520151 9520151 20260319025628_U4srn UK00AU 2026-03-20T12:05:50.121Z 2026-03-27T12:40:39.633Z
9519960 9519960 20260319024528_6Ogo6 UK00AU 2026-03-20T12:05:25.360Z 2026-03-27T12:40:37.258Z
9519926 9519926 20260319024326_ScdVs UK00AU 2026-03-20T12:05:23.119Z 2026-03-27T12:40:37.041Z

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