names

51 rows where place_id = 613126

✎ 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
3696764 1925213 1925213 defendant Askewe Mathew yeoman 613126 613126 Askewe, Mathew, of Santon, yeoman 1
3797037 1956953 1956953 defendant Paley Thomas yeoman 613126 613126 Paley, Thomas, of Santon, yeoman 0
3918852 1996627 1996627 defendant Santon Robert gent 613126 613126 Santon, Robert, of Santon, gent 1
4128523 2070492 2070492 defendant Croftes Thomas (legal representative) 613126 613126 Croftes, Thomas, of Santon, yeoman, executors of 0
4188158 2091359 2091359 defendant Lookeupe George husbandman 613126 613126 Lookeupe, George, of Santon, husbandman 1
4425182 2172704 2172704 defendant Bayly John le   613126 613126 Bayly, John le, of Santon 5
4469940 2191264 2191264 defendant Carter William   613126 613126 Carter, William, of Santon 0
4492334 2198279 2198279 defendant Balour Henry   613126 613126 Balour, Henry, of Santon 1
4497715 2199929 2199929 defendant Coupeland Alan de   613126 613126 Coupeland, Alan de, of Santon 0
4497716 2199929 2199929 defendant Coupeland John de   613126 613126 Coupeland, John de, of Santon 1
4497717 2199929 2199929 defendant Park William de   613126 613126 Park, William de, of Santon 2
4497718 2199929 2199929 defendant Hird Thomas   613126 613126 Hird, Thomas, of Santon 3
4497719 2199929 2199929 defendant Daud Michael   613126 613126 Daud, Michael, of Santon 4
4567041 2221247 2221247 defendant Fynche Thomas   613126 613126 Fynche, Thomas, of Santon 1
4581990 2225806 2225806 defendant Botwryght William   613126 613126 Botwryght, William, of Santon 9
4582003 2225807 2225807 defendant Botwryght William   613126 613126 Botwryght, William, of Santon 9
4600546 2231393 2231393 plaintiff Tollere John   613126 613126 Tollere, John, of Santon 0
4607675 2233508 2233508 defendant Brounflete Mathew   613126 613126 Brounflete, Mathew, of Santon 5
4663895 2250191 2250191 defendant Bolour Henry thresher 613126 613126 Bolour, Henry, of Santon, thresher 0
4696013 2264237 2264237 defendant Weton Richard de yeoman 613126 613126 Weton, Richard de, of Santon, yeoman 2
4749016 2280196 2280196 defendant Esturmy William   613126 613126 Esturmy, William, of Santon, knight 0
4753253 2281401 2281401 defendant Cleye Robert   613126 613126 Cleye, Robert, of Santon, parson 4
4810242 2299347 2299347 defendant Cowepeland John esq 613126 613126 Cowepeland, John, of Santon, esq 0
4815679 2301008 2301008 defendant Cawpeland John de esq 613126 613126 Cawpeland, John de, of Santon, esq 0
4815681 2301008 2301008 defendant Tubmon John smith 613126 613126 Tubmon, John, of Santon, smith 2
4817346 2301512 2301512 defendant Sturlogge Philip husbandman 613126 613126 Sturlogge, Philip, of Santon, husbandman 2
4830420 2305549 2305549 defendant atte Mylnes John laborer 613126 613126 atte Mylnes, John, of Santon, laborer 0
4831684 2305936 2305936 defendant Trewe John laborer 613126 613126 Trewe, John, of Santon, laborer 3
4852248 2312131 2312131 defendant Langton John yeoman 613126 613126 Langton, John, of Santon, yeoman 1
4887922 2323031 2323031 defendant Curson John laborer 613126 613126 Curson, John, of Santon, laborer 1
4900452 2326788 2326788 plaintiff Weton Richard   613126 613126 Weton, Richard, of Santon 0
4913720 2330790 2330790 defendant Dubyn William husbandman 613126 613126 Dubyn, William, of Santon, husbandman 2
4958312 2344454 2344454 defendant Beaumont Thomas esq 613126 613126 Beaumont, Thomas, of Santon, esq 0
4985167 2352493 2352493 defendant Shurlok Philip husbandman 613126 613126 Shurlok, Philip, of Santon, husbandman 0
4987811 2353320 2353320 defendant Grove Thomas husbandman 613126 613126 Grove, Thomas, of Santon, husbandman 2
5069019 2377232 2377232 defendant Burgeys William husbandman 613126 613126 Burgeys, William, of Santon, husbandman 0
5073207 2378475 2378475 defendant Skirlowe John husbandman 613126 613126 Skirlowe, John, of Santon, husbandman 0
5073208 2378475 2378475 defendant Leche John husbandman 613126 613126 Leche, John, of Santon, husbandman 1
5073209 2378475 2378475 defendant Debyn or Devyn John husbandman 613126 613126 Debyn or Devyn, John, of Santon, husbandman 2
5073210 2378475 2378475 defendant Debyn or Devyn William husbandman 613126 613126 Debyn or Devyn, William, of Santon, husbandman 3
5085957 2382286 2382286 defendant Everyngham Thomas gent 613126 613126 Everyngham, Thomas, of Santon, gent 0
5140780 2398417 2398417 defendant Santon Robert gent 613126 613126 Santon, Robert, of Santon, gent 0
5198070 2415179 2415179 defendant Santon Robert gent 613126 613126 Santon, Robert, of Santon, gent 0
5198072 2415180 2415180 defendant Santon Robert gent 613126 613126 Santon, Robert, of Santon, gent 0
5234560 2425695 2425695 defendant Everyngham Thomas yeoman 613126 613126 Everyngham, Thomas, of Santon, yeoman 2
5385716 2470986 2470986 defendant Pala Richard husbandman 613126 613126 Pala, Richard, of Santon, husbandman 0
5397900 2474472 2474472 defendant Pala Richard husbandman 613126 613126 Pala, Richard, of Santon, husbandman 0
5411051 2478260 2478260 defendant Pala Richard husbandman 613126 613126 Pala, Richard, of Santon, husbandman 0
5411053 2478261 2478261 defendant Pala Richard husbandman 613126 613126 Pala, Richard, of Santon, husbandman 0
5484252 2500216 2500216 plaintiff Matthew William   613126 613126 Matthew, William, of Santon 0
5546200 2518881 2518881 defendant Richardson Richard husbandman 613126 613126 Richardson, Richard, of Santon, 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);