names

28 rows where place_id = 593163

✎ 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
3610752 1871029 1871029 defendant Smyth John husbandman 593163 593163 Smyth, John, of Magna Fynbergh, husbandman 0
3610753 1871029 1871029 defendant Smyth Rose widow 593163 593163 Smyth, Rose, of Magna Fynbergh, widow 1
3614190 1872105 1872105 defendant Smyth John husbandman 593163 593163 Smyth, John, of Magna Fynbergh, husbandman 0
3614191 1872105 1872105 defendant Smyth Rose widow 593163 593163 Smyth, Rose, of Magna Fynbergh, widow 1
3614848 1872297 1872297 defendant Crosse Thomas husbandman 593163 593163 Crosse, Thomas, of Magna Fynbergh, husbandman 0
3614849 1872297 1872297 defendant Crosse Robert laborer 593163 593163 Crosse, Robert, of Magna Fynbergh, laborer 1
3614850 1872297 1872297 defendant Crosse John laborer 593163 593163 Crosse, John, of Magna Fynbergh, laborer 2
3618123 1873292 1873292 defendant Crosse Thomas husbandman 593163 593163 Crosse, Thomas, of Magna Fynbergh, husbandman 0
3625670 1875565 1875565 defendant Southawe John husbandman 593163 593163 Southawe, John, of Magna Fynbergh, husbandman 0
3625671 1875565 1875565 defendant Jonyr Robert husbandman 593163 593163 Jonyr, Robert, of Magna Fynbergh, husbandman 1
4777728 2289027 2289027 defendant Costard John, senior husbandman 593163 593163 Costard, John, senior, of Magna Fynbergh, husbandman 0
4777729 2289027 2289027 defendant Costard John, junior husbandman 593163 593163 Costard, John, junior, of Magna Fynbergh, husbandman 1
4906936 2328750 2328750 defendant Senelonys or Senelovys John butcher 593163 593163 Senelonys or Senelovys, John, of Magna Fynbergh, butcher 2
5077226 2379692 2379692 defendant Ive Robert esq 593163 593163 Ive, Robert, of Magna Fynbergh, esq 0
5231255 2424738 2424738 defendant Seveloves Joan widow 593163 593163 Seveloves, Joan, of Magna Fynbergh, widow 0
5231256 2424738 2424738 defendant Seveloves Robert husbandman 593163 593163 Seveloves, Robert, of Magna Fynbergh, husbandman 1
5244904 2428683 2428683 defendant Cordy Thomas scrivener 593163 593163 Cordy, Thomas, of Magna Fynbergh, scrivener 1
5280268 2439305 2439305 defendant Thurmod John husbandman 593163 593163 Thurmod, John, of Magna Fynbergh, husbandman 5
5359809 2463106 2463106 defendant Smyth Thomas carpenter 593163 593163 Smyth, Thomas, of Magna Fynbergh, carpenter 1
5490466 2502042 2502042 defendant Tryker William tailor 593163 593163 Tryker, William, of Magna Fynbergh, tailor 4
5505244 2506550 2506550 defendant Tynton John yeoman 593163 593163 Tynton, John, of Magna Fynbergh, yeoman 3
5512333 2508715 2508715 defendant Tynton John husbandman 593163 593163 Tynton, John, of Magna Fynbergh, husbandman 0
5533845 2515130 2515130 defendant Joure Robert husbandman 593163 593163 Joure, Robert, of Magna Fynbergh, husbandman 0
5545220 2518603 2518603 defendant Smyth Robert, senior husbandman 593163 593163 Smyth, Robert, senior, of Magna Fynbergh, husbandman 0
5550301 2520108 2520108 defendant Gowele Richard (legal representative) 593163 593163 Gowele, Richard, of Magna Fynbergh, executrix of 0
5550302 2520108 2520108 defendant Gowele Anne widow 593163 593163 Gowele, Anne, of Magna Fynbergh, widow 1
5560264 2522964 2522964 defendant Smyth Robert, senior husbandman 593163 593163 Smyth, Robert, senior, of Magna Fynbergh, husbandman 0
5560265 2522964 2522964 defendant Smyth Thomas panier maker 593163 593163 Smyth, Thomas, of Magna Fynbergh, panier maker 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);