names

26 rows where place_id = 760098

✎ 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
3641001 1907626 1907626 defendant Barlee John gent 760098 760098 Barlee, John, of Haveryng atte Bower, Essex, gent 1
3740735 1938968 1938968 defendant Baker Edward husbandman 760098 760098 Baker, Edward, of Haveryng atte Bower, Essex, husbandman 0
3740740 1938969 1938969 defendant Baker Edward husbandman 760098 760098 Baker, Edward, of Haveryng atte Bower, Essex, husbandman 0
3743923 1939985 1939985 defendant Glyn John gent 760098 760098 Glyn, John, of Haveryng att Bower, Essex, gent 1
3747840 1941247 1941247 defendant Halys Marcell gent 760098 760098 Halys, Marcell, of Haveryng at Bower, Essex, gent 3
3779936 1951452 1951452 defendant Halys Marcel gent 760098 760098 Halys, Marcel, of Haveryng at Bower, Essex, gent 3
3796864 1956898 1956898 defendant Halys Marcel gent 760098 760098 Halys, Marcel, of Haveryng at Bower, Essex, gent 3
3825904 1965950 1965950 defendant Bulle William yeoman 760098 760098 Bulle, William, of Haveryng at Bower, Essex, yeoman 1
3933309 2001436 2001436 defendant Ballard John   760098 760098 Ballard, John, of Haveryng atte Bower, Essex, yeoman, & at present, groom of the buttery, unto my Lady Elizabeth's Grace 3
4467037 2190361 2190361 plaintiff atte Brook Thomas   760098 760098 atte Brook, Thomas, of Haveryng, Essex, on his own account 0
4490173 2197643 2197643 defendant Bartelot Nicholas   760098 760098 Bartelot, Nicholas, of Haveryng, Essex 5
4490200 2197644 2197644 defendant Bartelot Nicholas   760098 760098 Bartelot, Nicholas, of Haveryng, Essex 5
4801396 2296623 2296623 defendant Roly Thomas husbandman 760098 760098 Roly, Thomas, of Haveryng, Essex, husbandman 4
4801414 2296625 2296625 defendant Roly Thomas husbandman 760098 760098 Roly, Thomas, of Haveryng, Essex, husbandman 4
5084511 2381881 2381881 defendant Chaterton Henry esq 760098 760098 Chaterton, Henry, of Haveryng, Essex, esq 0
5125644 2393989 2393989 defendant Neweman Thomas husbandman 760098 760098 (Neweman, Thomas, of Haveryng, Essex, husbandman 2
5128018 2394672 2394672 defendant Wylott Stephen husbandman 760098 760098 Wylott, Stephen, of Haveryng, Essex, husbandman 0
5134138 2396479 2396479 defendant (illegible) Robert yeoman 760098 760098 ----, Robert, of Haveryng, atte Bower, Essex, yeoman 1
5136668 2397247 2397247 defendant Huet James butcher 760098 760098 Huet, James, of Haveryng atte Bower, Essex, butcher 0
5139145 2397942 2397942 defendant Deyncourt Thomas   760098 760098 Deyncourt, Thomas, of Haveryng atte Bower, Essex 1
5144276 2399480 2399480 defendant Neweman Thomas husbandman 760098 760098 (Neweman, Thomas, of Haveryng, Essex, husbandman 2
5164186 2405265 2405265 defendant Vyncent Nicholas husbandman 760098 760098 Vyncent, Nicholas, of Haveryng, Essex, husbandman 0
5166936 2406057 2406057 defendant Brook John tanner 760098 760098 Brook, John, of Haveryng, Essex, tanner 0
5166938 2406058 2406058 defendant Fowlere Richard smith 760098 760098 Fowlere, Richard, of Haveryng, Essex, smith 0
5166940 2406059 2406059 defendant Person Richard husbandman 760098 760098 Person, Richard, of Haveryng, Essex, husbandman 0
5235456 2425948 2425948 defendant Colford Thomas butcher 760098 760098 Colford, Thomas, of Haveryng, Essex, butcher 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);