names

26 rows where place_id = 612230

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692240 1923742 1923742 defendant Markant George yeoman 612230 612230 Markant, George, of Watton, Norf, yeoman 0
3782875 1952392 1952392 defendant Markaunt George yeoman 612230 612230 Markaunt, George, of Watton, Norf, yeoman 0
3903146 1991280 1991280 defendant Weston Robert tailor 612230 612230 Weston, Robert, of Watton, Norf, tailor 0
3916718 1995960 1995960 defendant Weston Robert tailor 612230 612230 Weston, Robert, of Watton, Norf, tailor 0
3966046 2012745 2012745 defendant Fenwyke Thomas chapman 612230 612230 Fenwyke, Thomas, of Watton, Norf, chapman 2
3970656 2014324 2014324 defendant Base William chandler 612230 612230 Base, William, of Watton, Norf, chandler 0
3972066 2014788 2014788 defendant Alden Robert cooper 612230 612230 Alden, Robert, of Watton, Norf, cooper 0
3972068 2014789 2014789 defendant Alden Robert cooper 612230 612230 Alden, Robert, of Watton, Norf, cooper 0
4080453 2053320 2053320 defendant Maye Robert chapman 612230 612230 Maye, Robert, of Watton, Norf, chapman 0
4111192 2064253 2064253 defendant Hamson James mercer 612230 612230 Hamson, James, of Watton, Norf, mercer 1
4183827 2089838 2089838 defendant Brownynge Robert yeoman 612230 612230 Brownynge, Robert, of Watton, Norf, yeoman 0
4203676 2096844 2096844 defendant May Samuel chapman 612230 612230 May, Samuel, of Watton, Norf, chapman 0
4233568 2107260 2107260 defendant Haye William   612230 612230 Haye, William, of Watton, Norf, woollen draper 0
4289651 2126364 2126364 defendant Moore Francis   612230 612230 Moore, Francis, of Watton, Norf, worsted weaver 1
4337005 2142670 2142670 defendant Wyteman Richard   612230 612230 Wyteman, Richard, of Watton, Norf, woollen draper 0
4337011 2142671 2142671 defendant Mayes Samuel hatter 612230 612230 Mayes, Samuel, of Watton, Norf, hatter 1
4402023 2165267 2165267 defendant Brunsall or Brimsall William yeoman 612230 612230 Brunsall or Brimsall, William, of Watton, Norf, yeoman 1
4798301 2295658 2295658 defendant Fekeys Thomas gent 612230 612230 Fekeys, Thomas, of Watton, Norf, gent 1
4995364 2355456 2355456 defendant Crowche Edmund shoemaker 612230 612230 Crowche, Edmund, of Watton, Norf, shoemaker 1
5160711 2404233 2404233 defendant Baxster Simon laborer 612230 612230 Baxster, Simon, of Watton, Norf, laborer 2
5376901 2468371 2468371 defendant Sarson Henry husbandman 612230 612230 Sarson, Henry, of Watton, Norf, husbandman 0
5376904 2468372 2468372 defendant Sarson Henry husbandman 612230 612230 Sarson, Henry, of Watton, Norf, husbandman 0
5551075 2520339 2520339 defendant Dunham Richard husbandman 612230 612230 Dunham, Richard, of Watton, Norf, husbandman 0
5551080 2520340 2520340 defendant Dunham Richard husbandman 612230 612230 Dunham, Richard, of Watton, Norf, husbandman 0
5551085 2520341 2520341 defendant Dunham Richard husbandman 612230 612230 Dunham, Richard, of Watton, Norf, husbandman 0
5558182 2522343 2522343 defendant Gawedwyll William yeoman 612230 612230 Gawedwyll, William, of Watton, Norf, yeoman 5

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