names

35 rows where place_id = 587258

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590925 1864788 1864788 defendant de Bardys Adrian gent 587258 587258 de Bardys, Adrian, of Rammesbury, gent 0
3594044 1865778 1865778 defendant Tayllour Peter yeoman 587258 587258 Tayllour, Peter, of Rammesbury, yeoman 0
3594045 1865778 1865778 defendant Penketh John yeoman 587258 587258 Penketh, John, of Rammesbury, yeoman 1
3594046 1865778 1865778 defendant Saunders Thomas yeoman 587258 587258 Saunders, Thomas, of Rammesbury, yeoman 2
3604075 1868942 1868942 defendant Lone or Love Henry husbandman 587258 587258 Lone or Love, Henry, of Rammesbury, husbandman 2
3604078 1868943 1868943 defendant Lone or Love Henry husbandman 587258 587258 Lone or Love, Henry, of Rammesbury, husbandman 1
3720852 1932816 1932816 defendant Baskerfild John gent 587258 587258 Baskerfild, John, of Rammesbury, gent 0
3720853 1932816 1932816 defendant dawe James yeoman 587258 587258 dawe, James, of Rammesbury, yeoman 1
3720854 1932816 1932816 defendant Dawntry Robert yeoman 587258 587258 Dawntry, Robert, of Rammesbury, yeoman 2
3720855 1932816 1932816 defendant Wheteley Richard yeoman 587258 587258 Wheteley, Richard, of Rammesbury, yeoman 3
3720856 1932816 1932816 defendant Randall John yeoman 587258 587258 Randall, John, of Rammesbury, yeoman 4
3773175 1949316 1949316 defendant Woderove John clerk 587258 587258 Woderove, John, of Rammesbury, clerk 0
3812087 1961691 1961691 defendant Canon Thomas yeoman 587258 587258 Canon, Thomas, of Rammesbury, yeoman 0
4460606 2188375 2188375 defendant Lof John   587258 587258 Lof, John, of Rammesbury 0
4677229 2258496 2258496 defendant Ewayn William husbandman 587258 587258 Ewayn, William, of Rammesbury, husbandman 1
4677231 2258496 2258496 defendant Millward John husbandman 587258 587258 Millward, John, of Rammesbury, husbandman 3
4766957 2285653 2285653 defendant Truman Giles   587258 587258 Truman, Giles, of Rammesbury 0
4826710 2304388 2304388 defendant Soupull John husbandman 587258 587258 Soupull, John, of Rammesbury, husbandman 0
4910453 2329785 2329785 defendant Mildenall John husbandman 587258 587258 Mildenall, John, of Rammesbury, husbandman 0
4910454 2329785 2329785 defendant Spycer Walter husbandman 587258 587258 Spycer, Walter, of Rammesbury, husbandman 1
4910455 2329785 2329785 defendant Mildenall Richard husbandman 587258 587258 Mildenall, Richard, of Rammesbury, husbandman 2
5106478 2388327 2388327 defendant Wenslowe Thomas esq 587258 587258 Wenslowe, Thomas, of Rammesbury, esq 0
5148589 2400713 2400713 defendant Wenslowe Thomas esq 587258 587258 Wenslowe, Thomas, of Rammesbury, esq 0
5256032 2432011 2432011 defendant Mildenale Walter husbandman 587258 587258 Mildenale, Walter, of Rammesbury, husbandman 0
5256033 2432011 2432011 defendant Mildenale William husbandman 587258 587258 together with Mildenale, William, of Rammesbury, husbandman 1
5258511 2432776 2432776 defendant Rosell William husbandman 587258 587258 (Rosell, William, of Rammesbury, husbandman 1
5278259 2438740 2438740 defendant Reynold Margaret widow 587258 587258 Reynold, Margaret, of Rammesbury, widow 1
5333431 2455071 2455071 defendant Mildenhale Robert husbandman 587258 587258 Mildenhale, Robert, of Rammesbury, husbandman 0
5351303 2460503 2460503 defendant York John esq 587258 587258 York, John, of Rammesbury, esq 0
5480422 2499124 2499124 defendant Lyneley or Lyveley Robert yeoman 587258 587258 Lyneley or Lyveley, Robert, of Rammesbury, yeoman 0
5480424 2499124 2499124 defendant Saundrys John husbandman 587258 587258 Saundrys, John, of Rammesbury, husbandman 2
5480427 2499125 2499125 defendant Saunder John   587258 587258 Saunder, John, of Rammesbury 1
5480428 2499125 2499125 defendant Compton John husbandman 587258 587258 Compton, John, of Rammesbury, husbandman 2
5492901 2502787 2502787 defendant Compton John husbandman 587258 587258 Compton, John, of Rammesbury, husbandman 2
5492903 2502787 2502787 defendant Saunder John husbandman 587258 587258 Saunder, John, of Rammesbury, husbandman 4

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