names

84 rows where place_id = 595810

✎ 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
3622000 1874422 1874422 defendant Marshall Thomas yeoman 595810 595810 Marshall, Thomas, of Wyndesore, Berks, yeoman 2
3679901 1919780 1919780 defendant Pache Richard yeoman 595810 595810 Pache, Richard, of Wyndesore, Berks, yeoman 0
3679905 1919781 1919781 defendant Pache Richard yeoman 595810 595810 Pache, Richard, of Wyndesore, Berks, yeoman 0
3690213 1923097 1923097 defendant Wynn- William clerk 595810 595810 Wynn-, William, of Wyndesore, Berks, clerk 4
3736656 1937717 1937717 defendant Staper Christopher yeoman 595810 595810 Staper, Christopher, of Wyndesore, Berks, yeoman 0
3760598 1945313 1945313 defendant Johnson William mercer 595810 595810 Johnson, William, of Wyndesore, Berks, mercer 3
3786011 1953417 1953417 defendant Welden Miles clerk 595810 595810 Welden, Miles, of Wyndesore, berks, clerk 3
3792901 1955633 1955633 defendant Scrodener Hans shoemaker 595810 595810 Scrodener, Hans, of Wyndesore, Berks, shoemaker 0
3802194 1958582 1958582 plaintiff Oxenbrigg John (legal representative) 595810 595810 Oxenbrigg, John, of Wyndesore, Berks, clerk, executors of 0
3819678 1964036 1964036 plaintiff Oxenbrigge John (legal representative) 595810 595810 Oxenbrigge, John, of Wyndesore, Berks, canon of St George Chapel, executors of 0
3837279 1969566 1969566 defendant Perry John carpenter 595810 595810 (Perry, John, of Wyndesore, Berks, carpenter 1
3852051 1974232 1974232 defendant Browne John clerk 595810 595810 Browne, John, of Wyndesore, Berks, clerk 0
3857445 1975963 1975963 defendant Benet Robert brewer 595810 595810 Benet, Robert, of Wyndesore, Berks, brewer 0
3888004 1986238 1986238 defendant Benett Robert brewer 595810 595810 Benett, Robert, of Wyndesore, Berks, brewer 0
3901961 1990884 1990884 defendant Benett Robert brewer 595810 595810 Benett, Robert, of Wyndesore, Berks, brewer 0
3904078 1991605 1991605 defendant Holand John gent 595810 595810 Holand, John, of Wyndesore, Berks, gent 0
3905868 1992246 1992246 defendant Knollys John tailor 595810 595810 Knollys, John, of Wyndesore, Berks, tailor 1
3905871 1992247 1992247 defendant Knollys John tailor 595810 595810 Knollys, John, of Wyndesore, Berks, tailor 1
3983775 2018973 2018973 defendant Dale Humhrey yeoman 595810 595810 Dale, Humhrey, of Wyndesore, Berks, yeoman 0
3996270 2023415 2023415 defendant Dowcra or Dockrey Edmund esq 595810 595810 Dowcra or Dockrey, Edmund, of Wyndesore, berks, esq 0
4005043 2026589 2026589 defendant Alley Mathew gent 595810 595810 Alley, Mathew, of Wyndesore, Berks, gent 0
4088835 2056306 2056306 defendant Alley Mathew yeoman 595810 595810 Alley, Mathew, of Wyndesore, Berks, yeoman 1
4342959 2144813 2144813 defendant Aleyn John gent 595810 595810 Aleyn, John, of Wyndesore, Berks, gent 0
4670678 2256512 2256512 defendant Yns John gent 595810 595810 Yns, John, of Wyndesore, Berks, gent 0
4670696 2256515 2256515 defendant Yus or Yns John gent 595810 595810 Yus or Yns, John, of Wyndesore, Berks, gent 0
4681830 2259929 2259929 defendant Wyssetur Henry yeoman 595810 595810 Wyssetur, Henry, of Wyndesore, Berks, yeoman 1
4691775 2262959 2262959 defendant Gowe Robert clerk 595810 595810 Gowe, Robert, of Wyndesore, Berks, clerk 0
4704837 2266891 2266891 defendant Chaundeler James chandler 595810 595810 Chaundeler, James, of Wyndesore, Berks, chandler 1
4710719 2268707 2268707 defendant Gowe Robert clerk 595810 595810 Gowe, Robert, of Wyndesore, Berks, clerk 0
4722949 2272492 2272492 defendant Thomas John clerk 595810 595810 Thomas, John, of Wyndesore, Berks, clerk 0
4751693 2280983 2280983 defendant Randolf Robert chaplain 595810 595810 Randolf, Robert, of Wyndesore, Berks, chaplain 0
4752769 2281265 2281265 defendant Hunte Henry husbandman 595810 595810 Hunte, Henry, of wyndesore, Berks, husbandman 2
4778556 2289275 2289275 defendant de la Pomeray William esq 595810 595810 de la Pomeray, William, of Wyndesore, Berks, or of Devon, esq 3
4795488 2294741 2294741 defendant Kent John yeoman 595810 595810 Kent, John, of Wyndesore, Berks, yeoman 0
4818443 2301849 2301849 defendant Marcheford Simon clerk 595810 595810 Marcheford, Simon, of Wyndesore, Berks, clerk 5
4818452 2301850 2301850 defendant Marcheford Simon clerk 595810 595810 Marcheford, Simon, of Wyndesore, Berks, clerk 5
4827022 2304494 2304494 defendant Alcok William gent 595810 595810 Alcok, William, of Wyndesore, Berks, gent 2
4877815 2320025 2320025 defendant Malefant Thomas   595810 595810 Malefant, Thomas, of Wyndesore, Berks, knight 0
4877929 2320050 2320050 defendant Dowerege Thomas clerk 595810 595810 Dowerege, Thomas, of Wyndesore, Berks, clerk 0
4879519 2320522 2320522 defendant Yattere William husbandman 595810 595810 Yattere, William, of Wyndesore, Berks, husbandman 1
4896267 2325497 2325497 defendant Chaumbre Rose widow 595810 595810 Chaumbre, Rose, of Wyndesore, Berks, widow 1
4942562 2339649 2339649 defendant Norfolke John chapman 595810 595810 Norfolke, John, of Wyndesore, Berks, chapman 0
4953784 2343092 2343092 defendant Otewy John husbandman 595810 595810 Otewy, John, of Wyndesore, Berks, husbandman 0
4958152 2344406 2344406 defendant Kyderowe John   595810 595810 Kyderowe, John, of Wyndesore, Berks, or of Soms, knight 2
4958160 2344407 2344407 defendant Kyderowe John   595810 595810 Kyderowe, John, of Wyndesore, Berks, or of Soms, knight 2
4958582 2344532 2344532 defendant Sherman Roger chapman 595810 595810 Sherman, Roger, of Wyndesore, Berks, chapman 1
4959629 2344842 2344842 defendant Lyne William gent 595810 595810 Lyne, William, of Wyndesore, Berks, or of Kynfare, gent 0
4970269 2348061 2348061 defendant Bromehille William smith 595810 595810 Bromehille, William, of Wyndesore, Berks, smith 2
4970278 2348062 2348062 defendant Bromehille William smith 595810 595810 Bromehille, William, of Wyndesore, Berks, smith 2
4996821 2355905 2355905 defendant Towe William husbandman 595810 595810 Towe, William, of Wyndesore, Berks, husbandman 1
4996831 2355908 2355908 defendant Towe William husbandman 595810 595810 Towe, William, of Wyndesore, Berks, husbandman 1
5010253 2359863 2359863 defendant Kyng John yeoman 595810 595810 Kyng, John, of Wyndesore, Berks, yeoman 4
5015299 2361355 2361355 defendant Roo Henry   595810 595810 Roo, Henry, of Wyndesore, Berks, or of London, mason 1
5042977 2369515 2369515 defendant Houghton Richard yeoman 595810 595810 Houghton, Richard, of Wyndesore, Berks, yeoman 1
5048829 2371283 2371283 defendant Midelton William esq 595810 595810 Midelton, William, of Wyndesore, Berks, esq 4
5048842 2371285 2371285 defendant Midelton William esq 595810 595810 Midelton, William, of Wyndesore, Berks, esq 4
5049811 2371572 2371572 defendant Clyfford Thomas brewer 595810 595810 Clyfford, Thomas, of Wyndesore, Berks, brewer 0
5049813 2371572 2371572 defendant Sherman Roger sheerman 595810 595810 Sherman, Roger, of Wyndesore, Berks, sheerman 2
5052732 2372413 2372413 defendant Bolley William gent 595810 595810 Bolley, William, of Wyndesore, Berks, gent 3
5052737 2372414 2372414 defendant Bolley William gent 595810 595810 Bolley, William, of Wyndesore, Berks, gent 3
5075752 2379249 2379249 defendant Etwell John clerk 595810 595810 Etwell, John, of Wyndesore, Berks, clerk 3
5092569 2384203 2384203 defendant Towe William baker 595810 595810 Towe, William, of Wyndesore, Berks, baker 1
5092573 2384204 2384204 defendant Towe William baker 595810 595810 Towe, William, of Wyndesore, Berks, baker 1
5312119 2448657 2448657 defendant Gefferey Leyson clerk 595810 595810 Gefferey, Leyson, of Wyndesore, Berks, clerk 0
5342655 2457905 2457905 defendant Blankford William chapman 595810 595810 Blankford, William, of Wyndesore, Berks, chapman 0
5423123 2481874 2481874 defendant Birkhed James chaplain 595810 595810 Birkhed, James, of Wyndesore, Berks, chaplain 0
5483692 2500074 2500074 defendant Dynham Oliver clerk 595810 595810 Dynham, Oliver, of Wyndesore, Berks, clerk 0
5493540 2502982 2502982 defendant West Thomas chapman 595810 595810 West, Thomas, of Wyndesore, Berks, chapman 0
5495209 2503463 2503463 defendant Assheborne Richard saddler 595810 595810 Assheborne, Richard, of Wyndesore, Berks, saddler 0
5513091 2508949 2508949 defendant Middelton William yeoman 595810 595810 Middelton, William, of Wyndesore, Berks, yeoman 0
5525492 2512564 2512564 plaintiff Hardy John clerk 595810 595810 Hardy, John, of Wyndesore, Berks, clerk 0
5525494 2512565 2512565 plaintiff Hardy John clerk 595810 595810 Hardy, John, of Wyndesore, Berks, clerk 0
5525496 2512566 2512566 plaintiff Hardy John clerk 595810 595810 Hardy, John, of Wyndesore, Berks, clerk 0
5525498 2512567 2512567 plaintiff Hardy John clerk 595810 595810 Hardy, John, of Wyndesore, Berks, clerk 0
5525500 2512568 2512568 plaintiff Hardy John clerk 595810 595810 Hardy, John, of Wyndesore, Berks, clerk 0
5525506 2512569 2512569 plaintiff Hardy John clerk 595810 595810 Hardy, John, of Wyndesore, Berks, clerk 0
5530814 2514154 2514154 defendant Thorp Richard grocer 595810 595810 Thorp, Richard, of Wyndesore, Berks, grocer 0
5530819 2514155 2514155 defendant Thorp Richard grocer 595810 595810 Thorp, Richard, of Wyndesore, Berks, grocer 0
5600937 2535180 2535180 defendant Thorp William butcher 595810 595810 Thorp, William, of Wyndesore, Berks, butcher 0
5629090 2553070 2553070 defendant Exton Joan clerk 595810 595810 Exton, Joan, of Wyndesore, Berks, clerk 0
5631492 2553859 2553859 defendant Tebaude Peter weaver 595810 595810 Tebaude, Peter, of Wyndesore, Berks, weaver 0
5633903 2554597 2554597 defendant Gowe Robert clerk 595810 595810 Gowe, Robert, of Wyndesore, Berks, clerk 0
5633905 2554598 2554598 defendant Gowe Robert clerk 595810 595810 Gowe, Robert, of Wyndesore, Berks, clerk 0
5633986 2554611 2554611 defendant Petyte John fisher 595810 595810 Petyte, John, of Wyndesore, Berks, fisher 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);