names

37 rows where place_id = 604255

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657393 1912570 1912570 defendant a Wodde Thomas   604255 604255 a Wodde, Thomas, of Flytcham 5
3663908 1914653 1914653 defendant Jonson William laborer 604255 604255 Jonson, William, of Flytcham, laborer 3
3716308 1931394 1931394 defendant Lawe William husbandman 604255 604255 Lawe, William, of Flytcham, husbandman 0
3716309 1931394 1931394 defendant Myght Richard husbandman 604255 604255 Myght, Richard, of Flytcham, husbandman 1
3716310 1931394 1931394 defendant Webster William husbandman 604255 604255 Webster, William, of Flytcham, husbandman 2
3716311 1931394 1931394 defendant Hill Richard husbandman 604255 604255 Hill, Richard, of Flytcham, husbandman 3
3856231 1975569 1975569 defendant Thomson George husbandman 604255 604255 Thomson, George, of Flytcham, husbandman 0
3881534 1984085 1984085 defendant West John clerk 604255 604255 West, John, of Flytcham, clerk 0
3881536 1984085 1984085 defendant Bower George   604255 604255 Bower, George, of Flytcham, shepherd 2
3989730 2021072 2021072 defendant Might Thomas gent 604255 604255 Might, Thomas, of Flytcham, gent 2
4062606 2046920 2046920 defendant Thymperley Thomas esq 604255 604255 Thymperley, Thomas, of Flytcham, esq 0
4062608 2046921 2046921 defendant Tymperley Nicholas gent 604255 604255 Tymperley, Nicholas, of Flytcham, gent 0
4062610 2046922 2046922 defendant Tymperley Thomas esq 604255 604255 Tymperley, Thomas, of Flytcham, esq 0
4076536 2051906 2051906 plaintiff Skarlett William   604255 604255 Skarlett, William, of Flytcham 0
4107542 2062984 2062984 defendant Raveley Richard husbandman 604255 604255 Raveley, Richard, of Flytcham, husbandman 1
4213893 2100379 2100379 defendant Grene John singleman 604255 604255 Grene, John, of Flytcham, yeoman, singleman 1
5057068 2373692 2373692 defendant Cheny or Chevy John yeoman 604255 604255 Cheny or Chevy, John, of Flytcham, yeoman 2
5156322 2403002 2403002 defendant Bolter John yeoman 604255 604255 Bolter, John, of Flytcham, yeoman 0
5192100 2413419 2413419 defendant Bolter John yeoman 604255 604255 Bolter, John, of Flytcham, yeoman 0
5200244 2415832 2415832 defendant Hyket Robert husbandman 604255 604255 Hyket, Robert, of Flytcham, husbandman 0
5207616 2417968 2417968 defendant Bolter John yeoman 604255 604255 Bolter, John, of Flytcham, yeoman 3
5276853 2438313 2438313 defendant Man William carpenter 604255 604255 Man, William, of Flytcham, carpenter 1
5282760 2440016 2440016 defendant Browne Thomas   604255 604255 Browne, Thomas, of Flytcham, shepherd 0
5330466 2454193 2454193 defendant Inys or Ivys Richard husbandman 604255 604255 Inys or Ivys, Richard, of Flytcham, husbandman 0
5536686 2515960 2515960 defendant Bery Thomas yeoman 604255 604255 Bery, Thomas, of Flytcham, yeoman 0
5574372 2527068 2527068 defendant Hale Geoffrey yeoman 604255 604255 Hale, Geoffrey, of Flytcham, yeoman 2
5596887 2533946 2533946 defendant Hale Geoffrey yeoman 604255 604255 Hale, Geoffrey, of Flytcham, yeoman 1
5596888 2533946 2533946 defendant Key William laborer 604255 604255 Key, William, of Flytcham, laborer 2
5596889 2533946 2533946 defendant Kay Thomas laborer 604255 604255 Kay, Thomas, of Flytcham, laborer 3
5596890 2533946 2533946 defendant Scarlet Richard laborer 604255 604255 Scarlet, Richard, of Flytcham, laborer 4
5596891 2533946 2533946 defendant Taylor Thomas tailor 604255 604255 Taylor, Thomas, of Flytcham, tailor 5
5596892 2533946 2533946 defendant Webster William laborer 604255 604255 Webster, William, of Flytcham, laborer 6
5596893 2533946 2533946 defendant Webster Hugh tailor 604255 604255 Webster, Hugh, of Flytcham, tailor 7
5596894 2533946 2533946 defendant Hervy William laborer 604255 604255 Hervy, William, of Flytcham, laborer 8
5596895 2533946 2533946 defendant Costyn James carpenter 604255 604255 Costyn, James, of Flytcham, carpenter 9
5596896 2533946 2533946 defendant Southhyll Thomas   604255 604255 Southhyll, Thomas, of Flytcham, shepherd 10
5601180 2535260 2535260 defendant Sharnborn Thomas gent 604255 604255 Sharnborn, Thomas, of Flytcham, gent 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);