names

69 rows where place_id = 593774

✎ 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
3613260 1871800 1871800 defendant Bonnell Robert butcher 593774 593774 Bonnell, Robert, of Sheldon, butcher 0
3631417 1904639 1904639 defendant Venton Richard clerk 593774 593774 Venton, Richard, of Sheldon, clerk 0
3680607 1920016 1920016 defendant Whyte Robert husbandman 593774 593774 Whyte, Robert, of Sheldon, husbandman 0
3731074 1935945 1935945 defendant Hylle alias Coke Thomas husbandman 593774 593774 Hylle alias Coke, Thomas, of Sheldon, husbandman 1
3731076 1935945 1935945 defendant Blakemore John husbandman 593774 593774 Blakemore, John, of Sheldon, husbandman 3
3745654 1940548 1940548 defendant Hill alias Coke Thomas husbandman 593774 593774 Hill alias Coke, Thomas, of Sheldon, husbandman 1
3745656 1940548 1940548 defendant Blakemore John husbandman 593774 593774 Blakemore, John, of Sheldon, husbandman 3
3756054 1943849 1943849 defendant Dicons Thomas husbandman 593774 593774 Dicons, Thomas, of Sheldon, husbandman 0
3756055 1943849 1943849 defendant Dale Thomas husbandman 593774 593774 Dale, Thomas, of Sheldon, husbandman 1
3758562 1944675 1944675 defendant Hylle alias Coke Thomas husbandman 593774 593774 Hylle alias Coke, Thomas, of Sheldon, husbandman 1
3758564 1944675 1944675 defendant Blakemore John husbandman 593774 593774 Blakemore, John, of Sheldon, husbandman 3
3867510 1979369 1979369 defendant Brokehurste John husbandman 593774 593774 Brokehurste, John, of Sheldon, husbandman 0
3881327 1984020 1984020 defendant Robynson John husbandman 593774 593774 Robynson, John, of Sheldon, husbandman 0
3881328 1984020 1984020 defendant Johnson William laborer 593774 593774 Johnson, William, of Sheldon, laborer 1
3905122 1991978 1991978 defendant Marston William carpenter 593774 593774 Marston, William, of Sheldon, carpenter 0
3905123 1991978 1991978 defendant Marston Thomas miller 593774 593774 Marston, Thomas, of Sheldon, miller 1
3975996 2016171 2016171 defendant Malkyn Roger drover 593774 593774 Malkyn, Roger, of Sheldon, drover 0
3994697 2022854 2022854 defendant Smythe John husbandman 593774 593774 Smythe, John, of Sheldon, husbandman 1
4113089 2064949 2064949 defendant Duffe or Duffeild John yeoman 593774 593774 Duffe or Duffeild, John, of Sheldon, yeoman 0
4113091 2064950 2064950 defendant Duffe or Duffeilde John yeoman 593774 593774 Duffe or Duffeilde, John, of Sheldon, yeoman 0
4145139 2076460 2076460 defendant Browne Thomas yeoman 593774 593774 Browne, Thomas, of Sheldon, yeoman 0
4145141 2076461 2076461 defendant Browne Thomas yeoman 593774 593774 Browne, Thomas, of Sheldon, yeoman 0
4146943 2077080 2077080 defendant Smythe John yeoman 593774 593774 Smythe, John, of Sheldon, yeoman 0
4155343 2079960 2079960 defendant Phillipson Nicholas tailor 593774 593774 Phillipson, Nicholas, of Sheldon, tailor 0
4155344 2079960 2079960 defendant Duffeild John husbandman 593774 593774 Duffeild, John, of Sheldon, husbandman 1
4164167 2082995 2082995 defendant Sadler Richard   593774 593774 Sadler, Richard, of Sheldon, "fewester" 0
4165336 2083383 2083383 defendant Duffe alias Duffelde John husbandman 593774 593774 Duffe alias Duffelde, John, of Sheldon, husbandman 0
4171958 2085654 2085654 defendant Smythe John yeoman 593774 593774 Smythe, John, of Sheldon, yeoman 0
4187761 2091222 2091222 defendant Sadler Richard   593774 593774 Sadler, Richard, of Sheldon, "fewester" 0
4211273 2099495 2099495 defendant Sadler Richard   593774 593774 Sadler, Richard, of Sheldon, "fewester" 0
4216502 2101264 2101264 defendant Browne John laborer 593774 593774 Browne, John, of Sheldon, laborer 0
4216503 2101264 2101264 defendant Noone Henry spurrier 593774 593774 Noone, Henry, of Sheldon, spurrier 1
4220969 2102828 2102828 defendant Bellers John gent 593774 593774 Bellers, John, of Sheldon, or of Colleshill, gent 0
4229730 2105879 2105879 defendant Bellers John gent 593774 593774 Bellers, John, of Sheldon, or of Colleshill, gent 0
4247353 2112092 2112092 defendant Stephyn William yeoman 593774 593774 Stephyn, William, of Sheldon, yeoman 0
4276539 2121733 2121733 defendant Bellars John gent 593774 593774 Bellars, John, of Sheldon, gent 1
4276689 2121780 2121780 defendant Browne John laborer 593774 593774 Browne, John, of Sheldon, laborer 0
4276690 2121780 2121780 defendant Noone Henry spurrier 593774 593774 Noone, Henry, of Sheldon, spurrier 1
4277818 2122167 2122167 defendant Bellers John gent 593774 593774 Bellers, John, of Sheldon, or of Bacons End, Coleshull, Warks, gent 0
4311357 2134117 2134117 defendant Whyte Peter yeoman 593774 593774 Whyte, Peter, of Sheldon, yeoman 2
4377562 2157051 2157051 defendant Dunton Francis yeoman 593774 593774 Dunton, Francis, of Sheldon, yeoman 0
4380127 2157995 2157995 defendant Cowper William yeoman 593774 593774 Cowper, William, of Sheldon, yeoman 3
4592853 2229095 2229095 defendant Hamond John   593774 593774 Hamond, John, of Sheldon 4
4609352 2234025 2234025 defendant Browe Robert   593774 593774 Browe, Robert, of Sheldon, parson 0
4615683 2235907 2235907 defendant Gilbard John   593774 593774 Gilbard, John, of Sheldon 0
4659756 2248900 2248900 defendant Chaumberleyn John   593774 593774 Chaumberleyn, John, of Sheldon 2
4659757 2248900 2248900 defendant atte Forde John   593774 593774 atte Forde, John, of Sheldon 3
4663328 2250001 2250001 defendant Smyth William smith 593774 593774 Smyth, William, of Sheldon, smith 0
4765097 2285063 2285063 defendant Wotton John yeoman 593774 593774 Wotton, John, of Sheldon, yeoman 0
4765098 2285063 2285063 defendant (illegible) Thomas yeoman 593774 593774 _, Thomas, of Sheldon, yeoman 1
4989991 2353918 2353918 defendant Oosbarn William husbandman 593774 593774 Oosbarn, William, of Sheldon, husbandman 0
5073971 2378700 2378700 defendant Bromesmyth David smith 593774 593774 Bromesmyth, David, of Sheldon, smith 1
5275364 2437866 2437866 defendant Blakenhale Thomas husbandman 593774 593774 Blakenhale, Thomas, of Sheldon, husbandman 2
5283765 2440293 2440293 defendant Blakenhale Thomas husbandman 593774 593774 Blakenhale, Thomas, of Sheldon, husbandman 6
5323393 2452072 2452072 defendant Brokehurst William smith 593774 593774 Brokehurst, William, of Sheldon, smith 0
5323394 2452072 2452072 defendant Brokehurst Richard smith 593774 593774 Brokehurst, Richard, of Sheldon, smith 1
5326882 2453114 2453114 defendant Dounton Robert yeoman 593774 593774 Dounton, Robert, of Sheldon, yeoman 0
5338164 2456502 2456502 defendant Dale William, senior yeoman 593774 593774 Dale, William, senior, of Sheldon, yeoman 3
5355752 2461876 2461876 defendant Dale William husbandman 593774 593774 Dale, William, of Sheldon, husbandman 2
5355754 2461876 2461876 defendant Williamson Roger husbandman 593774 593774 Williamson, Roger, of Sheldon, husbandman 4
5376099 2468115 2468115 defendant Smyth Nicholas yeoman 593774 593774 Smyth, Nicholas, of Sheldon, yeoman 0
5408468 2477503 2477503 defendant Notyng Thomas husbandman 593774 593774 Notyng, Thomas, of Sheldon, husbandman 1
5434384 2485225 2485225 defendant Blakvale Thomas yeoman 593774 593774 Blakvale, Thomas, of Sheldon, yeoman 0
5510990 2508280 2508280 defendant Bowman John husbandman 593774 593774 Bowman, John, of Sheldon, husbandman 3
5556047 2521764 2521764 defendant Sheldon Henry husbandman 593774 593774 Sheldon, Henry, of Sheldon, husbandman 1
5587290 2531051 2531051 defendant Wygmore Thomas gent 593774 593774 Wygmore, Thomas, of Sheldon, gent 1
5589208 2531630 2531630 defendant Blakenall John yeoman 593774 593774 Blakenall, John, of Sheldon, yeoman 2
5607348 2537190 2537190 defendant Blakenall John yeoman 593774 593774 Blakenall, John, of Sheldon, yeoman 2
5617203 2549198 2549198 plaintiff Kyngton Richard   593774 593774 Kyngton, Richard, of Sheldon, parson 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);