names

22 rows where place_id = 618111

✎ 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
3722901 1933427 1933427 defendant Strode Henry barber 618111 618111 Strode, Henry, of Chelmsford, Essex, barber 0
3860040 1976855 1976855 defendant Knot Thomas grocer 618111 618111 Knot, Thomas, of Chelmsford, Essex, grocer 2
3926771 1999286 1999286 defendant Notter Thomas yeoman 618111 618111 Notter, Thomas, of Chelmsford, Essex, yeoman 2
3931005 2000698 2000698 defendant Harold Thomas   618111 618111 Harold, Thomas, of Chelmsford, Essex 4
3955184 2008878 2008878 plaintiff Maldon Richard haberdasher 618111 618111 Maldon, Richard, of Chelmsford, Essex, haberdasher 0
3977597 2016733 2016733 defendant Scott Thomas gent 618111 618111 Scott, Thomas, of Chelmsford, Essex, gent 2
4066880 2048451 2048451 plaintiff Hubberd Thomas   618111 618111 Hubberd, Thomas, of Chelmsford, Essex, linen draper 0
4126893 2069911 2069911 defendant Tatem John haberdasher 618111 618111 Tatem, John, of Chelmsford, Essex, haberdasher 0
4153201 2079218 2079218 defendant Fuller John dyer 618111 618111 Fuller, John, of Chelmsford, Essex, dyer 0
4168636 2084516 2084516 defendant Jackson Edward laborer 618111 618111 Jackson, Edward, of Chelmsford, Essex, or of Ipswich, laborer 2
4204161 2097006 2097006 defendant Studley George yeoman 618111 618111 Studley, George, of Chelmsford, Essex, yeoman 2
4302436 2130971 2130971 defendant Hasler Thomas chapman 618111 618111 Hasler, Thomas, of Chelmsford, Essex, chapman 2
4318385 2136538 2136538 defendant Tatem John haberdasher 618111 618111 Tatem, John, of Chelmsford, Essex, haberdasher 1
4350476 2147428 2147428 defendant Cooke Henry baker 618111 618111 (Cooke, Henry, of Chelmsford, Essex, baker 1
4350956 2147590 2147590 defendant Reynold Geoffrey chandler 618111 618111 Reynold, Geoffrey, of Chelmsford, Essex, chandler 0
4354425 2148779 2148779 defendant Longe John   618111 618111 Longe, John, of Chelmsford, Essex, woollen draper, jerkin maker 0
5164009 2405211 2405211 defendant Chelmysford Robert (legal representative) 618111 618111 Chelmysford, Robert, of Chelmsford, Essex, executors of 9
5164010 2405211 2405211 defendant Stoddysbere John yeoman 618111 618111 (Stoddysbere, John, of Chelmsford, Essex, yeoman 10
5279857 2439189 2439189 defendant Daysy John, junior chapman 618111 618111 Daysy, John, junior, of Chelmsford, Essex, chapman 0
5284090 2440366 2440366 defendant Bokyng Robert yeoman 618111 618111 Bokyng, Robert, of Chelmsford, Essex, yeoman 5
5340785 2457318 2457318 defendant Bruglon Thomas chapman 618111 618111 Bruglon, Thomas, of Chelmsford, Essex, chapman 0
5580295 2528922 2528922 defendant Harvy James grocer 618111 618111 Harvy, James, of Chelmsford, Essex, grocer 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);