names

57 rows where place_id = 597835

✎ 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
3630045 1904244 1904244 defendant Clerk William miller 597835 597835 Clerk, William, of Chesham, Bucks, miller 2
3683250 1920882 1920882 defendant Hardyng Edmund husbandman 597835 597835 Hardyng, Edmund, of Chesham, Bucks, husbandman 0
3744694 1940235 1940235 defendant Tredwey Edmund husbandman 597835 597835 Tredwey, Edmund, of Chesham, Bucks, husbandman 0
3749319 1941713 1941713 defendant Hutton Robert scrivener 597835 597835 Hutton, Robert, of Chesham, Bucks, scrivener 1
3749709 1941820 1941820 defendant Lote Alice widow 597835 597835 Lote, Alice, of Chesham, Bucks, widow 3
3851312 1974009 1974009 defendant Cok Nicholas yeoman 597835 597835 Cok, Nicholas, of Chesham, Bucks, yeoman 4
3971258 2014505 2014505 defendant Dell Robert yeoman 597835 597835 Dell, Robert, of Chesham, Bucks, yeoman 2
4021744 2032502 2032502 defendant Cheney Henry gent 597835 597835 Cheney, Henry, of Chesham, Bucks, gent 0
4023486 2033109 2033109 defendant Cheyney Henry gent 597835 597835 Cheyney, Henry, of Chesham, Bucks, gent 0
4026408 2034089 2034089 defendant Cheyney Henry gent 597835 597835 Cheyney, Henry, of Chesham, Bucks, gent 0
4028079 2034693 2034693 defendant Cheyney Henry gent 597835 597835 Cheyney, Henry, of Chesham, Bucks, gent 0
4045492 2040842 2040842 defendant Pare Jerome gent 597835 597835 Pare, Jerome, of Chesham, Bucks, gent 0
4066042 2048143 2048143 defendant Belgrave Thomas yeoman 597835 597835 Belgrave, Thomas, of Chesham, Bucks, yeoman 0
4066071 2048153 2048153 defendant Belgrave Thomas   597835 597835 Belgrave, Thomas, of Chesham, Bucks, wheelwright 0
4079161 2052849 2052849 defendant Lovett John yeoman 597835 597835 Lovett, John, of Chesham, Bucks, yeoman 0
4149408 2077920 2077920 defendant Saunders William clerk 597835 597835 Saunders, William, of Chesham, Bucks, clerk 0
4151812 2078747 2078747 defendant Turner Richard yeoman 597835 597835 Turner, Richard, of Chesham, Bucks, yeoman 0
4173162 2086069 2086069 defendant Baldwyn Richard yeoman 597835 597835 Baldwyn, Richard, of Chesham, Bucks, yeoman 0
4173285 2086116 2086116 defendant West John yeoman 597835 597835 West, John, of Chesham, Bucks, yeoman 0
4362710 2151719 2151719 defendant Turner Richard yeoman 597835 597835 Turner, Richard, of Chesham, Bucks, yeoman 2
4412327 2168711 2168711 defendant Overstrete Robert potter 597835 597835 Overstrete, Robert, of Chesham, Bucks, potter 2
4714826 2269970 2269970 defendant Kyngham Robert   597835 597835 Kyngham, Robert, of Chesham, Bucks, glove maker 3
4738626 2277169 2277169 defendant Milleward John husbandman 597835 597835 Milleward, John, of Chesham, Bucks, husbandman 1
4815701 2301014 2301014 defendant Cheyne Thomas esq 597835 597835 Cheyne, Thomas, of Chesham, Bucks, esq 0
4844074 2309657 2309657 defendant Maweclerk John   597835 597835 Maweclerk, John, of Chesham, Bucks, wheel wright 1
4893321 2324617 2324617 defendant Brooke William gent 597835 597835 Brooke, William, of Chesham, Bucks, gent 0
4895522 2325267 2325267 defendant Flamstede John husbandman 597835 597835 Flamstede, John, of Chesham, Bucks, husbandman 0
4903985 2327865 2327865 defendant Puttenham Thomas barker 597835 597835 Puttenham, Thomas, of Chesham, Bucks, barker 0
4910737 2329868 2329868 defendant Grynder Simon tilemaker 597835 597835 Grynder, Simon, of Chesham, Bucks, tilemaker 0
4918136 2332192 2332192 defendant Dene Henry   597835 597835 Dene, Henry, of Chesham, Bucks, tile maker 0
4929640 2335685 2335685 defendant Broun Henry husbandman 597835 597835 Broun, Henry, of Chesham, Bucks, husbandman 1
4997238 2356027 2356027 defendant Brig John chaplain 597835 597835 Brig, John, of Chesham, Bucks, chaplain 0
4997245 2356030 2356030 defendant Bryg John clerk & vicar 597835 597835 Bryg, John, of Chesham, Bucks, clerk & vicar 0
5007145 2358977 2358977 defendant Brigge John clerk 597835 597835 Brigge, John, of Chesham, Bucks, clerk 0
5026162 2364546 2364546 defendant Webbe Geoffrey smith 597835 597835 Webbe, Geoffrey, of Chesham, Bucks, smith 3
5028354 2365176 2365176 defendant Holynden John skinner 597835 597835 Holynden, John, of Chesham, Bucks, skinner 0
5028359 2365177 2365177 defendant Holynden John skinner 597835 597835 Holynden, John, of Chesham, Bucks, skinner 0
5051464 2372052 2372052 defendant Holte Thomas fuller 597835 597835 Holte, Thomas, of Chesham, Bucks, fuller 4
5097237 2385620 2385620 defendant Knollys Robert yeoman 597835 597835 Knollys, Robert, of Chesham, Bucks, yeoman 0
5134173 2396489 2396489 defendant Wedon William yeoman 597835 597835 Wedon, William, of Chesham, Bucks, yeoman 0
5192993 2413677 2413677 defendant Lynde Thomas esq 597835 597835 Lynde, Thomas, of Chesham, Bucks, esq 0
5192996 2413678 2413678 defendant Lynde Thomas esq 597835 597835 Lynde, Thomas, of Chesham, Bucks, esq 0
5207962 2418062 2418062 defendant Lynde Thomas esq 597835 597835 Lynde, Thomas, of Chesham, Bucks, esq 0
5221209 2421903 2421903 defendant of Wedon or A Weddon William yeoman 597835 597835 of Wedon or A Weddon, William,of Chesham, Bucks, yeoman 0
5245681 2428895 2428895 defendant Lynde Thomas esq 597835 597835 Lynde, Thomas, of Chesham, Bucks, esq 0
5285165 2440684 2440684 defendant Lynde Thomas gent 597835 597835 Lynde, Thomas, of Chesham, Bucks, gent 3
5285172 2440685 2440685 defendant Lynde Thomas gent 597835 597835 Lynde, Thomas, of Chesham, Bucks, gent 3
5314853 2449489 2449489 defendant Danby William laborer 597835 597835 Danby, William, of Chesham, Bucks, laborer 0
5325426 2452689 2452689 defendant Wedon William yeoman 597835 597835 Wedon, William, of Chesham, Bucks, yeoman 0
5342511 2457857 2457857 defendant Hewet John husbandman 597835 597835 Hewet, John, of Chesham, Bucks, husbandman 1
5359355 2462964 2462964 defendant Touyrsy Henry husbandman 597835 597835 Touyrsy, Henry, of Chesham, Bucks, husbandman 3
5525493 2512564 2512564 defendant Fox Henry smith 597835 597835 Fox, Henry, of Chesham, Bucks, smith 0
5525495 2512565 2512565 defendant Grynder John husbandman 597835 597835 Grynder, John, of Chesham, Bucks, husbandman 0
5525497 2512566 2512566 defendant Hayno John yeoman 597835 597835 Hayno, John, of Chesham, Bucks, yeoman 0
5525499 2512567 2512567 defendant Rudde Christopher clerk 597835 597835 Rudde, Christopher, of Chesham, Bucks, clerk 0
5525501 2512568 2512568 defendant Rudde Christopher clerk 597835 597835 Rudde, Christopher, of Chesham, Bucks, clerk 0
5545493 2518672 2518672 defendant Goodyng Richard cordwainer 597835 597835 Goodyng, Richard, of Chesham, Bucks, cordwainer 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);