names

20 rows where place_id = 611864

✎ 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
3690420 1923169 1923169 defendant Norwode Richard yeoman 611864 611864 Norwode, Richard, of St Peter, Isle of Thanet, yeoman 1
3738928 1938381 1938381 plaintiff Norwodde Richard   611864 611864 Norwodde, Richard, of St Peter, Isle of Thanet 0
3789123 1954406 1954406 defendant Calver Thomas yeoman 611864 611864 Calver, Thomas, of St Peter, Isle of Thanet, yeoman 0
4047116 2041415 2041415 plaintiff Spracklyn Leonard merchant 611864 611864 Spracklyn, Leonard, of St Peter, Isle of Thanet, merchant 0
4072527 2050480 2050480 plaintiff Hunt Robert   611864 611864 Hunt, Robert, of St Peter, isle of Thanet 1
4176810 2087358 2087358 defendant Webbe Michael yeoman 611864 611864 Webbe, Michael, of St Peter, Isle of Thanet, yeoman 0
4391896 2161915 2161915 defendant Noble George, senior carpenter 611864 611864 Noble, George, senior, of St Peter, Isle of Thanet, carpenter 0
4411626 2168484 2168484 defendant Emptage Richard yeoman 611864 611864 Emptage, Richard, of St Peter, Isle of Thanet, yeoman 0
4664735 2250449 2250449 defendant Haket William laborer 611864 611864 Haket, William, of St Peter, Isle of Thanet, laborer 0
4944324 2340200 2340200 defendant Seymond John carpenter 611864 611864 Seymond, John, of St Peter, Isle of Thanet, carpenter 0
5264345 2434605 2434605 defendant Norwode Richard husbandman 611864 611864 Norwode, Richard, of St Peter, Isle of Thanet, husbandman 0
5264346 2434605 2434605 defendant Gaston Nicholas husbandman 611864 611864 Gaston, Nicholas, of St Peter, Isle of Thanet, husbandman 1
5264347 2434605 2434605 defendant Underhill Richrd husbandman 611864 611864 Underhill, Richrd, of St Peter, Isle of Thanet, husbandman 2
5264348 2434605 2434605 defendant Goson Richard husbandman 611864 611864 Goson, Richard, of St Peter, Isle of Thanet, husbandman 3
5264349 2434605 2434605 defendant Gaston Edward husbandman 611864 611864 Gaston, Edward, of St Peter, Isle of Thanet, husbandman 4
5264350 2434605 2434605 defendant COlnar Thomas husbandman 611864 611864 COlnar, Thomas, of St Peter, Isle of Thanet, husbandman 5
5330282 2454131 2454131 defendant Forde Robert husbandman 611864 611864 Forde, Robert, of St Peter, Isle of Thanet, husbandman 2
5330287 2454132 2454132 defendant Forde Robert husbandman 611864 611864 Forde, Robert, of St Peter, Isle of Thanet, husbandman 2
5559914 2522855 2522855 defendant Graunte Edmund husbandman 611864 611864 Graunte, Edmund, of St Peter, Isle of Thanet, husbandman 0
5632408 2554169 2554169 defendant Seynclere John husbandman 611864 611864 Seynclere, John, of St Peter, Isle of Thanet, husbandman 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);