names

28 rows where place_id = 653045

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3927062 1999390 1999390 defendant Paslowe William gent 653045 653045 Paslowe, William, of Bewdley, Worcs, gent 0
3929301 2000145 2000145 defendant Sheperd Richard chapman 653045 653045 Sheperd, Richard, of Bewdley, Worcs, chapman 0
3929303 2000146 2000146 defendant Sheperd Richard chapman 653045 653045 Sheperd, Richard, of Bewdley, Worcs, chapman 0
3935762 2002268 2002268 defendant Sowthall Roger yeoman 653045 653045 Sowthall, Roger, of Bewdley, Worcs, yeoman 1
3937210 2002776 2002776 defendant Gye William draper 653045 653045 Gye, William, of Bewdley, Worcs, draper 0
3953052 2008131 2008131 defendant Smyth Ralph chapman 653045 653045 Smyth, Ralph, of Bewdley, Worcs, chapman 2
4046873 2041334 2041334 defendant Panner Tristram   653045 653045 Panner, Tristram, of bewdley, Worcs, "trowman" 0
4046882 2041338 2041338 defendant Palmere Tristram yeoman 653045 653045 Palmere, Tristram, of Bewdley, Worcs, yeoman 0
4051691 2043025 2043025 defendant Redferne Richard vintner 653045 653045 Redferne, Richard, of Bewdley, Worcs, vintner 1
4051698 2043026 2043026 defendant Redferne Richard vintner 653045 653045 Redferne, Richard, of Bewdley, Worcs, vintner 1
4147192 2077157 2077157 defendant Tyler William chapman 653045 653045 Tyler, William, of Bewdley, Worcs, chapman 2
4148815 2077704 2077704 defendant Symons William tailor 653045 653045 Symons, William, of Bewdley, Worcs, tailor 2
4150937 2078458 2078458 defendant Lonne or Loune Richard chapman 653045 653045 Lonne or Loune, Richard, of Bewdley, Worcs, chapman 0
4153907 2079461 2079461 defendant Wood Richard capper 653045 653045 Wood, Richard, of Bewdley, Worcs, capper 0
4177964 2087766 2087766 defendant Nicols John capper 653045 653045 Nicols, John, of Bewdley, Worcs, capper 1
4261489 2116805 2116805 defendant Dewe Christopher gent 653045 653045 Dewe, Christopher, of Bewdley, Worcs, gent 2
4261527 2116818 2116818 defendant Dewe Christopher gent 653045 653045 Dewe, Christopher, of Bewdley, Worcs, gent 1
4267079 2118628 2118628 defendant Hamond Humphrey chapman 653045 653045 Hamond, Humphrey, of Bewdley, Worcs, chapman 0
4295690 2128545 2128545 defendant Jackson Thomas capper 653045 653045 Jackson, Thomas, of Bewdley, Worcs, capper 0
4304157 2131586 2131586 defendant Jackon Thomas capper 653045 653045 Jackon, Thomas, of Bewdley, Worcs, capper 0
4306028 2132247 2132247 plaintiff Meresen John dyer 653045 653045 Meresen, John, of Bewdley, Worcs, dyer 0
4326121 2139106 2139106 defendant Hamand Humphrey mercer 653045 653045 Hamand, Humphrey, of Bewdley, Worcs, mercer 0
4326526 2139232 2139232 defendant Rushbery William capper 653045 653045 Rushbery, William, of Bewdley, Worcs, capper 2
4367451 2153412 2153412 defendant Draper John, junior mercer 653045 653045 Draper, John, junior, of Bewdley, Worcs, mercer 0
4384956 2159659 2159659 defendant Woodhall John carrier 653045 653045 Woodhall, John, of Bewdley, Worcs, carrier 0
4391263 2161695 2161695 defendant Browne John, junior yeoman 653045 653045 Browne, John, junior, of Bewdley, Worcs, yeoman 0
4408362 2167371 2167371 defendant Draper John draper 653045 653045 Draper, John, of Bewdley, Worcs, draper 0
5345701 2458805 2458805 defendant Lincoln John dyer 653045 653045 Lincoln, John, of Bewdley, Worcs, dyer 6

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