names

50 rows where place_id = 590028

✎ 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
3595511 1866230 1866230 defendant Dawes William husbandman 590028 590028 Dawes, William, of Bukby, or of Priors Newenham, Warks, husbandman 0
3599625 1867523 1867523 defendant Dawes William husbandman 590028 590028 Dawes, William, of Bukby, husbandman 0
3606096 1869574 1869574 defendant Dawes William husbandman 590028 590028 Dawes, William, of Bukby, husbandman 0
3673443 1917714 1917714 defendant Tydman John laborer 590028 590028 Tydman, John, of Bukby, laborer 1
3816688 1963124 1963124 defendant Colle William smith 590028 590028 Colle, William, of Bukby, smith 1
4483965 2195678 2195678 plaintiff Palmere Roger   590028 590028 Palmere, Roger, of Bukby 0
4564884 2220580 2220580 plaintiff Shepherd John   590028 590028 Shepherd, John, of Bukby 0
4564885 2220580 2220580 defendant Robyn Richard   590028 590028 Robyn, Richard, of Bukby 0
4611688 2234718 2234718 defendant Morys John   590028 590028 Morys, John, of Bukby 0
4611689 2234718 2234718 defendant Reynold John   590028 590028 Reynold, John, of Bukby 1
4611691 2234718 2234718 defendant Milward Thomas   590028 590028 Milward, Thomas, of Bukby 3
4611692 2234718 2234718 defendant Taillour William   590028 590028 Taillour, William, of Bukby 4
4611693 2234718 2234718 defendant Smyth William   590028 590028 Smyth, William, of Bukby 5
4652924 2246846 2246846 defendant Andrew Simon ironmonger 590028 590028 Andrew, Simon, of Bukby, ironmonger 0
4660494 2249107 2249107 defendant Verham John chaplain 590028 590028 Verham, John, of Bukby, chaplain 0
4666168 2250889 2250889 defendant Derlyng Roger husbandman 590028 590028 Derlyng, Roger, of Bukby, husbandman 0
4739512 2277441 2277441 defendant Reynald Henry yeoman 590028 590028 Reynald, Henry, of Bukby, yeoman 2
4816968 2301409 2301409 defendant Milner John milner 590028 590028 Milner, John, of Bukby, milner 1
4830432 2305552 2305552 defendant Cropthorn Richard miller 590028 590028 Cropthorn, Richard, of Bukby, miller 3
4902740 2327476 2327476 defendant Ryver John husbandman 590028 590028 Ryver, John, of Bukby, husbandman 0
4902741 2327476 2327476 defendant Ryver Richard husbandman 590028 590028 Ryver, Richard, of Bukby, husbandman 1
4912606 2330444 2330444 defendant Milner Thomas husbandman 590028 590028 Milner, Thomas, of Bukby, husbandman 0
4912609 2330445 2330445 defendant Milner Thomas husbandman 590028 590028 Milner, Thomas, of Bukby, husbandman 0
4929752 2335721 2335721 defendant Perys William husbandman 590028 590028 Perys, William, of Bukby, husbandman 3
4959943 2344935 2344935 defendant Janes alias Milner Richard yeoman 590028 590028 Janes alias Milner, Richard, of Bukby, yeoman 3
4962311 2345628 2345628 defendant Miller alias Denys Richard yeoman 590028 590028 Miller alias Denys, Richard, of Bukby, yeoman 3
4983810 2352087 2352087 defendant Robyns William husbandman 590028 590028 Robyns, William, of Bukby, husbandman 0
4983812 2352088 2352088 defendant Robyns William husbandman 590028 590028 Robyns, William, of Bukby, husbandman 0
5007086 2358967 2358967 defendant Nayleston Thomas yeoman 590028 590028 Nayleston, Thomas, of Bukby, yeoman 1
5007090 2358967 2358967 defendant Derby John laborer 590028 590028 Derby, John, of Bukby, laborer 5
5007091 2358967 2358967 defendant Taillour Peter tailor 590028 590028 Taillour, Peter, of Bukby, tailor 6
5007097 2358968 2358968 defendant Nayleston Thomas yeoman 590028 590028 together with Nayleston, Thomas, of Bukby, yeoman 1
5007099 2358968 2358968 defendant Nayleston Thomas yeoman 590028 590028 Nayleston, Thomas, of Bukby, yeoman 3
5007103 2358968 2358968 defendant Derby John laborer 590028 590028 Derby, John, of Bukby, laborer 7
5007104 2358968 2358968 defendant Taillour Peter tailor 590028 590028 Taillour, Peter, of Bukby, tailor 8
5012664 2360543 2360543 defendant Nayleston Thomas yeoman 590028 590028 Nayleston, Thomas, of Bukby, yeoman 0
5012668 2360543 2360543 defendant Derby John laborer 590028 590028 Derby, John, of Bukby, laborer 4
5012669 2360543 2360543 defendant Taillour Peter tailor 590028 590028 Taillour, Peter, of Bukby, tailor 5
5025266 2364284 2364284 plaintiff Janes alias Miller Richard yeoman 590028 590028 Janes alias Miller, Richard, of Bukby, yeoman 0
5217440 2420838 2420838 defendant Nayleston Thomas yeoman 590028 590028 Nayleston, Thomas, of Bukby, yeoman 1
5246253 2429067 2429067 defendant Miller William husbandman 590028 590028 Miller, William, of Bukby, husbandman 0
5263788 2434429 2434429 defendant Miller William husbandman 590028 590028 Miller, William, of Bukby, husbandman 0
5264079 2434524 2434524 defendant Miller William husbandman 590028 590028 together with Miller, William, of Bukby, husbandman 1
5331450 2454484 2454484 defendant Saunder Thomas smith 590028 590028 Saunder, Thomas, of Bukby, smith 1
5336267 2455920 2455920 defendant Spencer John husbandman 590028 590028 Spencer, John, of Bukby, husbandman 1
5336275 2455921 2455921 defendant Spenser John husbandman 590028 590028 Spenser, John, of Bukby, husbandman 1
5496192 2503759 2503759 defendant Langtre Lambert husbandman 590028 590028 Langtre, Lambert, of Bukby, husbandman 0
5630879 2553667 2553667 plaintiff Sendres William   590028 590028 Sendres, William, of Bukby 0
5634703 2554851 2554851 defendant Bukby John yeoman 590028 590028 Bukby, John, of Bukby, yeoman 1
5634704 2554851 2554851 defendant Russell William ploughman 590028 590028 Russell, William, of Bukby, ploughman 2

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