names

75 rows where place_id = 625977

✎ 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
3767298 1947416 1947416 defendant Smyth John husbandman 625977 625977 Smyth, John, of Chewton, husbandman 0
3767299 1947416 1947416 defendant Vowlys William husbandman 625977 625977 Vowlys, William, of Chewton, husbandman 1
3767300 1947416 1947416 defendant Hoke John husbandman 625977 625977 Hoke, John, of Chewton, husbandman 2
3767301 1947416 1947416 defendant Howe Alice widow 625977 625977 Howe, Alice, of Chewton, widow 3
3785050 1953108 1953108 defendant Smyth John husbandman 625977 625977 Smyth, John, of Chewton, husbandman 0
3785051 1953108 1953108 defendant Vowlys William husbandman 625977 625977 Vowlys, William, of Chewton, husbandman 1
3785052 1953108 1953108 defendant Hoke John husbandman 625977 625977 Hoke, John, of Chewton, husbandman 2
3785053 1953108 1953108 defendant Howe Alice widow 625977 625977 Howe, Alice, of Chewton, widow 3
3805862 1959772 1959772 defendant Gelyborne Miles husbandman 625977 625977 Gelyborne, Miles, of Chewton, husbandman 0
3821949 1964759 1964759 defendant Broke John husbandman 625977 625977 Broke, John, of Chewton, husbandman 0
3937327 2002819 2002819 plaintiff Northen Henry   625977 625977 Northen, Henry, of Chewton under Mendip 0
4010484 2028523 2028523 plaintiff Parker Robert tailor 625977 625977 Parker, Robert, of Chewton under Mendipe, tailor 0
4016950 2030764 2030764 defendant Bourge Robert husbandman 625977 625977 Bourge, Robert, of Chewton, husbandman 0
4054727 2044079 2044079 defendant Whytt Robert husbandman 625977 625977 Whytt, Robert, of Chewton, husbandman 1
4119730 2067345 2067345 defendant Bendell Nicholas husbandman 625977 625977 Bendell, Nicholas, of Chewton, husbandman 3
4125661 2069460 2069460 defendant Pennye John husbandman 625977 625977 Pennye, John, of Chewton, husbandman 1
4132133 2071806 2071806 defendant Daniell George husbandman 625977 625977 Daniell, George, of Chewton, husbandman 0
4132134 2071806 2071806 defendant Fyvean John husbandman 625977 625977 Fyvean, John, of Chewton, husbandman 1
4142821 2075664 2075664 defendant Bendell Robert   625977 625977 Bendell, Robert, of Chewton, husbandman, "grovers" 1
4142870 2075681 2075681 defendant Reade Thomas yeoman 625977 625977 Reade, Thomas, of Chewton, yeoman 0
4144618 2076276 2076276 defendant Cole John, senior husbandman 625977 625977 Cole, John, senior, of Chewton, husbandman 2
4157842 2080818 2080818 defendant Pyckfatte Geoffrey husbandman 625977 625977 Pyckfatte, Geoffrey, of Chewton, husbandman 1
4179610 2088343 2088343 defendant Wylcoxe William husbandman or yeoman 625977 625977 Wylcoxe, William, of Chewton, husbandman or yeoman 0
4179611 2088343 2088343 defendant Burge Robert husbandman or yeoman 625977 625977 Burge, Robert, of Chewton, husbandman or yeoman 1
4179615 2088344 2088344 defendant Wylcoxe William husbandman or yeoman 625977 625977 Wylcoxe, William, of Chewton, husbandman or yeoman 0
4179616 2088344 2088344 defendant Burge Robert husbandman or yeoman 625977 625977 Burge, Robert, of Chewton, husbandman or yeoman 1
4202182 2096307 2096307 defendant Dryall John   625977 625977 Dryall, John, of Chewton, "grovyer" 1
4228104 2105309 2105309 defendant Symons Lewis yeoman 625977 625977 Symons, Lewis, of Chewton, yeoman 0
4243970 2110964 2110964 defendant Reade Thomas yeoman 625977 625977 Reade, Thomas, of Chewton, yeoman 0
4244597 2111176 2111176 defendant Dudley Charles gent 625977 625977 Dudley, Charles, of Chewton, gent 0
4245784 2111568 2111568 defendant Dudley Charles gent 625977 625977 Dudley, Charles, of Chewton, gent 0
4259134 2116029 2116029 defendant Gaye Richard yeoman 625977 625977 Gaye, Richard, of Chewton, yeoman 0
4284265 2124424 2124424 defendant Burdge John yeoman 625977 625977 Burdge, John, of Chewton, yeoman 1
4307485 2132757 2132757 defendant Dudley Charles gent 625977 625977 Dudley, Charles, of Chewton, gent 0
4307487 2132757 2132757 defendant Symons Lewis yeoman 625977 625977 Symons, Lewis, of Chewton, yeoman 2
4308213 2133023 2133023 defendant Symons Lewis yeoman 625977 625977 Symons, Lewis, of Chewton, yeoman 0
4309170 2133363 2133363 defendant Wenselye John yeoman 625977 625977 Wenselye, John, of Chewton, yeoman 1
4312704 2134575 2134575 defendant Wilcoxe John yeoman 625977 625977 Wilcoxe, John, of Chewton, yeoman 0
4312706 2134576 2134576 defendant Wilcoxe William yeoman 625977 625977 Wilcoxe, William, of Chewton, yeoman 0
4314228 2135084 2135084 defendant Dudlye Charles gent 625977 625977 Dudlye, Charles, of Chewton, gent 0
4314774 2135278 2135278 defendant Burges John yeoman 625977 625977 Burges, John, of Chewton, yeoman 0
4316324 2135824 2135824 defendant Wenseley John yeoman 625977 625977 Wenseley, John, of Chewton, yeoman 1
4317571 2136260 2136260 defendant Dudley Charles gent 625977 625977 Dudley, Charles, of Chewton, gent 1
4317572 2136260 2136260 defendant Symons Lewis yeoman 625977 625977 Symons, Lewis, of Chewton, yeoman 2
4328155 2139732 2139732 defendant Burges John yeoman 625977 625977 Burges, John, of Chewton, yeoman 0
4332369 2141117 2141117 defendant Reade Thomas yeoman 625977 625977 Reade, Thomas, of Chewton, yeoman 2
4332370 2141117 2141117 defendant Bendle Nicholas husbandman 625977 625977 Bendle, Nicholas, of Chewton, husbandman 3
4358666 2150269 2150269 defendant Huishe William   625977 625977 Huishe, William, of Chewton, "grovyer" 0
4358872 2150338 2150338 defendant Parsons John husbandman 625977 625977 Parsons, John, of Chewton, husbandman 2
4358873 2150338 2150338 defendant Spyringe Thomas husbandman 625977 625977 Spyringe, Thomas, of Chewton, husbandman 3
4367178 2153318 2153318 defendant Simond Lewis gent 625977 625977 Simond, Lewis, of Chewton, gent 0
4367180 2153319 2153319 defendant Dudley Charles gent 625977 625977 Dudley, Charles, of Chewton, gent 0
4370637 2154550 2154550 defendant Dudley Charles gent 625977 625977 Dudley, Charles, of Chewton, gent 1
4372451 2155216 2155216 defendant Symons Lewis yeoman 625977 625977 Symons, Lewis, of Chewton, yeoman 0
4372452 2155216 2155216 defendant Francke James yeoman 625977 625977 Francke, James, of Chewton, yeoman 1
4373343 2155533 2155533 defendant Rodwey John husbandman 625977 625977 Rodwey, John, of Chewton, husbandman 0
4373346 2155533 2155533 defendant Wilcoxe William yeoman 625977 625977 Wilcoxe, William, of Chewton, yeoman 3
4377617 2157073 2157073 defendant Spyrynge Thomas, junior husbandman 625977 625977 Spyrynge, Thomas, junior, of Chewton, husbandman 0
4377623 2157074 2157074 defendant Wensley John husbandman 625977 625977 Wensley, John, of Chewton, husbandman 3
4379529 2157765 2157765 defendant Hewes William husbandman 625977 625977 Hewes, William, of Chewton, husbandman 0
4380152 2158005 2158005 defendant Simons Luke yeoman 625977 625977 Simons, Luke, of Chewton, yeoman 0
4385147 2159719 2159719 defendant Burdge or Bridge John yeoman 625977 625977 Burdge or Bridge, John, of Chewton, yeoman 0
4385148 2159719 2159719 defendant Androwes alias Wilkox Thomas yeoman 625977 625977 Androwes alias Wilkox, Thomas, of Chewton, yeoman 1
4385149 2159719 2159719 defendant Yorke alias Francke James yeoman 625977 625977 Yorke alias Francke, James, of Chewton, yeoman 2
4394648 2162798 2162798 defendant Wilcoxe Thomas yeoman 625977 625977 Wilcoxe, Thomas, of Chewton, yeoman 0
4860862 2314753 2314753 defendant Herberd Richard husbandman 625977 625977 Herberd, Richard, of Chewton, husbandman 1
4860863 2314753 2314753 defendant Marche Robert husbandman 625977 625977 Marche, Robert, of Chewton, husbandman 2
4860864 2314753 2314753 defendant Slegge William husbandman 625977 625977 Slegge, William, of Chewton, husbandman 3
4860865 2314753 2314753 defendant Goff Walter husbandman 625977 625977 Goff, Walter, of Chewton, husbandman 4
4860866 2314753 2314753 defendant Barry John   625977 625977 Barry, John, of Chewton, mason 5
4860867 2314753 2314753 defendant Cammell John husbandman 625977 625977 Cammell, John, of Chewton, husbandman 6
4925292 2334342 2334342 defendant Berry John   625977 625977 Berry, John, of Chewton, mason 0
4939039 2338599 2338599 defendant Barry John husbandman 625977 625977 Barry, John, of Chewton under Menydep, husbandman 1
4939040 2338599 2338599 defendant Marche Robert husbandman 625977 625977 Marche, Robert, of Chewton under Menydep, husbandman 2
5617092 2549162 2549162 plaintiff Knyght John   625977 625977 Knyght, John, of Chewton 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);