names

18 rows where place_id = 594500

✎ 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
3616354 1872753 1872753 defendant Hydys John, junior husbandman 594500 594500 Hydys, John, junior, of Clareburgh, husbandman 6
4015833 2030348 2030348 plaintiff Southworth Oliver husbandman 594500 594500 Southworth, Oliver, of Clareburgh, husbandman 0
4477094 2193492 2193492 defendant atte Brigge Roger   594500 594500 atte Brigge, Roger, of Clareburgh 0
4505140 2202140 2202140 defendant Bervyll Robert   594500 594500 Bervyll, Robert, of Clareburgh 0
4505147 2202143 2202143 defendant Bervyll Robert   594500 594500 Bervyll, Robert, of Clareburgh 0
4589692 2228143 2228143 defendant atte Bragge Richard   594500 594500 atte Bragge, Richard, of Clareburgh 5
4631866 2240850 2240850 defendant Aston William de   594500 594500 Aston, William de, of Clareburgh 0
4642172 2243824 2243824 defendant Smyth John   594500 594500 Smyth, John, of Clareburgh, son of Robert 0
4790819 2293218 2293218 defendant Cotyngham William husbandman 594500 594500 Cotyngham, William, of Clareburgh, husbandman 0
4812450 2300006 2300006 defendant Barwell Richard husbandman 594500 594500 Barwell, Richard, of Clareburgh, husbandman 0
4842717 2309260 2309260 defendant Hedon William husbandman 594500 594500 Hedon, William, of Clareburgh, husbandman 1
5069887 2377486 2377486 defendant Clerke Henry husbandman 594500 594500 Clerke, Henry, of Clareburgh, husbandman 2
5214422 2419950 2419950 defendant Colyns Thomas husbandman 594500 594500 Colyns, Thomas, of Clareburgh, husbandman 0
5348865 2459775 2459775 defendant Spycer Richard husbandman 594500 594500 Spycer, Richard, of Clareburgh, husbandman 0
5483274 2499943 2499943 defendant Sotehill Thomas husbandman 594500 594500 Sotehill, Thomas, of Clareburgh, husbandman 0
5542882 2517890 2517890 defendant Banester John gent 594500 594500 Banester, John, of Clareburgh, gent 2
5547624 2519322 2519322 defendant Croweder Henry clerk 594500 594500 Croweder, Henry, of Clareburgh, clerk 0
5593323 2532889 2532889 defendant Whytton James husbandman 594500 594500 Whytton, James, of Clareburgh, 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);