names

42 rows where place_id = 599171

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635589 1905933 1905933 defendant Meycott John yeoman 599171 599171 Meycott, John, of Mynster, Isle of Thanet, yeoman 0
3635591 1905934 1905934 defendant Maycott John yeoman 599171 599171 Maycott, John, of Mynster, Isle of Thanet, yeoman 0
3638154 1906750 1906750 defendant Webbe Robert yeoman 599171 599171 Webbe, Robert, of Mynster, Isle of Thanet, yeoman 1
3649042 1910090 1910090 defendant Maycot John yeoman 599171 599171 Maycot, John, of Mynster, Isle of Thanet, yeoman 0
3690161 1923080 1923080 defendant Swykett John husbandman 599171 599171 Swykett, John, of Mynster, Isle of Thanet, husbandman 0
3700009 1926237 1926237 defendant Baker Henry husbandman 599171 599171 Baker, Henry, of Mynster, Isle of Thanet, husbandman 0
3704609 1927730 1927730 defendant Swyket John husbandman 599171 599171 Swyket, John, of Mynster, Isle of Thanet, husbandman 0
3751463 1942375 1942375 defendant Henhorn John husbandman 599171 599171 Henhorn, John, of Mynster, Isle of Thanet, husbandman 1
3877934 1982864 1982864 defendant Beke Robert yeoman 599171 599171 Beke, Robert, of Mynster, Isle of Thanet, yeoman 0
4027375 2034439 2034439 defendant Bere John yeoman 599171 599171 Bere, John, of Mynster, Isle of Thanet, yeoman 0
4184235 2089983 2089983 defendant Bygge John, senior yeoman 599171 599171 Bygge, John, senior, of Mynster, Isle of Thanet, yeoman 0
4208317 2098456 2098456 defendant Playse John blacksmith 599171 599171 Playse, John, of Mynster, Isle of Thanet, blacksmith 0
4236489 2108336 2108336 defendant Cosyn Robert husbandman 599171 599171 Cosyn, Robert, of Mynster, Isle of Thanet, husbandman 0
4310376 2133784 2133784 defendant Tarrye Nicholas gent 599171 599171 Tarrye, Nicholas, of Mynster, Isle of Thanet, gent 1
4321213 2137513 2137513 defendant Beere John, senior yeoman 599171 599171 Beere, John, senior, of Mynster, Isle of Thanet, yeoman 0
4321214 2137513 2137513 defendant Beere John, junior yeoman 599171 599171 Beere, John, junior, of Mynster, Isle of Thanet, yeoman 1
4368821 2153902 2153902 defendant Russell Simon yeoman 599171 599171 Russell, Simon, of Mynster, Isle of Thanet, yeoman 1
4384931 2159650 2159650 defendant Russell Simon yeoman 599171 599171 Russell, Simon, of Mynster, Isle of Thanet, yeoman 1
5317867 2450431 2450431 defendant Clement Adam thatcher 599171 599171 Clement, Adam, of Mynster, Isle of Thanet, thatcher 1
5330285 2454132 2454132 defendant Atwey William, senior yeoman 599171 599171 Atwey, William, senior, of Mynster, Isle of Thanet, yeoman 0
5347039 2459230 2459230 defendant Cokke Richard husbandman 599171 599171 Cokke, Richard, of Mynster, Isle of Thanet, husbandman 3
5360210 2463235 2463235 defendant Clement Adam husbandman 599171 599171 Clement, Adam, of Mynster, Isle of Thanet, husbandman 1
5484702 2500349 2500349 defendant Harrys John (legal representative) 599171 599171 Harrys, John, of Mynster, Isle of Thanet, executors of 4
5484703 2500349 2500349 defendant Harrys maud widow 599171 599171 (Harrys, maud, of Mynster, Isle of Thanet, widow 5
5484704 2500349 2500349 defendant Harrys John husbandman 599171 599171 Harrys, John, of Mynster, Isle of Thanet, husbandman 6
5487227 2501077 2501077 defendant Harryes John, senior (legal representative) 599171 599171 Harryes, John, senior, of Mynster, Isle of Thanet, executors of 0
5487229 2501077 2501077 defendant Harryes John, junior husbandman 599171 599171 Harryes, John, junior, of Mynster, Isle of Thanet, husbandman 2
5494418 2503234 2503234 defendant Seynycholas Roger esq 599171 599171 Seynycholas, Roger, of Mynster, Isle of Thanet, esq 0
5494419 2503234 2503234 defendant Seynycholas John gent 599171 599171 Seynycholas, John, of Mynster, Isle of Thanet, gent 1
5494425 2503235 2503235 defendant Syntmond Roger husbandman 599171 599171 Syntmond, Roger, of Mynster, Isle of Thanet, husbandman 0
5497622 2504233 2504233 defendant Harry John husbandman 599171 599171 Harry, John, of Mynster, Isle of Thanet, husbandman 0
5499232 2504714 2504714 defendant Harry John husbandman 599171 599171 Harry, John, of Mynster, Isle of Thanet, husbandman 0
5499233 2504714 2504714 defendant Smyth John husbandman 599171 599171 Smyth, John, of Mynster, Isle of Thanet, husbandman 1
5511037 2508288 2508288 defendant Flete Thomas   599171 599171 Flete, Thomas, of Mynster, Isle of Thanet 5
5559971 2522873 2522873 defendant Hyllys Roger husbandman 599171 599171 Hyllys, Roger, of Mynster, Isle of Thanet, husbandman 2
5577262 2527941 2527941 plaintiff Webbe Robert yeoman 599171 599171 Webbe, Robert, of Mynster, Isle of Thanet, yeoman 0
5577264 2527942 2527942 plaintiff Webbe Robert yeoman 599171 599171 Webbe, Robert, of Mynster, Isle of Thanet, yeoman 0
5577267 2527942 2527942 defendant Hyllys Roger yeoman 599171 599171 Hyllys, Roger, of Mynster, Isle of Thanet, yeoman 2
5581238 2529201 2529201 defendant Dreylond Thomas gent 599171 599171 Dreylond, Thomas, of Mynster, Isle of Thanet, gent 0
5583525 2529918 2529918 defendant Meycot John yeoman 599171 599171 Meycot, John, of Mynster, Isle of Thanet, yeoman 0
5594950 2533392 2533392 defendant Meycote John gent 599171 599171 Meycote, John, of Mynster, Isle of Thanet, gent 0
5603607 2536002 2536002 defendant Maycott John yeoman 599171 599171 Maycott, John, of Mynster, Isle of Thanet, yeoman 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);