names

21 rows where place_id = 592309

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607284 1869941 1869941 defendant Aunger John gent 592309 592309 Aunger, John, of Grymmesby, Lincs, gent 0
3668361 1916050 1916050 defendant West Robert draper 592309 592309 West, Robert, of Grymmesby, Lincs, draper 0
3699926 1926208 1926208 defendant Lorde Robert chapman 592309 592309 Lorde, Robert, of Grymmesby, Lincs, chapman 0
3712582 1930250 1930250 defendant Empryngham John yeoman 592309 592309 Empryngham, John, of Grymmesby, Lincs, yeoman 3
3841578 1970950 1970950 defendant Curtes Thomas yeoman 592309 592309 Curtes, Thomas, of Grymmesby, Lincs, yeoman 1
4541984 2213385 2213385 defendant Newesom Thomas   592309 592309 Newesom, Thomas, of Grymmesby, Lincs 0
4727844 2273950 2273950 defendant Litster Adam dyer 592309 592309 Litster, Adam, of Grymmesby, Lincs, dyer 0
4802025 2296818 2296818 defendant Norton William husbandman 592309 592309 Norton, William, of Grymmesby, Lincs, husbandman 2
4827284 2304582 2304582 defendant wykham Robert spicer 592309 592309 wykham, Robert, of Grymmesby, Lincs, spicer 2
4926641 2334751 2334751 defendant Gaunte William shipman 592309 592309 Gaunte, William, of Grymmesby, Lincs, shipman 0
4942425 2339616 2339616 defendant Shelton John chapman 592309 592309 Shelton, John, of Grymmesby, Lincs, chapman 0
5070294 2377608 2377608 defendant Chapman alias Wathe William chapman 592309 592309 Chapman alias Wathe, William, of Grymmesby, Lincs, chapman 0
5076605 2379506 2379506 defendant Chapman William yeoman 592309 592309 Chapman, William, of Grymmesby, Lincs, yeoman 0
5086639 2382484 2382484 defendant Rote Robert mariner 592309 592309 Rote, Robert, of Grymmesby, Lincs, mariner 0
5088976 2383153 2383153 defendant Beke John laborer 592309 592309 Beke, John, of Grymmesby, Lincs, laborer 2
5119147 2392029 2392029 defendant Sayles Robert chapman 592309 592309 Sayles, Robert, of Grymmesby, Lincs, chapman 1
5144270 2399478 2399478 defendant Bayns alias Bawes John barber 592309 592309 Bayns alias Bawes, John, of Grymmesby, Lincs, barber 0
5163878 2405170 2405170 defendant (not given) Robert vicar of Pye 592309 592309 Pye, Robert, of Grymmesby, Lincs, parson, formerly vicar of Tadlowe, Cambs, clerk 0
5227097 2423579 2423579 defendant Neweport John esq 592309 592309 Neweport, John, of Grymmesby, Lincs, esq 1
5232641 2425128 2425128 defendant Couper Thomas cooper 592309 592309 Couper, Thomas, of Grymmesby, Lincs, cooper 0
5636193 2555275 2555275 defendant Whyte William gent 592309 592309 Whyte, William, of Grymmesby, Lincs, gent 2

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