names

24 rows where place_id = 595639

✎ 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
3621274 1874194 1874194 defendant Goodman Robert smith 595639 595639 Goodman, Robert, of Fenstanton, smith 0
3621275 1874194 1874194 defendant Stokeley Thomas husbandman 595639 595639 Stokeley, Thomas, of Fenstanton, husbandman 1
3621276 1874194 1874194 defendant Donewiche Thomas husbandman 595639 595639 Donewiche, Thomas, of Fenstanton, husbandman 2
3752502 1942707 1942707 defendant Massy Robert butcher 595639 595639 Massy, Robert, of Fenstanton, butcher 0
3755483 1943667 1943667 defendant Massy Robert butcher 595639 595639 Massy, Robert, of Fenstanton, butcher 3
3755742 1943758 1943758 defendant Pygot John husbandman 595639 595639 Pygot, John, of Fenstanton, husbandman 0
3772026 1948943 1948943 plaintiff Trevett John   595639 595639 Trevett, John, of Fenstanton 0
3773333 1949372 1949372 defendant Massy Robert butcher 595639 595639 Massy, Robert, of Fenstanton, butcher 1
3812405 1961770 1961770 defendant Grantham Henry (legal representative) 595639 595639 Grantham, Henry, of Fenstanton, husbandman, executor of 0
3812406 1961770 1961770 defendant Hanabull William husbandman 595639 595639 Hanabull, William, of Fenstanton, husbandman 1
3822014 1964777 1964777 plaintiff Smyth Richard clerk 595639 595639 Smyth, Richard, of Fenstanton, clerk 0
3822015 1964777 1964777 defendant Treyveyt or Trevett John husbandman 595639 595639 Treyveyt or Trevett, John, of Fenstanton, husbandman 0
3822016 1964778 1964778 plaintiff Smyth Richard clerk 595639 595639 Smyth, Richard, of Fenstanton, clerk 0
3822017 1964778 1964778 defendant Treyveyt or Trevett John husbandman 595639 595639 Treyveyt or Trevett, John, of Fenstanton, husbandman 0
3833829 1968512 1968512 defendant Trevet John husbandman 595639 595639 Trevet, John, of Fenstanton, husbandman 0
3865783 1978785 1978785 defendant Trevette John husbandman 595639 595639 Trevette, John, of Fenstanton, husbandman 0
3888062 1986261 1986261 defendant Tawnesland William tailor 595639 595639 Tawnesland, William, of Fenstanton, tailor 1
3892904 1987873 1987873 defendant Trevett John husbandman 595639 595639 Trevett, John, of Fenstanton, husbandman 0
4293118 2127605 2127605 defendant Cleifeld John laborer 595639 595639 Cleifeld, John, of Fenstanton, laborer 0
4300910 2130426 2130426 defendant Danford Thomas yeoman 595639 595639 Danford, Thomas, of Fenstanton, yeoman 0
4324525 2138593 2138593 defendant Cleifeild John laborer 595639 595639 Cleifeild, John, of Fenstanton, laborer 0
4343247 2144912 2144912 defendant Wray Thomas clerk 595639 595639 Wray, Thomas, of Fenstanton, clerk 0
4778105 2289143 2289143 defendant Aldreth Thomas chapman 595639 595639 Aldreth, Thomas, of Fenstanton, chapman 0
4778106 2289143 2289143 defendant Aldreth William chapman 595639 595639 Aldreth, William, of Fenstanton, chapman 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);