names

73 rows where place_id = 628017

✎ 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
3779906 1951444 1951444 defendant Purreans alias Purvyans Thomas clerk 628017 628017 Purreans alias Purvyans, Thomas, of Est Wynche, clerk 0
3793123 1955710 1955710 defendant Purreans Thomas chaplain 628017 628017 Purreans, Thomas, of Est Wynche, chaplain 2
3850692 1973806 1973806 defendant Dogett John husbandman 628017 628017 Dogett, John, of Est Wynche, husbandman 0
3850693 1973806 1973806 defendant Atkynson Robert laborer 628017 628017 Atkynson, Robert, of Est Wynche, laborer 1
3850694 1973806 1973806 defendant Rede Thomas laborer 628017 628017 Rede, Thomas, of Est Wynche, laborer 2
3850695 1973806 1973806 defendant Heycok Margaret widow 628017 628017 Heycok, Margaret, of Est Wynche, widow 3
3850697 1973807 1973807 defendant Torold William carpenter 628017 628017 Torold, William, of Est Wynche, carpenter 0
3850699 1973808 1973808 defendant Torold William carpenter 628017 628017 Torold, William, of Est Wynche, carpenter 0
3861379 1977273 1977273 defendant Purvyans Thomas clerk 628017 628017 Purvyans, Thomas, of Est Wynche, clerk 0
3944516 2005180 2005180 defendant Colson Clement laborer 628017 628017 Colson, Clement, of Est Wynche, laborer 4
3965434 2012522 2012522 defendant Cary Thomas fishmonger 628017 628017 Cary, Thomas, of Est Wynche, fishmonger 0
3980336 2017737 2017737 defendant Sewell John husbandman 628017 628017 Sewell, John, of Est Wynche, husbandman 2
3982726 2018591 2018591 plaintiff Sewell John husbandman 628017 628017 Sewell, John, of Est Wynche, husbandman 0
4019828 2031822 2031822 defendant Church Paul   628017 628017 Church, Paul, of Est Wynche, shepherd 0
4033757 2036725 2036725 defendant Ryxe Nicholas carpenter 628017 628017 Ryxe, Nicholas, of Est Wynche, carpenter 0
4066734 2048398 2048398 defendant Churche Paul husbandman 628017 628017 Churche, Paul, of Est Wynche, husbandman 2
4088475 2056177 2056177 defendant Ryxe Nicholas husbandman 628017 628017 Ryxe, Nicholas, of Est Wynche, husbandman 1
4088476 2056177 2056177 defendant Wyndell Thomas husbandman 628017 628017 Wyndell, Thomas, of Est Wynche, husbandman 2
4135263 2072931 2072931 defendant Guybon Francis gent 628017 628017 Guybon, Francis, of Est Wynche, gent 0
4135265 2072931 2072931 defendant Carey Edward husbandman 628017 628017 Carey, Edward, of Est Wynche, husbandman 2
4146331 2076866 2076866 defendant Cleybrooke John yeoman 628017 628017 Cleybrooke, John, of Est Wynche, yeoman 0
4146332 2076866 2076866 defendant Gybson John yeoman 628017 628017 Gybson, John, of Est Wynche, yeoman 1
4184515 2090093 2090093 defendant Guybon Francis gent 628017 628017 Guybon, Francis, of East Wynche, gent 0
4188806 2091564 2091564 defendant Guybon Francis gent 628017 628017 Guybon, Francis, of Est Wynche, gent 0
4199365 2095330 2095330 defendant Cary Edward husbandman 628017 628017 Cary, Edward, of Est Wynche, husbandman 0
4205835 2097587 2097587 defendant Fuller William husbandman 628017 628017 Fuller, William, of Est Wynche, husbandman 2
4207401 2098141 2098141 defendant Fuller William glover 628017 628017 Fuller, William, of Est Wynche, glover 2
4207408 2098143 2098143 defendant Fuller William glover 628017 628017 Fuller, William, of East Wynche, glover 3
4207756 2098276 2098276 defendant Cary William husbandman 628017 628017 Cary, William, of Est Wynche, husbandman 1
4207757 2098276 2098276 defendant Fawsett Edward husbandman 628017 628017 Fawsett, Edward, of Est Wynche, husbandman 2
4209947 2099042 2099042 defendant Guybon Francis gent 628017 628017 Guybon, Francis, of Est Wynche, gent 0
4212755 2100002 2100002 defendant Guybon Francis gent 628017 628017 Guybon, Francis, of Est Wynche, gent 0
4254276 2114431 2114431 defendant Hill Thomas gent 628017 628017 Hill, Thomas, of East Wynche, gent 0
4267237 2118682 2118682 defendant Cary William yeoman 628017 628017 Cary, William, of Est Wynche, yeoman 0
4347803 2146480 2146480 defendant Goodshoo Edward yeoman 628017 628017 Goodshoo, Edward, of Est Wynche, yeoman 0
4347804 2146480 2146480 defendant Sewell Richard husbandman 628017 628017 Sewell, Richard, of Est Wynche, husbandman 1
4347805 2146480 2146480 defendant Colton Arthur tailor 628017 628017 Colton, Arthur, of Est Wynche, tailor 2
4347806 2146480 2146480 defendant Saunder Christopher husbandman 628017 628017 Saunder, Christopher, of Est Wynche, husbandman 3
4349256 2147003 2147003 defendant Gervys Thomas tailor 628017 628017 Gervys, Thomas, of Est Wynche, tailor 0
4349257 2147003 2147003 defendant Wright William husbandman 628017 628017 Wright, William, of Est Wynche, husbandman 1
4349258 2147003 2147003 defendant Sewell Richard husbandman 628017 628017 Sewell, Richard, of Est Wynche, husbandman 2
4395270 2162997 2162997 defendant Wrenham John gent 628017 628017 Wrenham, John, of East Wynche, gent 0
4411745 2168524 2168524 defendant Welles Francis clerk 628017 628017 Welles, Francis, of Est Wynche, clerk 2
4411750 2168525 2168525 defendant Welles Francis clerk 628017 628017 Welles, Francis, of Est Wynche, clerk 2
4662700 2249790 2249790 defendant Bocher Roger butcher 628017 628017 Bocher, Roger, of Est Wynche, butcher 1
4708394 2267992 2267992 defendant Spryngolde Nicholas husbandman 628017 628017 Spryngolde, Nicholas, of East Wynche, husbandman 0
4752239 2281125 2281125 defendant Ryall Walter yeoman 628017 628017 Ryall, Walter, of East Wynche, yeoman 4
4760184 2283534 2283534 defendant Ryal Walter yeoman 628017 628017 Ryal, Walter, of East Wynche, yeoman 0
4781022 2290071 2290071 defendant Frevyle Walter yeoman 628017 628017 Frevyle, Walter, of Est Wynche, yeoman 0
4799914 2296156 2296156 defendant Gandyr or Gaudyr John pedder 628017 628017 Gandyr or Gaudyr, John, of Est Wynche, pedder 0
4835564 2307112 2307112 defendant Gandyr John husbandman 628017 628017 Gandyr, John, of East Wynche, husbandman 0
4862881 2315375 2315375 defendant Gander John yeoman 628017 628017 Gander, John, of Est Wynche, yeoman 1
4946436 2340879 2340879 defendant Dolman John pedder 628017 628017 Dolman, John, of Est Wynche, pedder 0
5006244 2358720 2358720 defendant Doget William yeoman 628017 628017 Doget, William, of East Wynche, yeoman 0
5006245 2358720 2358720 defendant atte Asshe John yeoman 628017 628017 atte Asshe, John, of East Wynche, yeoman 1
5082469 2381257 2381257 plaintiff Dolman Richard pedder 628017 628017 Dolman, Richard, of Est Wynche, pedder 0
5082470 2381257 2381257 plaintiff Brooke John   628017 628017 Brooke, John, of Est Wynche 1
5082472 2381258 2381258 plaintiff Dolman Richard   628017 628017 Dolman, Richard, of Est Wynche 0
5082473 2381258 2381258 plaintiff Broke John   628017 628017 Broke, John, of Est Wynche 1
5099048 2386153 2386153 defendant Honyngton John gent 628017 628017 Honyngton, John, of Est Wynche, gent 0
5146912 2400238 2400238 defendant Doket William   628017 628017 Doket, William, of East Wynche, pedlar 2
5229490 2424239 2424239 defendant Homette John husbandman 628017 628017 Homette, John, of Est Wynche, husbandman 1
5240530 2427444 2427444 plaintiff Keche John   628017 628017 Keche, John, of Est Wynche 0
5248474 2429680 2429680 defendant Homette John husbandman 628017 628017 Homette, John, of Est Wynche, husbandman 1
5256740 2432229 2432229 defendant Colvile John yeoman 628017 628017 Colvile, John, of Est Wynche, yeoman 3
5266671 2435331 2435331 defendant Rysyng William husbandman 628017 628017 Rysyng, William, of Est Wynche, husbandman 0
5266672 2435331 2435331 defendant Benet Richard husbandman 628017 628017 Benet, Richard, of Est Wynche, husbandman 1
5273112 2437207 2437207 defendant Cappe John   628017 628017 Cappe, John, of East Wynche, parson 3
5304914 2446475 2446475 defendant Nycholasson John yeoman 628017 628017 Nycholasson, John, of East Wynche, yeoman 0
5317318 2450259 2450259 defendant Langetofte Ralph husbandman 628017 628017 Langetofte, Ralph, of Est Wynche, husbandman 0
5361074 2463490 2463490 defendant Brook John, senior yeoman 628017 628017 Brook, John, senior, of Est Wynche, yeoman 0
5510301 2508060 2508060 defendant Broke John yeoman 628017 628017 Broke, John, of Est Wynche, yeoman 2
5545443 2518656 2518656 defendant Bevyll John husbandman 628017 628017 Bevyll, John, of Est Wynche, husbandman 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);