names

47 rows where place_id = 597429

✎ 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
3628531 1903793 1903793 defendant Burges John butcher 597429 597429 Burges, John, of Alborough, butcher 1
3696364 1925085 1925085 defendant Warn Thomas yeoman 597429 597429 Warn, Thomas, of Alborough, yeoman 0
3708820 1929054 1929054 defendant Russell John turner 597429 597429 Russell, John, of Alborough, turner 0
3850216 1973659 1973659 defendant Hunt Thomas carpenter 597429 597429 Hunt, Thomas, of Alborough, carpenter 2
3859721 1976752 1976752 defendant Glover alias Butcher alias Sabyn John butcher 597429 597429 Glover alias Butcher alias Sabyn, John, of Alborough, butcher 0
3860276 1976935 1976935 defendant Glover alias Bocher alias Sabyn John butcher 597429 597429 Glover alias Bocher alias Sabyn, John, of Alborough, butcher 0
3915079 1995399 1995399 defendant Calver John draper 597429 597429 Calver, John, of Alborough, draper 0
3942224 2004415 2004415 defendant Grene Thomas   597429 597429 Grene, Thomas, of Alborough, wax chandler 4
3946340 2005793 2005793 defendant Perse Ambrose mariner 597429 597429 Perse, Ambrose, of Alborough, mariner 0
3950392 2007219 2007219 defendant Whitt John husbandman 597429 597429 (Whitt, John, of Alborough, husbandman 3
3976876 2016483 2016483 defendant Wyllet Nicholas mariner 597429 597429 Wyllet, Nicholas, of Alborough, mariner 2
3984239 2019131 2019131 defendant Harward Clement gent 597429 597429 Harward, Clement, of Alborough, gent 2
4002618 2025707 2025707 defendant Lancaster Robert yeoman 597429 597429 Lancaster, Robert, of Alborough, or of Bedingham, Norf, yeoman 0
4028652 2034896 2034896 plaintiff Cotterell Robert gent 597429 597429 Cotterell, Robert, of Alborough, gent 0
4042306 2039729 2039729 defendant Herward Clement esq 597429 597429 Herward, Clement, of Alborough, esq 0
4042309 2039730 2039730 defendant Herward Clement esq 597429 597429 Herward, Clement, of Alborough, esq 0
4059808 2045901 2045901 defendant More John clerk 597429 597429 More, John, of Alborough, clerk 0
4084949 2054895 2054895 defendant Harward Clement esq 597429 597429 Harward, Clement, of Alborough, esq 1
4089178 2056417 2056417 defendant Goram Simon weaver 597429 597429 Goram, Simon, of Alborough, weaver 1
4093089 2057845 2057845 defendant Wentworth Thomas yeoman 597429 597429 Wentworth, Thomas, of Alborough, yeoman 0
4093090 2057845 2057845 defendant Hutchenson John yeoman 597429 597429 Hutchenson, John, of Alborough, yeoman 1
4095205 2058608 2058608 defendant Pegeon or Pydgyon Thomas gent 597429 597429 Pegeon or Pydgyon, Thomas, of Alborough, gent 1
4214400 2100543 2100543 defendant Warde Richard yeoman 597429 597429 Warde, Richard, of Alborough, yeoman 0
4224509 2104053 2104053 defendant Weston William gent 597429 597429 Weston, William, of Alborough, gent 2
4226732 2104822 2104822 defendant Webster Robert, junior yeoman 597429 597429 Webster, Robert, junior, of Alborough, yeoman 1
4239801 2109552 2109552 defendant Hocker George yeoman 597429 597429 Hocker, George, of Alborough, or of Mile End, Colchester, yeoman 0
4241285 2110070 2110070 defendant Harward Thomas gent 597429 597429 Harward, Thomas, of Alborough, gent 0
4262183 2117024 2117024 defendant Woodcock Robert yeoman 597429 597429 Woodcock, Robert, of Alborough, yeoman 0
4274531 2121037 2121037 defendant Wolnowgh Thomas (legal representative) 597429 597429 Wolnowgh, Thomas, of Alborough, husbandman, administratrix of 3
4284845 2124625 2124625 defendant Hocker John, junior yeoman 597429 597429 Hocker, John, junior, of Alborough, yeoman 0
4323829 2138382 2138382 defendant Webster Thomas butcher 597429 597429 Webster, Thomas, of Alborough, or of Wickin, butcher 1
4325965 2139059 2139059 defendant Newson John cooper 597429 597429 Newson, John, of Alborough, cooper 0
4330360 2140457 2140457 defendant Nelson Robert yeoman 597429 597429 Nelson, Robert, of Alborough, yeoman 0
4330361 2140457 2140457 defendant Angar Thomas yeoman 597429 597429 Angar, Thomas, of Alborough, yeoman 1
4330362 2140457 2140457 defendant Daye John   597429 597429 Daye, John, of Alborough 2
4330363 2140457 2140457 defendant Everard Nicholas yeoman 597429 597429 Everard, Nicholas, of Alborough, yeoman 3
4354215 2148705 2148705 defendant Bucke Richard, senior yeoman 597429 597429 Bucke, Richard, senior, of Alborough, yeoman 0
4354216 2148705 2148705 defendant Bucke John husbandman 597429 597429 Bucke, John, of Alborough, husbandman 1
4354217 2148705 2148705 defendant Bucke Richard, junior husbandman 597429 597429 Bucke, Richard, junior, of Alborough, husbandman 2
4356137 2149369 2149369 defendant Moore John clerk 597429 597429 Moore, John, of Alborough, clerk 0
4374556 2155957 2155957 defendant Wryght Thomas yeoman 597429 597429 Wryght, Thomas, of Alborough, yeoman 0
4403187 2165637 2165637 defendant Harcocke John husbandman 597429 597429 Harcocke, John, of Alborough, husbandman 0
4404955 2166228 2166228 defendant Gogle James yeoman 597429 597429 Gogle, James, of Alborough, yeoman 0
4404960 2166229 2166229 defendant Gogle James yeoman 597429 597429 Gogle, James, of Alborough, yeoman 0
4404982 2166236 2166236 defendant Gogle James yeoman 597429 597429 Gogle, James, of Alborough, yeoman 0
4404985 2166237 2166237 defendant Gogle James yeoman 597429 597429 Gogle, James, of Alborough, yeoman 0
5455990 2491703 2491703 defendant Corbyn John husbandman 597429 597429 Corbyn, John, of Alborough, husbandman 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);