names

34 rows where place_id = 600632

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641855 1907902 1907902 defendant Chapman Thomas husbandman 600632 600632 Chapman, Thomas, of Wrotham, Kent, husbandman 0
3641862 1907905 1907905 defendant Chapman Thomas husbandman 600632 600632 Chapman, Thomas, of Wrotham, Kent, husbandman 1
3646109 1909183 1909183 defendant Doge Richard potter 600632 600632 Doge, Richard, of Wrotham, Kent, potter 0
3786345 1953517 1953517 defendant Cook Thomas yeoman 600632 600632 Cook, Thomas, of Wrotham, Kent, yeoman 2
3786352 1953518 1953518 defendant Cooke Thomas yeoman 600632 600632 Cooke, Thomas, of Wrotham, Kent, yeoman 2
3794434 1956133 1956133 defendant Myller Richard yeoman 600632 600632 Myller, Richard, of Wrotham, Kent, yeoman 2
3975899 2016134 2016134 defendant Chowne Richard chapman 600632 600632 Chowne, Richard, of Wrotham, Kent, chapman 1
4102584 2061223 2061223 defendant Peckham James esq 600632 600632 Peckham, James, of Wrotham, Kent, esq 0
4186008 2090594 2090594 defendant Woodgate Edward clothier 600632 600632 Woodgate, Edward, of Wrotham, Kent, clothier 0
4208678 2098585 2098585 defendant Brysenden Thomas miller 600632 600632 Brysenden, Thomas, of Wrotham, Kent, miller 0
4262882 2117253 2117253 defendant Cornforde John   600632 600632 Cornforde, John, of Wrotham, Kent, yeoman, his brother 1
4263256 2117377 2117377 defendant Cornforde John   600632 600632 Cornforde, John, of Wrotham, Kent, yeoman, his brother 1
4322937 2138087 2138087 defendant Cornforde John brother of Robert 600632 600632 Cornforde, John, of Wrotham, Kent, yeoman, brother of Robert 0
4325679 2138966 2138966 defendant Cartwright Peter skinner 600632 600632 Cartwright, Peter, of Wrotham, Kent, or of London, skinner 0
4363623 2152062 2152062 defendant Crude Thomas yeoman 600632 600632 Crude, Thomas, of Wrotham, Kent, yeoman 0
4603387 2232251 2232251 defendant Barbour Thomas   600632 600632 Barbour, Thomas, of Wrotham, Kent 0
4603416 2232257 2232257 defendant Barbour Thomas   600632 600632 Barbour, Thomas, of Wrotham, Kent 0
4608374 2233730 2233730 defendant Godwyne Andrew   600632 600632 Godwyne, Andrew, of Wrotham, Kent 2
4668917 2255981 2255981 defendant Barbour Thomas husbandman 600632 600632 Barbour, Thomas, of Wrotham, Kent, husbandman 0
4689040 2262130 2262130 defendant Barbour Thomas yeoman 600632 600632 Barbour, Thomas, of Wrotham, Kent, yeoman 1
4796524 2295069 2295069 defendant Kyng John husbandman 600632 600632 Kyng, John, of Wrotham, Kent, husbandman 0
4951254 2342358 2342358 defendant Wolf Nicholas yeoman 600632 600632 Wolf, Nicholas, of Wrotham, Kent, yeoman 0
5016289 2361655 2361655 defendant Pagrave John chapman 600632 600632 Pagrave, John, of Wrotham, Kent, chapman 0
5020176 2362790 2362790 defendant Pekham Reginald esq 600632 600632 Pekham, Reginald, of Wrotham, Kent, esq 1
5052730 2372413 2372413 defendant Pekham Reginald esq 600632 600632 Pekham, Reginald, of Wrotham, Kent, esq 1
5052735 2372414 2372414 defendant Pekham Reginald esq 600632 600632 Pekham, Reginald, of Wrotham, Kent, esq 1
5087760 2382804 2382804 defendant Pekham Reginald esq 600632 600632 Pekham, Reginald, of Wrotham, Kent, esq 2
5094207 2384711 2384711 defendant Pe- Reginald esq 600632 600632 Pe-, Reginald, of Wrotham, Kent, esq 0
5293506 2443071 2443071 defendant Gange or Gauge Adam yeoman 600632 600632 (Gange or Gauge, Adam, of Wrotham, Kent, yeoman 1
5293510 2443072 2443072 defendant Gange or Gauge Adam yeoman 600632 600632 (Gange or Gauge, Adam, of Wrotham, Kent, yeoman 1
5528063 2513341 2513341 defendant Hert James husbandman 600632 600632 Hert, James, of Wrotham, Kent, husbandman 1
5549016 2519748 2519748 defendant Miller Richard husbandman 600632 600632 Miller, Richard, of Wrotham, Kent, husbandman 0
5580550 2529001 2529001 defendant Hart James   600632 600632 Hart, James, of Wrotham, Kent 2
5618916 2549758 2549758 defendant Cayly Hugh   600632 600632 Cayly, Hugh, of Wrotham, Kent 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);