participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,995 rows where station_code = "UK006S" 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 |
---|---|---|---|---|---|
5129795 | 5129795 | 20240917043123_m7HA3 | UK006S | 2024-09-19T12:12:05.535Z | 2024-09-19T12:12:05.535Z |
5129767 | 5129767 | 20240917042607_3EGWz | UK006S | 2024-09-19T12:12:03.110Z | 2024-09-19T12:12:03.110Z |
5129437 | 5129437 | 20240917035609_0Sfo9 | UK006S | 2024-09-19T12:11:37.165Z | 2024-09-19T12:11:37.165Z |
5129402 | 5129402 | 20240917035457_VPmvh | UK006S | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5128873 | 5128873 | 20240917024913_tCBKt | UK006S | 2024-09-19T12:11:04.427Z | 2024-09-19T12:11:04.427Z |
5128744 | 5128744 | 20240917023112_gpYjQ | UK006S | 2024-09-19T12:10:59.755Z | 2024-09-19T12:10:59.755Z |
5128657 | 5128657 | 20240917022323_SqLcF | UK006S | 2024-09-19T12:10:54.701Z | 2024-09-19T12:10:54.701Z |
5128617 | 5128617 | 20240917020932_OGMRa | UK006S | 2024-09-19T12:10:48.280Z | 2024-09-19T12:10:48.280Z |
5128485 | 5128485 | 20240917014859_I4xAH | UK006S | 2024-09-19T12:10:38.166Z | 2024-09-19T12:10:38.166Z |
5128472 | 5128472 | 20240917014807_us3hY | UK006S | 2024-09-19T12:10:37.365Z | 2024-09-19T12:10:37.365Z |
5127785 | 5127785 | 20240916232851_6zpE1 | UK006S | 2024-09-19T12:09:38.237Z | 2024-09-19T12:09:38.237Z |
5122176 | 5122176 | 20240914044427_G92Nh | UK006S | 2024-09-18T12:11:08.491Z | 2024-09-19T12:20:02.923Z |
5122126 | 5122126 | 20240914043816_SE29n | UK006S | 2024-09-18T12:11:07.582Z | 2024-09-19T12:20:02.862Z |
5122027 | 5122027 | 20240914042820_mJEfX | UK006S | 2024-09-18T12:11:05.022Z | 2024-09-19T12:20:02.705Z |
5121976 | 5121976 | 20240914042323_4l1UM | UK006S | 2024-09-18T12:11:03.681Z | 2024-09-19T12:20:02.557Z |
5121892 | 5121892 | 20240914042027_UwaLG | UK006S | 2024-09-18T12:11:02.834Z | 2024-09-19T12:20:02.482Z |
5121693 | 5121693 | 20240914041211_gzgsf | UK006S | 2024-09-18T12:10:59.392Z | 2024-09-19T12:20:02.218Z |
5121508 | 5121508 | 20240914040632_tqKgU | UK006S | 2024-09-18T12:10:57.679Z | 2024-09-19T12:20:02.011Z |
5121235 | 5121235 | 20240914035618_03B7Q | UK006S | 2024-09-18T12:10:52.843Z | 2024-09-19T12:20:01.520Z |
5121202 | 5121202 | 20240914035523_kP3a1 | UK006S | 2024-09-18T12:10:52.371Z | 2024-09-19T12:20:01.490Z |
5120573 | 5120573 | 20240914032806_ymlDa | UK006S | 2024-09-18T12:10:43.226Z | 2024-09-19T12:20:00.607Z |
5120423 | 5120423 | 20240914032020_biyKl | UK006S | 2024-09-18T12:10:39.710Z | 2024-09-19T12:20:00.207Z |
5120183 | 5120183 | 20240914030406_bq1eN | UK006S | 2024-09-18T12:10:33.621Z | 2024-09-19T12:19:59.538Z |
5120087 | 5120087 | 20240914025930_rIbm3 | UK006S | 2024-09-18T12:10:31.838Z | 2024-09-19T12:19:59.384Z |
5119963 | 5119963 | 20240914025452_2jk3k | UK006S | 2024-09-18T12:10:30.091Z | 2024-09-19T12:19:59.202Z |
5119926 | 5119926 | 20240914025403_iRxM3 | UK006S | 2024-09-18T12:10:29.593Z | 2024-09-19T12:19:59.170Z |
5119868 | 5119868 | 20240914025122_ie63A | UK006S | 2024-09-18T12:10:28.275Z | 2024-09-19T12:19:59.033Z |
5119731 | 5119731 | 20240914024608_v3ZnX | UK006S | 2024-09-18T12:10:24.624Z | 2024-09-19T12:19:58.797Z |
5119574 | 5119574 | 20240914023927_OhmTT | UK006S | 2024-09-18T12:10:22.440Z | 2024-09-19T12:19:58.542Z |
5119188 | 5119188 | 20240914021639_pPkX5 | UK006S | 2024-09-18T12:10:18.066Z | 2024-09-19T12:19:57.353Z |
5117259 | 5117259 | 20240915041543_32kqX | UK006S | 2024-09-18T12:07:36.387Z | 2024-09-19T12:19:14.055Z |
5117213 | 5117213 | 20240915041252_4Zis3 | UK006S | 2024-09-18T12:07:35.679Z | 2024-09-19T12:19:13.901Z |
5117163 | 5117163 | 20240915040711_ETWrb | UK006S | 2024-09-18T12:07:34.310Z | 2024-09-19T12:19:13.674Z |
5113616 | 5113616 | 20240915010050_dCSql | UK006S | 2024-09-18T12:04:35.194Z | 2024-09-19T12:18:50.617Z |
5112225 | 5112225 | 20240914223819_rd33g | UK006S | 2024-09-18T12:02:54.247Z | 2024-09-19T12:18:39.837Z |
5108260 | 5108260 | 20240913043759_THDwJ | UK006S | 2024-09-17T12:13:34.232Z | 2024-09-19T12:20:47.977Z |
5108091 | 5108091 | 20240913042246_PcaE2 | UK006S | 2024-09-17T12:13:30.364Z | 2024-09-19T12:20:47.843Z |
5108067 | 5108067 | 20240913042227_zWWmq | UK006S | 2024-09-17T12:13:30.150Z | 2024-09-19T12:20:47.834Z |
5107916 | 5107916 | 20240913041500_M9G1b | UK006S | 2024-09-17T12:13:25.945Z | 2024-09-19T12:20:47.637Z |
5107893 | 5107893 | 20240913041400_b8zTH | UK006S | 2024-09-17T12:13:25.507Z | 2024-09-19T12:20:47.630Z |
5107211 | 5107211 | 20240913034703_eaT0T | UK006S | 2024-09-17T12:13:10.607Z | 2024-09-19T12:20:46.907Z |
5107198 | 5107198 | 20240913034700_OF89q | UK006S | 2024-09-17T12:13:10.532Z | 2024-09-19T12:20:46.900Z |
5107022 | 5107022 | 20240913034216_HMLrn | UK006S | 2024-09-17T12:13:08.100Z | 2024-09-19T12:20:46.784Z |
5106779 | 5106779 | 20240913033429_Vg6vb | UK006S | 2024-09-17T12:13:00.994Z | 2024-09-19T12:20:46.393Z |
5106509 | 5106509 | 20240913032819_BGeiB | UK006S | 2024-09-17T12:12:56.691Z | 2024-09-19T12:20:46.164Z |
5106147 | 5106147 | 20240913031239_nml32 | UK006S | 2024-09-17T12:12:43.239Z | 2024-09-19T12:20:45.544Z |
5105993 | 5105993 | 20240913030537_DRrA0 | UK006S | 2024-09-17T12:12:35.358Z | 2024-09-19T12:20:45.114Z |
5105968 | 5105968 | 20240913030414_3Cc2F | UK006S | 2024-09-17T12:12:34.557Z | 2024-09-19T12:20:45.090Z |
5105948 | 5105948 | 20240913030350_8635I | UK006S | 2024-09-17T12:12:34.439Z | 2024-09-19T12:20:45.079Z |
5105895 | 5105895 | 20240913030210_5vnyB | UK006S | 2024-09-17T12:12:32.213Z | 2024-09-19T12:20:45.038Z |
5105732 | 5105732 | 20240913025617_2nmQb | UK006S | 2024-09-17T12:12:28.127Z | 2024-09-19T12:20:44.861Z |
5105671 | 5105671 | 20240913025456_vtBVi | UK006S | 2024-09-17T12:12:25.624Z | 2024-09-19T12:20:44.791Z |
5105409 | 5105409 | 20240913024434_fjOjP | UK006S | 2024-09-17T12:12:13.288Z | 2024-09-19T12:20:44.397Z |
5105348 | 5105348 | 20240913024217_lH8wJ | UK006S | 2024-09-17T12:12:10.507Z | 2024-09-19T12:20:44.309Z |
5104746 | 5104746 | 20240913022011_3wdyn | UK006S | 2024-09-17T12:11:43.763Z | 2024-09-19T12:20:42.838Z |
5104729 | 5104729 | 20240913021954_cot1K | UK006S | 2024-09-17T12:11:43.630Z | 2024-09-19T12:20:42.836Z |
5104206 | 5104206 | 20240913015826_GtGD4 | UK006S | 2024-09-17T12:11:28.886Z | 2024-09-19T12:20:41.203Z |
5103743 | 5103743 | 20240913013839_MgwIZ | UK006S | 2024-09-17T12:11:09.652Z | 2024-09-19T12:20:40.445Z |
5103605 | 5103605 | 20240913013431_c3daU | UK006S | 2024-09-17T12:11:06.077Z | 2024-09-19T12:20:40.379Z |
5102080 | 5102080 | 20240914010522_m1qbx | UK006S | 2024-09-17T12:06:47.105Z | 2024-09-19T12:19:52.409Z |
5101920 | 5101920 | 20240914005527_NzMrf | UK006S | 2024-09-17T12:06:24.077Z | 2024-09-19T12:19:51.861Z |
5101743 | 5101743 | 20240914004422_UBJy3 | UK006S | 2024-09-17T12:06:10.744Z | 2024-09-19T12:19:51.351Z |
5101423 | 5101423 | 20240914002608_YzTwN | UK006S | 2024-09-17T12:05:46.167Z | 2024-09-19T12:19:50.515Z |
5101313 | 5101313 | 20240914001913_y13qc | UK006S | 2024-09-17T12:05:34.769Z | 2024-09-19T12:19:50.251Z |
5098058 | 5098058 | 20240913011520_H7HAh | UK006S | 2024-09-16T12:17:19.214Z | 2024-09-19T12:20:39.587Z |
5097631 | 5097631 | 20240913005726_z907T | UK006S | 2024-09-16T12:17:13.813Z | 2024-09-19T12:20:38.855Z |
5097520 | 5097520 | 20240913005218_90IdC | UK006S | 2024-09-16T12:17:13.224Z | 2024-09-19T12:20:38.685Z |
5094911 | 5094911 | 20240912043619_Ir2lF | UK006S | 2024-09-16T12:15:01.105Z | 2024-09-19T12:21:16.545Z |
5094894 | 5094894 | 20240912043333_ZuNvu | UK006S | 2024-09-16T12:15:00.928Z | 2024-09-19T12:21:16.514Z |
5094800 | 5094800 | 20240912042354_CT8mt | UK006S | 2024-09-16T12:14:58.722Z | 2024-09-19T12:21:16.436Z |
5094672 | 5094672 | 20240912041435_23yq3 | UK006S | 2024-09-16T12:14:53.887Z | 2024-09-19T12:21:16.372Z |
5094237 | 5094237 | 20240912035411_JoaMv | UK006S | 2024-09-16T12:14:39.794Z | 2024-09-19T12:21:16.030Z |
5093693 | 5093693 | 20240912033258_y2SVU | UK006S | 2024-09-16T12:14:24.065Z | 2024-09-19T12:21:15.593Z |
5093676 | 5093676 | 20240912033215_GhtkC | UK006S | 2024-09-16T12:14:23.878Z | 2024-09-19T12:21:15.588Z |
5093412 | 5093412 | 20240912032020_FW32T | UK006S | 2024-09-16T12:14:16.550Z | 2024-09-19T12:21:15.307Z |
5093317 | 5093317 | 20240912031750_oLZM7 | UK006S | 2024-09-16T12:14:15.275Z | 2024-09-19T12:21:15.222Z |
5093128 | 5093128 | 20240912031231_OMnQR | UK006S | 2024-09-16T12:14:11.820Z | 2024-09-19T12:21:14.948Z |
5092830 | 5092830 | 20240912025929_NdeEe | UK006S | 2024-09-16T12:14:05.056Z | 2024-09-19T12:21:14.600Z |
5092761 | 5092761 | 20240912025622_elS9Z | UK006S | 2024-09-16T12:14:03.522Z | 2024-09-19T12:21:14.528Z |
5092703 | 5092703 | 20240912025508_2E2zD | UK006S | 2024-09-16T12:14:02.367Z | 2024-09-19T12:21:14.426Z |
5092284 | 5092284 | 20240912024205_EW2CV | UK006S | 2024-09-16T12:13:47.547Z | 2024-09-19T12:21:13.813Z |
5092203 | 5092203 | 20240912024005_69ypU | UK006S | 2024-09-16T12:13:43.783Z | 2024-09-19T12:21:13.699Z |
5092026 | 5092026 | 20240912023519_8Kpq9 | UK006S | 2024-09-16T12:13:38.402Z | 2024-09-19T12:21:13.602Z |
5091791 | 5091791 | 20240912022332_m5jrV | UK006S | 2024-09-16T12:13:24.209Z | 2024-09-19T12:21:13.401Z |
5091510 | 5091510 | 20240912021119_fOtwA | UK006S | 2024-09-16T12:13:08.826Z | 2024-09-19T12:21:13.105Z |
5091432 | 5091432 | 20240912020942_gADsK | UK006S | 2024-09-16T12:13:06.237Z | 2024-09-19T12:21:13.031Z |
5091216 | 5091216 | 20240912020240_335aV | UK006S | 2024-09-16T12:12:55.406Z | 2024-09-19T12:21:12.676Z |
5091195 | 5091195 | 20240912020213_U1v85 | UK006S | 2024-09-16T12:12:54.734Z | 2024-09-19T12:21:12.642Z |
5091022 | 5091022 | 20240912015545_2qpdO | UK006S | 2024-09-16T12:12:46.796Z | 2024-09-19T12:21:12.455Z |
5090476 | 5090476 | 20240912012733_SX3w8 | UK006S | 2024-09-16T12:12:21.535Z | 2024-09-19T12:21:11.339Z |
5090295 | 5090295 | 20240912012012_Rxaae | UK006S | 2024-09-16T12:12:11.822Z | 2024-09-19T12:21:11.170Z |
5089763 | 5089763 | 20240912005655_LHM8j | UK006S | 2024-09-16T12:11:41.520Z | 2024-09-19T12:21:10.459Z |
5089634 | 5089634 | 20240912005204_9pMze | UK006S | 2024-09-16T12:11:33.223Z | 2024-09-19T12:21:10.111Z |
5089454 | 5089454 | 20240912004214_cBm1J | UK006S | 2024-09-16T12:11:25.714Z | 2024-09-19T12:21:09.967Z |
5089347 | 5089347 | 20240912003729_xVa0M | UK006S | 2024-09-16T12:11:21.318Z | 2024-09-19T12:21:09.897Z |
5089260 | 5089260 | 20240912003156_oe9n6 | UK006S | 2024-09-16T12:11:18.694Z | 2024-09-19T12:21:09.851Z |
5089147 | 5089147 | 20240912002750_gu4AV | UK006S | 2024-09-16T12:11:16.335Z | 2024-09-19T12:21:09.811Z |
5089138 | 5089138 | 20240912002730_au1DM | UK006S | 2024-09-16T12:11:16.108Z | 2024-09-19T12:21:09.807Z |
5089095 | 5089095 | 20240912002601_LZJZ0 | UK006S | 2024-09-16T12:11:15.034Z | 2024-09-19T12:21:09.743Z |
5088690 | 5088690 | 20240913002128_494pi | UK006S | 2024-09-16T12:08:20.947Z | 2024-09-19T12:20:37.182Z |
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);