names

56 rows where place_id = 592266

✎ 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
3607140 1869899 1869899 defendant Wodyng William husbandman 592266 592266 Wodyng, William, of Bosbury, husbandman 1
3607141 1869899 1869899 defendant Wyn John husbandman 592266 592266 Wyn, John, of Bosbury, husbandman 2
3662835 1914291 1914291 defendant Hope Richard yeoman 592266 592266 Hope, Richard, of Bosbury, yeoman 0
3662836 1914291 1914291 defendant Kent Roger laborer 592266 592266 Kent, Roger, of Bosbury, laborer 1
3662837 1914291 1914291 defendant Hill Eleanor spinster 592266 592266 Hill, Eleanor, of Bosbury, spinster 2
3697250 1925363 1925363 plaintiff Stevens John   592266 592266 Stevens, John, of Bosbury 0
3892406 1987712 1987712 defendant Cornewell William husbandman 592266 592266 Cornewell, William, of Bosbury, husbandman 3
3903990 1991574 1991574 defendant Walwyn Edward gent 592266 592266 Walwyn, Edward, of Bosbury, gent 0
3933893 2001632 2001632 plaintiff Harforde John gent 592266 592266 Harforde, John, of Bosbury, gent 0
3974065 2015498 2015498 plaintiff Harford Richard esq 592266 592266 Harford, Richard, of Bosbury, esq 0
4004486 2026379 2026379 defendant Farley Thomas yeoman 592266 592266 Farley, Thomas, of Bosbury, yeoman 3
4034083 2036850 2036850 defendant Brydge James yeoman 592266 592266 Brydge, James, of Bosbury, yeoman 0
4037263 2037992 2037992 defendant Fynche Richard husbandman 592266 592266 Fynche, Richard, of Bosbury, husbandman 0
4037266 2037992 2037992 defendant Knyght Richard husbandman 592266 592266 Knyght, Richard, of Bosbury, husbandman 3
4098340 2059734 2059734 defendant Hawfyld Anthony gent 592266 592266 Hawfyld, Anthony, of Bosbury, gent 1
4139323 2074430 2074430 defendant Hill Katherine widow 592266 592266 Hill, Katherine, of Bosbury, widow 0
4150575 2078335 2078335 defendant Brampton Edward yeoman 592266 592266 Brampton, Edward, of Bosbury, yeoman 2
4156730 2080432 2080432 defendant Bridge Richard husbandman 592266 592266 Bridge, Richard, of Bosbury, husbandman 0
4185210 2090335 2090335 defendant Woodynge Richard yeoman 592266 592266 Woodynge, Richard, of Bosbury, yeoman 0
4215055 2100768 2100768 defendant Mutlowe Elizabeth widow 592266 592266 Mutlowe, Elizabeth, of Bosbury, widow 1
4215776 2101015 2101015 defendant Fynch Richard yeoman 592266 592266 Fynch, Richard, of Bosbury, yeoman 0
4215777 2101015 2101015 defendant Goodynge Richard yeoman 592266 592266 Goodynge, Richard, of Bosbury, yeoman 1
4215778 2101015 2101015 defendant Seborne Richard yeoman 592266 592266 Seborne, Richard, of Bosbury, yeoman 2
4224541 2104063 2104063 defendant Mutlowe Elizabeth widow 592266 592266 Mutlowe, Elizabeth, of Bosbury, widow 1
4225141 2104264 2104264 defendant Fynche Richard yeoman 592266 592266 Fynche, Richard, of Bosbury, yeoman 0
4225142 2104264 2104264 defendant Goodinge Richard yeoman 592266 592266 Goodinge, Richard, of Bosbury, yeoman 1
4225143 2104264 2104264 defendant Seborne Richard yeoman 592266 592266 Seborne, Richard, of Bosbury, yeoman 2
4235331 2107920 2107920 defendant Howles Edward yeoman 592266 592266 Howles, Edward, of Bosbury, yeoman 0
4235332 2107920 2107920 defendant Wood Thomas yeoman 592266 592266 Wood, Thomas, of Bosbury, yeoman 1
4248361 2112443 2112443 defendant Fynche Richard yeoman 592266 592266 Fynche, Richard, of Bosbury, yeoman 1
4248362 2112443 2112443 defendant Tyler Richard yeoman 592266 592266 Tyler, Richard, of Bosbury, yeoman 2
4300206 2130173 2130173 defendant Stevens Thomas yeoman 592266 592266 Stevens, Thomas, of Bosbury, yeoman 0
4315709 2135604 2135604 defendant Cornell Gabriel husbandman 592266 592266 Cornell, Gabriel, of Bosbury, husbandman 0
4315710 2135604 2135604 defendant Kenitt Richard husbandman 592266 592266 Kenitt, Richard, of Bosbury, husbandman 1
4315711 2135604 2135604 defendant Glasier Thomas glover 592266 592266 Glasier, Thomas, of Bosbury, glover 2
4315712 2135604 2135604 defendant Gillam James husbandman 592266 592266 Gillam, James, of Bosbury, husbandman 3
4328645 2139894 2139894 defendant Hodgkins alias Hodges William yeoman 592266 592266 Hodgkins alias Hodges, William, of Bosbury, yeoman 3
4343769 2145099 2145099 defendant Fynche Richard yeoman 592266 592266 Fynche, Richard, of Bosbury, yeoman 1
4364803 2152464 2152464 defendant Woodinge Richard husbandman 592266 592266 Woodinge, Richard, of Bosbury, husbandman 0
4364804 2152464 2152464 defendant Turnor John husbandman 592266 592266 Turnor, John, of Bosbury, husbandman 1
4370528 2154510 2154510 defendant Seburne Richard, junior yeoman 592266 592266 Seburne, Richard, junior, of Bosbury, yeoman 0
4377663 2157083 2157083 defendant Seaborne Richard, senior yeoman 592266 592266 Seaborne, Richard, senior, of Bosbury, yeoman 1
4377664 2157083 2157083 defendant Seaborne Richard, junior yeoman 592266 592266 Seaborne, Richard, junior, of Bosbury, yeoman 2
4377665 2157083 2157083 defendant Kent Richard yeoman 592266 592266 Kent, Richard, of Bosbury, yeoman 3
4395317 2163014 2163014 defendant Tyler Richard husbandman 592266 592266 Tyler, Richard, of Bosbury, husbandman 0
4395318 2163014 2163014 defendant Smyth Thomas laborer 592266 592266 Smyth, Thomas, of Bosbury, laborer 1
4398983 2164243 2164243 defendant Sebourne Richard, senior yeoman 592266 592266 Sebourne, Richard, senior, of Bosbury, yeoman 0
4398984 2164243 2164243 defendant Sebourne Richard, junior yeoman 592266 592266 Sebourne, Richard, junior, of Bosbury, yeoman 1
4412156 2168659 2168659 defendant Hill John husbandman 592266 592266 (Hill, John, of Bosbury, husbandman 1
5028622 2365249 2365249 defendant Oldebury Richard clerk 592266 592266 Oldebury, Richard, of Bosbury, clerk 3
5049514 2371484 2371484 defendant Strode Thomas husbandman 592266 592266 Strode, Thomas, of Bosbury, husbandman 0
5082166 2381161 2381161 defendant Whitby Richard clerk 592266 592266 Whitby, Richard, of Bosbury, clerk 1
5160260 2404095 2404095 defendant Mourton John husbandman 592266 592266 Mourton, John, of Bosbury, husbandman 3
5175108 2408415 2408415 defendant Mourton John husbandman 592266 592266 Mourton, John, of Bosbury, husbandman 1
5352383 2460844 2460844 defendant Morton John husbandman 592266 592266 Morton, John, of Bosbury, husbandman 1
5625321 2551857 2551857 defendant Toppesle John husbandman 592266 592266 Toppesle, John, of Bosbury, husbandman 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);