participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,278 rows where station_code = "UK004P" sorted by created_at descending
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 |
---|---|---|---|---|---|
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 |
2709903 | 2709903 | 20230807005755_uuMSF | UK004P | 2024-01-06T00:00:17.841Z | 2024-01-06T00:00:17.841Z |
2709758 | 2709758 | 20230807005125_5Hghz | UK004P | 2024-01-06T00:00:17.832Z | 2024-01-06T00:00:17.832Z |
2709604 | 2709604 | 20230807004721_RRXVJ | UK004P | 2024-01-06T00:00:17.822Z | 2024-01-06T00:00:17.822Z |
2709262 | 2709262 | 20230807003146_sX3hX | UK004P | 2024-01-06T00:00:17.798Z | 2024-01-06T00:00:17.798Z |
2709041 | 2709041 | 20230807002353_WRoV0 | UK004P | 2024-01-06T00:00:17.784Z | 2024-01-06T00:00:17.784Z |
2708903 | 2708903 | 20230807001940_LhUXl | UK004P | 2024-01-06T00:00:17.776Z | 2024-01-06T00:00:17.776Z |
2708888 | 2708888 | 20230807001900_6Pkrg | UK004P | 2024-01-06T00:00:17.775Z | 2024-01-06T00:00:17.775Z |
2708731 | 2708731 | 20230807001236_PtOKd | UK004P | 2024-01-06T00:00:17.765Z | 2024-01-06T00:00:17.765Z |
2708583 | 2708583 | 20230807000420_f4n0R | UK004P | 2024-01-06T00:00:17.754Z | 2024-01-06T00:00:17.754Z |
2708503 | 2708503 | 20230806235859_EDSRc | UK004P | 2024-01-06T00:00:17.747Z | 2024-01-06T00:00:17.747Z |
2708336 | 2708336 | 20230806235053_blAQw | UK004P | 2024-01-06T00:00:17.736Z | 2024-01-06T00:00:17.736Z |
2708292 | 2708292 | 20230806234938_dqhhv | UK004P | 2024-01-06T00:00:17.732Z | 2024-01-06T00:00:17.732Z |
2708175 | 2708175 | 20230806234228_2iOUy | UK004P | 2024-01-06T00:00:17.724Z | 2024-01-06T00:00:17.724Z |
2708045 | 2708045 | 20230806233546_Ic71F | UK004P | 2024-01-06T00:00:17.715Z | 2024-01-06T00:00:17.715Z |
2707728 | 2707728 | 20230806232016_p58n7 | UK004P | 2024-01-06T00:00:17.694Z | 2024-01-06T00:00:17.694Z |
2707387 | 2707387 | 20230806225918_VIkVO | UK004P | 2024-01-06T00:00:17.667Z | 2024-01-06T00:00:17.667Z |
2707378 | 2707378 | 20230806225909_W76BQ | UK004P | 2024-01-06T00:00:17.666Z | 2024-01-06T00:00:17.666Z |
Advanced export
JSON shape: default, array, newline-delimited
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);