names

81 rows where place_id = 590114

✎ 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
3599962 1867643 1867643 defendant Hele John husbandman 590114 590114 Hele, John, of Boryngton, husbandman 0
3599963 1867643 1867643 defendant Hele William   590114 590114 Hele, William, of Boryngton, groom 1
3606316 1869644 1869644 defendant Webber Thomas courtholder 590114 590114 Webber, Thomas, of Boryngton, courtholder 0
3622773 1874654 1874654 defendant Goddislond John husbandman 590114 590114 Goddislond, John, of Boryngton, husbandman 0
3637666 1906594 1906594 defendant Bragge John husbandman 590114 590114 Bragge, John, of Boryngton, husbandman 1
3640914 1907602 1907602 defendant Ford Agnes widow 590114 590114 Ford, Agnes, of Boryngton, widow 0
3640915 1907602 1907602 defendant Tourner John husbandman 590114 590114 Tourner, John, of Boryngton, husbandman 1
3651081 1910704 1910704 defendant Lechelond John husbandman 590114 590114 Lechelond, John, of Boryngton, husbandman 0
3691627 1923538 1923538 defendant Mathewys John yeoman 590114 590114 Mathewys, John, of Boryngton, yeoman 0
3702028 1926888 1926888 defendant Ley John husbandman 590114 590114 Ley, John, of Boryngton, husbandman 0
3702029 1926888 1926888 defendant Edward Robert husbandman 590114 590114 Edward, Robert, of Boryngton, husbandman 1
3715720 1931207 1931207 defendant Ley John husbandman 590114 590114 Ley, John, of Boryngton, husbandman 0
3715722 1931207 1931207 defendant Paddon Robert husbandman 590114 590114 Paddon, Robert, of Boryngton, husbandman 2
3723714 1933692 1933692 defendant Ford Agnes widow 590114 590114 Ford, Agnes, of Boryngton, widow 0
3723715 1933692 1933692 defendant Jule John husbandman 590114 590114 Jule, John, of Boryngton, husbandman 1
3723716 1933692 1933692 defendant Ley John husbandman 590114 590114 Ley, John, of Boryngton, husbandman 2
3723717 1933692 1933692 defendant Jule Thomas   590114 590114 Jule, Thomas, of Boryngton, groom 3
3739546 1938579 1938579 defendant Ford Agnes widow 590114 590114 Ford, Agnes, of Boryngton, widow 0
3739547 1938579 1938579 defendant Jule John husbandman 590114 590114 Jule, John, of Boryngton, husbandman 1
3739548 1938579 1938579 defendant Ley John husbandman 590114 590114 Ley, John, of Boryngton, husbandman 2
3739549 1938579 1938579 defendant Jule Thomas   590114 590114 Jule, Thomas, of Boryngton, groom 3
3755649 1943722 1943722 defendant Lovell John clothier 590114 590114 Lovell, John, of Boryngton, clothier 2
3757639 1944368 1944368 defendant Hansford William husbandman 590114 590114 Hansford, William, of Boryngton, husbandman 0
3757640 1944368 1944368 defendant Shoplond John husbandman 590114 590114 Shoplond, John, of Boryngton, husbandman 1
3757641 1944368 1944368 defendant Westhorne John husbandman 590114 590114 Westhorne, John, of Boryngton, husbandman 2
3797763 1957200 1957200 defendant Squyer John, junior husbandman 590114 590114 Squyer, John, junior, of Boryngton, husbandman 0
3818659 1963739 1963739 defendant Almestome William husbandman 590114 590114 Almestome, William, of Boryngton, husbandman 0
3850161 1973640 1973640 defendant Mey John husbandman 590114 590114 Mey, John, of Boryngton, husbandman 0
3851882 1974180 1974180 plaintiff Rowkeley Thomas   590114 590114 Rowkeley, Thomas, of Boryngton 1
3861649 1977354 1977354 defendant Pole John bucker maker 590114 590114 Pole, John, of Boryngton, bucker maker 0
3861650 1977354 1977354 defendant Maye John   590114 590114 Maye, John, of Boryngton, bucket maker 1
3904738 1991843 1991843 defendant Harrys Brian chaplain 590114 590114 Harrys, Brian, of Boryngton, chaplain 0
3927429 1999520 1999520 defendant Colyar Richard husbandman 590114 590114 Colyar, Richard, of Boryngton, husbandman 0
3929511 2000218 2000218 defendant Locke Richard husbandman 590114 590114 Locke, Richard, of Boryngton, husbandman 1
3929512 2000218 2000218 defendant Lock John husbandman 590114 590114 Lock, John, of Boryngton, husbandman 2
3946541 2005856 2005856 defendant Maye John, senior husbandman 590114 590114 Maye, John, senior, of Boryngton, husbandman 0
3977008 2016526 2016526 defendant Heale John husbandman 590114 590114 Heale, John, of Boryngton, husbandman 0
4041827 2039559 2039559 plaintiff Nycoll John (legal representative) 590114 590114 Nycoll, John, of Boryngton, yeoman, administratrix of 0
4181766 2089102 2089102 defendant Wyvell Nicholas gent 590114 590114 Wyvell, Nicholas, of Boryngton, gent 0
4205193 2097367 2097367 defendant Wyvell Nicholas gent 590114 590114 Wyvell, Nicholas, of Boryngton, gent 0
4639321 2243014 2243014 defendant Chugge John clerk 590114 590114 Chugge, John, of Boryngton, clerk 1
4668445 2255843 2255843 defendant Hayward John laborer 590114 590114 Hayward, John, of Boryngton, laborer 2
4678857 2258987 2258987 defendant Stone David husbandman 590114 590114 Stone, David, of Boryngton, husbandman 3
4719356 2271395 2271395 defendant Gybbe John tailor 590114 590114 Gybbe, John, of Boryngton, tailor 0
4856329 2313354 2313354 defendant Wysburgh Robert butcher 590114 590114 Wysburgh, Robert, of Boryngton, butcher 1
4869953 2317577 2317577 defendant Honyford John cordwainer 590114 590114 Honyford, John, of Boryngton, cordwainer 1
4971063 2348285 2348285 defendant Boste Thomas clerk 590114 590114 Boste, Thomas, of Boryngton, clerk 0
4971064 2348285 2348285 defendant Norys John   590114 590114 Norys, John, of Boryngton, servant 1
4971065 2348285 2348285 defendant Nicoll Thomas laborer 590114 590114 Nicoll, Thomas, of Boryngton, laborer 2
4996197 2355719 2355719 defendant Fyssher Robert butcher 590114 590114 Fyssher, Robert, of Boryngton, butcher 0
5029308 2365449 2365449 defendant Drayton Thomas   590114 590114 Drayton, Thomas, of Boryngton, groom 10
5168194 2406409 2406409 defendant Hoveford or Honeford Robert shoemaker 590114 590114 Hoveford or Honeford, Robert, of Boryngton, shoemaker 6
5234396 2425649 2425649 defendant Goddeswill John   590114 590114 Goddeswill, John, of Boryngton, holy water clerk 1
5248848 2429782 2429782 defendant Turner Oliver husbandman 590114 590114 Turner, Oliver, of Boryngton, husbandman 1
5256750 2432232 2432232 defendant Turner Oliver husbandman 590114 590114 together with Turner, Oliver, of Boryngton, husbandman 1
5281091 2439546 2439546 defendant Potter John husbandman 590114 590114 Potter, John, of Boryngton, husbandman 0
5281092 2439546 2439546 defendant Bragge William husbandman 590114 590114 Bragge, William, of Boryngton, husbandman 1
5281093 2439546 2439546 defendant Stoddon William husbandman 590114 590114 Stoddon, William, of Boryngton, husbandman 2
5281094 2439546 2439546 defendant Cowele John turner 590114 590114 Cowele, John, of Boryngton, turner 3
5289586 2441954 2441954 defendant Bater John, junior fletcher 590114 590114 Bater, John, junior, of Boryngton, fletcher 2
5289590 2441955 2441955 defendant Bater John, junior fletcher 590114 590114 Bater, John, junior, of Boryngton, fletcher 2
5312816 2448863 2448863 defendant Torner Oliver cooper 590114 590114 Torner, Oliver, of Boryngton, cooper 0
5317750 2450393 2450393 defendant Lymbeare John husbandman 590114 590114 Lymbeare, John, of Boryngton, husbandman 0
5335340 2455639 2455639 defendant Barry John gent 590114 590114 Barry, John, of Boryngton, gent 4
5335346 2455640 2455640 defendant Barry John gent 590114 590114 Barry, John, of Boryngton, gent 4
5357209 2462315 2462315 defendant Rede John husbandman 590114 590114 Rede, John, of Boryngton, husbandman 0
5357210 2462315 2462315 defendant Coule or Conle John husbandman 590114 590114 Coule or Conle, John, of Boryngton, husbandman 1
5366736 2465253 2465253 defendant Calard John yeoman 590114 590114 Calard, John, of Boryngton, yeoman 0
5379625 2469215 2469215 defendant Goddislond John yeoman 590114 590114 Goddislond, John, of Boryngton, yeoman 2
5411530 2478407 2478407 defendant Paddon Thomas husbandman 590114 590114 Paddon, Thomas, of Boryngton, husbandman 0
5425816 2482688 2482688 defendant Paddon Thomas husbandman 590114 590114 Paddon, Thomas, of Boryngton, husbandman 0
5458789 2492519 2492519 defendant Godeslond John yeoman 590114 590114 Godeslond, John, of Boryngton, yeoman 1
5480123 2499040 2499040 defendant Goddyslond John yeoman 590114 590114 Goddyslond, John, of Boryngton, yeoman 0
5484856 2500396 2500396 defendant Paddon Thomas husbandman 590114 590114 Paddon, Thomas, of Boryngton, husbandman 2
5488953 2501568 2501568 defendant Rede John husbandman 590114 590114 Rede, John, of Boryngton, husbandman 0
5488954 2501568 2501568 defendant Forde Robert tucker 590114 590114 Forde, Robert, of Boryngton, tucker 1
5488955 2501568 2501568 defendant Rede William laborer 590114 590114 Rede, William, of Boryngton, laborer 2
5530368 2514010 2514010 defendant Goddislond John husbandman 590114 590114 Goddislond, John, of Boryngton, husbandman 0
5552826 2520878 2520878 defendant Jule John husbandman 590114 590114 Jule, John, of Boryngton, husbandman 2
5599901 2534852 2534852 defendant Forde John husbandman 590114 590114 Forde, John, of Boryngton, husbandman 1
5605519 2536608 2536608 defendant Lecheland John yeoman 590114 590114 Lecheland, John, of Boryngton, yeoman 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);