names

48 rows where place_id = 595238

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619579 1873691 1873691 defendant Shoemaker James shoemaker 595238 595238 Shoemaker, James, of New Lemyngton, shoemaker 0
3656134 1912173 1912173 defendant Maller Robert husbandman 595238 595238 Maller, Robert, of New Lemyngton, husbandman 0
4487431 2196780 2196780 defendant Gust William   595238 595238 Gust, William, of New Lemyngton 0
4616498 2236156 2236156 plaintiff Frylond Robert   595238 595238 Frylond, Robert, of New Lemyngton 0
4759060 2283184 2283184 defendant Wymbourne Richard butcher 595238 595238 Wymbourne, Richard, of New Lemyngton, butcher 0
4768948 2286269 2286269 defendant Bakere John hosteller 595238 595238 Bakere, John, of New Lemyngton, hosteller 0
4831478 2305876 2305876 defendant Duke Martin husbandman 595238 595238 Duke, Martin, of New Lemyngton, husbandman 0
4850421 2311588 2311588 defendant Duke Mark laborer 595238 595238 Duke, Mark, of New Lemyngton, laborer 2
4850427 2311590 2311590 defendant Heryng John butcher 595238 595238 Heryng, John, of New Lemyngton, butcher 0
5007434 2359068 2359068 defendant Stokker Agnes widow 595238 595238 Stokker, Agnes, of New Lemyngton, widow 0
5056586 2373542 2373542 defendant Bocher John butcher 595238 595238 Bocher, John, of New Lemyngton, butcher 0
5066545 2376517 2376517 defendant Fraunceys John sherman 595238 595238 Fraunceys, John, of New Lemyngton, sherman 3
5076382 2379435 2379435 defendant Champeyon Thomas chapman 595238 595238 Champeyon, Thomas, of New Lemyngton,chapman 0
5080439 2380638 2380638 defendant Champyon Thomas yeoman 595238 595238 Champyon, Thomas, of New Lemyngton, yeoman 0
5080440 2380638 2380638 defendant Froket John butcher 595238 595238 Froket, John, of New Lemyngton, butcher 1
5089947 2383441 2383441 defendant Gardyner Robert tailor 595238 595238 Gardyner, Robert, of New Lemyngton, tailor 0
5127683 2394579 2394579 defendant Sewer Thomas carpenter 595238 595238 Sewer, Thomas, of New Lemyngton, carpenter 0
5145883 2399925 2399925 defendant Mewes William gent 595238 595238 Mewes, William, of New Lemyngton, gent 0
5145884 2399925 2399925 defendant Mewes Henry gent 595238 595238 Mewes, Henry, of New Lemyngton, gent 1
5145893 2399925 2399925 defendant Dommer Thomas yeoman 595238 595238 Dommer, Thomas, of New Lemyngton, yeoman 10
5145895 2399925 2399925 defendant Lyghtfote Edmund   595238 595238 Lyghtfote, Edmund, of New Lemyngton, arrow maker 12
5166211 2405843 2405843 defendant Mewes William gent 595238 595238 Mewes, William, of New Lemyngton, gent 0
5166212 2405843 2405843 defendant Mewes Henry gent 595238 595238 Mewes, Henry, of New Lemyngton, gent 1
5166223 2405843 2405843 defendant Lyghtfote Edmund fletcher 595238 595238 Lyghtfote, Edmund, of New Lemyngton, fletcher 12
5180949 2410168 2410168 defendant Mewes William gent 595238 595238 Mewes, William, of New Lemyngton, gent 0
5180950 2410168 2410168 defendant Mewes Henry gent 595238 595238 Mewes, Henry, of New Lemyngton, gent 1
5184302 2411152 2411152 defendant Dore John husbandman 595238 595238 Dore, John, of New Lemyngton, husbandman 2
5202630 2416534 2416534 defendant Mewes William gent 595238 595238 Mewes, William, of New Lemyngton, gent 0
5202631 2416534 2416534 defendant Mewes Henry gent 595238 595238 Mewes, Henry, of New Lemyngton, gent 1
5202640 2416534 2416534 defendant Dommer Thomas yeoman 595238 595238 Dommer, Thomas, of New Lemyngton, yeoman 10
5202642 2416534 2416534 defendant Lyghtfote Edmund   595238 595238 Lyghtfote, Edmund, of New Lemyngton, arrow maker 12
5204268 2417002 2417002 defendant Dore John husbandman 595238 595238 Dore, John, of New Lemyngton, husbandman 2
5207495 2417934 2417934 defendant Dene John mercer 595238 595238 Dene, John, of New Lemyngton, mercer 2
5244058 2428450 2428450 defendant Dommer Thomas yeoman 595238 595238 Dommer, Thomas, of New Lemyngton, yeoman 1
5244061 2428450 2428450 defendant Quykke John   595238 595238 Quykke, John, of New Lemyngton, "corneser" 4
5259318 2433034 2433034 defendant Stokker Thomas merchant 595238 595238 Stokker, Thomas, of New Lemyngton, merchant 0
5259320 2433034 2433034 defendant Couper Thomas cooper 595238 595238 Couper, Thomas, of New Lemyngton, cooper 2
5260012 2433253 2433253 defendant Peryn Walter tailor 595238 595238 Peryn, Walter, of New Lemyngton, tailor 1
5260014 2433253 2433253 defendant Gylpyn John yeoman 595238 595238 Gylpyn, John, of New Lemyngton, yeoman 3
5298635 2444573 2444573 defendant Oglonder Joan widow 595238 595238 Oglonder, Joan, of New Lemyngton, widow 4
5345292 2458701 2458701 defendant Bole John yeoman 595238 595238 Bole, John, of New Lemyngton, yeoman 0
5376796 2468337 2468337 defendant Holcombe Thomas merchant 595238 595238 Holcombe, Thomas, of New Lemyngton, merchant 1
5377580 2468571 2468571 defendant Holcombe Thomas merchant 595238 595238 Holcombe, Thomas, of New Lemyngton, merchant 1
5419024 2480616 2480616 defendant Holcombe William gent 595238 595238 Holcombe, William, of New Lemyngton, gent 1
5495915 2503675 2503675 plaintiff Holcombe William gent 595238 595238 Holcombe, William, of New lemyngton, gent 0
5495916 2503675 2503675 defendant Heywey Henry merchant 595238 595238 Heywey, Henry, of New Lemyngton, merchant 0
5575781 2527512 2527512 plaintiff Stokker John merchant 595238 595238 Stokker, John, of New Lemyngton, merchant 0
5590627 2532039 2532039 defendant Halyday William miller 595238 595238 Halyday, William, of New Lemyngton, miller 1

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