names

72 rows where place_id = 598328

✎ 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
3632021 1904832 1904832 defendant Powltney William gent 598328 598328 Powltney, William, of Lambeth, Surrey, gent 2
3674848 1918161 1918161 defendant Willot Robert gent 598328 598328 Willot, Robert, of Lambeth, Surrey, gent 2
3674854 1918162 1918162 defendant Wyllot Robert gent 598328 598328 Wyllot, Robert, of Lambeth, Surrey, gent 3
3675019 1918216 1918216 defendant Lambe alias Swane Alice widow 598328 598328 Lambe alias Swane, Alice, of Lambeth, Surrey, widow 1
3721345 1932983 1932983 defendant Cresse Robert smith 598328 598328 Cresse, Robert, of Lambeth, Surrey, smith 3
3842267 1971125 1971125 defendant Devenysshe William clerk 598328 598328 Devenysshe, William, of Lambeth, Surrey, clerk 2
3892754 1987826 1987826 defendant Nebbe William innholder 598328 598328 Nebbe, William, of Lambeth, Surrey, innholder 1
3898417 1989682 1989682 defendant Dune John innholder 598328 598328 Dune, John, of Lambeth, Surrey, innholder 2
3945609 2005540 2005540 defendant Knight John gent 598328 598328 Knight, John, of Knight Hill, Lambeth, Surrey, gent 1
3950899 2007381 2007381 defendant Erley Tristram gent 598328 598328 Erley, Tristram, of Lambeth, Surrey, gent 0
3963074 2011684 2011684 defendant Northe Henry gent 598328 598328 (Northe, Henry, of Lambeth, Surrey, gent 1
3973115 2015169 2015169 plaintiff Granger John yeoman 598328 598328 Granger, John, of Lambeth, Surrey, yeoman 0
3994169 2022666 2022666 defendant Longe Anthony innholder 598328 598328 Longe, Anthony, of Lambeth, Surrey, innholder 0
3998029 2024054 2024054 defendant Mote Robert gent 598328 598328 Mote, Robert, of Lambeth, Surrey, gent 2
4010803 2028640 2028640 plaintiff Paytwyn Thomas yeoman 598328 598328 Paytwyn, Thomas, of Lambeth, Surrey, yeoman 0
4019352 2031654 2031654 defendant Sterne John innholder 598328 598328 Sterne, John, of Lambeth, Surrey, innholder 1
4024521 2033446 2033446 plaintiff Blome Robert yeoman 598328 598328 Blome, Robert, of Lambeth, Surrey, yeoman 0
4025050 2033620 2033620 plaintiff Brace John tailor 598328 598328 Brace, John, of Lambeth, Surrey, tailor 0
4039764 2038836 2038836 plaintiff Marshe Peter esq 598328 598328 Marshe, Peter, of Lambeth, Surrey, esq 0
4041401 2039417 2039417 defendant Warden Thomas gent 598328 598328 Warden, Thomas, of Lambeth, Surrey, or of York, gent 0
4048336 2041850 2041850 defendant Dobson John yeoman 598328 598328 Dobson, John,of Lambeth, Surrey, yeoman 3
4048373 2041863 2041863 defendant Dobson John yeoman 598328 598328 Dobson, John, of Lambeth, Surrey, yeoman 3
4055957 2044510 2044510 defendant Cranefild Robert weaver 598328 598328 Cranefild, Robert, of Lambeth, Surrey, weaver 0
4059949 2045954 2045954 plaintiff Cranefeld Robert yeoman 598328 598328 Cranefeld, Robert, of Lambeth, Surrey, yeoman 0
4090941 2057050 2057050 defendant Depup Agnes widow 598328 598328 Depup, Agnes, of Lambeth, Surrey, widow 1
4096407 2059046 2059046 defendant Banes Lawrence yeoman 598328 598328 Banes, Lawrence, of Lambeth, Surrey, yeoman 2
4109565 2063681 2063681 defendant Parker John gent 598328 598328 Parker, John, of Lambeth, Surrey, gent 2
4109780 2063757 2063757 defendant Yorke William smith 598328 598328 Yorke, William, of Lambeth, Surrey, smith 1
4122614 2068383 2068383 defendant Betynson Christopher gent 598328 598328 Betynson, Christopher, of Lambeth, Surrey, gent 0
4130535 2071233 2071233 defendant Dent Thomas innholder 598328 598328 Dent, Thomas, of Lambeth, Surrey, innholder 1
4147231 2077169 2077169 defendant Godderd Thomas esq 598328 598328 Godderd, Thomas, of Lambeth, Surrey, esq 1
4147704 2077340 2077340 defendant Burroughe Thomas esq 598328 598328 Burroughe, Thomas, of Lambeth, Surrey, esq 0
4154876 2079802 2079802 defendant Burghe John esq 598328 598328 Burghe, John, of Lambeth, Surrey, esq 0
4155780 2080101 2080101 defendant Adams Richard saddler 598328 598328 (Adams, Richard, of Lambeth, Surrey, saddler 4
4173152 2086066 2086066 defendant Knyght John girdler 598328 598328 Knyght, John, of Lambeth, Surrey, yeoman, or of London, girdler 0
4179587 2088335 2088335 defendant Hewes Joan widow 598328 598328 Hewes, Joan, of Lambeth, Surrey, widow 4
4206920 2097964 2097964 defendant Crofte Edward gent 598328 598328 Crofte, Edward, of Lambeth, Surrey, gent 0
4207291 2098103 2098103 defendant Knyght John vintner 598328 598328 Knyght, John, of Lambeth, Surrey, vintner 2
4233457 2107217 2107217 defendant Wednester Charles gent 598328 598328 Wednester, Charles, of Lambeth, Surrey, gent 0
4256462 2115129 2115129 defendant Yorke William smith 598328 598328 Yorke, William, of Lambeth, Surrey, smith 1
4259954 2116300 2116300 defendant Knight Thomas innholder 598328 598328 Knight, Thomas, of Lambeth, Surrey, innholder 0
4259956 2116301 2116301 defendant Knight Thomas innholder 598328 598328 Knight, Thomas, of Lambeth, Surrey, innholder 0
4259961 2116303 2116303 defendant Stearne John innholder 598328 598328 Stearne, John, of Lambeth, Surrey, yeoman, innholder 0
4259966 2116304 2116304 defendant Stearne John innholder 598328 598328 Stearne, John, of Lambeth, Surrey, yeoman, innholder 0
4259971 2116305 2116305 defendant Wrighte Thomas gent 598328 598328 Wrighte, Thomas, of Lambeth, Surrey, gent 0
4259973 2116306 2116306 defendant Wrighte Thomas gent 598328 598328 Wrighte, Thomas, of Lambeth, Surrey, gent 0
4264409 2117738 2117738 defendant Starkey Peter innholder 598328 598328 Starkey, Peter, of Lambeth, Surrey, innholder 0
4268724 2119132 2119132 defendant Yorke   smith 598328 598328 Yorke, , of Lambeth, Surrey, smith 1
4281004 2123257 2123257 defendant Bagshawe John, senior yeoman 598328 598328 Bagshawe, John, senior, of Lambeth, Surrey, yeoman 0
4282954 2123940 2123940 defendant Vance Anthony innholder 598328 598328 Vance, Anthony, of Lambeth, Surrey, innholder 0
4295069 2128317 2128317 defendant Richardson Robert innkeeper 598328 598328 Richardson, Robert, of Lambeth, Surrey, yeoman, innkeeper 1
4306042 2132252 2132252 defendant Symons William   598328 598328 Symons, William, of Lambeth, Surrey, shipwright 0
4324096 2138466 2138466 defendant Davis John yeoman 598328 598328 Davis, John, of Lambeth, Surrey, yeoman 2
4324683 2138647 2138647 defendant Parker John esq 598328 598328 Parker, John, of Lambeth, Surrey, esq 0
4325434 2138884 2138884 defendant Lippescombe William esq 598328 598328 Lippescombe, William, of Lambeth, Surrey, esq 3
4326421 2139201 2139201 defendant Knyghte John innholder 598328 598328 Knyghte, John, of Lambeth, Surrey, innholder 0
4329698 2140228 2140228 defendant Thursbye George gent 598328 598328 Thursbye, George, of Lambeth, Surrey, gent 0
4343733 2145086 2145086 defendant Duckett James tailor 598328 598328 Duckett, James, of Lambeth, Surrey, tailor 3
4356993 2149677 2149677 defendant Wednester Bennett widow 598328 598328 Wednester, Bennett, of Lambeth, Surrey, widow 1
4360875 2151058 2151058 defendant Hyggens Walter baker 598328 598328 Hyggens, Walter, of Lambeth, Surrey, baker 0
4367561 2153453 2153453 defendant Duckett John tailor 598328 598328 Duckett, John, of Lambeth, Surrey, tailor 3
4381301 2158426 2158426 defendant Wednester Charles (legal representative) 598328 598328 Wednester, Charles, of Lambeth, Surrey, gent, administratrix of 0
4394690 2162811 2162811 defendant Parker John esq 598328 598328 Parker, John, of Lambeth, Surrey, esq 0
4405145 2166296 2166296 defendant Perkins Richard yeoman 598328 598328 Perkins, Richard, of Lambeth, Surrey, yeoman 0
4405431 2166395 2166395 defendant Saunders John bricklayer 598328 598328 Saunders, John, of Lambeth, Surrey, bricklayer 0
4406927 2166879 2166879 defendant Yelverton William esq 598328 598328 Yelverton, William, of Lambeth, Surrey, esq 1
4697324 2264642 2264642 defendant Beneham Thomas   598328 598328 Beneham, Thomas, of Lambeth, Surrey, parson 0
5146270 2400040 2400040 defendant Gildson Richard beer brewer 598328 598328 Gildson, Richard, of Lambeth, Surrey, beer brewer 1
5151338 2401541 2401541 defendant Pergrave John   598328 598328 Pergrave, John, of Lambeth, Surrey, holy water clerk 1
5167134 2406121 2406121 defendant Lutterworth John yeoman 598328 598328 Lutterworth, John, of Lambeth, Surrey, yeoman 0
5169512 2406821 2406821 defendant Pergrave John   598328 598328 Pergrave, John, of Lambeth, Surrey, holy water clerk 1
5585000 2530382 2530382 defendant Carew Richard   598328 598328 Carew, Richard, of Lambeth, Surrey, knight 0

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