names

90 rows where place_id = 595491

✎ 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
3620666 1874042 1874042 defendant Stede William husbandman 595491 595491 Stede, William, of Longham, husbandman 0
3622104 1874449 1874449 defendant Stede William husbandman 595491 595491 Stede, William, of Longham, husbandman 3
3699800 1926164 1926164 defendant Crowe Margaret widow 595491 595491 Crowe, Margaret, of Longham, widow 0
3699801 1926164 1926164 defendant Ketylwell Richard husbandman 595491 595491 Ketylwell, Richard, of Longham, husbandman 1
3699802 1926164 1926164 defendant Cooke Richard husbandman 595491 595491 Cooke, Richard, of Longham, husbandman 2
3712225 1930136 1930136 plaintiff Warner William carpenter 595491 595491 Warner, William, of Longham, carpenter 0
3712226 1930136 1930136 defendant Cooke Richard husbandman 595491 595491 Cooke, Richard, of Longham, husbandman 0
3712227 1930137 1930137 plaintiff Warner William carpenter 595491 595491 Warner, William, of Longham, carpenter 0
3712228 1930137 1930137 defendant Crowe Margaret widow 595491 595491 Crowe, Margaret, of Longham, widow 0
3712229 1930138 1930138 plaintiff Warner William carpenter 595491 595491 Warner, William, of Longham, carpenter 0
3712230 1930138 1930138 defendant Ketylwell Richard husbandman 595491 595491 Ketylwell, Richard, of Longham, husbandman 0
3809321 1960797 1960797 defendant Heydon George gent 595491 595491 Heydon, George, of Longham, gent 0
3809324 1960798 1960798 defendant Heydon George gent 595491 595491 Heydon, George, of Longham, gent 0
3829313 1967052 1967052 defendant Heydon George esq 595491 595491 Heydon, George, of Longham, esq 0
3841677 1970980 1970980 defendant Harryson William yeoman 595491 595491 Harryson, William, of Longham, yeoman 0
3845955 1972291 1972291 defendant Netherwood Robert husbandman 595491 595491 Netherwood, Robert, of Longham, husbandman 0
3876996 1982547 1982547 defendant Car John husbandman 595491 595491 Car, John, of Longham, husbandman 1
3887585 1986098 1986098 defendant Tayllour Thomas clerk 595491 595491 Tayllour, Thomas, of Longham, clerk 1
3888772 1986496 1986496 defendant Carre John laborer 595491 595491 Carre, John, of Longham, laborer 0
3903236 1991306 1991306 defendant Heydon George esq 595491 595491 Heydon, George, of Longham, esq 0
3904486 1991748 1991748 defendant Tuddenham Geoffrey husbandman 595491 595491 Tuddenham, Geoffrey, of Longham, husbandman 0
3904487 1991748 1991748 defendant Harwyn William husbandman 595491 595491 Harwyn, William, of Longham, husbandman 1
3904488 1991748 1991748 defendant Mawne Nicholas laborer 595491 595491 Mawne, Nicholas, of Longham, laborer 2
3904489 1991748 1991748 defendant Carre John husbandman 595491 595491 Carre, John, of Longham, husbandman 3
3910659 1993881 1993881 defendant Carre John husbandman 595491 595491 Carre, John, of Longham, husbandman 4
3918203 1996421 1996421 defendant Carr John husbandman 595491 595491 Carr, John, of Longham, husbandman 0
3918204 1996421 1996421 defendant Wellys Andrew weaver 595491 595491 Wellys, Andrew, of Longham, weaver 1
3918205 1996421 1996421 defendant Marham Geoffrey husbandman 595491 595491 Marham, Geoffrey, of Longham, husbandman 2
3928033 1999711 1999711 defendant Harryson George husbandman 595491 595491 Harryson, George, of Longham, husbandman 2
3939484 2003511 2003511 defendant Heydon John gent 595491 595491 Heydon, John, of Longham, gent 3
3944428 2005152 2005152 defendant Heydon John gent 595491 595491 Heydon, John, of Longham, gent 1
3947085 2006046 2006046 plaintiff Chesteyne William yeoman 595491 595491 Chesteyne, William, of Longham, yeoman 0
3950291 2007187 2007187 defendant Fuller John thatcher 595491 595491 Fuller, John, of Longham, thatcher 2
3950292 2007187 2007187 defendant Lamberd Reginald husbandman 595491 595491 Lamberd, Reginald, of Longham, husbandman 3
3952452 2007926 2007926 defendant Ryx James husbandman 595491 595491 Ryx, James, of Longham, husbandman 2
3952462 2007930 2007930 defendant Heydon John gent 595491 595491 Heydon, John, of Longham, gent 0
3963515 2011846 2011846 defendant Heydon John gent 595491 595491 Heydon, John, of Longham, gent 0
3963824 2011949 2011949 defendant Nickson Thomas husbandman 595491 595491 Nickson, Thomas, of Longham, husbandman 0
3994118 2022645 2022645 plaintiff Clement George gent 595491 595491 Clement, George, of Longham, gent 0
4029815 2035306 2035306 defendant Goodson Nicholas carpenter 595491 595491 Goodson, Nicholas, of Longham, carpenter 1
4046584 2041231 2041231 defendant Goodson Nicholas carpenter 595491 595491 Goodson, Nicholas, of Longham, carpenter 1
4070099 2049595 2049595 plaintiff Mallet Mathew   595491 595491 Mallet, Mathew, of Longham 0
4077589 2052273 2052273 defendant Goodson Nicholas carpenter 595491 595491 Goodson, Nicholas, of Longham, carpenter 1
4084543 2054748 2054748 defendant Comby John yeoman 595491 595491 Comby, John, of Longham, yeoman 0
4169217 2084737 2084737 defendant Burwey Robert carpenter 595491 595491 Burwey, Robert, of Longham, carpenter 0
4199368 2095331 2095331 defendant Clement George gent 595491 595491 Clement, George, of Longham, or of Kings Lynne, gent 0
4204358 2097071 2097071 defendant Wynne Arthur yeoman 595491 595491 Wynne, Arthur, of Longham, yeoman 0
4209945 2099041 2099041 defendant Clement George gent 595491 595491 Clement, George, of Longham, gent 0
4252376 2113788 2113788 defendant Cole George gent 595491 595491 Cole, George, of Longham, gent 1
4252379 2113789 2113789 defendant Cole George gent 595491 595491 Cole, George, of Longham, gent 1
4285188 2124753 2124753 defendant Larwyn William thatcher 595491 595491 Larwyn, William, of Longham, thatcher 0
4285189 2124753 2124753 defendant Wase James   595491 595491 Wase, James, of Longham, shepherd 1
4290951 2126825 2126825 defendant Stapelford Thomas husbandman 595491 595491 Stapelford, Thomas, of Longham, husbandman 3
4717123 2270684 2270684 defendant Michell Alesander yeoman 595491 595491 Michell, Alesander, of Longham, yeoman 2
4717124 2270684 2270684 defendant Wynter Adam   595491 595491 Wynter, Adam, of Longham, wheel wright 3
4762309 2284192 2284192 defendant Bokkyng Nicholas gent 595491 595491 Bokkyng, Nicholas, of Longham, gent 1
4785827 2291600 2291600 defendant Bockyng Nicholas gent 595491 595491 Bockyng, Nicholas, of Longham, gent 1
4785835 2291602 2291602 defendant Bockyng Nicholas gent 595491 595491 Bockyng, Nicholas, of Longham, gent 1
4799938 2296163 2296163 defendant Blanet or Bvlavet Thomas yeoman 595491 595491 Blanet or Bvlavet, Thomas, of Longham, yeoman 0
4812534 2300037 2300037 defendant Smyth John yeoman 595491 595491 Smyth, John, of Longham, yeoman 0
4848635 2311047 2311047 defendant Lamkyn John yeoman 595491 595491 Lamkyn, John, of Longham, yeoman 0
4848642 2311047 2311047 defendant Michell William yeoman 595491 595491 Michell, William, of Longham, yeoman 7
4887247 2322850 2322850 defendant Smyth John husbandman 595491 595491 Smyth, John, of Longham, husbandman 0
4892235 2324313 2324313 defendant Bokkyng Nicholas gent 595491 595491 Bokkyng, Nicholas, of Longham, gent 1
4902550 2327416 2327416 defendant Smyth John husbandman 595491 595491 Smyth, John, of Longham, husbandman 0
4968977 2347685 2347685 defendant Eyer or Gyer John husbandman 595491 595491 Eyer or Gyer, John, of Longham, husbandman 2
4975576 2349649 2349649 defendant Deynys Thomas (legal representative) 595491 595491 Deynys, Thomas, of Longham, executrix of 0
4987365 2353171 2353171 defendant Heyward Alice widow 595491 595491 Heyward, Alice, of Longham, widow 0
4987366 2353171 2353171 defendant Heyward John laborer 595491 595491 Heyward, John, of Longham, laborer 1
5011048 2360087 2360087 defendant Eyre John husbandman 595491 595491 Eyre, John, of Longham, husbandman 0
5017896 2362118 2362118 defendant Bokkyng Nicholas gent 595491 595491 Bokkyng, Nicholas, of Longham, gent 0
5036446 2367517 2367517 defendant Bokkyng Nicholas esq 595491 595491 Bokkyng, Nicholas, of Longham, esq 0
5038178 2368052 2368052 defendant Bokkyng Nicholas gent 595491 595491 Bokkyng, Nicholas, of Longham, gent 0
5117500 2391550 2391550 plaintiff Michil William   595491 595491 (Michil, William, of Longham 1
5125984 2394085 2394085 defendant Snoryng John gent 595491 595491 Snoryng, John, of Longham, gent 0
5144585 2399576 2399576 defendant Snoryng John gent 595491 595491 Snoryng, John, of Longham, gent 0
5179335 2409694 2409694 defendant Snoryng John gent 595491 595491 Snoryng, John, of Longham, gent 1
5201852 2416308 2416308 defendant Snoryng John gent 595491 595491 Snoryng, John, of Longham, gent 1
5279491 2439079 2439079 defendant Bockyng John esq 595491 595491 Bockyng, John, of Longham, esq 0
5319624 2450965 2450965 defendant Cheteryng John husbandman 595491 595491 Cheteryng, John, of Longham, husbandman 0
5321639 2451555 2451555 defendant Heyward John husbandman 595491 595491 Heyward, John, of Longham, husbandman 2
5332317 2454730 2454730 defendant Sekker Thomas husbanman 595491 595491 Sekker, Thomas, of Longham, husbanman 3
5337867 2456407 2456407 defendant Cheteryng William woolman 595491 595491 Cheteryng, William, of Longham, woolman 2
5407382 2477176 2477176 defendant Wymbill John yeoman 595491 595491 Wymbill, John, of Longham, yeoman 1
5459841 2492872 2492872 defendant Peke John chaplain 595491 595491 Peke, John, of Longham, chaplain 3
5482894 2499826 2499826 defendant Peke John chaplain 595491 595491 Peke, John, of Longham, chaplain 8
5486955 2500994 2500994 defendant Stede William butcher 595491 595491 Stede, William, of Longham, butcher 3
5500680 2505140 2505140 defendant Prat John husbandman 595491 595491 Prat, John, of Longham, husbandman 0
5512746 2508842 2508842 defendant Crewe Christopher yeoman 595491 595491 Crewe, Christopher, of Longham, yeoman 0
5568922 2525461 2525461 defendant Bache William husbandman 595491 595491 Bache, William, of Longham, husbandman 2

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