names

55 rows where place_id = 590658

✎ 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
3601913 1868254 1868254 defendant Grene Ralph yeoman 590658 590658 Grene, Ralph, of Parteney, yeoman 0
3609157 1870523 1870523 defendant Palmer Hugh husbandman 590658 590658 Palmer, Hugh, of Parteney, husbandman 0
3609158 1870523 1870523 defendant Clerk William weaver 590658 590658 Clerk, William, of Parteney, weaver 1
3621977 1874416 1874416 defendant Grene Ralph yeoman 590658 590658 Grene, Ralph, of Parteney, yeoman 1
3621978 1874416 1874416 defendant Grene alias Webster William yeoman 590658 590658 Grene alias Webster, William, of Parteney, yeoman 2
3625679 1875568 1875568 defendant Arnold John barker 590658 590658 Arnold, John, of Parteney, barker 0
3625680 1875568 1875568 defendant Broun John barker 590658 590658 Broun, John, of Parteney, barker 1
3876403 1982354 1982354 plaintiff Grene Ralph (legal representative) 590658 590658 Grene, Ralph, of Parteney, yeoman, executor of 0
4283466 2124123 2124123 defendant Moodey William yeoman 590658 590658 Moodey, William, of Parteney, yeoman 2
4450310 2185057 2185057 plaintiff Hanworth Hugh   590658 590658 Hanworth, Hugh, of Parteney, parson 0
4665386 2250654 2250654 defendant Otewar Henry husbandman 590658 590658 Otewar, Henry, of Parteney, husbandman 1
4692075 2263051 2263051 defendant Holand Richard   590658 590658 Holand, Richard, of Parteney, bailiff 10
4692880 2263278 2263278 defendant Holand Robert   590658 590658 Holand, Robert, of Parteney, bailiff 10
4728830 2274256 2274256 plaintiff Knot Thomas   590658 590658 Knot, Thomas, of Parteney, parson 0
4856690 2313468 2313468 defendant Bynbroke Richard   590658 590658 Bynbroke, Richard, of Parteney, bailiff 0
4887924 2323032 2323032 defendant Castell John husbandman 590658 590658 Castell, John, of Parteney, husbandman 0
4887929 2323033 2323033 defendant Burgh Simon husbandman 590658 590658 Burgh, Simon, of Parteney, husbandman 0
4900058 2326647 2326647 defendant Burgh Simon husbandman 590658 590658 Burgh, Simon, of Parteney, husbandman 0
4916300 2331601 2331601 defendant Daudy John yeoman 590658 590658 Daudy, John, of Parteney, yeoman 2
4948026 2341364 2341364 defendant Burgh Simon   590658 590658 Burgh, Simon, of Parteney, bailiff 2
4948046 2341367 2341367 defendant Burgh Simon   590658 590658 Burgh, Simon, of Parteney, bailiff 2
4960762 2345180 2345180 defendant Borell Robert husbandman 590658 590658 Borell, Robert, of Parteney, husbandman 0
4965847 2346715 2346715 defendant Borell Robert husbandman 590658 590658 Borell, Robert, of Parteney, husbandman 0
4965848 2346715 2346715 defendant Fosse Henry husbandman 590658 590658 Fosse, Henry, of Parteney, husbandman 1
4980002 2350973 2350973 defendant Tuplyn John clerk 590658 590658 Tuplyn, John, of Parteney, clerk 0
4980211 2351029 2351029 defendant Burgh Simon   590658 590658 Burgh, Simon, of Parteney, bailiff 0
4985044 2352457 2352457 defendant Borell Robert husbandman 590658 590658 Borell, Robert, of Parteney, husbandman 0
5021383 2363160 2363160 defendant Borell William merchant 590658 590658 Borell, William, of Parteney, merchant 0
5027047 2364781 2364781 defendant Burgh Simon laborer 590658 590658 Burgh, Simon, of Parteney, laborer 0
5029114 2365392 2365392 defendant Burell William merchant 590658 590658 Burell, William, of Parteney, merchant 0
5047040 2370738 2370738 defendant West William merchant 590658 590658 West, William, of Parteney, merchant 0
5058472 2374086 2374086 plaintiff Dandy or Daudy John yeoman 590658 590658 Dandy or Daudy, John, of Parteney, yeoman 0
5059125 2374296 2374296 defendant Borell William merchant 590658 590658 Borell, William, of Parteney, merchant 1
5061716 2375100 2375100 defendant Tuppelyn Robert clerk 590658 590658 Tuppelyn, Robert, of Parteney, clerk 0
5083203 2381473 2381473 defendant Dandy or Daudy John yeoman 590658 590658 Dandy or Daudy, John, of Parteney, yeoman 1
5084960 2382008 2382008 defendant Borell William merchant 590658 590658 Borell, William, of Parteney, merchant 0
5088427 2382990 2382990 defendant Jerman William coper 590658 590658 Jerman, William, of Parteney, coper 2
5095282 2385038 2385038 defendant Welby William dyer 590658 590658 Welby, William, of Parteney, dyer 1
5124057 2393490 2393490 defendant Lime or Lune Stephen butcher 590658 590658 Lime or Lune, Stephen, of Parteney, butcher 0
5129413 2395089 2395089 defendant Palmer William husbandman 590658 590658 Palmer, William, of Parteney, husbandman 7
5148707 2400745 2400745 defendant Palmer William husbandman 590658 590658 Palmer, William, of Parteney, husbandman 7
5167915 2406327 2406327 defendant Palmer William husbandman 590658 590658 Palmer, William, of Parteney, husbandman 7
5203931 2416900 2416900 defendant Palmer William husbandman 590658 590658 Palmer, William, of Parteney, husbandman 6
5216931 2420692 2420692 defendant Lune or Lime Stephen butcher 590658 590658 Lune or Lime, Stephen, of Parteney, butcher 1
5255760 2431922 2431922 defendant Goldyng Richard weaver 590658 590658 Goldyng, Richard, of Parteney, weaver 0
5258522 2432780 2432780 defendant Kelowe John butcher 590658 590658 Kelowe, John, of Parteney, butcher 0
5260174 2433308 2433308 defendant Topelyn Robert clerk 590658 590658 together with Topelyn, Robert, of Parteney, clerk 1
5264176 2434555 2434555 defendant Rodley Thomas yeoman 590658 590658 Rodley, Thomas, of Parteney, yeoman 0
5283438 2440211 2440211 defendant Tetteney Robert husbanman 590658 590658 Tetteney, Robert, of Parteney, husbanman 0
5289246 2441856 2441856 defendant Dalby Richard husbandman 590658 590658 togehter with Dalby, Richard, of Parteney, husbandman 9
5359766 2463095 2463095 plaintiff Rotheley Thomas   590658 590658 Rotheley, Thomas, of Parteney 0
5557898 2522263 2522263 defendant Alcok John husbandman 590658 590658 Alcok, John, of Parteney, husbandman 1
5593839 2533059 2533059 defendant Anderson Walter scrivener 590658 590658 Anderson, Walter, of Parteney, scrivener 0
5593840 2533059 2533059 defendant Cooke John yeoman 590658 590658 Cooke, John, of Parteney, yeoman 1
5593842 2533060 2533060 defendant Grene Ralph mercer 590658 590658 Grene, Ralph, of Parteney, mercer 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);