names

35 rows where place_id = 615683

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3710193 1929503 1929503 defendant Bayly John husbandman 615683 615683 Bayly, John, of Alvechurche, husbandman 1
3797069 1956964 1956964 defendant Emondys John yeoman 615683 615683 Emondys, John, of Alvechurche, yeoman 0
3797070 1956964 1956964 defendant More John carpenter 615683 615683 More, John, of Alvechurche, carpenter 1
3797071 1956964 1956964 defendant More William husbandman 615683 615683 More, William, of Alvechurche, husbandman 2
3797072 1956964 1956964 defendant Nede John husbandman 615683 615683 Nede, John, of Alvechurche, husbandman 3
3797073 1956964 1956964 defendant More Thomas, senior husbandman 615683 615683 More, Thomas, senior, of Alvechurche, husbandman 4
3797074 1956964 1956964 defendant Scolowe John husbandman 615683 615683 Scolowe, John, of Alvechurche, husbandman 5
3801383 1958360 1958360 defendant Emondys John yeoman 615683 615683 Emondys, John, of Alvechurche, yeoman 0
3801384 1958360 1958360 defendant More John carpenter 615683 615683 More, John, of Alvechurche, carpenter 1
3801385 1958360 1958360 defendant More William husbandman 615683 615683 More, William, of Alvechurche, husbandman 2
3801386 1958360 1958360 defendant Nede John husbandman 615683 615683 Nede, John, of Alvechurche, husbandman 3
3801387 1958360 1958360 defendant More Thomas, senior husbandman 615683 615683 More, Thomas, senior, of Alvechurche, husbandman 4
3801388 1958360 1958360 defendant Scolowe John husbandman 615683 615683 Scolowe, John, of Alvechurche, husbandman 5
3801389 1958360 1958360 defendant Scolowe William tailor 615683 615683 Scolowe, William, of Alvechurche, tailor 6
3802728 1958750 1958750 defendant Keteley John husbandman 615683 615683 Keteley, John, of Alvechurche, husbandman 0
3907957 1992952 1992952 defendant Levyott Henry husbandman 615683 615683 Levyott, Henry, of Alvechurche, husbandman 0
3959929 2010570 2010570 defendant Wever Richard yeoman 615683 615683 Wever, Richard, of Alvechurche, yeoman 0
4116843 2066319 2066319 defendant Hyllar Edward husbandman 615683 615683 Hyllar, Edward, of Alvechurche, husbandman 0
4130745 2071306 2071306 defendant Asshewell Richard weaver 615683 615683 Asshewell, Richard, of Alvechurche, weaver 0
4133657 2072370 2072370 defendant Mylward George butcher 615683 615683 Mylward, George, of Alvechurche, butcher 2
4133663 2072373 2072373 defendant Carter Richard tanner 615683 615683 Carter, Richard, of Alvechurche, tanner 0
4140704 2074914 2074914 defendant Ashewell Richard yeoman 615683 615683 Ashewell, Richard, of Alvechurche, yeoman 0
4141470 2075178 2075178 defendant Cotterell Edmund turner 615683 615683 Cotterell, Edmund, of Alvechurche, turner 0
4165585 2083463 2083463 defendant Hillar Edward husbandman 615683 615683 Hillar, Edward, of Alvechurche, husbandman 0
4194504 2093628 2093628 defendant Hawkes Thomas shoemaker 615683 615683 Hawkes, Thomas, of Alvechurche, shoemaker 1
4236599 2108374 2108374 defendant Hodges George yeoman 615683 615683 Hodges, George, of Alvechurche, yeoman 0
4261532 2116820 2116820 defendant Hodges George yeoman 615683 615683 Hodges, George, of Alvechurche, yeoman 0
4383880 2159311 2159311 defendant Tayler Thomas yeoman 615683 615683 Tayler, Thomas, of Alvechurche, yeoman 0
4389675 2161176 2161176 defendant Walker Richard yeoman 615683 615683 Walker, Richard, of Alvechurche, yeoman 1
4392659 2162164 2162164 defendant Carte William yeoman 615683 615683 Carte, William, of Alvechurche, yeoman 0
4392660 2162164 2162164 defendant Brooke John clerk 615683 615683 Brooke, John, of Alvechurche, clerk 1
4392661 2162164 2162164 defendant Baylyffe Thomas yeoman 615683 615683 Baylyffe, Thomas, of Alvechurche, yeoman 2
4396806 2163500 2163500 defendant Hodges George yeoman 615683 615683 Hodges, George, of Alvechurche, yeoman 0
4411381 2168397 2168397 defendant Jeffres Robert yeoman 615683 615683 Jeffres, Robert, of Alvechurche, yeoman 0
4827620 2304689 2304689 defendant Trayell Richard husbandman 615683 615683 Trayell, Richard, of Alvechurche, husbandman 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);