names

58 rows where place_id = 600466

✎ 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
3641139 1907677 1907677 defendant Wilmynson Peter husbandman 600466 600466 Wilmynson, Peter, of Rodmersham, husbandman 1
3770471 1948445 1948445 defendant Porrage John husbandman 600466 600466 Porrage, John, of Rodmersham, husbandman 0
3916315 1995838 1995838 defendant Podage John yeoman 600466 600466 Podage, John, of Rodmersham, yeoman 0
3916317 1995839 1995839 defendant Podage John yeoman 600466 600466 Podage, John, of Rodmersham, yeoman 0
3918960 1996662 1996662 defendant Croft Thomas husbandman 600466 600466 Croft, Thomas, of Rodmersham, husbandman 0
3957085 2009546 2009546 defendant Barley Edmund gent 600466 600466 Barley, Edmund, of Rodmersham, gent 0
3961760 2011214 2011214 defendant Jesopp John (legal representative) 600466 600466 Jesopp, John, of Rodmersham, yeoman, executors of 0
4018187 2031228 2031228 defendant Barley Anne widow 600466 600466 Barley, Anne, of Rodmersham, widow 0
4494365 2198931 2198931 plaintiff Bonho or Bouho Thomas   600466 600466 Bonho or Bouho, Thomas, of Rodmersham 0
4566189 2220987 2220987 defendant Couden Henry   600466 600466 Couden, Henry, of Rodmersham 0
4605837 2232939 2232939 defendant Bakere John   600466 600466 Bakere, John, of Rodmersham 0
4725268 2273193 2273193 defendant Trystram William butcher 600466 600466 Trystram, William, of Rodmersham, butcher 3
4841439 2308855 2308855 defendant Park William husbandman 600466 600466 Park, William, of Rodmersham, husbandman 1
4865747 2316251 2316251 defendant Forster John husbandman 600466 600466 Forster, John, of Rodmersham, husbandman 0
4894113 2324855 2324855 defendant Boho Richard husbandman 600466 600466 Boho, Richard, of Rodmersham, husbandman 0
4894114 2324855 2324855 defendant Preest Stephen husbandman 600466 600466 Preest, Stephen, of Rodmersham, husbandman 1
4894115 2324855 2324855 defendant Preest William   600466 600466 Preest, William, of Rodmersham, groom 2
4894117 2324856 2324856 defendant Preest Stephen husbandman 600466 600466 Preest, Stephen, of Rodmersham, husbandman 0
4894118 2324856 2324856 defendant Preest William   600466 600466 Preest, William, of Rodmersham, groom 1
4896987 2325707 2325707 defendant Wymond Thomas husbandman 600466 600466 Wymond, Thomas, of Rodmersham, husbandman 0
4908618 2329249 2329249 defendant Wymond Thomas husbandman 600466 600466 Wymond, Thomas, of Rodmersham, husbandman 0
4934406 2337153 2337153 defendant Partryche William husbandman 600466 600466 Partryche, William, of Rodmersham, husbandman 0
4944099 2340123 2340123 defendant Huntekyn John   600466 600466 Huntekyn, John, of Rodmersham 0
4951149 2342324 2342324 defendant Wymond Thomas husbandman 600466 600466 Wymond, Thomas, of Rodmersham, husbandman 1
4970653 2348159 2348159 defendant Scot John husbandman 600466 600466 Scot, John, of Rodmersham, husbandman 1
4991692 2354399 2354399 defendant Wymond Thomas husbandman 600466 600466 Wymond, Thomas, of Rodmersham, husbandman 2
5020345 2362834 2362834 defendant Hochyn John chapman 600466 600466 Hochyn, John, of Rodmersham, chapman 0
5032506 2366389 2366389 defendant Preest Stephen husbandman 600466 600466 Preest, Stephen, of Rodmersham, husbandman 0
5032507 2366389 2366389 defendant Preest Walter husbandman 600466 600466 Preest, Walter, of Rodmersham, husbandman 1
5034492 2366948 2366948 defendant Peryn Richard husbandman 600466 600466 Peryn, Richard, of Rodmersham, husbandman 0
5034494 2366949 2366949 defendant Peryn Richard husbandman 600466 600466 Peryn, Richard, of Rodmersham, husbandman 0
5034495 2366949 2366949 defendant Dylot Richard husbandman 600466 600466 Dylot, Richard, of Rodmersham, husbandman 1
5034496 2366949 2366949 defendant Peny John carpenter 600466 600466 Peny, John, of Rodmersham, carpenter 2
5057565 2373830 2373830 defendant Webbe Robert husbandman 600466 600466 Webbe, Robert, of Rodmersham, husbandman 2
5060215 2374626 2374626 defendant Norden John husbandman 600466 600466 Norden, John, of Rodmersham, husbandman 0
5066277 2376440 2376440 defendant Scot Reginald laborer 600466 600466 Scot, Reginald, of Rodmersham, laborer 4
5076219 2379389 2379389 defendant Dilote Richard laborer 600466 600466 Dilote, Richard, of Rodmersham, laborer 0
5077961 2379891 2379891 defendant Brownynge Richard yeoman 600466 600466 Brownynge, Richard, of Rodmersham, yeoman 1
5077973 2379894 2379894 defendant Brownynge Richard yeoman 600466 600466 Brownynge, Richard, of Rodmersham, yeoman 1
5104956 2387888 2387888 defendant Park Simon husbandman 600466 600466 Park, Simon, of Rodmersham, husbandman 0
5108457 2388910 2388910 defendant Prest Walter miller 600466 600466 Prest, Walter, of Rodmersham, miller 0
5122150 2392899 2392899 defendant Park Simon husbandman 600466 600466 Park, Simon, of Rodmersham, husbandman 1
5167381 2406195 2406195 defendant Parke Simon husbandman 600466 600466 Parke, Simon, of Rodmersham, husbandman 2
5167400 2406199 2406199 defendant Pryst Walter laborer 600466 600466 Pryst, Walter, of Rodmersham, laborer 1
5227835 2423756 2423756 defendant A Berwe Richard husbandman 600466 600466 A Berwe, Richard, of Rodmersham, husbandman 0
5230204 2424453 2424453 defendant Foxton Thomas husbandman 600466 600466 Foxton, Thomas, of Rodmersham, husbandman 0
5255489 2431838 2431838 defendant Prest Walter miller 600466 600466 Prest, Walter, of Rodmersham, miller 2
5269827 2436283 2436283 defendant Prest Walter husbandman 600466 600466 Prest, Walter, of Rodmersham, husbandman 2
5369436 2466033 2466033 defendant Partryche Thomas yeoman 600466 600466 Partryche, Thomas, of Rodmersham, yeoman 0
5369437 2466033 2466033 defendant Bateman William yeoman 600466 600466 Bateman, William, of Rodmersham, yeoman 1
5398111 2474526 2474526 defendant Desse John husbandman 600466 600466 Desse, John, of Rodmersham, husbandman 1
5481744 2499472 2499472 defendant Foxston John husbandman 600466 600466 Foxston, John, of Rodmersham, husbandman 2
5485096 2500463 2500463 defendant Assheford William husbandman 600466 600466 Assheford, William, of Rodmersham, husbandman 0
5496042 2503707 2503707 defendant Gawyn Walter husbandman 600466 600466 Gawyn, Walter, of Rodmersham, husbandman 3
5510991 2508280 2508280 defendant Weldysshe Edmund husbandman 600466 600466 Weldysshe, Edmund, of Rodmersham, husbandman 4
5511000 2508281 2508281 defendant Gawen Robert husbandman 600466 600466 Gawen, Robert, of Rodmersham, husbandman 6
5561360 2523301 2523301 defendant Tristeram Robert laborer 600466 600466 Tristeram, Robert, of Rodmersham, laborer 0
5625948 2552072 2552072 defendant Colyn John smith 600466 600466 Colyn, John, of Rodmersham, smith 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);