names

42 rows where place_id = 679174

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4034994 2037198 2037198 defendant Gillingham William butcher 679174 679174 Gillingham, William, of West Pulham, butcher 1
4177702 2087678 2087678 defendant Bushoppe William yeoman 679174 679174 Bushoppe, William, of West Pulham, yeoman 0
4177703 2087678 2087678 defendant Heate Henry yeoman 679174 679174 Heate, Henry, of West Pulham, yeoman 1
4177704 2087678 2087678 defendant Wallys William husbandman 679174 679174 Wallys, William, of West Pulham, husbandman 2
4177705 2087678 2087678 defendant Drewes William husbandman 679174 679174 Drewes, William, of West Pulham, husbandman 3
4177706 2087678 2087678 defendant Drewes Elizabeth widow 679174 679174 Drewes, Elizabeth, of West Pulham, widow 4
4177708 2087679 2087679 defendant Drewes William husbandman 679174 679174 Drewes, William, of West Pulham, husbandman 0
4177709 2087679 2087679 defendant Bushoppe William yeoman 679174 679174 together with Bushoppe, William, of West Pulham, yeoman 1
4177710 2087679 2087679 defendant Heate Henry yeoman 679174 679174 Heate, Henry, of West Pulham, yeoman 2
4177711 2087679 2087679 defendant Wallys William husbandman 679174 679174 Wallys, William, of West Pulham, husbandman 3
4177712 2087679 2087679 defendant Drewes Elizabeth widow 679174 679174 Drewes, Elizabeth, of West Pulham, widow 4
4302885 2131131 2131131 defendant Hebdyche Robert yeoman 679174 679174 Hebdyche, Robert, of West Pulham, yeoman 1
4523609 2207709 2207709 defendant Croster Henry   679174 679174 Croster, Henry, of West Pulham 0
4687885 2261775 2261775 defendant Tapper Richard laborer 679174 679174 Tapper, Richard, of West Pulham, laborer 0
4691262 2262788 2262788 defendant Taillour Nicholas tailor 679174 679174 Taillour, Nicholas, of West Pulham, tailor 0
4711422 2268903 2268903 defendant Willes Henry drover 679174 679174 Willes, Henry, of West Pulham, drover 0
4716915 2270623 2270623 defendant Taillour Nicholas tailor 679174 679174 Taillour, Nicholas, of West Pulham, tailor 0
4728507 2274152 2274152 plaintiff Janyn John   679174 679174 Janyn, John, of West Pulham 0
4742430 2278283 2278283 defendant Dunnyng John butcher 679174 679174 Dunnyng, John, of West Pulham, butcher 0
4858329 2313978 2313978 defendant Servant Robert husbandman 679174 679174 Servant, Robert, of West Pulham, husbandman 0
4860307 2314584 2314584 defendant Servaunt Robert husbandman 679174 679174 Servaunt, Robert, of West Pulham, husbandman 0
5038890 2368276 2368276 defendant Pegon John   679174 679174 Pegon, John, of West Pulham, parson 0
5104373 2387703 2387703 defendant Cordewent John   679174 679174 Cordewent, John, of West Pulham, groom 0
5110974 2389603 2389603 defendant Michell John weaver 679174 679174 Michell, John, of West Pulham, weaver 1
5282291 2439880 2439880 plaintiff Davy William   679174 679174 Davy, William, of West Pulham 0
5282293 2439881 2439881 plaintiff Davy William   679174 679174 Davy, William, of West Pulham 0
5294779 2443456 2443456 defendant Cosshe alias Davy William husbandman or woolmonger 679174 679174 Cosshe alias Davy, William, of West Pulham, husbandman or woolmonger 0
5294906 2443502 2443502 defendant Rawele Walter butcher 679174 679174 Rawele, Walter, of West Pulham, butcher 0
5294907 2443502 2443502 defendant Okeford John husbandman 679174 679174 Okeford, John, of West Pulham, husbandman 1
5301519 2445408 2445408 plaintiff Davy William   679174 679174 Davy, William, of West Pulham 10
5368626 2465783 2465783 defendant Bisshop Edward husbandman 679174 679174 Bisshop, Edward, of West Pulham, husbandman 0
5368627 2465784 2465784 plaintiff Davy William   679174 679174 Davy, William, of West Pulham, wool monger 0
5385844 2471022 2471022 defendant Bisshop Edward husbandman 679174 679174 Bisshop, Edward, of West Pulham, husbandman 0
5386628 2471238 2471238 defendant Worle Richard husbandman 679174 679174 Worle, Richard, of West Pulham, husbandman 0
5386703 2471262 2471262 defendant Bysshop Edward husbandman 679174 679174 Bysshop, Edward, of West Pulham, husbandman 0
5386758 2471280 2471280 defendant Bysshop Edward husbandman 679174 679174 Bysshop, Edward, of West Pulham, husbandman 0
5398160 2474543 2474543 defendant Bysshop Edward husbandman 679174 679174 Bysshop, Edward, of West Pulham, husbandman 0
5411157 2478294 2478294 defendant Bisshop Edward husbandman 679174 679174 Bisshop, Edward, of West Pulham, husbandman 0
5487424 2501135 2501135 defendant Wyllys Robert husbandman 679174 679174 Wyllys, Robert, of West Pulham, husbandman 0
5550574 2520191 2520191 defendant Drewes William husbandman 679174 679174 Drewes, William, of West Pulham, husbandman 0
5556221 2521815 2521815 defendant Drewes William husbandman 679174 679174 Drewes, William, of West Pulham, husbandman 0
5635969 2555202 2555202 defendant Taillour Nicholas tailor 679174 679174 Taillour, Nicholas, of West Pulham, tailor 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);