names

149 rows where place_id = 594818

✎ 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
3617748 1873176 1873176 defendant Redware Thomas husbandman 594818 594818 Redware, Thomas, of Byker, husbandman 1
3633017 1905147 1905147 defendant Garrard John husbandman 594818 594818 Garrard, John, of Byker, husbandman 0
3691003 1923349 1923349 defendant Tooly John husbandman 594818 594818 Tooly, John, of Byker, husbandman 0
3697715 1925509 1925509 defendant Bennet William shoemaker 594818 594818 Bennet, William, of Byker, shoemaker 0
3714715 1930902 1930902 defendant Stalforth Henry   594818 594818 Stalforth, Henry, of Byker, salt weller 1
3736463 1937651 1937651 defendant Loveles Rober husbandman 594818 594818 Loveles, Rober, of Byker, husbandman 0
3736835 1937774 1937774 defendant Browne Thomas gent 594818 594818 Browne, Thomas, of Byker, gent 0
3752716 1942777 1942777 defendant Browne Thomas yeoman 594818 594818 Browne, Thomas, of Byker, yeoman 0
3794556 1956177 1956177 defendant Mylner James tailor 594818 594818 Mylner, James, of Byker, tailor 0
3805691 1959723 1959723 defendant Bennet William shoemaker 594818 594818 Bennet, William, of Byker, shoemaker 0
3811343 1961443 1961443 plaintiff Carre James   594818 594818 Carre, James, of Byker, administrators of 0
3823222 1965176 1965176 defendant Bennet William shoemaker 594818 594818 Bennet, William, of Byker, shoemaker 0
3859452 1976650 1976650 plaintiff Chaters Richard   594818 594818 Chaters, Richard, of Byker 0
3892831 1987852 1987852 defendant Andrewe Richard chaplain 594818 594818 Andrewe, Richard, of Byker, chaplain 0
3900898 1990530 1990530 plaintiff Chaters Richard   594818 594818 Chaters, Richard, of Byker 0
3905050 1991951 1991951 defendant Mason William husbandman 594818 594818 Mason, William, of Byker, husbandman 0
3948989 2006712 2006712 defendant Rodwell John smith 594818 594818 Rodwell, John, of Byker, smith 2
3970807 2014379 2014379 defendant Jackson Henry husbandman 594818 594818 Jackson, Henry, of Byker, husbandman 1
3970808 2014379 2014379 defendant Clayton Francis husbandman 594818 594818 Clayton, Francis, of Byker, husbandman 2
3970809 2014379 2014379 defendant Watson John husbandman 594818 594818 Watson, John, of Byker, husbandman 3
3970831 2014381 2014381 defendant Jackson Henry husbandman 594818 594818 Jackson, Henry, of Byker, husbandman 1
3970833 2014381 2014381 defendant Watson John   594818 594818 Watson, John, of Byker, of husbandman 3
3975512 2016001 2016001 defendant Borowe William yeoman 594818 594818 Borowe, William, of Byker, yeoman 0
3996875 2023651 2023651 defendant Jakson Henry husbandman 594818 594818 Jakson, Henry, of Byker, husbandman 0
4001290 2025240 2025240 defendant Thorpe William husbandman 594818 594818 Thorpe, William, of Byker, husbandman 2
4025664 2033832 2033832 defendant Rodwell Richard husbandman 594818 594818 Rodwell, Richard, of Byker, husbandman 0
4030724 2035651 2035651 defendant Borrowe William yeoman 594818 594818 Borrowe, William, of Byker, yeoman 0
4043983 2040299 2040299 defendant Mason Francis husbandman 594818 594818 Mason, Francis, of Byker, husbandman 0
4043984 2040299 2040299 defendant Haward Thomas husbandman 594818 594818 Haward, Thomas, of Byker, husbandman 1
4043985 2040299 2040299 defendant Thorpe William yeoman 594818 594818 Thorpe, William, of Byker, yeoman 2
4047937 2041708 2041708 defendant Stringer John husbandman 594818 594818 Stringer, John, of Byker, husbandman 1
4061057 2046362 2046362 defendant Carre Walter yeoman 594818 594818 Carre, Walter, of Byker, yeoman 4
4094860 2058494 2058494 defendant Burrowe William yeoman 594818 594818 Burrowe, William, of Byker, yeoman 0
4121942 2068145 2068145 defendant Seggesworth John glover 594818 594818 Seggesworth, John, of Byker, glover 0
4136323 2073336 2073336 defendant Chartresse Richard yeoman 594818 594818 Chartresse, Richard, of Byker, yeoman 1
4177779 2087704 2087704 defendant Borowe William yeoman 594818 594818 Borowe, William, of Byker, yeoman 0
4177780 2087704 2087704 defendant Borowe John   594818 594818 Borowe, John, of Byker, yeoman, his son 1
4177782 2087705 2087705 defendant Chaters Richard yeoman 594818 594818 Chaters, Richard, of Byker, yeoman 0
4177783 2087705 2087705 defendant Howse Thomas yeoman 594818 594818 Howse, Thomas, of Byker, yeoman 1
4446251 2183740 2183740 plaintiff Day William   594818 594818 Day, William, of Byker 0
4446254 2183740 2183740 defendant Wythone Robert   594818 594818 Wythone, Robert, of Byker 1
4453411 2186071 2186071 defendant Oc--lay Thomas de   594818 594818 Oc--lay, Thomas de, of Byker 0
4478769 2194027 2194027 defendant Gelleson Robert   594818 594818 Gelleson, Robert, of Byker, son of William 0
4484534 2195855 2195855 plaintiff Pevy Robert   594818 594818 Pevy, Robert, of Byker 0
4484536 2195856 2195856 plaintiff Pevy Robert   594818 594818 Pevy, Robert, of Byker 0
4484537 2195856 2195856 defendant Peny or Peuy Robert   594818 594818 Peny or Peuy, Robert, of Byker 0
4507977 2202961 2202961 defendant Webster Robert   594818 594818 Webster, Robert, of Byker 0
4515179 2205165 2205165 defendant Randson John   594818 594818 Randson, John, of Byker 0
4528558 2209208 2209208 defendant Holwys John   594818 594818 Holwys, John, of Byker 0
4536483 2211685 2211685 defendant Fen John de, sen   594818 594818 Fen, John de, sen, of Byker 0
4547002 2214996 2214996 plaintiff Buk Thomas   594818 594818 Buk, Thomas, of Byker 0
4552727 2216805 2216805 defendant Jakson William   594818 594818 Jakson, William, of Byker 1
4583718 2226321 2226321 plaintiff Fychet Alexander   594818 594818 Fychet, Alexander, of Byker 0
4611342 2234607 2234607 defendant Cokeman Richard   594818 594818 Cokeman, Richard, of Byker 0
4625420 2238915 2238915 plaintiff Pavy Robert   594818 594818 Pavy, Robert, of Byker 0
4633258 2241272 2241272 defendant Wilby John   594818 594818 Wilby, John, of Byker 0
4651229 2246390 2246390 defendant Been John laborer 594818 594818 Been, John, of Byker, laborer 0
4651230 2246390 2246390 defendant Helwys John laborer 594818 594818 Helwys, John, of Byker, laborer 1
4651231 2246390 2246390 defendant Randisson John husbandman 594818 594818 Randisson, John, of Byker, husbandman 2
4659906 2248953 2248953 defendant Wilkynson John husbandman 594818 594818 Wilkynson, John, of Byker, husbandman 0
4659907 2248953 2248953 defendant Hoghwell William husbandman 594818 594818 Hoghwell, William, of Byker, husbandman 1
4659909 2248953 2248953 defendant Lang Thomas husbandman 594818 594818 Lang, Thomas, of Byker, husbandman 3
4666936 2255389 2255389 defendant Been John laborer 594818 594818 Been, John, of Byker, laborer 0
4668411 2255832 2255832 defendant Richardeson John husbandman 594818 594818 Richardeson, John, of Byker, husbandman 1
4671686 2256790 2256790 defendant Helwyse John saltweller 594818 594818 Helwyse, John, of Byker, saltweller 0
4676027 2258113 2258113 defendant Redeware William husbandman 594818 594818 Redeware, William, of Byker, husbandman 0
4679614 2259241 2259241 defendant Durbak Peter laborer 594818 594818 Durbak, Peter, of Byker, laborer 0
4682372 2260107 2260107 defendant Smyth John husbandman 594818 594818 Smyth, John, of Byker, husbandman 3
4684718 2260822 2260822 defendant Tomson John husbandman & son of Richard Tomson 594818 594818 Tomson, John, of Byker, husbandman & son of Richard Tomson 0
4684719 2260822 2260822 defendant Cantelot John husbandman 594818 594818 Cantelot, John, of Byker, husbandman 1
4684720 2260822 2260822 defendant Fyssher John husbandman 594818 594818 Fyssher, John, of Byker, husbandman 2
4684721 2260822 2260822 defendant Peny Robert husbandman 594818 594818 Peny, Robert, of Byker, husbandman 3
4688369 2261928 2261928 defendant Bolok Richard husbandman 594818 594818 Bolok, Richard, of Byker, husbandman 2
4688432 2261948 2261948 defendant Durbagg John husbandman 594818 594818 Durbagg, John, of Byker, husbandman 3
4690267 2262511 2262511 defendant Burbak Peter laborer 594818 594818 Burbak, Peter, of Byker, laborer 0
4704196 2266688 2266688 defendant Feld Isabel de widow 594818 594818 Feld, Isabel de, of Byker, widow 0
4708827 2268130 2268130 defendant Helwys John husbandman 594818 594818 Helwys, John, of Byker, husbandman 0
4708828 2268130 2268130 defendant Reve John husbandman 594818 594818 Reve, John, of Byker, husbandman 1
4781612 2290262 2290262 defendant Rychardesson John husbandman 594818 594818 Rychardesson, John, of Byker, husbandman 0
4781724 2290295 2290295 defendant Rychardesson John husbandman 594818 594818 Rychardesson, John, of Byker, husbandman 0
4801228 2296568 2296568 defendant Daweson Robert yeoman 594818 594818 Daweson, Robert, of Byker, yeoman 0
4801229 2296568 2296568 defendant Hoghwell William yeoman 594818 594818 Hoghwell, William, of Byker, yeoman 1
4801230 2296568 2296568 defendant Person William husbandman 594818 594818 Person, William, of Byker, husbandman 2
4820516 2302485 2302485 defendant Richardson John husbandman 594818 594818 Richardson, John, of Byker, husbandman 10
4820517 2302485 2302485 defendant Bay Walter husbandman 594818 594818 Bay, Walter, of Byker, husbandman 11
4900636 2326837 2326837 defendant Richardson John husbandman 594818 594818 Richardson, John, of Byker, husbandman 0
4900637 2326837 2326837 defendant Thomas son of Dorbage John   594818 594818 Thomas son of Dorbage, John, of Byker, salt weller 1
4901038 2326950 2326950 defendant Lynne John yeoman 594818 594818 Lynne, John, of Byker, yeoman 0
4907887 2329027 2329027 defendant Redeware William husbandman 594818 594818 Redeware, William, of Byker or Bicker, husbandman 0
4926689 2334765 2334765 defendant Botellare Thomas husbandman 594818 594818 Botellare, Thomas, of Byker, husbandman 0
4939132 2338625 2338625 defendant Knyght Hugh husbandman 594818 594818 Knyght, Hugh, of Byker, husbandman 0
4940484 2339051 2339051 defendant Durbagge John husbandman 594818 594818 Durbagge, John, of Byker, husbandman 0
4940485 2339051 2339051 defendant Durbagge Thomas husbandman 594818 594818 Durbagge, Thomas, of Byker, husbandman 1
4955461 2343596 2343596 defendant Jakson John husbandman 594818 594818 Jakson, John, of Byker, husbandman 0
4976037 2349797 2349797 defendant Redware William   594818 594818 Redware, William, of Byker 11
4987987 2353377 2353377 defendant Fenne John barber 594818 594818 Fenne, John, of Byker, barber 0
4987988 2353377 2353377 defendant Fenne William laborer 594818 594818 Fenne, William, of Byker, laborer 1
5021842 2363280 2363280 defendant Durbagge Peter saltweller 594818 594818 Durbagge, Peter, of Byker, saltweller 1
5021853 2363283 2363283 defendant Fenne William husbandman 594818 594818 Fenne, William, of Byker, husbandman 0
5021854 2363283 2363283 defendant Fenne John weaver 594818 594818 Fenne, John, of Byker, weaver 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);