names

27 rows where place_id = 607557

✎ 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
3669819 1916505 1916505 defendant Laurence Thomas yeoman 607557 607557 Laurence, Thomas, of Yakesley, Hunts, yeoman 0
4656184 2247820 2247820 defendant Barker John barker 607557 607557 Barker, John, of Yakesley, Hunts, barker 0
4668992 2256006 2256006 defendant Bate John merchant 607557 607557 Bate, John, of Yakesley, Hunts, merchant 0
4691036 2262721 2262721 defendant Spore Nicholas shoemaker 607557 607557 Spore, Nicholas, of Yakesley, Hunts, shoemaker 0
4691436 2262847 2262847 defendant Barbour Richard barber 607557 607557 Barbour, Richard, of Yakesley, Hunts, barber 3
4695803 2264171 2264171 defendant Hoggeson Walter husbandman 607557 607557 Hoggeson, Walter, of Yakesley, Hunts, husbandman 0
4730234 2274659 2274659 defendant Malteman John yeoman 607557 607557 Malteman, John, of Yakesley, Hunts, yeoman 0
4744229 2278838 2278838 defendant Stokes Henry merchant 607557 607557 Stokes, Henry, of Yakesley, Hunts, merchant 3
4744234 2278839 2278839 defendant Stokes Henry merchant 607557 607557 Stokes, Henry, of Yakesley, Hunts, merchant 3
4751185 2280823 2280823 defendant Peel John husbandman 607557 607557 Peel, John, of Yakesley, Hunts, husbandman 0
4751190 2280825 2280825 defendant Peek Robert husbandman 607557 607557 Peek, Robert, of Yakesley, Hunts, husbandman 0
4751814 2281021 2281021 defendant Potton William   607557 607557 Potton, William, of Yakesley, Hunts, vicar 0
4795598 2294773 2294773 defendant Maltman John husbandman 607557 607557 Maltman, John, of Yakesley, Hunts, husbandman 1
4814163 2300533 2300533 defendant Chapman Thomas chapman 607557 607557 Chapman, Thomas, of Yakesley, Hunts, chapman 0
4814231 2300554 2300554 defendant Melton Thomas husbandman 607557 607557 Melton, Thomas, of Yakesley, Hunts, husbandman 2
4867874 2316924 2316924 defendant Curson William chapman 607557 607557 Curson, William, of Yakesley, Hunts, chapman 0
4868461 2317108 2317108 defendant Grene Robert chapman 607557 607557 Grene, Robert, of Yakesley, Hunts, chapman 1
4882641 2321483 2321483 defendant Curson William husbandman 607557 607557 Curson, William, of Yakesley, Hunts, husbandman 1
4888080 2323076 2323076 defendant Melton Thomas chapman 607557 607557 Melton, Thomas, of Yakesley, Hunts, chapman 0
4888858 2323303 2323303 defendant Hukker William merchant 607557 607557 Hukker, William, of Yakesley, Hunts, merchant 0
4889914 2323634 2323634 defendant Grene John chapman 607557 607557 Grene, John, of Yakesley, Hunts, chapman 1
4925644 2334454 2334454 defendant Snowe John husbandman 607557 607557 Snowe, John, of Yakesley, Hunts, husbandman 2
4931591 2336267 2336267 defendant Dukwere Robert husbandman 607557 607557 Dukwere, Robert, of Yakesley, Hunts, husbandman 0
4985392 2352552 2352552 defendant Rynell or Ryvell John chapman 607557 607557 Rynell or Ryvell, John, of Yakesley, Hunts, chapman 2
5036852 2367653 2367653 defendant Wryght Margaret widow 607557 607557 Wryght, Margaret, of Yakesley, Hunts, widow 3
5191070 2413128 2413128 defendant Lilford Robert yeoman 607557 607557 Lilford, Robert, of Yakesley, Hunts, yeoman 0
5500427 2505071 2505071 defendant Grene John yeoman 607557 607557 Grene, John, of Yakesley, Hunts, 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);