names

35 rows where place_id = 608994

✎ 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
3676452 1918679 1918679 defendant Johnson Roger husbandman 608994 608994 Johnson, Roger, of Monyassh, husbandman 0
3676453 1918679 1918679 defendant Godhyne Thomas yeoman 608994 608994 Godhyne, Thomas, of Monyassh, yeoman 1
3690601 1923224 1923224 defendant Elys Richard husbandman 608994 608994 Elys, Richard, of Monyassh, husbandman 0
3696562 1925157 1925157 defendant Sheldon Alice widow 608994 608994 Sheldon, Alice, of Monyassh, widow 0
3714497 1930830 1930830 defendant Lowe Robert yeoman 608994 608994 Lowe, Robert, of Monyassh, yeoman 4
3714498 1930830 1930830 defendant Oldfeld John butcher 608994 608994 Oldfeld, John, of Monyassh, butcher 5
3744874 1940295 1940295 defendant Elye Thomas husbandman 608994 608994 Elye, Thomas, of Monyassh, husbandman 1
3757358 1944280 1944280 defendant Thomlynson Richard husbandman 608994 608994 Thomlynson, Richard, of Monyassh, husbandman 2
4541345 2213191 2213191 defendant Nalle Thomas   608994 608994 Nalle, Thomas, of Monyassh 1
4555407 2217625 2217625 defendant Prest Hugh   608994 608994 Prest, Hugh, of Monyassh 1
4586173 2227099 2227099 defendant Peyntour Nicholas   608994 608994 Peyntour, Nicholas, of Monyassh 0
4590554 2228403 2228403 defendant Peyntour Nicholas   608994 608994 Peyntour, Nicholas, of Monyassh 1
4612110 2234855 2234855 defendant Mathewe John   608994 608994 Mathewe, John, of Monyassh 0
4622701 2238074 2238074 defendant Smythesson William le   608994 608994 Smythesson, William le, of Monyassh 1
4732817 2275441 2275441 plaintiff Peyntour John   608994 608994 Peyntour, John, of Monyassh 0
4821133 2302689 2302689 defendant Meyre John husbandman 608994 608994 Meyre, John, of Monyassh, husbandman 1
4821242 2302725 2302725 defendant Meyre John husbandman 608994 608994 Meyre, John, of Monyassh, husbandman 1
4834240 2306719 2306719 defendant Mere John of the yeoman 608994 608994 Mere, John of the, of Monyassh, yeoman 3
4834241 2306719 2306719 defendant Ely John smith 608994 608994 Ely, John, of Monyassh, smith 4
4864046 2315730 2315730 defendant Payntour William husbandman 608994 608994 Payntour, William, of Monyassh, husbandman 1
4864049 2315731 2315731 defendant Payntour William yeoman 608994 608994 Payntour, William, of Monyassh, yeoman 1
5029124 2365395 2365395 defendant Mere John yeoman 608994 608994 Mere, John, of Monyassh, yeoman 2
5068298 2377021 2377021 plaintiff Peryson William   608994 608994 Peryson, William, of Monyassh 0
5068301 2377022 2377022 plaintiff Perysson William   608994 608994 Perysson, William, of Monyassh 0
5071901 2378090 2378090 defendant Mayre John husbandman 608994 608994 Mayre, John, of Monyassh, husbandman 0
5119508 2392136 2392136 defendant Cotes John, junior husbandman 608994 608994 Cotes, John, junior, of Monyassh, husbandman 0
5355750 2461876 2461876 defendant Tag Richard yeoman 608994 608994 Tag, Richard, of Monyassh, yeoman 0
5387358 2471457 2471457 defendant Breabury William husbandman 608994 608994 Breabury, William, of Monyassh, husbandman 2
5387359 2471457 2471457 defendant Quardour Richard husbandman 608994 608994 Quardour, Richard, of Monyassh, husbandman 3
5387366 2471458 2471458 defendant Breabury William husbandman 608994 608994 Breabury, William, of Monyassh, husbandman 2
5387367 2471458 2471458 defendant Quareour Richard husbandman 608994 608994 Quareour, Richard, of Monyassh, husbandman 3
5399815 2475041 2475041 defendant Bradbury William   608994 608994 Bradbury, William, of Monyassh 2
5399816 2475041 2475041 defendant Quareour Richard husbandman 608994 608994 Quareour, Richard, of Monyassh, husbandman 3
5412812 2478782 2478782 defendant Bradbury William husbandman 608994 608994 Bradbury, William, of Monyassh, husbandman 2
5412813 2478782 2478782 defendant Quareour Richard husbandman 608994 608994 Quareour, Richard, of Monyassh, husbandman 3

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);