names

38 rows where place_id = 606922

✎ 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
3666969 1915613 1915613 defendant Wykys John husbandman 606922 606922 Wykys, John, of Eynsham, husbandman 1
3790978 1955014 1955014 defendant Bromeley Humphrey yeoman 606922 606922 Bromeley, Humphrey, of Eynsham, yeoman 0
3790979 1955014 1955014 defendant Tanner William tanner 606922 606922 Tanner, William, of Eynsham, tanner 1
3790981 1955015 1955015 defendant Bromeley Humphrey yeoman 606922 606922 Bromeley, Humphrey, of Eynsham, yeoman 0
3790982 1955015 1955015 defendant Tanner William tanner 606922 606922 Tanner, William, of Eynsham, tanner 1
3790984 1955016 1955016 defendant Bromeley Humphrey yeoman 606922 606922 Bromeley, Humphrey, of Eynsham, yeoman 0
3790986 1955017 1955017 defendant Bromeley Humphrey yeoman 606922 606922 Bromeley, Humphrey, of Eynsham, yeoman 0
3820696 1964360 1964360 defendant Wykes John yeoman 606922 606922 Wykes, John, of Eynsham, yeoman 0
3820698 1964361 1964361 defendant Wykes John yeoman 606922 606922 Wykes, John, of Eynsham, yeoman 0
4055548 2044378 2044378 defendant Gyfford Elizabeth widow 606922 606922 Gyfford, Elizabeth, of Eynsham, widow 2
4134779 2072764 2072764 defendant Ferys Edward yeoman 606922 606922 Ferys, Edward, of Eynsham, yeoman 0
4134780 2072764 2072764 defendant Goborne Edward yeoman 606922 606922 Goborne, Edward, of Eynsham, yeoman 1
4134781 2072764 2072764 defendant Magood George laborer 606922 606922 Magood, George, of Eynsham, laborer 2
4134782 2072764 2072764 defendant Dutton John laborer 606922 606922 Dutton, John, of Eynsham, laborer 3
4134783 2072764 2072764 defendant Cooke John laborer 606922 606922 Cooke, John, of Eynsham, laborer 4
4134784 2072764 2072764 defendant Pendleberye Adam laborer 606922 606922 Pendleberye, Adam, of Eynsham, laborer 5
4134785 2072764 2072764 defendant Herte John yeoman 606922 606922 Herte, John, of Eynsham, yeoman 6
4134787 2072765 2072765 defendant Ferys Edward yeoman 606922 606922 Ferys, Edward, of Eynsham, yeoman 0
4134788 2072765 2072765 defendant Goborne Edward yeoman 606922 606922 Goborne, Edward, of Eynsham, yeoman 1
4134789 2072765 2072765 defendant Magoodm George laborer 606922 606922 Magoodm George, of Eynsham, laborer 2
4134790 2072765 2072765 defendant Dutton John laborer 606922 606922 Dutton, John, of Eynsham, laborer 3
4134791 2072765 2072765 defendant Cooke John laborer 606922 606922 Cooke, John, of Eynsham, laborer 4
4134792 2072765 2072765 defendant Pendlebery Adam laborer 606922 606922 Pendlebery, Adam, of Eynsham, laborer 5
4134793 2072765 2072765 defendant Hart Thomas yeoman 606922 606922 Hart, Thomas, of Eynsham, yeoman 6
4134802 2072768 2072768 defendant Stanley Edward esq 606922 606922 Stanley, Edward, of Eynsham, esq 0
4965882 2346726 2346726 defendant Kene John husbandman 606922 606922 Kene, John, of Eynsham, husbandman 0
4965884 2346727 2346727 defendant Underway John weaver 606922 606922 Underway, John, of Eynsham, weaver 0
5029037 2365364 2365364 plaintiff Nootye John   606922 606922 Nootye, John, of Eynsham 0
5067540 2376789 2376789 defendant Polker Richard husbandman 606922 606922 Polker, Richard, of Eynsham, husbandman 2
5557524 2522155 2522155 defendant Webbe John butcher 606922 606922 Webbe, John, of Eynsham, butcher 1
5557525 2522155 2522155 defendant Underwey Thomas   606922 606922 Underwey, Thomas, of Eynsham, wax chandler 2
5562455 2523621 2523621 defendant Maynard John laborer 606922 606922 Maynard, John, of Eynsham, laborer 0
5562456 2523621 2523621 defendant Nele John husbandman 606922 606922 Nele, John, of Eynsham, husbandman 1
5562457 2523621 2523621 defendant Deson Thomas husbandman 606922 606922 Deson, Thomas, of Eynsham, husbandman 2
5562460 2523622 2523622 defendant Meynard John laborer 606922 606922 Meynard, John, of Eynsham, laborer 0
5562461 2523622 2523622 defendant Nele John husbandman 606922 606922 Nele, John, of Eynsham, husbandman 1
5562462 2523622 2523622 defendant Deson Thomas husbandman 606922 606922 Deson, Thomas, of Eynsham, husbandman 2
5562463 2523622 2523622 defendant Maryot Richard tailor 606922 606922 Maryot, Richard, of Eynsham, tailor 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);