names

42 rows where place_id = 602275

✎ 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
3649261 1910157 1910157 defendant Baker John yeoman 602275 602275 Baker, John, of Depford, Kent, yeoman 1
3664271 1914778 1914778 defendant Tyddar John (legal representative) 602275 602275 Tyddar, John, of Depford, Kent, yeoman, executors of 0
3691359 1923457 1923457 defendant Langthorne Edmund butcher 602275 602275 Langthorne, Edmund, of Depford, Kent, butcher 0
3718558 1932081 1932081 defendant Curtes William clerk 602275 602275 Curtes, William, of Depford, Kent, clerk 4
3755314 1943616 1943616 defendant Aparr William husbandman 602275 602275 (Aparr, William, of Depford, Kent, husbandman 1
3882648 1984463 1984463 plaintiff Thursby James husbandman 602275 602275 Thursby, James, of Depford, Kent, husbandman 0
3915657 1995607 1995607 defendant Casse Robert gent 602275 602275 Casse, Robert, of Depford, Kent, gent 0
4706585 2267439 2267439 defendant Cheseman John husbandman 602275 602275 Cheseman, John, of Depford, Kent, husbandman 0
4738911 2277261 2277261 defendant Wynchecombe John   602275 602275 Wynchecombe, John, of Depford, Kent 1
4786349 2291774 2291774 defendant Willyam Thomas   602275 602275 Willyam, Thomas, of Depford, Kent, "wherfager" 0
4818533 2301876 2301876 defendant Ludlowe John brewer 602275 602275 Ludlowe, John, of Depford, Kent, brewer 0
4818586 2301895 2301895 defendant Ludlowe John brewer 602275 602275 Ludlowe, John, of Depford, Kent, brewer 1
4832018 2306046 2306046 plaintiff Burgh Robert de   602275 602275 Burgh, Robert de, of Depford, Kent 0
4870314 2317689 2317689 defendant More Robert yeoman 602275 602275 More, Robert, of Depford, Kent, yeoman 0
4974087 2349212 2349212 defendant More Robert butcher 602275 602275 More, Robert, of Depford, Kent, butcher 0
5003761 2357992 2357992 defendant More Robert yeoman 602275 602275 More, Robert, of Depford, Kent, yeoman 1
5109071 2389073 2389073 defendant Fraunceys John, junior brewer 602275 602275 Fraunceys, John, junior, of Depford, Kent, brewer 1
5116122 2391140 2391140 defendant Lathe Henry   602275 602275 Lathe, Henry, of Depford, Kent 4
5116128 2391141 2391141 defendant Lathe Henry yeoman 602275 602275 Lathe, Henry, of Depford, Kent, yeoman 4
5185256 2411434 2411434 defendant Chamberleyn John husbandman 602275 602275 Chamberleyn, John, of Depford, Kent, husbandman 4
5204733 2417128 2417128 defendant Chamberleyn John husbandman 602275 602275 Chamberleyn, John, of Depford, Kent, husbandman 4
5216095 2420437 2420437 defendant Appulton Roger, junior gent 602275 602275 Appulton, Roger, junior, of Depford, Kent, gent 0
5216097 2420438 2420438 defendant Appulton Roger gent 602275 602275 Appulton, Roger, of Depford, Kent, gent 0
5240122 2427312 2427312 defendant White John husbandman 602275 602275 White, John, of Depford, Kent, husbandman 0
5346589 2459084 2459084 defendant Cruse Thomas yeoman 602275 602275 Cruse, Thomas, of Depford, Kent, yeoman 0
5349853 2460089 2460089 defendant Cruse Thomas yeoman 602275 602275 Cruse, Thomas, of Depford, Kent, yeoman 0
5357654 2462464 2462464 defendant Robyns John shipman 602275 602275 Robyns, John, of Depford, Kent, shipman 2
5357858 2462525 2462525 defendant Robyns John shipman 602275 602275 Robyns, John, of Depford, Kent, shipman 3
5395737 2473863 2473863 defendant Waller Thomas   602275 602275 Waller, Thomas, of Depford, Kent, lime burner 4
5408368 2477474 2477474 defendant Rylond Ralph yeoman 602275 602275 Rylond, Ralph, of Depford, Kent, yeoman 1
5416320 2479800 2479800 defendant Beake Richard yeoman 602275 602275 Beake, Richard, of Depford, Kent, yeoman 1
5418471 2480449 2480449 defendant Walker Thomas   602275 602275 Walker, Thomas, of Depford, Kent, lime burner 4
5431184 2484270 2484270 defendant Ryland Ralph yeoman 602275 602275 Ryland, Ralph, of Depford, Kent, yeoman 1
5431187 2484271 2484271 defendant Ryland Ralph yeoman 602275 602275 Ryland, Ralph, of Depford, Kent, yeoman 1
5433079 2484858 2484858 defendant Blake Richard yeoman 602275 602275 Blake, Richard, of Depford, Kent, yeoman 1
5436411 2485823 2485823 defendant Waller Thomas   602275 602275 Waller, Thomas, of Depford, Kent, lime burner 4
5490297 2501984 2501984 defendant Blak Richard yeoman 602275 602275 Blak, Richard, of Depford, Kent, yeoman 0
5490299 2501985 2501985 defendant Blak Richard yeoman 602275 602275 Blak, Richard, of Depford, Kent, yeoman 0
5514721 2509446 2509446 defendant Hanson Richard brewer 602275 602275 Hanson, Richard, of Depford, Kent, brewer 2
5514727 2509447 2509447 defendant Hanson Richard brewer 602275 602275 Hanson, Richard, of Depford, Kent, brewer 2
5555899 2521719 2521719 defendant Peke Henry innholder 602275 602275 Peke, Henry, of Depford, Kent, innholder 0
5576800 2527788 2527788 defendant Dalby Richard miller 602275 602275 Dalby, Richard, of Depford, Kent, miller 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);