names

33 rows where place_id = 606862

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666791 1915557 1915557 defendant Foxe John husbandman 606862 606862 Foxe, John, of Pentlowe, Essex, husbandman 0
3698575 1925772 1925772 defendant Marowe William gent 606862 606862 Marowe, William, of Pentlowe, Essex, gent 3
3732729 1936467 1936467 defendant Hardy William husbandman 606862 606862 Hardy, William, of Pentlowe, Essex, husbandman 2
3734288 1936962 1936962 defendant Chapleyn Nicholas husbandman 606862 606862 Chapleyn, Nicholas, of Pentlowe, Essex, husbandman 0
3746735 1940894 1940894 defendant Chapleyn Nicholas husbandman 606862 606862 Chapleyn, Nicholas, of Pentlowe, Essex, husbandman 3
3750730 1942151 1942151 defendant Chapleyn Nicholas husbandman 606862 606862 Chapleyn, Nicholas, of Pentlowe, Essex, husbandman 2
3762033 1945770 1945770 defendant Maye John husbandman 606862 606862 Maye, John, of Pentlowe, Essex, husbandman 5
3833902 1968540 1968540 defendant Felton Edward esq 606862 606862 Felton, Edward, of Pentlowe, Essex, esq 0
3923453 1998150 1998150 defendant Hyble John husbandman 606862 606862 Hyble, John, of Pentlowe, Essex, husbandman 0
3945444 2005489 2005489 defendant Felton Edmund gent 606862 606862 Felton, Edmund, of Pentlowe, Essex, gent: Leveriche, Henry, of Stanwicke, Nhants, gent 8
3989015 2020812 2020812 defendant Carter Anthony yeoman 606862 606862 Carter, Anthony, of Pentlowe, Essex, yeoman 0
3989017 2020813 2020813 defendant Carter Anthony yeoman 606862 606862 Carter, Anthony, of Pentlowe, Essex, yeoman 0
3989593 2021024 2021024 defendant Felton John gent 606862 606862 Felton, John, of Pentlowe, Essex, gent 2
4075364 2051492 2051492 defendant Howe William clothier 606862 606862 Howe, William, of Pentlowe, Essex, clothier 0
4218626 2102012 2102012 defendant Crysall John, junior yeoman 606862 606862 Crysall, John, junior, of Pentlowe, Essex, yeoman 0
4237991 2108891 2108891 defendant Crysall William, senior yeoman 606862 606862 Crysall, William, senior, of Pentlowe, Essex, yeoman 0
4243167 2110707 2110707 defendant Jervice Edmund husbandman 606862 606862 Jervice, Edmund, of Pentlowe, Essex, ploughwright, Jervice, Thomas, of Pentlowe, husbandman 1
4244752 2111230 2111230 defendant Crisall John, junior yeoman 606862 606862 Crisall, John, junior, of Pentlowe, Essex, yeoman 0
4246521 2111811 2111811 defendant Crysall John, senior yeoman 606862 606862 Crysall, John, senior, of Pentlowe, Essex, yeoman 0
4254560 2114514 2114514 defendant Abbott Thomas   606862 606862 Abbott, Thomas, of Pentlowe, Essex 0
4290580 2126688 2126688 defendant Dicke or Deeke Francis gent 606862 606862 Dicke or Deeke, Francis, of Pentlowe, Essex, gent 0
4318275 2136500 2136500 defendant Dyke Francis gent 606862 606862 Dyke, Francis, of Pentlowe, Essex, gent 0
4346634 2146076 2146076 defendant Dick Francis gent 606862 606862 Dick, Francis, of Pentlowe, Essex, gent 2
4349521 2147094 2147094 defendant Kerington John clothier 606862 606862 Kerington, John, of Pentlowe, Essex, clothier 2
4350965 2147592 2147592 defendant Keryngton John clothier 606862 606862 Keryngton, John, of Pentlowe, Essex, clothier 0
4401756 2165183 2165183 defendant Kerington John clothier 606862 606862 Kerington, John, of Pentlowe, Essex, clothier 2
4406691 2166805 2166805 defendant Crisall John yeoman 606862 606862 Crisall, John, of Pentlowe, Essex, yeoman 0
4411215 2168337 2168337 defendant Crissall John yeoman 606862 606862 Crissall, John, of Pentlowe, Essex, yeoman 1
4991165 2354245 2354245 defendant Stystede John   606862 606862 Stystede, John, of Pentlowe, Essex, parson 8
4991319 2354286 2354286 defendant Stystede John   606862 606862 Stystede, John, of Pentlowe, Essex, parson 8
5130609 2395441 2395441 defendant Wynde Peter husbandman 606862 606862 Wynde, Peter, of Pentlowe, Essex, husbandman 0
5150035 2401144 2401144 defendant Wynde Peter clerk 606862 606862 Wynde, Peter, of Pentlowe, Essex, clerk 0
5209625 2418554 2418554 defendant Wynde Peter husbandman 606862 606862 Wynde, Peter, of Pentlowe, Essex, husbandman 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);