names

31 rows where place_id = 600444

✎ 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
3641071 1907649 1907649 defendant Hopley Thomas, junior husbandman 600444 600444 Hopley, Thomas, junior, of Almeley, husbandman 0
3641072 1907649 1907649 defendant Mesebeth Thomas laborer 600444 600444 Mesebeth, Thomas, of Almeley, laborer 1
3642379 1908062 1908062 defendant Taillour John tailor 600444 600444 Taillour, John, of Almeley, tailor 2
3671000 1916902 1916902 defendant Wynnes Isabel widow 600444 600444 Wynnes, Isabel, of Almeley, widow 2
3724505 1933950 1933950 defendant Socur Henry cordwainer 600444 600444 Socur, Henry, of Almeley, cordwainer 1
3724506 1933950 1933950 defendant Socur Thomas laborer 600444 600444 Socur, Thomas, of Almeley, laborer 2
3942618 2004538 2004538 defendant Colyar Richard yeoman 600444 600444 Colyar, Richard, of Almeley, yeoman 0
3961244 2011027 2011027 defendant Williams alias Tayler Meredith tailor 600444 600444 Williams alias Tayler, Meredith, of Almeley, tailor 0
3975154 2015874 2015874 defendant Smythe Walter yeoman 600444 600444 Smythe, Walter, of Almeley, yeoman 1
4003910 2026166 2026166 defendant Collyer John yeoman 600444 600444 Collyer, John, of Almeley, yeoman 0
4008519 2027813 2027813 defendant Collyer John yeoman 600444 600444 Collyer, John, of Almeley, yeoman 4
4008528 2027814 2027814 defendant Collyer John yeoman 600444 600444 Collyer, John, of Almeley, yeoman 4
4040619 2039141 2039141 defendant Hopley Richard yeoman 600444 600444 Hopley, Richard, of Almeley, yeoman 0
4087436 2055800 2055800 defendant Collyer Richard yeoman 600444 600444 Collyer, Richard, of Almeley, yeoman 0
4093250 2057905 2057905 defendant Hawkyns John yeoman 600444 600444 Hawkyns, John, of Almeley, yeoman 0
4112077 2064574 2064574 defendant Bowyer Edmund laborer 600444 600444 Bowyer, Edmund, of Almeley, laborer 4
4152114 2078853 2078853 defendant Smyth Richard yeoman 600444 600444 Smyth, Richard, of Almeley, yeoman 0
4152116 2078854 2078854 defendant Turner Walter yeoman 600444 600444 Turner, Walter, of Almeley, yeoman 0
4175172 2086778 2086778 defendant Collyer Walter yeoman 600444 600444 Collyer, Walter, of Almeley, yeoman 0
4175173 2086778 2086778 defendant Parker John yeoman 600444 600444 Parker, John, of Almeley, yeoman 1
4182363 2089304 2089304 defendant Harper John yeoman 600444 600444 Harper, John, of Almeley, yeoman, son of Roland Harper, of Stockes, Almelye, yeoman 2
4190300 2092116 2092116 defendant George John   600444 600444 George, John, of Almeley, yeoman, bachelor 1
4190301 2092116 2092116 defendant Parker John yeoman 600444 600444 Parker, John, of Almeley, yeoman 2
4201016 2095913 2095913 defendant Hopley John yeoman 600444 600444 Hopley, John, of Almeley, yeoman 1
4246178 2111699 2111699 defendant Jenckines John yeoman 600444 600444 Jenckines, John, of Almeley, or of Upcott, yeoman 0
4269860 2119510 2119510 defendant Hopley Thomas yeoman 600444 600444 Hopley, Thomas, of Almeley, yeoman 0
4290773 2126758 2126758 defendant Hopley John yeoman 600444 600444 Hopley, John, of Almeley, yeoman 0
4390065 2161298 2161298 defendant Gibbons Richard yeoman 600444 600444 Gibbons, Richard, of Almeley, yeoman 0
4390066 2161298 2161298 defendant Whytney Elizabeth spinster 600444 600444 Whytney, Elizabeth, of Almeley, spinster 1
4399219 2164325 2164325 defendant Parker John yeoman 600444 600444 Parker, John, of Almeley, or of Harpton, Old Radnor, yeoman 0
4399220 2164325 2164325 defendant Parker James yeoman 600444 600444 Parker, James, of Almeley, yeoman 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);