names

33 rows where place_id = 589293

✎ 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
3597126 1866725 1866725 defendant Grene Robert husbandman 589293 589293 Grene, Robert, of Bylton, husbandman 1
3625391 1875483 1875483 defendant Snawsell Seth gent 589293 589293 Snawsell, Seth, of Bylton, gent 0
3625392 1875483 1875483 defendant Gayton Thomas yeoman 589293 589293 Gayton, Thomas, of Bylton, yeoman 1
3625393 1875483 1875483 defendant Chambre Lawrence yeoman 589293 589293 Chambre, Lawrence, of Bylton, yeoman 2
3625394 1875483 1875483 defendant Waven or Wanen James yeoman 589293 589293 Waven or Wanen, James, of Bylton, yeoman 3
3625395 1875483 1875483 defendant Wright William yeoman 589293 589293 Wright, William, of Bylton, yeoman 4
3625396 1875483 1875483 defendant Bebe or Beve James husbandman 589293 589293 Bebe or Beve, James, of Bylton, husbandman 5
3652409 1911088 1911088 defendant Faux John husbandman 589293 589293 Faux, John, of Bylton, husbandman 0
3710396 1929571 1929571 defendant Holme Thomas husbandman 589293 589293 Holme, Thomas, of Bylton, husbandman 0
3715541 1931146 1931146 defendant Ardern Thomas husbandman 589293 589293 Ardern, Thomas, of Bylton, husbandman 4
3767504 1947473 1947473 defendant Graveley or Graneley Richard drover 589293 589293 Graveley or Graneley, Richard, of Bylton, drover 0
3770832 1948566 1948566 defendant Warde Miles blacksmith 589293 589293 Warde, Miles, of Bylton, blacksmith 4
3831779 1967840 1967840 defendant Snawsell Thomas gent 589293 589293 Snawsell, Thomas, of Bylton, gent 0
3853869 1974843 1974843 defendant Percy Gregory clerk 589293 589293 Percy, Gregory, of Bylton, clerk 0
3949112 2006751 2006751 defendant Kay George gent 589293 589293 Kay, George, of Bylton, or of Wakefeld, gent 0
3996495 2023506 2023506 defendant Phillipps John yeoman 589293 589293 Phillipps, John, of Bylton, yeoman 1
3996496 2023506 2023506 defendant Mekyns William yeoman 589293 589293 Mekyns, William, of Bylton, yeoman 2
3996500 2023507 2023507 defendant Phillips John yeoman 589293 589293 Phillips, John, of Bylton, yeoman 1
3996501 2023507 2023507 defendant Mekyns William yeoman 589293 589293 Mekyns, William, of Bylton, yeoman 2
4022135 2032646 2032646 plaintiff Knolles Anne gentlewoman 589293 589293 Anne Knolles, of Bylton, gentlewoman, administrator of 0
4022138 2032647 2032647 plaintiff Knolles Anne gentlewoman 589293 589293 Anne Knolles, of Bylton, gentlewoman, administrator of 0
4051858 2043085 2043085 plaintiff Worcetter William yeoman 589293 589293 Worcetter, William, of Bylton, yeoman 0
4501521 2201078 2201078 defendant Frost William   589293 589293 Frost, William, of Bylton 0
4748843 2280150 2280150 defendant Kirkham Joan widow & formerly wife of Robert Kirkham 589293 589293 Kirkham, Joan, of Bylton, widow & formerly wife of Robert Kirkham 0
4754175 2281684 2281684 defendant Bylton John husbandman 589293 589293 Bylton, John, of Bylton, husbandman 1
4826567 2304345 2304345 defendant Parish-priest-of-Bylton Thomas chaplain 589293 589293 Parish-priest-of-Bylton, Thomas, of Bylton, chaplain 0
4835670 2307150 2307150 defendant Garner John husbandman 589293 589293 Garner, John, of Bylton, husbandman 0
4851317 2311859 2311859 defendant Routh William smith 589293 589293 Routh, William, of Bylton, smith 2
4946098 2340768 2340768 plaintiff James Richard   589293 589293 James, Richard, of Bylton 0
5133263 2396215 2396215 defendant Worsley John   589293 589293 Worsley, John, of Bylton 2
5494154 2503155 2503155 defendant Tryme John smith 589293 589293 Tryme, John, of Bylton, smith 3
5498471 2504495 2504495 defendant Daynell or Dayvell Thomas gent 589293 589293 Daynell or Dayvell, Thomas, of Bylton, gent 0
5498488 2504496 2504496 defendant Daynell Thomas gent 589293 589293 Daynell, Thomas, of Bylton, gent 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);