names

84 rows where place_id = 598047

✎ 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
3630893 1904483 1904483 defendant Blanke John tailor 598047 598047 Blanke, John, of Farneham, tailor 0
3630896 1904484 1904484 defendant Blanke John tailor 598047 598047 Blanke, John, of Farneham, tailor 0
3662694 1914250 1914250 defendant Bankys Thomas mercer 598047 598047 Bankys, Thomas, of Farneham, mercer 1
3668265 1916019 1916019 defendant Sandford John clerk 598047 598047 Sandford, John, of Farneham, clerk 0
3668266 1916019 1916019 defendant Peche John clerk 598047 598047 Peche, John, of Farneham, clerk 1
3668267 1916019 1916019 defendant Whitehed Thomas yeoman 598047 598047 Whitehed, Thomas, of Farneham, yeoman 2
3706864 1928433 1928433 defendant Bikersdike Edward yeoman 598047 598047 Bikersdike, Edward, of Farneham, yeoman 4
3706865 1928433 1928433 defendant Stones John laborer 598047 598047 Stones, John, of Farneham, laborer 5
3706866 1928433 1928433 defendant Pokson John laborer 598047 598047 Pokson, John, of Farneham, laborer 6
3706867 1928433 1928433 defendant Benson Richard laborer 598047 598047 Benson, Richard, of Farneham, laborer 7
3706868 1928433 1928433 defendant Boteler Miles laborer 598047 598047 Boteler, Miles, of Farneham, laborer 8
3761941 1945740 1945740 defendant Avenell John yeoman 598047 598047 Avenell, John, of Farneham, yeoman 0
3761943 1945741 1945741 defendant Councell William yeoman 598047 598047 Councell, William, of Farneham, yeoman 0
3795306 1956400 1956400 defendant Skynner Thomas butcher 598047 598047 Skynner, Thomas, of Farneham, butcher 0
3815561 1962783 1962783 defendant Bristowe John fuller 598047 598047 Bristowe, John, of Farneham, fuller 0
3839560 1970297 1970297 defendant Bristowe John yeoman 598047 598047 Bristowe, John, of Farneham, yeoman 0
3841020 1970762 1970762 defendant Champion Thomas shoemaker 598047 598047 Champion, Thomas, of Farneham, shoemaker 0
3842614 1971218 1971218 defendant Pery William husbandman 598047 598047 Pery, William, of Farneham, husbandman 0
3842622 1971221 1971221 defendant Woodall John husbandman 598047 598047 Woodall, John, of Farneham, husbandman 0
3846586 1972485 1972485 defendant Warde Thomas husbandman 598047 598047 Warde, Thomas, of Farneham, husbandman 1
3857731 1976054 1976054 defendant Champion Thomas shoemaker 598047 598047 Champion, Thomas, of Farneham, shoemaker 0
3858694 1976390 1976390 defendant Bryan William husbandman 598047 598047 Bryan, William, of Farneham, husbandman 3
3858703 1976392 1976392 defendant Brian William husbandman 598047 598047 Brian, William, of Farneham, husbandman 1
3862623 1977694 1977694 defendant Rede Thomas sherman 598047 598047 Rede, Thomas, of Farneham, sherman 0
3866785 1979128 1979128 plaintiff Rede Richard (legal representative) 598047 598047 Rede, Richard, of Farneham, fuller, executors of 0
3866788 1979128 1979128 defendant Battyll John fuller 598047 598047 Battyll, John, of Farneham, fuller 0
3866789 1979128 1979128 defendant Homoden William butcher 598047 598047 Homoden, William, of Farneham, butcher 1
3880754 1983827 1983827 defendant Jones Leonard shoemaker 598047 598047 Jones, Leonard, of Farneham, shoemaker 0
3894102 1988244 1988244 defendant Rygden George miller 598047 598047 Rygden, George, of Farneham, miller 0
3918694 1996581 1996581 defendant Tobridge Thomas butcher 598047 598047 Tobridge, Thomas, of Farneham, butcher 0
3968252 2013525 2013525 plaintiff Chapman alias Barkar John tanner 598047 598047 Chapman alias Barkar, John, of Farneham, or of Sibton, Suff, tanner 0
4096917 2059229 2059229 defendant Osborne John husbandman 598047 598047 Osborne, John, of Farneham, husbandman 0
4178979 2088126 2088126 defendant Order Nicholas barber 598047 598047 Order, Nicholas, of Farneham, barber 0
4186493 2090761 2090761 defendant Knyght Thomas gent 598047 598047 Knyght, Thomas, of Farneham, gent 0
4210177 2099121 2099121 defendant Knyght Thomas gent 598047 598047 Knyght, Thomas, of Farneham, gent 0
4224382 2104013 2104013 defendant Avenell George mercer 598047 598047 Avenell, George, of Farneham, mercer 1
4224383 2104013 2104013 defendant Hawarde John tailor 598047 598047 Hawarde, John, of Farneham, tailor 2
4224386 2104014 2104014 defendant Avenell George mercer 598047 598047 Avenell, George, of Farneham, mercer 1
4224387 2104014 2104014 defendant Haywarde John tailor 598047 598047 Haywarde, John, of Farneham, tailor 2
4231717 2106591 2106591 defendant Maddison John yeoman 598047 598047 Maddison, John, of Farneham, yeoman 2
4233242 2107138 2107138 defendant Maddison John yeoman 598047 598047 Maddison, John, of Farneham, yeoman 0
4237684 2108776 2108776 defendant Phillipp Robert yeoman 598047 598047 Phillipp, Robert, of Farneham, yeoman 0
4241376 2110101 2110101 defendant Hawarde John tailor 598047 598047 Hawarde, John, of Farneham, tailor 2
4241380 2110102 2110102 defendant Haywarde John tailor 598047 598047 Haywarde, John, of Farneham, tailor 2
4249634 2112861 2112861 defendant Avenell Robert chapman 598047 598047 Avenell, Robert, of Farneham, chapman 1
4264036 2117626 2117626 defendant Avenall Robert chapman 598047 598047 Avenall, Robert, of Farneham, chapman 1
4264967 2117918 2117918 defendant More John chapman 598047 598047 More, John, of Farneham, chapman 0
4283680 2124200 2124200 defendant Miller Thomas clothier 598047 598047 Miller, Thomas, of Farneham, clothier 2
4288924 2126094 2126094 defendant Moore John tailor 598047 598047 Moore, John, of Farneham, tailor 0
4288925 2126094 2126094 defendant Bennett Robert dyer 598047 598047 Bennett, Robert, of Farneham, dyer 1
4316487 2135883 2135883 defendant Bennett Robert dyer 598047 598047 Bennett, Robert, of Farneham, dyer 0
4318424 2136552 2136552 defendant Weste Lawrence yeoman 598047 598047 Weste, Lawrence, of Farneham, or of Guylford, yeoman 0
4320712 2137339 2137339 defendant Harwarde Anthony (legal representative) 598047 598047 Harwarde, Anthony, of Farneham, yeoman, administratrix of 0
4320713 2137339 2137339 defendant Harwarde Mary widow 598047 598047 Harwarde, Mary, of Farneham, widow 1
4336673 2142555 2142555 defendant Holdinge William bricklayer 598047 598047 Holdinge, William, of Farneham, bricklayer 0
4336674 2142555 2142555 defendant Holdinge Giles bricklayer 598047 598047 Holdinge, Giles, of Farneham, bricklayer 1
4364356 2152311 2152311 defendant Picke William gent 598047 598047 Picke, William, of Farneham, gent 0
4394836 2162860 2162860 defendant Parker Lewis husbandman 598047 598047 Parker, Lewis, of Farneham, husbandman 3
4395091 2162945 2162945 defendant Wood John gent 598047 598047 Wood, John, of Farneham, gent 0
4395093 2162945 2162945 defendant Webber Francis husbandman 598047 598047 Webber, Francis, of Farneham, husbandman 2
4395094 2162945 2162945 defendant Jefferye William husbandman 598047 598047 Jefferye, William, of Farneham, husbandman 3
4399079 2164274 2164274 defendant Weste Lawrence beer brewer 598047 598047 Weste, Lawrence, of Farneham, beer brewer 0
4399080 2164274 2164274 defendant Meryfelde John cutler 598047 598047 Meryfelde, John, of Farneham, cutler 1
4399081 2164274 2164274 defendant Arnolde John weaver 598047 598047 Arnolde, John, of Farneham, weaver 2
4401311 2165034 2165034 defendant Hackman John smith 598047 598047 Hackman, John, of Farneham, smith 0
4405086 2166277 2166277 defendant Wat John smith 598047 598047 Wat, John, of Farneham, smith 0
4411305 2168368 2168368 defendant Bicknold Rubin beer brewer 598047 598047 Bicknold, Rubin, of Farneham, beer brewer 0
4411306 2168368 2168368 defendant Knyghte Thomas gent 598047 598047 Knyghte, Thomas, of Farneham, gent 1
4411308 2168368 2168368 defendant Ryvers Richard shoemaker 598047 598047 Ryvers, Richard, of Farneham, shoemaker 3
4778157 2289160 2289160 defendant atte Forde Richard laborer 598047 598047 atte Forde, Richard, of Farneham, laborer 2
4944896 2340394 2340394 defendant Hatte John weaver 598047 598047 Hatte, John, of Farneham, weaver 0
4944897 2340394 2340394 defendant Gye Thomas weaver 598047 598047 Gye, Thomas, of Farneham, weaver 1
5070107 2377553 2377553 defendant Hunte John husbandman 598047 598047 (Hunte, John, of Farneham, husbandman 1
5087389 2382694 2382694 defendant Goum Robert cordwainer 598047 598047 Goum, Robert, of Farneham, cordwainer 0
5087391 2382694 2382694 defendant Phylyp William baker 598047 598047 Phylyp, William, of Farneham, baker 2
5087392 2382694 2382694 defendant Hatte John weaver 598047 598047 Hatte, John, of Farneham, weaver 3
5132298 2395943 2395943 defendant Sele William husbandman 598047 598047 Sele, William, of Farneham, husbandman 2
5227379 2423635 2423635 defendant Lokeer Edmund smith 598047 598047 Lokeer, Edmund, of Farneham, smith 0
5364041 2464411 2464411 defendant Baller John, senior laborer 598047 598047 Baller, John, senior, of Farneham, laborer 0
5369828 2466152 2466152 defendant Hore William cooper 598047 598047 Hore, William, of Farneham, cooper 0
5487179 2501061 2501061 defendant Wylde John weaver 598047 598047 Wylde, John, of Farneham, weaver 0
5514998 2509533 2509533 defendant Druet John husbandman 598047 598047 Druet, John, of Farneham, husbandman 0
5566872 2524907 2524907 defendant Braybourn William clothier 598047 598047 Braybourn, William, of Farneham, clothier 0
5566873 2524907 2524907 defendant Astolet Richard fuller 598047 598047 Astolet, Richard, of Farneham, fuller 1

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