names

61 rows where place_id = 593573

✎ 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
3612407 1871508 1871508 defendant Folburn Thomas engraver 593573 593573 Folburn, Thomas, of Smalbergh, engraver 1
3612408 1871508 1871508 defendant Rumhale Thomas husbandman 593573 593573 Rumhale, Thomas, of Smalbergh, husbandman 2
3612409 1871508 1871508 defendant Norwych John husbandman 593573 593573 Norwych, John, of Smalbergh, husbandman 3
3614211 1872112 1872112 defendant Fulbergh Thomas engraver 593573 593573 Fulbergh, Thomas, of Smalbergh, engraver 1
3614212 1872112 1872112 defendant Fulbergh Robert shoemaker 593573 593573 Fulbergh, Robert, of Smalbergh, shoemaker 2
3614215 1872113 1872113 defendant Fulbergh Thomas engraver 593573 593573 Fulbergh, Thomas, of Smalbergh, engraver 1
3614216 1872113 1872113 defendant Fulbergh Robert shoemaker 593573 593573 Fulbergh, Robert, of Smalbergh, shoemaker 2
3639851 1907277 1907277 defendant Auncell William (legal representative) 593573 593573 Auncell, William, of Smalbergh, husbandman, executor of 3
3639852 1907277 1907277 defendant Auncell Thomas husbandman 593573 593573 Auncell, Thomas, of Smalbergh, husbandman 4
3670935 1916877 1916877 defendant Deve Richard yeoman 593573 593573 Deve, Richard, of Smalbergh, yeoman 2
3670940 1916879 1916879 defendant Wodthorppe Robert   593573 593573 Wodthorppe, Robert, of Smalbergh, worsted weaver 0
3693662 1924211 1924211 defendant Wolman John turner 593573 593573 Wolman, John, of Smalbergh, turner 0
3702194 1926942 1926942 defendant Rumpe Alice widow 593573 593573 Rumpe, Alice, of Smalbergh, widow 1
3708354 1928907 1928907 defendant Mathewe John butcher 593573 593573 Mathewe, John, of Smalbergh, butcher 0
3714023 1930684 1930684 plaintiff Baldwyn John   593573 593573 Baldwyn, John, of Smalbergh, "graver" 0
3769177 1948017 1948017 defendant Northgate John   593573 593573 Northgate, John, of Smalbergh, worsted weaver 3
4571097 2222527 2222527 defendant Flur_ John   593573 593573 Flur_, John, of Smalbergh 1
4671136 2256637 2256637 defendant Lawys John husbandman 593573 593573 Lawys, John, of Smalbergh, husbandman 0
4682083 2260016 2260016 defendant atte Hill William spicer 593573 593573 atte Hill, William, of Smalbergh, spicer 1
4725275 2273195 2273195 defendant Becclys William husbandman 593573 593573 Becclys, William, of Smalbergh, husbandman 2
4739348 2277393 2277393 defendant Wattes William smith 593573 593573 Wattes, William, of Smalbergh, smith 2
4837195 2307586 2307586 plaintiff Folbergh Robert   593573 593573 Folbergh, Robert, of Smalbergh 0
4837196 2307586 2307586 plaintiff Joye Geoffrey   593573 593573 Joye, Geoffrey, of Smalbergh 1
4837197 2307586 2307586 plaintiff Praty William   593573 593573 Praty, William, of Smalbergh 2
4844452 2309778 2309778 defendant Mendham Oliver   593573 593573 Mendham, Oliver, of Smalbergh, parson 0
4847402 2310692 2310692 defendant Wattes John yeoman 593573 593573 Wattes, John, of Smalbergh, yeoman 2
4847411 2310694 2310694 defendant Joye Geoffrey husbandman 593573 593573 Joye, Geoffrey, of Smalbergh, husbandman 1
4847412 2310694 2310694 defendant Praty William husbandman 593573 593573 Praty, William, of Smalbergh, husbandman 2
4881507 2321120 2321120 plaintiff Wryght Robert (legal representative) 593573 593573 Wryght, Robert, of Smalbergh, executors of 0
4891655 2324129 2324129 defendant Joly Stephen carpenter 593573 593573 Joly, Stephen, of Smalbergh, carpenter 1
4891656 2324129 2324129 defendant Faax John husbandman 593573 593573 Faax, John, of Smalbergh, husbandman 2
4897883 2325997 2325997 defendant Joly Stephen carpenter 593573 593573 Joly, Stephen, of Smalbergh, carpenter 1
4897884 2325997 2325997 defendant Fox John carpenter 593573 593573 Fox, John, of Smalbergh, carpenter 2
5102784 2387232 2387232 defendant Praty alias Spycer Thomas chapman 593573 593573 Praty alias Spycer, Thomas, of Smalbergh, chapman 2
5120108 2392320 2392320 plaintiff Spycer Thomas   593573 593573 Spycer, Thomas, of Smalbergh 0
5217935 2420980 2420980 defendant Praty Thomas spicer 593573 593573 Praty, Thomas, of Smalbergh, spicer 1
5299957 2444951 2444951 defendant Sene John husbandman 593573 593573 Sene, John, of Smalbergh, husbandman 2
5299961 2444952 2444952 defendant Seyne John husbandman 593573 593573 Seyne, John, of Smalbergh, husbandman 2
5365885 2464984 2464984 plaintiff Born John   593573 593573 Born, John, of Smalbergh 0
5367839 2465568 2465568 defendant Hardewyn Joan widow 593573 593573 Hardewyn, Joan, of Smalbergh, widow 1
5399510 2474939 2474939 defendant Fulborn John   593573 593573 Fulborn, John, of Smalbergh, shoe maker 0
5411518 2478402 2478402 defendant Rumpe Isaac laborer 593573 593573 Rumpe, Isaac, of Smalbergh, laborer 0
5411520 2478403 2478403 defendant Rumpe Isaac laborer or loader 593573 593573 Rumpe, Isaac, of Smalbergh, laborer or loader 0
5468869 2495620 2495620 defendant Partryk John smith 593573 593573 Partryk, John, of Smalbergh, smith 0
5485820 2500655 2500655 plaintiff Wakefeld Robert   593573 593573 Wakefeld, Robert, of Smalbergh 2
5485824 2500656 2500656 plaintiff Wakefeld Robert   593573 593573 Wakefeld, Robert, of Smalbergh 2
5515447 2509677 2509677 defendant Rumpe Isaac yeoman 593573 593573 Rumpe, Isaac, of Smalbergh, yeoman 0
5519747 2511011 2511011 defendant Folbergh John husbandman 593573 593573 Folbergh, John, of Smalbergh, husbandman 1
5520842 2511339 2511339 defendant Partryk John husbandman 593573 593573 Partryk, John, of Smalbergh, husbandman 0
5520843 2511339 2511339 defendant Croft Clement husbandman 593573 593573 Croft, Clement, of Smalbergh, husbandman 1
5520844 2511339 2511339 defendant Laurence Thomas husbandman 593573 593573 Laurence, Thomas, of Smalbergh, husbandman 2
5525671 2512622 2512622 defendant Laurens Thomas husbandman 593573 593573 Laurens, Thomas, of Smalbergh, husbandman 0
5540238 2517076 2517076 defendant Laurence Thomas butcher 593573 593573 Laurence, Thomas, of Smalbergh, butcher 2
5540369 2517115 2517115 defendant Wodecoke Edward husbandman 593573 593573 Wodecoke, Edward, of Smalbergh, husbandman 2
5550425 2520144 2520144 defendant Heyward Thomas husbandman 593573 593573 Heyward, Thomas, of Smalbergh, husbandman 1
5550426 2520144 2520144 defendant Grene William   593573 593573 Grene, William, of Smalbergh, worsted weaver 2
5555312 2521556 2521556 defendant Wylkenson Matthew glover 593573 593573 Wylkenson, Matthew, of Smalbergh, glover 0
5572865 2526616 2526616 defendant Wodthorpe Robert   593573 593573 Wodthorpe, Robert, of Smalbergh, worsted weaver 0
5580741 2529057 2529057 defendant Patryk John smith 593573 593573 Patryk, John, of Smalbergh, smith 0
5580742 2529057 2529057 defendant Wodthorp Robert   593573 593573 Wodthorp, Robert, of Smalbergh, worsted weaver 1
5631623 2553901 2553901 defendant Wryghte Robert husbandman 593573 593573 Wryghte, Robert, of Smalbergh, husbandman 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);