names

24 rows where place_id = 773350

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4439748 2181707 2181707 plaintiff Barker William   773350 773350 Barker, William, of Drynghous, son of William 0
4599537 2231071 2231071 defendant Rouclyf John   773350 773350 Rouclyf, John, of Drynghous 0
4773915 2287820 2287820 defendant Robynson Thomas husbandman 773350 773350 Robynson, Thomas, of Drynghous, husbandman 0
4773916 2287820 2287820 defendant Rouclyff John husbandman 773350 773350 Rouclyff, John, of Drynghous, husbandman 1
4895919 2325388 2325388 defendant Westfyeld Nicholas clerk or gent 773350 773350 Westfyeld, Nicholas, of Drynghous, clerk or gent 0
4940073 2338922 2338922 defendant Chapman Gilbert   773350 773350 Chapman, Gilbert, of Drynghous, cook 1
4940074 2338922 2338922 defendant Gryme John husbandman 773350 773350 Gryme, John, of Drynghous, husbandman 2
4940078 2338923 2338923 defendant Gryme John husbandman 773350 773350 Gryme, John, of Drynghous, husbandman 2
4992529 2354651 2354651 defendant Gryme John husbandman 773350 773350 Gryme, John, of Drynghous, husbandman 0
4992533 2354652 2354652 defendant Gryme John, sen husbandman 773350 773350 Gryme, John, sen, of Drynghous, husbandman 0
5077171 2379675 2379675 defendant Wrygh or Wryght William husbandman 773350 773350 Wrygh or Wryght, William, of Drynghous, husbandman 1
5280295 2439313 2439313 defendant Couper Thomas husbandman 773350 773350 together with Couper, Thomas, of Drynghous, husbandman 1
5280296 2439313 2439313 defendant Halywell John husbandman 773350 773350 Halywell, John, of Drynghous, husbandman 2
5280297 2439313 2439313 defendant Brounflete Thomas husbandman 773350 773350 Brounflete, Thomas, of Drynghous, husbandman 3
5286142 2440956 2440956 defendant Couper Thomas husbandman 773350 773350 Couper, Thomas, of Drynghous, husbandman 0
5286143 2440956 2440956 defendant Halywell John husbandman 773350 773350 Halywell, John, of Drynghous, husbandman 1
5286144 2440956 2440956 defendant Brounflete Thomas husbandman 773350 773350 Brounflete, Thomas, of Drynghous, husbandman 2
5298013 2444431 2444431 defendant Kirkeby John pardoner 773350 773350 Kirkeby, John, of Drynghous, pardoner 3
5340154 2457128 2457128 defendant Fleccher William yeoman 773350 773350 Fleccher, William, of Drynghous, yeoman 3
5533998 2515173 2515173 defendant Jakson John yeoman 773350 773350 Jakson, John, of Drynghous, yeoman 5
5533999 2515173 2515173 defendant Roper Thomas marbler 773350 773350 Roper, Thomas, of Drynghous, marbler 6
5534001 2515173 2515173 defendant Hochynson John laborer 773350 773350 Hochynson, John, of Drynghous, laborer 8
5599621 2534773 2534773 defendant Grange Robert, senior husbandman 773350 773350 Grange, Robert, senior, of Drynghous, husbandman 0
5599622 2534773 2534773 defendant Grange Robert, junior husbandman 773350 773350 Grange, Robert, junior, of Drynghous, 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);