names

59 rows where place_id = 596638

✎ 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
3625597 1875538 1875538 defendant Peter William butcher 596638 596638 Peter, William, of South Mymmes, butcher 1
3625598 1875538 1875538 defendant Yong William husbandman 596638 596638 Yong, William, of South Mymmes, husbandman 2
3646227 1909213 1909213 defendant Heydon John husbandman 596638 596638 (Heydon, John, of South Mymmes, husbandman 1
3654255 1911591 1911591 defendant Styrley Tjhomas colier 596638 596638 Styrley, Tjhomas, of South Mymmes, colier 0
3747389 1941098 1941098 defendant Hore William laborer 596638 596638 Hore, William, of South Mymmes, laborer 3
3768665 1947844 1947844 defendant Page John laborer 596638 596638 Page, John, of South Mymmes, laborer 7
3768666 1947844 1947844 defendant Grafton or Graston Thomas laborer 596638 596638 Grafton or Graston, Thomas, of South Mymmes, laborer 8
4098699 2059868 2059868 defendant Burr Edward yeoman 596638 596638 Burr, Edward, of South Mymmes, yeoman 0
4269137 2119272 2119272 defendant Parrott John yeoman 596638 596638 Parrott, John, of South Mymmes, yeoman 0
4483038 2195391 2195391 defendant Rycheman John   596638 596638 Rycheman, John, of South Mymmes, vicar 0
4515723 2205344 2205344 defendant Smyth William   596638 596638 Smyth, William, of South Mymmes 0
4529386 2209478 2209478 defendant Person William   596638 596638 Person, William, of South Mymmes 3
4529387 2209478 2209478 defendant Sparowe John   596638 596638 Sparowe, John, of South Mymmes 4
4529388 2209478 2209478 defendant Prest John chaplain 596638 596638 Prest, John, of South Mymmes, chaplain 5
4625960 2239074 2239074 defendant Cordell Richard   596638 596638 Cordell, Richard, of South Mymmes 0
4762709 2284317 2284317 plaintiff Fuller Richard   596638 596638 Fuller, Richard, of South Mymmes 0
4817795 2301649 2301649 defendant Copewode Thomas maltman 596638 596638 Copewode, Thomas, of South Mymmes, maltman 1
4819494 2302174 2302174 defendant Copewode William husbandman 596638 596638 Copewode, William, of south Mymmes, husbandman 0
4874174 2318863 2318863 defendant Barnaby William butcher 596638 596638 Barnaby, William, of South Mymmes, butcher 0
4874175 2318863 2318863 defendant Barnaby Richard husbandman 596638 596638 Barnaby, Richard, of South Mymmes, husbandman 1
4883527 2321762 2321762 defendant Copewode Thomas loader 596638 596638 Copewode, Thomas, of South Mymmes, loader 1
4888938 2323325 2323325 defendant Copewode Thomas loader 596638 596638 Copewode, Thomas, of South Mymmes, loader 1
4919773 2332689 2332689 defendant Copwode William maltman 596638 596638 Copwode, William, of South Mymmes, maltman 0
4931280 2336162 2336162 defendant Ruylond John drover 596638 596638 Ruylond, John, of South Mymmes, drover 3
4956557 2343919 2343919 defendant Flexmere John ostler 596638 596638 Flexmere, John, of South Mymmes, ostler 1
4956567 2343920 2343920 defendant Flexmere John ostler 596638 596638 Flexmere, John, of South Mymmes, ostler 1
4973285 2348947 2348947 defendant Worseley George gent 596638 596638 Worseley, George, of South Mymmes, gent 0
5032834 2366489 2366489 defendant Salman Thomas husbandman 596638 596638 Salman, Thomas, of South Mymmes, husbandman 0
5060496 2374717 2374717 defendant Vernon Thomas yeoman 596638 596638 Vernon, Thomas, of South Mymmes, yeoman 0
5061766 2375114 2375114 defendant Staynrope Richard laborer 596638 596638 Staynrope, Richard, of South Mymmes, laborer 0
5061767 2375114 2375114 defendant Abel Nicholas laborer 596638 596638 Abel. Nicholas, of South Mymmes, laborer 1
5061768 2375114 2375114 defendant Draper John laborer 596638 596638 Draper, John, of South Mymmes, laborer 2
5098405 2385960 2385960 defendant Edwyn John husbandman 596638 596638 Edwyn, John, of South Mymmes, husbandman 0
5098406 2385960 2385960 defendant Sharp John husbandman 596638 596638 Sharp, John, of South Mymmes, husbandman 1
5098408 2385961 2385961 defendant Edwyn John husbandman 596638 596638 Edwyn, John, of South Mymmes, husbandman 0
5098409 2385961 2385961 defendant Sharp John husbandman 596638 596638 Sharp, John, of South Mymmes, husbandman 1
5102600 2387167 2387167 defendant Delle William husbandman 596638 596638 Delle, William, of South Mymmes, husbandman 3
5108263 2388850 2388850 defendant Cook John laborer 596638 596638 Cook, John, of South Mymmes, laborer 0
5126794 2394310 2394310 defendant Eston John yeoman 596638 596638 Eston, John, of South Mymmes, yeoman 0
5127133 2394412 2394412 defendant Eston John yeoman 596638 596638 Eston, John, of South Mymmes, yeoman 0
5189995 2412816 2412816 defendant Salman Walter husbandman 596638 596638 Salman, Walter, of South Mymmes, husbandman 0
5202439 2416477 2416477 defendant Eston John yeoman 596638 596638 Eston, John, of South Mymmes, yeoman 0
5206714 2417701 2417701 defendant Salman Walter husbandman 596638 596638 Salman, Walter, of South Mymmes, husbandman 0
5210846 2418905 2418905 defendant Frowyke Henry esq 596638 596638 Frowyke, Henry, of South Mymmes, esq 0
5218653 2421183 2421183 defendant Baker Thomas laborer 596638 596638 Baker, Thomas, of South Mymmes, laborer 0
5244649 2428615 2428615 defendant Pope John husbandman 596638 596638 Pope, John, of South Mymmes, husbandman 0
5272767 2437111 2437111 defendant Lever William chaplain 596638 596638 Lever, William, of South Mymmes, chaplain 0
5272768 2437111 2437111 defendant Broker Robert husbandman 596638 596638 Broker, Robert, of South Mymmes, husbandman 1
5288277 2441591 2441591 defendant Sugdon William yeoman 596638 596638 Sugdon, William, of South Mymmes, yeoman 0
5297639 2444315 2444315 defendant Childe Philip yeoman 596638 596638 Childe, Philip, of South Mymmes, yeoman 0
5310633 2448217 2448217 defendant Frowy Henry esq 596638 596638 Frowy, Henry, of South Mymmes, esq 0
5347011 2459223 2459223 defendant Andrewe William husbandman 596638 596638 Andrewe, William, of South Mymmes, husbandman 1
5395097 2473666 2473666 defendant Knottesford Roger tailor 596638 596638 Knottesford, Roger, of South Mymmes, tailor 2
5397438 2474354 2474354 defendant Andrewe William husbandman 596638 596638 Andrewe, William, of South Mymmes, husbandman 0
5399081 2474808 2474808 defendant Rolff William husbandman 596638 596638 Rolff, William, of South Mymmes, husbandman 3
5459019 2492590 2492590 defendant Acton John tailor 596638 596638 Acton, John, of South Mymmes, tailor 2
5481570 2499416 2499416 defendant Rypley William yeoman 596638 596638 Rypley, William, of South Mymmes, yeoman 1
5595062 2533423 2533423 defendant Aldfeld William yeoman 596638 596638 Aldfeld, William, of South Mymmes, yeoman 2
5609313 2537815 2537815 defendant Michell James collier 596638 596638 Michell, James, of South Mymmes, collier 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);