names

72 rows where place_id = 597617

✎ 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
3629219 1904007 1904007 defendant Blak William yeoman 597617 597617 Blak, William, of Gamelyngey, yeoman 0
4498341 2200140 2200140 plaintiff Foulere William   597617 597617 Foulere, William, of Gamelyngey, on his own account 0
4655428 2247592 2247592 defendant Litylbody John husbandman 597617 597617 Litylbody, John, of Gamelyngey, husbandman 1
4719619 2271478 2271478 defendant Otwy John smith 597617 597617 Otwy, John, of Gamelyngey, smith 2
4719687 2271505 2271505 defendant Bocher Richard butcher 597617 597617 Bocher, Richard, of Gamelyngey, butcher 1
4725345 2273218 2273218 defendant Elewyn John butcher 597617 597617 Elewyn, John, of Gamelyngey, butcher 2
4725346 2273218 2273218 defendant Clerk John   597617 597617 Clerk, John, of Gamelyngey, holy water clerk 3
4784728 2291229 2291229 defendant Smyth John draper 597617 597617 Smyth, John, of Gamelyngey, draper 3
4785729 2291569 2291569 defendant Otewy John laborer 597617 597617 Otewy, John, of Gamelyngey, laborer 0
4794461 2294404 2294404 defendant Otewy William smith 597617 597617 Otewy, William, of Gamelyngey, smith 3
4842257 2309112 2309112 defendant Rysley Henry   597617 597617 Rysley, Henry, of Gamelyngey, wright 0
4869741 2317506 2317506 defendant Rysley Henry   597617 597617 Rysley, Henry, of Gamelyngey, wright 0
4886409 2322610 2322610 plaintiff Smyth John maltman 597617 597617 Smyth, John, of Gamelyngey, maltman 1
4901929 2327210 2327210 defendant Welifed John husbandman 597617 597617 Welifed, John, of Gamelyngey, husbandman 1
4938465 2338408 2338408 defendant Spencer John yeoman 597617 597617 Spencer, John, of Gamelyngey, yeoman 1
4938466 2338408 2338408 defendant Fraunceys Richard yeoman 597617 597617 Fraunceys, Richard, of Gamelyngey, yeoman 2
4942418 2339613 2339613 defendant Otewey William brewer 597617 597617 Otewey, William, of Gamelyngey, husbandman, or of London, brewer 0
4953298 2342948 2342948 defendant Weston Walter potter 597617 597617 Weston, Walter, of Gamelyngey, potter 1
4954673 2343351 2343351 defendant Gretyng john husbandman 597617 597617 Gretyng, john, of Gamelyngey, husbandman 1
4993794 2355013 2355013 defendant Fraunceys Richard yeoman 597617 597617 Fraunceys, Richard, of Gamelyngey, yeoman 0
5031745 2366157 2366157 defendant Elwyn Thomas butcher 597617 597617 Elwyn, Thomas, of Gamelyngey, butcher 0
5031747 2366157 2366157 defendant Elwyn John husbandman 597617 597617 Elwyn, John, of Gamelyngey, husbandman 2
5033377 2366642 2366642 defendant Canne John husbandman 597617 597617 Canne, John, of Gamelyngey, husbandman 1
5033378 2366642 2366642 defendant Gatley John husbandman 597617 597617 Gatley, John, of Gamelyngey, husbandman 2
5044343 2369939 2369939 defendant Johnson John woolmonger 597617 597617 Johnson, John, of Gamelyngey, woolmonger 0
5062422 2375328 2375328 defendant Johnson John woolman 597617 597617 Johnson, John, of Gamelyngey, woolman 0
5081628 2381012 2381012 defendant Otewey William yeoman 597617 597617 Otewey, William, of Gamelyngey, yeoman 1
5081629 2381012 2381012 defendant Smyth Thomas yeoman 597617 597617 Smyth, Thomas, of Gamelyngey, yeoman 2
5081630 2381012 2381012 defendant Aycrope ot Aytrope Richard baker 597617 597617 Aycrope ot Aytrope, Richard, of Gamelyngey, baker 3
5100860 2386666 2386666 defendant Otewey William   597617 597617 Otewey, William, of Gamelyngey 0
5119016 2391998 2391998 defendant Sudyll John yeoman 597617 597617 Sudyll, John, of Gamelyngey, yeoman 0
5119018 2391998 2391998 defendant Parnell Richard yeoman 597617 597617 Parnell, Richard, of Gamelyngey, yeoman 2
5119419 2392106 2392106 defendant Smyth Thomas yeoman 597617 597617 Smyth, Thomas, of Gamelyngey, yeoman 1
5119421 2392107 2392107 defendant Sudyll John yeoman 597617 597617 Sudyll, John, of Gamelyngey, yeoman 0
5119423 2392107 2392107 defendant Parnell Richard yeoman 597617 597617 Parnell, Richard, of Gamelyngey, yeoman 2
5178905 2409557 2409557 defendant Creffeld John husbandman 597617 597617 Creffeld, John, of Gamelyngey, husbandman 0
5183044 2410785 2410785 plaintiff Cotell John (legal representative) 597617 597617 Cotell, John, of Gamelyngey, executor of 0
5183046 2410785 2410785 defendant Elwyn Thomas butcher 597617 597617 Elwyn, Thomas, of Gamelyngey, butcher 0
5193072 2413705 2413705 defendant Snell John husbandman 597617 597617 Snell, John, of Gamelyngey, husbandman 0
5193073 2413705 2413705 defendant Warde Robert maltman 597617 597617 Warde, Robert, of Gamelyngey, maltman 1
5201659 2416252 2416252 defendant Creffeld John husbandman 597617 597617 Creffeld, John, of Gamelyngey, husbandman 0
5203702 2416833 2416833 plaintiff Cotell John   597617 597617 Cotell, John, of Gamelyngey 0
5203703 2416833 2416833 defendant Elwyn Thomas butcher 597617 597617 Elwyn, Thomas, of Gamelyngey, butcher 0
5206112 2417520 2417520 defendant Stacy Robert husbandman 597617 597617 Stacy, Robert, of Gamelyngey, husbandman 0
5206113 2417520 2417520 defendant Phelypp John husbandman 597617 597617 Phelypp, John, of Gamelyngey, husbandman 1
5206114 2417520 2417520 defendant Gylberd John husbandman 597617 597617 Gylberd, John, of Gamelyngey, husbandman 2
5208012 2418075 2418075 defendant Snell John husbandman 597617 597617 Snell, John, of Gamelyngey, husbandman 0
5252212 2430804 2430804 defendant Rede William husbandman 597617 597617 Rede, William, of Gamelyngey, husbandman 4
5296525 2443973 2443973 defendant Aythorp Richard yeoman 597617 597617 Aythorp, Richard, of Gamelyngey, yeoman 1
5325473 2452701 2452701 defendant Ponde Thomas yeoman 597617 597617 Ponde, Thomas, of Gamelyngey, yeoman 1
5325481 2452702 2452702 defendant Elwyn Thomas butcher 597617 597617 Elwyn, Thomas, of Gamelyngey, butcher 2
5349311 2459914 2459914 defendant Byrde John weaver 597617 597617 Byrde, John, of Gamelyngey, weaver 1
5358351 2462664 2462664 defendant Robyns John yeoman 597617 597617 Robyns, John, of Gamelyngey, yeoman 1
5388037 2471636 2471636 defendant Whitlake John shoemaker 597617 597617 Whitlake, John, of Gamelyngey, shoemaker 3
5393962 2473332 2473332 defendant Star_ Robert yeoman 597617 597617 Star_, Robert, of Gamelyngey, yeoman 0
5422274 2481611 2481611 defendant Goolde Robert yeoman 597617 597617 Goolde, Robert, of Gamelyngey, yeoman 0
5441885 2487502 2487502 defendant Coolde Robert yeoman 597617 597617 Coolde, Robert, of Gamelyngey, yeoman 0
5441892 2487504 2487504 defendant Goolde Robert yeoman 597617 597617 Goolde, Robert, of Gamelyngey, yeoman 0
5482806 2499802 2499802 defendant Fraunceys Richard yeoman 597617 597617 Fraunceys, Richard, of Gamelyngey, yeoman 0
5496166 2503750 2503750 defendant Paulyn William yeoman 597617 597617 Paulyn, William, of Gamelyngey, yeoman 0
5496167 2503750 2503750 defendant Preston John yeoman 597617 597617 Preston, John, of Gamelyngey, yeoman 1
5496168 2503750 2503750 defendant Boteler Robert yeoman 597617 597617 Boteler, Robert, of Gamelyngey, yeoman 2
5496169 2503750 2503750 defendant Sandon William yeoman 597617 597617 Sandon, William, of Gamelyngey, yeoman 3
5557106 2522036 2522036 defendant Gosson Richard husbandman 597617 597617 Gosson, Richard, of Gamelyngey, husbandman 1
5557107 2522036 2522036 defendant Alyn Robert butcher 597617 597617 Alyn, Robert, of Gamelyngey, butcher 2
5557108 2522036 2522036 defendant Salle Thomas husbandman 597617 597617 Salle, Thomas, of Gamelyngey, husbandman 3
5557109 2522036 2522036 defendant Dalton William husbandman 597617 597617 Dalton, William, of Gamelyngey, husbandman 4
5557111 2522036 2522036 defendant Broun William laborer 597617 597617 Broun, William, of Gamelyngey, laborer 6
5562715 2523683 2523683 defendant Gesson Richard husbandman 597617 597617 Gesson, Richard, of Gamelyngey, husbandman 2
5562725 2523684 2523684 defendant Gesson Richard husbandman 597617 597617 Gesson, Richard, of Gamelyngey, husbandman 2
5634572 2554810 2554810 defendant Otewy William smith 597617 597617 Otewy, William, of Gamelyngey, smith 1
5634577 2554811 2554811 defendant Otewy William smith 597617 597617 Otewy, William, of Gamelyngey, smith 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);