names

22 rows where place_id = 672767

✎ 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
4006924 2027250 2027250 plaintiff Lucke Richard draper 672767 672767 Lucke, Richard, of Sittingborne, draper 0
4024745 2033532 2033532 defendant Whitlocke Richard butcher 672767 672767 Whitlocke, Richard, of Sittingborne, butcher 2
4024746 2033532 2033532 defendant Darby Mark   672767 672767 Darby, Mark, of Sittingborne, cook 3
4043063 2039986 2039986 plaintiff Perse Adam yeoman 672767 672767 Perse, Adam, of Sittingborne, yeoman 0
4061682 2046578 2046578 defendant Bote Simon yeoman 672767 672767 Bote, Simon, of Sittingborne, yeoman 0
4081900 2053829 2053829 defendant Bartelett Thomass joiner 672767 672767 Bartelett, Thomass, of Sittingborne, joiner 1
4083598 2054409 2054409 defendant Barton George butcher 672767 672767 Barton, George, of Sittingborne, butcher 2
4140219 2074746 2074746 defendant Percivall Gabriel gent 672767 672767 Percivall, Gabriel, of Sittingborne, yeoman, or of London, gent 0
4140222 2074746 2074746 defendant White John yeoman 672767 672767 White, John, of Sittingborne, or of Newington, yeoman 3
4237762 2108807 2108807 defendant Allen William beer brewer 672767 672767 Allen, William, of Sittingborne, beer brewer 0
4318242 2136488 2136488 defendant Amyas John gent 672767 672767 Amyas, John, of Sittingborne, gent 0
4319868 2137055 2137055 defendant Musse Edward butcher 672767 672767 Musse, Edward, of Sittingborne, butcher 0
4341195 2144191 2144191 defendant Amyas John gent 672767 672767 Amyas, John, of Sittingborne, gent 0
4361886 2151411 2151411 defendant Musse Samuel butcher 672767 672767 Musse, Samuel, of Sittingborne, butcher 1
4361887 2151411 2151411 defendant Musse Thomas butcher 672767 672767 Musse, Thomas, of Sittingborne, butcher 2
4368754 2153878 2153878 defendant Bishoppe William husbandman 672767 672767 Bishoppe, William, of Sittingborne, husbandman 0
4370519 2154506 2154506 defendant Bromfilde Henry yeoman 672767 672767 Bromfilde, Henry, of Sittingborne, yeoman 0
4370865 2154635 2154635 defendant Bishopp William husbandman 672767 672767 Bishopp, William, of Sittingborne, husbandman 0
4372617 2155279 2155279 defendant Bushoppe William laborer 672767 672767 Bushoppe, William, of Sittingborne, laborer;Coult, Richard, of Miltoln juxta Sittingborn, laborer 1
4373664 2155651 2155651 defendant Hunter Richard tailor 672767 672767 Hunter, Richard, of Sittingborne, tailor 2
4373988 2155768 2155768 defendant Bromfeild Benjamin yeoman 672767 672767 Bromfeild, Benjamin, of Sittingborne, yeoman 0
4401995 2165260 2165260 defendant Hunter Richard tailor 672767 672767 Hunter, Richard, of Sittingborne, tailor 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);