names

106 rows where place_id = 594785

✎ 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
3614121 1872083 1872083 plaintiff Bourman Richard (legal representative) 594785 594785 Bourman, Richard, of Assheford, executors of 0
3614125 1872084 1872084 plaintiff Bourman Richard (legal representative) 594785 594785 Bourman, Richard, of Assheford, executors of 0
3617602 1873127 1873127 defendant Roger Richard butcher 594785 594785 (Roger, Richard, of Assheford, butcher 1
3617603 1873127 1873127 defendant Bowereman Margaret widow 594785 594785 Bowereman, Margaret, of Assheford, widow 2
3617605 1873128 1873128 defendant Bowreman Richard (legal representative) 594785 594785 Bowreman, Richard, of Assheford, mercer, executors of 0
3617606 1873128 1873128 defendant Bowreman Margaret widow 594785 594785 (Bowreman, Margaret, of Assheford, widow 1
3617607 1873128 1873128 defendant Roger Richard butcher 594785 594785 Roger, Richard, of Assheford, butcher 2
3618373 1873377 1873377 defendant Gryffyn Thomas (legal representative) 594785 594785 Gryffyn, Thomas, of Assheford, administratrix of 3
3618374 1873377 1873377 defendant Gryffyn Denise widow 594785 594785 Gryffyn, Denise, of Assheford, widow 4
3622839 1874673 1874673 defendant Fuller Richard yeoman 594785 594785 Fuller, Richard, of Assheford, yeoman 2
3639601 1907196 1907196 defendant Assheburst Thomas yeoman 594785 594785 Assheburst, Thomas, of Assheford, yeoman 0
3677013 1918848 1918848 defendant Alyn Bartholomew butcher 594785 594785 Alyn, Bartholomew, of Assheford, butcher 2
3707339 1928585 1928585 defendant Alen Bartholomew husbandman 594785 594785 Alen, Bartholomew, of Assheford, husbandman 1
3712342 1930178 1930178 defendant Burdyll Robert (legal representative) 594785 594785 Burdyll, Robert, of Assheford, yeoman, administrator of 0
3785048 1953107 1953107 defendant Cleygate Geoffrey yeoman 594785 594785 Cleygate, Geoffrey, of Assheford, yeoman 0
3805781 1959752 1959752 defendant Glover Thomas grocer 594785 594785 Glover, Thomas, of Assheford, grocer 1
3861803 1977412 1977412 defendant Jaxson Robert yeoman 594785 594785 Jaxson, Robert, of Assheford, yeoman 0
3861804 1977412 1977412 defendant Shop Robert yeoman 594785 594785 Shop, Robert, of Assheford, yeoman 1
3861805 1977412 1977412 defendant Heyward Henry husbandman 594785 594785 Heyward, Henry, of Assheford, husbandman 2
3861806 1977412 1977412 defendant Groves Henry husbandman 594785 594785 Groves, Henry, of Assheford, husbandman 3
3861807 1977412 1977412 defendant Johnson William husbandman 594785 594785 Johnson, William, of Assheford, husbandman 4
3861808 1977412 1977412 defendant Mylnes William husbandman 594785 594785 Mylnes, William, of Assheford, husbandman 5
3861809 1977412 1977412 defendant Greves Robert husbandman 594785 594785 Greves, Robert, of Assheford, husbandman 6
3861810 1977412 1977412 defendant Greves Richard husbandman 594785 594785 Greves, Richard, of Assheford, husbandman 7
3861811 1977412 1977412 defendant Goodhyve Henry husbandman 594785 594785 Goodhyve, Henry, of Assheford, husbandman 8
3861812 1977412 1977412 defendant Neylot John husbandman 594785 594785 Neylot, John, of Assheford, husbandman 9
3861813 1977412 1977412 defendant Toftes Richard husbandman 594785 594785 Toftes, Richard, of Assheford, husbandman 10
3861814 1977412 1977412 defendant Ragge John husbandman 594785 594785 Ragge, John, of Assheford, husbandman 11
3881331 1984020 1984020 defendant Lowe Robert laborer 594785 594785 Lowe, Robert, of Assheford, laborer 4
3884439 1985066 1985066 defendant Ball John clothmaker 594785 594785 Ball, John, of Assheford, clothmaker 0
3884440 1985066 1985066 defendant A Croche William husbandman 594785 594785 A Croche, William, of Assheford, husbandman 1
3894978 1988528 1988528 defendant Brownell Edward husbandman 594785 594785 Brownell, Edward, of Assheford, husbandman 3
3909213 1993376 1993376 defendant Nelott John carpenter 594785 594785 Nelott, John, of Assheford, carpenter 1
3970149 2014158 2014158 defendant Jackson Margaret widow 594785 594785 Jackson, Margaret, of Assheford, widow 0
4006715 2027181 2027181 defendant Bray John glasier 594785 594785 Bray, John, of Assheford, glasier 1
4021539 2032432 2032432 defendant Fogge Edward esq 594785 594785 Fogge, Edward, of Assheford, or of Canterbury, Kent, esq 0
4022892 2032913 2032913 defendant James alias Hall Christiopher yeoman 594785 594785 James alias Hall, Christiopher, of Assheford, yeoman 0
4022893 2032913 2032913 defendant Johnson Richard husbandman 594785 594785 Johnson, Richard, of Assheford, husbandman 1
4022895 2032914 2032914 defendant James alias Hall Christiopher yeoman 594785 594785 James alias Hall, Christiopher, of Assheford, yeoman 0
4022896 2032914 2032914 defendant Johnson Richard husbandman 594785 594785 Johnson, Richard, of Assheford, husbandman 1
4046542 2041214 2041214 plaintiff Smyth John (legal representative) 594785 594785 Smyth, John, of Assheford, executors of 0
4095361 2058662 2058662 defendant Hauke or Hanke John yeoman 594785 594785 Hauke or Hanke, John, of Assheford, yeoman 0
4156711 2080425 2080425 defendant Fusse Jerome mercer 594785 594785 Fusse, Jerome, of Assheford, mercer 2
4427647 2173483 2173483 defendant Palmere William   594785 594785 Palmere, William, of Assheford 0
4491861 2198133 2198133 plaintiff Wryght John   594785 594785 Wryght, John, of Assheford, bailiff, on his own account 0
4491863 2198134 2198134 plaintiff Wryght John   594785 594785 Wryght, John, of Assheford, bailiff, on his own account 0
4491865 2198135 2198135 plaintiff Wryght John   594785 594785 Wryght, John, of Assheford, bailiff, on his own account 0
4491867 2198136 2198136 plaintiff Wryght John   594785 594785 Wryght, John, of Assheford, bailiff, on his own account 0
4491869 2198137 2198137 plaintiff Wryght John   594785 594785 Wryght, John, of Assheford, bailiff, on his own account 0
4491871 2198138 2198138 plaintiff Wryght John   594785 594785 Wryght, John, of Assheford, bailiff, on his own account 0
4618767 2236872 2236872 defendant Cheteryngden William   594785 594785 Cheteryngden, William, of Assheford 0
4622364 2237973 2237973 defendant Wryght John   594785 594785 Wryght, John, of Assheford 3
4638566 2242816 2242816 defendant Wether John   594785 594785 Wether, John, of Assheford 2
4644181 2244391 2244391 defendant Wryght John   594785 594785 Wryght, John, of Assheford 0
4680526 2259521 2259521 defendant Boudeler Thomas   594785 594785 Boudeler, Thomas, of Assheford gent 2
4686491 2261381 2261381 defendant Byrchilles Roger husbandman 594785 594785 Byrchilles, Roger, of Assheford, husbandman 1
4686494 2261382 2261382 defendant Byrchilles Roger husbandman 594785 594785 Byrchilles, Roger, of Assheford, husbandman 1
4727253 2273782 2273782 defendant Brokeman William gent 594785 594785 Brokeman, William, of Assheford, gent 1
4727254 2273782 2273782 defendant atte Melle Henry laborer 594785 594785 atte Melle, Henry, of Assheford, laborer 2
4727255 2273782 2273782 defendant Wyke John laborer 594785 594785 Wyke, John, of Assheford, laborer 3
4750596 2280660 2280660 defendant Yoman John husbandman 594785 594785 Yoman, John, of Assheford, husbandman 0
4823855 2303541 2303541 defendant Crump John husbandman 594785 594785 Crump, John, of Assheford, husbandman 2
4834137 2306685 2306685 defendant Child William husbandman 594785 594785 Child, William, of Assheford, husbandman 0
4846096 2310286 2310286 defendant Nycolson William yeoman 594785 594785 Nycolson, William, of Assheford, yeoman 0
4863995 2315715 2315715 defendant Reygate Thomas miller 594785 594785 Reygate, Thomas, of Assheford, miller 0
4884739 2322129 2322129 defendant Sprotte John butcher 594785 594785 Sprotte, John, of Assheford, butcher 2
4913115 2330596 2330596 defendant Sclater John husbandman 594785 594785 Sclater, John, of Assheford, husbandman 2
4916135 2331546 2331546 defendant Pette John baker 594785 594785 Pette, John, of Assheford, baker 0
4924365 2334058 2334058 defendant Wyner John chapman 594785 594785 Wyner, John, of Assheford, chapman 4
4964602 2346317 2346317 defendant Nicolson Richard yeoman 594785 594785 Nicolson, Richard, of Assheford, yeoman 0
5018698 2362356 2362356 defendant Sprot John butcher 594785 594785 Sprot, John, of Assheford, butcher 0
5022653 2363531 2363531 defendant Lambyrn alias Mayhewe John husbandman 594785 594785 Lambyrn alias Mayhewe, John, of Assheford, husbandman 2
5027161 2364814 2364814 defendant Sharp Richard drover 594785 594785 Sharp, Richard, of Assheford, drover 0
5031816 2366176 2366176 defendant Reygate Thomas ostler 594785 594785 Reygate, Thomas, of Assheford, ostler 1
5037024 2367697 2367697 defendant Assheford William esq 594785 594785 Assheford, William, of Assheford, esq 0
5037210 2367751 2367751 defendant Sprot John butcher 594785 594785 Sprot, John, of Assheford, butcher 0
5051914 2372185 2372185 defendant Srot Richard yeoman 594785 594785 Srot, Richard, of Assheford, yeoman 1
5055284 2373166 2373166 defendant Sprot John butcher 594785 594785 Sprot, John, of Assheford, butcher 2
5068528 2377079 2377079 defendant Greve Henry yeoman 594785 594785 Greve, Henry, of Assheford, yeoman 1
5074914 2379001 2379001 defendant Sprot Richard yeoman 594785 594785 Sprot, Richard, of Assheford, yeoman 0
5083080 2381448 2381448 defendant Amond Philip butcher 594785 594785 Amond, Philip, of Assheford, butcher 0
5100130 2386477 2386477 defendant Sprot Richard yeoman 594785 594785 Sprot, Richard, of Assheford, yeoman 0
5226322 2423366 2423366 defendant Pergate Thomas laborer 594785 594785 Pergate, Thomas, of Assheford, laborer 0
5226323 2423366 2423366 defendant Laverok Thomas laborer 594785 594785 Laverok, Thomas, of Assheford, laborer 1
5226324 2423366 2423366 defendant Pette James baker 594785 594785 Pette, James, of Assheford, baker 2
5226326 2423367 2423367 defendant Pergate Thomas laborer 594785 594785 Pergate, Thomas, of Assheford, laborer 0
5226327 2423367 2423367 defendant White William tailor 594785 594785 White, William, of Assheford, tailor 1
5247994 2429547 2429547 defendant Reygate Nicholas chapman 594785 594785 Reygate, Nicholas, of Assheford, chapman 2
5247995 2429547 2429547 defendant Werde John chapman 594785 594785 Werde, John, of Assheford, chapman 3
5258144 2432666 2432666 defendant Ely Humphrey yeoman 594785 594785 Ely, Humphrey, of Assheford, yeoman 0
5312240 2448697 2448697 defendant Heyward John yeoman 594785 594785 Heyward, John, of Assheford, or of Epsham, yeoman 0
5356941 2462235 2462235 defendant Afryth James chapman 594785 594785 Afryth, James, of Assheford, chapman 2
5376234 2468161 2468161 defendant Dale Thomas husbandman 594785 594785 Dale, Thomas, of Assheford, husbandman 4
5427809 2483274 2483274 defendant Johnson Thomas husbandman 594785 594785 Johnson, Thomas, of Assheford, husbandman 0
5427810 2483274 2483274 defendant Thornneley William husbandman 594785 594785 Thornneley, William, of Assheford, husbandman 1
5435290 2485489 2485489 defendant Smyth Roger husbandman 594785 594785 Smyth, Roger, of Assheford, husbandman 1
5445409 2488527 2488527 defendant Johnson Thomas   594785 594785 Johnson, Thomas, of Assheford 0
5445410 2488527 2488527 defendant Thorneley William husbandman 594785 594785 Thorneley, William, of Assheford, husbandman 1
5446736 2488920 2488920 defendant Leveroke Joan widow 594785 594785 Leveroke, Joan, of Assheford, widow 1
5458171 2492351 2492351 defendant Johnson Thomas husbandman 594785 594785 Johnson, Thomas, of Assheford, husbandman 0

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