names

28 rows where place_id = 635694

✎ 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
3827001 1966298 1966298 defendant Barker Thomas fuller 635694 635694 Barker, Thomas, of Manyngtre, fuller 0
3846733 1972534 1972534 defendant Ramston Thomas gent 635694 635694 Ramston, Thomas, of Manyngtre, gent 0
3847543 1972798 1972798 defendant Hodson Richard mariner 635694 635694 Hodson, Richard, of Manyngtre, mariner 0
3862898 1977785 1977785 defendant Garrard William butcher 635694 635694 Garrard, William, of Manyngtre, butcher 0
3866015 1978867 1978867 defendant Ramston Thomas gent 635694 635694 Ramston, Thomas, of Manyngtre, gent 0
3866016 1978867 1978867 defendant Paylmaker William husbandman 635694 635694 Paylmaker, William, of Manyngtre, husbandman 1
3866017 1978867 1978867 defendant Garrard William butcher 635694 635694 Garrard, William, of Manyngtre, butcher 2
3866018 1978867 1978867 defendant Newman John husbandman 635694 635694 Newman, John, of Manyngtre, husbandman 3
3866019 1978867 1978867 defendant Hodson Richard mariner 635694 635694 Hodson, Richard, of Manyngtre, mariner 4
3866020 1978867 1978867 defendant Skotte George shoemaker 635694 635694 Skotte, George, of Manyngtre, shoemaker 5
3880068 1983594 1983594 defendant Ramston Thomas gent 635694 635694 Ramston, Thomas, of Manyngtre, gent 0
3880069 1983594 1983594 defendant Paylemaker William husbandman 635694 635694 Paylemaker, William, of Manyngtre, husbandman 1
3880070 1983594 1983594 defendant Garrard William butcher 635694 635694 Garrard, William, of Manyngtre, butcher 2
3880071 1983594 1983594 defendant Newman John husbandman 635694 635694 Newman, John, of Manyngtre, husbandman 3
3880072 1983594 1983594 defendant Hudson Richard mariner 635694 635694 Hudson, Richard, of Manyngtre, mariner 4
3880073 1983594 1983594 defendant Skutt George shoemaker 635694 635694 Skutt, George, of Manyngtre, shoemaker 5
4013591 2029596 2029596 defendant Lytle Geoffrey weaver 635694 635694 Lytle, Geoffrey, of Manyngtre, weaver 0
4052141 2043183 2043183 defendant Holland John mariner 635694 635694 Holland, John, of Manyngtre, mariner 0
4065244 2047852 2047852 defendant Brooke Robert gent 635694 635694 Brooke, Robert, of Manyngtre, gent 1
4173136 2086059 2086059 defendant Morden Robert   635694 635694 Morden, Robert, of Manyngtre, wheelwright 0
4235236 2107884 2107884 defendant Parker George husbandman 635694 635694 Parker, George, of Manyngtre, or of Ardeley, husbandman 0
4238804 2109193 2109193 defendant Fennyng Thomas yeoman 635694 635694 Fennyng, Thomas, of Manyngtre, yeoman 1
4278177 2122302 2122302 defendant Fenne William grocer 635694 635694 Fenne, William, of Manyngtre, grocer 0
4534170 2210949 2210949 defendant Pollard William   635694 635694 Pollard, William, of Manyngtre 1
4736153 2276443 2276443 defendant Adam Thomas miller 635694 635694 Adam, Thomas, of Manyngtre, miller 1
5354234 2461389 2461389 defendant Broke William yeoman 635694 635694 Broke, William, of Manyngtre, yeoman 1
5380903 2469594 2469594 defendant Brook William   635694 635694 Brook, William, of Manyngtre 0
5473148 2496925 2496925 defendant Edward John yeoman 635694 635694 Edward, John, of Manyngtre, 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);