names

32 rows where place_id = 591489

✎ 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
3604550 1869087 1869087 defendant Bower John husbandman 591489 591489 Bower, John, of Monyasshe, husbandman 1
3670025 1916570 1916570 defendant Lowe Robert laborer 591489 591489 Lowe, Robert, of Monyasshe, laborer 2
3683153 1920848 1920848 defendant Shepart Roger husbandman 591489 591489 Shepart, Roger, of Monyasshe, husbandman 1
3683154 1920848 1920848 defendant More John husbandman 591489 591489 More, John, of Monyasshe, husbandman 2
3805238 1959584 1959584 defendant Moseley Henry miller 591489 591489 Moseley, Henry, of Monyasshe, miller 0
3816699 1963129 1963129 defendant Sheldon Hugh yeoman 591489 591489 Sheldon, Hugh, of Monyasshe, yeoman 0
3818700 1963751 1963751 defendant Meyre Agnes widow 591489 591489 Meyre, Agnes, of Monyasshe, widow 0
3818705 1963752 1963752 defendant Meyre Agnes widow 591489 591489 Meyre, Agnes, of Monyasshe, widow 0
3837155 1969522 1969522 defendant Canse Thomas laborer 591489 591489 Canse, Thomas, of Monyasshe, laborer 0
3847950 1972934 1972934 defendant Lawe Robert husbandman 591489 591489 Lawe, Robert, of Monyasshe, husbandman 5
3861255 1977235 1977235 defendant Helye Hugh weaver 591489 591489 Helye, Hugh, of Monyasshe, weaver 2
3861256 1977235 1977235 defendant Nedam John chaplain 591489 591489 Nedam, John, of Monyasshe, chaplain 3
3875381 1982012 1982012 defendant Lowe Robert yeoman 591489 591489 Lowe, Robert, of Monyasshe, yeoman 1
3875382 1982012 1982012 defendant Hethecowte Richard laborer 591489 591489 Hethecowte, Richard, of Monyasshe, laborer 2
3875383 1982012 1982012 defendant Bennet Nicholas laborer 591489 591489 Bennet, Nicholas, of Monyasshe, laborer 3
3892305 1987677 1987677 defendant Newton Roger butcher 591489 591489 Newton, Roger, of Monyasshe, butcher 0
3898898 1989835 1989835 defendant Balme William husbandman 591489 591489 Balme, William, of Monyasshe, husbandman 0
4417908 2170478 2170478 defendant Whitbody William   591489 591489 Whitbody, William, of Monyasshe 0
4417909 2170478 2170478 defendant Gote Robert le   591489 591489 Gote, Robert le, of Monyasshe 1
4622700 2238074 2238074 defendant del Dene William   591489 591489 del Dene, William, of Monyasshe 0
4640559 2243345 2243345 defendant Paramour Thomas   591489 591489 Paramour, Thomas, of Monyasshe 5
4714985 2270015 2270015 defendant Meer Thomas yeoman 591489 591489 Meer, Thomas, of Monyasshe, yeoman 0
4784895 2291282 2291282 defendant Codgrave Simon husbandman 591489 591489 Codgrave, Simon, of Monyasshe, husbandman 4
4793601 2294110 2294110 defendant Sleghe James husbandman 591489 591489 Sleghe, James, of Monyasshe, husbandman 0
4793602 2294110 2294110 defendant Assheley John chaplain 591489 591489 Assheley, John, of Monyasshe, chaplain 1
5058690 2374162 2374162 defendant Tagge Thomas butcher 591489 591489 Tagge, Thomas, of Monyasshe, butcher 0
5071095 2377848 2377848 defendant Vygore John yeoman 591489 591489 Vygore, John, of Monyasshe, yeoman 2
5087492 2382720 2382720 defendant Morton John yeoman 591489 591489 Morton, John, of Monyasshe, yeoman 0
5122924 2393135 2393135 defendant Tagge Thomas yeoman 591489 591489 Tagge, Thomas, of Monyasshe, yeoman 1
5535248 2515553 2515553 defendant Astley Henry yeoman 591489 591489 Astley, Henry, of Monyasshe, yeoman 1
5535252 2515554 2515554 defendant Astley Henry yeoman 591489 591489 Astley, Henry, of Monyasshe, yeoman 1
5563554 2523945 2523945 defendant Vycars Thomas husbandman 591489 591489 Vycars, Thomas, of Monyasshe, husbandman 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);