names

34 rows where place_id = 639658

✎ 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
3850221 1973660 1973660 defendant Bache William husbandman 639658 639658 Bache, William, of Fulmerston, husbandman 2
3868471 1979692 1979692 defendant Smyth Robert butcher 639658 639658 Smyth, Robert, of Fulmerston, butcher 0
4000400 2024911 2024911 defendant Tyndall William gent 639658 639658 Tyndall, William, of Fulmerston, gent 0
4017290 2030889 2030889 defendant Cobbe John yeoman 639658 639658 Cobbe, John, of Fulmerston, yeoman 0
4069049 2049221 2049221 defendant Cobb John yeoman 639658 639658 Cobb, John, of Fulmerston, yeoman 0
4404663 2166128 2166128 defendant Cobbe William yeoman 639658 639658 Cobbe, William, of Fulmerston, yeoman 1
4592536 2229018 2229018 defendant Taillour Geoffrey   639658 639658 Taillour, Geoffrey, of Fulmerston 0
4599753 2231144 2231144 defendant Wafyn John   639658 639658 Wafyn, John, of Fulmerston 0
4600075 2231252 2231252 defendant Barkere Geoffrey   639658 639658 Barkere, Geoffrey, of Fulmerston 1
4600082 2231253 2231253 defendant Barkere Geoffrey   639658 639658 Barkere, Geoffrey, of Fulmerston 1
4611354 2234611 2234611 defendant Bonde Thomas   639658 639658 Bonde, Thomas, of Fulmerston, parson 0
4611355 2234611 2234611 defendant Symond Thomas   639658 639658 Symond, Thomas, of fulmerston 1
4698147 2264908 2264908 defendant Bulman Geoffrey   639658 639658 Bulman, Geoffrey, of Fulmerston, plough man 0
4756969 2282548 2282548 defendant Wuorlyche Roger yeoman 639658 639658 Wuorlyche, Roger, of Fulmerston, yeoman 0
4966531 2346924 2346924 defendant Smyth Henry yeoman 639658 639658 Smyth, Henry, of Fulmerston, yeoman 0
4984859 2352399 2352399 defendant Ive Edmund husbandman 639658 639658 Ive, Edmund, of Fulmerston, husbandman 3
5013875 2360910 2360910 defendant Davy Thomas husbandman 639658 639658 Davy, Thomas, of Fulmerston, husbandman 0
5013876 2360910 2360910 defendant Leeman Thomas husbandman 639658 639658 Leeman, Thomas, of Fulmerston, husbandman 1
5013877 2360910 2360910 defendant Ive Edmund husbandman 639658 639658 Ive, Edmund, of Fulmerston, husbandman 2
5013878 2360910 2360910 defendant Schymyng John husbandman 639658 639658 Schymyng, John, of Fulmerston, husbandman 3
5052324 2372297 2372297 defendant Seman William butcher 639658 639658 Seman, William, of Fulmerston, butcher 0
5134953 2396724 2396724 defendant Tomson John clerk 639658 639658 Tomson, John, of Fulmerston, clerk 3
5155084 2402637 2402637 defendant Tomson John clerk & parson 639658 639658 Tomson, John, of Fulmerston, clerk & parson 2
5207022 2417790 2417790 defendant Tomson John clerk & parson 639658 639658 Tomson, John, of Fulmerston, clerk & parson 2
5233230 2425307 2425307 defendant Crumme John weaver 639658 639658 Crumme, John, of Fulmerston, weaver 0
5269227 2436105 2436105 defendant Seman William husbandman 639658 639658 Seman, William, of Fulmerston, husbandman 1
5271666 2436811 2436811 defendant Spruse Robert husbandman 639658 639658 Spruse, Robert, of Fulmerston, husbandman 0
5314194 2449259 2449259 defendant Hemmete or Emmete John husbandman 639658 639658 Hemmete or Emmete, John, of Fulmerston, husbandman 0
5323382 2452069 2452069 defendant Brake Thomas laborer 639658 639658 Brake, Thomas, of Fulmerston, laborer 1
5335037 2455547 2455547 defendant Brake John yeoman 639658 639658 Brake, John, of Fulmerston, yeoman 0
5335038 2455547 2455547 defendant Brake Thomas yeoman 639658 639658 Brake, Thomas, of Fulmerston, yeoman 1
5335456 2455674 2455674 defendant Brate John husbandman 639658 639658 Brate, John, of Fulmerston, husbandman 4
5515354 2509647 2509647 plaintiff Sharpe Henry clerk 639658 639658 Sharpe, Henry, of Fulmerston, clerk 0
5542991 2517927 2517927 defendant Boteler John husbandman 639658 639658 Boteler, John, of Fulmerston, husbandman 1

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);