names

85 rows where place_id = 602914

✎ 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
3652290 1911056 1911056 defendant Toller Reginald husbandman 602914 602914 Toller, Reginald, of Frekenham, husbandman 0
3652833 1911211 1911211 defendant Lote William husbandman 602914 602914 Lote, William, of Frekenham, husbandman 0
3652834 1911211 1911211 defendant reve Thomas husbandman 602914 602914 reve, Thomas, of Frekenham, husbandman 1
3652837 1911211 1911211 defendant Wynde Thomas husbandman 602914 602914 Wynde, Thomas, of Frekenham, husbandman 4
3683600 1921002 1921002 defendant Ballys John husbandman 602914 602914 Ballys, John, of Frekenham, husbandman 2
3683601 1921002 1921002 defendant Wrotham John tailor 602914 602914 Wrotham, John, of Frekenham, tailor 3
3762354 1945866 1945866 defendant Rogers William husbandman 602914 602914 Rogers, William, of Frekenham, husbandman 3
3783863 1952724 1952724 defendant Roger Robert husbandman 602914 602914 Roger, Robert, of Frekenham, husbandman 2
3784027 1952782 1952782 defendant Person Andrew husbandman 602914 602914 Person, Andrew, of Frekenham, husbandman 2
3794178 1956050 1956050 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 0
3800481 1958072 1958072 defendant Jacob Thomas husbandman 602914 602914 Jacob, Thomas, of Frekenham, husbandman 0
3811092 1961365 1961365 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 2
3811131 1961378 1961378 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 0
3813263 1962060 1962060 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 0
3815905 1962879 1962879 defendant Jenettys Humphrey gent 602914 602914 Jenettys, Humphrey, of Frekenham, gent 0
3817850 1963497 1963497 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 0
3817851 1963497 1963497 defendant Jacob Thomas yeoman 602914 602914 Jacob, Thomas, of Frekenham, yeoman 1
3825135 1965728 1965728 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 0
3862444 1977634 1977634 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 0
3866400 1978993 1978993 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 2
3880438 1983714 1983714 defendant Reve Thomas husbandman 602914 602914 Reve, Thomas, of Frekenham, husbandman 0
3894076 1988234 1988234 defendant Wycke Richard husbandman 602914 602914 Wycke, Richard, of Frekenham, husbandman 3
3919813 1996962 1996962 defendant Reve Thomas, senior husbandman 602914 602914 Reve, Thomas, senior, of Frekenham, husbandman 3
3921923 1997677 1997677 defendant Wykys Richard husbandman 602914 602914 Wykys, Richard, of Frekenham, husbandman 2
3957489 2009684 2009684 defendant Curtes John husbandman 602914 602914 Curtes, John, of Frekenham, or of Wyrlyngton, husbandman 0
3965648 2012600 2012600 defendant Loder John clerk 602914 602914 Loder, John, of Frekenham, clerk 0
3998368 2024155 2024155 defendant Parker Nicholas yeoman 602914 602914 Parker, Nicholas, of Frekenham, or of Mildenhall, yeoman 0
4444872 2183371 2183371 defendant Vaus William   602914 602914 Vaus, William, of Frekenham 1
4494665 2199024 2199024 plaintiff Bregge Thomas   602914 602914 Bregge, Thomas, of Frekenham, on his own account 0
4519605 2206493 2206493 defendant Caldewell John   602914 602914 Caldewell, John, of Frekenham 1
4536455 2211679 2211679 defendant Maynard William   602914 602914 Maynard, William, of Frekenham 0
4563560 2220172 2220172 defendant Mayanard William   602914 602914 Mayanard, William, of Frekenham 1
4580245 2225309 2225309 plaintiff Bregge Thomas   602914 602914 Bregge, Thomas, of Frekenham 1
4580248 2225309 2225309 defendant Basset John   602914 602914 Basset, John, of Frekenham 2
4581962 2225804 2225804 defendant Skynner Robert   602914 602914 Skynner, Robert, of Frekenham 3
4581973 2225805 2225805 defendant Skynnere Robert   602914 602914 Skynnere, Robert, of Frekenham 3
4656724 2247996 2247996 plaintiff Chappe Richard   602914 602914 Chappe, Richard, of Frekenham 0
4687870 2261772 2261772 defendant Wasshepayle William   602914 602914 Wasshepayle, William, of Frekenham 0
4700948 2265699 2265699 defendant Sket William husbandman 602914 602914 Sket, William, of Frekenham, husbandman 0
4731624 2275083 2275083 defendant Pope Robert yeoman 602914 602914 Pope, Robert, of Frekenham, yeoman 0
4942682 2339682 2339682 defendant Hardegrey William butcher 602914 602914 Hardegrey, William, of Frekenham, butcher 0
4963949 2346127 2346127 defendant Mors Robert yeoman 602914 602914 Mors, Robert, of Frekenham, yeoman 0
4963950 2346127 2346127 defendant Reve John yeoman 602914 602914 Reve, John, of Frekenham, yeoman 1
4984559 2352311 2352311 defendant Hardgrey James husbandman 602914 602914 Hardgrey, James, of Frekenham, husbandman 1
5000663 2357066 2357066 defendant Chappe Richard esq 602914 602914 Chappe, Richard, of Frekenham, esq 0
5000665 2357067 2357067 defendant Chappe Richard esq 602914 602914 Chappe, Richard, of Frekenham, esq 0
5036652 2367589 2367589 plaintiff Wardon William clerk 602914 602914 Wardon, William, of Frekenham, clerk 0
5075868 2379274 2379274 defendant Chappes Richard esq 602914 602914 Chappes, Richard, of Frekenham, esq 0
5082066 2381131 2381131 defendant Chappes Richard esq 602914 602914 Chappes, Richard, of Frekenham, esq 0
5082069 2381131 2381131 defendant Coftyn or Costyn John   602914 602914 Coftyn or Costyn, John, of Frekenham, shepherd 3
5082070 2381131 2381131 defendant Eton William tailor 602914 602914 Eton, William, of Frekenham, tailor 4
5082071 2381131 2381131 defendant Paye Robert roper 602914 602914 Paye, Robert, of Frekenham, roper 5
5082072 2381131 2381131 defendant Fyson Simon weaver 602914 602914 Fyson, Simon, of Frekenham, weaver 6
5082073 2381131 2381131 defendant Baker John laborer 602914 602914 Baker, John, of Frekenham, laborer 7
5082074 2381131 2381131 defendant Scocher George laborer 602914 602914 Scocher, George, of Frekenham, laborer 8
5082075 2381131 2381131 defendant Hancok Thomas yeoman 602914 602914 Hancok, Thomas, of Frekenham, yeoman 9
5082076 2381131 2381131 defendant Reve Reginald laborer 602914 602914 Reve, Reginald, of Frekenham, laborer 10
5082077 2381131 2381131 defendant Scot Edmund laborer 602914 602914 Scot, Edmund, of Frekenham, laborer 11
5095018 2384955 2384955 plaintiff Waleys John   602914 602914 Waleys, John, of Frekenham 2
5128514 2394813 2394813 defendant Waleys Robert butcher 602914 602914 Waleys, Robert, of Frekenham, butcher 0
5147660 2400453 2400453 defendant Waleys Robert butcher 602914 602914 Waleys, Robert, of Frekenham, butcher 0
5158424 2403585 2403585 defendant Wardon William   602914 602914 Wardon, William, of Frekenham, parson 1
5173991 2408092 2408092 defendant Wardon William   602914 602914 Wardon, William, of Frekenham, parson 0
5191022 2413116 2413116 defendant Chappys Richard esq 602914 602914 Chappys, Richard, of Frekenham, esq 0
5229958 2424377 2424377 defendant Chappes Richard esq 602914 602914 Chappes, Richard, of Frekenham, esq 0
5229965 2424378 2424378 defendant Chappes Richard esq 602914 602914 Chappes, Richard, of Frekenham, esq 0
5255676 2431893 2431893 defendant Borell William   602914 602914 Borell, William, of Frekenham, shepherd, 2
5263205 2434237 2434237 defendant Chappes Richard esq 602914 602914 Chappes, Richard, of Frekenham, esq 0
5282680 2439999 2439999 defendant Reve John husbandman 602914 602914 Reve, John, of Frekenham, husbandman 0
5354188 2461374 2461374 plaintiff Hardegrey William yeoman 602914 602914 Hardegrey, William, of Frekenham, yeoman 0
5354189 2461374 2461374 defendant Deynes Richard   602914 602914 Deynes, Richard, of Frekenham, yeoman, constable 0
5396917 2474200 2474200 defendant Balles Richard yeoman 602914 602914 Balles, Richard, of Frekenham, yeoman 2
5410205 2478003 2478003 defendant Hardegrey William yeoman 602914 602914 Hardegrey, William, of Frekenham, yeoman 0
5410206 2478003 2478003 defendant Balles Richard yeoman 602914 602914 Balles, Richard, of Frekenham, yeoman 1
5414250 2479196 2479196 plaintiff Hardegrey William yeoman 602914 602914 Hardegrey, William, of Frekenham, yeoman 0
5414251 2479196 2479196 defendant Deynes Richard yeoman & constable 602914 602914 Deynes, Richard, of Frekenham, yeoman & constable 0
5423892 2482099 2482099 defendant Hardegrey William yeoman 602914 602914 Hardegrey, William, of Frekenham, yeoman 0
5423893 2482099 2482099 defendant Balles Richard yeoman 602914 602914 Balles, Richard, of Frekenham, yeoman 1
5423895 2482100 2482100 defendant Hardegrey William yeoman 602914 602914 Hardegrey, William, of Frekenham, yeoman 0
5423896 2482100 2482100 defendant Balles Richard yeoman 602914 602914 Balles, Richard, of Frekenham, yeoman 1
5423898 2482101 2482101 defendant Hardegrey William yeoman 602914 602914 Hardegrey, William, of Frekenham, yeoman 0
5423899 2482101 2482101 defendant Balles Richard yeoman 602914 602914 Balles, Richard, of Frekenham, yeoman 1
5547612 2519319 2519319 defendant Deynes Robert husbandman 602914 602914 Deynes, Robert, of Frekenham, husbandman 2
5611268 2547254 2547254 plaintiff Bocher John   602914 602914 Bocher, John, of Frekenham, on his own account 0
5625983 2552086 2552086 defendant Waschepayn William husbandman 602914 602914 Waschepayn, William, of Frekenham, husbandman 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);