names

37 rows where place_id = 613672

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3699701 1926132 1926132 defendant Turnour John husbandman 613672 613672 Turnour, John, of Cradley, husbandman 0
3786823 1953675 1953675 defendant Jones William husbandman 613672 613672 Jones, William, of Cradley, husbandman 0
3960749 2010861 2010861 defendant Arundell John yeoman 613672 613672 Arundell, John, of Cradley, yeoman 0
3971505 2014593 2014593 defendant Holland Thomas laborer 613672 613672 Holland, Thomas, of Cradley, laborer 1
3996566 2023531 2023531 defendant Stroude or Stronde Thomas husbandman 613672 613672 Stroude or Stronde, Thomas, of Cradley, husbandman 0
3996568 2023532 2023532 defendant Wooddyett Richard yeoman 613672 613672 Wooddyett, Richard, of Cradley, yeoman 0
4039093 2038608 2038608 defendant Mauncell Robert yeoman 613672 613672 Mauncell, Robert, of Cradley, yeoman, son of William Mauncell, of Cradley, yeoman 0
4055908 2044494 2044494 defendant Nokes or Noxe Richard husbandman or yeoman 613672 613672 Nokes or Noxe, Richard, of Cradley, husbandman or yeoman 0
4122983 2068518 2068518 defendant Barrett Roland husbandman 613672 613672 Barrett, Roland, of Cradley, husbandman 2
4122984 2068518 2068518 defendant Yate James husbandman 613672 613672 Yate, James, of Cradley, husbandman 3
4122988 2068519 2068519 defendant Barrett Roland husbandman 613672 613672 Barrett, Roland, of Cradley, husbandman 2
4122989 2068519 2068519 defendant Yate James husbandman 613672 613672 Yate, James, of Cradley, husbandman 3
4138890 2074282 2074282 defendant Maunsell Robert husbandman 613672 613672 Maunsell, Robert, of Cradley, husbandman 0
4143343 2075835 2075835 defendant Trovell Richard   613672 613672 Trovell, Richard, of Cradley gent 0
4159638 2081439 2081439 defendant Trobell or Trovell Richard gent 613672 613672 Trobell or Trovell, Richard, of Cradley, gent 0
4171662 2085555 2085555 defendant Hill William husbandman 613672 613672 Hill, William, of Cradley, husbandman 0
4171663 2085555 2085555 defendant Hussye Simon husbandman 613672 613672 Hussye, Simon, of Cradley, husbandman 1
4220112 2102535 2102535 defendant Pichard Richard gent 613672 613672 Pichard, Richard, of Cradley, gent 1
4240104 2109663 2109663 defendant Pytchard William gent 613672 613672 Pytchard, William, of Cradley, gent 0
4248360 2112443 2112443 defendant Pytcherd William gent 613672 613672 Pytcherd, William, of Cradley, gent 0
4257673 2115540 2115540 defendant Pytcher William gent 613672 613672 Pytcher, William, of Cradley, gent 0
4295509 2128478 2128478 defendant Palmer William yeoman 613672 613672 Palmer, William, of Cradley, yeoman 3
4300461 2130260 2130260 defendant Myntridge James gent 613672 613672 Myntridge, James, of Cradley, gent 0
4322967 2138096 2138096 defendant Barrett Roland husbandman 613672 613672 Barrett, Roland, of Cradley, husbandman 1
4322969 2138096 2138096 defendant Pichard Joseph gent 613672 613672 Pichard, Joseph, of Cradley, ,gent 3
4383300 2159128 2159128 defendant Hill Edmund yeoman 613672 613672 Hill, Edmund, of Cradley, yeoman 0
4410010 2167954 2167954 defendant Myntridge James gent 613672 613672 Myntridge, James, of Cradley, gent 1
4411917 2168579 2168579 defendant Pichard William gent 613672 613672 Pichard, William, of Cradley, gent 0
4773968 2287840 2287840 defendant Pleyston Nicholas husbandman 613672 613672 Pleyston, Nicholas, of Cradley, husbandman 0
4860890 2314763 2314763 defendant Estnore Thomas ploughman 613672 613672 Estnore, Thomas, of Cradley, ploughman 0
5028623 2365249 2365249 defendant Nassh John husbandman 613672 613672 Nassh, John, of Cradley, husbandman 4
5135024 2396740 2396740 defendant Came Thomas   613672 613672 Came, Thomas, of Cradley, shoe maker 3
5146970 2400254 2400254 defendant Hyll John gent 613672 613672 Hyll, John, of Cradley, gent 0
5350447 2460262 2460262 defendant Longe William husbandman 613672 613672 Longe, William, of Cradley, husbandman 1
5350448 2460262 2460262 defendant Hall John yeoman 613672 613672 Hall, John, of Cradley, yeoman 2
5350449 2460262 2460262 defendant Colyns John husbandman 613672 613672 Colyns, John, of Cradley, husbandman 3
5425206 2482507 2482507 defendant Whelar William husbandman 613672 613672 Whelar, William, of Cradley, 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);