names

22 rows where place_id = 616160

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3712941 1930368 1930368 defendant Luscomb John husbandman 616160 616160 Luscomb, John, of Armyngton, husbandman 0
3732470 1936387 1936387 defendant Hyll William   616160 616160 Hyll, William, of Armyngton, groom 2
3746649 1940865 1940865 defendant Hill William   616160 616160 Hill, William, of Armyngton, groom 2
3877285 1982644 1982644 defendant Lowde Adam tinner 616160 616160 Lowde, Adam, of Armyngton, tinner 7
3904378 1991711 1991711 defendant Frynde Richard husbandman 616160 616160 Frynde, Richard, of Armyngton, husbandman 0
3923820 1998274 1998274 defendant Mugge Thomas husbandman 616160 616160 Mugge, Thomas, of Armyngton, husbandman 1
3923821 1998274 1998274 defendant Hunnysdon Robert husbandman 616160 616160 Hunnysdon, Robert, of Armyngton, husbandman 2
3939223 2003421 2003421 defendant Fortescue John   616160 616160 Fortescue, John, of Armyngton, esq, son & heir apparent of Henry Fortescue 2
4758505 2283040 2283040 defendant Thormondesby John gent 616160 616160 Thormondesby, John, of Armyngton, gent 0
4839578 2308298 2308298 defendant Coulyng William husbandman 616160 616160 Coulyng, William, of Armyngton, husbandman 3
4843163 2309388 2309388 defendant Fuller Walter husbandman 616160 616160 Fuller, Walter, of Armyngton, husbandman 1
4866793 2316578 2316578 defendant Coulyng or Conlyng William husbandman 616160 616160 Coulyng or Conlyng, William, of Armyngton, husbandman 0
4944493 2340257 2340257 defendant Cowebruge William husbandman 616160 616160 Cowebruge, William, of Armyngton, husbandman 3
4968328 2347490 2347490 defendant Taillour Robert husbandman 616160 616160 Taillour, Robert, of Armyngton, husbandman 2
4972623 2348744 2348744 defendant Cowlyng William husbandman 616160 616160 Cowlyng, William, of Armyngton, husbandman 0
4972626 2348745 2348745 defendant Cowlyng William husbandman 616160 616160 together with Cowlyng, William, of Armyngton, husbandman 1
5048152 2371073 2371073 defendant Aylston William   616160 616160 Aylston, William, of Armyngton, vicar 0
5111121 2389638 2389638 defendant Balsham Thomas butcher 616160 616160 Balsham, Thomas, of Armyngton, butcher 2
5229571 2424264 2424264 defendant Croppyll John husbandman 616160 616160 Croppyll, John, of Armyngton, husbandman 3
5258172 2432676 2432676 defendant Crophill John, senior husbandman 616160 616160 Crophill, John, senior, of Armyngton, husbandman 0
5258173 2432676 2432676 defendant Crophill Thomas husbandman 616160 616160 Crophill, Thomas, of Armyngton, husbandman 1
5258174 2432676 2432676 defendant Crophill Robert husbandman 616160 616160 Crophill, Robert, of Armyngton, husbandman 2

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