names

22 rows where place_id = 593041

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610178 1870847 1870847 defendant Clerk Thomas yeoman 593041 593041 Clerk, Thomas, of Magna Hadham, yeoman 0
3643898 1908522 1908522 defendant Huchyn Thomas husbandman 593041 593041 Huchyn, Thomas, of Magna Hadham, husbandman 2
3699862 1926182 1926182 defendant Whysterd Richard smith 593041 593041 Whysterd, Richard, of Magna Hadham, smith 3
3950914 2007385 2007385 defendant Branche Gilbert husbandman 593041 593041 Branche, Gilbert, of Magna Hadham, husbandman 0
3956148 2009223 2009223 defendant Thorne George carpenter 593041 593041 Thorne, George, of Magna Hadham, carpenter 0
4317282 2136158 2136158 defendant Davies Hugh yeoman 593041 593041 Davies, Hugh, of Magna Hadham, yeoman 0
4664035 2250239 2250239 defendant Westacre William yeoman 593041 593041 Westacre, William, of Magna Hadham, yeoman 0
4664037 2250240 2250240 defendant Westacre William yeoman 593041 593041 Westacre, William, of Magna Hadham, yeoman 0
4788446 2292451 2292451 defendant Tanner John butcher 593041 593041 Tanner, John, of Magna Hadham, butcher 0
4790962 2293266 2293266 defendant Hert John husbandman 593041 593041 Hert, John, of Magna Hadham, husbandman 0
4949592 2341867 2341867 plaintiff Neweman John   593041 593041 Neweman, John, of Magna Hadham 0
5029401 2365473 2365473 plaintiff Okholt Thomas   593041 593041 Okholt, Thomas, of Magna Hadham 0
5029402 2365473 2365473 defendant Denys Robert   593041 593041 Denys, Robert, of Magna Hadham 0
5029405 2365474 2365474 defendant Deynys Robert   593041 593041 Deynys, Robert, of Magna Hadham 0
5113988 2390481 2390481 defendant Hunte John husbandman 593041 593041 Hunte, John, of Magna Hadham, husbandman 0
5363770 2464322 2464322 defendant Wodcok John butcher 593041 593041 Wodcok, John, of Magna Hadham, butcher 0
5480303 2499091 2499091 defendant Marham Robert husbandman 593041 593041 Marham, Robert, of Magna Hadham, husbandman 0
5482593 2499733 2499733 defendant Kerver John clerk 593041 593041 Kerver, John, of Magna Hadham, clerk 10
5484782 2500372 2500372 defendant Sell John husbandman 593041 593041 Sell, John, of Magna Hadham, husbandman 1
5484783 2500372 2500372 defendant Skegge Richard husbandman 593041 593041 Skegge, Richard, of Magna Hadham, husbandman 2
5484784 2500372 2500372 defendant Whystard William husbandman 593041 593041 Whystard, William, of Magna Hadham, husbandman 3
5567213 2524988 2524988 defendant Cade John laborer 593041 593041 Cade, John, of Magna Hadham, laborer 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);