names

23 rows where place_id = 610764

✎ 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
3685035 1921462 1921462 defendant Wykeham John weaver 610764 610764 Wykeham, John, of Haukesbury, weaver 1
3695137 1924697 1924697 defendant Player Thomas husbandman 610764 610764 Player, Thomas, of Haukesbury, husbandman 0
3695494 1924813 1924813 defendant Webbe Thomas clothier 610764 610764 Webbe, Thomas, of Haukesbury, clothier 0
3788879 1954329 1954329 defendant Pycchar Thomas yeoman 610764 610764 Pycchar, Thomas, of Haukesbury, yeoman 0
3788881 1954330 1954330 defendant Pycher Thomas yeoman 610764 610764 Pycher, Thomas, of Haukesbury, yeoman 0
3820563 1964314 1964314 defendant Camme John husbandman 610764 610764 Camme, John, of Haukesbury, husbandman 0
4493391 2198639 2198639 defendant Bruwe Thomas   610764 610764 Bruwe, Thomas, of Haukesbury, perpetual vicar 0
4546834 2214937 2214937 plaintiff Bruet Thomas   610764 610764 Bruet, Thomas, of Haukesbury, vicar 0
4575655 2223898 2223898 defendant Tournour William   610764 610764 Tournour, William, of Haukesbury 0
4576452 2224150 2224150 plaintiff Bruet Thomas   610764 610764 Bruet, Thomas, of Haukesbury, vicar 0
4576458 2224152 2224152 defendant Wodeward John   610764 610764 Wodeward, John, of Haukesbury 0
4805761 2298011 2298011 defendant Trygoll John laborer 610764 610764 Trygoll, John, of Haukesbury, laborer 1
4805775 2298012 2298012 defendant Trygoll John laborer 610764 610764 Trygoll, John, of Haukesbury, laborer 5
4877703 2319987 2319987 defendant Salford John chaplain 610764 610764 Salford, John, of Haukesbury, or of Spellesbury, chaplain 0
4971108 2348302 2348302 defendant Cloune John husbandman 610764 610764 Cloune, John, of Haukesbury, husbandman 0
4971114 2348303 2348303 defendant Cloune John husbandman 610764 610764 Cloune, John, of Haukesbury, husbandman 0
4991292 2354282 2354282 defendant Wynbaude Thomas gent 610764 610764 Wynbaude, Thomas, of Haukesbury, gent 0
5011362 2360184 2360184 defendant Clowne John butcher 610764 610764 Clowne, John, of Haukesbury, butcher 2
5280608 2439401 2439401 defendant Foster Thomas yeoman 610764 610764 Foster, Thomas, of Haukesbury, yeoman 1
5342707 2457919 2457919 defendant Shepard John husbandman 610764 610764 Shepard, John, of Haukesbury, husbandman 2
5359879 2463130 2463130 defendant Cardygan John cordwainer 610764 610764 Cardygan, John, of Haukesbury, cordwainer 2
5535430 2515609 2515609 defendant Styff John husbandman 610764 610764 Styff, John, of Haukesbury, husbandman 1
5535433 2515610 2515610 defendant Styff John husbandman 610764 610764 Styff, John, of Haukesbury, husbandman 1

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