names

31 rows where place_id = 593533

✎ 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
3612281 1871475 1871475 defendant Hardwyll William husbandman 593533 593533 Hardwyll, William, of Wynscombe, husbandman 0
3612378 1871500 1871500 defendant Balampton John husbandman 593533 593533 Balampton, John, of Wynscombe, husbandman 0
3686921 1922074 1922074 defendant Ben- Deaman husbandman 593533 593533 Ben-, Deaman, of Wynscombe, husbandman 2
3844852 1971934 1971934 defendant Urche William husbandman 593533 593533 Urche, William, of Wynscombe, husbandman 1
3900669 1990453 1990453 defendant Carsleght John clerk 593533 593533 Carsleght, John, of Wynscombe, clerk 2
3912117 1994377 1994377 defendant Stele Stephen husbandman 593533 593533 Stele, Stephen, of Wynscombe, husbandman 0
3966085 2012760 2012760 defendant Hupper John husbandman 593533 593533 Hupper, John, of Wynscombe, husbandman 1
3972269 2014865 2014865 defendant Smyth William smith 593533 593533 Smyth, William, of Wynscombe, smith 0
4006566 2027127 2027127 defendant Hopper John husbandman 593533 593533 Hopper, John, of Wynscombe, husbandman 0
4148512 2077607 2077607 defendant Smyth William husbandman 593533 593533 Smyth, William, of Wynscombe, husbandman 3
4174471 2086538 2086538 defendant Coxe Robert, junior husbandman 593533 593533 Coxe, Robert, junior, of Wynscombe, husbandman 2
4174475 2086539 2086539 defendant Coxe Robert, junior husbandman 593533 593533 Coxe, Robert, junior, of Wynscombe, husbandman 2
4179612 2088343 2088343 defendant Hoper John husbandman 593533 593533 Hoper, John, of Wynscombe, husbandman 2
4179617 2088344 2088344 defendant Hoper John husbandman 593533 593533 Hoper, John, of Wynscombe, husbandman 2
4185684 2090496 2090496 defendant Hawkyns William husbandman 593533 593533 Hawkyns, William, of Wynscombe, husbandman 0
4185685 2090496 2090496 defendant Bynsham John husbandman 593533 593533 Bynsham, John, of Wynscombe, husbandman 1
4193789 2093399 2093399 defendant Payne George gent 593533 593533 Payne, George, of Wynscombe, gent 1
4307754 2132851 2132851 defendant Lubbyn Richard husbandman 593533 593533 Lubbyn, Richard, of Wynscombe, husbandman 0
4656836 2248032 2248032 defendant Marys William husbandman 593533 593533 Marys, William, of Wynscombe, husbandman 1
4656839 2248033 2248033 defendant Marys William husbandman 593533 593533 Marys, William, of Wynscombe, husbandman 1
4723994 2272803 2272803 defendant Dogmersfeld William husbandman 593533 593533 Dogmersfeld, William, of Wynscombe, husbandman 0
4802963 2297112 2297112 defendant Yale Robert laborer 593533 593533 Yale, Robert, of Wynscombe, laborer 2
4818096 2301734 2301734 defendant Godegrome Thomas husbandman 593533 593533 Godegrome, Thomas, of Wynscombe, husbandman 0
4858585 2314061 2314061 defendant Tyler Robert helyer or roofer 593533 593533 Tyler, Robert, of Wynscombe, helyer or roofer 0
4858586 2314061 2314061 defendant Tyler Walter helyer or roofer 593533 593533 Tyler, Walter, of Wynscombe, helyer or roofer 1
4894424 2324930 2324930 defendant Webbe Nicholas weaver 593533 593533 Webbe, Nicholas, of Wynscombe, weaver 2
4894425 2324930 2324930 defendant Reyman alias Martyn Henry husbandman 593533 593533 Reyman alias Martyn, Henry, of Wynscombe, husbandman 3
5201458 2416184 2416184 defendant Gylys John husbandman 593533 593533 Gylys, John, of Wynscombe, husbandman 4
5274097 2437501 2437501 defendant Beksy John mariner 593533 593533 Beksy, John, of Wynscombe, mariner 3
5320908 2451341 2451341 defendant Gyles John husbandman 593533 593533 Gyles, John, of Wynscombe, husbandman 1
5364225 2464469 2464469 defendant Haukyns Richard husbandman 593533 593533 Haukyns, Richard, of Wynscombe, 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);