names

38 rows where place_id = 632570

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3807337 1960197 1960197 plaintiff Wodewall Humphrey merchant 632570 632570 Wodewall, Humphrey, of Bewdley, merchant 0
3883933 1984896 1984896 plaintiff Wodwall Richard merchant 632570 632570 Wodwall, Richard, of Bewdley, merchant 0
3936653 2002586 2002586 defendant Turnor Edward yeoman 632570 632570 Turnor, Edward, of Bewdley, yeoman 0
3936654 2002586 2002586 defendant Tarbox James sadler 632570 632570 Tarbox, James, of Bewdley, sadler 1
4011564 2028891 2028891 defendant Campion Edward gent 632570 632570 Campion, Edward, of Bewdley, gent 0
4025309 2033713 2033713 plaintiff Brigg Oliver merchant 632570 632570 Brigg, Oliver, of Bewdley, merchant 0
4027605 2034521 2034521 defendant Patrick John butcher 632570 632570 Patrick, John, of Bewdley, butcher 0
4027775 2034584 2034584 defendant Pattrick John butcher 632570 632570 Pattrick, John, of Bewdley, butcher 0
4046874 2041334 2041334 defendant Mylwarde John yeoman 632570 632570 Mylwarde, John, of Bewdley, yeoman 1
4046883 2041338 2041338 defendant Milwarde John yeoman 632570 632570 Milwarde, John, of Bewdley, yeoman 1
4135351 2072964 2072964 defendant Bysshopp James yeoman 632570 632570 Bysshopp, James, of Bewdley, yeoman 1
4175958 2087068 2087068 defendant Hill James haberdasher 632570 632570 Hill, James, of Bewdley, haberdasher 2
4175963 2087069 2087069 defendant Hill James haberdasher 632570 632570 Hill, James, of Bewdley, haberdasher 2
4176110 2087120 2087120 defendant Maynard Mary widow 632570 632570 Maynard, Mary, of Bewdley, widow 0
4176112 2087120 2087120 defendant Mason William inlayer 632570 632570 Mason, William, of Bewdley, joiner, inlayer 2
4176115 2087121 2087121 defendant Maynard Mary widow 632570 632570 Maynard, Mary, of Bewdley, widow 0
4176117 2087121 2087121 defendant Mason William inlayer 632570 632570 Mason, William, of Bewdley, joiner, inlayer 2
4183003 2089536 2089536 defendant Lowe Thomas tailor 632570 632570 Lowe, Thomas, of Bewdley, tailor 0
4188696 2091525 2091525 defendant Symons Richard carpenter 632570 632570 Symons, Richard, of Bewdley, carpenter 1
4188700 2091526 2091526 defendant Symons Richard carpenter 632570 632570 Symons, Richard, of Bewdley, carpenter 1
4235551 2108002 2108002 defendant Clarke Robert barber 632570 632570 Clarke, Robert, of Bewdley, barber 3
4246351 2111757 2111757 defendant Hill John husbandman 632570 632570 Hill, John, of Bewdley, husbandman 2
4292886 2127522 2127522 defendant Tomes Humphrey shoemaker 632570 632570 Tomes, Humphrey, of Bewdley, shoemaker 1
4298392 2129526 2129526 defendant Hamondes Humphrey mercer 632570 632570 Hamondes, Humphrey, of Bewdley, mercer 0
4299836 2130032 2130032 defendant Browne Thomas timberman 632570 632570 Browne, Thomas, of Bewdley, timberman 1
4317022 2136065 2136065 defendant Monnowse Ellen or Helen (legal representative) 632570 632570 Monnowse, Ellen or Helen, of Bewdley, widow of William Monnowse, executors of 0
4317023 2136065 2136065 defendant Bostocke Agnes widow 632570 632570 (Bostocke, Agnes, of Bewdley, widow 1
4317024 2136065 2136065 defendant Brownynge John yeoman 632570 632570 Brownynge, John, of Bewdley, yeoman 2
4330617 2140533 2140533 defendant Hawkyns John sherman 632570 632570 Hawkyns, John, of Bewdley, sherman 3
4343225 2144903 2144903 defendant Hamonde Humphrey mercer 632570 632570 Hamonde, Humphrey, of Bewdley, mercer 0
4361561 2151297 2151297 defendant Vickeris Richard yeoman 632570 632570 Vickeris, Richard, of Bewdley, yeoman 0
4391264 2161695 2161695 defendant Fawkener Thomas carpenter 632570 632570 Fawkener, Thomas, of Bewdley, carpenter 1
4403738 2165823 2165823 defendant Draper John, junior mercer 632570 632570 Draper, John, junior, of Bewdley, mercer 0
4403739 2165823 2165823 defendant Tracye John, senior yeoman 632570 632570 Tracye, John, senior, of Bewdley, yeoman 1
4403740 2165823 2165823 defendant Clune Richard chandler 632570 632570 Clune, Richard, of Bewdley, chandler 2
4403765 2165832 2165832 defendant Tacy John, senior yeoman 632570 632570 Tacy, John, senior, of Bewdley, yeoman 0
4403766 2165832 2165832 defendant Clune Richard chandler 632570 632570 Clune, Richard, of Bewdley, chandler 1
4409677 2167836 2167836 defendant Draper John, senior chapman 632570 632570 Draper, John, senior, of Bewdley, chapman 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);