names

34 rows where place_id = 628467

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3782484 1952266 1952266 defendant Walwyn George gent 628467 628467 Walwyn, George, of Sowtham, gent 0
3862155 1977526 1977526 defendant Wyrall Robert husbandman 628467 628467 Wyrall, Robert, of Sowtham, husbandman 3
3943073 2004696 2004696 defendant Browne Edward yeoman 628467 628467 Browne, Edward, of Sowtham, yeoman 0
4049927 2042405 2042405 defendant Wyrrall John husbandman 628467 628467 Wyrrall, John, of Sowtham, husbandman 2
4103663 2061588 2061588 defendant Chaterton Humphrey yeoman 628467 628467 Chaterton, Humphrey, of Sowtham, yeoman 0
4115655 2065885 2065885 defendant Walton Nicholas husbandman 628467 628467 Walton, Nicholas, of Sowtham, husbandman 0
4115656 2065885 2065885 defendant Chatwyn Henry husbandman 628467 628467 Chatwyn, Henry, of Sowtham, husbandman 1
4129557 2070874 2070874 defendant Chattell alias Hostiler or Ostler Henry husbandman 628467 628467 Chattell alias Hostiler or Ostler, Henry, of Sowtham, husbandman 3
4140365 2074797 2074797 defendant Tybbatt Roger yeoman 628467 628467 Tybbatt, Roger, of Sowtham, yeoman 0
4152075 2078836 2078836 defendant Kempe Roger shoemaker 628467 628467 Kempe, Roger, of Sowtham, shoemaker 1
4152076 2078836 2078836 defendant Brockett or brockall John tucker 628467 628467 Brockett or brockall, John, of Sowtham, tucker 2
4161544 2082108 2082108 defendant Chatterton Humphrey yeoman 628467 628467 Chatterton, Humphrey, of Sowtham, yeoman 0
4161545 2082108 2082108 defendant Cheny John yeoman 628467 628467 Cheny, John, of Sowtham, yeoman 1
4165587 2083464 2083464 defendant Tibbat Roger yeoman 628467 628467 Tibbat, Roger, of Sowtham, yeoman 0
4169208 2084734 2084734 defendant Chenye John yeoman 628467 628467 Chenye, John, of Sowtham, yeoman 0
4185474 2090428 2090428 defendant Chatwyn Henry husbandman 628467 628467 Chatwyn, Henry, of Sowtham, husbandman 0
4185475 2090428 2090428 defendant Edmund Anthony husbandman 628467 628467 Edmund, Anthony, of Sowtham, husbandman 1
4185653 2090487 2090487 defendant Chatwyn Henry husbandman 628467 628467 Chatwyn, Henry, of Sowtham, husbandman 0
4185655 2090488 2090488 defendant Clarke Robert yeoman 628467 628467 Clarke, Robert, of Sowtham, yeoman 0
4185656 2090488 2090488 defendant Clarke John husbandman 628467 628467 Clarke, John, of Sowtham, husbandman 1
4185657 2090488 2090488 defendant Chatwyn Henry husbandman 628467 628467 Chatwyn, Henry, of Sowtham, husbandman 2
4185658 2090488 2090488 defendant Edmund Anthony husbandman 628467 628467 Edmund, Anthony, of Sowtham, husbandman 3
4185660 2090489 2090489 defendant Edmund Henry husbandman 628467 628467 Edmund, Henry, of Sowtham, husbandman 0
4185663 2090490 2090490 defendant Chatwyn Henry husbandman 628467 628467 Chatwyn, Henry, of Sowtham, husbandman 1
4185664 2090490 2090490 defendant Edmund Henry husbandman 628467 628467 Edmund, Henry, of Sowtham, husbandman 2
4185673 2090493 2090493 defendant Worrall Thomas yeoman 628467 628467 Worrall, Thomas, of Sowtham, yeoman 0
4294034 2127944 2127944 defendant Clarke John, junior husbandman 628467 628467 Clarke, John, junior, of Sowtham, husbandman 0
4295090 2128326 2128326 defendant Spicer Thomas glover 628467 628467 Spicer, Thomas, of Sowtham, glover 0
4320858 2137388 2137388 defendant Clarke Robert yeoman 628467 628467 Clarke, Robert, of Sowtham, yeoman 1
4372152 2155109 2155109 defendant Clarke William (legal representative) 628467 628467 Clarke, William, of Sowtham, husbandman, executors of 1
4400500 2164760 2164760 defendant Aphlett Edward butcher 628467 628467 Aphlett, Edward, of Sowtham, butcher 2
4407956 2167227 2167227 defendant Wheatley William baker 628467 628467 Wheatley, William, of Sowtham, baker 1
5071288 2377909 2377909 defendant Glover John husbandman 628467 628467 Glover, John, of Sowtham, husbandman 0
5071289 2377909 2377909 defendant Chekley Henry husbandman 628467 628467 Chekley, Henry, of Sowtham, husbandman 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);