names

143 rows where place_id = 590294

✎ 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
3600530 1867812 1867812 defendant Bant William yeoman 590294 590294 Bant, William, of Alternon, yeoman 0
3627377 1903417 1903417 defendant Weryng Robert husbandman 590294 590294 Weryng, Robert, of Alternon, husbandman 0
3692628 1923882 1923882 defendant Knebon John husbandman 590294 590294 Knebon, John, of Alternon, husbandman 0
3742353 1939478 1939478 defendant Wrothe John husbandman 590294 590294 Wrothe, John, of Alternon, husbandman 0
3754639 1943408 1943408 defendant Wrothe John husbandman 590294 590294 Wrothe, John, of Alternon, husbandman 0
3772011 1948938 1948938 defendant Wrothe John husbandman 590294 590294 Wrothe, John, of Alternon, husbandman 0
3773328 1949370 1949370 defendant Ayer Penticost husbandman 590294 590294 Ayer, Penticost, of Alternon, husbandman 1
3789643 1954590 1954590 defendant Wrothe John husbandman 590294 590294 Wrothe, John, of Alternon, husbandman 0
3792774 1955591 1955591 defendant Walkey John husbandman 590294 590294 Walkey, John, of Alternon, husbandman 3
3809392 1960819 1960819 defendant Walkey John husbandman 590294 590294 Walkey, John, of Alternon, husbandman 3
3813514 1962144 1962144 defendant Bant Stephen gent 590294 590294 Bant, Stephen, of Alternon, gent 0
3823350 1965217 1965217 defendant Walker John husbandman 590294 590294 Walker, John, of Alternon, husbandman 2
3833443 1968388 1968388 defendant Walkey John husbandman 590294 590294 Walkey, John, of Alternon, husbandman 0
3843435 1971483 1971483 defendant Straunge John husbandman 590294 590294 Straunge, John, of Alternon, husbandman 2
3843437 1971483 1971483 defendant Burges William husbandman 590294 590294 Burges, William, of Alternon, husbandman 4
3846201 1972367 1972367 defendant Hodge John husbandman 590294 590294 Hodge, John, of Alternon, husbandman 2
3846202 1972367 1972367 defendant Pryour William husbandman 590294 590294 Pryour, William, of Alternon, husbandman 3
3846203 1972367 1972367 defendant Burges John husbandman 590294 590294 Burges, John, of Alternon, husbandman 4
3861842 1977420 1977420 defendant Pryour William husbandman 590294 590294 Pryour, William, of Alternon, husbandman 3
3861843 1977420 1977420 defendant Burges John husbandman 590294 590294 Burges, John, of Alternon, husbandman 4
3861844 1977420 1977420 defendant Wyse John husbandman 590294 590294 Wyse, John, of Alternon, husbandman 5
3861845 1977420 1977420 defendant Gery John husbandman 590294 590294 Gery, John, of Alternon, husbandman 6
3861846 1977420 1977420 defendant Lucas Richard husbandman 590294 590294 Lucas, Richard, of Alternon, husbandman 7
3909743 1993567 1993567 defendant Waren Thomas yeoman 590294 590294 Waren, Thomas, of Alternon, yeoman 1
3954216 2008549 2008549 defendant Hardye John husbandman 590294 590294 Hardye, John, of Alternon, husbandman 0
3975811 2016103 2016103 defendant Parnall Thomas husbandman 590294 590294 Parnall, Thomas, of Alternon, husbandman 0
3975812 2016103 2016103 defendant Parnall William, junior husbandman 590294 590294 Parnall, William, junior, of Alternon, husbandman 1
3979893 2017567 2017567 defendant Ayer Thomas husbandman 590294 590294 Ayer, Thomas, of Alternon, husbandman 0
3979894 2017567 2017567 defendant Blake John husbandman 590294 590294 Blake, John, of Alternon, husbandman 1
3989562 2021013 2021013 defendant Sargeant John weaver 590294 590294 Sargeant, John, of Alternon, or of Badharleck, Egloskery, weaver 0
4002866 2025793 2025793 defendant Hawke Richard husbandman 590294 590294 Hawke, Richard, of Alternon, husbandman 0
4018704 2031424 2031424 defendant Jenson alias Hatherley John husbandman 590294 590294 Jenson alias Hatherley, John, of Alternon, husbandman 0
4040904 2039236 2039236 defendant Hardye John husbandman 590294 590294 Hardye, John, of Alternon, husbandman 1
4047405 2041529 2041529 defendant Sargeant John husbandman 590294 590294 Sargeant, John, of Alternon, husbandman 0
4047406 2041529 2041529 defendant Popleston John husbandman 590294 590294 Popleston, John, of Alternon, husbandman 1
4096635 2059123 2059123 defendant Earle or Yearle Henry tinner 590294 590294 Earle or Yearle, Henry, of Alternon, tinner 0
4105905 2062403 2062403 defendant Lowes Nicholas husbandman 590294 590294 Lowes, Nicholas, of Alternon, husbandman 1
4105906 2062403 2062403 defendant Wylkye Thomas husbandman 590294 590294 Wylkye, Thomas, of Alternon, husbandman 2
4108260 2063221 2063221 defendant Morye William yeoman 590294 590294 Morye, William, of Alternon, yeoman 2
4154831 2079783 2079783 defendant Tooker John husbandman 590294 590294 Tooker, John, of Alternon, husbandman 0
4163189 2082656 2082656 defendant Skawen alias Cornisshe Nicholas tailor 590294 590294 Skawen alias Cornisshe, Nicholas, of Alternon, tailor 2
4166067 2083637 2083637 defendant Mathewe John husbandman 590294 590294 Mathewe, John, of Alternon, husbandman 1
4169220 2084738 2084738 defendant Northey John husbandman 590294 590294 Northey, John, of Alternon, husbandman 0
4169225 2084739 2084739 defendant Northey John husbandman 590294 590294 Northey, John, of Alternon, husbandman 0
4169231 2084740 2084740 defendant Mowrye John yeoman 590294 590294 Mowrye, John, of Alternon, or of Carne, yeoman 1
4169704 2084894 2084894 defendant Hodge John yeoman 590294 590294 Hodge, John, of Alternon, yeoman 0
4230505 2106166 2106166 defendant Alternon Nicholas husbandman 590294 590294 Alternon, Nicholas, of Alternon, husbandman 0
4230506 2106166 2106166 defendant Martyn John butcher 590294 590294 Martyn, John, of Alternon, butcher 1
4230507 2106166 2106166 defendant Bounsall Arthur   590294 590294 Bounsall, Arthur, of Alternon, groom 2
4244739 2111224 2111224 defendant Coll Edward husbandman 590294 590294 Coll, Edward, of Alternon, husbandman 2
4256306 2115086 2115086 defendant Coll Edward husbandman 590294 590294 Coll, Edward, of Alternon, husbandman 2
4297359 2129160 2129160 defendant Wadge Thomas husbandman 590294 590294 Wadge, Thomas, of Alternon, husbandman 0
4390138 2161323 2161323 defendant Hodge William husbandman 590294 590294 Hodge, William, of Alternon, husbandman 3
4396431 2163382 2163382 defendant Gare John husbandman 590294 590294 Gare, John, of Alternon, husbandman 0
4396432 2163382 2163382 defendant Gare Richard husbandman 590294 590294 Gare, Richard, of Alternon, husbandman 1
4411166 2168322 2168322 defendant Letheby John husbandman 590294 590294 Letheby, John, of Alternon, husbandman 1
4599291 2230995 2230995 plaintiff Strange Philip   590294 590294 Strange, Philip, of Alternon 0
4599292 2230995 2230995 defendant Cola Thomas   590294 590294 Cola, Thomas, of Alternon 0
4600826 2231482 2231482 defendant Whirva Richard   590294 590294 Whirva, Richard, of Alternon 3
4630553 2240470 2240470 plaintiff Straunge Philip   590294 590294 Straunge, Philip, of Alternon 0
4635856 2242055 2242055 defendant Hogge (illegible)   590294 590294 Hogge, _, of Alternon 1
4698698 2265074 2265074 defendant toker Thomas   590294 590294 toker, Thomas, of Alternon, tin miner 1
4698706 2265076 2265076 defendant Toker Thomas   590294 590294 Toker, Thomas, of Alternon, tin miner 1
4721264 2271983 2271983 defendant Brok William   590294 590294 Brok, William, of Alternon, vicar 0
4750604 2280662 2280662 defendant Skelton John husbandman 590294 590294 Skelton, John, of Alternon, husbandman 1
4773384 2287650 2287650 defendant Nans John   590294 590294 Nans, John, of Alternon, tin miner 3
4808156 2298727 2298727 defendant Brenowe John tinner 590294 590294 Brenowe, John, of Alternon, tinner 0
4825376 2303978 2303978 defendant Hydyrdon William tinner 590294 590294 Hydyrdon, William, of Alternon, tinner 3
4850173 2311518 2311518 defendant Kene John husbandman 590294 590294 Kene, John, of Alternon, husbandman 0
4872865 2318466 2318466 defendant Toker Stephen tinner 590294 590294 Toker, Stephen, of Alternon, tinner 0
4872867 2318466 2318466 defendant Nederton William tinner 590294 590294 Nederton, William, of Alternon, tinner 2
4886967 2322773 2322773 defendant Ferrour Robert clerk 590294 590294 Ferrour, Robert, of Alternon, clerk 0
4890086 2323677 2323677 defendant Grenowe William husbandman 590294 590294 Grenowe, William, of Alternon, husbandman 1
4899890 2326602 2326602 defendant Hanke or Hauke William   590294 590294 Hanke or Hauke, William, of Alternon, bailiff 1
4904794 2328101 2328101 defendant Ferrour or Smith Robert clerk 590294 590294 Ferrour or Smith, Robert, of Alternon, clerk 2
4913797 2330816 2330816 defendant Skelton Robert gent 590294 590294 Skelton, Robert, of Alternon, gent 3
4939169 2338638 2338638 defendant Skelton Robert gent 590294 590294 Skelton, Robert, of Alternon, gent 0
4953510 2343021 2343021 defendant Lyghtfoot William tinner 590294 590294 Lyghtfoot, William, of Alternon, tinner 0
4953511 2343021 2343021 defendant Lyghtfoot Thomas tinner 590294 590294 Lyghtfoot, Thomas, of Alternon, tinner 1
4953512 2343021 2343021 defendant Schire Richard tailor 590294 590294 Schire, Richard, of Alternon, tailor 2
4956420 2343882 2343882 defendant Donet John tinner 590294 590294 Donet, John, of Alternon, tinner 0
4956422 2343882 2343882 defendant Richer John tinner 590294 590294 Richer, John, of Alternon, tinner 2
4956423 2343882 2343882 defendant Champyon Nicholas tinner 590294 590294 Champyon, Nicholas, of Alternon, tinner 3
4956424 2343882 2343882 defendant Attehay Thomas carpenter 590294 590294 Attehay, Thomas, of Alternon, carpenter 4
4956425 2343882 2343882 defendant Lughtfote Thomas tinner 590294 590294 Lughtfote, Thomas, of Alternon, tinner 5
4965093 2346484 2346484 defendant Heye Stephen husbandman 590294 590294 Heye, Stephen, of Alternon, husbandman 3
4969017 2347697 2347697 defendant Nytherton William husbandman 590294 590294 Nytherton, William, of Alternon, husbandman 0
4972846 2348816 2348816 defendant Gary Walter husbandman 590294 590294 Gary, Walter, of Alternon, husbandman 1
4978437 2350497 2350497 defendant Clerk William laborer 590294 590294 Clerk, William, of Alternon, laborer 0
4981851 2351491 2351491 defendant Gerveys John husbandman 590294 590294 Gerveys, John, of Alternon, husbandman 0
4981854 2351492 2351492 defendant Gerveys John husbandman 590294 590294 Gerveys, John, of Alternon, husbandman 0
4990987 2354194 2354194 defendant Skelton Robert gent 590294 590294 Skelton, Robert, of Alternon, gent 4
4991807 2354434 2354434 defendant Heye Stephen husbandman 590294 590294 Heye, Stephen, of Alternon, husbandman 1
4993569 2354949 2354949 defendant Hancok Stephen tinner 590294 590294 Hancok, Stephen, of Alternon, tinner 1
5015175 2361325 2361325 defendant Lewys Stephen husbandman 590294 590294 Lewys, Stephen, of Alternon, husbandman 7
5043191 2369583 2369583 defendant Louwys Thomas chaplain 590294 590294 Louwys, Thomas, of Alternon, chaplain 0
5057493 2373810 2373810 defendant Woo Stephen husbandman 590294 590294 Woo, Stephen, of Alternon, husbandman 3
5072948 2378394 2378394 defendant Clement William husbandman 590294 590294 Clement, William, of Alternon, husbandman 1
5083562 2381584 2381584 defendant Louwys Thomas chaplain 590294 590294 Louwys, Thomas, of Alternon, chaplain 0
5143109 2399118 2399118 defendant Rose William husbandman 590294 590294 Rose, William, of Alternon, husbandman 1

Next page

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);