names

37 rows where place_id = 595128

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619023 1873560 1873560 defendant Rudde John yeoman 595128 595128 Rudde, John, of Sanford, yeoman 0
3619024 1873560 1873560 defendant Rudde Richard yeoman 595128 595128 Rudde, Richard, of Sanford, yeoman 1
3619025 1873560 1873560 defendant Stykman John yeoman 595128 595128 Stykman, John, of Sanford, yeoman 2
3619026 1873560 1873560 defendant Lambe Richard yeoman 595128 595128 Lambe, Richard, of Sanford, yeoman 3
3619027 1873560 1873560 defendant Robynson John yeoman 595128 595128 Robynson, John, of Sanford, yeoman 4
3619028 1873560 1873560 defendant Feynt William yeoman 595128 595128 Feynt, William, of Sanford, yeoman 5
3619029 1873560 1873560 defendant Bank Robert yeoman 595128 595128 Bank, Robert, of Sanford, yeoman 6
3619030 1873560 1873560 defendant Rudde Thomas yeoman 595128 595128 Rudde, Thomas, of Sanford, yeoman 7
3619032 1873560 1873560 defendant Rudde Henry yeoman 595128 595128 Rudde, Henry, of Sanford, yeoman 9
3619033 1873560 1873560 defendant Bacon Christopher yeoman 595128 595128 Bacon, Christopher, of Sanford, yeoman 10
3619034 1873560 1873560 defendant Baxter John yeoman 595128 595128 Baxter, John, of Sanford, yeoman 11
3714240 1930750 1930750 defendant Colyn William yeoman 595128 595128 Colyn, William, of Sanford, yeoman 0
3714241 1930750 1930750 defendant Waller Thomas husbandman 595128 595128 Waller, Thomas, of Sanford, husbandman 1
3729567 1935494 1935494 defendant Colyn William yeoman 595128 595128 Colyn, William, of Sanford, yeoman 0
3729568 1935494 1935494 defendant Waller Thomas husbandman 595128 595128 Waller, Thomas, of Sanford, husbandman 1
3742970 1939649 1939649 defendant Colyn William husbandman 595128 595128 Colyn, William, of Sanford, husbandman 0
3742971 1939649 1939649 defendant Rudde John husbandman 595128 595128 Rudde, John, of Sanford, husbandman 1
3901523 1990734 1990734 defendant Elston Roger yeoman 595128 595128 Elston, Roger, of Sanford, yeoman 0
4181219 2088909 2088909 defendant Dyer John weaver 595128 595128 Dyer, John, of Sanford, weaver 1
4227478 2105091 2105091 defendant Carte alias Hurford John husbandman 595128 595128 Carte alias Hurford, John, of Sanford, husbandman 2
4476526 2193323 2193323 defendant Grene William   595128 595128 Grene, William, of Sanford 2
4476527 2193323 2193323 defendant Higges John   595128 595128 Higges, John, of Sanford 3
4476528 2193323 2193323 defendant Jones Margery   595128 595128 Jones, Margery, of Sanford 4
4476529 2193323 2193323 defendant Say Richard   595128 595128 Say, Richard, of Sanford 5
4665773 2250771 2250771 plaintiff Horyge William   595128 595128 Horyge, William, of Sanford 0
4707005 2267573 2267573 defendant Lullay John husbandman 595128 595128 Lullay, John, of Sanford, husbandman 0
4710211 2268544 2268544 defendant lullay John husbandman 595128 595128 lullay, John, of Sanford, husbandman 0
4846765 2310495 2310495 defendant Smyth Roger smith 595128 595128 Smyth, Roger, of Sanford, smith 1
4984364 2352252 2352252 defendant Pynnok Richard laborer 595128 595128 Pynnok, Richard, of Sanford, laborer 1
5067546 2376790 2376790 defendant Maydegode John husbndman 595128 595128 Maydegode, John, of Sanford, husbndman 3
5067547 2376790 2376790 defendant Andrewe William miller 595128 595128 Andrewe, William, of Sanford, miller 4
5312829 2448867 2448867 defendant Vyell Thomas yeoman 595128 595128 Vyell, Thomas, of Sanford, yeoman 0
5330187 2454104 2454104 defendant Vyell Thomas yeoman 595128 595128 Vyell, Thomas, of Sanford, yeoman 0
5346086 2458913 2458913 defendant Tetteborne John laborer 595128 595128 Tetteborne, John, of Sanford, laborer 4
5386263 2471133 2471133 defendant Adrian Agnes widow 595128 595128 Adrian, Agnes, of Sanford, widow 0
5568535 2525347 2525347 defendant Rocke Robert husbandman 595128 595128 Rocke, Robert, of Sanford, husbandman 1
5568536 2525347 2525347 defendant Tulle John husbandman 595128 595128 Tulle, John, of Sanford, husbandman 2

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