names

38 rows where place_id = 595573

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621057 1874143 1874143 defendant Lorkyn John butcher 595573 595573 Lorkyn, John, of South Flete, butcher 0
3621058 1874143 1874143 defendant Mere William husbandman 595573 595573 Mere, William, of South Flete, husbandman 1
3659931 1913362 1913362 defendant Bruse Nicholas husbandman 595573 595573 Bruse, Nicholas, of South Flete, husbandman 0
3710265 1929526 1929526 plaintiff Sedley John esq 595573 595573 Sedley, John, of South Flete, esq 0
3912780 1994606 1994606 defendant Gaunt Richard yeoman 595573 595573 Gaunt, Richard, of South Flete, yeoman 0
4021175 2032292 2032292 defendant Sydley John   595573 595573 Sydley, John, of South Flete, esq, sheriff 0
4061236 2046425 2046425 defendant Plane John husbandman 595573 595573 Plane, John, of South Flete, husbandman 1
4107812 2063071 2063071 defendant Rothman Edward gent 595573 595573 Rothman, Edward, of South Flete, gent 2
4458946 2187844 2187844 defendant Skathebery Robert   595573 595573 Skathebery, Robert, of South Flete 2
4460952 2188494 2188494 defendant Bayly John   595573 595573 Bayly, John, of South Flete 0
4485914 2196299 2196299 defendant Edmund William   595573 595573 Edmund, William, of South Flete 1
4499996 2200638 2200638 defendant Capoun Robert   595573 595573 Capoun, Robert, of South Flete 2
4504357 2201914 2201914 defendant Jurdon Thomas   595573 595573 Jurdon, Thomas, of South Flete 3
4550439 2216082 2216082 defendant Edmond William   595573 595573 Edmond, William, of South Flete 1
4550440 2216082 2216082 defendant Horne William   595573 595573 Horne, William, of South Flete 2
4558912 2218748 2218748 defendant Baterell William   595573 595573 Baterell, William, of South Flete 0
4688444 2261953 2261953 defendant Orgon Robert ploughman 595573 595573 Orgon, Robert, of South Flete, ploughman 0
4704883 2266904 2266904 defendant Cotyng Richard husbandman 595573 595573 Cotyng, Richard, of South Flete, husbandman 0
4736674 2276599 2276599 defendant Wyke William laborer 595573 595573 Wyke, William, of South Flete, laborer 0
4833051 2306355 2306355 defendant Wykes William husbandman 595573 595573 Wykes, William, of South Flete, husbandman 0
4846379 2310375 2310375 defendant Water Simon yeoman 595573 595573 Water, Simon, of South Flete, yeoman 1
5128188 2394718 2394718 defendant Shirdwode William butcher 595573 595573 Shirdwode, William, of South Flete, butcher 1
5128298 2394753 2394753 defendant Sherewoode John butcher 595573 595573 Sherewoode, John, of South Flete, butcher 2
5138498 2397760 2397760 defendant Chymbham Edmund esq 595573 595573 Chymbham, Edmund, of South Flete, gent, brother of John Chymblham, of Fremyngham, esq 0
5138595 2397783 2397783 defendant London John   595573 595573 London, John, of South Flete 4
5141439 2398610 2398610 defendant Shirwode John butcher 595573 595573 Shirwode, John, of South Flete, butcher 3
5147387 2400381 2400381 defendant Sherewode John butcher 595573 595573 Sherewode, John, of South Flete, butcher 2
5159333 2403846 2403846 defendant Loundyssh Roger husbandman 595573 595573 Loundyssh, Roger, of South Flete, husbandman 0
5159334 2403846 2403846 defendant Shirwode John butcher 595573 595573 Shirwode, John, of South Flete, butcher 1
5159335 2403846 2403846 defendant Shirwode William butcher 595573 595573 Shirwode, William, of South Flete, butcher 2
5167118 2406115 2406115 defendant Sherewode John butcher 595573 595573 Sherewode, John, of South Flete, butcher 2
5182381 2410601 2410601 defendant Sherewode John butcher 595573 595573 Sherewode, John, of South Flete, butcher 2
5195005 2414288 2414288 defendant Shirwode Roger husbandman 595573 595573 Shirwode, Roger, of South Flete, husbandman 0
5195223 2414349 2414349 defendant Loyndyssh Roger husbandman 595573 595573 Loyndyssh, Roger, of South Flete, husbandman 0
5301170 2445310 2445310 defendant Tumber Stephen husbandman 595573 595573 Tumber, Stephen, of South Flete, husbandman 0
5383437 2470342 2470342 defendant Axston Reginald husbandman 595573 595573 Axston, Reginald, of South Flete, husbandman 1
5475990 2497831 2497831 defendant Couper John husbandman 595573 595573 Couper, John, of South Flete, husbandman 0
5594484 2533256 2533256 plaintiff Beere William yeoman 595573 595573 Beere, William, of South Flete, yeoman 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);