names

38 rows where place_id = 600001

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639262 1907090 1907090 defendant Bulbroke Thomas mercer 600001 600001 Bulbroke, Thomas, of Harlowe, Essex, mercer 0
3673257 1917650 1917650 defendant Malery Giles gent 600001 600001 Malery, Giles, of Harlowe, Essex, gent 0
3859089 1976529 1976529 defendant Bugges Edward gent 600001 600001 Bugges, Edward, of Harlowe, Essex, gent 2
3898904 1989837 1989837 defendant Campyon Edward yeoman 600001 600001 Campyon, Edward, of Harlowe, Essex, yeoman 0
3914069 1995050 1995050 defendant Campyon Edward gent 600001 600001 Campyon, Edward, of Harlowe, Essex, gent 0
3943725 2004918 2004918 defendant Tornor Thomas tailor 600001 600001 Tornor, Thomas, of Harlowe, Essex, tailor 1
4134075 2072514 2072514 defendant Shoublard Thomas tailor 600001 600001 Shoublard, Thomas, of Harlowe, Essex, tailor 1
4354734 2148881 2148881 defendant Addames Thomas chapman 600001 600001 Addames, Thomas, of Harlowe, Essex, chapman 3
4354750 2148884 2148884 defendant Adams Thomas chapman 600001 600001 Adams, Thomas, of Harlowe, Essex, chapman 1
4898508 2326184 2326184 defendant Dobbys John husbandman 600001 600001 Dobbys, John, of Harlowe, Essex, husbandman 0
4905718 2328388 2328388 defendant Dobbys John husbandman 600001 600001 Dobbys, John, of Harlowe, Essex, husbandman 0
4988156 2353434 2353434 defendant Gladwyn John butcher 600001 600001 Gladwyn, John, of Harlowe, Essex, butcher 0
5055710 2373277 2373277 defendant Gladwyn John husbandman 600001 600001 Gladwyn, John, of Harlowe, Essex, husbandman 0
5070708 2377734 2377734 defendant Gladwyn Nicholas butcher 600001 600001 Gladwyn, Nicholas, of Harlowe, Essex, butcher 1
5104764 2387831 2387831 defendant Parker John chapman 600001 600001 Parker, John, of Harlowe, Essex, chapman 4
5190979 2413106 2413106 defendant Purfote John yeoman 600001 600001 Purfote, John, of Harlowe, Essex, yeoman 4
5246805 2429230 2429230 defendant Swerder William husbandman 600001 600001 Swerder, William, of Harlowe, Essex, husbandman 1
5246808 2429231 2429231 defendant Swerder William husbandman 600001 600001 Swerder, William, of Harlowe, Essex, husbandman 1
5252678 2430950 2430950 defendant Sewall Thomas gent 600001 600001 Sewall, Thomas, of Harlowe, Essex, gent 0
5255558 2431856 2431856 defendant Swerder Henry butcher 600001 600001 Swerder, Henry, of Harlowe, Essex, butcher 1
5279832 2439183 2439183 defendant Bullebroke John chapman 600001 600001 Bullebroke, John, of Harlowe, Essex, chapman 1
5279838 2439184 2439184 defendant Bullebroke John chapman 600001 600001 Bullebroke, John, of Harlowe, Essex, chapman 1
5287038 2441218 2441218 defendant Bulbroke John chapman 600001 600001 Bulbroke, John, of Harlowe, Essex, chapman 2
5287043 2441219 2441219 defendant Bulbroke John chapman 600001 600001 Bulbroke, John, of Harlowe, Essex, chapman 1
5304149 2446248 2446248 defendant Grene John tailor 600001 600001 Grene, John, of Harlowe, Essex, tailor 4
5385346 2470885 2470885 defendant Thorogoode William husbandman 600001 600001 Thorogoode, William, of Harlowe, Essex, husbandman 0
5397411 2474345 2474345 defendant Thurogode William husbandman 600001 600001 Thurogode, William, of Harlowe, Essex, husbandman 0
5443321 2487921 2487921 defendant Th_ William husbandman 600001 600001 Th_, William, of Harlowe, Essex, husbandman 0
5467547 2495224 2495224 defendant Proudefote John husbandman 600001 600001 Proudefote, John, of Harlowe, Essex, husbandman 0
5512772 2508848 2508848 defendant Fordell John husbandman 600001 600001 Fordell, John, of Harlowe, Essex, husbandman 4
5517921 2510448 2510448 defendant Pryklove John butcher 600001 600001 Pryklove, John, of Harlowe, Essex, butcher 2
5556902 2521976 2521976 defendant Prentys John maltman 600001 600001 Prentys, John, of Harlowe, Essex, maltman 0
5559773 2522816 2522816 defendant Chauncy William gent 600001 600001 Chauncy, William, of Harlowe, Essex, gent 0
5567218 2524988 2524988 defendant Kyng John husbandman 600001 600001 (Kyng, John, of Harlowe, Essex, husbandman 5
5583325 2529856 2529856 defendant Buggys Edward gent 600001 600001 Buggys, Edward, of Harlowe, Essex, gent 1
5599280 2534656 2534656 defendant Purfote John yeoman 600001 600001 Purfote, John, of Harlowe, Essex, yeoman 0
5599283 2534657 2534657 defendant Purfote John yeoman 600001 600001 Purfote, John, of Harlowe, Essex, yeoman 0
5599286 2534658 2534658 defendant Purfote John yeoman 600001 600001 Purfote, John, of Harlowe, Essex, yeoman 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);