names

32 rows where place_id = 598501

✎ 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
3632792 1905067 1905067 defendant Ousteby Richard yeoman 598501 598501 Ousteby, Richard, of Southcave, yeoman 2
3763127 1946098 1946098 defendant Fostar John husbandman 598501 598501 Fostar, John, of Southcave, husbandman 3
4358357 2150155 2150155 defendant Foddyll John husbandman 598501 598501 Foddyll, John, of Southcave, husbandman 0
4388021 2160622 2160622 defendant Todd Marmaduke gent 598501 598501 Todd, Marmaduke, of Southcave, gent 3
4407187 2166967 2166967 defendant Todd Marmaduke yeoman 598501 598501 Todd, Marmaduke, of Southcave, or of Beverley, yeoman 0
4411317 2168372 2168372 defendant Tebill Thomas yeoman 598501 598501 Tebill, Thomas, of Southcave, yeoman 0
4411319 2168373 2168373 defendant Tebill or tevill Thomas yeoman 598501 598501 Tebill or tevill, Thomas, of Southcave, yeoman 0
4427512 2173443 2173443 plaintiff Santon Richard de   598501 598501 Santon, Richard de, of Southcave, son of Richard 0
4482524 2195236 2195236 defendant Woderose John   598501 598501 Woderose, John, of Southcave 0
4670046 2256333 2256333 defendant del Crosse Richard   598501 598501 del Crosse, Richard, of Southcave, bailiff of Herthill Wapentake 0
4674422 2257612 2257612 defendant Santon del Wald Thomas de esq 598501 598501 Santon del Wald, Thomas de, of Southcave, esq 1
4687954 2261800 2261800 defendant Bradebelt William husbandman 598501 598501 Bradebelt, William, of Southcave, husbandman 0
4723951 2272790 2272790 defendant Santon del Walde Thomas de esq 598501 598501 Santon del Walde, Thomas de, of Southcave, esq 1
4750762 2280706 2280706 defendant Santon Thomas gent 598501 598501 Santon, Thomas, of Southcave, gent 0
4752279 2281130 2281130 defendant Hyll Thomas yeoman 598501 598501 Hyll, Thomas, of Southcave, yeoman 1
4895900 2325383 2325383 defendant Wythornwyk John yeoman 598501 598501 Wythornwyk, John, of Southcave, yeoman 0
4895917 2325387 2325387 defendant Payntour Thomas husbandman 598501 598501 Payntour, Thomas, of Southcave, husbandman 2
4904419 2327996 2327996 defendant Wythornwyk John yeoman 598501 598501 Wythornwyk, John, of Southcave, yeoman 0
4924928 2334226 2334226 defendant Wright William yeoman 598501 598501 Wright, William, of Southcave, yeoman 1
4932068 2336423 2336423 defendant Wythornwyk John husbandman 598501 598501 Wythornwyk, John, of Southcave, husbandman 1
4934659 2337231 2337231 defendant Lounde Alexander esq 598501 598501 Lounde, Alexander, of Southcave, esq 0
4935426 2337476 2337476 defendant Fowele Peter husbandman 598501 598501 Fowele, Peter, of Southcave, husbandman 0
5319261 2450855 2450855 defendant Tenett William yeoman 598501 598501 Tenett, William, of Southcave, yeoman 0
5412140 2478586 2478586 defendant Crosseby John yeoman 598501 598501 Crosseby, John, of Southcave, yeoman 1
5446416 2488825 2488825 plaintiff Grene Robert   598501 598501 Grene, Robert, of Southcave 0
5512021 2508619 2508619 defendant Tenell John husbandman 598501 598501 Tenell, John, of Southcave, husbandman 1
5512025 2508620 2508620 defendant Tenell John husbandman 598501 598501 Tenell, John, of Southcave, husbandman 1
5528142 2513367 2513367 defendant Jakson Richard husbandman 598501 598501 Jakson, Richard, of Southcave, husbandman 0
5528143 2513367 2513367 defendant Smyth Richard husbandman 598501 598501 Smyth, Richard, of Southcave, husbandman 1
5528144 2513367 2513367 defendant Cok John husbandman 598501 598501 Cok, John, of Southcave, husbandman 2
5528145 2513367 2513367 defendant Belyngeham John husbandman 598501 598501 Belyngeham, John, of Southcave, husbandman 3
5596738 2533898 2533898 defendant Graunge Thomas laborer 598501 598501 Graunge, Thomas, of Southcave, laborer 1

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