names

27 rows where place_id = 592987

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609787 1870730 1870730 defendant Arche Richard   592987 592987 Arche, Richard, of Chaddesley 0
3613026 1871725 1871725 defendant Arche Richard   592987 592987 Arche, Richard, of Chaddesley 0
3701695 1926773 1926773 defendant Smyth Richard laborer 592987 592987 Smyth, Richard, of Chaddesley, laborer 0
3701696 1926773 1926773 defendant Smyth Katherine widow 592987 592987 Smyth, Katherine, of Chaddesley, widow 1
3713956 1930663 1930663 defendant Cooke William butcher 592987 592987 Cooke, William, of Chaddesley, butcher 0
3810304 1961113 1961113 defendant Smyth William smith 592987 592987 Smyth, William, of Chaddesley, smith 0
3848276 1973031 1973031 defendant Newman William husbandman 592987 592987 Newman, William, of Chaddesley, husbandman 0
3886143 1985617 1985617 defendant Smyth William husbandman 592987 592987 Smyth, William, of Chaddesley, husbandman 1
3900267 1990319 1990319 defendant Newey John   592987 592987 Newey, John, of Chaddesley, scythe smith 0
3900268 1990319 1990319 defendant Newey Thomas   592987 592987 Newey, Thomas, of Chaddesley, scythe smith 1
3929361 2000165 2000165 defendant Beche Richard husbandman 592987 592987 Beche, Richard, of Chaddesley, husbandman 0
3935741 2002262 2002262 defendant Brettyll John tailor 592987 592987 Brettyll, John, of Chaddesley, tailor 2
4008941 2027961 2027961 defendant Westwood Simon   592987 592987 Westwood, Simon, of Chaddesley, scythe smith 0
4060611 2046198 2046198 defendant Wall John husbandman 592987 592987 Wall, John, of Chaddesley, husbandman 0
4070827 2049863 2049863 defendant Freman Simon smith 592987 592987 Freman, Simon, of Chaddesley, smith 0
4091645 2057305 2057305 defendant Suche Thomas tailor 592987 592987 Suche, Thomas, of Chaddesley, tailor 1
4560181 2219130 2219130 defendant Malverne William   592987 592987 Malverne, William, of Chaddesley 0
4645580 2244776 2244776 defendant Bacon John   592987 592987 Bacon, John, of Chaddesley 3
4811611 2299739 2299739 defendant Bernard John, junior laborer 592987 592987 Bernard, John, junior, of Chaddesley, laborer 1
4971591 2348432 2348432 defendant Stokes William husbandman 592987 592987 Stokes, William, of Chaddesley, husbandman 4
4991668 2354391 2354391 defendant Malvern Nicholas husbandman 592987 592987 Malvern, Nicholas, of chaddesley, husbandman 1
5380866 2469583 2469583 defendant Symondes Walter husbandman 592987 592987 Symondes, Walter, of Chaddesley, husbandman 1
5384089 2470538 2470538 defendant Symondes Walter   592987 592987 Symondes, Walter, of Chaddesley 1
5532815 2514811 2514811 defendant Smyth Richard smith 592987 592987 Smyth, Richard, of Chaddesley, smith 1
5532816 2514811 2514811 defendant Clerke Richard husbandman 592987 592987 Clerke, Richard, of Chaddesley, husbandman 2
5544937 2518524 2518524 defendant Warton Henry yeoman 592987 592987 Warton, Henry, of Chaddesley, yeoman 0
5590588 2532026 2532026 defendant Smyth Thomas smith 592987 592987 Smyth, Thomas, of Chaddesley, smith 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);