names

37 rows where place_id = 596122

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623201 1874780 1874780 defendant Hochyn John husbandman 596122 596122 Hochyn, John, of Sampford, husbandman 2
3711827 1930014 1930014 defendant Cole John husbandman 596122 596122 Cole, John, of Sampford, husbandman 2
3744428 1940159 1940159 defendant Cleydon William laborer 596122 596122 Cleydon, William, of Sampford, laborer 2
3770466 1948443 1948443 defendant Picard Richard   596122 596122 Picard, Richard, of Sampford, mason 0
3894071 1988233 1988233 defendant Wosley William clerk 596122 596122 Wosley, William, of Sampford, clerk 0
3921706 1997602 1997602 plaintiff Powell Edmund esq 596122 596122 Powell, Edmund, of Sampford, esq 0
3998202 2024103 2024103 defendant Jerrard Robert esq 596122 596122 Jerrard, Robert, of Sampford, esq 0
4108554 2063313 2063313 defendant Thressher William yeoman 596122 596122 Thressher, William, of Sampford, yeoman 2
4313121 2134706 2134706 defendant Courtney Amicius gent 596122 596122 Courtney, Amicius, of Sampford, gent 0
4421305 2171561 2171561 defendant Horkeslegh John de   596122 596122 Horkeslegh, John de, of Sampford 1
4432255 2174870 2174870 defendant Horkeslegh John de   596122 596122 Horkeslegh, John de, of Sampford 1
4463988 2189410 2189410 defendant Derman Gilbert   596122 596122 Derman, Gilbert, of Sampford 0
4472406 2192041 2192041 defendant Potter Thomas   596122 596122 Potter, Thomas, of Sampford 2
4543640 2213905 2213905 defendant Lugge Walter   596122 596122 Lugge, Walter, of Sampford 6
4620911 2237522 2237522 defendant Robynet John   596122 596122 Robynet, John, of Sampford 0
4631330 2240689 2240689 defendant Haukewode John   596122 596122 Haukewode, John, of Sampford 0
4639280 2243006 2243006 defendant Mabyel John   596122 596122 Mabyel, John, of Sampford 2
4653154 2246923 2246923 defendant Southe Robert laborer 596122 596122 Southe, Robert, of Sampford, laborer 0
4740655 2277783 2277783 defendant Hervy Katherine   596122 596122 Hervy, Katherine, of Sampford, servant 1
4762409 2284229 2284229 defendant Sampford Richard de gent 596122 596122 Sampford, Richard de, of Sampford, gent 0
4762410 2284229 2284229 defendant Sampford Griffith de gent 596122 596122 Sampford, Griffith de, of Sampford, gent 1
4834033 2306650 2306650 defendant Harres Thomas   596122 596122 Harres, Thomas, of Sampford, wheel wright 2
4961569 2345424 2345424 defendant Stenteford Richard husbandman 596122 596122 Stenteford, Richard, of Sampford, husbandman 8
5021733 2363253 2363253 defendant Walker Richard husbandman 596122 596122 Walker, Richard, of Sampford, husbandman 0
5269747 2436261 2436261 defendant Strepe John yeoman 596122 596122 Strepe, John, of Sampford, yeoman 2
5324959 2452544 2452544 defendant Clopton Thomas gent 596122 596122 Clopton, Thomas, of Sampford, gent 2
5360689 2463376 2463376 defendant Byfeld John carpenter 596122 596122 Byfeld, John, of Sampford, carpenter 2
5360694 2463377 2463377 defendant Byfold John carpenter 596122 596122 Byfold, John, of Sampford, carpenter 2
5480474 2499133 2499133 defendant Broughton John, junior gent 596122 596122 Broughton, John, junior, of Sampford juxta Briggewater, gent 1
5546587 2519003 2519003 defendant Safyn John husbandman 596122 596122 Safyn, John, of Sampford, husbandman 0
5546588 2519003 2519003 defendant Arnold John husbandman 596122 596122 Arnold, John, of Sampford, husbandman 1
5546589 2519003 2519003 defendant Burgeys Richard husbandman 596122 596122 Burgeys, Richard, of Sampford, husbandman 2
5546590 2519003 2519003 defendant Pymme Walter husbandman 596122 596122 Pymme, Walter, of Sampford, husbandman 3
5546591 2519003 2519003 defendant Pymme Philip husbandman 596122 596122 Pymme, Philip, of Sampford, husbandman 4
5546592 2519003 2519003 defendant Wellysley John husbandman 596122 596122 Wellysley, John, of Sampford, husbandman 5
5546593 2519003 2519003 defendant Croftman Thomas glover 596122 596122 Croftman, Thomas, of Sampford, glover 6
5575413 2527400 2527400 defendant Bayly John husbandman 596122 596122 Bayly, John, of Sampford, husbandman 4

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