names

186 rows where place_id = 585945

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587545 1863753 1863753 defendant Piggot William yeoman 585945 585945 Piggot, William, of Pershore, yeoman 1
3587546 1863753 1863753 defendant Shropshire Thomas yeoman 585945 585945 Shropshire, Thomas, of Pershore, yeoman 2
3595911 1866355 1866355 defendant Walton John smith 585945 585945 Walton, John, of Pershore, smith 0
3595912 1866355 1866355 defendant Walton William   585945 585945 Walton, William, of Pershore, holy water clerk 1
3595916 1866356 1866356 defendant Walton John smith 585945 585945 Walton, John, of Pershore, smith 0
3595917 1866356 1866356 defendant Walton William   585945 585945 Walton, William, of Pershore, holy water clerk 1
3602459 1868428 1868428 defendant Squier John butcher 585945 585945 Squier, John, of Pershore, butcher 0
3610315 1870882 1870882 defendant Frewenen Thomas wheeler 585945 585945 Frewenen, Thomas, of Pershore, wheeler 0
3618242 1873329 1873329 defendant Russell John yeoman 585945 585945 Russell, John, of Pershore, yeoman 0
3618243 1873329 1873329 defendant Milton George butcher 585945 585945 Milton, George, of Pershore, butcher 1
3620502 1873988 1873988 defendant Wolmer Thomas yeoman 585945 585945 Wolmer, Thomas, of Pershore, yeoman 5
3656978 1912441 1912441 plaintiff Compton William   585945 585945 Compton, William, of Pershore, abbot of the Abbey of St. Mary and St. Eadburga 0
3656980 1912442 1912442 plaintiff Compton William   585945 585945 Compton, William, of Pershore, abbot of the Monastery of St Mary and St Edburga, the virgin 0
3665711 1915224 1915224 defendant Russell John clerk 585945 585945 Russell, John, of Pershore, clerk 0
3705494 1928009 1928009 defendant Cosnet William yeoman 585945 585945 Cosnet, William, of Pershore, yeoman 1
3705495 1928009 1928009 defendant Smyth Simon yeoman 585945 585945 Smyth, Simon, of Pershore, yeoman 2
3705496 1928009 1928009 defendant Lemster John yeoman 585945 585945 Lemster, John, of Pershore, yeoman 3
3705497 1928009 1928009 defendant Ledbery Thomas yeoman 585945 585945 Ledbery, Thomas, of Pershore, yeoman 4
3705498 1928009 1928009 defendant Shroppshire Thomas yeoman 585945 585945 Shroppshire, Thomas, of Pershore, yeoman 5
3705502 1928010 1928010 defendant Cosnet William yeoman 585945 585945 Cosnet, William, of Pershore, yeoman 1
3705503 1928010 1928010 defendant Smyth Simon yeoman 585945 585945 Smyth, Simon, of Pershore, yeoman 2
3705504 1928010 1928010 defendant Lemster John yeoman 585945 585945 Lemster, John, of Pershore, yeoman 3
3705505 1928010 1928010 defendant Ledbery Thomas yeoman 585945 585945 Ledbery, Thomas, of Pershore, yeoman 4
3705506 1928010 1928010 defendant Shroppshire Thomas yeoman 585945 585945 Shroppshire, Thomas, of Pershore, yeoman 5
3705510 1928011 1928011 defendant Cosnet William yeoman 585945 585945 Cosnet, William, of Pershore, yeoman 1
3705511 1928011 1928011 defendant Smythe Simon yeoman 585945 585945 Smythe, Simon, of Pershore, yeoman 2
3705512 1928011 1928011 defendant Lemster John yeoman 585945 585945 Lemster, John, of Pershore, yeoman 3
3705513 1928011 1928011 defendant Ledbery Thomas yeoman 585945 585945 Ledbery, Thomas, of Pershore, yeoman 4
3705514 1928011 1928011 defendant Shroppshyre Thomas yeoman 585945 585945 Shroppshyre, Thomas, of Pershore, yeoman 5
3705799 1928094 1928094 defendant Cosnet William yeoman 585945 585945 Cosnet, William, of Pershore, yeoman 1
3705800 1928094 1928094 defendant Smythe Simon yeoman 585945 585945 Smythe, Simon, of Pershore, yeoman 2
3705801 1928094 1928094 defendant Lemster John yeoman 585945 585945 Lemster, John, of Pershore, yeoman 3
3705802 1928094 1928094 defendant Ledbery Thomas yeoman 585945 585945 Ledbery, Thomas, of Pershore, yeoman 4
3705803 1928094 1928094 defendant Shropshire Thomas yeoman 585945 585945 Shropshire, Thomas, of Pershore, yeoman 5
3827771 1966552 1966552 defendant Philippis William (legal representative) 585945 585945 Philippis, William, of Pershore, shoemaker, executors of 4
3842481 1971185 1971185 defendant Smyth Thomas cordwainer 585945 585945 Smyth, Thomas, of Pershore, cordwainer 1
3868694 1979772 1979772 defendant Frenche Robert husbandman 585945 585945 Frenche, Robert, of Pershore, husbandman 0
3874419 1981673 1981673 defendant Salte Gilbert tailor 585945 585945 Salte, Gilbert, of Pershore, tailor 0
3886278 1985666 1985666 plaintiff Browne John   585945 585945 Browne, John, of Pershore 0
4240823 2109914 2109914 defendant Skelton Conard baker 585945 585945 Skelton, Conard, of Pershore, baker 2
4362925 2151800 2151800 defendant French Edward innholder 585945 585945 French, Edward, of Pershore, innholder 1
4393317 2162367 2162367 defendant Clowde alias Haryson Henry yeoman 585945 585945 Clowde alias Haryson, Henry, of Pershore, yeoman 1
4433911 2175367 2175367 defendant Baret Alexander   585945 585945 Baret, Alexander, of Pershore 0
4433921 2175368 2175368 defendant Cockes David   585945 585945 Cockes, David, of Pershore 0
4433922 2175368 2175368 defendant Baret Alexander   585945 585945 Baret, Alexander, of Pershore 1
4458105 2187566 2187566 defendant Glover John   585945 585945 Glover, John, of Pershore 0
4462354 2188922 2188922 plaintiff Symondes William draper 585945 585945 Symondes, William, of Pershore, draper 0
4465797 2189974 2189974 defendant Corveser John   585945 585945 Corveser, John, of Pershore 0
4466368 2190145 2190145 defendant Walcote Thomas   585945 585945 Walcote, Thomas, of Pershore 0
4466959 2190339 2190339 defendant Mason John   585945 585945 Mason, John, of Pershore 0
4466960 2190339 2190339 defendant Mathewe Roger   585945 585945 Mathewe, Roger, of Pershore 1
4484077 2195713 2195713 defendant Conyng John   585945 585945 Conyng, John, of Pershore 0
4504794 2202040 2202040 plaintiff Scryveyn John   585945 585945 Scryveyn, John, of Pershore 0
4509755 2203535 2203535 defendant Taillour Andrew   585945 585945 Taillour, Andrew, of Pershore 1
4509757 2203535 2203535 defendant Mille John   585945 585945 Mille, John, of Pershore 3
4509759 2203535 2203535 defendant Hunte Thomas   585945 585945 Hunte, Thomas, of Pershore 5
4534677 2211119 2211119 plaintiff Scryveyn John   585945 585945 Scryveyn, John, of Pershore 0
4549748 2215859 2215859 plaintiff Couper William   585945 585945 Couper, William, of Pershore 0
4549749 2215859 2215859 defendant Tayllour Robert   585945 585945 Tayllour, Robert, of Pershore 0
4597736 2230544 2230544 plaintiff Skynner Walter   585945 585945 Skynner, Walter, of Pershore 0
4597740 2230544 2230544 defendant Walker Roger   585945 585945 Walker, Roger, of Pershore 3
4604902 2232700 2232700 defendant Dyer Robert   585945 585945 Dyer, Robert, of Pershore 2
4649355 2245862 2245862 defendant Hill Simon   585945 585945 Hill, Simon, of Pershore 1
4649356 2245862 2245862 defendant Knappe John   585945 585945 Knappe, John, of Pershore 2
4649358 2245863 2245863 defendant Knappe John butcher 585945 585945 Knappe, John, of Pershore, butcher 0
4649359 2245864 2245864 plaintiff Vampage John   585945 585945 Vampage, John, of Pershore 0
4649361 2245864 2245864 defendant Hill Simon   585945 585945 Hill, Simon, of Pershore 1
4649362 2245864 2245864 defendant Knappe John   585945 585945 Knappe, John, of Pershore 2
4651940 2246544 2246544 defendant Wager John carpenter 585945 585945 Wager, John, of Pershore, carpenter 0
4663867 2250184 2250184 defendant Barker Edmund barker 585945 585945 Barker, Edmund, of Pershore, barker 0
4663868 2250184 2250184 defendant Typper Thomas barker 585945 585945 Typper, Thomas, of Pershore, barker 1
4689161 2262170 2262170 defendant Fareman Elizabeth spinster 585945 585945 Fareman, Elizabeth, of Pershore, spinster 0
4700335 2265521 2265521 defendant Pigeon Edmund gent 585945 585945 Pigeon, Edmund, of Pershore, gent 1
4700340 2265522 2265522 defendant Pygeon Edmund gent 585945 585945 Pygeon, Edmund, of Pershore, gent 1
4706456 2267400 2267400 defendant Ruley William walker 585945 585945 Ruley, William, of Pershore, walker 0
4718368 2271085 2271085 defendant Rusley William husbandman 585945 585945 Rusley, William, of Pershore, husbandman 0
4718371 2271085 2271085 defendant Knappe John butcher 585945 585945 Knappe, John, of Pershore, butcher 3
4718372 2271085 2271085 defendant Denys Richard tailor 585945 585945 Denys, Richard, of Pershore, tailor 4
4726366 2273531 2273531 defendant Spark Ralph smith 585945 585945 Spark, Ralph, of Pershore, smith 0
4726367 2273531 2273531 defendant Spare Walter   585945 585945 Spare, Walter, of Pershore, laborer, servant of Ralph Spare 1
4726864 2273669 2273669 defendant Kyngton Thomas gent 585945 585945 Kyngton, Thomas, of Pershore, gent 0
4734040 2275831 2275831 plaintiff Ruyhale John yeoman 585945 585945 Ruyhale, John, of Pershore, yeoman 0
4734418 2275933 2275933 plaintiff Sclattere John (legal representative) 585945 585945 Sclattere, John, of Pershore, executor of 0
4734421 2275933 2275933 defendant Wotton William husbandman 585945 585945 Wotton, William, of Pershore, husbandman 1
4746167 2279371 2279371 defendant Halle Richard husbandman 585945 585945 Halle, Richard, of Pershore, husbandman 0
4753386 2281434 2281434 defendant Pygeon Edmund gent 585945 585945 Pygeon, Edmund, of Pershore, gent 0
4753392 2281435 2281435 defendant Pygeon Edmund gent 585945 585945 Pygeon, Edmund, of Pershore, gent 0
4755201 2282013 2282013 defendant Snappe John butcher 585945 585945 Snappe, John, of Pershore, butcher 4
4763431 2284550 2284550 defendant Walker David walker 585945 585945 Walker, David, of Pershore, walker 0
4767092 2285695 2285695 defendant Tayllour John tailor 585945 585945 Tayllour, John, of Pershore, tailor 4
4767093 2285695 2285695 defendant Ruseley William yeoman 585945 585945 Ruseley, William, of Pershore, yeoman 5
4783870 2290972 2290972 defendant Gunne Thomas chaplain 585945 585945 Gunne, Thomas, of Pershore, chaplain 1
4787123 2292037 2292037 defendant Walker David walker 585945 585945 Walker, David, of Pershore, walker 0
4787125 2292038 2292038 defendant Walker David walker 585945 585945 Walker, David, of Pershore, walker 0
4818157 2301753 2301753 plaintiff Newenton William   585945 585945 Newenton, William, of Pershore, abbot 0
4822352 2303071 2303071 defendant Knappe John butcher 585945 585945 Knappe, John, of Pershore, butcher 0
4830840 2305672 2305672 plaintiff (not given) John vicar of Ledwell 585945 585945 (Ledwell, John, of Pershore, vicar of St Andrew's church 1
4841506 2308874 2308874 defendant Wyche John another monk in the same place 585945 585945 Wyche, John, of Pershore, another monk in the same place 1
4852938 2312341 2312341 defendant Kay John carter 585945 585945 Kay, John, of Pershore, carter 3
4878904 2320336 2320336 defendant Davyes Richard laborer 585945 585945 Davyes, Richard, of Pershore, laborer 0

Next page

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);