names

68 rows where place_id = 586872

✎ 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
3589863 1864470 1864470 defendant Cosyngton Richard gent 586872 586872 Cosyngton, Richard, of Raynham, gent 0
3598515 1867164 1867164 defendant Harry Valentine husbandman 586872 586872 Harry, Valentine, of Raynham, husbandman 0
3612077 1871421 1871421 defendant Butte Robert husbandman 586872 586872 Butte, Robert, of Raynham, husbandman 1
3616594 1872822 1872822 defendant Sandon John husbandman 586872 586872 Sandon, John, of Raynham, husbandman 0
3664360 1914802 1914802 defendant Charnok John   586872 586872 Charnok, John, of Raynham, cook 0
3672767 1917488 1917488 defendant Burne John yeoman 586872 586872 Burne, John,of Raynham, yeoman 7
3672770 1917489 1917489 defendant Bourne John yeoman 586872 586872 Bourne, John, of Raynham, yeoman 1
3678332 1919276 1919276 defendant Clerke John husbandman 586872 586872 Clerke, John, of Raynham, husbandman 2
3728420 1935136 1935136 defendant Sede Richard yeoman 586872 586872 Sede, Richard, of Raynham, yeoman 0
3745890 1940620 1940620 defendant Baldwyn John, senior husbandman 586872 586872 Baldwyn, John, senior, of Raynham, husbandman 0
3777378 1950669 1950669 defendant Elmeston Thomas yeoman 586872 586872 Elmeston, Thomas, of Raynham, yeoman 0
3806174 1959858 1959858 defendant Butt Robert husbandman 586872 586872 Butt, Robert, of Raynham, husbandman 0
3852005 1974216 1974216 defendant Munke William waterman 586872 586872 Munke, William, of Raynham, waterman 1
3852006 1974216 1974216 defendant Marten Robert waterman 586872 586872 Marten, Robert, of Raynham, waterman 2
3860110 1976878 1976878 defendant Nycollys Thomas clerk 586872 586872 Nycollys, Thomas, of Raynham, clerk 3
3935225 2002091 2002091 plaintiff Johnson Ralph   586872 586872 Johnson, Ralph, of Raynham 0
3965051 2012380 2012380 defendant Sturges Thomas gent 586872 586872 Sturges, Thomas, of Raynham, gent 1
3965068 2012386 2012386 defendant Sturges Thomas gent 586872 586872 Sturges, Thomas, of Raynham, gent 1
3976153 2016226 2016226 plaintiff Johnson Ralph (legal representative) 586872 586872 Johnson, Ralph, of Raynham, executors of 0
4003177 2025897 2025897 defendant Parker Richard yeoman 586872 586872 Parker, Richard, of Raynham, yeoman 0
4003593 2026048 2026048 defendant Mawde Brian   586872 586872 Mawde, Brian, of Raynham, woollen weaver 1
4029103 2035054 2035054 defendant Jenyson Robert yeoman 586872 586872 Jenyson, Robert, of Raynham, yeoman 1
4039210 2038649 2038649 defendant Leman John butcher 586872 586872 Leman, John, of Raynham, butcher 2
4081715 2053762 2053762 defendant Stier Robert   586872 586872 Stier, Robert, of Raynham, "knackner" 1
4107319 2062908 2062908 defendant Mathewe Richard collier 586872 586872 Mathewe, Richard, of Raynham, collier 0
4198809 2095142 2095142 defendant Baker Lawrence yeoman 586872 586872 Baker, Lawrence, of Raynham, yeoman 1
4206234 2097726 2097726 defendant Ladyman Henry husbandman 586872 586872 Ladyman, Henry, of Raynham, husbandman 0
4214894 2100710 2100710 defendant Clyfton Stephen gent 586872 586872 Clyfton, Stephen, of Raynham, gent 1
4217227 2101522 2101522 defendant Basham William yeoman 586872 586872 Basham, William, of Raynham, yeoman 2
4217230 2101523 2101523 defendant Jenyson Thomas yeoman 586872 586872 Jenyson, Thomas, of Raynham, yeoman 1
4217231 2101523 2101523 defendant Dalton Robert yeoman 586872 586872 Dalton, Robert, of Raynham, yeoman 2
4225710 2104457 2104457 defendant Wyngfeld William yeoman 586872 586872 Wyngfeld, William, of Raynham, yeoman 0
4241269 2110064 2110064 defendant Clyfton Stephen gent 586872 586872 Clyfton, Stephen, of Raynham, gent 1
4243492 2110816 2110816 defendant Maddock John miller 586872 586872 Maddock, John, of Raynham, miller 1
4243493 2110816 2110816 defendant Basham William yeoman 586872 586872 Basham, William, of Raynham, yeoman 2
4252475 2113819 2113819 defendant Wyngfeld William yeoman 586872 586872 Wyngfeld, William, of Raynham, yeoman 0
4257287 2115412 2115412 defendant Hasting Luke yeoman 586872 586872 Hasting, Luke, of Raynham, yeoman 0
4310159 2133708 2133708 defendant Blanche Thomas butcher 586872 586872 Blanche, Thomas, of Raynham, butcher 0
4321940 2137760 2137760 defendant Empson William mariner 586872 586872 Empson, William, of Raynham, mariner 0
4334686 2141870 2141870 defendant Baldwyn Nicholas clerk 586872 586872 Baldwyn, Nicholas, of Raynham, clerk 0
4378295 2157305 2157305 defendant Harrison Sampson yeoman 586872 586872 Harrison, Sampson, of Raynham, yeoman 1
4400834 2164871 2164871 defendant Blanche Thomas chapman 586872 586872 Blanche, Thomas, of Raynham, chapman 2
4407847 2167190 2167190 defendant Wedowe William yeoman 586872 586872 Wedowe, William, of Raynham, yeoman 1
4658331 2248491 2248491 defendant Godstone John gent 586872 586872 Godstone, John, of Raynham, gent 0
4894476 2324945 2324945 defendant Parker William ostler 586872 586872 Parker, William, of Raynham, ostler 1
4894477 2324945 2324945 defendant Danyell Thomas husbandman 586872 586872 Danyell, Thomas, of Raynham, husbandman 2
4904257 2327944 2327944 defendant Bryt Edmund husbandman 586872 586872 Bryt, Edmund, of Raynham, husbandman 0
4935744 2337570 2337570 defendant Burton William mariner 586872 586872 Burton, William, of Raynham, mariner 1
5003527 2357926 2357926 defendant Wade John yeoman 586872 586872 Wade, John, of Raynham, yeoman 1
5003528 2357926 2357926 defendant Huet John smith 586872 586872 Huet, John, of Raynham, smith 2
5003529 2357926 2357926 defendant Slovyle Robert husbandman 586872 586872 Slovyle, Robert, of Raynham, husbandman 3
5003530 2357926 2357926 defendant Neweman William   586872 586872 Neweman, William, of Raynham, groom 4
5011207 2360133 2360133 defendant Tele Robert tailor 586872 586872 Tele, Robert, of Raynham, tailor 1
5011208 2360133 2360133 defendant Heve Silvester husbandman 586872 586872 Heve, Silvester, of Raynham, husbandman 2
5331143 2454388 2454388 defendant Cosyngton Richard gent 586872 586872 Cosyngton, Richard, of Raynham, gent 1
5331144 2454388 2454388 defendant Paytewyn Thomas yeoman 586872 586872 Paytewyn, Thomas, of Raynham, yeoman 2
5331149 2454390 2454390 defendant Cosyngton Richard gent 586872 586872 Cosyngton, Richard, of Raynham, gent 1
5331150 2454390 2454390 defendant Paytewyn Thomas yeoman 586872 586872 Paytewyn, Thomas, of Raynham, yeoman 2
5334399 2455358 2455358 defendant Stodard John husbandman 586872 586872 Stodard, John, of Raynham, husbandman 3
5377877 2468657 2468657 defendant Estlond Robert carpernter 586872 586872 Estlond, Robert, of Raynham, carpernter 2
5496036 2503706 2503706 defendant Taylour John husbandman 586872 586872 Taylour, John, of Raynham, husbandman 2
5500812 2505186 2505186 defendant Cosyngton William gent 586872 586872 Cosyngton, William, of Raynham, gent 0
5500813 2505186 2505186 defendant Hillis John husbandman 586872 586872 Hillis, John, of Raynham, husbandman 1
5500815 2505187 2505187 defendant Hardyng Thomas husbandman 586872 586872 Hardyng, Thomas, of Raynham, husbandman 0
5512534 2508779 2508779 defendant Hyde Thomas husbandman 586872 586872 Hyde, Thomas, of Raynham, husbandman 4
5518508 2510619 2510619 defendant Skelton Thomas draper 586872 586872 Skelton, Thomas, of Raynham, draper 1
5530426 2514031 2514031 defendant Cosyngton Thomas gent 586872 586872 Cosyngton, Thomas, of Raynham, gent 0
5581271 2529214 2529214 defendant Charnoke John tailor 586872 586872 Charnoke, John, of Raynham, tailor 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);