names

105 rows where place_id = 586652

✎ 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
3589300 1864295 1864295 defendant Palfreyman Robert husbandman 586652 586652 Palfreyman, Robert, of Islyngton, husbandman 2
3596869 1866656 1866656 defendant Lacy Nicholas husbandman 586652 586652 Lacy, Nicholas, of Islyngton, husbandman 0
3596873 1866657 1866657 defendant Lacy Richard husbandman 586652 586652 Lacy, Richard, of Islyngton, husbandman 0
3625248 1875432 1875432 defendant Dagles William smith 586652 586652 Dagles, William, of Islyngton, smith 3
3631518 1904673 1904673 defendant Spaldyng Robert yeoman 586652 586652 Spaldyng, Robert, of Islyngton, yeoman 0
3660697 1913611 1913611 plaintiff Howardyn Joan widow 586652 586652 Howardyn, Joan, of Islyngton, widow 0
3672519 1917407 1917407 defendant Warde Anthony husbandman 586652 586652 Warde, Anthony, of Islyngton, husbandman 2
3676954 1918829 1918829 defendant Whirell William husbandman 586652 586652 Whirell, William, of Islyngton, husbandman 0
3688213 1922463 1922463 defendant Wherell William yeoman 586652 586652 Wherell, William, of Islyngton, yeoman 1
3699787 1926157 1926157 defendant Sharpe William husbandman 586652 586652 Sharpe, William, of Islyngton, husbandman 0
3699788 1926157 1926157 defendant Sharpe Robert husbandman 586652 586652 Sharpe, Robert, of Islyngton, husbandman 1
3703891 1927497 1927497 defendant Werell William husbandman 586652 586652 Werell, William, of Islyngton, husbandman 1
3705197 1927911 1927911 defendant Hamond John husbandman 586652 586652 Hamond, John, of Islyngton, husbandman 1
3707409 1928609 1928609 defendant Waters John yeoman 586652 586652 Waters, John, of Islyngton, yeoman 0
3710139 1929485 1929485 defendant Scharpe William husbandman 586652 586652 Scharpe, William, of Islyngton, husbandman 0
3710140 1929485 1929485 defendant Scharpe Robert husbandman 586652 586652 Scharpe, Robert, of Islyngton, husbandman 1
3710142 1929486 1929486 defendant Scharpe William husbandman 586652 586652 Scharpe, William, of Islyngton, husbandman 0
3710143 1929486 1929486 defendant Scharpe Robert husbandman 586652 586652 Scharpe, Robert, of Islyngton, husbandman 1
3724717 1934016 1934016 defendant Sharpe William husbandman 586652 586652 Sharpe, William, of Islyngton, husbandman 0
3724718 1934016 1934016 defendant Sharpe Robert husbandman 586652 586652 Sharpe, Robert, of Islyngton, husbandman 1
3725599 1934298 1934298 defendant Burton John yeoman 586652 586652 Burton, John, of Islyngton, yeoman 1
3731222 1935991 1935991 defendant Wherell William husbandman 586652 586652 Wherell, William, of Islyngton, husbandman 1
3731223 1935991 1935991 defendant Wherell Katherine widow 586652 586652 Wherell, Katherine, of Islyngton, widow 2
3731561 1936097 1936097 defendant Appowell Lewis yeoman 586652 586652 Appowell, Lewis, of Islyngton, yeoman 0
3734464 1937022 1937022 defendant Spaldyng Robert yeoman 586652 586652 Spaldyng, Robert, of Islyngton, yeoman 1
3771517 1948784 1948784 defendant Spademan William yeoman 586652 586652 Spademan, William, of Islyngton, yeoman 3
3776051 1950254 1950254 defendant Robynson James clerk 586652 586652 Robynson, James, of Islyngton, clerk 1
3776052 1950254 1950254 defendant Towse Roger carpenter 586652 586652 Towse, Roger, of Islyngton, carpenter 2
3787158 1953774 1953774 defendant Ablot William husbandman 586652 586652 Ablot, William, of Islyngton, husbandman 0
3793585 1955856 1955856 defendant Robynson James clerk 586652 586652 Robynson, James, of Islyngton, clerk 1
3793586 1955856 1955856 defendant Towse Roger carpenter 586652 586652 Towse, Roger, of Islyngton, carpenter 2
3816249 1962990 1962990 defendant Grene Richard carter 586652 586652 Grene, Richard, of Islyngton, carter 1
3826586 1966164 1966164 defendant Sharpe Robert yeoman 586652 586652 Sharpe, Robert, of Islyngton, yeoman 0
3829654 1967166 1967166 defendant Cauntwell William yeoman 586652 586652 Cauntwell, William, of Islyngton, yeoman 3
3829708 1967184 1967184 plaintiff Grubbe Edward husbandman 586652 586652 Grubbe, Edward, of Islyngton, husbandman 1
3831028 1967587 1967587 defendant Jagnett William laborer 586652 586652 Jagnett, William, of Islyngton, laborer 3
3836968 1969469 1969469 defendant Abbott William husbandman 586652 586652 Abbott, William, of Islyngton, husbandman 0
3838676 1970021 1970021 defendant Dery John brewer 586652 586652 Dery, John, of Islyngton, brewer 0
3838677 1970021 1970021 defendant Grubbe Edward husbandman 586652 586652 Grubbe, Edward, of Islyngton, husbandman 1
3852336 1974332 1974332 defendant Ablott William husbandman 586652 586652 Ablott, William, of Islyngton, husbandman 0
3853005 1974560 1974560 defendant Abbott William husbandman 586652 586652 Abbott, William, of Islyngton, husbandman 2
3932322 2001115 2001115 plaintiff Forde George esq 586652 586652 Forde, George, of Islyngton, esq 0
3962287 2011391 2011391 defendant Cosyn John yeoman 586652 586652 Cosyn, John, of Islyngton, yeoman 0
3981639 2018190 2018190 defendant Baldynge William yeoman 586652 586652 Baldynge, William, of Islyngton, yeoman 1
4020507 2032058 2032058 defendant Rigges Clement innholder 586652 586652 Rigges, Clement, of Islyngton, innholder 0
4021870 2032548 2032548 defendant Estryck Robert   586652 586652 Estryck, Robert, of Islyngton 0
4030690 2035638 2035638 defendant Blande James husbandman 586652 586652 Blande, James, of Islyngton, husbandman 1
4054179 2043882 2043882 defendant Cressey Thomas gent 586652 586652 Cressey, Thomas, of Islyngton, gent 3
4072557 2050490 2050490 defendant Steward Peter tailor 586652 586652 Steward, Peter, of Islyngton, tailor 3
4082661 2054109 2054109 defendant Kynge Robert husbandman 586652 586652 (Kynge, Robert, of Islyngton, husbandman 2
4083976 2054546 2054546 defendant Roodman Richard husbandman 586652 586652 Roodman, Richard, of Islyngton, husbandman 0
4083977 2054546 2054546 defendant Kynge Robert husbandman 586652 586652 Kynge, Robert, of Islyngton, husbandman 1
4115756 2065916 2065916 defendant Balding Robert yeoman 586652 586652 Balding, Robert, of Islyngton, yeoman 1
4115757 2065916 2065916 defendant Steward Peter yeoman 586652 586652 Steward, Peter, of Islyngton, yeoman 2
4166612 2083819 2083819 defendant Rudham Richard husbandman 586652 586652 Rudham, Richard, of Islyngton, husbandman 0
4180417 2088626 2088626 defendant Flory John husbandman 586652 586652 Flory, John, of Islyngton, husbandman 3
4191865 2092713 2092713 defendant Rudham Richard husbandman 586652 586652 Rudham, Richard, of Islyngton, husbandman 0
4205763 2097564 2097564 defendant Flory John yeoman 586652 586652 Flory, John, of Islyngton, yeoman 0
4205765 2097565 2097565 defendant Florye John husbandman 586652 586652 Florye, John, of Islyngton, husbandman 0
4212757 2100002 2100002 defendant Rudham Richard husbandman 586652 586652 Rudham, Richard, of Islyngton, husbandman 2
4212758 2100002 2100002 defendant Florye John husbandman 586652 586652 Florye, John, of Islyngton, husbandman 3
4552601 2216767 2216767 defendant Kervyle Robert   586652 586652 Kervyle, Robert, of Islyngton 0
4794557 2294438 2294438 defendant Milk William husbandman 586652 586652 together with Milk, William, of Islyngton, husbandman 1
4920955 2333067 2333067 defendant Bernewell John yeoman 586652 586652 Bernewell, John, of Islyngton, yeoman 1
4946462 2340889 2340889 plaintiff Kervyle Edmund   586652 586652 Kervyle, Edmund, of Islyngton 0
4946468 2340891 2340891 plaintiff Kervyll Edmund   586652 586652 Kervyll, Edmund, of Islyngton 0
4954245 2343243 2343243 defendant Powedych Robert yeoman 586652 586652 Powedych, Robert, of Islyngton, yeoman 0
4972346 2348666 2348666 defendant Belyot Edmund husbandman 586652 586652 Belyot, Edmund, of Islyngton, husbandman 1
4972347 2348666 2348666 defendant Bernewell John husbandman 586652 586652 Bernewell, John, of Islyngton, husbandman 2
4984027 2352155 2352155 defendant Alberd John husbandman 586652 586652 Alberd, John, of Islyngton, husbandman 0
5003885 2358026 2358026 defendant Flory Richard husbandman 586652 586652 Flory, Richard, of Islyngton, husbandman 2
5011134 2360109 2360109 defendant Milk William yeoman 586652 586652 Milk, William, of Islyngton, yeoman 0
5011135 2360109 2360109 defendant Milk Edmund yeoman 586652 586652 Milk, Edmund, of Islyngton, yeoman 1
5016887 2361830 2361830 defendant Nytynghale John laborer 586652 586652 Nytynghale, John, of Islyngton, laborer 2
5016889 2361830 2361830 defendant Nytynghale William husbandman 586652 586652 Nytynghale, William, of Islyngton, husbandman 4
5025653 2364410 2364410 defendant Neyghtynghale John husbandman 586652 586652 Neyghtynghale, John, of Islyngton, husbandman 0
5025654 2364410 2364410 defendant Bokerey John husbandman 586652 586652 Bokerey, John, of Islyngton, husbandman 1
5025656 2364411 2364411 defendant Bastard John husbandman 586652 586652 Bastard, John, of Islyngton, husbandman 0
5037870 2367955 2367955 defendant Billyet Edmund yeoman 586652 586652 Billyet, Edmund, of Islyngton, yeoman 0
5266640 2435320 2435320 defendant Nygale Thomas husbandman 586652 586652 Nygale, Thomas, of Islyngton, husbandman 0
5266850 2435383 2435383 defendant Freman Richard husbandman 586652 586652 Freman, Richard, of Islyngton, husbandman 0
5283984 2440341 2440341 defendant Reve Thomas husbandman 586652 586652 Reve, Thomas, of Islyngton, husbandman 1
5306422 2446908 2446908 defendant Freman Richard husbandman 586652 586652 Freman, Richard, of Islyngton, husbandman 0
5306986 2447087 2447087 defendant Bekerey John husbandman 586652 586652 Bekerey, John, of Islyngton, husbandman 1
5310393 2448144 2448144 defendant Freman Thomas husbandman 586652 586652 Freman, Thomas, of Islyngton, husbandman 0
5369225 2465974 2465974 defendant Flory John yeoman 586652 586652 Flory, John, of Islyngton, yeoman 3
5374519 2467634 2467634 defendant Nytegale Edmund husbandman 586652 586652 Nytegale, Edmund, of Islyngton, husbandman 1
5439931 2486886 2486886 defendant Cordell John yeoman 586652 586652 Cordell, John, of Islyngton, yeoman 3
5514305 2509325 2509325 defendant Benet Joan widow 586652 586652 Benet, Joan, of Islyngton, widow 0
5514307 2509326 2509326 defendant Flude William gent 586652 586652 Flude, William, of Islyngton, gent 0
5516339 2509944 2509944 defendant Pygge Robert husbandman 586652 586652 Pygge, Robert, of Islyngton, husbandman 2
5523684 2512235 2512235 plaintiff Gedney Thomas   586652 586652 Gedney, Thomas, of Islyngton 0
5523686 2512236 2512236 plaintiff Gedney Thomas   586652 586652 Gedney, Thomas, of Islyngton 0
5527298 2513115 2513115 defendant Bonham John painter 586652 586652 Bonham, John, of Islyngton, painter 2
5533109 2514899 2514899 defendant Nayller John husbandman 586652 586652 Nayller, John, of Islyngton, husbandman 2
5533114 2514900 2514900 defendant Nayller John husbandman 586652 586652 Nayller, John, of Islyngton, husbandman 2
5542174 2517683 2517683 defendant Mounford John gent 586652 586652 Mounford, John, of Islyngton, gent 1
5550881 2520290 2520290 defendant Ingland Stephen yeoman 586652 586652 Ingland, Stephen, of Islyngton, yeoman 1
5573010 2526657 2526657 defendant Olyff John husbandman 586652 586652 Olyff, John, of Islyngton, husbandman 0
5573013 2526658 2526658 defendant Olyff John husbandman 586652 586652 Olyff, John, of Islyngton, husbandman 0

Next page

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