names

36 rows where place_id = 601004

✎ 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
3643507 1908399 1908399 defendant Bysshop William husbandman 601004 601004 Bysshop, William, of Newnham, husbandman 0
3753806 1943132 1943132 defendant Foster Richard yeoman 601004 601004 Foster, Richard, of Newnham, yeoman 1
3791456 1955164 1955164 defendant Parkys Thomas husbandman 601004 601004 Parkys, Thomas, of Newnham, husbandman 2
3791457 1955164 1955164 defendant Carles Robert husbandman 601004 601004 Carles, Robert, of Newnham, husbandman 3
3925920 1998984 1998984 defendant Webbe John yeoman 601004 601004 Webbe, John, of Newnham, yeoman 1
3925921 1998984 1998984 defendant Stayner Walter butcher 601004 601004 Stayner, Walter, of Newnham, butcher 2
3925922 1998984 1998984 defendant Pumpffrey John yeoman 601004 601004 Pumpffrey, John, of Newnham, yeoman 3
3925925 1998985 1998985 defendant Webbe John yeoman 601004 601004 Webbe, John, of Newnham, yeoman 1
3925926 1998985 1998985 defendant Stayner Walter butcher 601004 601004 Stayner, Walter, of Newnham, butcher 2
3925927 1998985 1998985 defendant Pumpffrey John yeoman 601004 601004 Pumpffrey, John, of Newnham, yeoman 3
3997159 2023752 2023752 defendant Handes John husbandman 601004 601004 Handes, John, of Newnham, husbandman 0
4033206 2036529 2036529 plaintiff Goulde Thomas   601004 601004 Goulde, Thomas, of Newnham, wire drawer 0
4143794 2075989 2075989 defendant Brabant Roger husbandman 601004 601004 Brabant, Roger, of Newnham, husbandman 0
4181126 2088874 2088874 defendant Jennyng Hugh butcher 601004 601004 Jennyng, Hugh, of Newnham, butcher 0
4213951 2100401 2100401 defendant Whyte James weaver 601004 601004 Whyte, James, of Newnham, weaver 0
4213952 2100401 2100401 defendant Trigge Thomas yeoman 601004 601004 Trigge, Thomas, of Newnham, yeoman 1
4214452 2100563 2100563 defendant Hodge Richard husbandman 601004 601004 Hodge, Richard, of Newnham, husbandman 0
4214454 2100564 2100564 defendant White James husbandman 601004 601004 White, James, of Newnham, husbandman 0
4223640 2103756 2103756 defendant Trigge Thomas yeoman 601004 601004 Trigge, Thomas, of Newnham, yeoman 1
4232103 2106730 2106730 defendant Hodge Richard husbandman 601004 601004 Hodge, Richard, of Newnham, husbandman 0
4238230 2108980 2108980 defendant Wytt Richard yeoman 601004 601004 Wytt, Richard, of Newnham, yeoman 0
4284146 2124376 2124376 defendant White James husbandman 601004 601004 White, James, of Newnham, husbandman 0
4289825 2126424 2126424 defendant Withers Walter husbandman 601004 601004 Withers, Walter, of Newnham, husbandman 0
4290174 2126554 2126554 defendant Wytte Richard yeoman 601004 601004 Wytte, Richard, of Newnham, yeoman 0
4292664 2127440 2127440 defendant Sparkes John yeoman 601004 601004 Sparkes, John, of Newnham, yeoman 0
4310705 2133888 2133888 defendant Baker John tailor 601004 601004 Baker, John, of Newnham, tailor 2
4358103 2150077 2150077 defendant Glewe Richard   601004 601004 Glewe, Richard, of Newnham, or of Bristol, sailor 0
4359642 2150609 2150609 defendant Baker John tailor 601004 601004 Baker, John, of Newnham, tailor 1
4361754 2151362 2151362 defendant Foreman Peter butcher 601004 601004 Foreman, Peter, of Newnham, butcher 1
4362683 2151712 2151712 defendant Taylor Walter yeoman 601004 601004 Taylor, Walter, of Newnham, yeoman 2
4362684 2151712 2151712 defendant Gold Thomas   601004 601004 Gold, Thomas, of Newnham, sailor 3
4370920 2154655 2154655 defendant Bacheler Jonah weaver 601004 601004 Bacheler, Jonah, of Newnham, weaver 0
4395698 2163147 2163147 defendant White James weaver 601004 601004 White, James, of Newnham, weaver 0
4395699 2163147 2163147 defendant Morse John butcher 601004 601004 Morse, John, of Newnham, butcher 1
4398723 2164153 2164153 defendant Bacheler Jonah weaver 601004 601004 Bacheler, Jonah, of Newnham, weaver 0
5392129 2472833 2472833 defendant Bustar Robert clerk 601004 601004 Bustar, Robert, of Newnham, clerk 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);