names

55 rows where place_id = 592166

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606810 1869801 1869801 defendant Crowe Christopher yeoman 592166 592166 Crowe, Christopher, of Myleham, yeoman 9
3656290 1912213 1912213 defendant Jameson John yeoman 592166 592166 Jameson, John, of Myleham, yeoman 0
3697068 1925302 1925302 defendant Crowe John clerk 592166 592166 Crowe, John, of Myleham, clerk 0
3715697 1931200 1931200 defendant Capell John butcher 592166 592166 Capell, John, of Myleham, butcher 0
3791852 1955297 1955297 defendant Skerdell Richard husbandman 592166 592166 Skerdell, Richard, of Myleham, husbandman 1
3800127 1957963 1957963 defendant Crowe Thomas yeoman 592166 592166 Crowe, Thomas, of Myleham, yeoman 0
3800818 1958168 1958168 defendant Broun John husbandman 592166 592166 Broun, John, of Myleham, husbandman 3
3800823 1958169 1958169 defendant Palmer Thomas husbandman 592166 592166 Palmer, Thomas, of Myleham, husbandman 1
3800824 1958169 1958169 defendant White William thatcher 592166 592166 White, William, of Myleham, thatcher 2
3800826 1958169 1958169 defendant Broun John husbandman 592166 592166 Broun, John, of Myleham, husbandman 4
3809327 1960799 1960799 defendant Scarndell Richard yeoman 592166 592166 Scarndell, Richard, of Myleham, yeoman 0
3816012 1962908 1962908 defendant Crowe Thomas yeoman 592166 592166 Crowe, Thomas, of Myleham, yeoman 0
3829314 1967053 1967053 plaintiff Crowe Thomas   592166 592166 Crowe, Thomas, of Myleham 0
3833878 1968531 1968531 defendant Wale Clement husbandman 592166 592166 Wale, Clement, of Myleham, husbandman 0
3833879 1968531 1968531 defendant Newby Humphrey tanner 592166 592166 Newby, Humphrey, of Myleham, tanner 1
3849931 1973565 1973565 defendant Wale Clement husbandman 592166 592166 Wale, Clement, of Myleham, husbandman 0
3849932 1973565 1973565 defendant Newby Humphrey tanner 592166 592166 Newby, Humphrey, of Myleham, tanner 1
3927493 1999540 1999540 defendant Crowe Thomas yeoman 592166 592166 Crowe, Thomas, of Myleham, yeoman 0
3947854 2006313 2006313 plaintiff Cooke Robert (legal representative) 592166 592166 Cooke, Robert, of Myleham, gent, executors of 0
4014942 2030059 2030059 defendant Shynglewood William carpenter 592166 592166 Shynglewood, William, of Myleham, carpenter 1
4015340 2030180 2030180 defendant Palmer Nicholas husbandman 592166 592166 Palmer, Nicholas, of Myleham, husbandman 0
4021324 2032350 2032350 defendant Wylkynson George clerk 592166 592166 Wylkynson, George, of Myleham, clerk 3
4056023 2044536 2044536 defendant Peerson John yeoman 592166 592166 Peerson, John, of Myleham, yeoman 0
4061016 2046348 2046348 defendant Thysle Nicholas butcher 592166 592166 Thysle, Nicholas, of Myleham, butcher 1
4068435 2049009 2049009 plaintiff Knyght Robert yeoman 592166 592166 Knyght, Robert, of Myleham, yeoman 0
4068436 2049009 2049009 defendant Thyrlo Nicholas husbandman 592166 592166 Thyrlo, Nicholas, of Myleham, husbandman 0
4090502 2056886 2056886 defendant Jary Thomas husbandman 592166 592166 Jary, Thomas, of Myleham, husbandman 1
4090503 2056886 2056886 defendant Halman Edmund husbandman 592166 592166 Halman, Edmund, of Myleham, husbandman 2
4118390 2066868 2066868 defendant Bowle William carpenter 592166 592166 Bowle, William, of Myleham, carpenter 0
4207755 2098276 2098276 defendant Constable Richard yeoman 592166 592166 Constable, Richard, of Myleham, yeoman 0
4994161 2355128 2355128 defendant Brykwode Robert yeoman 592166 592166 Brykwode, Robert, of Myleham, yeoman 0
5046258 2370513 2370513 defendant Matelask John husbandman 592166 592166 Matelask, John, of Myleham, husbandman 0
5264605 2434683 2434683 defendant Brunham Nicholas husbandman 592166 592166 Brunham, Nicholas, of Myleham, husbandman 0
5325837 2452811 2452811 defendant Scarlet Richard husbandman 592166 592166 Scarlet, Richard, of Myleham, husbandman 0
5344696 2458516 2458516 defendant Skarlet Richard yeoman 592166 592166 Skarlet, Richard, of Myleham, yeoman 1
5352530 2460883 2460883 defendant Harryes Thomas husbandman 592166 592166 Harryes, Thomas, of Myleham, husbandman 1
5352531 2460883 2460883 defendant Roper William husbandman 592166 592166 Roper, William, of Myleham, husbandman 2
5377955 2468685 2468685 defendant Stede Peter husbandman 592166 592166 Stede, Peter, of Myleham, husbandman 0
5381411 2469743 2469743 defendant Scarlet Richard yeoman 592166 592166 Scarlet, Richard, of Myleham, yeoman 3
5398939 2474766 2474766 defendant Booxton Robert yeoman 592166 592166 Booxton, Robert, of Myleham, yeoman 0
5398940 2474766 2474766 defendant Hunt Thomas yeoman 592166 592166 Hunt, Thomas, of Myleham, yeoman 1
5412050 2478557 2478557 defendant B_ Robert yeoman 592166 592166 B_, Robert, of Myleham, yeoman 0
5412051 2478557 2478557 defendant Hunt Thomas yeoman 592166 592166 Hunt, Thomas, of Myleham, yeoman 1
5426627 2482912 2482912 defendant Booxton Robert yeoman 592166 592166 Booxton, Robert, of Myleham, yeoman 0
5426628 2482912 2482912 defendant Hunt Thomas yeoman 592166 592166 Hunt, Thomas, of Myleham, yeoman 1
5426633 2482913 2482913 defendant Booxton Robert yeoman 592166 592166 Booxton, Robert, of Myleham, yeoman 0
5426638 2482914 2482914 defendant Hunt Thomas yeoman 592166 592166 Hunt, Thomas, of Myleham, yeoman 0
5447385 2489109 2489109 defendant Ketylston Thomas   592166 592166 Ketylston, Thomas, of Myleham, court holder or parish clerk 8
5469272 2495738 2495738 defendant Ketelston Thomas yeoman 592166 592166 Ketelston, Thomas, of Myleham, yeoman 10
5473324 2496984 2496984 defendant Stede Peter husbandman 592166 592166 Stede, Peter, of Myleham, husbandman 0
5480597 2499166 2499166 defendant ketelston Thomas yeoman 592166 592166 ketelston, Thomas, of Myleham, yeoman 10
5490352 2502007 2502007 defendant Smyth Richard husbandman 592166 592166 Smyth, Richard, of Myleham, husbandman 0
5494960 2503390 2503390 defendant Scarlet Richard yeoman 592166 592166 Scarlet, Richard, of Myleham, yeoman 3
5499712 2504856 2504856 defendant Sadeler Robert husbandman 592166 592166 Sadeler, Robert, of Myleham, husbandman 0
5561697 2523409 2523409 defendant Fyssher Adam husbandman 592166 592166 Fyssher, Adam, of Myleham, 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);