names

72 rows where place_id = 604448

✎ 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
3658019 1912762 1912762 defendant Wilson Robert yeoman 604448 604448 Wilson, Robert, of Wombewell, yeoman 0
3658020 1912762 1912762 defendant Alverley Edward husbasndman 604448 604448 Alverley, Edward, of Wombewell, husbasndman 1
3658023 1912763 1912763 defendant Taillour John yeoman 604448 604448 Taillour, John, of Wombewell, yeoman 0
3658025 1912764 1912764 defendant Taillour John yeoman 604448 604448 Taillour, John, of Wombewell, yeoman 0
3658029 1912765 1912765 defendant Alverley Edward husbandman 604448 604448 Alverley, Edward, of Wombewell, husbandman 2
3672928 1917545 1917545 defendant Stansfeld Robert gent 604448 604448 Stansfeld, Robert, of Wombewell, gent 1
3727167 1934767 1934767 defendant Alott Robert husbandman 604448 604448 Alott, Robert, of Wombewell, husbandman 3
3757475 1944310 1944310 defendant Morewode William yeoman 604448 604448 Morewode, William, of Wombewell, yeoman 0
3815003 1962613 1962613 defendant Scheperd Thomas husbandman 604448 604448 Scheperd, Thomas, of Wombewell, husbandman 0
3815004 1962613 1962613 defendant Tomson James yeoman 604448 604448 Tomson, James, of Wombewell, yeoman 1
3851790 1974148 1974148 defendant Lee Edward yeoman 604448 604448 Lee, Edward, of Wombewell, yeoman 1
4128941 2070650 2070650 defendant Thomson John   604448 604448 Thomson, John, of Wombewell, linen weaver 1
4128943 2070650 2070650 defendant Watman or Waterman William mercer 604448 604448 Watman or Waterman, William, of Wombewell, mercer 3
4136462 2073381 2073381 defendant Sacker Robert cordwainer 604448 604448 Sacker, Robert, of Wombewell, cordwainer 1
4166116 2083656 2083656 defendant Bilcliff Edward clerk 604448 604448 Bilcliff, Edward, of Wombewell, clerk 1
4451087 2185305 2185305 plaintiff Heron John   604448 604448 Heron, John, of Wombewell 0
4530328 2209772 2209772 defendant Fernall John   604448 604448 Fernall, John, of Wombewell 0
4573433 2223220 2223220 defendant Fernoll John   604448 604448 Fernoll, John, of Wombewell 0
4573434 2223220 2223220 defendant Edward Richard   604448 604448 Edward, Richard, of Wombewell 1
4580824 2225484 2225484 defendant Turton William de   604448 604448 Turton, William de, of Wombewell 4
4603516 2232287 2232287 defendant Fernoll John   604448 604448 Fernoll, John, of Wombewell 0
4603517 2232287 2232287 defendant Edward Richard   604448 604448 Edward, Richard, of Wombewell 1
4603521 2232289 2232289 defendant White John   604448 604448 White, John, of Wombewell 0
4714512 2269870 2269870 defendant Wombewell Thomas esq 604448 604448 Wombewell, Thomas, of Wombewell, esq 0
4718698 2271187 2271187 defendant Frape Robert yeoman 604448 604448 Frape, Robert, of Wombewell, yeoman 1
4752696 2281248 2281248 defendant Coke William draper 604448 604448 Coke, William, of Wombewell, draper 0
4809420 2299122 2299122 defendant Coke William husbandman 604448 604448 Coke, William, of Wombewell, husbandman 2
4853785 2312595 2312595 defendant Coke William yeoman 604448 604448 Coke, William, of Wombewell, yeoman 2
4853786 2312595 2312595 defendant Hunshelf William husbandman 604448 604448 Hunshelf, William, of Wombewell, husbandman 3
4877152 2319816 2319816 defendant Coke William husbandman 604448 604448 Coke, William, of Wombewell, husbandman 0
4877153 2319816 2319816 defendant Pye Henry husbandman 604448 604448 Pye, Henry, of Wombewell, husbandman 1
4877154 2319816 2319816 defendant Darlay Richard husbandman 604448 604448 Darlay, Richard, of Wombewell, husbandman 2
4877155 2319816 2319816 defendant Bakester Richard husbandman 604448 604448 Bakester, Richard, of Wombewell, husbandman 3
4958099 2344389 2344389 defendant Grene John smith 604448 604448 Grene, John, of Wombewell, smith 0
5071779 2378053 2378053 defendant Stafford John husbandman 604448 604448 Stafford, John, of Wombewell, husbandman 0
5071781 2378054 2378054 defendant Stafford William husbandman 604448 604448 Stafford, William, of Wombewell, husbandman 0
5094957 2384935 2384935 defendant Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5094958 2384935 2384935 defendant Frankyssh John yeoman 604448 604448 Frankyssh, John, of Wombewell, yeoman 1
5099906 2386410 2386410 plaintiff Wombewell Thomas (legal representative) 604448 604448 Wombewell, Thomas, of Wombewell, esq, executors of 0
5123732 2393402 2393402 plaintiff Wombewell Thomas (legal representative) 604448 604448 Wombewell, Thomas, of Wombewell, executor of 0
5129671 2395165 2395165 defendant Fulloluff Robert yeoman 604448 604448 Fulloluff, Robert, of Wombewell, yeoman 0
5129673 2395165 2395165 defendant Wombewell John esq 604448 604448 with Wombewell, John, of Wombewell, esq 2
5129678 2395167 2395167 defendant Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5129680 2395168 2395168 defendant Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5129682 2395169 2395169 defendant Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5156046 2402927 2402927 defendant Wombwell John esq 604448 604448 Wombwell, John, of Wombewell, esq 0
5156048 2402928 2402928 defendant Wombwell John esq 604448 604448 Wombwell, John, of Wombewell, esq 0
5163839 2405159 2405159 plaintiff Wombewell Thomas (legal representative) 604448 604448 Wombewell, Thomas, of Wombewell, executor of 0
5172384 2407648 2407648 defendant Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5172386 2407649 2407649 defendant Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5177335 2409065 2409065 plaintiff Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5177341 2409066 2409066 plaintiff Wombewell Thomas (legal representative) 604448 604448 Wombewell, Thomas, of Wombewell, executor of 0
5200308 2415850 2415850 plaintiff Wombewell John esq 604448 604448 Wombewell, John, of Wombewell, esq 0
5200314 2415851 2415851 plaintiff Wombewell Thomas (legal representative) 604448 604448 Wombewell, Thomas, of Wombewell, executor of 0
5200315 2415851 2415851 plaintiff Wombewell John   604448 604448 Wombewell, John, of Wombewell, son of Thomas 1
5279021 2438972 2438972 defendant Wygsall Richard tailor 604448 604448 Wygsall, Richard, of Wombewell, tailor 1
5333554 2455108 2455108 defendant Taillour John draper 604448 604448 Taillour, John, of Wombewell, draper 0
5338456 2456600 2456600 defendant Taillour John draper 604448 604448 Taillour, John, of Wombewell, draper 0
5344069 2458323 2458323 plaintiff Taillour John draper 604448 604448 Taillour, John, of Wombewell, draper 0
5371075 2466540 2466540 defendant Taylour John yeoman 604448 604448 Taylour, John, of Wombewell, yeoman 0
5371076 2466540 2466540 defendant Taylour John   604448 604448 Taylour, John, of Wombewell, yeoman & son of John, senior 1
5372692 2467058 2467058 defendant Tayllour John draper 604448 604448 Tayllour, John, of Wombewell, draper 0
5389906 2472177 2472177 defendant Tailour John draper 604448 604448 Tailour, John, of Wombewell, draper 0
5402709 2475851 2475851 defendant Taillour John draper 604448 604448 Taillour, John, of Wombewell, draper 0
5433488 2484977 2484977 defendant Taillour John draper 604448 604448 Taillour, John, of Wombewell, draper 0
5472217 2496657 2496657 defendant Taillour John, sen yeoman 604448 604448 Taillour, John, sen, of Wombewell, yeoman 0
5518121 2510502 2510502 defendant Fuloluff Robert yeoman 604448 604448 Fuloluff, Robert, of Wombewell, yeoman 0
5522613 2511898 2511898 defendant Fawekes Robert husbandman 604448 604448 Fawekes, Robert, of Wombewell, draper, Sale, Edward, of Pikeburn, husbandman 0
5546953 2519110 2519110 defendant Fawkes Robert husbandman 604448 604448 Fawkes, Robert, of Wombewell, husbandman 0
5563160 2523822 2523822 defendant Taillour John yeoman 604448 604448 Taillour, John, of Wombewell, yeoman 0
5563163 2523823 2523823 defendant Taillour John yeoman 604448 604448 Taillour, John, of Wombewell, yeoman 1
5597577 2534141 2534141 defendant Alot John husbandman 604448 604448 Alot, John, of Wombewell, husbandman 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);