names

37 rows where place_id = 608363

✎ 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
3673372 1917689 1917689 defendant Anabyll John husbandman 608363 608363 Anabyll, John, of Hyston, husbandman 1
3714156 1930727 1930727 defendant Busshe William carpenter 608363 608363 Busshe, William, of Hyston, carpenter 0
3916176 1995795 1995795 defendant Bumsted William husbandman 608363 608363 Bumsted, William, of Hyston, husbandman 0
3916178 1995796 1995796 defendant Favell Thomas tailor 608363 608363 Favell, Thomas, of Hyston, tailor 0
3916179 1995796 1995796 defendant Brumsted William husbandman 608363 608363 Brumsted, William, of Hyston, husbandman 1
3916180 1995796 1995796 defendant Lome Richard husbandman 608363 608363 Lome, Richard, of Hyston, husbandman 2
3916181 1995796 1995796 defendant Lawrens William husbandman 608363 608363 Lawrens, William, of Hyston, husbandman 3
3916183 1995797 1995797 defendant Flavell Thomas tailor 608363 608363 Flavell, Thomas, of Hyston, tailor 0
3916185 1995798 1995798 defendant Lawrence William husbandman 608363 608363 Lawrence, William, of Hyston, husbandman 0
4016794 2030704 2030704 defendant Bowyer John   608363 608363 Bowyer, John, of Hyston, esq, administrarix of 0
4018214 2031238 2031238 plaintiff Turtle Thomas laborer 608363 608363 Turtle, Thomas, of Hyston, laborer 0
4018215 2031238 2031238 defendant Atkyn Edmund husbandman 608363 608363 Atkyn, Edmund, of Hyston, husbandman 0
4046801 2041310 2041310 defendant Wyneder or Wyveder Christopher smith 608363 608363 Wyneder or Wyveder, Christopher, of Hyston, smith 2
4096390 2059039 2059039 defendant Cockerell John yeoman 608363 608363 Cockerell, John, of Hyston, yeoman, Tedmont, Humphrey, of Marche, Isle of Ely, yeoman 2
4139551 2074507 2074507 defendant Harryson Peter innholder 608363 608363 Harryson, Peter, of Hyston, yeoman, or of Cambridge, innholder 0
4273404 2120665 2120665 defendant Banckys Thomas husbandman 608363 608363 Banckys, Thomas, of Hyston, husbandman 0
4273405 2120665 2120665 defendant Grigge Edmund husbandman 608363 608363 Grigge, Edmund, of Hyston, husbandman 1
4273407 2120666 2120666 defendant Banckys Thomas husbandman 608363 608363 Banckys, Thomas, of Hyston, husbandman 0
4273408 2120666 2120666 defendant Grigge Edmund husbandman 608363 608363 Grigge, Edmund, of Hyston, husbandman 1
4464902 2189694 2189694 defendant Hervy John   608363 608363 Hervy, John, of Hyston 0
4472830 2192176 2192176 defendant Reynald John   608363 608363 Reynald, John, of Hyston 0
4477539 2193644 2193644 plaintiff Gybbe John   608363 608363 Gybbe, John, of Hyston, on his own account 0
4593581 2229267 2229267 plaintiff Pechel John (legal representative) 608363 608363 Pechel, John, of Hyston, parson of St Andrew's church, executors of 0
4593587 2229268 2229268 plaintiff Pechel John (legal representative) 608363 608363 Pechel, John, of Hyston, parson of St Andrew's church, executors of 0
4778761 2289332 2289332 defendant Smyth John husbandman 608363 608363 Smyth, John, of Hyston, husbandman 3
4789621 2292824 2292824 defendant Ferrour or Smith Nicholas husbandman 608363 608363 Ferrour or Smith, Nicholas, of Hyston, husbandman 0
4789622 2292824 2292824 defendant Muncy Robert husbandman 608363 608363 Muncy, Robert, of Hyston, husbandman 1
4881482 2321110 2321110 defendant Smyth John husbandman 608363 608363 Smyth, John, of Hyston, husbandman 0
5143894 2399354 2399354 defendant Gylle Ralph clerk 608363 608363 Gylle, Ralph, of Hyston, clerk 2
5164935 2405481 2405481 defendant Gylle Ralph clerk 608363 608363 Gylle, Ralph, of Hyston, clerk 2
5178527 2409432 2409432 defendant Gylle Ralph clerk 608363 608363 Gylle, Ralph, of Hyston, clerk 2
5282105 2439840 2439840 defendant Hardyst William husbandman 608363 608363 Hardyst, William, of Hyston, husbandman 0
5282112 2439841 2439841 defendant Hardist William husbandman 608363 608363 Hardist, William,of Hyston, husbandman 1
5282120 2439843 2439843 defendant Haylys Edward husbandman 608363 608363 Haylys, Edward, of Hyston, husbandman 0
5282121 2439843 2439843 defendant Hardyst William husbandman 608363 608363 Hardyst, William,of Hyston, husbandman 1
5420995 2481208 2481208 defendant Munsy William husbandman 608363 608363 Munsy, William, of Hyston, husbandman 2
5440459 2487048 2487048 defendant Munsy William husbandman 608363 608363 Munsy, William, of Hyston, husbandman 2

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