names

103 rows where place_id = 603087

✎ 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
3653015 1911273 1911273 plaintiff White John   603087 603087 White, John, of Caster 0
3669010 1916238 1916238 defendant Johnson James (legal representative) 603087 603087 Johnson, James, of Caster, mercer, administrator of 0
3669023 1916242 1916242 defendant Johnson James (legal representative) 603087 603087 Johnson, James, of Caster, administrator of 0
3670559 1916755 1916755 defendant Grene Robert yeoman 603087 603087 Grene, Robert, of Caster, yeoman 1
3673314 1917668 1917668 defendant Tharrold Robert fisherman 603087 603087 Tharrold, Robert, of Caster, fisherman 1
3675838 1918478 1918478 defendant Coke John mercer 603087 603087 Coke, John, of Caster, mercer 0
3676946 1918826 1918826 defendant Johnson James (legal representative) 603087 603087 Johnson, James, of Caster, mercer, administrator of 0
3677752 1919090 1919090 defendant Atkynson James yeoman 603087 603087 Atkynson, James, of Caster, yeoman 1
3697761 1925523 1925523 defendant Keill Robert fisher 603087 603087 Keill, Robert, of Caster, fisher 0
3714165 1930729 1930729 defendant Johnson William (legal representative) 603087 603087 Johnson, William, of Caster, mercer, executrix of 0
3714166 1930729 1930729 defendant Johnson Joan widow 603087 603087 Johnson, Joan, of Caster, widow 1
3720822 1932804 1932804 defendant West Robert draper 603087 603087 West, Robert, of Caster, draper 0
3754700 1943431 1943431 defendant Basse William carpenter 603087 603087 Basse, William, of Caster, carpenter 0
3757507 1944321 1944321 defendant Ade Robert husbandman 603087 603087 Ade, Robert, of Caster, husbandman 2
3780102 1951501 1951501 defendant Waller alias Metcalfe Richard husbandman 603087 603087 Waller alias Metcalfe, Richard, of Caster, husbandman 0
3784395 1952899 1952899 defendant Rydesayre Richard husbandman 603087 603087 Rydesayre, Richard, of Caster, husbandman 0
3833911 1968544 1968544 defendant Rowght Richard yeoman 603087 603087 Rowght, Richard, of Caster, yeoman 0
3833913 1968544 1968544 defendant Grene John yeoman 603087 603087 Grene, John, of Caster, yeoman 2
3837679 1969695 1969695 defendant Routhe Robert yeoman 603087 603087 Routhe, Robert, of Caster, yeoman 1
3899070 1989898 1989898 plaintiff Barnwell William husbandman 603087 603087 Barnwell, William, of Caster, husbandman 0
3901751 1990809 1990809 plaintiff Curtes Robert husbandman 603087 603087 Curtes, Robert, of Caster, husbandman 0
3903499 1991398 1991398 defendant Taterall John glover 603087 603087 Taterall, John, of Caster, glover 0
3915923 1995706 1995706 defendant Curtes Robert husbandman 603087 603087 Curtes, Robert, of Caster, husbandman 0
3915925 1995706 1995706 defendant Mosse Hugh husbandman 603087 603087 Mosse, Hugh, of Caster, husbandman 2
3915926 1995706 1995706 defendant Wyldbore William husbandman 603087 603087 Wyldbore, William, of Caster, husbandman 3
3915927 1995706 1995706 defendant Waren William husbandman 603087 603087 Waren, William, of Caster, husbandman 4
3915928 1995706 1995706 defendant Alsop John husbandman 603087 603087 Alsop, John, of Caster, husbandman 5
3915929 1995706 1995706 defendant Wylson Richard husbandman 603087 603087 Wylson, Richard, of Caster, husbandman 6
3922802 1997932 1997932 defendant Gybson William husbandman 603087 603087 Gybson, William, of Caster, husbandman 0
3922803 1997932 1997932 defendant Rey George yeoman 603087 603087 Rey, George, of Caster, yeoman 1
3922804 1997932 1997932 defendant Haynton William husbandman 603087 603087 Haynton, William, of Caster, husbandman 2
3932856 2001280 2001280 defendant Baseley John yeoman 603087 603087 Baseley, John, of Caster, yeoman 0
3951136 2007466 2007466 defendant Townsende Christopher husbandman 603087 603087 Townsende, Christopher, of Caster, husbandman 1
3984350 2019160 2019160 defendant Townesend Christopher yeoman 603087 603087 Townesend, Christopher, of Caster, yeoman 14
4030742 2035657 2035657 defendant Clerke Christopher husbandman 603087 603087 Clerke, Christopher, of Caster, husbandman 1
4037179 2037957 2037957 plaintiff Johnson James   603087 603087 Johnson, James, of Caster 0
4037181 2037958 2037958 plaintiff Johnson James   603087 603087 Johnson, James, of Caster 0
4043087 2039995 2039995 defendant Brigg John yeoman 603087 603087 Brigg, John, of Caster, yeoman 0
4043089 2039996 2039996 defendant Brygg John yeoman 603087 603087 Brygg, John, of Caster, yeoman 0
4056680 2044777 2044777 defendant Inglyshe Michael gent 603087 603087 Inglyshe, Michael, of Caster, gent 0
4056919 2044858 2044858 defendant Blythe Thomas yeoman 603087 603087 Blythe, Thomas, of Caster, yeoman 0
4056922 2044859 2044859 defendant Blythe Thomas yeoman 603087 603087 Blythe, Thomas, of Caster, yeoman 0
4058072 2045268 2045268 defendant Townend Christopher yeoman 603087 603087 Townend Christopher, of Caster, yeoman 0
4058073 2045268 2045268 defendant Botham Richard yeoman 603087 603087 Botham, Richard, of Caster, yeoman 1
4058075 2045269 2045269 defendant Townesend Christopher yeoman 603087 603087 Townesend, Christopher, of Caster, yeoman 0
4058076 2045269 2045269 defendant Borham Richard yeoman 603087 603087 Borham, Richard, of Caster, yeoman 1
4059460 2045779 2045779 plaintiff Cood or Cod Humphrey mercer 603087 603087 Cood or Cod, Humphrey, of Caster, mercer 0
4089578 2056561 2056561 defendant Kelsey George husbandman 603087 603087 Kelsey, George, of Caster, husbandman 1
4103219 2061432 2061432 defendant Townesend Christopher yeoman 603087 603087 Townesend, Christopher, of Caster, yeoman 0
4105222 2062143 2062143 defendant Harrison William husbandman 603087 603087 Harrison, William, of Caster, husbandman 0
4110648 2064065 2064065 defendant Payne Edmund gent 603087 603087 Payne, Edmund, of Caster, gent 1
4110757 2064105 2064105 defendant Payne Edmund gent 603087 603087 Payne, Edmund, of Caster, gent 1
4111929 2064516 2064516 defendant Johnson James innkeeper 603087 603087 Johnson, James, of Caster, yeoman, innkeeper 0
4112437 2064705 2064705 defendant Townsend Christoppher yeoman 603087 603087 Townsend, Christoppher, of Caster, yeoman 1
4120865 2067750 2067750 defendant Ellistons John clothier 603087 603087 Ellistons, John, of Caster, or of Hallifaxe, clothier 0
4121867 2068119 2068119 defendant Webster Robert merchant 603087 603087 Webster, Robert, of Caster, merchant 0
4124485 2069052 2069052 defendant Bellowe Stephen glover 603087 603087 Bellowe, Stephen, of Caster, glover 0
4125970 2069572 2069572 defendant Wighell John gent 603087 603087 Wighell, John, of Caster, or of Dowthorp in Holdernes, Yorks, gent 0
4125971 2069572 2069572 defendant Pormort George merchant 603087 603087 Pormort, George, of Caster, or of Kingston on Hull, merchant 1
4125972 2069572 2069572 defendant Browne George gent 603087 603087 Browne, George, of Caster, or of Kingston on Hull, gent 2
4140553 2074864 2074864 defendant Duffe alias Wood Thomas yeoman 603087 603087 Duffe alias Wood, Thomas, of Caster, yeoman 0
4142990 2075717 2075717 defendant Bradley William yeoman 603087 603087 Bradley, William, of Caster, yeoman 0
4144992 2076407 2076407 defendant Webster Robert merchant 603087 603087 Webster, Robert, of Caster, merchant 0
4147641 2077315 2077315 defendant Bellow Stephen glover 603087 603087 Bellow, Stephen, of Caster, glover 0
4167935 2084271 2084271 defendant Leake Hugh gent 603087 603087 Leake, Hugh, of Caster, gent 0
4167936 2084271 2084271 defendant Marshall John roper 603087 603087 Marshall, John, of Caster, roper 1
4170931 2085316 2085316 defendant Leake Hugh innkeeper 603087 603087 Leake, Hugh, of Caster, innkeeper 1
4174090 2086391 2086391 defendant Browne George gent 603087 603087 Browne, George, of Caster, or of Kingston on Hull, gent 0
4174094 2086393 2086393 defendant Pormort Gregory merchant 603087 603087 Pormort, Gregory, of Caster, or of Kingston on Hull, merchant 0
4174096 2086394 2086394 defendant Wyghell John gent 603087 603087 Wyghell, John, of Caster, or of Dowthorp in Holdernes, Yorks, gent 0
4177972 2087769 2087769 defendant Leake Hugh gent 603087 603087 Leake, Hugh, of Caster, gent 0
4181527 2089018 2089018 defendant Forman Alexander gent 603087 603087 Forman, Alexander, of Caster, gent 0
4185029 2090273 2090273 defendant Sowden William husbandman 603087 603087 Sowden, William, of Caster, husbandman 0
4186601 2090797 2090797 defendant Grymmelbbye Ralph yeoman 603087 603087 Grymmelbbye, Ralph, of Caster, yeoman 1
4187417 2091097 2091097 defendant Leake Hugh gent 603087 603087 Leake, Hugh, of Caster, gent 0
4189500 2091826 2091826 defendant Lake Hugh innholder 603087 603087 Lake, Hugh, of Caster, innholder 0
4192916 2093087 2093087 defendant Leake Hugh innholder 603087 603087 Leake, Hugh, of Caster, innholder 1
4240244 2109709 2109709 defendant Mason Christopher blacksmith 603087 603087 Mason, Christopher, of Caster, blacksmith 1
4285268 2124781 2124781 defendant Losse Christopher husbandman 603087 603087 Losse, Christopher, of Caster, husbandman 5
4291008 2126851 2126851 plaintiff Stebbyn Robert (legal representative) 603087 603087 Stebbyn, Robert, of Caster, yeoman, executors of 0
4293166 2127617 2127617 defendant Sabsford of Sabfford Henry husbandman 603087 603087 Sabsford of Sabfford, Henry, of Caster, husbandman 1
4301404 2130608 2130608 defendant Wildbore Richard husbandman 603087 603087 Wildbore, Richard, of Caster, husbandman 0
4301660 2130699 2130699 defendant Wyldbore Richard husbandman 603087 603087 Wyldbore, Richard, of Caster, husbandman 0
4305872 2132192 2132192 defendant Wilbore Richard husbandman 603087 603087 Wilbore, Richard, of Caster, husbandman 0
4309128 2133348 2133348 defendant Wildbore Richard husbandman 603087 603087 Wildbore, Richard, of Caster, husbandman 0
4309710 2133553 2133553 defendant Wildbore Richard husbandman 603087 603087 Wildbore, Richard, of Caster, husbandman 0
4310214 2133727 2133727 defendant Wildbore Richard husbandman 603087 603087 Wildbore, Richard, of Caster, husbandman 0
4317355 2136184 2136184 defendant Wildbore Richard yeoman 603087 603087 Wildbore, Richard, of Caster, yeoman 0
4320233 2137178 2137178 defendant Aldred Richard gent 603087 603087 Aldred, Richard, of Caster, gent 0
4320235 2137178 2137178 defendant White Christopher husbandman 603087 603087 White, Christopher, of Caster, husbandman 2
4323262 2138197 2138197 defendant Wildbore Richard husbandman 603087 603087 Wildbore, Richard, of Caster, husbandman 0
4325752 2138988 2138988 defendant Durrant John husbandman 603087 603087 Durrant, John, of Caster, husbandman 6
4325753 2138988 2138988 defendant Losse Christopher husbandman 603087 603087 Losse, Christopher, of Caster, husbandman 7
4408741 2167520 2167520 defendant Atkinson George husbandman 603087 603087 Atkinson, George, of Caster, husbandman 0
5183088 2410797 2410797 defendant Derby William carpenter 603087 603087 Derby, William, of Caster, carpenter 1
5203722 2416839 2416839 defendant Derby William carpenter 603087 603087 Derby, William, of Caster, carpenter 1
5219267 2421360 2421360 defendant Essheton John weaver 603087 603087 Essheton, John, of Caster, weaver 4
5219273 2421361 2421361 defendant Essheton John weaver 603087 603087 Essheton, John, of Caster, weaver 4
5234466 2425671 2425671 defendant Derby William carpenter 603087 603087 Derby, William, of Caster, carpenter 2
5354384 2461438 2461438 defendant Daweney Henry yeoman 603087 603087 Daweney, Henry, of Caster, yeoman 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);