names

22 rows where place_id = 673600

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4010501 2028530 2028530 defendant Hyll or Hyllyn Joan widow 673600 673600 Hyll or Hyllyn, Joan, of Ryme, widow 0
4010502 2028530 2028530 defendant Hyll or Hyllyn John husbandman 673600 673600 Hyll or Hyllyn, John, of Ryme, husbandman 1
4055070 2044212 2044212 defendant Chaundeler William husbandman 673600 673600 Chaundeler, William, of Ryme, husbandman 0
4055072 2044213 2044213 defendant Chaundler William husbandman 673600 673600 Chaundler, William, of Ryme, husbandman 0
4149208 2077852 2077852 defendant Vallyce William yeoman 673600 673600 Vallyce, William, of Ryme, yeoman 1
4158098 2080899 2080899 defendant Lyttell William yeoman or husbandman 673600 673600 Lyttell, William, of Ryme, Yetmyster, yeoman or husbandman 0
4171914 2085638 2085638 defendant Callys Thomas yeoman 673600 673600 Callys, Thomas, of Ryme, yeoman 1
4308320 2133060 2133060 defendant Littell Henry husbandman 673600 673600 Littell, Henry, of Ryme, husbandman 1
4317385 2136194 2136194 defendant Stronde or Stroude William yeoman 673600 673600 Stronde or Stroude, William, of Ryme, yeoman 0
4317386 2136194 2136194 defendant Parker alias Hambridge John laborer 673600 673600 Parker alias Hambridge, John, of Ryme, laborer 1
4317387 2136194 2136194 defendant Pert John laborer 673600 673600 Pert, John, of Ryme, laborer 2
4373843 2155712 2155712 defendant Parker Maud widow 673600 673600 Parker, Maud, of Ryme, widow 3
4469802 2191229 2191229 plaintiff Box Robert   673600 673600 Box, Robert, of Ryme, parson 0
4482158 2195129 2195129 plaintiff Matheu John   673600 673600 Matheu, John, of Ryme, parson 0
4704281 2266716 2266716 defendant Keyme Richard husbandman 673600 673600 Keyme, Richard, of Ryme, husbandman 1
4740209 2277647 2277647 defendant Ryme Richard husbandman 673600 673600 Ryme, Richard, of Ryme, husbandman 0
4740210 2277647 2277647 defendant Kenier Richard husbandman 673600 673600 Kenier, Richard, of Ryme, husbandman 1
4740211 2277647 2277647 defendant Kemer William husbandman 673600 673600 Kemer, William, of Ryme, husbandman 2
4784563 2291178 2291178 defendant Kemer John fisher 673600 673600 Kemer, John, of Ryme, fisher 1
4821876 2302917 2302917 defendant Kember William husbandman 673600 673600 Kember, William, of Ryme, husbandman 1
5106345 2388295 2388295 defendant Wastall William yeoman 673600 673600 Wastall, William, of Ryme, yeoman 0
5352169 2460779 2460779 defendant Kymer Richard husbandman 673600 673600 Kymer, Richard, of Ryme, 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);