names

70 rows where place_id = 588034

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593155 1865488 1865488 plaintiff Harper Roger merchant 588034 588034 Harper, Roger, of Axbrigge, merchant 0
3606334 1869649 1869649 defendant Rousewyll John dyer 588034 588034 Rousewyll, John, of Axbrigge, dyer 0
3624109 1875067 1875067 defendant Courteys Walter yeoman 588034 588034 Courteys, Walter, of Axbrigge, yeoman 0
3624111 1875068 1875068 defendant Courteys Walter yeoman 588034 588034 Courteys, Walter, of Axbrigge, yeoman 0
3630871 1904475 1904475 defendant Witcombe John tucker 588034 588034 Witcombe, John, of Axbrigge, tucker 1
3635952 1906039 1906039 defendant Yver David yeoman 588034 588034 Yver, David, of Axbrigge, yeoman 0
3658737 1912986 1912986 defendant Butler Thomas fuller of cloth 588034 588034 Butler, Thomas, of Axbrigge, fuller of cloth 0
3658740 1912986 1912986 defendant Cromer William tanner 588034 588034 Cromer, William, of Axbrigge, tanner 3
3670390 1916694 1916694 defendant Hyve William fuller 588034 588034 Hyve, William, of Axbrigge, fuller 0
3680479 1919978 1919978 defendant Alen John glover 588034 588034 Alen, John, of Axbrigge, glover 0
3696527 1925141 1925141 defendant Coker Edward yeoman 588034 588034 Coker, Edward, of Axbrigge, yeoman 0
3789159 1954420 1954420 defendant Aleyn John glover 588034 588034 Aleyn, John, of Axbrigge, glover 0
3789160 1954420 1954420 defendant Phelippis Thomas glover 588034 588034 Phelippis, Thomas, of Axbrigge, glover 1
4467185 2190408 2190408 defendant Anglesye Henry   588034 588034 Anglesye, Henry, of Axbrigge 0
4506249 2202457 2202457 defendant Taillour John   588034 588034 Taillour, John, of Axbrigge 0
4769407 2286405 2286405 defendant Barbour John barber 588034 588034 Barbour, John, of Axbrigge, barber 0
4960567 2345129 2345129 defendant Pryse William mercer 588034 588034 Pryse, William, of Axbrigge, mercer 0
4966314 2346858 2346858 defendant Wygmore John dyer 588034 588034 Wygmore, John, of Axbrigge, dyer 0
4968493 2347546 2347546 defendant Wyther John husbandman 588034 588034 Wyther, John, of Axbrigge, husbandman 0
4978645 2350560 2350560 defendant Wygmore John dyer 588034 588034 together with Wygmore, John, of Axbrigge, dyer 4
4985326 2352530 2352530 defendant Bocher John butcher 588034 588034 Bocher, John, of Axbrigge, butcher 0
4987010 2353058 2353058 defendant Harper William fuller 588034 588034 Harper, William, of Axbrigge, fuller 1
4987012 2353058 2353058 defendant Beauchamp Thomas fuller 588034 588034 Beauchamp, Thomas, of Axbrigge, fuller 3
4995710 2355558 2355558 defendant Smyth John husbandman 588034 588034 Smyth, John, of Axbrigge, husbandman 0
5038775 2368241 2368241 defendant Rayman Henry merchant 588034 588034 Rayman, Henry, of Axbrigge, merchant 0
5050921 2371891 2371891 defendant Hayne John fuller 588034 588034 Hayne, John, of Axbrigge, fuller 0
5050922 2371891 2371891 defendant Wethir John fuller 588034 588034 Wethir, John, of Axbrigge, fuller 1
5061056 2374881 2374881 defendant Hayne William tucker 588034 588034 Hayne, William, of Axbrigge, tucker 1
5084683 2381933 2381933 defendant Smok Thomas mercer 588034 588034 Smok, Thomas, of Axbrigge, mercer 2
5084698 2381939 2381939 defendant Hayne John tucker 588034 588034 Hayne, John, of Axbrigge, tucker 0
5105776 2388136 2388136 defendant Spayne John clothier 588034 588034 Spayne, John, of Axbrigge, clothier 3
5105781 2388137 2388137 defendant Spayne John clothier 588034 588034 Spayne, John, of Axbrigge, clothier 3
5178472 2409412 2409412 defendant Aleyn John tanner 588034 588034 Aleyn, John, of Axbrigge, tanner 3
5227149 2423585 2423585 defendant Hayne John tucker 588034 588034 Hayne, John, of Axbrigge, tucker 13
5227178 2423586 2423586 defendant Hayne John tucker 588034 588034 Hayne, John, of Axbrigge, tucker 13
5259771 2433179 2433179 defendant May Edmund fisher 588034 588034 May, Edmund, of Axbrigge, fisher 1
5265158 2434863 2434863 defendant Payn John husbandman 588034 588034 Payn, John, of Axbrigge, husbandman 1
5304152 2446249 2446249 defendant May Thomas fuller 588034 588034 May, Thomas, of Axbrigge, fuller 1
5304153 2446249 2446249 defendant Colman Thomas dyer 588034 588034 Colman, Thomas, of Axbrigge, dyer 2
5356922 2462229 2462229 defendant Barbour John chapman 588034 588034 Barbour, John, of Axbrigge, girdler, or of Banwell, chapman 0
5361765 2463710 2463710 defendant Harper Roger clothier 588034 588034 Harper, Roger, of Axbrigge, clothier 0
5372368 2466953 2466953 defendant Parterigge John (legal representative) 588034 588034 Parterigge, John, of Axbrigge, executrix of 0
5373560 2467329 2467329 defendant Cachemay Thomas fuller of cloth 588034 588034 Cachemay, Thomas, of Axbrigge, fuller of cloth 0
5373564 2467330 2467330 defendant Cachemay Thomas fuller of cloth 588034 588034 Cachemay, Thomas, of Axbrigge, fuller of cloth 0
5392596 2472951 2472951 defendant Courteys Thomas merchant 588034 588034 Courteys, Thomas, of Axbrigge, merchant 1
5395352 2473744 2473744 defendant Happer Roger clothier 588034 588034 Happer, Roger, of Axbrigge, clothier 0
5395353 2473744 2473744 defendant Gyles Thomas mercer 588034 588034 Gyles, Thomas, of Axbrigge, mercer 1
5420408 2481029 2481029 defendant Sprynge Robert tanner 588034 588034 Sprynge, Robert, of Axbrigge, tanner 0
5420409 2481029 2481029 defendant Cachemay Thomas fuller of cloth 588034 588034 Cachemay, Thomas, of Axbrigge, fuller of cloth 1
5420410 2481029 2481029 defendant Cachemay John fuller of cloth 588034 588034 Cachemay, John, of Axbrigge, fuller of cloth 2
5428397 2483418 2483418 defendant Curteys Thomas baker 588034 588034 Curteys, Thomas, of Axbrigge, baker 1
5445761 2488619 2488619 defendant Curteys Thomas baker 588034 588034 Curteys, Thomas, of Axbrigge, baker 1
5452332 2490569 2490569 defendant Harres William   588034 588034 Harres, William, of Axbrigge, court holder or parish clerk 0
5453207 2490839 2490839 defendant Harper Roger fuller 588034 588034 Harper, Roger, of Axbrigge, fuller 0
5453209 2490839 2490839 defendant Schete Thomas baker 588034 588034 Schete, Thomas, of Axbrigge, baker 2
5486467 2500844 2500844 defendant Courteys Thomas merchant 588034 588034 Courteys, Thomas, of Axbrigge, merchant 0
5487388 2501122 2501122 defendant Ewen John husbandman 588034 588034 Ewen, John, of Axbrigge, husbandman 0
5488522 2501453 2501453 plaintiff Whitcom John   588034 588034 Whitcom, John, of Axbrigge 0
5488523 2501453 2501453 defendant Smyth John smith 588034 588034 Smyth, John, of Axbrigge, smith 0
5508989 2507668 2507668 defendant Hyll Henry yeoman 588034 588034 Hyll, Henry, of Axbrigge, yeoman 1
5512653 2508814 2508814 defendant Cacchemay Thomas tucker 588034 588034 Cacchemay, Thomas, of Axbrigge, tucker 0
5515629 2509731 2509731 defendant Mershe John   588034 588034 Mershe, John, of Axbrigge, pedlar 0
5530739 2514131 2514131 defendant Davy John weaver 588034 588034 Davy, John, of Axbrigge, weaver 2
5533883 2515140 2515140 defendant Hylpe Thomas yeoman 588034 588034 Hylpe, Thomas, of Axbrigge, yeoman 1
5533884 2515140 2515140 defendant Wyther Richard yeoman 588034 588034 Wyther, Richard, of Axbrigge, yeoman 2
5537305 2516156 2516156 defendant Broun Richard cordwainer 588034 588034 Broun, Richard, of Axbrigge, cordwainer 0
5545476 2518666 2518666 defendant Coteler Thomas tucker 588034 588034 Coteler, Thomas, of Axbrigge, tucker 0
5545478 2518666 2518666 defendant Broun Richard cordwainer 588034 588034 Broun, Richard, of Axbrigge, cordwainer 2
5557555 2522163 2522163 defendant Doket John merchant 588034 588034 Doket, John, of Axbrigge, merchant 3
5567613 2525101 2525101 defendant Durban Thomas husbandman 588034 588034 Durban, Thomas, of Axbrigge, husbandman 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);