names

30 rows where place_id = 668135

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3987928 2020428 2020428 defendant Kynge John yeoman 668135 668135 Kynge, John, of Islington, yeoman 0
4007087 2027312 2027312 defendant Harbarowe German yeoman 668135 668135 Harbarowe, German, of Islington, yeoman 1
4007090 2027313 2027313 defendant Harbarowe German yeoman 668135 668135 Harbarowe, German, of Islington, yeoman 1
4023598 2033150 2033150 defendant Flood Lewis innkeeper 668135 668135 Flood, Lewis, of Islington, innkeeper 0
4023599 2033150 2033150 defendant Evans John carpenter 668135 668135 Evans, John, of Islington, or of Clompnar Lane, carpenter 1
4059775 2045891 2045891 plaintiff Cottyngham William yeoman 668135 668135 Cottyngham, William, of Islington, yeoman 0
4081572 2053714 2053714 defendant Randall Wolstan   668135 668135 Randall, Wolstan, of Islington, Middx gent 3
4111299 2064289 2064289 defendant Greves William clerk 668135 668135 Greves, William, of Islington, clerk 0
4115755 2065916 2065916 defendant Flory William yeoman 668135 668135 Flory, William, of Islington, yeoman 0
4216322 2101201 2101201 defendant Hoopes Francis (legal representative) 668135 668135 Hoopes, Francis, of Islington, yeoman, executrix of 0
4216323 2101201 2101201 defendant Hoopes Agnes widow 668135 668135 Hoopes, Agnes, of Islington, widow 1
4232470 2106864 2106864 defendant Gardiner John farrier 668135 668135 Gardiner, John, of Islington, or of Maydston, Kent, farrier 0
4232471 2106864 2106864 defendant Ryton John husbandman 668135 668135 Ryton, John, of Islington, husbandman 1
4232472 2106864 2106864 defendant Hardye Robert husbandman 668135 668135 Hardye, Robert, of Islington, husbandman 2
4241181 2110038 2110038 defendant Hardye Robert husbandman 668135 668135 Hardye, Robert, of Islington, husbandman 0
4246915 2111942 2111942 defendant Fobbes Thomas yeoman 668135 668135 Fobbes, Thomas, of Islington, yeoman 0
4260247 2116391 2116391 defendant Hudde Thomas baker 668135 668135 Hudde, Thomas, of Islington, baker 0
4260249 2116392 2116392 defendant Hudde Thomas baker 668135 668135 Hudde, Thomas, of Islington, baker 0
4275833 2121497 2121497 defendant Edwardes Robert yeoman 668135 668135 Edwardes, Robert, of Islington, yeoman 0
4280133 2122961 2122961 defendant Fobbe Thomas husbandman 668135 668135 Fobbe, Thomas, of Islington, husbandman 1
4312964 2134657 2134657 defendant Edwardes Robert yeoman 668135 668135 Edwardes, Robert, of Islington, yeoman 0
4337108 2142703 2142703 defendant Harte John yeoman 668135 668135 Harte, John, of Islington, yeoman 0
4388855 2160905 2160905 defendant Neale Stephen husbandman 668135 668135 Neale, Stephen, of Islington, husbandman 0
4393220 2162339 2162339 defendant Mower John husbandman 668135 668135 Mower, John, of Islington, husbandman 0
4393221 2162339 2162339 defendant Flory John yeoman 668135 668135 Flory, John, of Islington, yeoman 1
4393222 2162339 2162339 defendant Horskyn William husbandman 668135 668135 Horskyn, William, of Islington, husbandman 2
4502146 2201266 2201266 defendant Baxter John   668135 668135 Baxter, John, of Islington 1
5154477 2402458 2402458 defendant Halom William esq 668135 668135 Halom, William, of Islington, esq 0
5159433 2403876 2403876 defendant Gravenest John husbandman 668135 668135 Gravenest, John, of Islington, husbandman 0
5171542 2407395 2407395 defendant Halom William esq 668135 668135 Halom, William, of Islington, esq 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);