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,295 rows where station_code = "UK004P" 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
9273269 9273269 20260128052118_LZOzb UK004P 2026-01-29T14:29:15.189Z 2026-01-29T14:30:25.780Z
9272410 9272410 20260128015909_T1k56 UK004P 2026-01-29T14:26:36.945Z 2026-01-29T14:30:25.343Z
9271600 9271600 20260127182817_W8iBN UK004P 2026-01-29T14:21:43.047Z 2026-01-29T14:30:24.962Z
9255448 9255448 20260124033648_xkX8Y UK004P 2026-01-25T14:13:29.346Z 2026-01-29T14:47:31.400Z
9237025 9237025 20260120042817_IZnyx UK004P 2026-01-21T14:24:58.821Z 2026-01-28T15:00:54.491Z
9228586 9228586 20260118230244_sIioU UK004P 2026-01-20T14:18:31.142Z 2026-01-27T15:02:09.450Z
9228469 9228469 20260118223030_v9Dy1 UK004P 2026-01-20T14:17:56.665Z 2026-01-27T15:02:03.035Z
9218365 9218365 20260117031901_uFZgq UK004P 2026-01-18T14:11:49.227Z 2026-01-25T14:58:23.526Z
9218359 9218359 20260117031820_2m8KC UK004P 2026-01-18T14:11:47.864Z 2026-01-25T14:58:23.302Z
9213195 9213195 20260116023316_LLqNI UK004P 2026-01-17T14:15:52.304Z 2026-01-24T15:11:48.668Z
9213168 9213168 20260116022925_MM8FV UK004P 2026-01-17T14:15:44.434Z 2026-01-24T15:11:47.657Z
9213161 9213161 20260116022912_YcLsb UK004P 2026-01-17T14:15:43.823Z 2026-01-24T15:11:47.565Z
9213051 9213051 20260116020211_XcUyn UK004P 2026-01-17T14:15:10.876Z 2026-01-24T15:11:38.676Z
9212890 9212890 20260116013453_79sV0 UK004P 2026-01-17T14:14:26.202Z 2026-01-24T15:11:32.579Z
9212860 9212860 20260116012326_syc6Z UK004P 2026-01-17T14:14:17.118Z 2026-01-24T15:11:30.717Z
9212843 9212843 20260116012051_7zA1p UK004P 2026-01-17T14:14:14.374Z 2026-01-24T15:11:29.405Z
9207449 9207449 20260115014256_RzUhj UK004P 2026-01-16T14:08:48.301Z 2026-01-22T15:03:22.288Z
2867245 2867245 20230821004906_sIgUZ UK004P 2024-01-06T00:01:05.818Z 2024-01-06T00:01:05.818Z
2866928 2866928 20230821003638_RWekm UK004P 2024-01-06T00:01:05.797Z 2024-01-06T00:01:05.797Z
2866474 2866474 20230821000956_1NNst UK004P 2024-01-06T00:01:05.758Z 2024-01-06T00:01:05.758Z
2866408 2866408 20230821000534_6sZAk UK004P 2024-01-06T00:01:05.752Z 2024-01-06T00:01:05.752Z
2865897 2865897 20230820233900_gXtbM UK004P 2024-01-06T00:01:05.712Z 2024-01-06T00:01:05.712Z
2865857 2865857 20230820233758_6HL7t UK004P 2024-01-06T00:01:05.711Z 2024-01-06T00:01:05.711Z
2865805 2865805 20230820233524_Tf991 UK004P 2024-01-06T00:01:05.708Z 2024-01-06T00:01:05.708Z
2865701 2865701 20230820232646_VLFK8 UK004P 2024-01-06T00:01:05.697Z 2024-01-06T00:01:05.697Z
2865558 2865558 20230820231721_lib57 UK004P 2024-01-06T00:01:05.687Z 2024-01-06T00:01:05.687Z
2865473 2865473 20230820231337_EsoXx UK004P 2024-01-06T00:01:05.681Z 2024-01-06T00:01:05.681Z
2865277 2865277 20230820230511_T1uHG UK004P 2024-01-06T00:01:05.666Z 2024-01-06T00:01:05.666Z
2865111 2865111 20230820225332_ClfpL UK004P 2024-01-06T00:01:05.653Z 2024-01-06T00:01:05.653Z
2864397 2864397 20230820220303_GxdLx UK004P 2024-01-06T00:01:05.591Z 2024-01-06T00:01:05.591Z
2864290 2864290 20230820215841_yL53v UK004P 2024-01-06T00:01:05.583Z 2024-01-06T00:01:05.583Z
2864210 2864210 20230820215345_OTMCP UK004P 2024-01-06T00:01:05.578Z 2024-01-06T00:01:05.578Z
2863797 2863797 20230820212047_4LL5G UK004P 2024-01-06T00:01:05.541Z 2024-01-06T00:01:05.541Z
2863726 2863726 20230820211113_q6azb UK004P 2024-01-06T00:01:05.527Z 2024-01-06T00:01:05.527Z
2852171 2852171 20230819030348_VDzfw UK004P 2024-01-06T00:01:01.762Z 2024-01-06T00:01:01.762Z
2852140 2852140 20230819025623_wQrky UK004P 2024-01-06T00:01:01.759Z 2024-01-06T00:01:01.759Z
2852133 2852133 20230819025543_lOCuD UK004P 2024-01-06T00:01:01.758Z 2024-01-06T00:01:01.758Z
2852073 2852073 20230819024537_OPVbE UK004P 2024-01-06T00:01:01.751Z 2024-01-06T00:01:01.751Z
2838200 2838200 20230816234233_pyVrF UK004P 2024-01-06T00:00:57.559Z 2024-01-06T00:00:57.559Z
2838174 2838174 20230816234131_Rvlud UK004P 2024-01-06T00:00:57.557Z 2024-01-06T00:00:57.557Z
2838135 2838135 20230816234000_7q4oQ UK004P 2024-01-06T00:00:57.554Z 2024-01-06T00:00:57.554Z
2837002 2837002 20230816222113_avHnw UK004P 2024-01-06T00:00:57.446Z 2024-01-06T00:00:57.446Z
2836172 2836172 20230816212022_scg8x UK004P 2024-01-06T00:00:57.366Z 2024-01-06T00:00:57.366Z
2836147 2836147 20230816211726_9xg0C UK004P 2024-01-06T00:00:57.363Z 2024-01-06T00:00:57.363Z
2836064 2836064 20230816211106_IGPeE UK004P 2024-01-06T00:00:57.354Z 2024-01-06T00:00:57.354Z
2817167 2817167 20230815031900_8Tezg UK004P 2024-01-06T00:00:48.444Z 2024-01-06T00:00:48.444Z
2816887 2816887 20230815031009_ak1CR UK004P 2024-01-06T00:00:48.410Z 2024-01-06T00:00:48.410Z
2816515 2816515 20230815025928_A12iu UK004P 2024-01-06T00:00:48.369Z 2024-01-06T00:00:48.369Z
2816497 2816497 20230815025835_eulkD UK004P 2024-01-06T00:00:48.366Z 2024-01-06T00:00:48.366Z
2816484 2816484 20230815025819_6b8tZ UK004P 2024-01-06T00:00:48.365Z 2024-01-06T00:00:48.365Z
2816395 2816395 20230815025650_29t9n UK004P 2024-01-06T00:00:48.357Z 2024-01-06T00:00:48.357Z
2816379 2816379 20230815025639_u4Ae8 UK004P 2024-01-06T00:00:48.356Z 2024-01-06T00:00:48.356Z
2815836 2815836 20230815023956_W2eOU UK004P 2024-01-06T00:00:48.295Z 2024-01-06T00:00:48.295Z
2815747 2815747 20230815023622_Po3OL UK004P 2024-01-06T00:00:48.283Z 2024-01-06T00:00:48.283Z
2815663 2815663 20230815023315_mr1LP UK004P 2024-01-06T00:00:48.272Z 2024-01-06T00:00:48.272Z
2815564 2815564 20230815023036_RE35i UK004P 2024-01-06T00:00:48.258Z 2024-01-06T00:00:48.258Z
2815316 2815316 20230815022425_Dum2U UK004P 2024-01-06T00:00:48.217Z 2024-01-06T00:00:48.217Z
2815240 2815240 20230815022311_REqXr UK004P 2024-01-06T00:00:48.208Z 2024-01-06T00:00:48.208Z
2814822 2814822 20230815021201_VQ6u0 UK004P 2024-01-06T00:00:48.147Z 2024-01-06T00:00:48.147Z
2814797 2814797 20230815021151_1oO8C UK004P 2024-01-06T00:00:48.145Z 2024-01-06T00:00:48.145Z
2814726 2814726 20230815021021_ibyVK UK004P 2024-01-06T00:00:48.139Z 2024-01-06T00:00:48.139Z
2814651 2814651 20230815020801_YEv7V UK004P 2024-01-06T00:00:48.126Z 2024-01-06T00:00:48.126Z
2814521 2814521 20230815020539_N944k UK004P 2024-01-06T00:00:48.106Z 2024-01-06T00:00:48.106Z
2813454 2813454 20230815014418_k9Tx3 UK004P 2024-01-06T00:00:47.946Z 2024-01-06T00:00:47.946Z
2813387 2813387 20230815014255_vyc1S UK004P 2024-01-06T00:00:47.937Z 2024-01-06T00:00:47.937Z
2736216 2736216 20230810000607_osaNm UK004P 2024-01-06T00:00:27.709Z 2024-01-06T00:00:27.709Z
2736205 2736205 20230810000557_FeD3A UK004P 2024-01-06T00:00:27.707Z 2024-01-06T00:00:27.707Z
2735931 2735931 20230809235844_Py6im UK004P 2024-01-06T00:00:27.664Z 2024-01-06T00:00:27.664Z
2735786 2735786 20230809235414_WlEye UK004P 2024-01-06T00:00:27.643Z 2024-01-06T00:00:27.643Z
2735653 2735653 20230809234801_6u87R UK004P 2024-01-06T00:00:27.617Z 2024-01-06T00:00:27.617Z
2735270 2735270 20230809232904_0tvYx UK004P 2024-01-06T00:00:27.545Z 2024-01-06T00:00:27.545Z
2734959 2734959 20230809231928_YsoE6 UK004P 2024-01-06T00:00:27.494Z 2024-01-06T00:00:27.494Z
2734877 2734877 20230809231351_6nNL5 UK004P 2024-01-06T00:00:27.478Z 2024-01-06T00:00:27.478Z
2734720 2734720 20230809230929_xzOiM UK004P 2024-01-06T00:00:27.455Z 2024-01-06T00:00:27.455Z
2734304 2734304 20230809225337_VG2It UK004P 2024-01-06T00:00:27.385Z 2024-01-06T00:00:27.385Z
2734242 2734242 20230809225005_qAcQJ UK004P 2024-01-06T00:00:27.373Z 2024-01-06T00:00:27.373Z
2733908 2733908 20230809223727_TM1hL UK004P 2024-01-06T00:00:27.316Z 2024-01-06T00:00:27.316Z
2733331 2733331 20230809220801_IQ8At UK004P 2024-01-06T00:00:27.218Z 2024-01-06T00:00:27.218Z
2733089 2733089 20230809215627_AQGkH UK004P 2024-01-06T00:00:27.175Z 2024-01-06T00:00:27.175Z
2732934 2732934 20230809214521_B4iZ5 UK004P 2024-01-06T00:00:27.147Z 2024-01-06T00:00:27.147Z
2729972 2729972 20230809021731_GqSca UK004P 2024-01-06T00:00:24.200Z 2024-01-06T00:00:24.200Z
2712488 2712488 20230807024315_h5ZXy UK004P 2024-01-06T00:00:19.333Z 2024-01-06T00:00:19.333Z
2712474 2712474 20230807024302_WvyRw UK004P 2024-01-06T00:00:19.332Z 2024-01-06T00:00:19.332Z
2712326 2712326 20230807023641_WgHMF UK004P 2024-01-06T00:00:19.321Z 2024-01-06T00:00:19.321Z
2712182 2712182 20230807023117_a7hr5 UK004P 2024-01-06T00:00:19.309Z 2024-01-06T00:00:19.309Z
2712165 2712165 20230807023057_3QACw UK004P 2024-01-06T00:00:19.308Z 2024-01-06T00:00:19.308Z
2712151 2712151 20230807023028_ZTjUO UK004P 2024-01-06T00:00:19.307Z 2024-01-06T00:00:19.307Z
2712115 2712115 20230807022832_iySPK UK004P 2024-01-06T00:00:19.304Z 2024-01-06T00:00:19.304Z
2711941 2711941 20230807022109_P2kRP UK004P 2024-01-06T00:00:19.291Z 2024-01-06T00:00:19.291Z
2711840 2711840 20230807021745_QdS2U UK004P 2024-01-06T00:00:19.284Z 2024-01-06T00:00:19.284Z
2711825 2711825 20230807021720_CxOd3 UK004P 2024-01-06T00:00:19.283Z 2024-01-06T00:00:19.283Z
2711547 2711547 20230807020458_VFw9x UK004P 2024-01-06T00:00:19.263Z 2024-01-06T00:00:19.263Z
2711255 2711255 20230807015311_HQ5rc UK004P 2024-01-06T00:00:19.241Z 2024-01-06T00:00:19.241Z
2711078 2711078 20230807014518_LpzIO UK004P 2024-01-06T00:00:19.230Z 2024-01-06T00:00:19.230Z
2710822 2710822 20230807013358_GOeSR UK004P 2024-01-06T00:00:19.212Z 2024-01-06T00:00:19.212Z
2710370 2710370 20230807011523_tE5J3 UK004P 2024-01-06T00:00:17.872Z 2024-01-06T00:00:17.872Z
2710177 2710177 20230807010934_mbjqj UK004P 2024-01-06T00:00:17.858Z 2024-01-06T00:00:17.858Z
2710097 2710097 20230807010444_Hqz8b UK004P 2024-01-06T00:00:17.853Z 2024-01-06T00:00:17.853Z
2710022 2710022 20230807010207_TjiIb UK004P 2024-01-06T00:00:17.848Z 2024-01-06T00:00:17.848Z
2709964 2709964 20230807010133_VTSVA UK004P 2024-01-06T00:00:17.846Z 2024-01-06T00:00:17.846Z

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