names

33 rows where place_id = 782815

✎ 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
4496617 2199618 2199618 defendant Gace William (legal representative) 782815 782815 Gace, William, of Neweport, Essex, executors of 1
4517371 2205836 2205836 defendant Grace William (legal representative) 782815 782815 Grace, William, of Neweport, Essex, executors of 0
4679334 2259150 2259150 defendant Rychemonde William pedder 782815 782815 Rychemonde, William, of Neweport, Essex, pedder 1
4690067 2262443 2262443 defendant Heldere John tailor 782815 782815 Heldere, John, of Neweport, Essex, tailor 4
4749386 2280300 2280300 defendant Elys Henry tailor 782815 782815 Elys, Henry, of Neweport, Essex, tailor 1
4762260 2284178 2284178 defendant Abbot John yeoman 782815 782815 Abbot, John, of Neweport, Essex, yeoman 0
4874226 2318884 2318884 defendant Haukyn William husbandman 782815 782815 Haukyn, William, of Neweport, Essex, husbandman 0
4878273 2320157 2320157 defendant Harlyng John husbandman 782815 782815 Harlyng, John, of Neweport, Essex, husbandman 1
4888857 2323303 2323303 plaintiff Hawekyn William   782815 782815 Hawekyn, William, of Neweport, Essex 1
4897123 2325755 2325755 defendant Harlyng John woolman 782815 782815 Harlyng, John, of Neweport, Essex, woolman 0
4913585 2330746 2330746 defendant Trumper John husbandman 782815 782815 Trumper, John, of Neweport, Essex, husbandman 0
4953268 2342940 2342940 defendant Gebon Thomas husbandman 782815 782815 Gebon, Thomas, of Neweport, Essex, husbandman 0
4953274 2342941 2342941 defendant Gebon Thomas husbandman 782815 782815 Gebon, Thomas, of Neweport, Essex, husbandman 0
4968344 2347496 2347496 defendant Ponde John   782815 782815 Ponde, John, of Neweport, Essex, wheelwright 0
4977078 2350099 2350099 defendant Fraunceys William woolman 782815 782815 Fraunceys, William, of Neweport, Essex, woolman 1
4979614 2350860 2350860 defendant Ponde John husbandman 782815 782815 Ponde, John, of Neweport, Essex, husbandman 0
4979682 2350879 2350879 defendant Ponde John husbandman 782815 782815 Ponde, John, of Neweport, Essex, husbandman 0
4980825 2351194 2351194 defendant Fraunceys John yeoman 782815 782815 Fraunceys, John, of Neweport, Essex, yeoman 4
5002549 2357658 2357658 defendant Harlyng John butcher 782815 782815 Harlyng, John, of Neweport, Essex, butcher 2
5033077 2366558 2366558 defendant Fraunceys John husbandman 782815 782815 Fraunceys, John, of Neweport, Essex, husbandman 0
5033191 2366590 2366590 defendant Fraunceys John husbandman 782815 782815 Fraunceys, John, of Neweport, Essex, husbandman 0
5105621 2388094 2388094 defendant Rokell John baker 782815 782815 Rokell, John, of Neweport, Essex, baker 0
5127487 2394516 2394516 defendant Holt Thomas husbandman 782815 782815 Holt, Thomas, of Neweport, Essex, husbandman 4
5138878 2397873 2397873 defendant Store John yeoman 782815 782815 Store, John, of Neweport, Essex, yeoman 1
5159779 2403961 2403961 defendant Store John yeoman 782815 782815 Store, John, of Neweport, Essex, yeoman 1
5215520 2420262 2420262 defendant mainpernors for Henham John husbandman 782815 782815 mainpernors for Henham, John, of Neweport, Essex, husbandman 4
5265235 2434885 2434885 defendant Holt Thomas husbandman 782815 782815 Holt, Thomas, of Neweport, Essex, husbandman 0
5265239 2434886 2434886 defendant Holt Thomas husbandman 782815 782815 Holt, Thomas, of Neweport, Essex, husbandman 0
5353049 2461039 2461039 defendant Brygman William smith 782815 782815 Brygman, William, of Neweport, Essex, smith 4
5353055 2461040 2461040 defendant Brygman William smith 782815 782815 Brygman, William, of Neweport, Essex, smith 4
5385663 2470970 2470970 defendant Holt Thomas yeoman 782815 782815 Holt, Thomas, of Neweport, Essex, yeoman 0
5394765 2473570 2473570 defendant Holt Thomas yeoman 782815 782815 Holt, Thomas, of Neweport, Essex, yeoman 0
5397834 2474451 2474451 defendant Jer-vyle John   782815 782815 Jer-vyle, John, of Neweport, Essex 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);