names

21 rows where place_id = 594937

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618197 1873316 1873316 defendant Hayle John husbandman 594937 594937 Hayle, John, of Magna Chesterford, Essex, husbandman 1
3625536 1875525 1875525 defendant Stalworth Robert   594937 594937 Stalworth, Robert, of Magna Chesterford, Essex, sghepherd 2
3626359 1903103 1903103 defendant Shether John gent 594937 594937 Shether, John, of Magna Chesterford, Essex, gent 0
3716879 1931566 1931566 defendant Howesden John husbandman 594937 594937 Howesden, John, of Magna Chesterford, Essex, husbandman 2
3716883 1931567 1931567 defendant Howesden John husbandman 594937 594937 Howesden, John, of Magna Chesterford, Essex, husbandman 2
3716887 1931568 1931568 defendant Howsden John husbandman 594937 594937 Howsden, John, of Magna Chesterford, Essex, husbandman 2
3743565 1939863 1939863 defendant Chawke Thomas maltman 594937 594937 Chawke, Thomas, of Magna Chesterford, Essex, maltman 1
3744418 1940156 1940156 defendant Wynterflode John maltman 594937 594937 Wynterflode, John, of Magna Chesterford, Essex, maltman 0
3811091 1961365 1961365 defendant Page John husbandman 594937 594937 Page, John, of Magna Chesterford, Essex, husbandman 1
3816028 1962913 1962913 plaintiff Hert Robert   594937 594937 Hert, Robert, of Magna Chesterford, Essex 0
3871930 1980845 1980845 defendant Shether John gent 594937 594937 Shether, John, of Magna Chesterford, Essex, gent 0
3871933 1980846 1980846 defendant Shether John gent 594937 594937 Shether, John, of Magna Chesterford, Essex, gent 0
4158235 2080952 2080952 defendant Baker John (legal representative) 594937 594937 Baker, John, of Magna Chesterford, Essex, gent, executor of 1
4336530 2142514 2142514 defendant Reynold James gent 594937 594937 Reynold, James, of Magna Chesterford, Essex, gent 0
4385005 2159676 2159676 defendant Reynolds James gent 594937 594937 Reynolds, James, of Magna Chesterford, Essex, gent 0
5072927 2378389 2378389 defendant Kyng John yeoman 594937 594937 Kyng, John, of Magna Chesterford, Essex, yeoman 0
5092502 2384185 2384185 defendant Joce Thomas husbandman 594937 594937 Joce, Thomas, of Magna Chesterford, Essex, husbandman 0
5122652 2393057 2393057 defendant Burgh Richard smith 594937 594937 Burgh, Richard, of Magna Chesterford, Essex, smith 2
5328964 2453742 2453742 defendant Harryes John yeoman 594937 594937 Harryes, John, of Magna Chesterford, Essex, yeoman 0
5329004 2453754 2453754 defendant Herryes John yeoman 594937 594937 Herryes, John, of Magna Chesterford, Essex, yeoman 0
5536727 2515972 2515972 defendant Page John yeoman 594937 594937 Page, John, of Magna Chesterford, Essex, yeoman 1

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);