names

36 rows where place_id = 596481

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624954 1875338 1875338 defendant Davy William gent 596481 596481 Davy, William, of Northflete, Kent, gent 0
3631886 1904782 1904782 defendant Womwell John gent 596481 596481 Womwell, John, of Northflete, Kent, gent 0
3827950 1966608 1966608 defendant Posyer William gent 596481 596481 Posyer, William, of Northflete, Kent, gent 0
3831527 1967747 1967747 defendant Swanne Thomas gent 596481 596481 Swanne, Thomas, of Northflete, Kent, gent 0
3831530 1967748 1967748 defendant Swanne Thomas gent 596481 596481 Swanne, Thomas, of Northflete, Kent, gent 0
3839633 1970320 1970320 defendant Swanne Thomas gent 596481 596481 Swanne, Thomas, of Northflete, Kent, gent 0
3911574 1994189 1994189 defendant Thorneton John gent 596481 596481 Thorneton, John, of Northflete, Kent, gent 0
3984387 2019173 2019173 defendant Cobham George   596481 596481 Cobham, George, of Northflete, Kent, esq, son of Lord Cobham 0
3999921 2024741 2024741 defendant Franck William gent 596481 596481 Franck, William, of Northflete, Kent, gent 0
4023488 2033110 2033110 defendant Raynes William gent 596481 596481 Raynes, William, of Northflete, Kent, gent 0
4041014 2039277 2039277 defendant Swanne William gent 596481 596481 Swanne, William, of Northflete, Kent, gent 0
4041016 2039278 2039278 defendant Swanne William gent 596481 596481 Swanne, William, of Northflete, Kent, gent 0
4049896 2042395 2042395 plaintiff Walhed John, senior yeoman 596481 596481 Walhed, John, senior, of Northflete, Kent, yeoman 0
4088159 2056056 2056056 defendant Saxcye Trustram gent 596481 596481 Saxcye, Trustram, of Northflete, Kent, or of Swanscombe, gent 0
4088516 2056192 2056192 defendant Saxcye Tristram gent 596481 596481 Saxcye, Tristram, of Northflete, Kent, gent 0
4106483 2062610 2062610 defendant Smythe Nicholas husbandman 596481 596481 Smythe, Nicholas, of Northflete, Kent, husbandman 0
4175809 2087015 2087015 defendant Byrde Thomas yeoman 596481 596481 Byrde, Thomas, of Northflete, Kent, yeoman 0
4327634 2139563 2139563 defendant Wakelyn John yeoman 596481 596481 Wakelyn, John, of Northflete, Kent, yeoman 1
4651738 2246508 2246508 defendant Scarburgh John gent 596481 596481 Scarburgh, John, of Northflete, Kent, gent 17
4814510 2300646 2300646 defendant Mepeam Richard husbandman 596481 596481 Mepeam, Richard, of Northflete, Kent, husbandman 1
4883538 2321767 2321767 defendant Cosyn William   596481 596481 Cosyn, William, of Northflete, Kent, holy water clerk 0
4884433 2322032 2322032 defendant George Thomas yeoman 596481 596481 George, Thomas, of Northflete, Kent, yeoman 1
4973834 2349130 2349130 defendant Rikhill William esq 596481 596481 Rikhill, William, of Northflete, Kent, esq 0
5027152 2364810 2364810 defendant Tykhyll William esq 596481 596481 Tykhyll, William, of Northflete, Kent, esq 0
5048071 2371046 2371046 defendant Kyng Willliam husbandman 596481 596481 Kyng, Willliam, of Northflete, Kent, husbandman 3
5113003 2390196 2390196 defendant Flooke Thomas husbandman 596481 596481 Flooke, Thomas, of Northflete, Kent, husbandman 2
5119849 2392239 2392239 defendant Hull John husbandman 596481 596481 Hull, John, of Northflete, Kent, husbandman 4
5136096 2397068 2397068 defendant Lymsey John gent 596481 596481 Lymsey, John, of Northflete, Kent, gent 0
5156405 2403026 2403026 defendant Lymsey John gent 596481 596481 Lymsey, John, of Northflete, Kent, gent 0
5266263 2435200 2435200 defendant Gerard William husbandman 596481 596481 Gerard, William, of Northflete, Kent, husbandman 2
5290547 2442236 2442236 defendant London Thomas   596481 596481 London, Thomas, of Northflete, Kent, parish clerk 4
5296713 2444027 2444027 plaintiff Wombewell Thomas   596481 596481 Wombewell, Thomas, of Northflete, Kent 0
5501818 2505495 2505495 defendant Walsshe John gent 596481 596481 Walsshe, John, of Northflete, Kent, gent 0
5529306 2513681 2513681 defendant Wybarne John (legal representative) 596481 596481 Wybarne, John, of Northflete, Kent, gent, executors of 0
5561330 2523293 2523293 defendant Davy William gent 596481 596481 Davy, William, of Northflete, Kent, gent 0
5584458 2530205 2530205 defendant Davy William gent 596481 596481 Davy, William, of Northflete, Kent, gent 0

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);