names

46 rows where place_id = 593803

✎ 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
3613404 1871839 1871839 defendant Wilson Robert brewer 593803 593803 Wilson, Robert, of Est Grenewyche, brewer 0
3713410 1930510 1930510 plaintiff Aldewyn Philip yeoman 593803 593803 Aldewyn, Philip, of Est Grenewyche, yeoman 0
3717172 1931657 1931657 defendant Rochester John esq 593803 593803 Rochester, John, of Est Grenewyche, esq 1
3717184 1931661 1931661 defendant Rochester John esq 593803 593803 Rochester, John, of Est Grenewyche, esq 1
3721351 1932985 1932985 defendant Pryour Nicholas   593803 593803 Pryour, Nicholas, of Est Grenewyche, wax chandler 1
3721352 1932985 1932985 defendant Lumley John yeoman 593803 593803 Lumley, John, of Est Grenewyche, yeoman 2
3721402 1933002 1933002 defendant Pryour Nicholas   593803 593803 Pryour, Nicholas, of Est Grenewyche, wax chandler 1
3721403 1933002 1933002 defendant Lumley John yeoman 593803 593803 Lumley, John, of Est Grenewyche, yeoman 2
3728857 1935272 1935272 defendant Draper William gent 593803 593803 Draper, William, of Est Grenewyche, gent 2
3732247 1936325 1936325 defendant Copenger John gent 593803 593803 Copenger, John, of Est Grenewyche, gent 1
3732248 1936325 1936325 defendant Potter Richard gent 593803 593803 Potter, Richard, of Est Grenewyche, gent 2
3744684 1940231 1940231 defendant Reynsforth John   593803 593803 Reynsforth, John, of Est Grenewyche, knight 3
3748107 1941333 1941333 defendant Troughton Robert gent 593803 593803 Troughton, Robert, of Est Grenewyche, gent 0
3781077 1951817 1951817 defendant Stephynson Hugh scrivener 593803 593803 Stephynson, Hugh, of Est Grenewyche, scrivener 0
3792324 1955459 1955459 defendant Sherck William carpenter 593803 593803 Sherck, William, of East Grenewyche, carpenter 1
3792325 1955459 1955459 defendant Forde William laborer 593803 593803 Forde, William, of East Grenewyche, laborer 2
3807040 1960092 1960092 defendant Morgan John yeoman of the crown 593803 593803 Morgan, John, of Est Grenewyche, yeoman of the crown 4
3808127 1960436 1960436 defendant Bulbek Richard butcher 593803 593803 Bulbek, Richard, of Est Grenewyche, butcher 0
3811484 1961483 1961483 defendant Hopkyns John innholder 593803 593803 Hopkyns, John, of Est Grenewyche, innholder 5
3817911 1963519 1963519 defendant Sakfyld Thomas gent 593803 593803 Sakfyld, Thomas, of Est Grenewyche, gent 1
3823534 1965261 1965261 defendant Skelton Thomas yeoman 593803 593803 Skelton, Thomas, of Est Grenewyche, yeoman 3
3890649 1987137 1987137 defendant (not given) Richard rector of Wall 593803 593803 Wall, Richard, of Est Grenewyche, rector of Pepulton, Worcs 0
3892753 1987826 1987826 defendant Leigton Edward clerk of the King's closet 593803 593803 Leigton, Edward, of Est Grenewyche, clerk of the King's closet 0
3897787 1989463 1989463 defendant Wright Roger yeoman 593803 593803 Wright, Roger, of Est Grenewyche, yeoman 2
4305711 2132134 2132134 defendant Humfrey John yeoman 593803 593803 Humfrey, John, of East Grenewyche, yeoman 2
4481267 2194827 2194827 plaintiff Longe John   593803 593803 Longe, John, of East Grenewyche 0
5096539 2385420 2385420 plaintiff Stevyn William chandler 593803 593803 Stevyn, William, of Est Grenewyche, chandler 0
5234707 2425736 2425736 defendant Cheseman Robert gent 593803 593803 Cheseman, Robert, of Est Grenewyche, gent 1
5328616 2453637 2453637 defendant Chapman John baker 593803 593803 Chapman, John, of Est Grenewyche, baker 2
5346022 2458892 2458892 defendant Chapman John yeoman 593803 593803 Chapman, John, of Est Grenewyche, yeoman 0
5346029 2458895 2458895 defendant Pope Robert yeoman 593803 593803 Pope, Robert, of Est Grenewyche, yeoman 0
5346030 2458895 2458895 defendant Roder alias Gate John butcher 593803 593803 Roder alias Gate, John, of Est Grenewyche, butcher 1
5364150 2464445 2464445 defendant Garnam Robert baker 593803 593803 Garnam, Robert, of Est Grenewyche, baker 1
5364151 2464445 2464445 defendant Federston William carpenter 593803 593803 Federston, William, of Est Grenewyche, carpenter 2
5364152 2464445 2464445 defendant Lee Roger carpenter 593803 593803 Lee, Roger, of Est Grenewyche, carpenter 3
5364153 2464445 2464445 defendant Geryng Robert carpenter 593803 593803 Geryng, Robert, of Est Grenewyche, carpenter 4
5394242 2473414 2473414 defendant Reylond Ralph yeoman 593803 593803 Reylond, Ralph, of East Grenewyche, yeoman 0
5407404 2477184 2477184 defendant Reylond Ralph yeoman 593803 593803 Reylond, Ralph, of East Grenewyche, yeoman 0
5420652 2481101 2481101 defendant Reylond Ralph yeoman 593803 593803 Reylond, Ralph, of East Grenewyche, yeoman 0
5512739 2508839 2508839 defendant Fyssher David yeoman 593803 593803 Fyssher, David, of Est Grenewyche, yeoman 3
5515587 2509719 2509719 defendant Elys John yeoman 593803 593803 Elys, John, of Est Grenewyche, yeoman 0
5525628 2512607 2512607 defendant Wellys John gent 593803 593803 Wellys, John, of Est Grenewyche, gent 0
5525630 2512608 2512608 defendant Wellys John gent 593803 593803 Wellys, John, of Est Grenewyche, gent 0
5540842 2517269 2517269 defendant Wellys John gent 593803 593803 Wellys, John, of Est Grenewyche, gent 0
5566400 2524763 2524763 plaintiff Coke William (legal representative) 593803 593803 Coke, William, of Est Grenewyche, lighterman, executors of 0
5597953 2534262 2534262 defendant Godyng Thomas yeoman 593803 593803 Godyng, Thomas, of Est Grenewyche, yeoman 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);