names

61 rows where place_id = 591650

✎ 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
3605094 1869258 1869258 defendant Mapulton John chaplain 591650 591650 Mapulton, John, of Wortley, chaplain 0
3631514 1904671 1904671 defendant Musgrave William husbandman 591650 591650 Musgrave, William, of Wortley, husbandman 0
3674702 1918135 1918135 defendant Came Stephen laborer 591650 591650 Came, Stephen, of Wortley, laborer 1
3685973 1921771 1921771 defendant Bradfeld John yeoman 591650 591650 Bradfeld, John, of Wortley, yeoman 0
3685974 1921771 1921771 defendant Loge Richard yeoman 591650 591650 Loge, Richard, of Wortley, yeoman 1
3685975 1921771 1921771 defendant Smyth John yeoman 591650 591650 Smyth, John, of Wortley, yeoman 2
3692135 1923709 1923709 defendant Camme William husbandman 591650 591650 Camme, William, of Wortley, husbandman 1
3692931 1923988 1923988 defendant Pawson Nicholas yeoman 591650 591650 Pawson, Nicholas, of Wortley, yeoman 0
3696512 1925138 1925138 defendant Bradford John yeoman 591650 591650 Bradford, John, of Wortley, yeoman 0
3696513 1925138 1925138 defendant Loge Richard yeoman 591650 591650 Loge, Richard, of Wortley, yeoman 1
3696514 1925138 1925138 defendant Smyth William yeoman 591650 591650 Smyth, William, of Wortley, yeoman 2
3796965 1956931 1956931 defendant Patrik William yeoman 591650 591650 Patrik, William, of Wortley, yeoman 0
3796966 1956931 1956931 defendant Boswell William gent 591650 591650 Boswell, William, of Wortley, gent 1
3796967 1956931 1956931 defendant Wilson Richard yeoman 591650 591650 Wilson, Richard, of Wortley, yeoman 2
3796970 1956932 1956932 defendant Patrik William yeoman 591650 591650 Patrik, William, of Wortley, yeoman 0
3796971 1956932 1956932 defendant Boswell William gent 591650 591650 Boswell, William, of Wortley, gent 1
3796972 1956932 1956932 defendant Wilson William yeoman 591650 591650 Wilson, William, of Wortley, yeoman 2
3838096 1969830 1969830 defendant Kirby Robert smith 591650 591650 Kirby, Robert, of Wortley, smith 0
3990831 2021478 2021478 defendant Burgen Robert yeoman 591650 591650 Burgen Robert, of Wortley, yeoman 3
4000700 2025020 2025020 defendant Spencer William husbandman 591650 591650 Spencer, William, of Wortley, husbandman 0
4037840 2038186 2038186 plaintiff Kydson or Kytson William clothier 591650 591650 Kydson or Kytson, William, of Wortley, clothier 0
4041106 2039311 2039311 defendant Casseley William clothier 591650 591650 Casseley, William, of Wortley, clothier 0
4116325 2066125 2066125 defendant Sykes Thomas   591650 591650 Sykes, Thomas, of Wortley, wood collier 0
4116327 2066126 2066126 defendant Sykes Thomas   591650 591650 Sykes, Thomas, of Wortley, wood collier 0
4121938 2068143 2068143 defendant Craven Miles clothier 591650 591650 Craven, Miles, of Wortley, clothier 1
4170812 2085281 2085281 defendant Wood Ralph nailer 591650 591650 Wood, Ralph, of Wortley, nailer 2
4278623 2122457 2122457 defendant Rowe John tanner 591650 591650 Rowe, John, of Wortley, tanner 0
4315953 2135693 2135693 defendant Cawdrey Thomas yeoman 591650 591650 Cawdrey, Thomas, of Wortley, yeoman 0
4315956 2135694 2135694 defendant Cawdrey Thomas yeoman 591650 591650 Cawdrey, Thomas, of Wortley, yeoman 0
4382058 2158683 2158683 defendant Hall Lawrence yeoman 591650 591650 together with Hall, Lawrence, of Wortley, yeoman 2
4382059 2158683 2158683 defendant Morris George yeoman 591650 591650 Morris, George, of Wortley, yeoman 3
4385607 2159869 2159869 defendant Newson William yeoman 591650 591650 Newson, William, of Wortley, yeoman 0
4386641 2160207 2160207 defendant Walker Thomas clothier 591650 591650 Walker, Thomas, of Wortley, clothier 1
4392517 2162118 2162118 defendant Ogden Robert yeoman 591650 591650 Ogden, Robert, of Wortley, yeoman 2
4401526 2165106 2165106 defendant Ford John yeoman 591650 591650 Ford, John, of Wortley, yeoman 0
4404204 2165976 2165976 defendant Higg John yeoman 591650 591650 Higg, John, of Wortley, weaver, yeoman 2
4409357 2167726 2167726 defendant Ludland Nicholas yeoman 591650 591650 Ludland, Nicholas, of Wortley, yeoman 3
4410419 2168086 2168086 defendant Craven Miles clothier 591650 591650 Craven, Miles, of Wortley, clothier 2
5012589 2360521 2360521 defendant Adamson Richard husbandman 591650 591650 Adamson, Richard, of Wortley, husbandman 4
5033891 2366787 2366787 defendant Gefson Geoffrey husbandman 591650 591650 Gefson, Geoffrey, of Wortley, husbandman 3
5033897 2366788 2366788 defendant Jefson Geoffrey husbandman 591650 591650 Jefson, Geoffrey, of Wortley, husbandman 3
5163842 2405159 2405159 defendant Wortley Nicholas (legal representative) 591650 591650 Wortley, Nicholas, of Wortley, executors of 1
5163843 2405159 2405159 defendant Wortley Robert gent 591650 591650 (Wortley, Robert, of Wortley, gent 2
5177344 2409066 2409066 defendant Wortley Thomas (legal representative) 591650 591650 Wortley, Thomas, of Wortley, executors of 1
5177345 2409066 2409066 defendant Wortley Robert gent 591650 591650 (Wortley, Robert, of Wortley, gent 2
5177346 2409066 2409066 defendant Wortley Thomas gent 591650 591650 Wortley, Thomas, of Wortley, gent 3
5200317 2415851 2415851 defendant Wortley Nicholas (legal representative) 591650 591650 Wortley, Nicholas, of Wortley, executor of 1
5200318 2415851 2415851 defendant Wortley Robert gent 591650 591650 Wortley, Robert, of Wortley, gent 2
5200319 2415851 2415851 defendant Wortley Thomas gent 591650 591650 Wortley, Thomas, of Wortley, gent 3
5457513 2492144 2492144 defendant Heyward Lawrence   591650 591650 Heyward, Lawrence, of Wortley, nail maker 0
5469339 2495760 2495760 defendant Heyward Lawrence   591650 591650 Heyward, Lawrence, of Wortley, nail maker 0
5530554 2514074 2514074 defendant Paweson Thomas yeoman 591650 591650 Paweson, Thomas, of Wortley, yeoman 0
5530555 2514074 2514074 defendant Hadfeld John laborer 591650 591650 Hadfeld, John, of Wortley, laborer 1
5530556 2514074 2514074 defendant Hudson Lawrence nailer 591650 591650 Hudson, Lawrence, of Wortley, nailer 2
5530557 2514074 2514074 defendant Hudson William nailer 591650 591650 Hudson, William, of Wortley, nailer 3
5567172 2524976 2524976 defendant Bussy Robert laborer 591650 591650 Bussy, Robert, of Wortley, laborer 1
5574474 2527099 2527099 defendant Cutte Henry nailer 591650 591650 Cutte, Henry, of Wortley, nailer 4
5582093 2529469 2529469 defendant Bussy Robert laborer 591650 591650 Bussy, Robert, of Wortley, laborer 1
5582096 2529470 2529470 defendant Bussy Robert laborer 591650 591650 Bussy, Robert, of Wortley, laborer 1
5597656 2534163 2534163 defendant Bussy Thomas laborer 591650 591650 Bussy, Thomas, of Wortley, laborer 1
5623204 2551191 2551191 defendant Bromele Richard   591650 591650 Bromele, Richard, of Wortley 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);