names

28 rows where place_id = 680024

✎ 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
4038587 2038441 2038441 defendant Locke Robert husbandman 680024 680024 Locke, Robert, of Wicklewood, husbandman 0
4059594 2045823 2045823 defendant Flowerdewe Stephen husbandman 680024 680024 Flowerdewe, Stephen, of Wicklewood, husbandman 0
4060184 2046042 2046042 defendant Raynold Thomas yeoman 680024 680024 Raynold, Thomas, of Wicklewood, yeoman 0
4079090 2052823 2052823 plaintiff Tompson John miller 680024 680024 Tompson, John, of Wicklewood, miller 0
4079091 2052823 2052823 defendant Kynder William   680024 680024 Kynder, William, of Wicklewood, husbandman, bachelor 0
4118657 2066965 2066965 defendant Duffeld Richard yeoman 680024 680024 Duffeld, Richard, of Wicklewood, yeoman 0
4148776 2077692 2077692 defendant Mannyng William husbandman 680024 680024 Mannyng, William, of Wicklewood, husbandman 1
4173203 2086085 2086085 defendant Thompson John   680024 680024 Thompson, John, of Wicklewood miller 0
4204390 2097082 2097082 defendant Mallowse Ambrose husbandman 680024 680024 Mallowse, Ambrose, of Wicklewood, husbandman 2
4215901 2101060 2101060 defendant Shone John husbandman 680024 680024 Shone, John, of Wicklewood, husbandman 1
4217952 2101771 2101771 defendant Stone Bartholomew yeoman 680024 680024 Stone, Bartholomew, of Wicklewood, yeoman 0
4243320 2110756 2110756 defendant Moulton Thomas gent 680024 680024 Moulton, Thomas, of Wicklewood, gent 0
4259245 2116068 2116068 defendant Burman William husbandman 680024 680024 Burman, William, of Wicklewood, husbandman 0
4259246 2116068 2116068 defendant Stone John husbandman 680024 680024 Stone, John, of Wicklewood, husbandman 1
4281018 2123262 2123262 defendant Fage William gent 680024 680024 Fage, William, of Wicklewood, gent 1
4284773 2124602 2124602 defendant Multon Thomas esq 680024 680024 Multon, Thomas, of Wicklewood, esq 0
4285838 2124986 2124986 defendant Multon Thomas gent 680024 680024 Multon, Thomas, of Wicklewood, gent 0
4291174 2126910 2126910 defendant Miles Richard yeoman 680024 680024 Miles, Richard, of Wicklewood, yeoman 0
4331794 2140927 2140927 defendant Raven John yeoman 680024 680024 Raven, John, of Wicklewood, yeoman 2
4331972 2140988 2140988 defendant Sparke John husbandman 680024 680024 Sparke, John, of Wicklewood, husbandman 1
4331975 2140989 2140989 defendant Sparke John husbandman 680024 680024 Sparke, John, of Wicklewood, husbandman 1
4334693 2141871 2141871 defendant Jewby Robert miller 680024 680024 Jewby, Robert, of Wicklewood, miller 2
4344546 2145370 2145370 defendant Inbye or Jubye Robert yeoman 680024 680024 Inbye or Jubye, Robert, of Wicklewood, yeoman 0
4379120 2157614 2157614 defendant Multon or Moulton Thomas esq 680024 680024 Multon or Moulton, Thomas, of Wicklewood, esq 1
4397003 2163567 2163567 defendant Purgold Simon yeoman 680024 680024 Purgold, Simon, of Wicklewood, or of Magna Langham, yeoman 0
4400231 2164669 2164669 defendant Stone Bartholomew yeoman 680024 680024 Stone, Bartholomew, of Wicklewood, yeoman 0
4409156 2167664 2167664 defendant Multon Thomas esq 680024 680024 Multon, Thomas, of Wicklewood, esq 1
4410686 2168166 2168166 defendant Mallowes Ambrose yeoman 680024 680024 Mallowes, Ambrose, of Wicklewood, yeoman 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);