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 = "UK0024" 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
9616707 9616707 20260406035420_uuFpk UK0024 2026-04-07T12:13:17.190Z 2026-04-07T12:13:20.040Z
9616168 9616168 20260406023329_aDMkY UK0024 2026-04-07T12:12:18.770Z 2026-04-07T12:13:19.929Z
9616084 9616084 20260406022028_VVoUk UK0024 2026-04-07T12:12:07.350Z 2026-04-07T12:13:19.911Z
9616020 9616020 20260406021537_dduc3 UK0024 2026-04-07T12:12:02.125Z 2026-04-07T12:13:19.900Z
9615839 9615839 20260406015916_037Nu UK0024 2026-04-07T12:11:38.069Z 2026-04-07T12:13:19.872Z
9615689 9615689 20260406014309_P8KDZ UK0024 2026-04-07T12:11:24.513Z 2026-04-07T12:13:19.846Z
9615568 9615568 20260406013249_8TzZb UK0024 2026-04-07T12:11:01.712Z 2026-04-07T12:13:19.824Z
9615396 9615396 20260406011125_CEEDp UK0024 2026-04-07T12:10:43.145Z 2026-04-07T12:13:19.793Z
9615372 9615372 20260406010654_eMqVL UK0024 2026-04-07T12:10:41.272Z 2026-04-07T12:13:19.789Z
9615315 9615315 20260406005922_oAJ7s UK0024 2026-04-07T12:10:36.009Z 2026-04-07T12:13:19.779Z
9614886 9614886 20260406000413_OmSi3 UK0024 2026-04-07T12:09:33.116Z 2026-04-07T12:13:19.691Z
9614872 9614872 20260406000412_2ZnfI UK0024 2026-04-07T12:09:32.840Z 2026-04-07T12:13:19.691Z
9614687 9614687 20260405234056_3Ejdd UK0024 2026-04-07T12:09:16.936Z 2026-04-07T12:13:19.656Z
9614313 9614313 20260405225137_KbVhO UK0024 2026-04-07T12:08:23.954Z 2026-04-07T12:13:19.573Z
9614241 9614241 20260405224011_UBk1J UK0024 2026-04-07T12:08:17.611Z 2026-04-07T12:13:19.553Z
9614193 9614193 20260405223003_nJQCi UK0024 2026-04-07T12:08:11.342Z 2026-04-07T12:13:19.540Z
9613746 9613746 20260405211737_4wYff UK0024 2026-04-07T12:07:15.201Z 2026-04-07T12:13:19.447Z
9613441 9613441 20260405201810_iE4A2 UK0024 2026-04-07T12:06:43.288Z 2026-04-07T12:13:19.385Z
9612001 9612001 20260406043758_00S3h UK0024 2026-04-07T12:00:25.437Z 2026-04-07T12:00:25.437Z
9611989 9611989 20260406043422_sU2bs UK0024 2026-04-07T12:00:22.918Z 2026-04-07T12:00:22.918Z
9611964 9611964 20260406042115_2sX5R UK0024 2026-04-07T12:00:19.290Z 2026-04-07T12:00:19.290Z
9611916 9611916 20260406035558_U4L8k UK0024 2026-04-07T12:00:10.651Z 2026-04-07T12:00:10.651Z
9608645 9608645 20260404001632_LtfqJ UK0024 2026-04-05T12:11:07.602Z 2026-04-07T12:18:17.156Z
9608293 9608293 20260403213009_gWo3a UK0024 2026-04-05T12:09:55.332Z 2026-04-07T12:18:06.918Z
9600569 9600569 20260330233813_s7Zqo UK0024 2026-04-01T12:11:13.120Z 2026-04-07T12:26:08.231Z
9592747 9592747 20260329031246_S4EsB UK0024 2026-03-30T12:01:50.013Z 2026-04-07T12:26:40.107Z
9590042 9590042 20260328043412_eTzn7 UK0024 2026-03-29T12:01:54.458Z 2026-04-06T12:37:47.972Z
9589706 9589706 20260328040002_2LibW UK0024 2026-03-29T12:01:34.347Z 2026-04-06T12:37:31.818Z
9588952 9588952 20260328015657_3NRL2 UK0024 2026-03-29T12:00:32.441Z 2026-04-06T12:36:57.243Z
9585012 9585012 20260325230611_cO53t UK0024 2026-03-27T12:16:32.147Z 2026-04-03T12:39:46.576Z
9584525 9584525 20260325202956_SjQdj UK0024 2026-03-27T12:15:35.314Z 2026-04-03T12:39:18.843Z
9580593 9580593 20260326010538_gz7bu UK0024 2026-03-27T12:00:53.206Z 2026-04-04T12:38:15.688Z
9580564 9580564 20260326010243_olqGo UK0024 2026-03-27T12:00:49.195Z 2026-04-04T12:38:14.349Z
9580147 9580147 20260325001258_ixOx7 UK0024 2026-03-26T12:15:10.598Z 2026-04-02T12:37:43.949Z
9571114 9571114 20260322234801_ksRwO UK0024 2026-03-24T12:24:21.454Z 2026-03-30T12:30:55.418Z
9562019 9562019 20260323011615_ISxor UK0024 2026-03-24T12:01:55.651Z 2026-03-31T12:25:59.576Z
9561965 9561965 20260323010218_W2825 UK0024 2026-03-24T12:01:43.019Z 2026-03-31T12:25:57.596Z
9561060 9561060 20260321225158_dsu3T UK0024 2026-03-23T12:12:10.918Z 2026-03-29T12:21:04.963Z
9560978 9560978 20260321223926_jJ8UA UK0024 2026-03-23T12:12:08.654Z 2026-03-29T12:21:04.316Z
9560971 9560971 20260321223925_H0Ls7 UK0024 2026-03-23T12:12:08.625Z 2026-03-29T12:21:04.311Z
9559731 9559731 20260321193633_NvLHx UK0024 2026-03-23T12:11:28.386Z 2026-03-29T12:20:48.433Z
9555464 9555464 20260322050025_19KMy UK0024 2026-03-23T12:03:26.751Z 2026-03-30T12:28:26.830Z
9555440 9555440 20260322045624_1jO2C UK0024 2026-03-23T12:03:26.165Z 2026-03-30T12:28:26.623Z
9554874 9554874 20260322034012_284C6 UK0024 2026-03-23T12:02:54.226Z 2026-03-30T12:28:10.695Z
9554788 9554788 20260322033455_L3FIy UK0024 2026-03-23T12:02:51.131Z 2026-03-30T12:28:08.968Z
9554738 9554738 20260322033244_D0C2d UK0024 2026-03-23T12:02:48.605Z 2026-03-30T12:28:08.143Z
9554273 9554273 20260322025436_fI5js UK0024 2026-03-23T12:02:24.123Z 2026-03-30T12:28:01.562Z
9553755 9553755 20260322021227_CDB9I UK0024 2026-03-23T12:01:50.417Z 2026-03-30T12:27:52.157Z
9553656 9553656 20260322020524_egWsG UK0024 2026-03-23T12:01:45.246Z 2026-03-30T12:27:50.811Z
9553506 9553506 20260322014650_bkTkH UK0024 2026-03-23T12:01:35.036Z 2026-03-30T12:27:42.382Z
9553277 9553277 20260322012928_jP3GY UK0024 2026-03-23T12:01:22.664Z 2026-03-30T12:27:38.921Z
9552975 9552975 20260322010055_k1Kr8 UK0024 2026-03-23T12:01:06.650Z 2026-03-30T12:27:33.290Z
9552888 9552888 20260322005112_2Glao UK0024 2026-03-23T12:00:58.615Z 2026-03-30T12:27:31.842Z
9551962 9551962 20260320222414_IGddj UK0024 2026-03-22T12:27:19.991Z 2026-03-28T12:37:05.043Z
9542224 9542224 20260319230301_aeU8L UK0024 2026-03-21T12:29:52.455Z 2026-03-27T12:42:50.312Z
9542193 9542193 20260319225820_BCM6B UK0024 2026-03-21T12:29:50.889Z 2026-03-27T12:42:49.443Z
9541687 9541687 20260319212747_qIhYI UK0024 2026-03-21T12:29:16.798Z 2026-03-27T12:42:40.880Z
9541167 9541167 20260319194839_ibq8a UK0024 2026-03-21T12:28:40.777Z 2026-03-27T12:42:34.795Z
9534734 9534734 20260320041640_7Lzfr UK0024 2026-03-21T12:08:44.602Z 2026-03-28T12:34:21.466Z
9534550 9534550 20260320035746_NwaKN UK0024 2026-03-21T12:08:14.036Z 2026-03-28T12:34:19.187Z
9534401 9534401 20260320034810_hTyEj UK0024 2026-03-21T12:07:54.646Z 2026-03-28T12:34:17.985Z
9534263 9534263 20260320033853_7va3B UK0024 2026-03-21T12:07:35.514Z 2026-03-28T12:34:16.788Z
9534013 9534013 20260320031730_2mXct UK0024 2026-03-21T12:06:54.881Z 2026-03-28T12:34:03.672Z
9533727 9533727 20260320025356_fWoUf UK0024 2026-03-21T12:06:08.420Z 2026-03-28T12:33:59.931Z
9533186 9533186 20260320021023_ahkWJ UK0024 2026-03-21T12:04:43.966Z 2026-03-28T12:33:49.980Z
9532646 9532646 20260320011637_2Gpip UK0024 2026-03-21T12:03:20.335Z 2026-03-28T12:33:34.983Z
9532336 9532336 20260320004808_vw0oX UK0024 2026-03-21T12:02:26.159Z 2026-03-28T12:33:28.018Z
9532129 9532129 20260320002127_6l1Kc UK0024 2026-03-21T12:01:47.315Z 2026-03-28T12:33:24.806Z
9531768 9531768 20260319234703_QYVjA UK0024 2026-03-21T12:00:51.078Z 2026-03-28T12:33:21.456Z
9531556 9531556 20260319232509_sJjT7 UK0024 2026-03-21T12:00:13.662Z 2026-03-28T12:33:18.381Z
9531237 9531237 20260318224833_30WIw UK0024 2026-03-20T12:25:02.833Z 2026-03-26T12:39:18.278Z
9530884 9530884 20260318215713_CJC7q UK0024 2026-03-20T12:24:50.828Z 2026-03-26T12:39:16.418Z
9530380 9530380 20260318204608_Fhc3c UK0024 2026-03-20T12:24:20.435Z 2026-03-26T12:39:11.747Z
9529765 9529765 20260318192801_fQY23 UK0024 2026-03-20T12:23:38.134Z 2026-03-26T12:39:06.319Z
9521996 9521996 20260319050832_4sTjD UK0024 2026-03-20T12:08:50.044Z 2026-03-27T12:41:12.564Z
9521888 9521888 20260319045139_ZSsrr UK0024 2026-03-20T12:08:42.884Z 2026-03-27T12:41:11.636Z
9521795 9521795 20260319044652_hPLI6 UK0024 2026-03-20T12:08:33.594Z 2026-03-27T12:41:10.839Z
9520411 9520411 20260319031406_3isc7 UK0024 2026-03-20T12:06:20.717Z 2026-03-27T12:40:42.717Z
9519954 9519954 20260319024528_6Ogo6 UK0024 2026-03-20T12:05:25.360Z 2026-03-27T12:40:37.258Z
9519919 9519919 20260319024326_ScdVs UK0024 2026-03-20T12:05:23.119Z 2026-03-27T12:40:37.041Z
9519735 9519735 20260319023243_LT8Uj UK0024 2026-03-20T12:05:00.660Z 2026-03-27T12:40:34.979Z
9519647 9519647 20260319022534_57Ig2 UK0024 2026-03-20T12:04:50.006Z 2026-03-27T12:40:33.741Z
9519347 9519347 20260319020439_l3RDu UK0024 2026-03-20T12:04:20.893Z 2026-03-27T12:40:25.239Z
9519329 9519329 20260319020332_uoC39 UK0024 2026-03-20T12:04:19.545Z 2026-03-27T12:40:20.202Z
9519322 9519322 20260319020138_Xh4JK UK0024 2026-03-20T12:04:17.192Z 2026-03-27T12:40:20.109Z
9519016 9519016 20260319014121_zQnuo UK0024 2026-03-20T12:03:47.147Z 2026-03-27T12:40:17.320Z
9518785 9518785 20260319012534_TbbnC UK0024 2026-03-20T12:03:20.361Z 2026-03-27T12:40:13.798Z
9518670 9518670 20260319011702_W3qkZ UK0024 2026-03-20T12:03:05.478Z 2026-03-27T12:40:12.552Z
9518512 9518512 20260319010551_Yn6Qs UK0024 2026-03-20T12:02:45.035Z 2026-03-27T12:40:10.986Z
9518090 9518090 20260319002714_z33X6 UK0024 2026-03-20T12:01:52.097Z 2026-03-27T12:40:06.199Z
9517876 9517876 20260319000909_DwsmB UK0024 2026-03-20T12:01:27.586Z 2026-03-27T12:40:04.441Z
9517691 9517691 20260318235442_VDePQ UK0024 2026-03-20T12:01:02.438Z 2026-03-27T12:40:02.444Z
9517297 9517297 20260317230659_gLoPJ UK0024 2026-03-19T12:27:27.071Z 2026-03-25T12:43:09.999Z
9517129 9517129 20260317224502_xGIaM UK0024 2026-03-19T12:27:13.846Z 2026-03-25T12:43:08.918Z
9517036 9517036 20260317222902_hXfpm UK0024 2026-03-19T12:27:06.670Z 2026-03-25T12:43:08.175Z
9516770 9516770 20260317215427_LYU4J UK0024 2026-03-19T12:26:46.190Z 2026-03-25T12:43:06.864Z
9516447 9516447 20260317205427_HVF6C UK0024 2026-03-19T12:26:13.454Z 2026-03-25T12:42:59.243Z
9512135 9512135 20260318044558_L09e1 UK0024 2026-03-19T12:11:46.684Z 2026-03-26T12:37:42.637Z
9511584 9511584 20260318040248_CwLiM UK0024 2026-03-19T12:10:33.071Z 2026-03-26T12:37:38.103Z
9510815 9510815 20260318031640_kAHwD UK0024 2026-03-19T12:08:44.504Z 2026-03-26T12:37:16.894Z

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