names

26 rows where place_id = 585895

✎ 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
3587435 1863715 1863715 defendant Bussell Robert, junior laborer 585895 585895 Bussell, Robert, junior, of Mekesburgh, laborer 0
3587436 1863715 1863715 defendant Sheperd John husbandman 585895 585895 Sheperd, John, of Mekesburgh, husbandman 1
3587438 1863716 1863716 defendant Bussell Robert, junior laborer 585895 585895 Bussell, Robert, junior, of Mekesburgh, laborer 0
3587439 1863716 1863716 defendant Sheperd John nailer 585895 585895 Sheperd, John, of Mekesburgh, husbandman, son of Sheperd, John, nailer 1
3861359 1977267 1977267 defendant Blaksmyth Richard husbandman 585895 585895 Blaksmyth, Richard, of Mekesburgh, husbandman 0
4482169 2195133 2195133 plaintiff Mauger John   585895 585895 Mauger, John, of Mekesburgh, on his own account 0
4531683 2210172 2210172 defendant del Car Richard   585895 585895 del Car, Richard, of Mekesburgh 0
4673622 2257378 2257378 plaintiff Daude Robert   585895 585895 Daude, Robert, of Mekesburgh 0
4768395 2286085 2286085 defendant Bette John husbandman 585895 585895 Bette, John, of Mekesburgh, husbandman 0
4776570 2288666 2288666 defendant Wodesom John husbandman 585895 585895 Wodesom, John, of Mekesburgh, husbandman 0
4776571 2288666 2288666 defendant Wodesom William laborer 585895 585895 Wodesom, William, of Mekesburgh, laborer 1
4776572 2288666 2288666 defendant Wodesom Adam laborer 585895 585895 Wodesom, Adam, of Mekesburgh, laborer 2
4776573 2288666 2288666 defendant Bussell John husbandman 585895 585895 Bussell, John, of Mekesburgh, husbandman 3
4841026 2308728 2308728 defendant Rosemay Thomas husbandman 585895 585895 Rosemay, Thomas, of Mekesburgh, husbandman 2
4852751 2312281 2312281 defendant Whitehede Richard husbandman 585895 585895 Whitehede, Richard, of Mekesburgh, husbandman 4
4860869 2314754 2314754 defendant Mason Thomas chaplain 585895 585895 Mason, Thomas, of Mekesburgh, chaplain 0
4862199 2315192 2315192 defendant Elys John husbandman 585895 585895 Elys, John, of Mekesburgh, husbandman 0
4868230 2317041 2317041 defendant Rosemay Thomas husbandman 585895 585895 Rosemay, Thomas, of Mekesburgh, husbandman 2
4880678 2320867 2320867 defendant Whytehede Richard husbandman 585895 585895 Whytehede, Richard, of Mekesburgh, husbandman 2
4966144 2346806 2346806 defendant Mason Thomas chaplain 585895 585895 Mason, Thomas, of Mekesburgh, chaplain 0
4998564 2356454 2356454 defendant Mason Thomas chaplain 585895 585895 Mason, Thomas, of Mekesburgh, chaplain 0
5031592 2366103 2366103 defendant del Karr John husbandman 585895 585895 del Karr, John, of Mekesburgh, husbandman 0
5634513 2554794 2554794 defendant Ploghwryght Thomas husbandman 585895 585895 Ploghwryght, Thomas, of Mekesburgh, husbandman 1
5634514 2554794 2554794 defendant Whitehede Richard husbandman 585895 585895 Whitehede, Richard, of Mekesburgh, husbandman 2
5634515 2554794 2554794 defendant Besyng Robert husbandman 585895 585895 Besyng, Robert, of Mekesburgh, husbandman 3
5634516 2554794 2554794 defendant Hardclyf Agnes widow of Hugh Hardclyf 585895 585895 Hardclyf, Agnes, of Mekesburgh, widow of Hugh Hardclyf 4

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