names

38 rows where place_id = 603024

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612545 1871557 1871557 defendant Bourchier John   603024 603024 Bourchier, John, of Astley, knight 0
3612570 1871567 1871567 defendant Bourchier John   603024 603024 Bourchier, John, of Astley, knight 0
3652763 1911184 1911184 defendant Walle John tailor 603024 603024 Walle, John, of Astley, tailor 2
3652767 1911185 1911185 defendant Walle John tailor 603024 603024 Walle, John, of Astley, tailor 2
3656547 1912300 1912300 defendant Combe John husbandman 603024 603024 Combe, John, of Astley, husbandman 3
3656548 1912300 1912300 defendant Maroley Thomas husbandman 603024 603024 Maroley, Thomas, of Astley, husbandman 4
3692434 1923811 1923811 defendant James Hugh yeoman of the crown 603024 603024 James, Hugh, of Astley, yeoman of the crown 0
3713762 1930603 1930603 defendant Baddesley Richard laborer 603024 603024 Baddesley, Richard, of Astley, laborer 0
3713763 1930603 1930603 defendant Townesend William chaplain 603024 603024 Townesend, William, of Astley, chaplain 1
3763391 1946177 1946177 defendant James Hugh yeoman 603024 603024 James, Hugh, of Astley, yeoman 0
3798860 1957558 1957558 defendant Yaryngton John yeoman 603024 603024 Yaryngton, John, of Astley, yeoman 1
3872408 1980995 1980995 defendant Gravenour Henry yeoman 603024 603024 Gravenour, Henry, of Astley, yeoman 0
3872409 1980995 1980995 defendant Elcoke John miller 603024 603024 Elcoke, John, of Astley, miller 1
3901236 1990638 1990638 defendant Colyer Richard husbandman 603024 603024 Colyer, Richard, of Astley, husbandman 0
3914960 1995354 1995354 defendant Colyer Richard husbandman 603024 603024 Colyer, Richard, of Astley, husbandman 0
3934556 2001851 2001851 defendant Baddysley Thomas yeoman 603024 603024 Baddysley, Thomas, of Astley, yeoman 0
3973621 2015345 2015345 plaintiff Gyles John husbandman 603024 603024 Gyles, John, of Astley, husbandman 0
3991778 2021813 2021813 plaintiff Brooke Robert husbandman 603024 603024 Brooke, Robert, of Astley, husbandman 0
4052470 2043304 2043304 defendant Portman alias Polehowse or Pullus John yeoman 603024 603024 Portman alias Polehowse or Pullus, John, of Astley, yeoman 0
4056210 2044606 2044606 defendant Clarke Richard husbandman 603024 603024 Clarke, Richard, of Astley, husbandman 1
4162026 2082275 2082275 defendant Gerye John husbandman 603024 603024 Gerye, John, of Astley, husbandman 0
4162027 2082275 2082275 defendant Athersbury William husbandman 603024 603024 Athersbury, William, of Astley, husbandman 1
4260389 2116442 2116442 defendant Grave Lancelot husbandman 603024 603024 Grave, Lancelot, of Astley, husbandman 0
4313629 2134871 2134871 defendant Grave Thomas husbandman 603024 603024 Grave, Thomas, of Astley, husbandman 0
4344622 2145398 2145398 defendant Grave Thomas husbandman 603024 603024 Grave, Thomas, of Astley, husbandman 0
4962892 2345816 2345816 defendant Salwey Thomas husbandman 603024 603024 Salwey, Thomas, of Astley, husbandman 3
5139570 2398057 2398057 defendant Huet Thomas yeoman 603024 603024 Huet, Thomas, of Astley, yeoman 2
5139571 2398057 2398057 defendant Wodcote Robert husbandman 603024 603024 Wodcote, Robert, of Astley, husbandman 3
5139576 2398058 2398058 defendant Huet Thomas yeoman 603024 603024 Huet, Thomas, of Astley, yeoman 2
5139577 2398058 2398058 defendant Wodcote Robert husbandman 603024 603024 Wodcote, Robert, of Astley, husbandman 3
5224979 2422977 2422977 defendant Wyllyngton Thomas yeoman 603024 603024 Wyllyngton, Thomas, of Astley, yeoman 0
5224980 2422977 2422977 defendant Browe William clerk 603024 603024 Browe, William, of Astley, clerk 1
5224982 2422977 2422977 defendant Pilton Thomas yeoman 603024 603024 Pilton, Thomas, of Astley, yeoman 3
5285262 2440711 2440711 defendant Typper John yeoman 603024 603024 Typper, John, of Astley, yeoman 4
5332687 2454845 2454845 defendant Leylond Robert yeoman 603024 603024 Leylond, Robert, of Astley, yeoman 1
5391030 2472503 2472503 defendant Sal_ Robert husbandman 603024 603024 Sal_, Robert, of Astley, husbandman 0
5403970 2476208 2476208 defendant Salwey Robert husbandman 603024 603024 Salwey, Robert, of Astley, husbandman 0
5588052 2531274 2531274 defendant Oughton William miller 603024 603024 Oughton, William, of Astley, miller 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);