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

>10,000 rows count all where station_code = "UK004D" 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
9611769 9611769 20260405032146_d3dNe UK004D 2026-04-06T12:15:57.382Z 2026-04-06T12:16:14.860Z
9611445 9611445 20260405020318_7Er4J UK004D 2026-04-06T12:14:36.813Z 2026-04-06T12:16:14.801Z
9610742 9610742 20260404212733_ivBfy UK004D 2026-04-06T12:11:01.488Z 2026-04-06T12:16:14.649Z
9609088 9609088 20260405033346_N322O UK004D 2026-04-06T12:00:13.425Z 2026-04-06T12:00:13.425Z
9609008 9609008 20260404030436_10Y3Y UK004D 2026-04-05T12:12:35.998Z 2026-04-06T12:20:56.756Z
9608805 9608805 20260404013847_ANi0V UK004D 2026-04-05T12:11:49.193Z 2026-04-06T12:20:38.316Z
9608275 9608275 20260403212957_uN7IU UK004D 2026-04-05T12:09:53.163Z 2026-04-06T12:20:03.209Z
9608209 9608209 20260403205900_drmmx UK004D 2026-04-05T12:09:34.062Z 2026-04-06T12:19:56.163Z
9607052 9607052 20260404031925_Zrm39 UK004D 2026-04-05T12:00:15.459Z 2026-04-06T12:16:14.351Z
9600543 9600543 20260330231833_egrK8 UK004D 2026-04-01T12:11:08.239Z 2026-04-06T12:33:33.584Z
9600528 9600528 20260330231318_4UmsC UK004D 2026-04-01T12:11:05.565Z 2026-04-06T12:33:32.583Z
9600436 9600436 20260330215852_YggfO UK004D 2026-04-01T12:10:46.980Z 2026-04-06T12:33:25.840Z
9598567 9598567 20260330012026_TdOOw UK004D 2026-03-31T12:10:57.008Z 2026-04-06T12:36:46.576Z
9598352 9598352 20260329231338_DCRF7 UK004D 2026-03-31T12:10:25.940Z 2026-04-06T12:36:26.702Z
9598269 9598269 20260329215631_OoYJx UK004D 2026-03-31T12:10:09.631Z 2026-04-06T12:36:21.560Z
9598224 9598224 20260329204746_Whhy2 UK004D 2026-03-31T12:10:01.430Z 2026-04-06T12:36:18.330Z
9594347 9594347 20260328214059_NTcNB UK004D 2026-03-30T12:09:21.782Z 2026-04-06T12:39:48.920Z
9594319 9594319 20260328212525_ajrol UK004D 2026-03-30T12:09:18.088Z 2026-04-06T12:39:47.924Z
9594169 9594169 20260328194224_ImLr8 UK004D 2026-03-30T12:08:53.491Z 2026-04-06T12:39:40.956Z
9593004 9593004 20260329041500_sJCgG UK004D 2026-03-30T12:02:35.354Z 2026-04-06T12:34:44.904Z
9592881 9592881 20260329034517_WiV3c UK004D 2026-03-30T12:02:13.187Z 2026-04-06T12:34:38.934Z
9592810 9592810 20260329032821_GkCT2 UK004D 2026-03-30T12:01:58.575Z 2026-04-06T12:34:29.074Z
9592504 9592504 20260329021944_iLH7U UK004D 2026-03-30T12:01:09.384Z 2026-04-06T12:34:13.241Z
9592183 9592183 20260329011915_uuiwS UK004D 2026-03-30T12:00:17.905Z 2026-04-06T12:33:52.682Z
9590028 9590028 20260328042936_7m7Tv UK004D 2026-03-29T12:01:53.411Z 2026-04-06T12:37:47.605Z
9590013 9590013 20260328042810_HZopq UK004D 2026-03-29T12:01:51.903Z 2026-04-06T12:37:46.995Z
9589933 9589933 20260328042212_JwjiF UK004D 2026-03-29T12:01:46.002Z 2026-04-06T12:37:38.717Z
9589808 9589808 20260328040906_KIy3m UK004D 2026-03-29T12:01:39.059Z 2026-04-06T12:37:35.507Z
9589711 9589711 20260328040123_0ko93 UK004D 2026-03-29T12:01:34.959Z 2026-04-06T12:37:32.072Z
9589184 9589184 20260328024238_j225W UK004D 2026-03-29T12:00:49.838Z 2026-04-06T12:37:04.627Z
9589165 9589165 20260328023758_ya5yk UK004D 2026-03-29T12:00:48.474Z 2026-04-06T12:37:04.037Z
9588902 9588902 20260328015404_mhwyo UK004D 2026-03-29T12:00:28.441Z 2026-04-06T12:36:56.099Z
9585175 9585175 20260325233757_EDHcm UK004D 2026-03-27T12:16:53.147Z 2026-04-03T12:39:51.027Z
9585081 9585081 20260325232342_3gVlt UK004D 2026-03-27T12:16:42.538Z 2026-04-03T12:39:49.098Z
9582115 9582115 20260326044012_vIzfz UK004D 2026-03-27T12:04:40.848Z 2026-04-04T12:39:38.175Z
9582081 9582081 20260326043431_uLSNe UK004D 2026-03-27T12:04:35.151Z 2026-04-04T12:39:37.207Z
9581893 9581893 20260326040822_rsdxQ UK004D 2026-03-27T12:04:05.191Z 2026-04-04T12:39:29.907Z
9581781 9581781 20260326035617_PIqPo UK004D 2026-03-27T12:03:50.691Z 2026-04-04T12:39:20.438Z
9581741 9581741 20260326035448_ETQQI UK004D 2026-03-27T12:03:47.778Z 2026-04-04T12:39:18.009Z
9581561 9581561 20260326033113_OwaM9 UK004D 2026-03-27T12:03:25.278Z 2026-04-04T12:39:10.831Z
9581176 9581176 20260326023233_WB5bk UK004D 2026-03-27T12:02:17.972Z 2026-04-04T12:38:44.736Z
9581124 9581124 20260326022731_oZw9m UK004D 2026-03-27T12:02:11.551Z 2026-04-04T12:38:43.403Z
9580796 9580796 20260326013431_XdW6Y UK004D 2026-03-27T12:01:26.866Z 2026-04-04T12:38:29.830Z
9580394 9580394 20260326004322_hQwqd UK004D 2026-03-27T12:00:21.338Z 2026-04-04T12:38:08.338Z
9580327 9580327 20260326003059_3ZxO2 UK004D 2026-03-27T12:00:11.748Z 2026-04-04T12:38:06.084Z
9576718 9576718 20260325030014_x5qDG UK004D 2026-03-26T12:03:07.026Z 2026-04-03T12:36:18.935Z
9576628 9576628 20260325024501_oPGOH UK004D 2026-03-26T12:02:50.830Z 2026-04-03T12:36:15.271Z
9576299 9576299 20260325015022_2URz4 UK004D 2026-03-26T12:01:52.743Z 2026-04-03T12:35:52.417Z
9576073 9576073 20260325010947_EnWq5 UK004D 2026-03-26T12:01:12.659Z 2026-04-03T12:35:43.426Z
9575931 9575931 20260325004259_YWyFX UK004D 2026-03-26T12:00:42.592Z 2026-04-03T12:35:29.771Z
9560496 9560496 20260321213230_n7SJd UK004D 2026-03-23T12:11:49.218Z 2026-03-29T12:21:00.789Z
9560402 9560402 20260321211309_C68na UK004D 2026-03-23T12:11:45.339Z 2026-03-29T12:20:59.911Z
9559916 9559916 20260321200942_9U3mw UK004D 2026-03-23T12:11:33.696Z 2026-03-29T12:20:56.587Z
9554701 9554701 20260322032713_FkJKJ UK004D 2026-03-23T12:02:46.898Z 2026-03-30T12:28:07.443Z
9553610 9553610 20260322020005_vTrzk UK004D 2026-03-23T12:01:42.636Z 2026-03-30T12:27:50.048Z
9552878 9552878 20260322005048_Y2DTm UK004D 2026-03-23T12:00:58.328Z 2026-03-30T12:27:31.745Z
9551377 9551377 20260320193828_rzJJZ UK004D 2026-03-22T12:26:36.929Z 2026-03-28T12:36:48.907Z
9542646 9542646 20260321003131_22ARl UK004D 2026-03-22T12:01:04.393Z 2026-03-29T12:18:56.218Z
9542587 9542587 20260321001656_Rw5kr UK004D 2026-03-22T12:00:52.034Z 2026-03-29T12:18:46.119Z
9542555 9542555 20260321001342_Xw1SL UK004D 2026-03-22T12:00:46.024Z 2026-03-29T12:18:45.604Z
9542394 9542394 20260319232118_ywD88 UK004D 2026-03-21T12:30:01.615Z 2026-03-27T12:43:01.963Z
9541909 9541909 20260319220512_r7Nm8 UK004D 2026-03-21T12:29:29.290Z 2026-03-27T12:42:42.947Z
9534669 9534669 20260320041032_2R98l UK004D 2026-03-21T12:08:35.075Z 2026-03-28T12:34:20.657Z
9534648 9534648 20260320041017_7uMuA UK004D 2026-03-21T12:08:33.350Z 2026-03-28T12:34:20.519Z
9534480 9534480 20260320035142_623U7 UK004D 2026-03-21T12:08:05.348Z 2026-03-28T12:34:18.654Z
9534421 9534421 20260320034851_7dMul UK004D 2026-03-21T12:07:58.539Z 2026-03-28T12:34:18.162Z
9534103 9534103 20260320032517_AlR3G UK004D 2026-03-21T12:07:09.226Z 2026-03-28T12:34:13.813Z
9533919 9533919 20260320030919_J2NfQ UK004D 2026-03-21T12:06:39.280Z 2026-03-28T12:34:02.261Z
9533912 9533912 20260320030910_ihCzc UK004D 2026-03-21T12:06:36.771Z 2026-03-28T12:34:02.207Z
9533875 9533875 20260320030700_YpHUA UK004D 2026-03-21T12:06:32.827Z 2026-03-28T12:34:01.801Z
9533772 9533772 20260320025730_xfiQE UK004D 2026-03-21T12:06:14.771Z 2026-03-28T12:34:00.376Z
9533697 9533697 20260320025209_wi9m0 UK004D 2026-03-21T12:06:02.909Z 2026-03-28T12:33:58.753Z
9533366 9533366 20260320022606_PR29b UK004D 2026-03-21T12:05:16.562Z 2026-03-28T12:33:52.472Z
9533111 9533111 20260320020017_UtdCR UK004D 2026-03-21T12:04:29.439Z 2026-03-28T12:33:48.965Z
9533012 9533012 20260320014624_sVL2P UK004D 2026-03-21T12:04:13.243Z 2026-03-28T12:33:47.560Z
9532980 9532980 20260320014329_R6Ac3 UK004D 2026-03-21T12:04:08.344Z 2026-03-28T12:33:47.165Z
9532834 9532834 20260320013210_nUGNT UK004D 2026-03-21T12:03:46.573Z 2026-03-28T12:33:44.765Z
9532802 9532802 20260320012706_avs63 UK004D 2026-03-21T12:03:40.571Z 2026-03-28T12:33:44.121Z
9532553 9532553 20260320010632_S83TM UK004D 2026-03-21T12:03:03.439Z 2026-03-28T12:33:33.875Z
9532097 9532097 20260320001816_RQnGj UK004D 2026-03-21T12:01:43.103Z 2026-03-28T12:33:24.606Z
9532056 9532056 20260320001302_RB0l4 UK004D 2026-03-21T12:01:34.746Z 2026-03-28T12:33:24.234Z
9531806 9531806 20260319235135_C20dN UK004D 2026-03-21T12:00:53.791Z 2026-03-28T12:33:21.740Z
9531708 9531708 20260319233708_K5Dzq UK004D 2026-03-21T12:00:35.229Z 2026-03-28T12:33:20.563Z
9531317 9531317 20260318225644_eF63x UK004D 2026-03-20T12:25:06.333Z 2026-03-26T12:39:18.746Z
9530991 9530991 20260318221136_96qa0 UK004D 2026-03-20T12:24:53.746Z 2026-03-26T12:39:16.826Z
9530099 9530099 20260318200727_vZFQj UK004D 2026-03-20T12:24:00.432Z 2026-03-26T12:39:09.277Z
9530014 9530014 20260318195442_vkqsS UK004D 2026-03-20T12:23:54.468Z 2026-03-26T12:39:08.263Z
9521335 9521335 20260319040705_NLcXg UK004D 2026-03-20T12:07:51.498Z 2026-03-27T12:40:53.893Z
9521173 9521173 20260319035545_5IQyU UK004D 2026-03-20T12:07:39.036Z 2026-03-27T12:40:52.299Z
9520678 9520678 20260319033109_u5Lie UK004D 2026-03-20T12:06:47.405Z 2026-03-27T12:40:46.233Z
9520264 9520264 20260319030722_cxADO UK004D 2026-03-20T12:06:06.029Z 2026-03-27T12:40:41.232Z
9520033 9520033 20260319024808_WLpkw UK004D 2026-03-20T12:05:34.119Z 2026-03-27T12:40:38.091Z
9519864 9519864 20260319024139_aXVdu UK004D 2026-03-20T12:05:20.175Z 2026-03-27T12:40:36.698Z
9518857 9518857 20260319012948_KM2vU UK004D 2026-03-20T12:03:30.559Z 2026-03-27T12:40:15.799Z
9518637 9518637 20260319011414_tFkmv UK004D 2026-03-20T12:03:01.881Z 2026-03-27T12:40:12.153Z
9517813 9517813 20260319000539_q83X8 UK004D 2026-03-20T12:01:21.363Z 2026-03-27T12:40:03.691Z
9517702 9517702 20260318235627_RxWaH UK004D 2026-03-20T12:01:03.631Z 2026-03-27T12:40:02.485Z
9517241 9517241 20260317225851_nDE2k UK004D 2026-03-19T12:27:21.856Z 2026-03-25T12:43:09.528Z
9517165 9517165 20260317224915_Hh0ix UK004D 2026-03-19T12:27:16.276Z 2026-03-25T12:43:09.075Z
9517002 9517002 20260317222503_bqdfI UK004D 2026-03-19T12:27:04.867Z 2026-03-25T12:43:08.044Z

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