names

35 rows where place_id = 607762

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670706 1916798 1916798 defendant Dreffeld Thomas husbandman 607762 607762 Dreffeld, Thomas, of Clyfton, Beds, husbandman 4
4014309 2029842 2029842 defendant Underwood Lawrence woolman 607762 607762 Underwood, Lawrence, of Clyfton, Beds, woolman 3
4094307 2058301 2058301 defendant Petyte John husbandman 607762 607762 Petyte, John, of Clyfton, Beds, husbandman 0
4175814 2087016 2087016 defendant Lynwood Robert husbandman 607762 607762 Lynwood, Robert, of Clyfton, Beds, husbandman 2
4312619 2134548 2134548 defendant Baker Leonard gent 607762 607762 Baker, Leonard, of Clyfton, Beds, gent 2
4917067 2331845 2331845 defendant Bromeham John husbandman 607762 607762 Bromeham, John, of Clyfton, Beds, husbandman 2
4917072 2331846 2331846 defendant Bromeham John husbandman 607762 607762 Bromeham, John, of Clyfton, Beds, husbandman 2
4918585 2332329 2332329 defendant Boteler Henry yeoman 607762 607762 Boteler, Henry, of Clyfton, Beds, yeoman 0
4941369 2339325 2339325 defendant Halybrede Walter clerk 607762 607762 Halybrede, Walter, of Clyfton, Beds, clerk 0
4941376 2339326 2339326 defendant Halybrede Walter clerk 607762 607762 Halybrede, Walter, of Clyfton, Beds, clerk 0
4968201 2347440 2347440 defendant Bromeham John husbandman 607762 607762 Bromeham, John, of Clyfton, Beds, husbandman 2
5030441 2365775 2365775 defendant Neel John husbandman 607762 607762 Neel, John, of Clyfton, Beds, husbandman 0
5030443 2365776 2365776 defendant Neel John husbandman 607762 607762 Neel, John, of Clyfton, Beds, husbandman 0
5083667 2381616 2381616 defendant atte Wode William husbandman 607762 607762 atte Wode,William, of Clyfton,Beds, husbandman 7
5106372 2388303 2388303 defendant Wode William chapman 607762 607762 Wode, William, of Clyfton, Beds, chapman 0
5107304 2388564 2388564 defendant Wode William yeoman 607762 607762 Wode, William, of Clyfton, Beds, yeoman 0
5107306 2388565 2388565 defendant Wode William yeoman 607762 607762 Wode, William, of Clyfton, Beds, yeoman 0
5115904 2391080 2391080 defendant Staunford William husbandman 607762 607762 Staunford, William, of Clyfton, Beds, husbandman 4
5115922 2391085 2391085 defendant Staunford William husbandman 607762 607762 Staunford, William, of Clyfton, Beds, husbandman 3
5123232 2393231 2393231 defendant Wode William husbandman 607762 607762 Wode, William, of Clyfton, Beds, husbandman 1
5123235 2393232 2393232 defendant Wode William husbandman 607762 607762 Wode, William, of Clyfton, Beds, husbandman 1
5123237 2393233 2393233 defendant Wode William husbandman 607762 607762 Wode, William, of Clyfton, Beds, husbandman 0
5125238 2393859 2393859 defendant Wode Richard husbandman 607762 607762 Wode, Richard, of Clyfton, Beds, husbandman 0
5143833 2399332 2399332 defendant Wode Richard husbandman 607762 607762 Wode, Richard, of Clyfton, Beds, husbandman 0
5143837 2399333 2399333 defendant Wode Richard husbandman 607762 607762 Wode, Richard, of Clyfton, Beds, husbandman 0
5183211 2410830 2410830 defendant Stamford William gent 607762 607762 Stamford, William, of Clyfton, Beds, gent 1
5183214 2410831 2410831 defendant Stanford William gent 607762 607762 Stanford, William, of Clyfton, Beds, gent 1
5183217 2410832 2410832 defendant Stanford William gent 607762 607762 Stanford, William, of Clyfton, Beds, gent 1
5203778 2416855 2416855 defendant Stanford William gent 607762 607762 Stanford, William, of Clyfton, Beds, gent 1
5203783 2416857 2416857 defendant Stanford William gent 607762 607762 Stanford, William, of Clyfton, Beds, gent 1
5245603 2428872 2428872 defendant Boteler John husbandman 607762 607762 Boteler, John, of Clyfton, Beds, husbandman 2
5297741 2444346 2444346 defendant Mountagu John husbandman 607762 607762 Mountagu, John, of Clyfton, Beds, husbandman 1
5385061 2470803 2470803 defendant Streven Nicholas husbandman 607762 607762 Streven, Nicholas, of Clyfton, Beds, husbandman 0
5485218 2500497 2500497 defendant formerly Bareman Rose widow 607762 607762 formerly Bareman, Rose, of Clyfton, Beds, widow 1
5539583 2516859 2516859 defendant A Wode William husbandman 607762 607762 A Wode,William, of Clyfton, Beds, husbandman 2

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);