names

23 rows where place_id = 586080

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587881 1863860 1863860 defendant atte Hoo John husbandman 586080 586080 atte Hoo, John, of Foxherd, Essex, husbandman 1
3590084 1864539 1864539 defendant Turnour Robert carver 586080 586080 Turnour, Robert, of Foxherd, Essex, carver 2
3643093 1908282 1908282 plaintiff Coole William yeoman 586080 586080 Coole, William, of Foxherd, Essex, yeoman 0
3712138 1930114 1930114 defendant Clerke John husbandman 586080 586080 Clerke, John, of Foxherd, Essex, husbandman 0
3718908 1932193 1932193 defendant Loder Richard husbandman 586080 586080 Loder, Richard, of Foxherd, Essex, husbandman 1
3722633 1933338 1933338 defendant Hokett Roger husbandman 586080 586080 Hokett, Roger, of Foxherd, Essex, husbandman 2
3722637 1933339 1933339 defendant Hokett Roger husbandman 586080 586080 Hokett, Roger, of Foxherd, Essex, husbandman 2
3767776 1947558 1947558 defendant Loder Richard yeoman 586080 586080 Loder, Richard, of Foxherd, Essex, yeoman 0
3779086 1951185 1951185 defendant Bures Henry (legal representative) 586080 586080 Bures, Henry, of Foxherd, Essex, esq, executors of 2
3818458 1963672 1963672 defendant Berton John husbandman 586080 586080 Berton, John, of Foxherd, Essex, husbandman 0
3923454 1998150 1998150 defendant Howe William fuller 586080 586080 Howe, William, of Foxherd, Essex, fuller 1
3981432 2018124 2018124 defendant Fyrmen William clothier 586080 586080 Fyrmen, William, of Foxherd, Essex, clothier 0
3982375 2018469 2018469 defendant Hanger Francis yeoman 586080 586080 Hanger, Francis, of Foxherd, Essex, yeoman 0
4003129 2025879 2025879 plaintiff Hollyar John gent 586080 586080 Hollyar, John, of Foxherd, Essex, gent 0
4177876 2087735 2087735 defendant Loder John clerk 586080 586080 Loder, John, of Foxherd, Essex, clerk 2
4683541 2260457 2260457 defendant Underwode John, junior husbandman 586080 586080 Underwode, John, junior, of Foxherd, Essex, husbandman 0
4782391 2290497 2290497 defendant Fryot John butcher 586080 586080 (Fryot, John, of Foxherd, Essex, butcher 1
5350676 2460324 2460324 plaintiff Cordray Thomas clerk 586080 586080 Cordray, Thomas, of Foxherd, Essex, clerk 0
5355462 2461784 2461784 defendant Clerk John husbandman 586080 586080 Clerk, John, of Foxherd, Essex, husbandman 0
5362305 2463869 2463869 defendant Berton John, junior fuller 586080 586080 Berton, John, junior, of Foxherd, Essex, fuller 0
5563539 2523940 2523940 defendant Lowdyr Richard husbandman 586080 586080 Lowdyr, Richard, of Foxherd, Essex, husbandman 0
5578712 2528403 2528403 defendant Loweder Richard husbandman 586080 586080 Loweder, Richard, of Foxherd, Essex, husbandman 3
5598926 2534542 2534542 defendant Heggeman Thomas clothmaker 586080 586080 Heggeman, Thomas, of Foxherd, Essex, clothmaker 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);