names

56 rows where place_id = 607410

✎ 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
3669126 1916280 1916280 defendant Byrchall John husbandman 607410 607410 Byrchall, John, of Yate, husbandman 0
3676603 1918720 1918720 defendant Short Richard husbandman 607410 607410 Short, Richard, of Yate, husbandman 0
3676604 1918720 1918720 defendant Baynam Thomas   607410 607410 Baynam, Thomas, of Yate, rough mason 1
3692134 1923709 1923709 defendant Parker John husbandman 607410 607410 Parker, John, of Yate, husbandman 0
3715818 1931233 1931233 defendant Spenser William butcher 607410 607410 Spenser, William, of Yate, butcher 1
3727169 1934768 1934768 defendant Belshyre William weaver 607410 607410 Belshyre, William, of Yate, weaver 0
3731273 1936007 1936007 defendant Spencer William butcher 607410 607410 Spencer, William, of Yate, butcher 1
3731283 1936010 1936010 defendant Spenser William butcher 607410 607410 Spenser, William, of Yate, butcher 1
3731943 1936221 1936221 defendant Bocher William butcher 607410 607410 Bocher, William, of Yate, butcher 0
3750558 1942093 1942093 defendant Beynam Thomas   607410 607410 Beynam, Thomas, of Yate, mason 0
3766903 1947315 1947315 defendant Dymre or Dyvire William husbandman 607410 607410 Dymre or Dyvire, William, of Yate, husbandman 2
3766908 1947316 1947316 defendant Dymre William husbandman 607410 607410 Dymre, William, of Yate, husbandman 2
3774845 1949861 1949861 defendant Riche Robert weaver 607410 607410 Riche, Robert, of Yate, weaver 0
3774846 1949861 1949861 defendant Weste John weaver 607410 607410 Weste, John, of Yate, weaver 1
3803526 1959009 1959009 defendant Nele William husbandman 607410 607410 Nele, William, of Yate, husbandman 1
3804312 1959284 1959284 defendant Nele John husbandman 607410 607410 Nele, John, of Yate, husbandman 0
3804313 1959284 1959284 defendant Nele William yeoman 607410 607410 Nele, William, of Yate, yeoman 1
3816697 1963128 1963128 defendant Packer John husbandman 607410 607410 Packer, John, of Yate, husbandman 0
3941492 2004164 2004164 defendant Colyns Thomas husbandman 607410 607410 Colyns, Thomas, of Yate, husbandman 2
3992326 2022022 2022022 plaintiff Burnell John yeoman 607410 607410 Burnell, John, of Yate, yeoman 0
4023749 2033196 2033196 plaintiff Baynam Robert clothier 607410 607410 Baynam, Robert, of Yate, clothier 0
4023753 2033197 2033197 plaintiff Baynam Robert clothier 607410 607410 Baynam, Robert, of Yate, clothier 0
4082505 2054049 2054049 defendant Colman John   607410 607410 Colman, John, of Yate, Glosm yeoman 0
4243780 2110899 2110899 defendant Belshere John yeoman 607410 607410 Belshere, John, of Yate, yeoman 2
4247944 2112297 2112297 defendant Belshere Robert weaver 607410 607410 Belshere, Robert, of Yate, weaver 0
4359889 2150701 2150701 plaintiff Belshere Robert   607410 607410 Belshere, Robert, of Yate 0
4385069 2159696 2159696 plaintiff Belcher Robert   607410 607410 Belcher, Robert, of Yate 0
4449186 2184692 2184692 defendant Bircheholte Nicholas   607410 607410 Bircheholte, Nicholas, of Yate 0
4530123 2209709 2209709 defendant Note Thomas   607410 607410 Note, Thomas, of Yate 1
4563514 2220163 2220163 defendant Wether Thomas   607410 607410 Wether, Thomas, of Yate 0
4567921 2221539 2221539 defendant Park William   607410 607410 Park, William, of Yate 0
4567925 2221539 2221539 defendant Andrewes William   607410 607410 Andrewes, William, of Yate 4
4681823 2259926 2259926 defendant Trumpeleyn Thomas husbandman 607410 607410 Trumpeleyn, Thomas, of Yate, husbandman 0
4707689 2267769 2267769 defendant Trompeleyn Thomas husbandman 607410 607410 Trompeleyn, Thomas, of Yate, husbandman 0
4803814 2297372 2297372 defendant Neel John laborer 607410 607410 Neel, John, of Yate, laborer 0
4825269 2303944 2303944 defendant Crewe Andrew husbandman 607410 607410 Crewe, Andrew, of Yate, husbandman 0
4910053 2329667 2329667 defendant Burchald or Burthale Thomas laborer 607410 607410 Burchald or Burthale, Thomas, of Yate, laborer 0
4995682 2355551 2355551 defendant Trumplyn William smith 607410 607410 Trumplyn, William, of Yate, smith 0
5014625 2361143 2361143 defendant Bonham Edmund husbandman 607410 607410 Bonham, Edmund, of Yate, husbandman 0
5055222 2373142 2373142 defendant Heynes Thomas yeoman 607410 607410 Heynes, Thomas, of Yate, yeoman 0
5304596 2446372 2446372 defendant Thommes John husbandman 607410 607410 Thommes, John, of Yate, husbandman 0
5320238 2451141 2451141 defendant Ithell William husbandman 607410 607410 Ithell, William, of Yate, husbandman 0
5494335 2503207 2503207 defendant Hawekys John husbandman 607410 607410 Hawekys, John, of Yate, husbandman 1
5494336 2503207 2503207 defendant Logge John husbandman 607410 607410 Logge, John, of Yate, husbandman 2
5520377 2511194 2511194 defendant Malet John husbandman 607410 607410 Malet, John, of Yate, husbandman 1
5520379 2511194 2511194 defendant Broun John husbandman 607410 607410 Broun, John, of Yate, husbandman 3
5541488 2517451 2517451 defendant Berchehold Robert husbandman 607410 607410 Berchehold, Robert, of Yate, husbandman 6
5541510 2517455 2517455 defendant Berchehold Robert husbandman 607410 607410 Berchehold, Robert, of Yate, husbandman 6
5551832 2520580 2520580 defendant Turnour Ambrose laborer 607410 607410 Turnour, Ambrose, of Yate, laborer 0
5551833 2520580 2520580 defendant Benham Thomas, senior   607410 607410 Benham, Thomas, senior, of Yate, mason 1
5551834 2520580 2520580 defendant Benham Thomas, junior   607410 607410 Benham, Thomas, junior, of Yate, mason 2
5579237 2528580 2528580 defendant Turnor Richard laborer 607410 607410 Turnor, Richard, of Yate, laborer 1
5579239 2528580 2528580 defendant Baynam Thomas   607410 607410 Baynam, Thomas, of Yate, mason 3
5579240 2528580 2528580 defendant Nele John laborer 607410 607410 Nele, John, of Yate, laborer 4
5594354 2533212 2533212 defendant Birchal- John husbandman 607410 607410 Birchal-, John, of Yate, husbandman 1
5603904 2536088 2536088 defendant Heynes John husbandman 607410 607410 Heynes, John, of Yate, husbandman 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);