names

34 rows where place_id = 600388

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640839 1907580 1907580 defendant Knyghtbreg William laborer 600388 600388 Knyghtbreg, William, of Downham, laborer 0
3640840 1907580 1907580 defendant Clerke Robert laborer 600388 600388 Clerke, Robert, of Downham, laborer 1
3640841 1907580 1907580 defendant Knyghtbrege John yeoman 600388 600388 Knyghtbrege, John, of Downham, yeoman 2
3640843 1907581 1907581 defendant Knyghtbregge John yeoman 600388 600388 Knyghtbregge, John, of Downham, yeoman 0
3640845 1907581 1907581 defendant Clerk Robert laborer 600388 600388 Clerk, Robert, of Downham, laborer 2
3678511 1919338 1919338 defendant Boon John husbandman 600388 600388 Boon, John, of Downham, husbandman 0
3722203 1933203 1933203 defendant Losthowsse Christopher husbandman 600388 600388 Losthowsse, Christopher, of Downham, husbandman 1
3800726 1958139 1958139 defendant Marys John laborer 600388 600388 Marys, John, of Downham, laborer 3
3813318 1962076 1962076 defendant Castyng William slater 600388 600388 Castyng, William, of Downham, slater 0
3813319 1962076 1962076 defendant Wolman John slater 600388 600388 Wolman, John, of Downham, slater 1
3813321 1962076 1962076 defendant Nottyng John roper 600388 600388 Nottyng, John, of Downham, roper 3
3813322 1962076 1962076 defendant Pottrell Thomas husbandman 600388 600388 Pottrell, Thomas, of Downham, husbandman 4
3821518 1964626 1964626 plaintiff Scheryng Henry   600388 600388 Scheryng, Henry, of Downham 0
3865078 1978523 1978523 plaintiff Megges Thomas esq 600388 600388 Megges, Thomas, of Downham, esq 0
3991166 2021599 2021599 plaintiff Bownett William   600388 600388 Bownett, William, of Downham 0
4129376 2070809 2070809 defendant Maltnard Thomas yeoman 600388 600388 (Maltnard, Thomas, of Downham, yeoman 1
4139719 2074568 2074568 defendant Style Richard yeoman 600388 600388 Style, Richard, of Downham, yeoman 1
4164505 2083102 2083102 defendant Style Richard yeoman 600388 600388 Style, Richard, of Downham, yeoman 1
4186355 2090714 2090714 defendant Parlett William draper 600388 600388 Parlett, William, of Downham, draper 0
4192664 2092992 2092992 defendant Malyns William goldsmith 600388 600388 Malyns, William, of Downham, goldsmith 0
4192665 2092992 2092992 defendant Weeche Richard shoemaker 600388 600388 Weeche, Richard, of Downham, shoemaker 1
4192666 2092992 2092992 defendant Goddisman William glover 600388 600388 Goddisman, William, of Downham, glover 2
4193593 2093328 2093328 defendant Gilbert Robert tailor 600388 600388 Gilbert, Robert, of Downham, tailor 1
4193594 2093328 2093328 defendant Egeley Robert tailor 600388 600388 Egeley, Robert, of Downham, tailor 2
4234821 2107730 2107730 defendant Crowne John yeoman 600388 600388 Crowne, John, of Downham, yeoman 1
4246909 2111940 2111940 defendant Fludd James clerk 600388 600388 Fludd, James, of Downham, clerk 0
4246912 2111941 2111941 defendant Fludd James clerk 600388 600388 Fludd, James, of Downham, clerk 0
4284923 2124656 2124656 defendant Parker Henry yeoman 600388 600388 Parker, Henry, of Downham, yeoman 2
4289629 2126358 2126358 defendant Bugge Nicholas yeoman 600388 600388 Bugge, Nicholas, of Downham, yeoman 1
4295456 2128462 2128462 defendant Kaye or Keye Robert yeoman 600388 600388 Kaye or Keye, Robert, of Downham, or of Cambridge, yeoman 1
4330117 2140372 2140372 defendant Barrett Edward yeoman 600388 600388 Barrett, Edward, of Downham, yeoman 2
4347377 2146337 2146337 defendant Bretton Thomas clerk 600388 600388 Bretton, Thomas, of Downham, clerk 1
5076428 2379449 2379449 defendant Lucas John husbandman 600388 600388 Lucas, John, of Downham, husbandman 2
5358407 2462681 2462681 defendant Scotyn Thomas baker 600388 600388 Scotyn, Thomas, of Downham, baker 3

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