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 = "UK0098" 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
9611762 9611762 20260405032145_CXpOP UK0098 2026-04-06T12:15:55.259Z 2026-04-06T12:16:14.859Z
9611728 9611728 20260405031842_v5VeH UK0098 2026-04-06T12:15:50.387Z 2026-04-06T12:16:14.854Z
9611704 9611704 20260405031620_8vqGv UK0098 2026-04-06T12:15:46.975Z 2026-04-06T12:16:14.850Z
9611660 9611660 20260405025843_iHGFh UK0098 2026-04-06T12:15:37.061Z 2026-04-06T12:16:14.842Z
9611539 9611539 20260405023305_Sj6pI UK0098 2026-04-06T12:15:01.430Z 2026-04-06T12:16:14.818Z
9611419 9611419 20260405015320_Y3m59 UK0098 2026-04-06T12:14:32.200Z 2026-04-06T12:16:14.797Z
9611388 9611388 20260405014351_kva1F UK0098 2026-04-06T12:14:15.204Z 2026-04-06T12:16:14.791Z
9611328 9611328 20260405012738_dw303 UK0098 2026-04-06T12:14:01.825Z 2026-04-06T12:16:14.779Z
9611044 9611044 20260404233822_Nu23F UK0098 2026-04-06T12:12:46.450Z 2026-04-06T12:16:14.719Z
9609263 9609263 20260405040602_Fxp4j UK0098 2026-04-06T12:00:51.171Z 2026-04-06T12:00:51.171Z
9609223 9609223 20260405040134_bLRav UK0098 2026-04-06T12:00:45.945Z 2026-04-06T12:00:45.945Z
9609197 9609197 20260405035806_OFdo5 UK0098 2026-04-06T12:00:41.409Z 2026-04-06T12:00:41.409Z
9608686 9608686 20260404004219_MqJil UK0098 2026-04-05T12:11:17.467Z 2026-04-06T12:20:30.628Z
9608565 9608565 20260403234038_Q98Qs UK0098 2026-04-05T12:10:49.963Z 2026-04-06T12:20:20.882Z
9608533 9608533 20260403233233_JZNxx UK0098 2026-04-05T12:10:45.878Z 2026-04-06T12:20:19.075Z
9608515 9608515 20260403232829_ZFMMC UK0098 2026-04-05T12:10:42.877Z 2026-04-06T12:20:18.108Z
9608445 9608445 20260403230641_MWiiM UK0098 2026-04-05T12:10:28.354Z 2026-04-06T12:20:13.400Z
9608422 9608422 20260403230257_cm72s UK0098 2026-04-05T12:10:24.416Z 2026-04-06T12:20:12.030Z
9608283 9608283 20260403212957_Enk12 UK0098 2026-04-05T12:09:54.160Z 2026-04-06T12:20:03.501Z
9608194 9608194 20260403204507_I7yys UK0098 2026-04-05T12:09:26.527Z 2026-04-06T12:19:53.105Z
9608162 9608162 20260403202352_Vjtf3 UK0098 2026-04-05T12:09:08.335Z 2026-04-06T12:19:47.216Z
9602474 9602474 20260331212927_qlPUf UK0098 2026-04-02T12:09:01.328Z 2026-04-06T12:29:13.390Z
9602421 9602421 20260331205818_eG3vg UK0098 2026-04-02T12:08:47.466Z 2026-04-06T12:29:07.255Z
9602399 9602399 20260331204824_8qTQg UK0098 2026-04-02T12:08:42.628Z 2026-04-06T12:29:05.352Z
9602377 9602377 20260331203412_UIb4D UK0098 2026-04-02T12:08:36.387Z 2026-04-06T12:29:03.714Z
9602363 9602363 20260331202049_MD3JH UK0098 2026-04-02T12:08:34.308Z 2026-04-06T12:29:02.906Z
9602308 9602308 20260331193934_a9bKo UK0098 2026-04-02T12:08:19.942Z 2026-04-06T12:28:57.616Z
9595475 9595475 20260330041509_x6h57 UK0098 2026-03-31T12:01:30.883Z 2026-04-06T12:30:05.526Z
9595342 9595342 20260330034600_0dKqY UK0098 2026-03-31T12:01:11.531Z 2026-04-06T12:29:58.921Z
9594372 9594372 20260328215357_Dct3P UK0098 2026-03-30T12:09:24.860Z 2026-04-06T12:39:49.822Z
9594355 9594355 20260328214100_KbNGN UK0098 2026-03-30T12:09:22.274Z 2026-04-06T12:39:49.026Z
9594221 9594221 20260328202128_EoQ1K UK0098 2026-03-30T12:09:00.902Z 2026-04-06T12:39:43.742Z
9594202 9594202 20260328200750_92LcM UK0098 2026-03-30T12:08:58.498Z 2026-04-06T12:39:42.736Z
9592884 9592884 20260329034517_WiV3c UK0098 2026-03-30T12:02:13.187Z 2026-04-06T12:34:38.935Z
9592547 9592547 20260329022729_xmpIU UK0098 2026-03-30T12:01:15.996Z 2026-04-06T12:34:14.926Z
9592124 9592124 20260328004941_IkoUw UK0098 2026-03-29T12:07:12.182Z 2026-04-05T12:35:38.042Z
9592069 9592069 20260328000948_g0c3C UK0098 2026-03-29T12:07:09.063Z 2026-04-05T12:35:25.854Z
9592037 9592037 20260328000116_zr4KI UK0098 2026-03-29T12:07:07.331Z 2026-04-05T12:35:24.905Z
9592024 9592024 20260327235929_6v0iH UK0098 2026-03-29T12:07:06.654Z 2026-04-05T12:35:24.531Z
9591909 9591909 20260327230231_T25zD UK0098 2026-03-29T12:06:58.073Z 2026-04-05T12:35:19.365Z
9590029 9590029 20260328042936_7m7Tv UK0098 2026-03-29T12:01:53.411Z 2026-04-06T12:37:47.605Z
9590004 9590004 20260328042810_3zvWE UK0098 2026-03-29T12:01:51.579Z 2026-04-06T12:37:46.777Z
9589926 9589926 20260328042211_fWjy4 UK0098 2026-03-29T12:01:45.773Z 2026-04-06T12:37:38.533Z
9589923 9589923 20260328042211_IhA6V UK0098 2026-03-29T12:01:45.620Z 2026-04-06T12:37:38.428Z
9589767 9589767 20260328040624_IH222 UK0098 2026-03-29T12:01:37.295Z 2026-04-06T12:37:33.006Z
9589488 9589488 20260328033503_3BTdl UK0098 2026-03-29T12:01:19.865Z 2026-04-06T12:37:25.580Z
9589319 9589319 20260328031734_e35Hx UK0098 2026-03-29T12:01:06.728Z 2026-04-06T12:37:20.228Z
9589076 9589076 20260328022230_FXJJZ UK0098 2026-03-29T12:00:42.141Z 2026-04-06T12:37:01.276Z
9588965 9588965 20260328020418_ORLz9 UK0098 2026-03-29T12:00:34.960Z 2026-04-06T12:36:58.230Z
9584977 9584977 20260325225641_QEATY UK0098 2026-03-27T12:16:27.412Z 2026-04-03T12:39:45.395Z
9584971 9584971 20260325225639_NvVP2 UK0098 2026-03-27T12:16:27.065Z 2026-04-03T12:39:45.336Z
9584766 9584766 20260325220134_2tM2j UK0098 2026-03-27T12:16:05.102Z 2026-04-03T12:39:40.331Z
9584715 9584715 20260325214919_A2AO2 UK0098 2026-03-27T12:16:00.426Z 2026-04-03T12:39:29.676Z
9582119 9582119 20260326044012_vIzfz UK0098 2026-03-27T12:04:40.848Z 2026-04-04T12:39:38.175Z
9582084 9582084 20260326043431_uLSNe UK0098 2026-03-27T12:04:35.151Z 2026-04-04T12:39:37.207Z
9582000 9582000 20260326042117_kf55Z UK0098 2026-03-27T12:04:23.563Z 2026-04-04T12:39:34.563Z
9581895 9581895 20260326040822_rsdxQ UK0098 2026-03-27T12:04:05.191Z 2026-04-04T12:39:29.907Z
9581769 9581769 20260326035611_3U2Hi UK0098 2026-03-27T12:03:50.184Z 2026-04-04T12:39:20.353Z
9581746 9581746 20260326035448_ETQQI UK0098 2026-03-27T12:03:47.778Z 2026-04-04T12:39:18.009Z
9581573 9581573 20260326033136_H7QUJ UK0098 2026-03-27T12:03:25.762Z 2026-04-04T12:39:11.002Z
9581464 9581464 20260326031614_IdewG UK0098 2026-03-27T12:03:11.387Z 2026-04-04T12:39:07.030Z
9581444 9581444 20260326031439_mlr2n UK0098 2026-03-27T12:03:09.350Z 2026-04-04T12:39:06.286Z
9581430 9581430 20260326031306_PJijM UK0098 2026-03-27T12:03:05.929Z 2026-04-04T12:39:04.687Z
9581417 9581417 20260326030924_HRzXo UK0098 2026-03-27T12:03:02.883Z 2026-04-04T12:39:03.994Z
9581378 9581378 20260326030200_Omnwb UK0098 2026-03-27T12:02:54.871Z 2026-04-04T12:38:55.014Z
9581226 9581226 20260326023847_QbFXJ UK0098 2026-03-27T12:02:26.625Z 2026-04-04T12:38:47.054Z
9581179 9581179 20260326023233_WB5bk UK0098 2026-03-27T12:02:17.972Z 2026-04-04T12:38:44.736Z
9581141 9581141 20260326022937_tgf3C UK0098 2026-03-27T12:02:14.532Z 2026-04-04T12:38:43.961Z
9581126 9581126 20260326022731_oZw9m UK0098 2026-03-27T12:02:11.551Z 2026-04-04T12:38:43.403Z
9580952 9580952 20260326015721_OsJi2 UK0098 2026-03-27T12:01:45.363Z 2026-04-04T12:38:35.948Z
9580947 9580947 20260326015715_T79vB UK0098 2026-03-27T12:01:44.895Z 2026-04-04T12:38:35.527Z
9580844 9580844 20260326014447_1R1N3 UK0098 2026-03-27T12:01:32.539Z 2026-04-04T12:38:31.183Z
9580799 9580799 20260326013431_XdW6Y UK0098 2026-03-27T12:01:26.880Z 2026-04-04T12:38:29.831Z
9580702 9580702 20260326011850_hx5Kv UK0098 2026-03-27T12:01:12.656Z 2026-04-04T12:38:21.071Z
9580586 9580586 20260326010512_0zp8I UK0098 2026-03-27T12:00:51.699Z 2026-04-04T12:38:15.137Z
9580514 9580514 20260326005738_r8vVN UK0098 2026-03-27T12:00:40.931Z 2026-04-04T12:38:12.747Z
9580398 9580398 20260326004322_hQwqd UK0098 2026-03-27T12:00:21.338Z 2026-04-04T12:38:08.338Z
9580315 9580315 20260326002905_cEIhe UK0098 2026-03-27T12:00:09.697Z 2026-04-04T12:38:05.366Z
9577315 9577315 20260325045134_ffJ4A UK0098 2026-03-26T12:04:45.539Z 2026-04-03T12:36:56.329Z
9561467 9561467 20260321233709_HYtVc UK0098 2026-03-23T12:12:20.008Z 2026-03-29T12:21:07.497Z
9561304 9561304 20260321232047_YyOcv UK0098 2026-03-23T12:12:16.129Z 2026-03-29T12:21:06.288Z
9561220 9561220 20260321230937_fqZYa UK0098 2026-03-23T12:12:14.156Z 2026-03-29T12:21:05.793Z
9560800 9560800 20260321221535_L273u UK0098 2026-03-23T12:12:03.887Z 2026-03-29T12:21:02.940Z
9560404 9560404 20260321211309_C68na UK0098 2026-03-23T12:11:45.339Z 2026-03-29T12:20:59.911Z
9560374 9560374 20260321210634_7ar4h UK0098 2026-03-23T12:11:44.599Z 2026-03-29T12:20:59.705Z
9560242 9560242 20260321205105_4tGlK UK0098 2026-03-23T12:11:40.504Z 2026-03-29T12:20:58.743Z
9560191 9560191 20260321204556_Ng6di UK0098 2026-03-23T12:11:40.039Z 2026-03-29T12:20:58.473Z
9560076 9560076 20260321203000_23DV8 UK0098 2026-03-23T12:11:37.449Z 2026-03-29T12:20:57.789Z
9559752 9559752 20260321193855_0D02z UK0098 2026-03-23T12:11:28.909Z 2026-03-29T12:20:50.515Z
9555403 9555403 20260322044813_My0gm UK0098 2026-03-23T12:03:23.795Z 2026-03-30T12:28:25.991Z
9555223 9555223 20260322042621_fhWTF UK0098 2026-03-23T12:03:16.029Z 2026-03-30T12:28:23.070Z
9554999 9554999 20260322035240_lo4yM UK0098 2026-03-23T12:03:01.417Z 2026-03-30T12:28:12.942Z
9554755 9554755 20260322033329_MKL3U UK0098 2026-03-23T12:02:49.365Z 2026-03-30T12:28:08.432Z
9554462 9554462 20260322031138_iF1r9 UK0098 2026-03-23T12:02:33.750Z 2026-03-30T12:28:04.278Z
9554135 9554135 20260322024247_4tP3P UK0098 2026-03-23T12:02:15.818Z 2026-03-30T12:27:58.893Z
9554053 9554053 20260322023455_3R8JN UK0098 2026-03-23T12:02:11.364Z 2026-03-30T12:27:57.513Z
9553974 9553974 20260322022942_A36vo UK0098 2026-03-23T12:02:04.465Z 2026-03-30T12:27:56.298Z
9553213 9553213 20260322012507_TZvhq UK0098 2026-03-23T12:01:19.512Z 2026-03-30T12:27:38.030Z
9553166 9553166 20260322012243_183id UK0098 2026-03-23T12:01:17.968Z 2026-03-30T12:27:36.022Z
9552465 9552465 20260322001308_4XT4i UK0098 2026-03-23T12:00:27.477Z 2026-03-30T12:27:24.742Z

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