names

24 rows where place_id = 592378

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607511 1870008 1870008 defendant Taillour John yeoman 592378 592378 Taillour, John, of Yarom, yeoman 2
3634505 1905593 1905593 defendant Hunton John chaplain 592378 592378 Hunton, John, of Yarom, chaplain 0
3674296 1918005 1918005 defendant Chamer Thomas chapman 592378 592378 Chamer, Thomas, of Yarom, chapman 2
4317448 2136220 2136220 defendant Sampson Jane widow 592378 592378 Sampson, Jane, of Yarom, widow 0
4317449 2136220 2136220 defendant Fawberd Thomas butcher 592378 592378 Fawberd, Thomas, of Yarom, butcher 1
4450589 2185145 2185145 defendant Preston Richard de   592378 592378 Preston, Richard de, of Yarom 1
4450595 2185146 2185146 defendant Preston Richard de   592378 592378 Preston, Richard de, of Yarom 1
4606893 2233265 2233265 defendant Knyght John   592378 592378 Knyght, John, of Yarom 3
4717597 2270840 2270840 defendant Paule William yeoman 592378 592378 Paule, William, of Yarom, yeoman 0
4793841 2294195 2294195 defendant Cuddesworth John   592378 592378 Cuddesworth, John, of Yarom, parchment maker 0
4815990 2301093 2301093 defendant Hassoke Thomas shoemaker 592378 592378 Hassoke, Thomas, of Yarom, shoemaker 0
4823869 2303545 2303545 defendant Herte Idonea single woman 592378 592378 Herte, Idonea, of Yarom, single woman 3
4972532 2348716 2348716 defendant Smyth John smith 592378 592378 Smyth, John, of Yarom, smith 1
4988424 2353501 2353501 defendant Spicer William spicer 592378 592378 Spicer, William, of Yarom, spicer 11
5044580 2370011 2370011 defendant Smyth John weaver 592378 592378 Smyth, John, of Yarom, weaver 3
5070295 2377608 2377608 defendant Selby Thomas chapman 592378 592378 Selby, Thomas, of Yarom, chapman 1
5195648 2414473 2414473 defendant Richardson John chapman 592378 592378 Richardson, John, of Yarom, chapman 4
5312523 2448783 2448783 plaintiff Bankes Richard   592378 592378 Bankes, Richard, of Yarom 0
5396554 2474103 2474103 defendant Trafford Ralph yeoman 592378 592378 Trafford, Ralph, of Yarom, yeoman 0
5399639 2474981 2474981 plaintiff Eltham John   592378 592378 Eltham, John, of Yarom, 0
5412654 2478732 2478732 plaintiff Eltham John   592378 592378 Eltham, John, of Yarom 0
5412656 2478733 2478733 plaintiff Eltham John   592378 592378 Eltham, John, of Yarom 0
5578188 2528249 2528249 plaintiff Akers William   592378 592378 Akers, William, of Yarom, bailiff 0
5582178 2529498 2529498 defendant Wilkynson alias Routhe Richard yeoman or chapman 592378 592378 Wilkynson alias Routhe, Richard, of Yarom, yeoman or chapman 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);