names

37 rows where place_id = 588878

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595884 1866348 1866348 defendant Chambre Robert butcher 588878 588878 Chambre, Robert, of Helperby, butcher 1
3906892 1992592 1992592 defendant Horneby William yeoman 588878 588878 Horneby, William, of Helperby, yeoman 0
4354168 2148686 2148686 defendant Banck Thomas husbandman 588878 588878 Banck, Thomas, of Helperby, husbandman 0
4451067 2185298 2185298 defendant Golt Agatha   588878 588878 Golt, Agatha, of Helperby 2
4478119 2193830 2193830 defendant Walker Gilbert   588878 588878 Walker, Gilbert, of Helperby 3
4497228 2199785 2199785 defendant Haukeswell John   588878 588878 Haukeswell, John, of Helperby 2
4499522 2200497 2200497 plaintiff Haukeswell John   588878 588878 Haukeswell, John, of Helperby 0
4504554 2201981 2201981 plaintiff Salisbury John de   588878 588878 Salisbury, John de, of Helperby 0
4565197 2220688 2220688 defendant Syr Thomas   588878 588878 Syr, Thomas, of Helperby 0
4565198 2220688 2220688 defendant Syr John   588878 588878 Syr, John, of Helperby 1
4602777 2232083 2232083 defendant del Howe John   588878 588878 del Howe, John, of Helperby 5
4631529 2240752 2240752 defendant Haukeswell John   588878 588878 Haukeswell, John, of Helperby 1
4664631 2250416 2250416 defendant Hawkeswell John esq 588878 588878 Hawkeswell, John, of Helperby, esq 0
4673425 2257326 2257326 defendant Davyson Adam husbandman 588878 588878 Davyson, Adam, of Helperby, husbandman 1
4728264 2274084 2274084 defendant Howeson Thomas husbandman 588878 588878 Howeson, Thomas, of Helperby, husbandman 3
4732410 2275311 2275311 defendant Hawekeswell John esq 588878 588878 Hawekeswell, John, of Helperby, esq 5
4735170 2276146 2276146 defendant Watton William chaplain 588878 588878 Watton, William, of Helperby, chaplain 0
4738743 2277205 2277205 defendant Howesson Thomas husbandman 588878 588878 Howesson, Thomas, of Helperby, husbandman 0
4739572 2277451 2277451 defendant Laton John husbandman 588878 588878 Laton, John, of Helperby, husbandman 2
4748533 2280073 2280073 defendant Haukeswell John gent 588878 588878 Haukeswell, John, of Helperby, gent 0
4753994 2281633 2281633 defendant Howeson Thomas husbandman 588878 588878 Howeson, Thomas, of Helperby, husbandman 0
4783264 2290785 2290785 defendant Haweson Thomas husbandman 588878 588878 Haweson, Thomas, of Helperby, husbandman 0
4783265 2290785 2290785 defendant Wakefeld John husbandman 588878 588878 Wakefeld, John, of Helperby, husbandman 1
4783266 2290785 2290785 defendant Danyson or Davyson Adam husbandman 588878 588878 Danyson or Davyson, Adam, of Helperby, husbandman 2
4789497 2292782 2292782 defendant Howeson Thomas husbandman 588878 588878 Howeson, Thomas, of Helperby, husbandman 0
4792045 2293613 2293613 defendant Haukeswell John gent 588878 588878 Haukeswell, John, of Helperby, gent 0
4854448 2312785 2312785 defendant Douse John husbandman 588878 588878 Douse, John, of Helperby, husbandman 1
4958052 2344374 2344374 defendant Totty John yeoman 588878 588878 Totty, John, of Helperby, yeoman 0
5012522 2360506 2360506 defendant Yorke Robert husbandman 588878 588878 Yorke, Robert, of Helperby, husbandman 2
5091505 2383907 2383907 defendant Atkynson William chaplain 588878 588878 Atkynson, William, of Helperby, chaplain 0
5345188 2458664 2458664 defendant Chapman Thomas yeoman 588878 588878 Chapman, Thomas, of Helperby, yeoman 0
5385645 2470966 2470966 defendant Warde Thomas husbandman 588878 588878 Warde, Thomas, of Helperby, husbandman 0
5385647 2470966 2470966 defendant Donne William husbandman 588878 588878 Donne, William, of Helperby, husbandman 2
5385648 2470966 2470966 defendant Conyng Robert husbandman 588878 588878 Conyng, Robert, of Helperby, husbandman 3
5385649 2470966 2470966 defendant Bauke John husbandman 588878 588878 Bauke, John, of Helperby, husbandman 4
5385651 2470966 2470966 defendant S_ William husbandman 588878 588878 S_, William, of Helperby, husbandman 6
5627005 2552417 2552417 defendant de Neweton John clerk 588878 588878 de Neweton, John, of Helperby, clerk 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);