names

42 rows where place_id = 596596

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625454 1875499 1875499 defendant Fitter Robert baker 596596 596596 Fitter, Robert, of Kynges Norton, Worcs, baker 0
3632780 1905065 1905065 defendant Middelmore John gent 596596 596596 Middelmore, John, of Kynges Norton, Worcs, gent 0
3650738 1910594 1910594 defendant Reynoldes Thomas husbandman 596596 596596 Reynoldes, Thomas, of Kynges Norton, Worcs, husbandman 3
3659499 1913229 1913229 defendant Middilmore John gent 596596 596596 Middilmore, John, of Kynges Norton, Worcs, gent 0
3662476 1914177 1914177 defendant Sergeant Thomas yeoman 596596 596596 Sergeant, Thomas, of Kynges Norton, Worcs, yeoman 0
3715531 1931145 1931145 defendant Homes Thomas   596596 596596 Homes, Thomas, of Kynges Norton, Worcs, cartwright 2
3737303 1937903 1937903 defendant Chamber Richard   596596 596596 Chamber, Richard, of Kynges Norton, Worcs, wheelwright 0
4160247 2081651 2081651 defendant Milwarde William yeoman 596596 596596 Milwarde, William, of Kynges Norton, Worcs, yeoman 0
4175633 2086948 2086948 defendant Lyne Thomas yeoman 596596 596596 Lyne, Thomas, of Kynges Norton, Worcs, yeoman 1
4311952 2134315 2134315 defendant Gower John gent 596596 596596 Gower, John, of Kynges Norton, Worcs, gent 2
4789036 2292625 2292625 defendant Blakedon William   596596 596596 Blakedon, William, of Kynges Norton, Worcs, husbandnan 1
4793349 2294018 2294018 defendant atte Felde Baldwin yeoman 596596 596596 atte Felde, Baldwin, of Kynges Norton, Worcs, yeoman 0
4812465 2300010 2300010 defendant Blakedon William yeoman 596596 596596 Blakedon, William, of Kynges Norton, Worcs, yeoman 1
4829590 2305297 2305297 defendant Serieaunt John butcher 596596 596596 Serieaunt, John, of Kynges Norton, Worcs, butcher 0
4883695 2321812 2321812 defendant Halle William gent 596596 596596 Halle, William, of Kynges Norton, Worcs, gent 0
4885884 2322454 2322454 defendant Barne William yeoman 596596 596596 Barne, William, of Kynges Norton, Worcs, yeoman 0
4920907 2333052 2333052 defendant Radolf John yeoman 596596 596596 Radolf, John, of Kynges Norton, Worcs, yeoman 0
4932354 2336516 2336516 defendant Benyngton Thomas   596596 596596 Benyngton, Thomas, of Kynges Norton, Worcs, franklin 1
4941399 2339332 2339332 defendant Radeclyffe John yeoman 596596 596596 Radeclyffe, John, of Kynges Norton, Worcs, yeoman 2
4964975 2346440 2346440 defendant Radclyff John yeoman 596596 596596 Radclyff, John, of Kynges Norton, Worcs, yeoman 2
5023628 2363821 2363821 defendant Kyng John husbandman 596596 596596 Kyng, John, of Kynges Norton, Worcs, husbandman 0
5055147 2373114 2373114 defendant Radclyf John yeoman 596596 596596 Radclyf, John, of Kynges Norton, Worcs, yeoman 3
5096878 2385517 2385517 defendant Hawekeslowe John (legal representative) 596596 596596 Hawekeslowe, John, of Kynges Norton, Worcs, executrix of 0
5102486 2387129 2387129 defendant Bromwych Walter yeoman 596596 596596 Bromwych, Walter, of Kynges Norton, Worcs, yeoman 0
5134983 2396731 2396731 defendant Belle William yeoman 596596 596596 Belle, William, of Kynges Norton, Worcs, yeoman 2
5160582 2404188 2404188 defendant Reynold John husbandman 596596 596596 Reynold, John, of Kynges Norton, Worcs, husbandman 0
5359424 2462983 2462983 defendant Greve John husbandman 596596 596596 Greve, John, of Kynges Norton, Worcs, husbandman 0
5408895 2477621 2477621 defendant Avenaunt John   596596 596596 Avenaunt, John, of Kynges Norton, Worcs, husbandman, son & heir of Robert Avenaunte, of Kynges Norton 0
5422233 2481597 2481597 defendant Avenaunt John   596596 596596 Avenaunt, John, of Kynges Norton, Worcs, husbandman, son & heir of Robert 0
5422235 2481598 2481598 defendant Avenaunt John   596596 596596 Avenaunt, John, of Kynges Norton, Worcs, husbandman, son & heir of Robert 0
5441825 2487484 2487484 defendant Avenaunt John   596596 596596 Avenaunt, John, of Kynges Norton, Worcs, husbandman, son & heir of Robert 0
5507815 2507343 2507343 defendant Avenaunt John husbandman 596596 596596 Avenaunt, John, of Kynges Norton, Worcs, husbandman 0
5507819 2507344 2507344 defendant Avenaunt John husbandman 596596 596596 Avenaunt, John, of Kynges Norton, Worcs, husbandman 0
5513258 2508997 2508997 defendant Bent Robert husbandman 596596 596596 Bent, Robert, of Kynges Norton, Worcs, husbandman 1
5533356 2514982 2514982 defendant Benton John draper 596596 596596 Benton, John, of Kynges Norton, Worcs, draper 0
5557119 2522038 2522038 defendant Marche Thomas painter 596596 596596 Marche, Thomas, of Kynges Norton, Worcs, painter 0
5557130 2522042 2522042 defendant Blacton Thomas yeoman 596596 596596 Blacton, Thomas, of Kynges Norton, Worcs, yeoman 0
5557135 2522044 2522044 defendant Roper William laborer 596596 596596 Roper, William, of Kynges Norton, Worcs, laborer 1
5564503 2524230 2524230 defendant Balle William tanner 596596 596596 Balle, William, of Kynges Norton, Worcs, tanner 0
5564576 2524238 2524238 defendant Belle William tanner 596596 596596 Belle, William, of Kynges Norton, Worcs, tanner 3
5564625 2524243 2524243 defendant Belle William tanner 596596 596596 Belle, William, of Kynges Norton, Worcs, tanner 2
5602491 2535672 2535672 defendant Belne or Belve Thomas yeoman 596596 596596 Belne or Belve, Thomas, of Kynges Norton, Worcs, yeoman 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);