names

33 rows where place_id = 636884

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3833226 1968323 1968323 plaintiff Langerege John   636884 636884 Langerege, John, of Est Grensted, Sussex 0
3904269 1991673 1991673 plaintiff Hasilden Edward yeoman 636884 636884 Hasilden, Edward, of Est Grensted, Sussex, yeoman 0
3907340 1992744 1992744 plaintiff Page William yeoman 636884 636884 Page, William, of Est Grensted, Sussex, yeoman 0
3907342 1992745 1992745 plaintiff Page William yeoman 636884 636884 Page, William, of Est Grensted, Sussex, yeoman 0
3946399 2005812 2005812 defendant Parke John clothier 636884 636884 Parke, John, of Est Grensted, Sussex, clothier 0
3952712 2008019 2008019 plaintiff Homwood John   636884 636884 Homwood, John, of Est Grensted, Sussex 0
3982557 2018536 2018536 defendant Ellys Thomas yeoman 636884 636884 Ellys, Thomas, of Est Grensted, Sussex, yeoman 0
3985133 2019435 2019435 defendant Pykes James gent 636884 636884 Pykes, James, of Est Grensted, Sussex, gent 0
4003207 2025908 2025908 plaintiff Holte Thomas   636884 636884 Holte, Thomas, of Est Grensted, Sussex, notary public 0
4092057 2057455 2057455 defendant Browne Lawrence yeoman 636884 636884 Browne, Lawrence, of Est Grensted, Sussex, yeoman 0
4093186 2057879 2057879 defendant Lyntate Richard chapman 636884 636884 Lyntate, Richard, of Est Grensted, Sussex, chapman 1
4174823 2086662 2086662 defendant Bottynge John yeoman 636884 636884 Bottynge, John, of Est Grensted, Sussex, yeoman 0
4229042 2105640 2105640 defendant Ellice William yeoman 636884 636884 Ellice, William, of Est Grensted, Sussex, yeoman 1
4246126 2111684 2111684 defendant Ellice William yeoman 636884 636884 Ellice, William, of Est Grensted, Sussex, yeoman 1
4301556 2130662 2130662 defendant Ward Edmund gent 636884 636884 Ward, Edmund, of Est Grensted, Sussex, gent 0
4324839 2138695 2138695 defendant Praye Hugh hammerman 636884 636884 Praye, Hugh, of Est Grensted, Sussex, hammerman 0
4334147 2141699 2141699 defendant Plawe John husbandman 636884 636884 Plawe, John, of Est Grensted, Sussex, husbandman 2
4665277 2250628 2250628 defendant Tykereg John husbandman 636884 636884 Tykereg, John, of Est Grensted, Sussex, husbandman 0
4804259 2297517 2297517 defendant Joop Nicholas gent 636884 636884 Joop, Nicholas, of East Grensted, Sussex, gent 0
4846536 2310424 2310424 defendant Isop Nicholas gent 636884 636884 Isop, Nicholas, of East Grensted, Sussex, gent 2
4851311 2311857 2311857 defendant Joop Nicholas   636884 636884 Joop, Nicholas, of East Grensted, Sussex 0
4897588 2325908 2325908 defendant Jopp Nicholas gent 636884 636884 Jopp, Nicholas, of Est Grensted, Sussex, gent 0
4926212 2334620 2334620 defendant Maldon Richard .chapman 636884 636884 Maldon, Richard, of East Grensted, Sussex,.chapman 4
4996877 2355925 2355925 defendant Candelesby John clerk 636884 636884 Candelesby, John, of East Grensted, Sussex, clerk 0
5037630 2367881 2367881 defendant Scras Richard husbandman 636884 636884 Scras, Richard, of Est Grensted, Sussex, husbandman 2
5137339 2397434 2397434 defendant Thomas William smith 636884 636884 Thomas, William, of East Grensted, Sussex, smith 3
5142086 2398805 2398805 defendant Lewkenore John esq 636884 636884 Lewkenore, John, of East Grensted, sussex, esq 3
5154215 2402389 2402389 defendant Lewekenore John esq 636884 636884 Lewekenore, John, of East Grensted, Sussex, esq 0
5253549 2431217 2431217 defendant Modell William husbandman 636884 636884 Modell, William, of Est Grensted, Sussex, husbandman 0
5303005 2445889 2445889 defendant Boteler John yeoman 636884 636884 Boteler, John, of East Grensted, Sussex, yeoman 1
5305498 2446647 2446647 defendant Alfrey Richard gent 636884 636884 Alfrey, Richard, of East Grensted, Sussex, gent 0
5311910 2448589 2448589 defendant Alfray Richard gent 636884 636884 Alfray, Richard, of Est Grensted, Sussex, gent 0
5582993 2529755 2529755 defendant Duffeld Henry tanner 636884 636884 Duffeld, Henry, of Est Grensted, Sussex, tanner 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);