participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,695 rows where station_code = "UK00A0" 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 |
---|---|---|---|---|---|
5135309 | 5135309 | 20240915034452_7Om9l | UK00A0 | 2024-09-19T12:19:12.501Z | 2024-09-19T12:19:12.501Z |
5133952 | 5133952 | 20240916041942_aX270 | UK00A0 | 2024-09-19T12:17:13.871Z | 2024-09-19T12:17:13.871Z |
5133807 | 5133807 | 20240916040602_bYLGY | UK00A0 | 2024-09-19T12:17:08.308Z | 2024-09-19T12:17:08.308Z |
5133799 | 5133799 | 20240916040600_rfa4F | UK00A0 | 2024-09-19T12:17:08.259Z | 2024-09-19T12:17:08.259Z |
5133578 | 5133578 | 20240916034148_UGbIi | UK00A0 | 2024-09-19T12:17:02.136Z | 2024-09-19T12:17:02.136Z |
5133523 | 5133523 | 20240916033624_CKW3Z | UK00A0 | 2024-09-19T12:17:00.429Z | 2024-09-19T12:17:00.429Z |
5133121 | 5133121 | 20240916025923_25RE3 | UK00A0 | 2024-09-19T12:16:44.581Z | 2024-09-19T12:16:44.581Z |
5133115 | 5133115 | 20240916025759_uF3b6 | UK00A0 | 2024-09-19T12:16:44.465Z | 2024-09-19T12:16:44.465Z |
5133045 | 5133045 | 20240916024757_9FNFd | UK00A0 | 2024-09-19T12:16:42.359Z | 2024-09-19T12:16:42.359Z |
5132879 | 5132879 | 20240916022442_Ezgpk | UK00A0 | 2024-09-19T12:16:35.229Z | 2024-09-19T12:16:35.229Z |
5132848 | 5132848 | 20240916022134_cUpiw | UK00A0 | 2024-09-19T12:16:34.404Z | 2024-09-19T12:16:34.404Z |
5132834 | 5132834 | 20240916022044_vTxPy | UK00A0 | 2024-09-19T12:16:34.207Z | 2024-09-19T12:16:34.207Z |
5132786 | 5132786 | 20240916021209_Der22 | UK00A0 | 2024-09-19T12:16:32.725Z | 2024-09-19T12:16:32.725Z |
5132740 | 5132740 | 20240916020339_UArj4 | UK00A0 | 2024-09-19T12:16:30.117Z | 2024-09-19T12:16:30.117Z |
5132660 | 5132660 | 20240916015040_7runA | UK00A0 | 2024-09-19T12:16:25.516Z | 2024-09-19T12:16:25.516Z |
5132586 | 5132586 | 20240916013728_TLFSN | UK00A0 | 2024-09-19T12:16:20.419Z | 2024-09-19T12:16:20.419Z |
5132500 | 5132500 | 20240916011841_r8Re2 | UK00A0 | 2024-09-19T12:16:15.478Z | 2024-09-19T12:16:15.478Z |
5132467 | 5132467 | 20240916011515_Zrmnt | UK00A0 | 2024-09-19T12:16:13.923Z | 2024-09-19T12:16:13.923Z |
5132359 | 5132359 | 20240916005037_rslEv | UK00A0 | 2024-09-19T12:16:09.291Z | 2024-09-19T12:16:09.291Z |
5132344 | 5132344 | 20240916004138_cpE2E | UK00A0 | 2024-09-19T12:16:08.250Z | 2024-09-19T12:16:08.250Z |
5132265 | 5132265 | 20240916001321_0n1p8 | UK00A0 | 2024-09-19T12:16:02.199Z | 2024-09-19T12:16:02.199Z |
5132247 | 5132247 | 20240916001010_S7lSY | UK00A0 | 2024-09-19T12:16:00.393Z | 2024-09-19T12:16:00.393Z |
5132137 | 5132137 | 20240915233555_odEOz | UK00A0 | 2024-09-19T12:15:52.458Z | 2024-09-19T12:15:52.458Z |
5132118 | 5132118 | 20240915232657_yRbn8 | UK00A0 | 2024-09-19T12:15:51.044Z | 2024-09-19T12:15:51.044Z |
5132098 | 5132098 | 20240915231621_OvCW9 | UK00A0 | 2024-09-19T12:15:49.968Z | 2024-09-19T12:15:49.968Z |
5132060 | 5132060 | 20240915225807_0pz6L | UK00A0 | 2024-09-19T12:15:47.035Z | 2024-09-19T12:15:47.035Z |
5131870 | 5131870 | 20240915215918_6YvZK | UK00A0 | 2024-09-19T12:15:32.083Z | 2024-09-19T12:15:32.083Z |
5128806 | 5128806 | 20240917024150_rcFBd | UK00A0 | 2024-09-19T12:11:02.693Z | 2024-09-19T12:11:02.693Z |
5128236 | 5128236 | 20240917010822_61oNf | UK00A0 | 2024-09-19T12:10:21.192Z | 2024-09-19T12:10:21.192Z |
5128052 | 5128052 | 20240917002958_DCV0a | UK00A0 | 2024-09-19T12:09:56.963Z | 2024-09-19T12:09:56.963Z |
5128029 | 5128029 | 20240917002306_3urdo | UK00A0 | 2024-09-19T12:09:54.890Z | 2024-09-19T12:09:54.890Z |
5127890 | 5127890 | 20240917000013_TaN8V | UK00A0 | 2024-09-19T12:09:45.565Z | 2024-09-19T12:09:45.565Z |
5127722 | 5127722 | 20240916231020_Lo0L5 | UK00A0 | 2024-09-19T12:09:34.297Z | 2024-09-19T12:09:34.297Z |
5127431 | 5127431 | 20240916215157_Wy76T | UK00A0 | 2024-09-19T12:09:07.244Z | 2024-09-19T12:09:07.244Z |
5126931 | 5126931 | 20240916195425_w03N5 | UK00A0 | 2024-09-19T12:07:43.356Z | 2024-09-19T12:07:43.356Z |
5126831 | 5126831 | 20240916194024_Ud8Qt | UK00A0 | 2024-09-19T12:07:24.389Z | 2024-09-19T12:07:24.389Z |
5121876 | 5121876 | 20240914041800_qCUmK | UK00A0 | 2024-09-18T12:11:02.516Z | 2024-09-19T12:20:02.474Z |
5121856 | 5121856 | 20240914041646_ko7IR | UK00A0 | 2024-09-18T12:11:02.272Z | 2024-09-19T12:20:02.434Z |
5121750 | 5121750 | 20240914041331_usi4A | UK00A0 | 2024-09-18T12:11:01.160Z | 2024-09-19T12:20:02.321Z |
5121360 | 5121360 | 20240914035905_QiNcV | UK00A0 | 2024-09-18T12:10:54.685Z | 2024-09-19T12:20:01.699Z |
5121119 | 5121119 | 20240914035228_sJvYo | UK00A0 | 2024-09-18T12:10:51.280Z | 2024-09-19T12:20:01.367Z |
5120846 | 5120846 | 20240914033739_42LWu | UK00A0 | 2024-09-18T12:10:47.628Z | 2024-09-19T12:20:00.927Z |
5120664 | 5120664 | 20240914033102_bvUGA | UK00A0 | 2024-09-18T12:10:44.284Z | 2024-09-19T12:20:00.676Z |
5120647 | 5120647 | 20240914033037_YKJCw | UK00A0 | 2024-09-18T12:10:44.189Z | 2024-09-19T12:20:00.671Z |
5119324 | 5119324 | 20240914022402_Gu8fz | UK00A0 | 2024-09-18T12:10:19.908Z | 2024-09-19T12:19:57.923Z |
5117297 | 5117297 | 20240915041633_GX8vC | UK00A0 | 2024-09-18T12:07:37.210Z | 2024-09-19T12:19:14.148Z |
5116982 | 5116982 | 20240915035311_gFGMP | UK00A0 | 2024-09-18T12:07:27.216Z | 2024-09-19T12:19:12.938Z |
5116900 | 5116900 | 20240915034751_DhpkO | UK00A0 | 2024-09-18T12:07:24.848Z | 2024-09-19T12:19:12.609Z |
5116869 | 5116869 | 20240915034443_G1tt1 | UK00A0 | 2024-09-18T12:07:23.700Z | 2024-09-19T12:19:12.484Z |
5116764 | 5116764 | 20240915034018_8sSmw | UK00A0 | 2024-09-18T12:07:20.178Z | 2024-09-19T12:19:12.313Z |
5116683 | 5116683 | 20240915033621_9Y0Ky | UK00A0 | 2024-09-18T12:07:16.591Z | 2024-09-19T12:19:12.038Z |
5116580 | 5116580 | 20240915033225_MK2tZ | UK00A0 | 2024-09-18T12:07:10.682Z | 2024-09-19T12:19:11.568Z |
5116506 | 5116506 | 20240915033018_VgXWk | UK00A0 | 2024-09-18T12:07:07.881Z | 2024-09-19T12:19:11.410Z |
5116426 | 5116426 | 20240915032539_9leAG | UK00A0 | 2024-09-18T12:07:01.982Z | 2024-09-19T12:19:11.103Z |
5116389 | 5116389 | 20240915032441_0atvh | UK00A0 | 2024-09-18T12:07:00.922Z | 2024-09-19T12:19:11.065Z |
5116191 | 5116191 | 20240915031532_ci99d | UK00A0 | 2024-09-18T12:06:47.178Z | 2024-09-19T12:19:09.604Z |
5116060 | 5116060 | 20240915030621_o3P8e | UK00A0 | 2024-09-18T12:06:35.904Z | 2024-09-19T12:19:08.346Z |
5116044 | 5116044 | 20240915030422_BjdsF | UK00A0 | 2024-09-18T12:06:35.056Z | 2024-09-19T12:19:08.235Z |
5115910 | 5115910 | 20240915025912_eze3N | UK00A0 | 2024-09-18T12:06:31.499Z | 2024-09-19T12:19:07.807Z |
5115744 | 5115744 | 20240915025118_ZVC3C | UK00A0 | 2024-09-18T12:06:22.630Z | 2024-09-19T12:19:06.714Z |
5115456 | 5115456 | 20240915023927_3ohzm | UK00A0 | 2024-09-18T12:06:14.913Z | 2024-09-19T12:19:04.825Z |
5115238 | 5115238 | 20240915022834_oclyd | UK00A0 | 2024-09-18T12:06:07.451Z | 2024-09-19T12:19:03.184Z |
5114820 | 5114820 | 20240915020025_2J9Ay | UK00A0 | 2024-09-18T12:05:35.841Z | 2024-09-19T12:19:00.092Z |
5114387 | 5114387 | 20240915014044_iD3CJ | UK00A0 | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5113553 | 5113553 | 20240915005804_lXwlZ | UK00A0 | 2024-09-18T12:04:29.490Z | 2024-09-19T12:18:50.356Z |
5112592 | 5112592 | 20240914233034_ABu4f | UK00A0 | 2024-09-18T12:03:15.509Z | 2024-09-19T12:18:41.527Z |
5112554 | 5112554 | 20240914232901_rULlG | UK00A0 | 2024-09-18T12:03:13.309Z | 2024-09-19T12:18:41.438Z |
5112475 | 5112475 | 20240914231854_40L2a | UK00A0 | 2024-09-18T12:03:09.635Z | 2024-09-19T12:18:41.112Z |
5111787 | 5111787 | 20240914211700_pLBEl | UK00A0 | 2024-09-18T12:02:17.053Z | 2024-09-19T12:18:34.037Z |
5111669 | 5111669 | 20240914205845_MMRs8 | UK00A0 | 2024-09-18T12:02:09.928Z | 2024-09-19T12:18:32.850Z |
5111455 | 5111455 | 20240914203754_fIoxq | UK00A0 | 2024-09-18T12:01:57.038Z | 2024-09-19T12:18:30.335Z |
5111391 | 5111391 | 20240914203159_KvJ3h | UK00A0 | 2024-09-18T12:01:53.865Z | 2024-09-19T12:18:29.815Z |
5110464 | 5110464 | 20240911015731_IcZFW | UK00A0 | 2024-09-17T12:17:59.582Z | 2024-09-19T12:21:40.394Z |
5110396 | 5110396 | 20240912030013_O0Leh | UK00A0 | 2024-09-17T12:16:43.910Z | 2024-09-19T12:21:14.622Z |
5108121 | 5108121 | 20240913042358_AZAj2 | UK00A0 | 2024-09-17T12:13:30.683Z | 2024-09-19T12:20:47.851Z |
5107525 | 5107525 | 20240913035832_3d1p1 | UK00A0 | 2024-09-17T12:13:16.603Z | 2024-09-19T12:20:47.206Z |
5107459 | 5107459 | 20240913035737_r9og7 | UK00A0 | 2024-09-17T12:13:15.772Z | 2024-09-19T12:20:47.165Z |
5107166 | 5107166 | 20240913034540_HdeRC | UK00A0 | 2024-09-17T12:13:10.141Z | 2024-09-19T12:20:46.870Z |
5106798 | 5106798 | 20240913033513_TN2om | UK00A0 | 2024-09-17T12:13:01.804Z | 2024-09-19T12:20:46.435Z |
5106767 | 5106767 | 20240913033355_jgXwb | UK00A0 | 2024-09-17T12:13:00.753Z | 2024-09-19T12:20:46.382Z |
5106416 | 5106416 | 20240913032412_uY2aI | UK00A0 | 2024-09-17T12:12:53.401Z | 2024-09-19T12:20:46.061Z |
5106359 | 5106359 | 20240913032043_2RkvF | UK00A0 | 2024-09-17T12:12:50.864Z | 2024-09-19T12:20:45.980Z |
5106279 | 5106279 | 20240913031648_y9XF3 | UK00A0 | 2024-09-17T12:12:47.768Z | 2024-09-19T12:20:45.738Z |
5106247 | 5106247 | 20240913031554_OvOOU | UK00A0 | 2024-09-17T12:12:45.346Z | 2024-09-19T12:20:45.682Z |
5105808 | 5105808 | 20240913025849_ag2Ct | UK00A0 | 2024-09-17T12:12:29.270Z | 2024-09-19T12:20:44.929Z |
5105748 | 5105748 | 20240913025619_qM1bX | UK00A0 | 2024-09-17T12:12:28.313Z | 2024-09-19T12:20:44.866Z |
5104762 | 5104762 | 20240913022027_C2wow | UK00A0 | 2024-09-17T12:11:43.989Z | 2024-09-19T12:20:42.843Z |
5104165 | 5104165 | 20240913015623_h2FmE | UK00A0 | 2024-09-17T12:11:27.848Z | 2024-09-19T12:20:41.163Z |
5103538 | 5103538 | 20240913013210_cUxrY | UK00A0 | 2024-09-17T12:11:01.661Z | 2024-09-19T12:20:40.268Z |
5103486 | 5103486 | 20240913013131_UGhv3 | UK00A0 | 2024-09-17T12:10:59.809Z | 2024-09-19T12:20:40.214Z |
5103082 | 5103082 | 20240914020025_Rfh6Z | UK00A0 | 2024-09-17T12:07:51.019Z | 2024-09-19T12:19:56.516Z |
5103066 | 5103066 | 20240914020001_PczKj | UK00A0 | 2024-09-17T12:07:49.795Z | 2024-09-19T12:19:56.479Z |
5102987 | 5102987 | 20240914015558_UuU9v | UK00A0 | 2024-09-17T12:07:45.942Z | 2024-09-19T12:19:56.229Z |
5102586 | 5102586 | 20240914013208_a6I9u | UK00A0 | 2024-09-17T12:07:26.102Z | 2024-09-19T12:19:55.150Z |
5101639 | 5101639 | 20240914004007_6X8wy | UK00A0 | 2024-09-17T12:06:05.936Z | 2024-09-19T12:19:51.166Z |
5101445 | 5101445 | 20240914002627_O3LJg | UK00A0 | 2024-09-17T12:05:48.329Z | 2024-09-19T12:19:50.565Z |
5101308 | 5101308 | 20240914001906_13ORz | UK00A0 | 2024-09-17T12:05:34.189Z | 2024-09-19T12:19:50.230Z |
5101227 | 5101227 | 20240914001437_p09kM | UK00A0 | 2024-09-17T12:05:28.236Z | 2024-09-19T12:19:50.078Z |
5100843 | 5100843 | 20240913234638_kQP3K | UK00A0 | 2024-09-17T12:04:59.054Z | 2024-09-19T12:19:48.800Z |
5100817 | 5100817 | 20240913234633_aIf8p | UK00A0 | 2024-09-17T12:04:57.585Z | 2024-09-19T12:19:48.789Z |
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);