names

75 rows where place_id = 638361

✎ 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
3842065 1971071 1971071 defendant Shyperd John clerk 638361 638361 Shyperd, John, of Worle, clerk 3
3857386 1975945 1975945 defendant Blake John husbandman 638361 638361 Blake, John, of Worle, husbandman 0
3911062 1994027 1994027 defendant Thomas John yeoman 638361 638361 Thomas, John, of Worle, yeoman 2
3911063 1994027 1994027 defendant Sesse John husbandman 638361 638361 Sesse, John, of Worle, husbandman 3
4077466 2052231 2052231 defendant Frydaye Thomas yeoman 638361 638361 Frydaye, Thomas, of Worle, yeoman 0
4077468 2052231 2052231 defendant Hawkyns Theophilus tailor 638361 638361 Hawkyns, Theophilus, of Worle, tailor 2
4090433 2056860 2056860 defendant Colman Edmund husbandman 638361 638361 Colman, Edmund, of Worle, husbandman 3
4099906 2060293 2060293 defendant Fryday Thomas husbandman or yeoman 638361 638361 Fryday, Thomas, of Worle, husbandman or yeoman 0
4140927 2074991 2074991 defendant Warren John husbandman 638361 638361 Warren John, of Worle, husbandman 0
4145730 2076659 2076659 defendant Prynter John clerk 638361 638361 Prynter, John, of Worle, clerk 2
4158350 2080992 2080992 defendant Ewens William husbandman 638361 638361 Ewens William, of Worle, husbandman 0
4158351 2080992 2080992 defendant Daye John husbandman 638361 638361 Daye, John, of Worle, husbandman 1
4178630 2088002 2088002 defendant Tucker John husbandman 638361 638361 Tucker, John, of Worle, husbandman 1
4184764 2090180 2090180 defendant Warren David husbandman 638361 638361 Warren, David, of Worle, husbandman 0
4207697 2098252 2098252 defendant Warren John gent 638361 638361 Warren, John, of Worle, gent 0
4208358 2098471 2098471 defendant Hellyar William husbandman 638361 638361 Hellyar, William, of Worle, husbandman 1
4208918 2098668 2098668 defendant Stanley Thomas husbandman 638361 638361 Stanley, Thomas, of Worle, husbandman 0
4211819 2099684 2099684 defendant Yewens William husbandman 638361 638361 Yewens, William, of Worle, husbandman 1
4211827 2099686 2099686 defendant Sheperd John (legal representative) 638361 638361 Sheperd, John, of Worle, yeoman, executors of 3
4211828 2099686 2099686 defendant Salman Simon yeoman 638361 638361 (Salman, Simon, of Worle, yeoman 4
4211829 2099686 2099686 defendant Sheperd Richard husbandman 638361 638361 Sheperd, Richard, of Worle, husbandman 5
4211832 2099687 2099687 defendant Yewens William husbandman 638361 638361 Yewens, William, of Worle, husbandman 1
4211840 2099689 2099689 defendant Sheperd John (legal representative) 638361 638361 Sheperd, John, of Worle, yeoman, executors of 3
4211841 2099689 2099689 defendant Salmon Simon yeoman 638361 638361 (Salmon, Simon, of Worle, yeoman 4
4211842 2099689 2099689 defendant Shepard Richard husbandman 638361 638361 Shepard, Richard, of Worle, husbandman 5
4226914 2104885 2104885 defendant Warren Thomas yeoman 638361 638361 Warren, Thomas, of Worle, yeoman 0
4226915 2104885 2104885 defendant Salmon Simon yeoman 638361 638361 Salmon, Simon, of Worle, yeoman 1
4226916 2104885 2104885 defendant Waye George husbandman 638361 638361 Waye, George, of Worle, husbandman 2
4226917 2104885 2104885 defendant Whitinge William husbandman 638361 638361 Whitinge, William, of Worle, husbandman 3
4284889 2124644 2124644 defendant Warren John yeoman 638361 638361 Warren, John, of Worle, yeoman 1
4284890 2124644 2124644 defendant Warren David   638361 638361 Warren, David, of Worle, husbandman, son of John 2
4287131 2125454 2125454 defendant Warren John yeoman 638361 638361 Warren, John, of Worle, yeoman 1
4287364 2125534 2125534 defendant Tucker Richard   638361 638361 Tucker, Richard, of Worle husbandman 1
4287926 2125729 2125729 defendant Hellyer William butcher 638361 638361 Hellyer, William, of Worle, butcher 0
4307206 2132656 2132656 defendant Pratt William cordwainer 638361 638361 Pratt, William, of Worle, cordwainer 1
4312305 2134440 2134440 defendant Prynter John clerk 638361 638361 Prynter, John, of Worle, clerk 0
4359207 2150451 2150451 defendant Prynter John clerk 638361 638361 Prynter, John, of Worle, clerk 0
4379678 2157829 2157829 defendant Tucker Richard husbandman 638361 638361 Tucker, Richard, of Worle, husbandman 0
4383915 2159324 2159324 defendant Printer John clerk 638361 638361 Printer, John, of Worle, clerk 0
4408034 2167256 2167256 defendant Maye Agnes spinster 638361 638361 Maye, Agnes, of Worle, spinster 1
4411850 2168555 2168555 defendant Salmon Simon yeoman 638361 638361 Salmon, Simon, of Worle, yeoman 0
4482874 2195347 2195347 defendant Doll Thomas   638361 638361 Doll, Thomas, of Worle 2
4482875 2195347 2195347 defendant Howes Thomas   638361 638361 Howes, Thomas, of Worle 3
4482876 2195347 2195347 defendant Hile John   638361 638361 Hile, John, of Worle 4
4482877 2195347 2195347 defendant Davy Nicholas   638361 638361 Davy, Nicholas, of Worle 5
4491754 2198105 2198105 defendant Stychere John   638361 638361 Stychere, John, of Worle 0
4511886 2204166 2204166 defendant Howys Thomas   638361 638361 Howys, Thomas, of Worle 0
4656835 2248032 2248032 defendant Wodelond John husbandman 638361 638361 Wodelond, John, of Worle, husbandman 0
4656838 2248033 2248033 defendant Wodelond John husbandman 638361 638361 Wodelond, John, of Worle, husbandman 0
4671862 2256844 2256844 defendant Symondes Walter draper 638361 638361 Symondes, Walter, of Worle, draper 0
4671863 2256844 2256844 defendant Body Richard husbandman 638361 638361 Body, Richard, of Worle, husbandman 1
4771795 2287156 2287156 plaintiff Simones Walter chapman 638361 638361 Simones, Walter, of Worle, chapman 0
4771796 2287156 2287156 defendant Langforde Thomas ploughman 638361 638361 Langforde, Thomas, of Worle, ploughman 0
4771798 2287156 2287156 defendant Hake Ralph   638361 638361 Hake, Ralph, of Worle, holy water clerk 2
4771799 2287156 2287156 defendant Edward Walter fuller 638361 638361 Edward, Walter, of Worle, fuller 3
4777410 2288928 2288928 defendant Jurdan Thomas husbandman 638361 638361 Jurdan, Thomas, of Worle, husbandman 0
4824164 2303632 2303632 defendant Stafford William chapman 638361 638361 Stafford, William, of Worle, chapman 0
4873158 2318555 2318555 defendant Gybon William husbandman 638361 638361 Gybon, William, of Worle, husbandman 3
4884854 2322161 2322161 defendant There David laborer 638361 638361 There, David, of Worle, laborer 10
4888037 2323062 2323062 defendant Shepehurd Nicholas husbandman 638361 638361 Shepehurd, Nicholas, of Worle, husbandman 0
4950680 2342176 2342176 defendant Lond Nicholas butcher 638361 638361 Lond, Nicholas, of Worle, butcher 0
4957237 2344126 2344126 defendant Bysshop Thomas husbandman 638361 638361 Bysshop, Thomas, of Worle, husbandman 0
4978643 2350560 2350560 defendant Payn Walter husbandman 638361 638361 Payn, Walter, of Worle, husbandman 2
4983575 2352006 2352006 defendant Bysshop Thomas husbandman 638361 638361 Bysshop, Thomas, of Worle, husbandman 0
5024747 2364159 2364159 defendant Yoman John husbandman 638361 638361 Yoman, John, of Worle, husbandman 0
5038180 2368053 2368053 defendant Chester John pulter 638361 638361 Chester, John, of Worle, pulter 0
5038183 2368054 2368054 defendant Chester John pulter 638361 638361 Chester, John, of Worle, pulter 0
5227145 2423585 2423585 defendant Dyryke John laborer 638361 638361 Dyryke, John, of Worle, laborer 9
5227146 2423585 2423585 defendant Neulond Thomas husbandman 638361 638361 Neulond, Thomas, of Worle, husbandman 10
5227157 2423585 2423585 defendant Virgo Philip   638361 638361 Virgo, Philip, of Worle, mason 21
5227174 2423586 2423586 defendant Dyryke John laborer 638361 638361 Dyryke, John, of Worle, laborer 9
5227175 2423586 2423586 defendant Neulond Thomas husbandman 638361 638361 Neulond, Thomas, of Worle, husbandman 10
5227186 2423586 2423586 defendant Virgo Philip   638361 638361 Virgo, Philip, of Worle, mason 21
5516498 2509986 2509986 defendant Gewell Richard husbandman 638361 638361 Gewell, Richard, of Worle, husbandman 0
5516500 2509987 2509987 defendant Gewell Richard husbandman 638361 638361 Gewell, Richard, of Worle, 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);