names

58 rows where place_id = 606647

✎ 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
3666036 1915314 1915314 defendant Cobley Robert draper 606647 606647 Cobley, Robert, of Calne, Wilts, draper 1
3677555 1919024 1919024 defendant Seman Thomas gent 606647 606647 Seman, Thomas, of Calne, Wilts, gent 1
3807020 1960089 1960089 defendant Blake Roger gent 606647 606647 Blake, Roger, of Calne, Wilts, gent 2
3924677 1998568 1998568 defendant Aleyne William clothier 606647 606647 Aleyne, William, of Calne, Wilts, clothier 0
3925682 1998902 1998902 defendant Aleyn William clothier 606647 606647 Aleyn, William, of Calne, Wilts, clothier 0
3928419 1999842 1999842 defendant Allen William clothman 606647 606647 Allen, William, of Calne, Wilts, clothman 0
3938391 2003182 2003182 defendant Alen William clothier 606647 606647 Alen, William, of Calne, Wilts, clothier 0
3958441 2010022 2010022 defendant Moody William gent 606647 606647 Moody, William, of Calne, Wilts, gent 3
3966767 2013012 2013012 defendant Danyell John yeoman 606647 606647 Danyell, John, of Calne, Wilts, yeoman 0
3999423 2024554 2024554 defendant Longe Thomas yeoman or clothman 606647 606647 Longe, Thomas, of Calne, Wilts, yeoman or clothman 0
3999427 2024556 2024556 defendant Longe Thomas clothman 606647 606647 Longe, Thomas, of Calne, Wilts, yeoman, clothman 0
4015695 2030311 2030311 defendant Woodroffe John yeoman 606647 606647 Woodroffe, John, of Calne, Wilts, yeoman 0
4018167 2031219 2031219 defendant Forde Robert chapman 606647 606647 Forde, Robert, of Calne, Wilts, chapman 4
4041920 2039597 2039597 defendant Danyell John yeoman 606647 606647 Danyell, John, of Calne, Wilts, yeoman 0
4041922 2039598 2039598 defendant Massey Henry yeoman 606647 606647 Massey, Henry, of Calne, Wilts, yeoman 0
4047767 2041649 2041649 defendant Danyell John yeoman 606647 606647 Danyell, John, of Calne, Wilts, yeoman 0
4047770 2041650 2041650 defendant Danyell John yeoman 606647 606647 Danyell, John, of Calne, Wilts, yeoman 0
4060927 2046316 2046316 defendant Nicholas Roger butcher 606647 606647 Nicholas, Roger, of Calne, Wilts, butcher 0
4131016 2071407 2071407 defendant Watkyns Henry chapman 606647 606647 Watkyns, Henry, of Calne, Wilts, chapman 0
4137077 2073610 2073610 defendant Broke Thomas gent 606647 606647 Broke, Thomas, of Calne, Wilts, gent 0
4137080 2073611 2073611 defendant Brooke Thomas gent 606647 606647 Brooke, Thomas, of Calne, Wilts, gent 0
4138636 2074185 2074185 defendant Massey Henry gent 606647 606647 Massey, Henry, of Calne, Wilts, gent 0
4160071 2081587 2081587 defendant Warren William gent 606647 606647 Warren, William, of Calne, Wilts, or of Stoke, Devon, gent 0
4175155 2086771 2086771 defendant Butler John yeoman 606647 606647 Butler, John, of Calne, Wilts, yeoman 0
4184807 2090195 2090195 defendant Broke Thomas gent 606647 606647 Broke, Thomas, of Calne, Wilts, gent 0
4186794 2090869 2090869 defendant Brooke Thomas gent 606647 606647 Brooke, Thomas, of Calne, Wilts, gent 0
4198275 2094945 2094945 defendant Massy Henry gent 606647 606647 Massy, Henry, of Calne, Wilts, gent 0
4227853 2105223 2105223 defendant Braye George victualer 606647 606647 Braye, George, of Calne, Wilts, butcher, victualer 0
4234353 2107552 2107552 defendant Brooke Thomas gent 606647 606647 Brooke, Thomas, of Calne, Wilts, gent 0
4236284 2108260 2108260 defendant Braye George victualer 606647 606647 Braye, George, of Calne, Wilts, butcher, victualer 0
4274853 2121151 2121151 defendant Braye George yeoman 606647 606647 Braye, George, of Calne, Wilts, yeoman 0
4288479 2125927 2125927 defendant Sampson Humphrey chapman 606647 606647 Sampson, Humphrey, of Calne, Wilts, chapman 2
4332454 2141145 2141145 defendant Dashe or Bashe John husbandman 606647 606647 Dashe or Bashe, John, of Calne, Wilts, husbandman 0
4333813 2141590 2141590 defendant Sampson Humphrey chapman 606647 606647 Sampson, Humphrey, of Calne, Wilts, chapman 1
4353067 2148301 2148301 defendant Dashe John chapman 606647 606647 Dashe, John, of Calne, Wilts, chapman 0
4369549 2154168 2154168 defendant Sampson Humphrey chapman 606647 606647 Sampson, Humphrey, of Calne, Wilts, chapman 1
4910236 2329719 2329719 plaintiff Barbour Roger tailor 606647 606647 Barbour, Roger, of Calne, Wilts, tailor 7
4915003 2331196 2331196 defendant Justice John gent 606647 606647 Justice, John, of Calne, Wilts, gent 0
4933563 2336876 2336876 defendant Justice John gent 606647 606647 Justice, John, of Calne, Wilts, gent 0
5007388 2359054 2359054 defendant Harresse Thomas chapman 606647 606647 Harresse, Thomas, of Calne, Wilts, chapman 0
5007393 2359055 2359055 defendant Harryesse Thomas chapman 606647 606647 Harryesse, Thomas, of Calne, Wilts, chapman 0
5114832 2390751 2390751 defendant Everard Walter yeoman 606647 606647 Everard, Walter, of Calne, Wilts, yeoman 2
5114837 2390752 2390752 defendant Everard Walter yeoman 606647 606647 Everard, Walter, of Calne, Wilts, yeoman 2
5126113 2394118 2394118 defendant Whyte John osteller 606647 606647 Whyte, John, of Calne, Wilts, osteller 0
5143316 2399183 2399183 defendant Hawkyns William carrier 606647 606647 Hawkyns, William, of Calne, Wilts, carrier 0
5144730 2399615 2399615 defendant Whyte John ostler 606647 606647 Whyte, John, of Calne, Wilts, ostler 0
5144732 2399616 2399616 defendant Whyte John osteller 606647 606647 Whyte, John, of Calne, Wilts, osteller 0
5155375 2402723 2402723 defendant Chapman Edmund chapman 606647 606647 Chapman, Edmund, of Calne, Wilts, chapman 0
5165453 2405641 2405641 defendant Whyte John ostler 606647 606647 Whyte, John, of Calne, Wilts, ostler 0
5228537 2423951 2423951 defendant White John yeoman 606647 606647 White, John, of Calne, Wilts, yeoman 1
5228541 2423952 2423952 defendant Whyte John yeoman 606647 606647 Whyte, John, of Calne, Wilts, yeoman 1
5452945 2490760 2490760 defendant Hill Thomas dyer 606647 606647 Hill, Thomas, of Calne, Wilts, dyer 4
5464884 2494410 2494410 defendant Hyll Thomas dyer 606647 606647 Hyll, Thomas, of Calne, Wilts, dyer 4
5476386 2497940 2497940 defendant Hill Thomas dyer 606647 606647 Hill, Thomas, of Calne, Wilts, dyer 4
5533326 2514973 2514973 defendant Reynold William yeoman 606647 606647 Reynold, William, of Calne, Wilts, yeoman 2
5533330 2514974 2514974 defendant Reynold William yeoman 606647 606647 Reynold, William, of Calne, Wilts, yeoman 2
5557258 2522083 2522083 defendant Blake Alice widow 606647 606647 Blake, Alice, of Calne, Wilts, widow 4
5574838 2527211 2527211 plaintiff Semayn Thomas gent 606647 606647 Semayn, Thomas, of Calne, Wilts, gent 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);