names

25 rows where place_id = 595121

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618986 1873550 1873550 defendant Porchet Richard smith 595121 595121 Porchet, Richard, of Suthwyke, smith 0
3624657 1875247 1875247 defendant Senok John laborer 595121 595121 Senok, John, of Suthwyke, laborer 0
3691249 1923419 1923419 defendant Avery John husbandman 595121 595121 Avery, John, of Suthwyke, husbandman 1
3695735 1924896 1924896 defendant Godwyn Richard carpenter 595121 595121 Godwyn, Richard, of Suthwyke, carpenter 0
3764868 1946679 1946679 defendant Fylle Henry husbandman 595121 595121 Fylle, Henry, of Suthwyke, husbandman 2
3809434 1960832 1960832 defendant Compton John smith 595121 595121 Compton, John, of Suthwyke, smith 0
3816668 1963116 1963116 defendant Compton John smith 595121 595121 Compton, John, of Suthwyke, smith 0
3844660 1971873 1971873 defendant Evans Thomas husbandman 595121 595121 Evans, Thomas, of Suthwyke, husbandman 0
3846913 1972572 1972572 defendant Neuman William laborer 595121 595121 Neuman, William, of Suthwyke, laborer 1
4545767 2214603 2214603 defendant Pevensy Walter   595121 595121 Pevensy, Walter, of Suthwyke 0
4837153 2307573 2307573 defendant Nevyle Simon yeoman 595121 595121 Nevyle, Simon, of Suthwyke, yeoman 0
4862996 2315405 2315405 defendant Northonne Richard husbandman 595121 595121 Northonne, Richard, of Suthwyke, husbandman 0
4899179 2326385 2326385 defendant Bygges William chapman 595121 595121 Bygges, William, of Suthwyke, chapman 0
5340094 2457109 2457109 defendant Vyle John husbandman 595121 595121 Vyle, John, of Suthwyke, husbandman 0
5355408 2461766 2461766 defendant Carde Mathew yeoman 595121 595121 Carde, Mathew, of Suthwyke, yeoman 0
5372288 2466927 2466927 defendant Shalden Thomas yeoman 595121 595121 Shalden, Thomas, of Suthwyke, yeoman 1
5414738 2479344 2479344 defendant Marchall Jacob yeoman 595121 595121 Marchall, Jacob, of Suthwyke, yeoman 0
5460199 2492984 2492984 defendant Shalden Thomas yeoman 595121 595121 Shalden, Thomas, of Suthwyke, yeoman 0
5460200 2492984 2492984 defendant Kentysshe Thomas husbandman 595121 595121 Kentysshe, Thomas, of Suthwyke, husbandman 1
5521680 2511595 2511595 defendant Myll Thomas miller 595121 595121 Myll, Thomas, of Suthwyke, miller 0
5525077 2512432 2512432 defendant Mylle Thomas husbandman 595121 595121 Mylle, Thomas, of Suthwyke, husbandman 0
5534252 2515245 2515245 defendant Adys Richard cordwainer 595121 595121 Adys, Richard, of Suthwyke, cordwainer 0
5534253 2515245 2515245 defendant Bylbury Nicholas cordwainer 595121 595121 Bylbury, Nicholas, of Suthwyke, cordwainer 1
5534437 2515313 2515313 defendant Rykman John husbandman 595121 595121 Rykman, John, of Suthwyke, husbandman 2
5556248 2521823 2521823 defendant Walssh Thomas fuller 595121 595121 Walssh, Thomas, of Suthwyke, fuller 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);