names

217 rows where place_id = 592344

✎ 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
3607407 1869977 1869977 defendant Gresham John gent 592344 592344 Gresham, John, of Holt, gent 0
3622545 1874588 1874588 defendant Pylehous John husbandman 592344 592344 Pylehous, John, of Holt, husbandman 0
3645510 1908995 1908995 defendant Bacon Richard yeoman 592344 592344 Bacon, Richard, of Holt, yeoman 6
3671523 1917076 1917076 defendant Shortyng William stainer 592344 592344 Shortyng, William, of Holt, stainer 0
3671524 1917076 1917076 defendant Woodcok William   592344 592344 Woodcok, William, of Holt, wax chandler 1
3673115 1917602 1917602 defendant Barbour Thomas husbandman 592344 592344 Barbour, Thomas, of Holt, husbandman 0
3680799 1920076 1920076 defendant Styberd John husbandman 592344 592344 Styberd, John, of Holt, husbandman 0
3702451 1927027 1927027 defendant Clerborn Thomas husbandman 592344 592344 Clerborn, Thomas, of Holt, husbandman 3
3705636 1928044 1928044 defendant Shortyng William stainer 592344 592344 Shortyng, William, of Holt, stainer 1
3716463 1931443 1931443 defendant Flete Thomas   592344 592344 Flete, Thomas, of Holt, "trowman" 0
3725938 1934387 1934387 defendant Langford John   592344 592344 Langford, John, of Holt, knight 1
3748972 1941611 1941611 defendant Shorttyng William painter 592344 592344 Shorttyng, William, of Holt, painter 0
3759724 1945033 1945033 defendant Barbour Thomas husbandman 592344 592344 Barbour, Thomas, of Holt, husbandman 4
3767004 1947345 1947345 defendant Rufford Richard yeoman 592344 592344 Rufford, Richard, of Holt, yeoman 4
3777309 1950647 1950647 defendant Erle Robert husbandman 592344 592344 Erle, Robert, of Holt, husbandman 0
3836488 1969318 1969318 defendant Barbour Thomas yeoman 592344 592344 Barbour, Thomas, of Holt, yeoman 0
3841039 1970769 1970769 defendant Embyrson Edward husbandman 592344 592344 Embyrson, Edward, of Holt, husbandman 0
3841041 1970769 1970769 defendant Mabbys Thomas husbandman 592344 592344 Mabbys, Thomas, of Holt, husbandman 2
3841344 1970869 1970869 defendant Michell Alan mariner 592344 592344 Michell, Alan, of Holt, mariner 1
3845376 1972115 1972115 defendant Barbour Thomas husbandman 592344 592344 Barbour, Thomas, of Holt, husbandman 1
3855311 1975297 1975297 defendant Whitney Richard gent 592344 592344 Whitney, Richard, of Holt, gent 2
3856089 1975527 1975527 plaintiff Whytney Richard gent 592344 592344 Whytney, Richard, of Holt, gent 0
3856092 1975528 1975528 plaintiff Whytney Richard gent 592344 592344 Whytney, Richard, of Holt, gent 0
3868525 1979714 1979714 defendant Dobydo William   592344 592344 Dobydo, William, of Holt, shepherd 2
3877249 1982633 1982633 defendant Mabbys Thomas husbandman 592344 592344 Mabbys, Thomas, of Holt, husbandman 0
3877309 1982655 1982655 defendant Warne Nicholas butcher 592344 592344 Warne, Nicholas, of Holt, butcher 0
3893652 1988104 1988104 defendant Walshe George gent 592344 592344 Walshe, George, of Holt, gent 0
3901398 1990690 1990690 defendant Walshe Edward clerk 592344 592344 Walshe, Edward, of Holt, clerk 0
3923981 1998332 1998332 defendant Matsale William yeoman 592344 592344 Matsale, William, of Holt, yeoman 2
3923987 1998333 1998333 defendant Matsale William yeoman 592344 592344 Matsale, William, of Holt, yeoman 4
3958651 2010101 2010101 plaintiff Roydon Peter   592344 592344 Roydon, Peter, of Holt 0
3986688 2019979 2019979 defendant Borne John   592344 592344 Borne, John, of Holt, knight 0
4023733 2033190 2033190 defendant Erle Richard yeoman 592344 592344 Erle, Richard, of Holt, yeoman 0
4041422 2039423 2039423 plaintiff Nevell Thomas (legal representative) 592344 592344 Nevell, Thomas, of Holt, knight, executors of 0
4041426 2039424 2039424 plaintiff Nevell Thomas (legal representative) 592344 592344 Nevell, Thomas, of Holt, knight, executors of 0
4041430 2039425 2039425 plaintiff Nevell Thomas (legal representative) 592344 592344 Nevell, Thomas, of Holt, knight, executors of 0
4070093 2049593 2049593 plaintiff Mallet Mathew gent 592344 592344 Mallet, Mathew, of Holt, gent 0
4070096 2049594 2049594 plaintiff Mallet Mathew gent 592344 592344 Mallet, Mathew, of Holt, gent 0
4070101 2049596 2049596 plaintiff Mallett Mathew gent 592344 592344 Mallett, Mathew, of Holt, gent 0
4070232 2049644 2049644 defendant Harman John thatcher 592344 592344 Harman, John, of Holt, thatcher 3
4076671 2051943 2051943 defendant Partricke Richard yeoman 592344 592344 Partricke, Richard, of Holt, yeoman 14
4081604 2053724 2053724 defendant Erle Thomas yeoman 592344 592344 Erle, Thomas, of Holt, yeoman 3
4093286 2057915 2057915 defendant Duggles Christopher   592344 592344 Duggles, Christopher, of Holt, ploughwright 0
4093287 2057915 2057915 defendant Gogney William fishmonger 592344 592344 Gogney, William, of Holt, fishmonger 1
4121999 2068169 2068169 defendant Gogney William fishmonger 592344 592344 Gogney, William, of Holt, fishmonger 0
4122739 2068424 2068424 defendant Gogney William fishmonger 592344 592344 Gogney, William, of Holt, or of Fulmodesaton, fishmonger 3
4153687 2079384 2079384 defendant Gogney William husbandman 592344 592344 Gogney, William, of Holt, husbandman 0
4174162 2086418 2086418 defendant Grene John husbandman 592344 592344 Grene, John, of Holt, husbandman 1
4198930 2095182 2095182 defendant Gogney William fishmonger 592344 592344 Gogney, William, of Holt, fishmonger 1
4199671 2095436 2095436 defendant Barnes John yeoman 592344 592344 Barnes, John, of Holt, yeoman 0
4200408 2095699 2095699 defendant Jenynges John husbandman 592344 592344 Jenynges, John, of Holt, Wymborne Mynster, husbandman 0
4215695 2100987 2100987 defendant Dun Thomas yeoman 592344 592344 Dun, Thomas, of Holt, yeoman 0
4217246 2101528 2101528 defendant Clarke William tinker 592344 592344 Clarke, William, of Holt, tinker 0
4217247 2101528 2101528 defendant Grene John yeoman 592344 592344 Grene, John, of Holt, yeoman 1
4217825 2101728 2101728 defendant Langdon Christopher gent 592344 592344 Langdon, Christopher, of Holt, gent 1
4227360 2105051 2105051 defendant Syer Anne widow 592344 592344 Syer, Anne, of Holt, widow 1
4227365 2105052 2105052 defendant Syer Anne widow 592344 592344 Syer, Anne, of Holt, widow 1
4243495 2110817 2110817 defendant Clarke William tinker 592344 592344 Clarke, William, of Holt, tinker 0
4243496 2110817 2110817 defendant Masseye Geoffrey yeoman 592344 592344 Masseye, Geoffrey, of Holt, yeoman 1
4243497 2110817 2110817 defendant Grene John yeoman 592344 592344 Grene, John, of Holt, yeoman 2
4247194 2112037 2112037 defendant Hallyday John tailor 592344 592344 Hallyday, John, of Holt, tailor 2
4247195 2112037 2112037 defendant Hallyday Edward tailor 592344 592344 Hallyday, Edward, of Holt, tailor 3
4274316 2120962 2120962 defendant Geyton Thomas yeoman 592344 592344 Geyton, Thomas, of Holt, yeoman 0
4276246 2121634 2121634 defendant Syer Anne widow 592344 592344 Syer, Anne, of Holt, widow 1
4277624 2122096 2122096 defendant Mollyn Nicholas gent 592344 592344 Mollyn, Nicholas, of Holt, gent 0
4277625 2122096 2122096 defendant Antlye William yeoman 592344 592344 Antlye, William, of Holt, yeoman 1
4277626 2122096 2122096 defendant Hunt Peter   592344 592344 Hunt, Peter, of Holt, shepherd 2
4278229 2122321 2122321 defendant Syer Anne widow 592344 592344 Syer, Anne, of Holt, widow 0
4281277 2123361 2123361 defendant Armiger Henry vintner 592344 592344 Armiger, Henry, of Holt, yeoman, vintner 0
4286871 2125361 2125361 defendant Kinge John husbandman 592344 592344 Kinge, John, of Holt, husbandman 1
4309763 2133571 2133571 defendant Gayton Thomas yeoman 592344 592344 Gayton, Thomas, of Holt, yeoman 0
4311614 2134204 2134204 defendant Drewry William tailor 592344 592344 Drewry, William, of Holt, tailor 3
4313339 2134772 2134772 defendant Kynge William yeoman 592344 592344 Kynge, William, of Holt, yeoman 3
4313344 2134773 2134773 defendant Cooke John yeoman 592344 592344 Cooke, John, of Holt, yeoman 3
4341955 2144466 2144466 defendant Antley William yeoman 592344 592344 Antley, William, of Holt, yeoman 0
4342884 2144785 2144785 defendant Mollyn Nicholas yeoman 592344 592344 Mollyn, Nicholas, of Holt, yeoman 0
4342885 2144785 2144785 defendant Antley or Autley William yeoman 592344 592344 Antley or Autley, William, of Holt, yeoman 1
4343537 2145016 2145016 defendant Kighley Lawrence yeoman 592344 592344 Kighley, Lawrence, of Holt, yeoman 0
4352092 2147965 2147965 defendant Rale John beer brewer 592344 592344 Rale, John, of Holt, beer brewer 2
4354623 2148849 2148849 defendant Massye Andrew glover 592344 592344 Massye, Andrew, of Holt, yeoman, glover 1
4354624 2148849 2148849 defendant Rayle John beer brewer 592344 592344 Rayle, John, of Holt, beer brewer 2
4354625 2148849 2148849 defendant Howse Thomas butcher 592344 592344 Howse, Thomas, of Holt, butcher 3
4355829 2149257 2149257 defendant Hunt Peter   592344 592344 Hunt, Peter, of Holt, shepherd 1
4356995 2149678 2149678 defendant Athowe Thomas butcher 592344 592344 Athowe, Thomas, of Holt, butcher 0
4374826 2156050 2156050 defendant Patricke Roger husbandman 592344 592344 Patricke, Roger, of Holt, husbandman 1
4386364 2160119 2160119 defendant Rale John beer brewer 592344 592344 Rale, John, of Holt, beer brewer 0
4388587 2160823 2160823 defendant Ives George carpenter 592344 592344 Ives, George, of Holt, carpenter 0
4392971 2162262 2162262 defendant Duglas Richard laborer 592344 592344 Duglas, Richard, of Holt, laborer 0
4392972 2162262 2162262 defendant Hunt Peter   592344 592344 Hunt, Peter, of Holt, shepherd 1
4392973 2162262 2162262 defendant Athowe Thomas, junior butcher 592344 592344 Athowe, Thomas, junior, of Holt, butcher 2
4394014 2162599 2162599 defendant Raile John beer brewer 592344 592344 Raile, John, of Holt, beer brewer 1
4394478 2162749 2162749 defendant Massye Andrew glover 592344 592344 Massye, Andrew, of Holt, glover 1
4394480 2162749 2162749 defendant Lacye George   592344 592344 Lacye, George, of Holt, sailor 3
4403200 2165641 2165641 defendant Hunt Peter   592344 592344 Hunt, Peter, of Holt, shepherd 0
4405750 2166493 2166493 defendant Antley William yeoman 592344 592344 Antley, William, of Holt, yeoman 0
4405751 2166493 2166493 defendant Syer Anne widow 592344 592344 Syer, Anne, of Holt, widow 1
4408646 2167486 2167486 defendant Massye Andrew glover 592344 592344 Massye, Andrew, of Holt, yeoman, glover 1
4408647 2167486 2167486 defendant Rayle John beer brewer 592344 592344 Rayle, John, of Holt, beer brewer 2
4410803 2168202 2168202 defendant Westbye Henry   592344 592344 Westbye, Henry, of Holt, paten maker 1
4483958 2195676 2195676 plaintiff Palmere John   592344 592344 Palmere, John, of Holt 0

Next page

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