names

24 rows where place_id = 586790

✎ 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
3589630 1864400 1864400 defendant Deryng Thomas miller 586790 586790 Deryng, Thomas, of Ugburgh, miller 0
3600245 1867724 1867724 defendant Toker Walter miller 586790 586790 Toker, Walter, of Ugburgh, miller 1
3613508 1871873 1871873 defendant Wode Agnes widow 586790 586790 Wode, Agnes, of Ugburgh, widow 1
3625477 1875507 1875507 defendant Baron John husbandman 586790 586790 Baron, John, of Ugburgh, husbandman 0
3646591 1909338 1909338 defendant Creweber Henry husbandman 586790 586790 Creweber, Henry, of Ugburgh, husbandman 1
3650213 1910436 1910436 defendant Baron William husbandman 586790 586790 Baron, William, of Ugburgh, husbandman 2
3650218 1910437 1910437 defendant Baron William husbandman 586790 586790 Baron, William, of Ugburgh, husbandman 2
3656910 1912418 1912418 defendant Vyrby Richenda singlewoman 586790 586790 Vyrby, Richenda, of Ugburgh, singlewoman 1
3662773 1914277 1914277 defendant Han John husbandman 586790 586790 Han, John, of Ugburgh, husbandman 0
3662774 1914277 1914277 defendant Tope John husbandman 586790 586790 Tope, John, of Ugburgh, husbandman 1
3678022 1919170 1919170 defendant Gownde Thomas laborer 586790 586790 Gownde, Thomas, of Ugburgh, laborer 0
3693688 1924219 1924219 defendant Gowide Thomas laborer 586790 586790 Gowide, Thomas, of Ugburgh, laborer 1
3805473 1959650 1959650 defendant Harrys John   586790 586790 Harrys, John, of Ugburgh 0
3894501 1988369 1988369 defendant Fouhell Thomas esq 586790 586790 Fouhell, Thomas, of Ugburgh, esq 0
3990488 2021351 2021351 defendant Damerell Thomas (legal representative) 586790 586790 Damerell, Thomas, of Ugburgh, executors of 0
4733596 2275683 2275683 defendant Stoklegh Nicholas husbandman 586790 586790 Stoklegh, Nicholas, of Ugburgh, husbandman 3
4960117 2344993 2344993 defendant Shekcote Richard husbandman 586790 586790 Shekcote, Richard, of Ugburgh, husbandman 0
4960118 2344993 2344993 defendant Shekcote Walter yeoman 586790 586790 Shekcote, Walter, of Ugburgh, yeoman 1
5013782 2360877 2360877 defendant Luer Robert carpenter 586790 586790 Luer, Robert, of Ugburgh, carpenter 0
5085566 2382173 2382173 defendant Luer or Ludr Simon carpenter 586790 586790 Luer or Ludr, Simon, of Ugburgh, carpenter 2
5303669 2446093 2446093 defendant Kyrton John gent 586790 586790 Kyrton, John, of Ugburgh, gent 0
5402516 2475789 2475789 defendant Ceyto William laborer 586790 586790 Ceyto, William, of Ugburgh, laborer 0
5457330 2492094 2492094 defendant Baron John husbandman 586790 586790 Baron, John, of Ugburgh, husbandman 0
5578286 2528278 2528278 defendant Gille Baldwin husbandman 586790 586790 Gille, Baldwin, of Ugburgh, husbandman 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);