names

85 rows where place_id = 597394

✎ 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
3628399 1903747 1903747 defendant Halse John tucker 597394 597394 Halse, John, of Corscombe, tucker 1
3647185 1909510 1909510 plaintiff Langford alias Turner John turner 597394 597394 Langford alias Turner, John, of Corscombe, turner 0
3647186 1909510 1909510 defendant Pownde Roger roper 597394 597394 Pownde, Roger, of Corscombe, roper 0
3647187 1909510 1909510 defendant Burt Roger husbandman 597394 597394 Burt, Roger, of Corscombe, husbandman 1
3647188 1909510 1909510 defendant Burt John butcher 597394 597394 Burt, John, of Corscombe, butcher 2
3647189 1909510 1909510 defendant Russell Edward miller 597394 597394 Russell, Edward, of Corscombe, miller 3
3647190 1909510 1909510 defendant Swetme- William husbandman 597394 597394 Swetme-, William, of Corscombe, husbandman 4
3673149 1917613 1917613 plaintiff Edmundys John   597394 597394 Edmundys, John, of Corscombe 4
3734402 1937001 1937001 defendant Taylour William tanner 597394 597394 Taylour, William, of Corscombe, tanner 2
3758891 1944772 1944772 plaintiff Carter John clothman 597394 597394 Carter, John, of Corscombe, clothman 0
3776964 1950540 1950540 plaintiff Carter Joan (legal representative) 597394 597394 Carter, Joan, of Corscombe, widow, executor of 0
3776966 1950540 1950540 defendant Porter John clothman 597394 597394 Porter, John, of Corscombe, clothman 0
3788964 1954359 1954359 defendant Fawon Stephen husbandman 597394 597394 Fawon, Stephen, of Corscombe, husbandman 2
3794375 1956120 1956120 defendant Carter John yeoman 597394 597394 Carter, John, of Corscombe, yeoman 0
3853952 1974875 1974875 defendant Fawen Stephen husbandman 597394 597394 Fawen, Stephen, of Corscombe, husbandman 0
3888932 1986541 1986541 defendant Downe Thomas husbandman 597394 597394 Downe, Thomas, of Corscombe, husbandman 0
3888933 1986541 1986541 defendant Downe Humphrey yeoman 597394 597394 Downe, Humphrey, of Corscombe, yeoman 1
3895022 1988544 1988544 defendant Wattys William weaver 597394 597394 Wattys, William, of Corscombe, weaver 0
3918501 1996516 1996516 defendant Somerton William husbandman 597394 597394 Somerton, William, of Corscombe, husbandman 5
3918523 1996521 1996521 defendant Bysse Richard clothier 597394 597394 Bysse, Richard, of Corscombe, clothier 0
3918525 1996522 1996522 defendant Bysse Richard clothier 597394 597394 Bysse, Richard, of Corscombe, clothier 0
3989239 2020892 2020892 defendant Fowen or Fawen John husbandman 597394 597394 Fowen or Fawen, John, of Corscombe, husbandman 0
4120482 2067603 2067603 defendant Fowne Ralph yeoman 597394 597394 Fowne, Ralph, of Corscombe, yeoman 0
4398910 2164218 2164218 defendant Fathers John yeoman 597394 597394 Fathers, John, of Corscombe, yeoman 0
4398911 2164218 2164218 defendant Barrett John husbandman 597394 597394 Barrett, John, of Corscombe, husbandman 1
4440724 2182013 2182013 defendant Wareyn Thomas   597394 597394 Wareyn, Thomas, of Corscombe 0
4443102 2182804 2182804 defendant Neweton John   597394 597394 Neweton, John, of Corscombe 2
4444579 2183282 2183282 defendant Bomour John   597394 597394 Bomour, John, of Corscombe 0
4451803 2185540 2185540 defendant Neweton John   597394 597394 Neweton, John, of Corscombe 0
4451805 2185541 2185541 defendant Neweton John   597394 597394 Neweton, John, of Corscombe 0
4458057 2187547 2187547 defendant Baryngton William   597394 597394 Baryngton, William, of Corscombe 0
4458058 2187547 2187547 defendant Waryn Thomas   597394 597394 Waryn, Thomas, of Corscombe 1
4468239 2190736 2190736 defendant Huntelby Thomas   597394 597394 Huntelby, Thomas, of Corscombe 0
4493362 2198627 2198627 defendant Boye Henry   597394 597394 Boye, Henry, of Corscombe 0
4509989 2203609 2203609 plaintiff Bakere Richard   597394 597394 Bakere, Richard, of Corscombe 0
4514949 2205084 2205084 defendant Loveworth John   597394 597394 Loveworth, John, of Corscombe 1
4514955 2205084 2205084 defendant Dyer Thomas   597394 597394 Dyer, Thomas, of Corscombe 7
4518500 2206158 2206158 defendant Lonwythe John   597394 597394 Lonwythe, John, of Corscombe 1
4546756 2214911 2214911 plaintiff Broun John   597394 597394 Broun, John, of Corscombe 0
4570008 2222191 2222191 defendant Rouche Hugh   597394 597394 Rouche, Hugh, of Corscombe 0
4578241 2224693 2224693 defendant Taillour Roger   597394 597394 Taillour, Roger, of Corscombe 0
4582838 2226065 2226065 defendant Gardener William   597394 597394 Gardener, William, of Corscombe 0
4593270 2229190 2229190 defendant Hopkyns Thomas   597394 597394 Hopkyns, Thomas, of Corscombe 2
4597141 2230345 2230345 defendant Diere William   597394 597394 Diere, William, of Corscombe 0
4614542 2235555 2235555 defendant Broun John   597394 597394 Broun, John, of Corscombe 0
4665434 2250664 2250664 defendant Shete Walter chapman 597394 597394 Shete, Walter, of Corscombe, chapman 0
4665435 2250664 2250664 defendant Gome John chapman 597394 597394 Gome, John, of Corscombe, chapman 1
4667159 2255462 2255462 defendant Harryes John clothier 597394 597394 Harryes, John, of Corscombe, clothier 0
4679100 2259068 2259068 defendant Huchyns alias Lambroke John chapman 597394 597394 Huchyns alias Lambroke, John, of Corscombe, chapman 1
4694489 2263771 2263771 defendant Gome John fuller 597394 597394 Gome, John, of Corscombe, fuller 0
4694491 2263771 2263771 defendant Boure Robert weaver 597394 597394 Boure, Robert, of Corscombe, weaver 2
4694492 2263771 2263771 defendant Houchouns John   597394 597394 Houchouns, John, of Corscombe, cloth maker 3
4711833 2269030 2269030 plaintiff Schepton John (legal representative) 597394 597394 Schepton, John, of Corscombe, executors of 0
4717388 2270777 2270777 defendant Hunte William butcher 597394 597394 Hunte, William, of Corscombe, butcher 1
4733056 2275518 2275518 defendant Shepton John weaver 597394 597394 Shepton, John, of Corscombe, weaver 0
4733057 2275518 2275518 defendant Shepton Thomas weaver 597394 597394 Shepton, Thomas, of Corscombe, weaver 1
4734407 2275930 2275930 plaintiff Schepton John (legal representative) 597394 597394 Schepton, John, of Corscombe, executors of 0
4767876 2285927 2285927 defendant Shepton Thomas weaver 597394 597394 Shepton, Thomas, of Corscombe, weaver 0
4777994 2289102 2289102 defendant Pury John merchant 597394 597394 Pury, John, of Corscombe, merchant 0
4784477 2291150 2291150 defendant Pury John merchant 597394 597394 Pury, John, of Corscombe, merchant 0
4792283 2293674 2293674 defendant Shepton Thomas weaver 597394 597394 Shepton, Thomas, of Corscombe, weaver 0
4793998 2294252 2294252 defendant Pury or Pery John husbandman 597394 597394 Pury or Pery, John, of Corscombe, husbandman 0
4803176 2297186 2297186 defendant Roulond John, senior fuller 597394 597394 Roulond, John, senior, of Corscombe, fuller 0
4803177 2297186 2297186 defendant Roulond John, junior   597394 597394 Roulond, John, junior, of Corscombe 1
4807788 2298622 2298622 defendant Baunokke Richard butcher 597394 597394 Baunokke, Richard, of Corscombe, butcher 2
4838017 2307815 2307815 defendant Atkyns Richard clerk 597394 597394 Atkyns, Richard, of Corscombe, clerk 0
4872861 2318464 2318464 defendant Saundrys Thomas weaver 597394 597394 Saundrys, Thomas, of Corscombe, weaver 0
4896466 2325564 2325564 plaintiff Daungervyle John   597394 597394 Daungervyle, John, of Corscombe 0
4942200 2339548 2339548 defendant Page Henry draper 597394 597394 Page, Henry, of Corscombe, draper 3
4988021 2353388 2353388 defendant Mede John fuller 597394 597394 Mede, John, of Corscombe, fuller 0
5020504 2362886 2362886 defendant Crondon John tucker 597394 597394 Crondon, John, of Corscombe, tucker 0
5093957 2384629 2384629 defendant Tapener Walter husbandman 597394 597394 Tapener, Walter, of Corscombe, husbandman 0
5297455 2444257 2444257 defendant Doune Richard yeoman 597394 597394 Doune, Richard, of Corscombe, yeoman 0
5373547 2467325 2467325 defendant Inge John dyer 597394 597394 Inge, John, of Corscombe, dyer 0
5403374 2476039 2476039 defendant Ynge John dyer 597394 597394 Ynge, John, of Corscombe, dyer 0
5403377 2476040 2476040 defendant Ynge John dyer 597394 597394 Ynge, John, of Corscombe, dyer 0
5449074 2489616 2489616 defendant Ynge John dyer 597394 597394 Ynge, John, of Corscombe, dyer 0
5472863 2496838 2496838 defendant Ynge Jonn dyer 597394 597394 Ynge, Jonn, of Corscombe, dyer 0
5489077 2501616 2501616 defendant More Alice widow 597394 597394 More, Alice, of Corscombe, widow 0
5495958 2503686 2503686 defendant More Alice widow 597394 597394 More, Alice, of Corscombe, widow 0
5549169 2519800 2519800 defendant Erley John tailor 597394 597394 Erley, John, of Corscombe, tailor 1
5573548 2526826 2526826 defendant Morgan Hugh tucker 597394 597394 Morgan, Hugh, of Corscombe, tucker 0
5616855 2549081 2549081 defendant Bal Henry   597394 597394 Bal, Henry, of Corscombe 0
5626751 2552339 2552339 defendant Smyth John smith 597394 597394 Smyth, John, of Corscombe, smith 4
5630674 2553600 2553600 plaintiff Schepton John (legal representative) 597394 597394 Schepton, John, of Corscombe, executors of 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);