names

46 rows where place_id = 608689

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631437 1904644 1904644 defendant Hokket John   608689 608689 Hokket, John, of Balydon, tile maker 3
3674952 1918196 1918196 plaintiff Gylbert Henry baker 608689 608689 Gylbert, Henry, of Balydon, baker 0
3713997 1930675 1930675 defendant Strete John sherman 608689 608689 Strete, John, of Balydon, sherman 1
3713998 1930675 1930675 defendant Peter John yeoman 608689 608689 Peter, John, of Balydon, yeoman 2
3718542 1932078 1932078 defendant Strete Thomas carpenter 608689 608689 Strete, Thomas, of Balydon, carpenter 1
3759915 1945094 1945094 defendant Courde John butcher 608689 608689 Courde, John, of Balydon, butcher 0
3781153 1951842 1951842 defendant Barbour John weaver 608689 608689 Barbour, John, of Balydon, weaver 1
3781613 1951987 1951987 defendant Lane John clothmaker 608689 608689 Lane, John, of Balydon, clothmaker 4
3789809 1954643 1954643 defendant Lane John clothmaker 608689 608689 Lane, John, of Balydon, clothmaker 0
3792034 1955360 1955360 defendant Curde John butcher 608689 608689 Curde, John, of Balydon, butcher 5
3805899 1959785 1959785 defendant Lane John clothmaker 608689 608689 Lane, John, of Balydon, clothmaker 0
3821391 1964585 1964585 defendant Lane John essex, fuller 608689 608689 Lane John, of Balydon, essex, fuller 2
3831884 1967865 1967865 defendant Harvy Simon pedder 608689 608689 Harvy, Simon, of Balydon, pedder 0
3831885 1967865 1967865 defendant Newman Robert pedder 608689 608689 Newman, Robert, of Balydon, pedder 1
3847353 1972733 1972733 defendant Harvy Simon pedder 608689 608689 Harvy, Simon, of Balydon, pedder 0
3848778 1973203 1973203 defendant Cookk Nicholas baker 608689 608689 Cookk, Nicholas, of Balydon, baker 0
3908761 1993225 1993225 defendant White Thomas   608689 608689 White, Thomas, of Balydon, wheelwright 0
3932555 2001176 2001176 defendant Cory Margaret widow 608689 608689 Cory, Margaret, of Balydon, widow 1
4708693 2268092 2268092 defendant Bryghtwell Alice single woman 608689 608689 Bryghtwell, Alice, of Balydon, single woman 0
4727395 2273815 2273815 defendant Hamylden William laborer 608689 608689 Hamylden, William, of Balydon, laborer 3
4763203 2284478 2284478 plaintiff Glover John   608689 608689 Glover, John, of Balydon 0
4763204 2284478 2284478 defendant Broun Roger laborer 608689 608689 Broun, Roger, of Balydon, laborer 0
4772870 2287486 2287486 defendant Broun Roger laborer 608689 608689 Broun, Roger, of Balydon, laborer 0
4786855 2291948 2291948 plaintiff Glover John   608689 608689 Glover, John, of Balydon 0
4786856 2291948 2291948 defendant Broun Roger laborer 608689 608689 Broun, Roger, of Balydon, laborer 0
4798137 2295610 2295610 defendant Broun Roger laborer 608689 608689 Broun, Roger, of Balydon, laborer 0
4800855 2296455 2296455 defendant Sextayn John butcher 608689 608689 Sextayn, John, of Balydon, butcher 2
4800859 2296456 2296456 defendant Wysebeche Simon weaver 608689 608689 Wysebeche, Simon, of Balydon, weaver 0
4800861 2296456 2296456 defendant Claryew William cordwainer 608689 608689 Claryew, William, of Balydon, cordwainer 2
4800862 2296456 2296456 defendant Sexteyn John butcher 608689 608689 Sexteyn, John, of Balydon, butcher 3
4951278 2342364 2342364 defendant Cutte Walter husbandman 608689 608689 Cutte, Walter, of Balydon, husbandman 2
4995597 2355521 2355521 defendant Stowre John   608689 608689 Stowre, John, of Balydon, lime burner 0
5016650 2361760 2361760 defendant Coursy Peter   608689 608689 Coursy, Peter, of Balydon, lime burner 0
5016651 2361760 2361760 defendant Wryghte Robert yeoman 608689 608689 Wryghte, Robert, of Balydon, yeoman 1
5016652 2361760 2361760 defendant Melford Roger carpenter 608689 608689 Melford, Roger, of Balydon, carpenter 2
5016653 2361760 2361760 defendant Prynce John smith 608689 608689 Prynce, John, of Balydon, smith 3
5060513 2374723 2374723 defendant Cowser Peter yeoman 608689 608689 Cowser, Peter, of Balydon, yeoman 2
5073046 2378424 2378424 defendant Herward John yeoman 608689 608689 Herward, John, of Balydon, yeoman 1
5073047 2378424 2378424 defendant Bardewell William   608689 608689 Bardewell, William, of Balydon, lime burner 2
5197717 2415076 2415076 defendant Hereward William   608689 608689 Hereward, William, of Balydon, breke maker or brick maker 0
5250431 2430244 2430244 defendant Nutson John husbandman 608689 608689 Nutson, John, of Balydon, husbandman 2
5250432 2430244 2430244 defendant Prynce Thomas husbandman 608689 608689 Prynce, Thomas, of Balydon, husbandman 3
5266899 2435398 2435398 defendant Stowere John, senior   608689 608689 Stowere, John, senior, of Balydon, lime burner 0
5266900 2435398 2435398 defendant Stowere John, junior husbandman 608689 608689 Stowere, John, junior, of Balydon, husbandman 1
5284028 2440350 2440350 defendant Semer Nicholas husbandman 608689 608689 Semer, Nicholas, of Balydon, husbandman 3
5631204 2553767 2553767 defendant Inglond Thomas weaver 608689 608689 Inglond, Thomas, of Balydon, weaver 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);