names

42 rows where place_id = 597548

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628988 1903943 1903943 defendant Hyll Thomas yeoman 597548 597548 Hyll, Thomas, of Rumsey, Hants, yeoman 0
3674529 1918086 1918086 defendant Balker John merchant 597548 597548 Balker, John, of Rumsey, Hants, merchant 0
3674531 1918087 1918087 defendant Calker John merchant 597548 597548 Calker, John, of Rumsey, Hants, merchant 0
3679597 1919688 1919688 defendant Raey Robert yeoman 597548 597548 Raey, Robert, of Rumsey, Hants, yeoman 1
3679602 1919689 1919689 defendant Raye Robert yeoman 597548 597548 Raye, Robert, of Rumsey, Hants, yeoman 1
3683906 1921100 1921100 defendant Hancok John dyer 597548 597548 Hancok, John, of Rumsey, Hants, dyer 0
3695205 1924721 1924721 defendant Dyer John dyer 597548 597548 Dyer, John, of Rumsey, Hants, dyer 1
3815176 1962665 1962665 defendant Segwyke Nicholas yeoman 597548 597548 Segwyke, Nicholas, of Rumsey, Hants, yeoman 3
3849235 1973352 1973352 defendant Bull John chapman 597548 597548 Bull, John, of Rumsey, Hants, chapman 4
4008977 2027974 2027974 defendant Parkyns John   597548 597548 Parkyns, John, of Rumsey, Hants, hat maker 0
4008980 2027975 2027975 defendant Parkyns John   597548 597548 Parkyns, John, of Rumsey, Hants, hat maker 0
4022151 2032651 2032651 defendant Mascall James yeoman 597548 597548 Mascall, James, of Rumsey, Hants, yeoman 0
4022353 2032716 2032716 defendant Whetley John fletcher 597548 597548 Whetley, John, of Rumsey, Hants, fletcher 0
4022357 2032718 2032718 defendant Whetley John fletcher 597548 597548 Whetley, John, of Rumsey, Hants, fletcher 0
4031895 2036072 2036072 defendant Wheler Richard yeoman 597548 597548 Wheler, Richard, of Rumsey, Hants, yeoman 0
4054128 2043863 2043863 defendant Mewe Aldred yeoman 597548 597548 Mewe, Aldred, of Rumsey, Hants, yeoman 0
4061883 2046646 2046646 defendant Breckstone Simon butcher 597548 597548 Breckstone, Simon, of Rumsey, Hants, butcher 1
4340108 2143804 2143804 defendant Edmond John esq 597548 597548 Edmond, John, of Rumsey, Hants, esq 3
4368164 2153666 2153666 defendant Estman John chapman 597548 597548 Estman, John, of Rumsey, Hants, chapman 0
4675103 2257825 2257825 defendant Hawle-- Thomas husbandman 597548 597548 Hawle--, Thomas, of Rumsey, Hants, husbandman 2
4731354 2275007 2275007 defendant Kirkeby John esq 597548 597548 Kirkeby, John, of Rumsey, Hants, esq 1
4731357 2275008 2275008 defendant Kirkeby John esq 597548 597548 Kirkeby, John, of Rumsey, Hants, esq 1
4943394 2339903 2339903 defendant Vayrle John husbandman 597548 597548 Vayrle, John, of Rumsey, Hants, husbandman 0
4972019 2348570 2348570 defendant Brynkley Alice widow 597548 597548 Brynkley, Alice, of Rumsey, Hants, widow 3
4972025 2348571 2348571 defendant Brynkley Alice widow 597548 597548 Brynkley, Alice, of Rumsey, Hants, widow 3
5131955 2395830 2395830 defendant Pury John dyer 597548 597548 Pury, John, of Rumsey, Hants, dyer 0
5170737 2407164 2407164 defendant Hawys John fuller 597548 597548 Hawys, John, of Rumsey, Hants, fuller 0
5170744 2407165 2407165 defendant Hawys John fuller 597548 597548 together with Hawys, John, of Rumsey, Hants, fuller 1
5229800 2424337 2424337 defendant Estby John tailor 597548 597548 Estby, John, of Rumsey, Hants, tailor 3
5248561 2429704 2429704 defendant Kyrkeby John esq 597548 597548 Kyrkeby, John, of Rumsey, Hants, esq 3
5254094 2431398 2431398 defendant Ploweman George yeoman 597548 597548 Ploweman, George, of Rumsey, Hants, yeoman 1
5276624 2438243 2438243 defendant Algare William miller 597548 597548 Algare, William, of Rumsey, Hants, miller 0
5289550 2441945 2441945 defendant Cokkys Thomas chapman 597548 597548 Cokkys, Thomas, of Rumsey, Hants, chapman 0
5296334 2443916 2443916 defendant Tomson John husbandman 597548 597548 Tomson, John, of Rumsey, Hants, husbandman 3
5296551 2443980 2443980 defendant Algare William husbandman 597548 597548 Algare, William, of Rumsey, Hants, husbandman 0
5341833 2457638 2457638 defendant Chircherd John yeoman 597548 597548 Chircherd, John, of Rumsey, Hants, yeoman 2
5343052 2458013 2458013 defendant Bonell or Bovell Simon chapman 597548 597548 Bonell or Bovell, Simon, of Rumsey, Hants, chapman 2
5352456 2460868 2460868 defendant Gateryche Stephen yeoman 597548 597548 Gateryche, Stephen, of Rumsey, Hants, yeoman 0
5417496 2480151 2480151 defendant Bounde Robert mercer 597548 597548 Bounde, Robert, of Rumsey, Hants, mercer 1
5482360 2499667 2499667 defendant Marchall John butcher 597548 597548 Marchall, John, of Rumsey, Hants, butcher 0
5552570 2520807 2520807 defendant Calcar Thomas merchant 597548 597548 Calcar, Thomas, of Rumsey, Hants, merchant 2
5589141 2531612 2531612 defendant Hyll John husbandman 597548 597548 Hyll, John, of Rumsey, Hants, 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);