names

37 rows where place_id = 587807

✎ 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
3592493 1865268 1865268 defendant Chudley John husbandman 587807 587807 Chudley, John, of Martyn, husbandman 0
3647435 1909586 1909586 defendant William Richard husbandman 587807 587807 William, Richard, of Martyn, husbandman 0
3656759 1912367 1912367 defendant Hogge Humphrey husbandman 587807 587807 Hogge, Humphrey, of Martyn, husbandman 0
3673212 1917634 1917634 defendant Oxenham William, junior husbandman 587807 587807 Oxenham, William, junior, of Martyn, husbandman 0
3692476 1923829 1923829 defendant Cloydon John husbandman 587807 587807 Cloydon, John, of Martyn, husbandman 1
3692477 1923829 1923829 defendant Toker William smith 587807 587807 Toker, William, of Martyn, smith 2
3692478 1923829 1923829 defendant Wykes John husbandman 587807 587807 Wykes, John, of Martyn, husbandman 3
3692481 1923830 1923830 defendant Toker William smith 587807 587807 Toker, William, of Martyn, smith 1
3692482 1923830 1923830 defendant Wykes John husbandman 587807 587807 Wykes, John, of Martyn, husbandman 2
3778837 1951095 1951095 defendant William Richard butcher 587807 587807 William, Richard, of Martyn, butcher 3
3827130 1966347 1966347 defendant Vanstone John yeoman or butcher 587807 587807 Vanstone, John, of Martyn, yeoman or butcher 0
3873511 1981356 1981356 defendant Pawe Stephen husbandman 587807 587807 Pawe, Stephen, of Martyn, husbandman 0
3873512 1981356 1981356 defendant Pawe William husbandman 587807 587807 Pawe, William, of Martyn, husbandman 1
3921337 1997479 1997479 defendant Pawe Anthony husbandman 587807 587807 Pawe, Anthony, of Martyn, husbandman 0
3980491 2017791 2017791 defendant Salter John yeoman 587807 587807 Salter, John, of Martyn, yeoman 2
4000194 2024837 2024837 plaintiff Gonne Edward yeoman 587807 587807 Gonne, Edward, of Martyn, yeoman 0
4034890 2037154 2037154 defendant Shurte John husbandman 587807 587807 Shurte, John, of Martyn, husbandman 3
4050801 2042723 2042723 defendant Hatche Thomas gent 587807 587807 Hatche, Thomas, of Martyn, gent 0
4140520 2074852 2074852 defendant Beard John husbandman 587807 587807 Beard, John, of Martyn, husbandman 1
4167233 2084042 2084042 defendant Gilbert John gent 587807 587807 Gilbert, John, of Martyn, gent 0
4202816 2096529 2096529 defendant Haydon Robert Wilts, husbandman 587807 587807 Haydon Robert, of Martyn, Wilts, husbandman 1
4218880 2102099 2102099 defendant Tayler John yeoman 587807 587807 Tayler, John, of Martyn, yeoman 0
4282366 2123732 2123732 defendant Parkyn Thomas tailor 587807 587807 Parkyn, Thomas, of Martyn, tailor 0
4282367 2123732 2123732 defendant Smale Edmund husbandman 587807 587807 Smale, Edmund, of Martyn, husbandman 1
4282368 2123732 2123732 defendant Dalbye Robert husbandman 587807 587807 Dalbye, Robert, of Martyn, husbandman 2
4282369 2123732 2123732 defendant Clarke Thomasine widow 587807 587807 Clarke, Thomasine, of Martyn, widow 3
4317070 2136084 2136084 defendant Marrys John husbandman 587807 587807 Marrys, John, of Martyn, husbandman 0
4351783 2147866 2147866 defendant Hill John esq 587807 587807 (Hill, John, of Martyn, esq 3
4367042 2153267 2153267 defendant Storke John yeoman 587807 587807 Storke, John, of Martyn, yeoman 0
4388686 2160849 2160849 defendant Horsey Francis widow 587807 587807 Horsey, Francis, of Martyn, widow 1
4396360 2163357 2163357 defendant Craike Ralph gent 587807 587807 Craike, Ralph, of Martyn, gent 0
4800245 2296254 2296254 defendant Pery John, junior husbandman 587807 587807 Pery, John, junior, of Martyn, husbandman 1
5248834 2429777 2429777 defendant Stokys William   587807 587807 Stokys, William, of Martyn 0
5546887 2519091 2519091 defendant Stowell Humphrey clerk 587807 587807 Stowell, Humphrey, of Martyn, clerk 0
5561076 2523211 2523211 defendant Marlowe George yeoman 587807 587807 Marlowe, George, of Martyn, yeoman 1
5573140 2526696 2526696 defendant Crofte Richard chaplain 587807 587807 Crofte, Richard, of Martyn, chaplain 2
5575828 2527527 2527527 defendant Hakker Robert husbandman 587807 587807 Hakker, Robert, of Martyn, 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);