names

64 rows where place_id = 598952

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634661 1905639 1905639 defendant Duffeld Robert glover 598952 598952 Duffeld, Robert, of Ramsey, Hunts, glover 1
3635058 1905763 1905763 defendant Fermer Henry pewterer 598952 598952 Fermer, Henry, of Ramsey, Hunts, pewterer 4
3645148 1908890 1908890 defendant Fermer alias Freman alias Gardener Henry pewterer 598952 598952 Fermer alias Freman alias Gardener, Henry, of Ramsey, Hunts, pewterer 1
3645151 1908891 1908891 defendant Fermer alias Freman alias Gardener Henry pewterer 598952 598952 Fermer alias Freman alias Gardener, Henry, of Ramsey, Hunts, pewterer 0
3667148 1915659 1915659 defendant Somerby John, junior   598952 598952 Somerby, John, junior, of Ramsey, Hunts 0
3693187 1924080 1924080 defendant Wyggys John gent 598952 598952 Wyggys, John, of Ramsey, Hunts, gent 0
3727200 1934779 1934779 defendant Cole Richard clerk 598952 598952 Cole, Richard, of Ramsey, Hunts, clerk 1
3727205 1934780 1934780 defendant Ogle Richard clerk 598952 598952 Ogle, Richard, of Ramsey, Hunts, clerk 0
3739586 1938593 1938593 defendant Stucley Thomas gent 598952 598952 Stucley, Thomas, of Ramsey, Hunts, gent 1
3806896 1960066 1960066 defendant Draper Robert yeoman 598952 598952 Draper, Robert, of Ramsey, Hunts, yeoman 3
3806903 1960067 1960067 defendant Draper Robert yeoman 598952 598952 Draper, Robert, of Ramsey, Hunts, yeoman 3
3836674 1969371 1969371 defendant Talmache Hugh gent 598952 598952 Talmache, Hugh, of Ramsey, Hunts, gent 0
3922691 1997904 1997904 defendant Thressher John yeoman 598952 598952 Thressher, John, of Ramsey, Hunts, yeoman 1
3922698 1997905 1997905 defendant Thresher John yeoman 598952 598952 Thresher, John, of Ramsey, Hunts, yeoman 1
3945412 2005479 2005479 defendant Tynsley John yeoman 598952 598952 Tynsley, John, of Ramsey, Hunts, yeoman 0
3987989 2020451 2020451 defendant Style Thomas yeoman 598952 598952 Style, Thomas, of Ramsey, Hunts, yeoman 0
4172562 2085863 2085863 defendant Drage John husbandman 598952 598952 Drage, John, of Ramsey, Hunts, husbandman 0
4176176 2087142 2087142 defendant Younge Edward yeoman 598952 598952 Younge, Edward, of Ramsey, Hunts, yeoman 2
4176349 2087205 2087205 defendant Mascall William yeoman 598952 598952 Mascall, William, of Ramsey, Hunts, yeoman 0
4195757 2094070 2094070 defendant Dragge John husbandman 598952 598952 Dragge, John, of Ramsey, Hunts, husbandman 0
4253365 2114116 2114116 defendant Myles William chapman 598952 598952 Myles, William, of Ramsey, Hunts, chapman 0
4266603 2118476 2118476 defendant Myles William chapman 598952 598952 Myles, William, of Ramsey, Hunts, chapman 0
4312178 2134398 2134398 defendant Bonham John yeoman 598952 598952 Bonham, John, of Ramsey, Hunts, yeoman 0
4361045 2151122 2151122 defendant Myles William chapman 598952 598952 Myles, William, of Ramsey, Hunts, chapman 2
4707124 2267611 2267611 defendant Gilliot John   598952 598952 Gilliot, John, of Ramsey, Hunts, gold smith 0
4710490 2268639 2268639 defendant Shirewode William fishmonger 598952 598952 Shirewode, William, of Ramsey, Hunts, fishmonger 2
4710514 2268647 2268647 defendant Brigge John yeoman 598952 598952 Brigge, John, of Ramsey, Hunts, yeoman 0
4806672 2298297 2298297 defendant Cook Richard   598952 598952 Cook, Richard, of Ramsey, Hunts, cook 0
4835142 2306990 2306990 defendant Wysbech Geoffrey soldier 598952 598952 Wysbech, Geoffrey, of Ramsey, Hunts, gent, alias of Calais, soldier 2
4835144 2306990 2306990 defendant Rikkes John chapman 598952 598952 Rikkes, John, of Ramsey, Hunts, chapman 4
4850950 2311746 2311746 defendant Kirkeby John gent 598952 598952 Kirkeby, John, of Ramsey, Hunts, gent 0
4888110 2323087 2323087 defendant Bekyswelle John gent 598952 598952 Bekyswelle, John, of Ramsey, Hunts, gent 0
4912376 2330372 2330372 defendant Parys Henry yeoman 598952 598952 Parys, Henry, of Ramsey, Hunts, yeoman 0
4920215 2332835 2332835 defendant Revenale John butcher 598952 598952 Revenale, John, of Ramsey, Hunts, butcher 1
4929471 2335635 2335635 defendant Berford John, senior yeoman 598952 598952 Berford, John, senior, of Ramsey, Hunts, yeoman 3
4930227 2335857 2335857 defendant Geyte John shoemaker 598952 598952 Geyte, John, of Ramsey, Hunts, shoemaker 0
4944150 2340140 2340140 defendant Fuller Thomas husbandman 598952 598952 Fuller, Thomas, of Ramsey, Hunts, husbandman 2
4965956 2346747 2346747 defendant Gayle Richard shoemaker 598952 598952 Gayle, Richard, of Ramsey, Hunts, shoemaker 0
4987444 2353201 2353201 defendant Foster Gerard yeoman 598952 598952 Foster, Gerard, of Ramsey, Hunts, yeoman 0
4996352 2355767 2355767 defendant Sporyour Walter spicer 598952 598952 Sporyour, Walter, of Ramsey, Hunts, spicer 1
5023044 2363647 2363647 defendant Faunt William yeoman 598952 598952 (Faunt, William, of Ramsey, Hunts, yeoman 5
5027648 2364963 2364963 defendant Meyke John chapman 598952 598952 Meyke, John, of Ramsey, Hunts, chapman 1
5039746 2368529 2368529 defendant Meyke John, senior   598952 598952 Meyke, John, senior, of Ramsey, Hunts, minstrel 1
5081443 2380950 2380950 defendant Bole John chapman 598952 598952 Bole, John, of Ramsey, Hunts, chapman 4
5169258 2406746 2406746 defendant Bonour Thomas yeoman 598952 598952 Bonour, Thomas, of Ramsey, Hunts, yeoman 2
5283305 2440173 2440173 defendant Bonour Thomas yeoman 598952 598952 Bonour, Thomas, of Ramsey, Hunts, yeoman 0
5284559 2440495 2440495 defendant Bever William laborer 598952 598952 Bever, William, of Ramsey, Hunts, laborer 1
5374756 2467700 2467700 defendant Smyth William husbandman 598952 598952 Smyth, William, of Ramsey, Hunts, husbandman 0
5389997 2472200 2472200 defendant C__sby Richard chapman 598952 598952 C__sby, Richard, of Ramsey, Hunts, chapman 1
5398243 2474567 2474567 defendant Faunt John yeoman 598952 598952 Faunt, John, of Ramsey, Hunts, yeoman 0
5402807 2475880 2475880 defendant Causey Richard chapman 598952 598952 Causey, Richard, of Ramsey, Hunts, chapman 1
5415747 2479649 2479649 defendant Cansby Richard chapman 598952 598952 Cansby, Richard, of Ramsey, Hunts, chapman 1
5419330 2480703 2480703 defendant Whyte (illegible) gent 598952 598952 Whyte, _, of Ramsey, Hunts, gent 1
5437476 2486151 2486151 defendant Whyte William gent 598952 598952 Whyte, William, of Ramsey, Hunts, gent 1
5437635 2486192 2486192 defendant Whyte William gent 598952 598952 Whyte, William, of Ramsey, Hunts, gent 0
5457990 2492290 2492290 defendant Bonor Thomas husbandman 598952 598952 Bonor, Thomas, of Ramsey, Hunts, husbandman 0
5457992 2492291 2492291 defendant Bonor Thomas husbandman 598952 598952 Bonor, Thomas, of Ramsey, Hunts, husbandman 0
5482236 2499629 2499629 defendant Lolham John baker 598952 598952 Lolham, John, of Ramsey, Hunts, baker 0
5483721 2500081 2500081 defendant Cansby or Causby Richard chapman 598952 598952 Cansby or Causby, Richard, of Ramsey, Hunts, chapman 1
5491456 2502327 2502327 defendant Sele John smith 598952 598952 Sele, John, of Ramsey, Hunts, smith 4
5493484 2502964 2502964 defendant Lappyng Andrew merchant 598952 598952 Lappyng, Andrew, of Ramsey, Hunts, merchant 0
5512178 2508672 2508672 defendant Lapeng Adrian merchant 598952 598952 Lapeng, Adrian, of Ramsey, Hunts, merchant 0
5544072 2518255 2518255 defendant Byggyng John draper 598952 598952 Byggyng, John, of Ramsey, Hunts, draper 2
5586319 2530762 2530762 defendant Wynd John, senior gent 598952 598952 Wynd, John, senior, of Ramsey, Hunts, gent 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);