names

93 rows where place_id = 640639

✎ 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
3856545 1975674 1975674 defendant Harward Nicholas husbandman 640639 640639 Harward, Nicholas, of Napton, husbandman 2
3856549 1975674 1975674 defendant Stonley Thomas husbandman 640639 640639 Stonley, Thomas, of Napton, husbandman 6
3856550 1975674 1975674 defendant Maryott Thomas husbandman 640639 640639 Maryott, Thomas, of Napton, husbandman 7
3870391 1980343 1980343 defendant Borowes Thomas husbandman 640639 640639 Borowes, Thomas, of Napton, husbandman 0
3870396 1980344 1980344 defendant Hardward Nicholas husbandman 640639 640639 Hardward, Nicholas, of Napton, husbandman 2
3870400 1980344 1980344 defendant Stonley Thomas husbandman 640639 640639 Stonley, Thomas, of Napton, husbandman 6
3870401 1980344 1980344 defendant Maryott Thomas husbandman 640639 640639 Maryott, Thomas, of Napton, husbandman 7
4038743 2038484 2038484 defendant Tofte John yeoman 640639 640639 Tofte, John, of Napton, yeoman 2
4038744 2038484 2038484 defendant Horley Humphrey husbandman 640639 640639 Horley, Humphrey, of Napton, husbandman 3
4038745 2038484 2038484 defendant Rychardson Robert butcher 640639 640639 Rychardson, Robert, of Napton, butcher 4
4038750 2038485 2038485 defendant Tofte John singleman 640639 640639 Tofte, John, of Napton, yeoman, singleman 2
4038751 2038485 2038485 defendant Horley Humphrey husbandman 640639 640639 Horley, Humphrey, of Napton, husbandman 3
4038752 2038485 2038485 defendant Rychardson Robert butcher 640639 640639 Rychardson, Robert, of Napton, butcher 4
4048709 2041983 2041983 defendant Oldefylde Thomas yeoman 640639 640639 Oldefylde, Thomas, of Napton, yeoman 2
4048710 2041983 2041983 defendant Elwarde William yeoman 640639 640639 Elwarde, William, of Napton, yeoman 3
4048711 2041983 2041983 defendant Elward John husbandman 640639 640639 Elward, John, of Napton, husbandman 4
4048712 2041983 2041983 defendant Grene William husbandman 640639 640639 Grene, William, of Napton, husbandman 5
4048713 2041983 2041983 defendant Martyn Richard husbandman 640639 640639 Martyn, Richard, of Napton, husbandman 6
4048714 2041983 2041983 defendant Twyst William husbandman 640639 640639 Twyst, William, of Napton, husbandman 7
4049926 2042405 2042405 defendant Fawkener John yeoman 640639 640639 Fawkener, John, of Napton, yeoman 1
4058057 2045263 2045263 defendant Tofte Thomas husbandman 640639 640639 Tofte, Thomas, of Napton, husbandman 0
4058058 2045263 2045263 defendant Raynbowe William husbandman 640639 640639 Raynbowe, William, of Napton, husbandman 1
4078974 2052779 2052779 defendant Marriatt Thomas husbandman 640639 640639 Marriatt, Thomas, of Napton, husbandman 0
4115657 2065885 2065885 defendant Smyth William husbandman 640639 640639 Smyth, William, of Napton, husbandman 2
4115841 2065950 2065950 defendant Taste John, senior yeoman 640639 640639 Taste, John, senior, of Napton, yeoman 0
4115843 2065950 2065950 defendant Taste William yeoman 640639 640639 Taste, William, of Napton, yeoman 2
4115845 2065951 2065951 defendant Taste John, senior yeoman 640639 640639 Taste, John, senior, of Napton, yeoman 0
4115847 2065951 2065951 defendant Taste William yeoman 640639 640639 Taste, William, of Napton, yeoman 2
4115850 2065952 2065952 defendant Taste John yeoman 640639 640639 Taste, John, of Napton, yeoman 0
4115854 2065953 2065953 defendant Tofte or Tafte or Taste John yeoman 640639 640639 Tofte or Tafte or Taste, John, of Napton, yeoman 0
4158029 2080880 2080880 defendant Oldfelde Thomas gent 640639 640639 Oldfelde, Thomas, of Napton, gent 0
4185662 2090490 2090490 defendant Oldfeild Thomas yeoman 640639 640639 Oldfeild, Thomas, of Napton, yeoman 0
4217413 2101584 2101584 defendant Jeffes John husbandman 640639 640639 Jeffes, John, of Napton, husbandman 2
4226610 2104783 2104783 defendant Jeffes John husbandman 640639 640639 Jeffes, John, of Napton, husbandman 2
4277777 2122152 2122152 defendant Grene Richard husbandman 640639 640639 Grene, Richard, of Napton, husbandman 0
4418219 2170582 2170582 defendant Hoo James de   640639 640639 Hoo, James de, of Napton, parson 0
4426069 2172963 2172963 defendant Shereman Alice   640639 640639 Shereman, Alice, of Napton, formerly wife of William 0
4426071 2172963 2172963 defendant Webbe Robert   640639 640639 Webbe, Robert, of Napton 2
4427757 2173518 2173518 defendant Compton Thomas de   640639 640639 Compton, Thomas de, of Napton 1
4435311 2175803 2175803 defendant Campioun Richard   640639 640639 Campioun, Richard, of Napton 4
4435313 2175803 2175803 defendant Gunne John   640639 640639 Gunne, John, of Napton, son of Adam 6
4435317 2175803 2175803 defendant Disshere Richard   640639 640639 Disshere, Richard, of Napton 10
4435318 2175803 2175803 defendant Charles Ralph   640639 640639 Charles, Ralph, of Napton 11
4437283 2176408 2176408 defendant Hoo James de   640639 640639 Hoo, James de, of Napton, parson 0
4451202 2185334 2185334 plaintiff Hervy John   640639 640639 Hervy, John, of Napton, on his own account 0
4460855 2188459 2188459 defendant Austyn William   640639 640639 Austyn, William, of Napton 0
4460857 2188460 2188460 defendant Porter Robert   640639 640639 Porter, Robert, of Napton 0
4460858 2188460 2188460 defendant Austyn William   640639 640639 Austyn, William, of Napton 1
4460860 2188461 2188461 defendant Potter Robert   640639 640639 Potter, Robert, of Napton 0
4460862 2188462 2188462 defendant Hereward John   640639 640639 Hereward, John, of Napton 0
4465531 2189888 2189888 defendant Potare Robert   640639 640639 Potare, Robert, of Napton 0
4483591 2195559 2195559 plaintiff Odam Emma   640639 640639 Odam, Emma, of Napton, formerly wife of John, on her own account 0
4570232 2222261 2222261 defendant Juddon Richard   640639 640639 Juddon, Richard, of Napton 0
4570233 2222261 2222261 defendant Freman William   640639 640639 Freman, William, of Napton 1
4576379 2224125 2224125 plaintiff Broun John   640639 640639 Broun, John, of Napton 0
4617976 2236629 2236629 plaintiff Hayton Thomas   640639 640639 Hayton, Thomas, of Napton 2
4624997 2238786 2238786 plaintiff Oscherch John draper 640639 640639 Oscherch, John, of Napton, draper 0
4655729 2247675 2247675 plaintiff Budde William   640639 640639 Budde, William, of Napton 0
4655732 2247676 2247676 plaintiff Budde William   640639 640639 Budde, William, of Napton 0
4664841 2250481 2250481 defendant Toft John husbandman 640639 640639 Toft, John, of Napton, husbandman 0
4680987 2259679 2259679 defendant Bayle John husbandman 640639 640639 Bayle, John, of Napton, husbandman 0
4695525 2264083 2264083 plaintiff Broune John, sen   640639 640639 Broune, John, sen, of Napton 0
4695526 2264083 2264083 defendant Budde William   640639 640639 Budde, William, of Napton 0
4727174 2273760 2273760 defendant Mason John   640639 640639 Mason, John, of Napton 0
4727383 2273813 2273813 defendant Tofte Edmund laborer 640639 640639 Tofte, Edmund, of Napton, laborer 1
4788253 2292394 2292394 defendant Holbek Richard   640639 640639 Holbek, Richard, of Napton, shepherd 0
4788254 2292395 2292395 plaintiff Hayton Thomas   640639 640639 Hayton, Thomas, of Napton 0
4813073 2300204 2300204 plaintiff Bircher Simon clerk 640639 640639 Bircher, Simon, of Napton, clerk 1
4848610 2311039 2311039 defendant Broun John   640639 640639 Broun, John, of Napton, franklin 0
4861571 2314989 2314989 defendant Broun John   640639 640639 Broun, John, of Napton, franklin 0
4866995 2316641 2316641 defendant Godfrey John husbandman 640639 640639 Godfrey, John, of Napton, husbandman 0
4866996 2316641 2316641 defendant Walenger William   640639 640639 Walenger, William, of Napton, servant 1
4866997 2316641 2316641 defendant Whyte William   640639 640639 Whyte, William, of Napton, servant 2
4953406 2342984 2342984 defendant Par Hugh tailor 640639 640639 Par, Hugh, of Napton, tailor 0
4953407 2342984 2342984 defendant Shirlok Thomas weaver 640639 640639 Shirlok, Thomas, of Napton, weaver 1
4953507 2343020 2343020 defendant Sherman Thomas chaplain 640639 640639 Sherman, Thomas, of Napton, chaplain 0
4953508 2343020 2343020 defendant Sherman Edmund husbandman 640639 640639 Sherman, Edmund, of Napton, husbandman 1
4991099 2354228 2354228 defendant Cryk Richard butcher 640639 640639 Cryk, Richard, of Napton, butcher 0
5027916 2365043 2365043 defendant Cryke Richard butcher 640639 640639 Cryke, Richard, of Napton, butcher 0
5027917 2365043 2365043 defendant Corell John smith 640639 640639 Corell, John, of Napton, smith 1
5258959 2432917 2432917 defendant Venables Peter esq 640639 640639 Venables, Peter, of Napton, esq 0
5428954 2483578 2483578 defendant Hayton Thomas gent 640639 640639 Hayton, Thomas, of Napton, gent 2
5446164 2488735 2488735 defendant Hayton Thomas gent 640639 640639 Hayton, Thomas, of Napton, gent 1
5458770 2492515 2492515 defendant Hayton Thomas gent 640639 640639 Hayton, Thomas, of Napton, gent 1
5494125 2503147 2503147 defendant Heyward Henry husbandman 640639 640639 Heyward, Henry, of Napton, husbandman 0
5494126 2503147 2503147 defendant Deyster Thomas husbandman 640639 640639 Deyster, Thomas, of Napton, husbandman 1
5528796 2513529 2513529 defendant Haiton Thomas gent 640639 640639 Haiton, Thomas, of Napton, gent 0
5542945 2517912 2517912 defendant Hayton Thomas gent 640639 640639 Hayton, Thomas, of Napton, gent 0
5547804 2519376 2519376 plaintiff Wyllys Richard   640639 640639 Wyllys, Richard, of Napton 0
5588288 2531339 2531339 defendant Bree John husbandman 640639 640639 Bree, John, of of Napton, husbandman 0
5613292 2547939 2547939 defendant Tysho Richard de   640639 640639 Tysho, Richard de, of Napton, parson 0
5623243 2551200 2551200 defendant Potter Robert   640639 640639 Potter, Robert, of Napton 0
5633698 2554539 2554539 plaintiff Throop Thomas (legal representative) 640639 640639 Throop, Thomas, of Napton, executors of 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);