names

35 rows where place_id = 629637

✎ 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
3789481 1954535 1954535 defendant Percy John merchant 629637 629637 Percy, John, of Whitby, Yorks, merchant 0
3856899 1975789 1975789 defendant Mydylwoode Roger gent 629637 629637 Mydylwoode, Roger, of Whitby, Yorks, gent 1
4122061 2068192 2068192 defendant Wilson Mathew merchant 629637 629637 Wilson, Mathew, of Whitby, Yorks, merchant 0
4129648 2070912 2070912 defendant Wilson Mathew merchant 629637 629637 Wilson, Mathew, of Whitby, Yorks, merchant 0
4129650 2070913 2070913 defendant Wylson Mathew merchant 629637 629637 Wylson, Mathew, of Whitby, Yorks, merchant 0
4139403 2074454 2074454 defendant Howe Robert chapman 629637 629637 Howe, Robert, of Whitby, Yorks, chapman 0
4177486 2087600 2087600 defendant Wilson Mathew merchant 629637 629637 Wilson, Mathew, of Whitby, Yorks, merchant 0
4273194 2120596 2120596 defendant Hutton William yeoman 629637 629637 Hutton, William, of Whitby, Yorks, yeoman 0
4347407 2146348 2146348 defendant Cholmeley Henry esq 629637 629637 Cholmeley, Henry, of Whitby, Yorks, esq 0
4347409 2146349 2146349 defendant Boyes George yeoman 629637 629637 Boyes, George, of Whitby, Yorks, yeoman 0
4348112 2146585 2146585 defendant Cholmeley Henry esq 629637 629637 Cholmeley, Henry, of Whitby, Yorks, esq 0
4401065 2164949 2164949 defendant Bore Nicholas yeoman 629637 629637 Bore, Nicholas, of Whitby, Yorks, yeoman 1
4669421 2256143 2256143 defendant Draper Alan draper 629637 629637 Draper, Alan, of Whitby, Yorks, draper 0
4685057 2260925 2260925 defendant Maltby John mariner 629637 629637 Maltby, John, of Whitby, Yorks, mariner 0
4720003 2271602 2271602 defendant Nesteveld Henry gent 629637 629637 Nesteveld, Henry, of Whitby, Yorks, gent 1
4809317 2299088 2299088 defendant Gower William   629637 629637 Gower, William, of Whitby, Yorks, burgeess & merchant 0
4843541 2309501 2309501 defendant Crate Richard yeoman 629637 629637 Crate, Richard, of Whitby, Yorks, yeoman 2
4844620 2309837 2309837 defendant Husy John gent 629637 629637 together with Husy, John, of Whitby, Yorks, gent 3
4861934 2315110 2315110 defendant Barker Thomas gent 629637 629637 Barker, Thomas, of Whitby, Yorks, gent 1
4896475 2325566 2325566 defendant Gower William merchant 629637 629637 Gower, William, of Whitby, Yorks, merchant 0
4897191 2325775 2325775 defendant Nesfeld or Neffeld Henry esq 629637 629637 Nesfeld or Neffeld, Henry, of Whitby, Yorks, esq 2
4901830 2327179 2327179 defendant Nesfeld or Neffeld Henry esq 629637 629637 Nesfeld or Neffeld, Henry, of Whitby, Yorks, esq 2
4935119 2337392 2337392 defendant Marchall John yeoman 629637 629637 Marchall, John, of Whitby, Yorks, yeoman 1
4942239 2339562 2339562 defendant Andrewe Robert chapman 629637 629637 Andrewe, Robert, of Whitby, Yorks, chapman 0
4942241 2339563 2339563 defendant Andrewe Robert chapman 629637 629637 Andrewe, Robert, of Whitby, Yorks, chapman 0
4951478 2342421 2342421 defendant Neffeld or Nesfeld Henry gent 629637 629637 Neffeld or Nesfeld, Henry, of Whitby, Yorks, gent 0
4951480 2342422 2342422 defendant Neffeld or Nesfeld Henry gent 629637 629637 Neffeld or Nesfeld, Henry, of Whitby, Yorks, gent 0
4955561 2343624 2343624 defendant Marsshall John merchant 629637 629637 Marsshall, John, of Whitby, Yorks, merchant 0
4968697 2347604 2347604 defendant Marshall Robert merchant 629637 629637 Marshall, Robert, of Whitby, Yorks, merchant 0
4989300 2353732 2353732 defendant Barker Thomas gent 629637 629637 Barker, Thomas, of Whitby, Yorks, gent 0
4991936 2354477 2354477 defendant Barker Thomas gent 629637 629637 Barker, Thomas, of Whitby, Yorks, gent 0
4997668 2356159 2356159 defendant Andrewe Robert mariner 629637 629637 Andrewe, Robert, of Whitby, Yorks, mariner 0
5046287 2370520 2370520 defendant Andrewe Robert mariner 629637 629637 Andrewe, Robert, of Whitby, Yorks, mariner 3
5629363 2553163 2553163 defendant Nethyrton John carver 629637 629637 Nethyrton, John, of Whitby, Yorks, carver 0
5629366 2553164 2553164 defendant Nethirton John carver 629637 629637 Nethirton, John, of Whitby, Yorks, carver 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);