names

36 rows where place_id = 589335

✎ 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
3597261 1866763 1866763 defendant Rokesaker Thomas husbandman 589335 589335 Rokesaker, Thomas, of Bersted, husbandman 3
3597694 1866904 1866904 defendant Rokesacre Thomas   589335 589335 Rokesacre, Thomas, of Bersted, mason 2
3620880 1874093 1874093 defendant Pokyll Thomas yeoman 589335 589335 Pokyll, Thomas, of Bersted, yeoman 0
3659043 1913091 1913091 defendant Shersted Robert husbandman 589335 589335 Shersted, Robert, of Bersted, husbandman 0
3713809 1930618 1930618 defendant Shersted Robert husbandman 589335 589335 Shersted, Robert, of Bersted, husbandman 1
3726257 1934478 1934478 defendant At Wodde William husbandman 589335 589335 At Wodde, William, of Bersted, husbandman 2
3759627 1944998 1944998 defendant Thomson William fuller 589335 589335 Thomson, William, of Bersted, fuller 0
3759628 1944998 1944998 defendant Johnson Lewis fuller 589335 589335 Johnson, Lewis, of Bersted, fuller 1
3796084 1956638 1956638 defendant Howtyng Ralph shoemaker 589335 589335 Howtyng, Ralph, of Bersted, shoemaker 0
3912775 1994605 1994605 defendant Wyatt John   589335 589335 Wyatt, John, of Bersted, mason 1
3912778 1994605 1994605 defendant Hart Richard husbandman 589335 589335 Hart, Richard, of Bersted, husbandman 4
4232881 2107007 2107007 defendant Howtynge Robert husbandman 589335 589335 Howtynge, Robert, of Bersted, husbandman 0
4390304 2161379 2161379 defendant Woldgate Edward yeoman 589335 589335 Woldgate, Edward, of Bersted, yeoman 1
4397035 2163576 2163576 defendant Poulford Thomas husbandman 589335 589335 Poulford, Thomas, of Bersted, husbandman 0
4397036 2163576 2163576 defendant Taylor Michael husbandman 589335 589335 Taylor, Michael, of Bersted, husbandman 1
4822760 2303198 2303198 defendant Edwardes John husbandman 589335 589335 Edwardes, John, of Bersted, husbandman 0
4823533 2303449 2303449 defendant Dane John smith 589335 589335 Dane, John, of Bersted, smith 0
4856236 2313323 2313323 defendant Pelsham John laborer 589335 589335 Pelsham, John, of Bersted, laborer 0
4856237 2313323 2313323 defendant Marchaunt John tailor 589335 589335 Marchaunt, John, of Bersted, tailor 1
4856238 2313323 2313323 defendant Marchaunt John laborer 589335 589335 Marchaunt, John, of Bersted, laborer 2
4856239 2313323 2313323 defendant Clynton Robert   589335 589335 Clynton, Robert, of Bersted, mason 3
4964273 2346224 2346224 defendant Hunne Thomas   589335 589335 Hunne, Thomas, of Bersted, mason 0
5087708 2382791 2382791 defendant Brewer Henry   589335 589335 Brewer, Henry, of Bersted, mason 2
5087714 2382792 2382792 defendant Brewer Henry   589335 589335 Brewer, Henry, of Bersted, mason 2
5376282 2468176 2468176 defendant Hokyng John butcher 589335 589335 Hokyng, John, of Bersted, butcher 0
5403169 2475990 2475990 defendant Hopkyn John butcher 589335 589335 Hopkyn, John, of Bersted, butcher 3
5411821 2478489 2478489 defendant Thomlyn Henry laborer 589335 589335 Thomlyn, Henry, of Bersted, laborer 2
5416185 2479771 2479771 defendant Hopkyng John butcher 589335 589335 Hopkyng, John, of Bersted, butcher 1
5457200 2492052 2492052 defendant Tomlyn Henry laborer 589335 589335 Tomlyn, Henry, of Bersted, laborer 0
5465675 2494647 2494647 defendant Pokyll Thomas draper 589335 589335 Pokyll, Thomas, of Bersted, draper 0
5465676 2494647 2494647 defendant Godyn Robert husbandman 589335 589335 Godyn, Robert, of Bersted, husbandman 1
5465677 2494647 2494647 defendant Rokesaker John husbandman 589335 589335 Rokesaker, John, of Bersted, husbandman 2
5480227 2499069 2499069 defendant Tomlyn Henry laborer 589335 589335 Tomlyn, Henry, of Bersted, laborer 0
5503973 2506153 2506153 defendant Bartey John   589335 589335 Bartey, John, of Bersted, mason 0
5513127 2508960 2508960 defendant Couper John smith 589335 589335 Couper, John, of Bersted, smith 2
5532131 2514593 2514593 defendant Gate John butcher 589335 589335 Gate, John, of Bersted, butcher 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);