names

60 rows where place_id = 601813

✎ 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
3647130 1909494 1909494 defendant Stokys John tailor 601813 601813 Stokys, John, of Upwell, Cams, tailor 2
3768268 1947716 1947716 defendant Wellys Thomas gent 601813 601813 Wellys, Thomas, of Upwell, Cams, gent 0
3792717 1955575 1955575 plaintiff Bateman Richard husbandman 601813 601813 Bateman, Richard, of Upwell, Cams, husbandman 0
3817401 1963356 1963356 defendant Watton John butcher 601813 601813 Watton, John, of Upwell, Cams, butcher 2
3850051 1973605 1973605 defendant Raynham Richard husbandman 601813 601813 Raynham, Richard, of Upwell, Cams, husbandman 2
3850937 1973885 1973885 defendant Burley William bricklayer 601813 601813 Burley, William, of Upwell, Cams, bricklayer 2
3869465 1980028 1980028 defendant Haspye William husbandman 601813 601813 Haspye, William, of Upwell, Cams, husbandman 1
3884787 1985188 1985188 defendant Megges Nicholas esq 601813 601813 Megges, Nicholas, of Upwell, Cams, esq 0
3972207 2014837 2014837 defendant Hasyllwood Edward husbandman 601813 601813 Hasyllwood, Edward, of Upwell, Cams, husbandman 7
4296180 2128732 2128732 defendant Redley Joshua yeoman 601813 601813 Redley, Joshua, of Upwell, Cams, yeoman 0
4330331 2140448 2140448 defendant Brades John husbandman 601813 601813 Brades, John, of Upwell, Cams, husbandman 2
4396184 2163297 2163297 defendant Johnson Thomas yeoman 601813 601813 Johnson, Thomas, of Upwell, Cams, yeoman 0
4666589 2251030 2251030 defendant Osbern William husbandman 601813 601813 Osbern, William, of Upwell, Cams, husbandman 2
4892968 2324526 2324526 defendant Bateman Thomas yeoman 601813 601813 Bateman, Thomas, of Upwell, Cams, yeoman 1
4956173 2343808 2343808 defendant Danyell Walter waterman 601813 601813 Danyell, Walter, of Upwell, Cams, waterman 1
4961365 2345366 2345366 defendant Walpole Robert husbandman 601813 601813 Walpole, Robert, of Upwell, Cams, husbandman 0
4970320 2348072 2348072 defendant Bateman Thomas husbandman 601813 601813 Bateman, Thomas, of Upwell, Cams, husbandman 0
4977440 2350216 2350216 defendant Walpole Henry husbandman 601813 601813 Walpole, Henry, of Upwell, Cams, husbandman 1
5018407 2362268 2362268 defendant Justys alias Porter Richard   601813 601813 Justys alias Porter, Richard, of Upwell, Cams, husbandnan 2
5031739 2366155 2366155 defendant Palmer Nicholas husbandman 601813 601813 Palmer, Nicholas, of Upwell, Cams, husbandman 0
5057672 2373860 2373860 defendant White Richard husbandman 601813 601813 White, Richard, of Upwell, Cams, husbandman 1
5099182 2386185 2386185 plaintiff Wellys Thomas   601813 601813 Wellys, Thomas, of Upwell, Cams 0
5119223 2392049 2392049 defendant Warner John husbandman 601813 601813 Warner, John, of Upwell, Cams, husbandman 1
5217881 2420961 2420961 defendant Mathon John husbandman 601813 601813 Mathon, John, of Upwell, Cams, husbandman 1
5217882 2420961 2420961 defendant Aylesham John husbandman 601813 601813 Aylesham, John, of Upwell, Cams, husbandman 2
5220940 2421820 2421820 defendant Welles Thomas gent 601813 601813 Welles, Thomas, of Upwell, Cams, gent 1
5220944 2421821 2421821 defendant Welles Thomas gent 601813 601813 Welles, Thomas, of Upwell, Cams, gent 1
5244394 2428542 2428542 defendant Gayton Robert yeoman 601813 601813 Gayton, Robert, of Upwell, Cams, yeoman 0
5290604 2442253 2442253 defendant Maney John yeoman 601813 601813 Maney, John, of Upwell, Cams, yeoman 2
5290793 2442312 2442312 defendant Welles Thomas gent 601813 601813 Welles, Thomas, of Upwell, Cams, gent 0
5290795 2442313 2442313 defendant Welles Thomas gent 601813 601813 Welles, Thomas, of Upwell, Cams, gent 0
5327264 2453226 2453226 defendant Welles Thomas gent 601813 601813 Welles, Thomas, of Upwell, Cams, gent 1
5328436 2453580 2453580 defendant Rotelond John husbandman 601813 601813 Rotelond, John, of Upwell, Cams, husbandman 3
5328437 2453580 2453580 defendant Stoneham Thomas husbandman 601813 601813 Stoneham, Thomas, of Upwell, Cams, husbandman 4
5333101 2454971 2454971 defendant Stonham Thomas waterman 601813 601813 Stonham, Thomas, of Upwell, Cams, waterman 2
5338060 2456474 2456474 defendant Wellys John gent 601813 601813 Wellys, John, of Upwell, Cams, gent 1
5347271 2459313 2459313 defendant Legat John laborer 601813 601813 Legat, John, of Upwell, Cams, laborer 1
5349000 2459818 2459818 defendant Hanspy John husbandman 601813 601813 Hanspy, John, of Upwell, Cams, husbandman 0
5351530 2460577 2460577 defendant Wolle Walter yeoman 601813 601813 Wolle, Walter, of Upwell, Cams, yeoman 1
5351531 2460577 2460577 defendant Shene or Sheve Robert yeoman 601813 601813 Shene or Sheve, Robert, of Upwell, Cams, yeoman 2
5358880 2462828 2462828 defendant Welles John gent 601813 601813 Welles, John, of Upwell, Cams, gent 0
5358884 2462829 2462829 defendant Welles John gent 601813 601813 Welles, John, of Upwell, Cams, gent 0
5363230 2464154 2464154 plaintiff Welles John gent 601813 601813 Welles, John, of Upwell, Cams, gent 0
5363234 2464155 2464155 plaintiff Welles John gent 601813 601813 Welles, John, of Upwell, Cams, gent 0
5491281 2502280 2502280 defendant Stanham Thomas waterman 601813 601813 Stanham, Thomas, of Upwell, Cams, waterman 0
5491283 2502281 2502281 defendant Bateman Thomas yeoman 601813 601813 Bateman, Thomas, of Upwell, Cams, yeoman 0
5507783 2507332 2507332 plaintiff Damett William yeoman 601813 601813 Damett, William, of Upwell, Cams, yeoman 0
5521754 2511616 2511616 defendant Burdon Robert husbandman 601813 601813 Burdon, Robert, of Upwell, Cams, husbandman 0
5532009 2514552 2514552 defendant Stonham Thomas yeoman 601813 601813 Stonham, Thomas, of Upwell, Cams, yeoman 0
5537815 2516316 2516316 defendant Wylcy William husbandman 601813 601813 Wylcy, William, of Upwell, Cams, husbandman 3
5537816 2516316 2516316 defendant Canne William husbandman 601813 601813 Canne, William, of Upwell, Cams, husbandman 4
5538270 2516454 2516454 defendant Wright Robert tailor 601813 601813 Wright, Robert, of Upwell, Cams, tailor 0
5543437 2518065 2518065 defendant Stoneham Thomas husbandman 601813 601813 Stoneham, Thomas, of Upwell, Cams, husbandman 2
5548866 2519712 2519712 defendant Nicolson William shoemaker 601813 601813 Nicolson, William, of Upwell, Cams, shoemaker 1
5556702 2521919 2521919 defendant Stoneham Thomas husbandman 601813 601813 Stoneham, Thomas, of Upwell, Cams, husbandman 0
5561734 2523419 2523419 defendant Nicolson William shoemaker 601813 601813 Nicolson, William, of Upwell, Cams, shoemaker 0
5565678 2524551 2524551 defendant Goldwell Henry husbandman 601813 601813 Goldwell, Henry, of Upwell, Cams, husbandman 1
5567161 2524974 2524974 defendant Goldwell Henry husbandman 601813 601813 Goldwell, Henry, of Upwell, Cams, husbandman 4
5575438 2527407 2527407 defendant Wright Robert brewer 601813 601813 Wright, Robert, of Upwell, Cams, brewer 0
5576324 2527651 2527651 defendant Wrenche William laborer 601813 601813 Wrenche, William, of Upwell, Cams, laborer 2

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);