names

951 rows where place_id = 588084

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592641 1865311 1865311 defendant Wyloughby John   588084 588084 Wyloughby, John, of Chichester, mason 0
3593313 1865539 1865539 defendant Webbe John glover 588084 588084 Webbe, John, of Chichester, glover 0
3593957 1865748 1865748 plaintiff Hyberden John   588084 588084 Hyberden, John, of Chichester 0
3593958 1865748 1865748 defendant Golfynche Richard yeoman 588084 588084 Golfynche, Richard, of Chichester, yeoman 0
3605232 1869304 1869304 defendant Gysbourn William mercer 588084 588084 Gysbourn, William, of Chichester, mercer 0
3607960 1870140 1870140 defendant Hamwell William   588084 588084 Hamwell, William, of Chichester, mason 0
3615497 1872489 1872489 defendant Peers William saddler 588084 588084 Peers, William, of Chichester, saddler 0
3615498 1872489 1872489 defendant Forte alias Garnesey John yeoman 588084 588084 Forte alias Garnesey, John, of Chichester, yeoman 1
3615499 1872489 1872489 defendant Bryknehurst Richard yeoman 588084 588084 Bryknehurst, Richard, of Chichester, yeoman 2
3616213 1872712 1872712 defendant Hardyng Richard butcher 588084 588084 Hardyng, Richard, of Chichester, butcher 0
3624107 1875066 1875066 defendant Nyman John yeoman 588084 588084 Nyman, John, of Chichester, yeoman 0
3625287 1875446 1875446 defendant Chilton John yeoman 588084 588084 Chilton, John, of Chichester, yeoman 0
3630510 1904374 1904374 defendant Lane William mercer 588084 588084 Lane, William, of Chichester, mercer 3
3630511 1904374 1904374 defendant Trowe John weaver 588084 588084 Trowe, John, of Chichester, weaver 4
3633839 1905393 1905393 defendant Hall John yeoman 588084 588084 (Hall, John, of Chichester, yeoman 1
3633840 1905393 1905393 defendant Beverley John gent 588084 588084 Beverley, John, of Chichester, gent 2
3634220 1905502 1905502 defendant Paynter Thomas innholder 588084 588084 Paynter, Thomas, of Chichester, innholder 0
3645182 1908901 1908901 defendant Hall John gent 588084 588084 Hall, John, of Chichester, gent 2
3653764 1911436 1911436 defendant Crawfote John   588084 588084 Crawfote, John, of Chichester 1
3654340 1911618 1911618 defendant Cresweller John mercer 588084 588084 Cresweller, John, of Chichester, mercer 0
3674280 1917999 1917999 defendant Mathew John innholder 588084 588084 Mathew, John, of Chichester, innholder 0
3674909 1918182 1918182 defendant Bowley William butcher 588084 588084 Bowley, William, of Chichester, butcher 0
3679995 1919808 1919808 defendant Danyell John butcher 588084 588084 Danyell, John, of Chichester, butcher 0
3684136 1921174 1921174 defendant Hillis John tailor 588084 588084 Hillis, John, of Chichester, tailor 0
3684674 1921339 1921339 defendant Pympill Robert smith 588084 588084 Pympill, Robert, of Chichester, smith 1
3685699 1921685 1921685 defendant Davy William cooper 588084 588084 Davy, William, of Chichester, cooper 1
3689418 1922848 1922848 defendant Adeson John butcher 588084 588084 Adeson, John, of Chichester, butcher 0
3694721 1924554 1924554 defendant Throwghton Thomas barker 588084 588084 Throwghton, Thomas, of Chichester, barker 0
3702929 1927184 1927184 defendant Mason John clerk 588084 588084 Mason, John, of Chichester, clerk 0
3706601 1928349 1928349 defendant Salet Nicholas   588084 588084 Salet, Nicholas, of Chichester, mason 2
3711874 1930030 1930030 defendant Lucas John yeoman 588084 588084 Lucas, John, of Chichester, yeoman 0
3712298 1930162 1930162 defendant Mason John clerk 588084 588084 Mason, John, of Chichester, clerk 0
3730200 1935671 1935671 defendant Jenycott William draper 588084 588084 Jenycott, William, of Chichester, draper 1
3730201 1935671 1935671 defendant Holme Richard yeoman 588084 588084 Holme, Richard, of Chichester, yeoman 2
3730431 1935750 1935750 plaintiff Bowyer Robert merchant 588084 588084 Bowyer, Robert, of Chichester, merchant 0
3730432 1935750 1935750 plaintiff Boys John merchant 588084 588084 Boys, John, of Chichester, merchant 1
3730650 1935821 1935821 defendant Sewell Richard cooper 588084 588084 Sewell, Richard, of Chichester, cooper 0
3730651 1935821 1935821 defendant White Thomas sawyer 588084 588084 White, Thomas, of Chichester, sawyer 1
3732677 1936451 1936451 plaintiff Crosweller John mercer 588084 588084 Crosweller, John, of Chichester, mercer 0
3744983 1940338 1940338 defendant Jenycott William draper 588084 588084 Jenycott, William, of Chichester, draper 1
3744984 1940338 1940338 defendant Holmes Richard yeoman 588084 588084 Holmes, Richard, of Chichester, yeoman 2
3746822 1940926 1940926 plaintiff Crosweler John mercer 588084 588084 Crosweler, John, of Chichester, mercer 0
3747090 1941006 1941006 defendant Cresseweller John mercer 588084 588084 Cresseweller, John, of Chichester, mercer 0
3753343 1942984 1942984 defendant Byrle John fuller 588084 588084 Byrle, John, of Chichester, fuller 0
3754563 1943385 1943385 defendant Whyte Thomas sawyer 588084 588084 Whyte, Thomas, of Chichester, sawyer 0
3756239 1943911 1943911 plaintiff Andus Thomas clerk 588084 588084 Andus, Thomas, of Chichester, clerk 0
3757858 1944437 1944437 defendant Bradshawe Elias yeoman 588084 588084 Bradshawe, Elias, of Chichester, yeoman 0
3757859 1944437 1944437 defendant Tayller John husbandman 588084 588084 Tayller, John, of Chichester, husbandman 1
3763221 1946133 1946133 defendant Fromond Richard glover 588084 588084 Fromond, Richard, of Chichester, glover 0
3770242 1948361 1948361 defendant Frende William clerk 588084 588084 Frende, William, of Chichester, clerk 0
3775792 1950177 1950177 plaintiff Bowyer Robert merchant 588084 588084 Bowyer, Robert, of Chichester, merchant 0
3775793 1950177 1950177 plaintiff Boys John merchant 588084 588084 Boys, John, of Chichester, merchant 1
3804073 1959198 1959198 defendant Cavyllen William   588084 588084 Cavyllen, William, of Chichester, tallow chandler 0
3808295 1960468 1960468 defendant Kynkeham John yeoman 588084 588084 Kynkeham, John, of Chichester, yeoman 0
3808296 1960468 1960468 defendant Holmes Richard yeoman 588084 588084 Holmes, Richard, of Chichester, yeoman 1
3812997 1961967 1961967 defendant Pryor Robert husbandman 588084 588084 Pryor, Robert, of Chichester, husbandman 0
3818487 1963681 1963681 defendant Wynman John clerk 588084 588084 Wynman, John, of Chichester, clerk 0
3826310 1966078 1966078 plaintiff Audeby Richard gent 588084 588084 Audeby, Richard, of Chichester, gent 0
3826346 1966090 1966090 plaintiff Awdeby Richard gent 588084 588084 Awdeby, Richard, of Chichester, gent 0
3826656 1966183 1966183 plaintiff Barneham Robert   588084 588084 Barneham, Robert, of Chichester 0
3830863 1967534 1967534 defendant Redknappe Robert gent 588084 588084 Redknappe, Robert, of Chichester, gent 0
3833890 1968536 1968536 defendant Sherman Richard smith 588084 588084 Sherman, Richard, of Chichester, smith 0
3833892 1968537 1968537 defendant Sherman Richard smith 588084 588084 Sherman, Richard, of Chichester, smith 0
3844054 1971685 1971685 defendant Holland Edward yeoman 588084 588084 Holland, Edward, of Chichester, yeoman 2
3844058 1971686 1971686 defendant Holland Edward yeoman 588084 588084 Holland, Edward, of Chichester, yeoman 2
3846091 1972335 1972335 defendant Redknap Robert gent 588084 588084 (Redknap, Robert, of Chichester, gent 3
3860126 1976884 1976884 defendant Hardham Alexander butcher 588084 588084 Hardham, Alexander, of Chichester, butcher 0
3872660 1981073 1981073 plaintiff Bowyer Robert   588084 588084 Bowyer, Robert, of Chichester 0
3874287 1981624 1981624 defendant Hardam Alexander butcher 588084 588084 Hardam, Alexander, of Chichester, butcher 0
3886023 1985576 1985576 plaintiff Bradbryge William   588084 588084 Bradbryge, William, of Chichester 0
3886275 1985665 1985665 defendant Bryser Richard husbandman 588084 588084 Bryser, Richard, of Chichester, husbandman 0
3886276 1985665 1985665 defendant Roser George fuller 588084 588084 Roser, George, of Chichester, fuller 1
3886277 1985665 1985665 defendant Stephyns Edmund butcher 588084 588084 Stephyns, Edmund, of Chichester, butcher 2
3886826 1985856 1985856 defendant Cresweller John merchant 588084 588084 Cresweller, John, of Chichester, merchant 0
3886829 1985857 1985857 defendant Cresweller John merchant 588084 588084 Cresweller, John, of Chichester, merchant 0
3899520 1990054 1990054 defendant Flynt Thomas beer brewer 588084 588084 Flynt, Thomas, of Chichester, beer brewer 0
3900856 1990516 1990516 plaintiff Boys John   588084 588084 Boys, John, of Chichester 2
3908042 1992985 1992985 defendant Hoke John butcher 588084 588084 Hoke, John, of Chichester, butcher 0
3908625 1993183 1993183 defendant Blanford John merchant 588084 588084 Blanford, John, of Chichester, merchant 0
3917072 1996066 1996066 defendant Marchall alias Smyth William husbandman 588084 588084 Marchall alias Smyth, William, of Chichester, husbandman 0
3921969 1997691 1997691 defendant Hall John clerk 588084 588084 Hall, John, of Chichester, clerk 0
3922679 1997901 1997901 plaintiff Samford William   588084 588084 Samford, William, of Chichester, administrators of 0
3930638 2000593 2000593 defendant Novey alias Skynner Thomas barber 588084 588084 Novey alias Skynner, Thomas, of Chichester, barber 0
3934152 2001714 2001714 defendant Wesden Ralph merchant 588084 588084 Wesden, Ralph, of Chichester, merchant 2
3935322 2002128 2002128 defendant Sanford William (legal representative) 588084 588084 Sanford, William, of Chichester, executors of 0
3935327 2002129 2002129 defendant Askewe John   588084 588084 Askewe, John, of Chichester, inn holder 1
3964645 2012241 2012241 defendant Machyn Thomas mercer 588084 588084 Machyn, Thomas, of Chichester, mercer 1
3968417 2013587 2013587 defendant Husshe Edward gent 588084 588084 Husshe, Edward, of Chichester, gent 0
3988560 2020655 2020655 plaintiff Ardren Lawrence (legal representative) 588084 588084 Ardren, Lawrence, of Chichester, alderman, executor of 0
3988562 2020655 2020655 defendant Moyses John beer brewer 588084 588084 Moyses, John, of Chichester, beer brewer 0
3988566 2020656 2020656 plaintiff Ardren Lawrence (legal representative) 588084 588084 Ardren, Lawrence, of Chichester, alderman, executor of 0
3990716 2021435 2021435 defendant Russhe Anthony clerk 588084 588084 Russhe, Anthony, of Chichester, clerk 0
3990717 2021435 2021435 defendant Overton William clerk 588084 588084 Overton, William, of Chichester, clerk 1
3990718 2021435 2021435 defendant Penvin John clerk 588084 588084 Penvin, John, of Chichester, clerk 2
3990719 2021435 2021435 defendant Skelton John yeoman 588084 588084 Skelton, John, of Chichester, yeoman 3
3990720 2021435 2021435 defendant Edward John yeoman 588084 588084 Edward, John, of Chichester, yeoman 4
3990721 2021435 2021435 defendant Bechyng Seintleger yeoman 588084 588084 Bechyng, Seintleger, of Chichester, yeoman 5
3990722 2021435 2021435 defendant Cottrell Nicholas yeoman 588084 588084 Cottrell, Nicholas, of Chichester, yeoman 6
3990723 2021435 2021435 defendant Chaterton Richard gent 588084 588084 Chaterton, Richard, of Chichester, gent 7
3994760 2022878 2022878 defendant Blanford John yeoman 588084 588084 Blanford, John, of Chichester, yeoman 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);