names

65 rows where place_id = 599060

✎ 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
3635023 1905753 1905753 defendant Dyker William   599060 599060 Dyker, William, of Russheton, groom 0
3635024 1905753 1905753 defendant Ball Alice widow 599060 599060 Ball, Alice, of Russheton, widow 1
3657996 1912753 1912753 defendant Bradoke John husbandman 599060 599060 Bradoke, John, of Russheton, husbandman 0
3770853 1948572 1948572 defendant Malen or Maben Thomas husbandman 599060 599060 Malen or Maben, Thomas, of Russheton, husbandman 0
3815554 1962781 1962781 defendant Wall Edward yeoman 599060 599060 Wall, Edward, of Russheton, yeoman 0
3871214 1980626 1980626 defendant Edmonde Matilda widow 599060 599060 Edmonde, Matilda, of Russheton, widow 0
3936858 2002662 2002662 defendant Tresham Thomas   599060 599060 Tresham, Thomas, of Russheton, knight 0
4531516 2210136 2210136 plaintiff Penythorn John   599060 599060 Penythorn, John, of Russheton 0
4569418 2222026 2222026 defendant Oulemere William   599060 599060 Oulemere, William, of Russheton 0
4569419 2222026 2222026 defendant Madyut Richard   599060 599060 Madyut, Richard, of Russheton 1
4576074 2224013 2224013 defendant Lolle John   599060 599060 Lolle, John, of Russheton 0
4596574 2230165 2230165 defendant Lolle John   599060 599060 Lolle, John, of Russheton 0
4646062 2244922 2244922 defendant Langton John   599060 599060 Langton, John, of Russheton 4
4686552 2261402 2261402 plaintiff Smyth Peter   599060 599060 Smyth, Peter, of Russheton 0
4752401 2281161 2281161 defendant Penythorn William woolman 599060 599060 Penythorn, William, of Russheton, woolman 0
4758915 2283139 2283139 defendant Tyler Philip husbandman 599060 599060 Tyler, Philip, of Russheton, husbandman 0
4767970 2285953 2285953 defendant Ivedon Thomas husbandman 599060 599060 Ivedon, Thomas, of Russheton, husbandman 0
4773350 2287638 2287638 defendant Penythorn William   599060 599060 Penythorn, William, of Russheton, wool man 0
4781040 2290078 2290078 defendant Tyler Philip laborer 599060 599060 Tyler, Philip, of Russheton, laborer 0
4805029 2297778 2297778 defendant Burghton Richard smith 599060 599060 Burghton, Richard, of Russheton Spencer, smith 0
4806183 2298138 2298138 defendant Kyng William husbandman 599060 599060 Kyng, William, of Russheton, husbandman 0
4806184 2298138 2298138 defendant Peke Robert husbandman 599060 599060 Peke, Robert, of Russheton, husbandman 1
4819256 2302101 2302101 plaintiff Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4819258 2302102 2302102 plaintiff Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4819260 2302103 2302103 plaintiff Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4819263 2302104 2302104 plaintiff Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4819266 2302105 2302105 plaintiff Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4819269 2302106 2302106 plaintiff Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4895423 2325231 2325231 defendant Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4895429 2325234 2325234 defendant Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4895431 2325235 2325235 defendant Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4897608 2325915 2325915 defendant Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4900211 2326692 2326692 defendant Penythorn William merchant 599060 599060 Penythorn, William, of Russheton, merchant 0
4912329 2330357 2330357 defendant Lovet Thomas gent 599060 599060 Lovet, Thomas, of Russheton, gent 0
4912334 2330359 2330359 defendant Lovet Thomas gent 599060 599060 Lovet, Thomas, of Russheton, gent 0
4925431 2334389 2334389 plaintiff Penythorn William, senior   599060 599060 Penythorn, William, senior, of Russheton 0
4925433 2334389 2334389 defendant Alderman Thomas husbandman 599060 599060 Alderman, Thomas, of Russheton, husbandman 1
4925435 2334389 2334389 defendant Stone William tailor 599060 599060 Stone, William, of Russheton, tailor 3
4947842 2341306 2341306 defendant Okeham William husbandman 599060 599060 Okeham, William, of Russheton, husbandman 0
4947843 2341307 2341307 plaintiff Lovet Thomas gent 599060 599060 Lovet, Thomas, of Russheton, gent 0
4983635 2352028 2352028 defendant Weldon Thomas gent 599060 599060 Weldon, Thomas, of Russheton, gent 0
5003134 2357821 2357821 defendant Croxton Simon   599060 599060 Croxton, Simon, of Russheton, servant 0
5010911 2360048 2360048 defendant Elyngham Richard gent 599060 599060 Elyngham, Richard, of Russheton, gent 5
5027720 2364982 2364982 defendant Harryes John husbandman 599060 599060 Harryes, John, of Russheton, husbandman 0
5037781 2367927 2367927 defendant Penythorn William gent 599060 599060 Penythorn, William, of Russheton, gent 0
5043700 2369736 2369736 plaintiff Gage John esq 599060 599060 Gage, John, of Russheton, esq 0
5095839 2385211 2385211 plaintiff Southern John   599060 599060 Southern, John, of Russheton 0
5104315 2387685 2387685 defendant Merbury John esq 599060 599060 (Merbury, John, of Russheton, esq 1
5141995 2398778 2398778 defendant Spanne Thomas yeoman 599060 599060 Spanne, Thomas, of Russheton, yeoman 1
5163121 2404942 2404942 defendant Spanne Thomas yeoman 599060 599060 Spanne, Thomas, of Russheton, yeoman 1
5237381 2426518 2426518 plaintiff Gage John esq 599060 599060 Gage, John, of Russheton, esq 0
5263150 2434219 2434219 defendant Harrys Thomas   599060 599060 Harrys, Thomas, of Russheton, yeoman, son of Harrys, John 0
5307542 2447268 2447268 defendant Taillour Robert tailor 599060 599060 Taillour, Robert, of Russheton, tailor 1
5307543 2447268 2447268 defendant Brant Nicholas chaplain 599060 599060 Brant, Nicholas, of Russheton, chaplain 2
5326448 2452997 2452997 defendant Morteyn Robert chapman 599060 599060 Morteyn, Robert, of Russheton, chapman 0
5326454 2452998 2452998 defendant Morteyn Robert chapman 599060 599060 Morteyn, Robert, of Russheton, chapman 0
5338849 2456725 2456725 defendant Brant Nicholas chaplain 599060 599060 Brant, Nicholas, of Russheton, chaplain 1
5422615 2481716 2481716 defendant Balle John husbandman 599060 599060 Balle, John, of Russheton, husbandman 0
5423674 2482045 2482045 defendant Bysshoptre Thomas gent 599060 599060 Bysshoptre, Thomas, of Russheton, gent 0
5442218 2487594 2487594 defendant Balle John husbandman 599060 599060 Balle, John, of Russheton, husbandman 0
5514819 2509478 2509478 defendant Hamerton William painter 599060 599060 Hamerton, William, of Russheton, painter 0
5514821 2509479 2509479 defendant Hamerton William painter 599060 599060 Hamerton, William, of Russheton, painter 0
5590930 2532139 2532139 defendant Harrys Thomas husbandman 599060 599060 Harrys, Thomas, of Russheton, husbandman 0
5626365 2552213 2552213 defendant Broune John drover 599060 599060 Broune, John, of Russheton, drover 0
5629374 2553168 2553168 defendant Lovet Nicholas gent 599060 599060 Lovet, Nicholas, of Russheton, gent 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);