names

99 rows where place_id = 589270

✎ 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
3597066 1866704 1866704 defendant Shend Robert husbandman 589270 589270 Shend, Robert, of Outwell, husbandman 2
3598401 1867129 1867129 defendant Schene Robert yeoman 589270 589270 Schene, Robert, of Outwell, yeoman 2
3601012 1867983 1867983 defendant Cosyn Christopher laborer 589270 589270 Cosyn, Christopher, of Outwell, laborer 0
3620750 1874065 1874065 defendant Cunnok Richard yeoman 589270 589270 Cunnok, Richard, of Outwell, yeoman 0
3623014 1874725 1874725 defendant Halowe Robert yeoman 589270 589270 Halowe, Robert, of Outwell, yeoman 1
3636074 1906074 1906074 defendant Southwell Robert husbandman 589270 589270 Southwell, Robert, of Outwell, husbandman 0
3647131 1909494 1909494 defendant Wyggys Simon waterman 589270 589270 Wyggys, Simon, of Outwell, waterman 3
3647133 1909494 1909494 defendant Elyet Robert husbandman 589270 589270 Elyet, Robert, of Outwell, husbandman 5
3654037 1911525 1911525 defendant Chamber William husbandman 589270 589270 Chamber, William, of Outwell, husbandman 0
3676785 1918775 1918775 defendant Akers Thomas husbandman 589270 589270 Akers, Thomas, of Outwell, husbandman 3
3718582 1932089 1932089 plaintiff Fyncham John gent 589270 589270 Fyncham, John, of Outwell, gent 0
3756954 1944152 1944152 defendant Cambryge William   589270 589270 Cambryge, William, of Outwell, mason 0
3817402 1963356 1963356 defendant Mosse Robert butcher 589270 589270 Mosse, Robert, of Outwell, butcher 3
3839948 1970426 1970426 defendant Delfe John husbandman 589270 589270 Delfe, John, of Outwell, husbandman 0
3846141 1972348 1972348 defendant Laverok or Lanerok Mathew husbandman 589270 589270 Laverok or Lanerok, Mathew, of Outwell, husbandman 0
3849042 1973294 1973294 defendant Cosyn Thomas husbandman 589270 589270 Cosyn, Thomas, of Outwell, husbandman 4
3880510 1983739 1983739 defendant Norsse Robert tanner 589270 589270 Norsse, Robert, of Outwell, tanner 0
3923784 1998259 1998259 plaintiff Steward Nicholas   589270 589270 Steward, Nicholas, of Outwell 1
3923787 1998260 1998260 plaintiff Steward Nicholas   589270 589270 Steward, Nicholas, of Outwell 1
3933248 2001414 2001414 defendant Norsse Robert butcher 589270 589270 Norsse, Robert, of Outwell, butcher 0
3933818 2001605 2001605 defendant Norsse Richard husbandman 589270 589270 Norsse, Richard, of Outwell, husbandman 0
3941537 2004182 2004182 defendant Beaupre Edmund esq 589270 589270 Beaupre, Edmund, of Outwell, esq 0
3973019 2015134 2015134 defendant Camebryge Thomas yeoman 589270 589270 Camebryge, Thomas, of Outwell, yeoman 2
3973818 2015411 2015411 defendant Cambrydge Thomas   589270 589270 Cambrydge, Thomas, of Outwell, brick layer 1
3973821 2015412 2015412 defendant Cambridge Thomas bricklayer 589270 589270 Cambridge, Thomas, of Outwell, bricklayer 1
4222721 2103440 2103440 defendant Goddard Anne butcher 589270 589270 Goddard, Anne, of Outwell, butcher 0
4222722 2103440 2103440 defendant Bourne Richard tailor 589270 589270 Bourne, Richard, of Outwell, tailor 1
4222723 2103440 2103440 defendant Davye Robert husbandman 589270 589270 Davye, Robert, of Outwell, husbandman 2
4303749 2131439 2131439 plaintiff Fyncham Anne (legal representative) 589270 589270 Fyncham, Anne, of Outwell, spinster, executor of 0
4540347 2212879 2212879 defendant Leveryngton Thomas   589270 589270 Leveryngton, Thomas, of Outwell, parson 0
4716004 2270314 2270314 defendant Grene John fishmonger 589270 589270 Grene, John, of Outwell, fishmonger 1
4799744 2296105 2296105 defendant Hubberd Thomas husbandman 589270 589270 Hubberd, Thomas, of Outwell, husbandman 0
4848905 2311123 2311123 defendant Hoberd Thomas husbandman 589270 589270 Hoberd, Thomas, of Outwell, husbandman 0
4861785 2315059 2315059 defendant Petman Robert   589270 589270 Petman, Robert, of Outwell, servant 1
4939584 2338766 2338766 defendant Walpole Richard carpenter 589270 589270 Walpole, Richard, of Outwell, carpenter 1
4944149 2340140 2340140 defendant Bluntesham John butcher 589270 589270 Bluntesham, John, of Outwell, butcher 1
4950111 2342001 2342001 defendant Meyre William husbandman 589270 589270 Meyre, William, of Outwell, husbandman 0
4950112 2342001 2342001 defendant Johnson Robert husbandman 589270 589270 Johnson, Robert, of Outwell, husbandman 1
4950113 2342001 2342001 defendant Stebbyng John husbandman 589270 589270 Stebbyng, John, of Outwell, husbandman 2
4964372 2346259 2346259 defendant Walpole Henry husbandman 589270 589270 Walpole, Henry, of Outwell, husbandman 0
4965738 2346680 2346680 plaintiff Curteyse Robert   589270 589270 Curteyse, Robert, of Outwell 0
4965739 2346680 2346680 defendant Walpolle Richard husbandman 589270 589270 Walpolle, Richard, of Outwell, husbandman 0
4969662 2347872 2347872 plaintiff Gryme Thomas, senior   589270 589270 Gryme, Thomas, senior, of Outwell 0
4977439 2350216 2350216 defendant Gryme Thomas yeoman 589270 589270 Gryme, Thomas, of Outwell, yeoman 0
4996117 2355695 2355695 defendant Beaupre Thomas esq 589270 589270 Beaupre, Thomas, of Outwell, esq 1
4996120 2355696 2355696 defendant Beaupre Thomas esq 589270 589270 Beaupre, Thomas, of Outwell, esq 1
5003898 2358027 2358027 defendant Brest Thomas shipman 589270 589270 Brest, Thomas, of Outwell, shipman 8
5023170 2363679 2363679 defendant Hobert Thomas husbandman 589270 589270 Hobert, Thomas, of Outwell, husbandman 0
5023171 2363679 2363679 defendant Burgony Robert husbandman 589270 589270 Burgony, Robert, of Outwell, husbandman 1
5045120 2370170 2370170 defendant Holder Thomas husbandman 589270 589270 Holder, Thomas, of Outwell, husbandman 2
5053380 2372615 2372615 plaintiff Barfet John   589270 589270 Barfet, John, of Outwell 1
5057674 2373860 2373860 defendant Cony John thatcher 589270 589270 Cony, John, of Outwell, thatcher 3
5057941 2373949 2373949 plaintiff Covyngton or Conyngton Thomas butcher 589270 589270 Covyngton or Conyngton, Thomas, of Outwell, butcher 0
5057942 2373949 2373949 plaintiff Delf John   589270 589270 Delf, John, of Outwell 1
5085738 2382224 2382224 defendant Virly William butcher 589270 589270 Virly, William, of Outwell, butcher 1
5085739 2382224 2382224 defendant Ellot John, senior husbandman 589270 589270 Ellot, John, senior, of Outwell, husbandman 2
5114117 2390526 2390526 defendant Poryng Geoffrey husbandman 589270 589270 Poryng, Geoffrey, of Outwell, husbandman 0
5118074 2391718 2391718 defendant Burgony Robert husbandman 589270 589270 Burgony, Robert, of Outwell, husbandman 0
5125461 2393931 2393931 defendant Dalm or Daum John husbandman 589270 589270 Dalm or Daum, John, of Outwell, husbandman 2
5128733 2394890 2394890 plaintiff Conyngton Thomas (legal representative) 589270 589270 Conyngton, Thomas, of Outwell, executors of 0
5128738 2394890 2394890 defendant Pore John husbandman 589270 589270 Pore, John, of Outwell, husbandman 2
5128741 2394891 2394891 plaintiff Conyngton Thomas (legal representative) 589270 589270 Conyngton, Thomas, of Outwell, executors of 0
5132679 2396055 2396055 defendant Cosyn Thomas mercer 589270 589270 Cosyn, Thomas, of Outwell, mercer 0
5132680 2396055 2396055 defendant Lynghoke Adam carpenter 589270 589270 Lynghoke, Adam, of Outwell, carpenter 1
5132681 2396055 2396055 defendant Stolham Thomas tailor 589270 589270 Stolham, Thomas, of Outwell, tailor 2
5152492 2401865 2401865 defendant Cosyn Thomas mercer 589270 589270 Cosyn, Thomas, of Outwell, mercer 0
5152493 2401865 2401865 defendant Lynghoke Adam carpenter 589270 589270 Lynghoke, Adam, of Outwell, carpenter 1
5159439 2403878 2403878 defendant Bussh John   589270 589270 (Bussh, John, of Outwell, surgeon alias yeoman 1
5167412 2406204 2406204 plaintiff Conyngton Thomas (legal representative) 589270 589270 Conyngton, Thomas, of Outwell, executors of 0
5167417 2406205 2406205 plaintiff Conyngton Thomas (legal representative) 589270 589270 Conyngton, Thomas, of Outwell, executors of 0
5212494 2419399 2419399 defendant Dam John husbandman 589270 589270 Dam, John, of Outwell, husbandman 3
5212885 2419514 2419514 plaintiff Halugh Christopher   589270 589270 (Halugh, Christopher, of Outwell 1
5212894 2419515 2419515 plaintiff Halugh Christopher   589270 589270 (Halugh, Christopher, of Outwell 1
5212903 2419516 2419516 plaintiff Halugh Christopher   589270 589270 (Halugh, Christopher, of Outwell 1
5218991 2421283 2421283 defendant Walpole Reginald (legal representative) 589270 589270 Walpole, Reginald, of Outwell, executor of 5
5252386 2430860 2430860 defendant Kyng Thomas yeoman 589270 589270 Kyng, Thomas, of Outwell, yeoman 0
5254297 2431471 2431471 defendant Kyng Thomas yeoman 589270 589270 Kyng, Thomas, of Outwell, yeoman 2
5254299 2431471 2431471 defendant Maltons or Malcons Henry butcher 589270 589270 Maltons or Malcons, Henry, of Outwell, butcher 4
5255528 2431845 2431845 defendant Sompter John husbandman 589270 589270 Sompter, John, of Outwell, husbandman 3
5293885 2443182 2443182 defendant Barette John brewer 589270 589270 Barette, John, of Outwell, brewer 0
5342199 2457753 2457753 defendant Barret John brewer 589270 589270 Barret, John, of Outwell, brewer 0
5347270 2459313 2459313 defendant powedych Peter skinner 589270 589270 powedych, Peter, of Outwell, skinner 0
5351624 2460607 2460607 defendant Baret John brewer 589270 589270 Baret, John, of Outwell, brewer 0
5353385 2461137 2461137 defendant Baret John brewer 589270 589270 Baret, John, of Outwell, brewer 0
5369234 2465977 2465977 defendant Penteney or Peuteney John yeoman 589270 589270 Penteney or Peuteney, John, of Outwell, yeoman 1
5371365 2466623 2466623 defendant Hanslop Richard stainer 589270 589270 Hanslop, Richard, of Outwell, stainer 1
5376748 2468325 2468325 defendant Delf Robert husbandman 589270 589270 Delf, Robert, of Outwell, husbandman 1
5418996 2480608 2480608 defendant Delf Robert husbandman 589270 589270 Delf, Robert, of Outwell, husbandman 1
5480217 2499066 2499066 plaintiff Cousen Thomas   589270 589270 Cousen, Thomas, of Outwell 0
5491285 2502281 2502281 defendant Stonham William yeoman 589270 589270 Stonham, William, of Outwell, yeoman 2
5527107 2513051 2513051 defendant Halough Robert husbandman 589270 589270 Halough, Robert, of Outwell, husbandman 0
5560133 2522926 2522926 defendant Payn William brewer 589270 589270 Payn, William, of Outwell, brewer 0
5560134 2522926 2522926 defendant Lambard Henry chapman 589270 589270 Lambard, Henry, of Outwell, chapman 1
5560135 2522926 2522926 defendant A Chamber William husbandman 589270 589270 A Chamber, William, of Outwell, husbandman 2
5560136 2522926 2522926 defendant Pondych William husbandman 589270 589270 Pondych, William, of Outwell, husbandman 3
5569697 2525706 2525706 defendant Clerk John tailor 589270 589270 Clerk, John, of Outwell, tailor 3
5576322 2527651 2527651 defendant Southwell Robert husbandman 589270 589270 Southwell, Robert, of Outwell, husbandman 0
5601271 2535288 2535288 defendant Southwell Robert husbandman 589270 589270 Southwell, Robert, of Outwell, husbandman 0
5636156 2555261 2555261 plaintiff Ellot John   589270 589270 Ellot, John, of Outwell 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);