names

27 rows where place_id = 591269

✎ 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
3603896 1868891 1868891 defendant Hewes Thomas carpenter 591269 591269 Hewes, Thomas, of Ledered, carpenter 0
3615082 1872363 1872363 defendant Smyth Richard husbandman 591269 591269 Smyth, Richard, of Ledered, husbandman 0
3615083 1872363 1872363 defendant A Dene Robert husbandman 591269 591269 A Dene, Robert, of Ledered, husbandman 1
3615085 1872364 1872364 defendant Smythe Richard husbandman 591269 591269 Smythe, Richard, of Ledered, husbandman 0
3615086 1872364 1872364 defendant A Dene Robert husbandman 591269 591269 A Dene, Robert, of Ledered, husbandman 1
4973111 2348892 2348892 defendant Kerver Robert yeoman 591269 591269 Kerver, Robert, of Ledered, yeoman 1
4973112 2348892 2348892 defendant Crowmer John skinner 591269 591269 Crowmer, John, of Ledered, skinner 2
4973113 2348892 2348892 defendant Smyth aloas Gelowe William pulter 591269 591269 Smyth aloas Gelowe, William, of Ledered, pulter 3
5068911 2377201 2377201 defendant Wymmyldon Isabel widow 591269 591269 Wymmyldon, Isabel, of Ledered, widow 4
5071187 2377879 2377879 defendant Bolke John yeoman 591269 591269 Bolke, John, of Ledered, yeoman 1
5118890 2391955 2391955 defendant Slower Thomas laborer 591269 591269 Slower, Thomas, of Ledered, laborer 0
5119642 2392179 2392179 defendant Denby John tanner 591269 591269 Denby, John, of Ledered, tanner 0
5225301 2423071 2423071 defendant Wymeldon Isabel widow 591269 591269 Wymeldon, Isabel, of Ledered, widow 0
5225303 2423071 2423071 defendant Godman Simon tailor 591269 591269 Godman, Simon, of Ledered, tailor 2
5225612 2423163 2423163 defendant Lather Simon carpenter 591269 591269 Lather, Simon, of Ledered, carpenter 0
5260820 2433506 2433506 defendant A Dene Thomas yeoman 591269 591269 A Dene, Thomas, of Ledered, yeoman 0
5260822 2433507 2433507 defendant Groffam or Grossam John yeoman 591269 591269 Groffam or Grossam, John, of Ledered, yeoman 0
5260824 2433508 2433508 defendant Groffam or Grossam John yeoman 591269 591269 Groffam or Grossam, John, of Ledered, yeoman 0
5265424 2434943 2434943 defendant Lanwey Peter laboer 591269 591269 Lanwey, Peter, of Ledered, laboer 4
5334099 2455264 2455264 defendant Manwell John husbandman 591269 591269 Manwell, John, of Ledered, husbandman 0
5334101 2455265 2455265 defendant Wylbildon Richard gent 591269 591269 Wylbildon, Richard, of Ledered, gent 0
5334102 2455265 2455265 defendant A Dene Richard yeoman 591269 591269 A Dene, Richard, of Ledered, yeoman 1
5334103 2455265 2455265 defendant Manwell John husbandman 591269 591269 Manwell, John, of Ledered, husbandman 2
5334105 2455266 2455266 defendant Wymbyldon Ricard gent 591269 591269 Wymbyldon, Ricard, of Ledered, gent 0
5334106 2455266 2455266 defendant A Dene Richard yeoman 591269 591269 A Dene, Richard, of Ledered, yeoman 1
5340624 2457271 2457271 defendant Curteys John clerk 591269 591269 Curteys, John, of Ledered, clerk 1
5451675 2490375 2490375 plaintiff Grosseham John   591269 591269 Grosseham, John, of Ledered 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);