names

188 rows where place_id = 615552

✎ 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
3709443 1929256 1929256 plaintiff Pyne George gent 615552 615552 Pyne, George, of Devon, gent 0
3815457 1962750 1962750 defendant Carowe Thomas gent 615552 615552 Carowe, Thomas, of Devon, gent 1
3825431 1965806 1965806 defendant Alexander Charles clerk 615552 615552 Alexander, Charles, of Devon, clerk 0
3829477 1967105 1967105 defendant Rawylegh George esq 615552 615552 Rawylegh, George, of Devon, esq 0
3909112 1993347 1993347 defendant Seyntclere John gent 615552 615552 Seyntclere, John, of Devon, gent 2
3926240 1999100 1999100 defendant Davy alias Rychard John   615552 615552 Davy alias Rychard, John, of Devon 1
3938150 2003096 2003096 plaintiff Pomerey Thomas   615552 615552 Pomerey, Thomas, of Devon, knight 0
3938152 2003097 2003097 plaintiff Pomerey Thomas   615552 615552 Pomerey, Thomas, of Devon, knight 0
3938160 2003101 2003101 plaintiff Pomery Thomas   615552 615552 Pomery, Thomas, of Devon, knight 0
3945433 2005488 2005488 plaintiff Bowrman Lawrence merchant 615552 615552 Bowrman, Lawrence, of Devon, merchant 0
3972842 2015072 2015072 defendant Horton Robert   615552 615552 Horton, Robert, of Devon 1
4022899 2032916 2032916 plaintiff Bagtor John   615552 615552 Bagtor, John, of Devon 0
4023662 2033172 2033172 plaintiff Baxter John   615552 615552 Baxter, John, of Devon 0
4130328 2071158 2071158 defendant Denys Richard weaver 615552 615552 Denys, Richard, of Devon, weaver 1
4185129 2090303 2090303 defendant Fulford Thomas esq 615552 615552 Fulford, Thomas, of Devon, esq 0
4333086 2141352 2141352 defendant Williams Nicholas glover 615552 615552 Williams, Nicholas, of Devon, glover 3
4363651 2152071 2152071 defendant Beare Roger clerk 615552 615552 Beare, Roger, of parson Morchard Bishop, Devon, clerk 2
4414252 2169366 2169366 defendant Cola John   615552 615552 Cola, John, of Devon 0
4421797 2171697 2171697 defendant atte Brigge William   615552 615552 atte Brigge, William, of Devon 1
4430633 2174336 2174336 defendant Kelle John de   615552 615552 Kelle, John de, of Devon, knight 0
4445185 2183467 2183467 plaintiff Courtenay Edward de   615552 615552 Courtenay, Edward de, of Devon 0
4451753 2185523 2185523 defendant Morgan John   615552 615552 Morgan, John, of Devon, on his own account 0
4451755 2185524 2185524 defendant Morgan John   615552 615552 Morgan, John, of Devon, on his own account 0
4454740 2186490 2186490 plaintiff Marchaunt Robert   615552 615552 Marchaunt, Robert, of Devon 0
4461878 2188780 2188780 defendant Cropp John   615552 615552 Cropp, John, of Devon 7
4461894 2188780 2188780 defendant Payn William   615552 615552 Payn, William, of Devon 23
4470258 2191348 2191348 defendant C--- Walter   615552 615552 C---, Walter, of Devon 0
4473002 2192233 2192233 plaintiff Courtenay Edward   615552 615552 Courtenay, Edward, of Devon, Earl of 0
4473004 2192234 2192234 plaintiff Courtenay Edward   615552 615552 Courtenay, Edward, of Devon, Earl of 0
4473169 2192274 2192274 defendant Pomereay William esq 615552 615552 Pomereay, William, of Devon, esq 0
4477103 2193496 2193496 defendant fitz Waryn Philip   615552 615552 fitz Waryn, Philip, of Devon 0
4478031 2193798 2193798 defendant Leynton John   615552 615552 Leynton, John, of Devon 2
4478114 2193829 2193829 defendant Neweman John   615552 615552 Neweman, John, of Devon 0
4479112 2194124 2194124 defendant Morgan John   615552 615552 Morgan, John, of Devon 0
4480497 2194563 2194563 defendant de la Pomeray Thomas   615552 615552 de la Pomeray, Thomas, of Devon 1
4480498 2194563 2194563 defendant de la Pomeray William   615552 615552 de la Pomeray, William, of Devon 2
4480499 2194563 2194563 defendant Yerd John esq 615552 615552 Yerd, John, of Devon, esq 3
4483683 2195589 2195589 defendant Mulward Robert   615552 615552 Mulward, Robert, of Devon 0
4484865 2195968 2195968 defendant de la Pomeray William   615552 615552 de la Pomeray, William, of Devon 2
4484869 2195969 2195969 defendant de la Pomeray William esq 615552 615552 de la Pomeray, William, of Devon, esq 2
4484887 2195972 2195972 defendant Pomeray Thomas esq 615552 615552 Pomeray, Thomas, of Devon, esq 2
4484888 2195972 2195972 defendant Hamstede William   615552 615552 Hamstede, William, of Devon 3
4484893 2195974 2195974 defendant Pomeray Thomas esq 615552 615552 Pomeray, Thomas, of Devon, esq 0
4484894 2195974 2195974 defendant Hamstede William   615552 615552 Hamstede, William, of Devon 1
4484904 2195976 2195976 defendant Berie John   615552 615552 Berie, John, of Devon 0
4484910 2195977 2195977 defendant Berie John   615552 615552 Berie, John, of Devon 1
4485879 2196290 2196290 defendant Bast William   615552 615552 Bast, William, of Devon 1
4485896 2196295 2196295 defendant Gast William   615552 615552 Gast, William, of Devon 1
4488430 2197101 2197101 defendant Berye John   615552 615552 Berye, John, of Devon 0
4491242 2197951 2197951 defendant Courtenay Hugh   615552 615552 Courtenay, Hugh, of Devon, knight 0
4491249 2197952 2197952 defendant Courtenay Hugh   615552 615552 Courtenay, Hugh, of Devon, knight 0
4498821 2200266 2200266 plaintiff Gerard Ugholinus merchant 615552 615552 Gerard, Ugholinus, of Devon, merchant, on his own account 0
4499672 2200536 2200536 defendant Courtenay Edward   615552 615552 Courtenay, Edward, of Devon 0
4504657 2201999 2201999 defendant Hull John   615552 615552 Hull, John, of Devon 0
4509667 2203503 2203503 defendant Bykelake John   615552 615552 Bykelake, John, of Devon 0
4514025 2204809 2204809 defendant Thorne Thomas   615552 615552 Thorne, Thomas, of Devon, administrators of 0
4516832 2205669 2205669 defendant Pomeray Thomas   615552 615552 Pomeray, Thomas, of Devon 0
4516833 2205669 2205669 defendant Pridyeux Giles   615552 615552 Pridyeux, Giles, of Devon 1
4516862 2205678 2205678 defendant Gosse Richard   615552 615552 Gosse, Richard, of Devon 2
4516867 2205679 2205679 defendant Tremman John   615552 615552 Tremman, John, of Devon 0
4516872 2205679 2205679 defendant Chapman John   615552 615552 Chapman, John, of Devon 5
4517037 2205736 2205736 plaintiff Courtenay Edward   615552 615552 Courtenay, Edward, of Devon 0
4520116 2206625 2206625 defendant Asthorp William (legal representative) 615552 615552 Asthorp, William, of Devon, knight, executors of 0
4523513 2207677 2207677 defendant Storgeon Nicholas   615552 615552 Storgeon, Nicholas, of Devon 0
4523515 2207678 2207678 defendant Storgeon Nicholas   615552 615552 Storgeon, Nicholas, of Devon 0
4525490 2208302 2208302 defendant cole John esq 615552 615552 cole, John, of Devon, esq 2
4525496 2208303 2208303 defendant Cole John esq 615552 615552 Cole, John, of Devon, esq 2
4526509 2208573 2208573 defendant Pyn Edmund   615552 615552 Pyn, Edmund, of Devon 3
4527223 2208795 2208795 defendant Pomerey Thomas esq 615552 615552 Pomerey, Thomas, of Devon, esq 0
4534475 2211054 2211054 defendant Cobham Richard (legal representative) 615552 615552 Cobham, Richard, of Devon, esq, executors of 4
4536176 2211588 2211588 defendant Bery John   615552 615552 Bery, John, of Devon 0
4536674 2211748 2211748 defendant Hert John   615552 615552 Hert, John, of Devon 6
4537969 2212156 2212156 defendant Shepwasshe John   615552 615552 Shepwasshe, John, of Devon 0
4539576 2212635 2212635 defendant Cole John esq 615552 615552 Cole, John, of Devon, esq 0
4539658 2212663 2212663 defendant Pomeray Nicholas   615552 615552 Pomeray, Nicholas, of Devon 2
4541602 2213268 2213268 defendant Goold Roger   615552 615552 Goold, Roger, of Devon 1
4542226 2213458 2213458 defendant Terell Thomas   615552 615552 Terell, Thomas, of Devon 3
4545611 2214549 2214549 defendant Saunford Andrew goldsmith 615552 615552 Saunford, Andrew, of Devon, goldsmith 0
4548666 2215526 2215526 defendant Denewell William   615552 615552 Denewell, William, of Devon 2
4548677 2215528 2215528 defendant Denewell William   615552 615552 Denewell, William, of Devon 3
4552277 2216666 2216666 defendant Pyllond Thomas   615552 615552 Pyllond, Thomas, of Devon 1
4552278 2216666 2216666 defendant Foukes John   615552 615552 Foukes, John, of Devon 2
4558944 2218761 2218761 defendant Alred John   615552 615552 Alred, John, of Devon 0
4558947 2218762 2218762 defendant Alrede John   615552 615552 Alrede, John, of Devon 0
4558950 2218763 2218763 defendant Alrede John   615552 615552 Alrede, John, of Devon 0
4562010 2219684 2219684 defendant Massy John   615552 615552 Massy, John, of Devon 0
4562435 2219812 2219812 defendant St Aubyn Guy   615552 615552 St Aubyn, Guy, of Devon 0
4562531 2219840 2219840 defendant Bisshop Walter   615552 615552 Bisshop, Walter, of Devon 2
4568723 2221800 2221800 defendant Bernevill John   615552 615552 Bernevill, John, of Devon 3
4568724 2221800 2221800 defendant Dawene John   615552 615552 Dawene, John, of Devon 4
4568754 2221810 2221810 defendant Bernevill John   615552 615552 Bernevill, John, of Devon 3
4568755 2221810 2221810 defendant Dawene John   615552 615552 Dawene, John, of Devon 4
4571736 2222742 2222742 defendant Anketill John   615552 615552 Anketill, John, of Devon 0
4576585 2224187 2224187 defendant Courtenay John   615552 615552 Courtenay, John, of Devon 0
4578204 2224677 2224677 defendant Asshe Giles   615552 615552 Asshe, Giles, of Devon 6
4581652 2225709 2225709 defendant Lang Thomas clerk 615552 615552 Lang, Thomas, of Devon, clerk 4
4581660 2225710 2225710 defendant Lang Thomas clerk 615552 615552 Lang, Thomas, of Devon, clerk 4
4582153 2225856 2225856 defendant Courtenay John   615552 615552 Courtenay, John, of Devon, knight 0
4582546 2225984 2225984 defendant Wattekyn Thomas clerk 615552 615552 Wattekyn, Thomas, of Devon, clerk 5
4582548 2225984 2225984 defendant Abyndon Thomas clerk 615552 615552 Abyndon, Thomas, of Devon, clerk 7

Next page

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);