names

35 rows where place_id = 666299

✎ 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
3980460 2017780 2017780 defendant Harvye Francis butcher 666299 666299 Harvye, Francis, of Stenynge, butcher 0
3994765 2022879 2022879 defendant Cooke Richard yeoman 666299 666299 Cooke, Richard, of Stenynge, yeoman 1
4189223 2091724 2091724 defendant Taylor William yeoman 666299 666299 Taylor, William, of Stenynge, yeoman 2
4192304 2092868 2092868 defendant Smyth John yeoman 666299 666299 Smyth, John, of Stenynge, or of Pepperscombe, yeoman 0
4223848 2103826 2103826 defendant Smythe Thomas shoemaker 666299 666299 Smythe, Thomas, of Stenynge, shoemaker 2
4224185 2103947 2103947 defendant Ludbetter Thomas yeoman 666299 666299 Ludbetter, Thomas, of Stenynge, yeoman 0
4224250 2103968 2103968 defendant Myddelton Dorothy widow 666299 666299 Myddelton, Dorothy, of Stenynge, widow 1
4225794 2104486 2104486 defendant Charles Richard shoemaker 666299 666299 Charles, Richard, of Stenynge, shoemaker 0
4225795 2104486 2104486 defendant Smythe Richard butcher 666299 666299 Smythe, Richard, of Stenynge, butcher 1
4225796 2104486 2104486 defendant Hore John husbandman 666299 666299 Hore, John, of Stenynge, husbandman 2
4226458 2104726 2104726 defendant Goffe John tanner 666299 666299 Goffe, John, of Stenynge, tanner 0
4226459 2104726 2104726 defendant Cooke Peter yeoman 666299 666299 Cooke, Peter, of Stenynge, yeoman 1
4234044 2107431 2107431 defendant Baylye William yeoman 666299 666299 Baylye, William, of Stenynge, yeoman 2
4235678 2108047 2108047 defendant Butcher Nicholas brewer 666299 666299 Butcher, Nicholas, of Stenynge, brewer 0
4235679 2108047 2108047 defendant Adams Richard husbandman 666299 666299 Adams, Richard, of Stenynge, husbandman 1
4235680 2108047 2108047 defendant Belson Thomas laborer 666299 666299 Belson, Thomas, of Stenynge, laborer 2
4249297 2112747 2112747 defendant Smythe Thomas shoemaker 666299 666299 Smythe, Thomas, of Stenynge, shoemaker 2
4252691 2113887 2113887 defendant Charles Richard shoemaker 666299 666299 Charles, Richard, of Stenynge, shoemaker 0
4252692 2113887 2113887 defendant Smythe Richard butcher 666299 666299 Smythe, Richard, of Stenynge, butcher 1
4252693 2113887 2113887 defendant Hore John husbandman 666299 666299 Hore, John, of Stenynge, husbandman 2
4310363 2133778 2133778 defendant Darkynge John yeoman 666299 666299 Darkynge, John, of Stenynge, yeoman 1
4314832 2135301 2135301 defendant Streter John yeoman 666299 666299 Streter, John, of Stenynge, yeoman 0
4319470 2136919 2136919 defendant Streter John yeoman 666299 666299 Streter, John, of Stenynge, yeoman 0
4327169 2139414 2139414 defendant Humfrey Richard husbandman 666299 666299 Humfrey, Richard, of Stenynge, husbandman 0
4361697 2151340 2151340 defendant Baylye William yeoman 666299 666299 Baylye, William, of Stenynge, yeoman 0
4369540 2154166 2154166 defendant Farnfold Anthony gent 666299 666299 Farnfold, Anthony, of Stenynge, gent 0
4413527 2169120 2169120 plaintiff Bisshop Walter   666299 666299 Bisshop, Walter, of Stenynge 0
4415618 2169764 2169764 defendant Gryntere Thomas le   666299 666299 Gryntere, Thomas le, of Stenynge 0
4610805 2234450 2234450 defendant Ponyman Richard   666299 666299 Ponyman, Richard, of Stenynge 0
4669000 2256009 2256009 defendant Clerk Nicholas   666299 666299 Clerk, Nicholas, of Stenynge, vicar 0
4881668 2321165 2321165 defendant Pryklove John butcher 666299 666299 Pryklove, John, of Stenynge, butcher 0
4881669 2321165 2321165 defendant Ubley John tanner 666299 666299 Ubley, John, of Stenynge, tanner 1
5064807 2376012 2376012 defendant Snellyng John yeoman 666299 666299 Snellyng, John, of Stenynge, yeoman 0
5113539 2390350 2390350 plaintiff Lamvale Thomas   666299 666299 Lamvale, Thomas, of Stenynge 0
5296822 2444060 2444060 defendant Campion Thomas husbandman 666299 666299 Campion, Thomas, of Stenynge, husbandman 1

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