names

25 rows where place_id = 627207

✎ 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
3774797 1949845 1949845 defendant Cowper William husbandman 627207 627207 Cowper, William, of Sharpenho, husbandman 0
4504543 2201978 2201978 defendant Cook Thomas chapman 627207 627207 Cook, Thomas, of Sharpenho, chapman 4
4504617 2201992 2201992 defendant Cook Thomas chapman 627207 627207 Cook, Thomas, of Sharpenho, chapman 4
4663816 2250167 2250167 defendant Taillour Robert tailor 627207 627207 Taillour, Robert, of Sharpenho, tailor 0
4663817 2250167 2250167 defendant Taillour Agnes spinster 627207 627207 Taillour, Agnes, of Sharpenho, spinster 1
4663819 2250168 2250168 defendant Taillour Agnes spinster 627207 627207 Taillour, Agnes, of Sharpenho, spinster 0
4719053 2271307 2271307 defendant Barfot John husbandman 627207 627207 Barfot, John, of Sharpenho, husbandman 0
4808693 2298886 2298886 defendant Wyngate William yeoman 627207 627207 with Wyngate, William, of Sharpenho, yeoman 1
4835004 2306950 2306950 defendant Wyngate William yeoman 627207 627207 together with Wyngate, William, of Sharpenho, yeoman 1
4854165 2312711 2312711 defendant Aldebury Richard husbandman 627207 627207 Aldebury, Richard, of Sharpenho, husbandman 1
4854166 2312711 2312711 defendant atte Chamber William husbandman 627207 627207 atte Chamber, William, of Sharpenho, husbandman 2
4907675 2328968 2328968 defendant Bocher Simon butcher 627207 627207 Bocher, Simon, of Sharpenho, butcher 0
4930685 2336009 2336009 defendant Wyngate William yeoman 627207 627207 Wyngate, William, of Sharpenho, yeoman 0
4958191 2344418 2344418 defendant Huet Thomas husbandman 627207 627207 Huet, Thomas, of Sharpenho, husbandman 0
4958192 2344418 2344418 defendant Taylour Robert husbandman 627207 627207 Taylour, Robert, of Sharpenho, husbandman 1
4958196 2344420 2344420 defendant Hewet Thomas husbandman 627207 627207 Hewet, Thomas, of Sharpenho, husbandman 0
4958197 2344420 2344420 defendant Stoughton Richard husbandman 627207 627207 Stoughton, Richard, of Sharpenho, husbandman 1
4958198 2344420 2344420 defendant Harry William husbandman 627207 627207 Harry, William, of Sharpenho, husbandman 2
4958199 2344420 2344420 defendant Barefot Reginald husbandman 627207 627207 Barefot, Reginald, of Sharpenho, husbandman 3
4958200 2344420 2344420 defendant Syngilday Richard husbandman 627207 627207 Syngilday, Richard, of Sharpenho, husbandman 4
4958201 2344420 2344420 defendant Elyot Nicholas husbandman 627207 627207 Elyot, Nicholas, of Sharpenho, husbandman 5
4981681 2351436 2351436 defendant Wyngate William yeoman 627207 627207 Wyngate, William, of Sharpenho, yeoman 0
4981683 2351436 2351436 defendant Wyngate Richard husbandman 627207 627207 Wyngate, Richard, of Sharpenho, husbandman 2
4988235 2353451 2353451 defendant Wyngate William yeoman 627207 627207 Wyngate, William, of Sharpenho, yeoman 0
5342512 2457857 2457857 defendant Whitlok John husbandman 627207 627207 Whitlok, John, of Sharpenho, 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);