names

75 rows where place_id = 601687

✎ 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
3646509 1909307 1909307 defendant Robynson Robert innholder 601687 601687 Robynson, Robert, of Badburgham, innholder 0
3772133 1948976 1948976 defendant Swan William husbandman 601687 601687 Swan, William, of Badburgham, husbandman 1
3776883 1950510 1950510 defendant Bentley John husbandman 601687 601687 Bentley, John, of Badburgham, husbandman 3
3776884 1950510 1950510 defendant Smyth George smith 601687 601687 Smyth, George, of Badburgham, smith 4
3799836 1957867 1957867 defendant Nykson John   601687 601687 Nykson, John, of Badburgham, Cams, proctor 0
3799837 1957867 1957867 defendant Benteley John husbandman 601687 601687 Benteley, John, of Badburgham, husbandman 1
3799838 1957867 1957867 defendant Smetheman John husbandman 601687 601687 Smetheman, John, of Badburgham, husbandman 2
4442278 2182518 2182518 defendant Bonsquier John   601687 601687 Bonsquier, John, of Badburgham 0
4442746 2182685 2182685 defendant Spencer John   601687 601687 Spencer, John, of Badburgham 0
4447159 2184019 2184019 defendant Bousquier John   601687 601687 Bousquier, John, of Badburgham 0
4476998 2193465 2193465 defendant Bowyere Thomas   601687 601687 Bowyere, Thomas, of Badburgham 3
4503757 2201738 2201738 defendant Takele Thomas   601687 601687 Takele, Thomas, of Badburgham 0
4507142 2202702 2202702 defendant Brayne Richard Jones-servant   601687 601687 Brayne, Richard Jones-servant, of Badburgham 0
4514057 2204821 2204821 defendant Mountpilers Thomas   601687 601687 Mountpilers, Thomas, of Badburgham 0
4531500 2210129 2210129 defendant Rumbald John   601687 601687 Rumbald, John, of Badburgham 1
4531503 2210130 2210130 defendant Rumbald John   601687 601687 Rumbald, John, of Badburgham 1
4580713 2225447 2225447 defendant Hunte John   601687 601687 Hunte, John, of Badburgham 0
4606777 2233233 2233233 defendant Mounpellers Thomas   601687 601687 Mounpellers, Thomas, of Badburgham 0
4607506 2233460 2233460 defendant Mompellers Thomas   601687 601687 Mompellers, Thomas, of Badburgham 0
4614156 2235437 2235437 defendant Cordewaner Thomas   601687 601687 Cordewaner, Thomas, of Badburgham 0
4625630 2238976 2238976 defendant Bonsquire John   601687 601687 Bonsquire, John, of Badburgham 0
4631747 2240814 2240814 defendant Stapilton Thomas   601687 601687 Stapilton, Thomas, of Badburgham 0
4644952 2244593 2244593 defendant Halle Thomas   601687 601687 Halle, Thomas, of Badburgham 0
4682092 2260020 2260020 plaintiff Mounpellers Thomas   601687 601687 Mounpellers, Thomas, of Badburgham, on his own account 0
4682094 2260020 2260020 defendant Herberd John husbandman 601687 601687 Herberd, John, of Badburgham, husbandman 1
4682096 2260020 2260020 defendant Carpenter William carpenter 601687 601687 Carpenter, William, of Badburgham, carpenter 3
4682098 2260020 2260020 defendant Webbe John laborer 601687 601687 Webbe, John, of Badburgham, laborer 5
4704524 2266790 2266790 defendant Mountpellers Thomas   601687 601687 Mountpellers, Thomas, of Badburgham, esq, administrators of 0
4705183 2266991 2266991 defendant Beverech William husbandman 601687 601687 Beverech, William, of Badburgham, husbandman 0
4769296 2286373 2286373 defendant Dene William yeoman 601687 601687 Dene, William, of Badburgham, yeoman 2
4774898 2288143 2288143 plaintiff Webbe John   601687 601687 Webbe, John, of Badburgham 0
4779711 2289644 2289644 defendant Acton Robert   601687 601687 Acton, Robert, of Badburgham 1
4792881 2293862 2293862 defendant Reyner William yeoman 601687 601687 Reyner, William, of Badburgham, yeoman 1
4810925 2299534 2299534 defendant Reyner William butcher 601687 601687 Reyner, William, of Badburgham, butcher 0
4813302 2300276 2300276 defendant Lylter John ostler 601687 601687 Lylter, John, of Badburgham, ostler 2
4827222 2304565 2304565 defendant Wilford John, senior gent 601687 601687 Wilford, John, senior, of Badburgham, gent 0
4827223 2304565 2304565 defendant Wilford John, junior gent 601687 601687 Wilford, John, junior, of Badburgham, gent 1
4839338 2308224 2308224 defendant Munne John husbandman 601687 601687 Munne, John, of Badburgham, husbandman 3
4839903 2308393 2308393 defendant Baldok Roger hosier 601687 601687 Baldok, Roger, of Badburgham, hosier 0
4844417 2309766 2309766 defendant Shepherde Henry husbandman 601687 601687 Shepherde, Henry, of Badburgham, husbandman 0
4851162 2311815 2311815 defendant Mumme John husbandman 601687 601687 Mumme, John, of Badburgham, husbandman 2
4851168 2311816 2311816 defendant Munne John husbandman 601687 601687 Munne, John, of Badburgham, husbandman 1
4860573 2314664 2314664 defendant Baldok Roger ostler 601687 601687 Baldok, Roger, of Badburgham, ostler 0
4860574 2314664 2314664 defendant Reyner Agnes   601687 601687 Reyner, Agnes, of Badburgham, widow of Reyner, William 1
4870018 2317588 2317588 defendant Chapman Henry husbandman 601687 601687 Chapman, Henry, of Badburgham, husbandman 0
4894835 2325051 2325051 defendant Baldok Roger ostler 601687 601687 Baldok, Roger, of Badburgham, ostler 0
4906173 2328522 2328522 defendant Chapman Henry husbandman 601687 601687 Chapman, Henry, of Badburgham, husbandman 1
4908171 2329108 2329108 defendant Chapman Henry husbandman 601687 601687 Chapman, Henry, of Badburgham, husbandman 1
4908172 2329108 2329108 defendant Thurger Roger husbandman 601687 601687 Thurger, Roger, of Badburgham, husbandman 2
4908557 2329233 2329233 defendant Pye Robert miller 601687 601687 Pye, Robert, of Badburgham, miller 0
4912855 2330514 2330514 defendant Thurgore Roger husbandman 601687 601687 Thurgore, Roger, of Badburgham, husbandman 0
4916865 2331777 2331777 defendant Stapylton Thomas yeoman 601687 601687 Stapylton, Thomas, of Badburgham, yeoman 1
4916868 2331778 2331778 defendant Stonhill John husbandman 601687 601687 Stonhill, John, of Badburgham, husbandman 0
4920278 2332857 2332857 defendant Wylford John, senior gent 601687 601687 Wylford, John, senior, of Badburgham, gent 0
4920279 2332857 2332857 defendant Baldok Roger hostler 601687 601687 Baldok, Roger, of Badburgham, hostler 1
4920282 2332857 2332857 defendant Wilford John, junior gent 601687 601687 Wilford, John, junior, of Badburgham, gent 4
4935429 2337477 2337477 defendant Bateman John yeoman 601687 601687 Bateman, John, of Badburgham, yeoman 1
4942992 2339786 2339786 defendant Chapman Henry husbandman 601687 601687 Chapman, Henry, of Badburgham, husbandman 0
4983706 2352055 2352055 defendant Glovere John yeoman 601687 601687 Glovere, John, of Badburgham, yeoman 1
4990579 2354091 2354091 defendant Glover John yeoman 601687 601687 Glover, John, of Badburgham, yeoman 2
5014727 2361179 2361179 defendant Wilford John   601687 601687 Wilford, John, of Badburgham, franklin 0
5282118 2439842 2439842 defendant Sutton John yeoman 601687 601687 Sutton, John, of Badburgham, yeoman 1
5282127 2439844 2439844 defendant Sutton John yeoman 601687 601687 Sutton, John, of Badburgham, yeoman 1
5349807 2460076 2460076 defendant Trene or Treve Robert smith 601687 601687 Trene or Treve, Robert, of Badburgham, smith 0
5349808 2460076 2460076 defendant Umfrey Thomas husbandman 601687 601687 Umfrey, Thomas, of Badburgham, husbandman 1
5453197 2490837 2490837 defendant Reygat Reginald yeoman 601687 601687 Reygat, Reginald, of Badburgham, yeoman 0
5453198 2490837 2490837 defendant Smyth Thomas yeoman 601687 601687 Smyth, Thomas, of Badburgham, yeoman 1
5465115 2494473 2494473 defendant Reygat Reginald yeoman 601687 601687 Reygat, Reginald, of Badburgham, yeoman 0
5465116 2494473 2494473 defendant Smyth Thomas yeoman 601687 601687 Smyth, Thomas, of Badburgham, yeoman 1
5517892 2510439 2510439 defendant Rumbold William husbandman 601687 601687 Rumbold, William, of Badburgham, husbandman 3
5627491 2552567 2552567 defendant Pye Walter husbandman 601687 601687 Pye, Walter, of Badburgham, husbandman 0
5629078 2553065 2553065 defendant Rammok Robert husbandman 601687 601687 Rammok, Robert, of Badburgham, husbandman 0
5629079 2553065 2553065 defendant Brayne John husbandman 601687 601687 Brayne, John, of Badburgham, husbandman 1
5630184 2553446 2553446 defendant Brayn John ostler 601687 601687 Brayn, John, of Badburgham, ostler 1
5630188 2553447 2553447 defendant Brayn John ostler 601687 601687 Brayn, John, of Badburgham, ostler 1

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