names

39 rows where place_id = 775389

✎ 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
4622468 2238009 2238009 defendant Godiston John   775389 775389 Godiston, John, of Reynham, Essex 0
4688326 2261917 2261917 defendant Godeston John esq 775389 775389 Godeston, John, of Reynham, Essex, esq 0
4688421 2261946 2261946 defendant Godeston John esq 775389 775389 Godeston, John, of Reynham, Essex, esq 0
4705924 2267230 2267230 defendant Wilby William   775389 775389 Wilby, William, of Reynham, Essex, vicar 0
4737016 2276705 2276705 defendant Godeston John esq 775389 775389 Godeston, John, of Reynham, Essex, esq 0
4744932 2279032 2279032 defendant Godeston John merchant & custumer or customs collector of Ipswich 775389 775389 Godeston, John, of Reynham, Essex, merchant & custumer or customs collector of Ipswich 0
4757297 2282656 2282656 defendant Godiston John esq 775389 775389 Godiston, John, of Reynham, Essex, esq 2
4772493 2287360 2287360 defendant Bodston John gent 775389 775389 Bodston, John, of Reynham, Essex, gent 0
4776314 2288585 2288585 defendant Godston John gent 775389 775389 Godston, John, of Reynham, Essex, gent 2
4776318 2288586 2288586 defendant Godston John gent 775389 775389 Godston, John, of Reynham, Essex, gent 2
4782627 2290580 2290580 defendant Godston John gent 775389 775389 Godston, John, of Reynham, Essex, gent 1
4792977 2293895 2293895 defendant Godston John gent 775389 775389 Godston, John, of Reynham, Essex, gent 2
4792981 2293896 2293896 defendant Godston John gent 775389 775389 Godston, John, of Reynham, Essex, gent 2
4801392 2296623 2296623 defendant Godston John husbandman 775389 775389 Godston, John, of Reynham, Essex, husbandman 0
4801410 2296625 2296625 defendant Godston John husbandman 775389 775389 Godston, John, of Reynham, Essex, husbandman 0
4803486 2297277 2297277 defendant Godiston John gent 775389 775389 Godiston, John, of Reynham, Essex, gent 0
4890582 2323813 2323813 defendant Godston John esq 775389 775389 Godston, John, of Reynham, Essex, esq 0
4893154 2324576 2324576 defendant Godston John esq 775389 775389 Godston, John, of Reynham, Essex, esq 0
4899358 2326438 2326438 defendant Godston John esq 775389 775389 Godston, John, of Reynham, Essex, esq 0
4920893 2333048 2333048 defendant Dukwra John chaplain 775389 775389 Dukwra, John, of Reynham, Essex, chaplain 0
5122382 2392973 2392973 defendant Wade John husbandman 775389 775389 Wade, John, of Reynham, Essex, husbandman 0
5125645 2393989 2393989 defendant Neweman William husbandman 775389 775389 Neweman, William, of Reynham, Essex, husbandman 3
5157376 2403293 2403293 defendant Lelye John husbandman 775389 775389 Lelye, John, of Reynham, Essex, husbandman 3
5157999 2403463 2403463 defendant Huwet John waterman 775389 775389 Huwet, John, of Reynham, Essex, waterman 2
5159226 2403816 2403816 defendant Feld Richard de la esq 775389 775389 Feld, Richard de la, of Reynham, Essex, esq 0
5159229 2403817 2403817 defendant Feld Richard de la esq 775389 775389 Feld, Richard de la, of Reynham, Essex, esq 0
5174445 2408228 2408228 defendant Feld Richard de la esq 775389 775389 Feld, Richard de la, of Reynham, Essex, esq 0
5174448 2408229 2408229 defendant Feld Richard de la esq 775389 775389 Feld, Richard de la, of Reynham, Essex, esq 0
5199022 2415465 2415465 defendant Feld Richard de la esq 775389 775389 Feld, Richard de la, of Reynham, Essex, esq 0
5210888 2418917 2418917 defendant Feld Richard de la esq 775389 775389 Feld, Richard de la, of Reynham, Essex, esq 0
5210890 2418918 2418918 defendant Laffeld Richard de esq 775389 775389 Laffeld, Richard de, of Reynham, Essex, esq 0
5438998 2486585 2486585 defendant Wattes John husbandman 775389 775389 Wattes, John, of Reynham, Essex, husbandman 2
5439010 2486587 2486587 defendant Wattes John husbandman 775389 775389 Wattes, John, of Reynham, Essex, husbandman 2
5452899 2490746 2490746 defendant Wattes John husbandman 775389 775389 Wattes, John, of Reynham, Essex, husbandman 1
5452904 2490747 2490747 defendant Wattes John husbandman 775389 775389 Wattes, John, of Reynham, Essex, husbandman 1
5477494 2498283 2498283 defendant Godstone William gent 775389 775389 Godstone, William, of Reynham, Essex, gent 0
5529820 2513836 2513836 defendant Bukke James laborer 775389 775389 Bukke, James, of Reynham, Essex, laborer 0
5529823 2513837 2513837 defendant Bukke James laborer 775389 775389 Bukke, James, of Reynham, Essex, laborer 0
5590415 2531973 2531973 defendant Damyon Thomas husbandman 775389 775389 Damyon, Thomas, of Reynham, Essex, husbandman 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);