names

40 rows where place_id = 598719

✎ 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
3633755 1905370 1905370 defendant Hogard Andrew esq 598719 598719 Hogard, Andrew, of Emneth, Norf, esq 0
3639799 1907258 1907258 defendant Hopkynson Robert husbandman 598719 598719 Hopkynson, Robert, of Emneth, Norf, husbandman 0
3639801 1907259 1907259 defendant Hopkynson Robert husbandman 598719 598719 Hopkynson, Robert, of Emneth, Norf, husbandman 0
3663509 1914514 1914514 defendant Ogerd Andrew esq 598719 598719 Ogerd, Andrew, of Emneth, Norf, esq 0
3663514 1914515 1914515 defendant Ogard Andrew esq 598719 598719 Ogard, Andrew, of Emneth, Norf, esq 0
3717410 1931727 1931727 defendant Hopkynson Robert yeoman 598719 598719 Hopkynson, Robert, of Emneth, Norf, yeoman 0
3778782 1951080 1951080 defendant Ogard Philippa widow 598719 598719 Ogard, Philippa, of Emneth, Norf, widow 1
3949521 2006904 2006904 defendant Palmer Richard husbandman 598719 598719 Palmer, Richard, of Emneth, Norf, husbandman 0
4062252 2046790 2046790 defendant Hall William gent 598719 598719 Hall, William, of Emneth, Norf, gent 0
4069071 2049228 2049228 defendant Bulward Thomas yeoman 598719 598719 Bulward, Thomas, of Emneth, Norf, yeoman 0
4083772 2054470 2054470 defendant Wardall Edward husbandman 598719 598719 Wardall, Edward, of Emneth, Norf, husbandman 2
4083780 2054472 2054472 defendant Wardell Edward yeoman 598719 598719 Wardell, Edward, of Emneth, Norf, yeoman 2
4094511 2058374 2058374 defendant Wardell John husbandman 598719 598719 Wardell, John, of Emneth, Norf, husbandman 2
4237960 2108881 2108881 defendant Symson William husbandman 598719 598719 Symson, William, of Emneth, husbandman, Norf, husbandman 0
4294426 2128090 2128090 defendant Baxter William yeoman 598719 598719 Baxter, William, of Emneth, Norf, yeoman 0
4326267 2139152 2139152 defendant Francklyn Edred gent 598719 598719 Francklyn, Edred, of Emneth, Norf, gent 0
4346383 2145992 2145992 defendant Wolmer Nicholas husbandman 598719 598719 Wolmer, Nicholas, of Emneth, Norf, husbandman 0
4354599 2148843 2148843 defendant Arkinstall Thomas gent 598719 598719 Arkinstall, Thomas, of Emneth, Norf, gent 3
4363855 2152130 2152130 defendant Wilson Thomas yeoman 598719 598719 Wilson, Thomas, of Emneth, Norf, yeoman 0
4723333 2272607 2272607 defendant Falyate Robert gent 598719 598719 Falyate, Robert, of Emneth, Norf, gent 0
4779953 2289730 2289730 defendant Smyth Adam husbandman 598719 598719 Smyth, Adam, of Emneth, Norf, husbandman 0
4900733 2326868 2326868 defendant de Merton Thomas   598719 598719 de Merton, Thomas, of Emneth, Norf, franklin 2
5012487 2360499 2360499 defendant Roper Peter husbandman 598719 598719 Roper, Peter, of Emneth, Norf, husbandman 3
5018193 2362209 2362209 defendant Osbyn Thomas yeoman 598719 598719 Osbyn, Thomas, of Emneth, Norf, yeoman 1
5064164 2375822 2375822 defendant Doraunt Richard (legal representative) 598719 598719 Doraunt, Richard, of Emneth, Norf, husbandman, executors of 0
5072928 2378389 2378389 defendant Blewyk Robert yeoman 598719 598719 Blewyk, Robert, of Emneth, Norf, yeoman 1
5090141 2383487 2383487 defendant Masey John husbandman 598719 598719 Masey, John, of Emneth, Norf, husbandman 1
5161591 2404489 2404489 defendant Blewyk Robert yeoman 598719 598719 Blewyk, Robert, of Emneth, Norf, yeoman 1
5187477 2412055 2412055 defendant Dunton Reginald husbandman 598719 598719 Dunton, Reginald, of Emneth, Norf, husbandman 1
5187481 2412055 2412055 defendant Austyn John weaver 598719 598719 Austyn, John, of Emneth, Norf, weaver 5
5187484 2412056 2412056 defendant Roray Margaret widow 598719 598719 Roray, Margaret, of Emneth, Norf, widow 1
5218992 2421283 2421283 defendant Walpole Richard husbandman 598719 598719 Walpole, Richard, of Emneth, Norf, husbandman 6
5253261 2431117 2431117 defendant Baret Thomas husbandman 598719 598719 Baret, Thomas, of Emneth, Norf, husbandman 0
5278858 2438927 2438927 defendant Baret Thomas husbandman 598719 598719 Baret, Thomas, of Emneth, Norf, husbandman 0
5316101 2449889 2449889 defendant Powedyche Richard yeoman 598719 598719 Powedyche, Richard, of Emneth, Norf, yeoman 3
5363231 2464154 2464154 plaintiff Prest John carpenter 598719 598719 Prest, John, of Emneth, Norf, carpenter 1
5363235 2464155 2464155 plaintiff Prest John carpenter 598719 598719 Prest, John, of Emneth, Norf, carpenter 1
5363237 2464155 2464155 defendant Powedyche Richard husbandman 598719 598719 Powedyche, Richard, of Emneth, Norf, husbandman 0
5480832 2499226 2499226 defendant Clerk Robert husbandman 598719 598719 Clerk, Robert, of Emneth, Norf, husbandman 1
5546425 2518954 2518954 defendant Fendyke Nicholas yeoman 598719 598719 Fendyke, Nicholas, of Emneth, Norf, yeoman 1

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