names

42 rows where place_id = 641379

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3861199 1977221 1977221 defendant Copleston Charles esq 641379 641379 Copleston, Charles, of Plymptre, esq 0
3866056 1978880 1978880 defendant Copleston Charles esq 641379 641379 Copleston, Charles, of Plymptre, gent, son of Copleston, Henry, of Bytton, esq 0
3969895 2014071 2014071 plaintiff Crosse John husbandman 641379 641379 Crosse, John, of Plymptre, husbandman 0
3969898 2014072 2014072 plaintiff Crosse John husbandman 641379 641379 Crosse, John, of Plymptre, husbandman 0
3995740 2023222 2023222 plaintiff Crosse Robert   641379 641379 Crosse, Robert, of Plymptre 0
3995742 2023223 2023223 plaintiff Crosse Robert   641379 641379 Crosse, Robert, of Plymptre 0
4031696 2036001 2036001 plaintiff Fourde Edward gent 641379 641379 Fourde, Edward, of Plymptre, gent 0
4039604 2038780 2038780 defendant Pound John husbandman 641379 641379 Pound, John, of Plymptre, husbandman 14
4474428 2192659 2192659 defendant Waryn Richard   641379 641379 Waryn, Richard, of Plymptre 2
4533630 2210787 2210787 plaintiff Roldeston John   641379 641379 Roldeston, John, of Plymptre, parson 0
4557704 2218345 2218345 defendant Crosse John   641379 641379 Crosse, John, of Plymptre 0
4573013 2223094 2223094 plaintiff Baker Thomas   641379 641379 Baker, Thomas, of Plymptre 0
4573014 2223094 2223094 defendant Pyle Richard   641379 641379 Pyle, Richard, of Plymptre 0
4573015 2223094 2223094 defendant Pyle John   641379 641379 Pyle, John, of Plymptre 1
4677133 2258464 2258464 defendant Oton John wheeler 641379 641379 Oton, John, of Plymptre, wheeler 2
4677137 2258465 2258465 defendant Oton John wheeler 641379 641379 Oton, John, of Plymptre, wheeler 2
4677139 2258466 2258466 defendant Axe William husbandman 641379 641379 Axe, William, of Plymptre, husbandman 0
4678355 2258839 2258839 defendant Axe William husbandman 641379 641379 Axe, William, of Plymptre, husbandman 0
5046278 2370518 2370518 defendant atte Halle Thomas husbandman 641379 641379 atte Halle, Thomas, of Plymptre, husbandman 0
5085128 2382054 2382054 defendant atte Forde John   641379 641379 atte Forde, John, of Plymptre, franklin 1
5118944 2391973 2391973 defendant atte Forde John   641379 641379 atte Forde, John, of Plymptre, franklin 0
5118945 2391973 2391973 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 1
5248071 2429573 2429573 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 1
5262028 2433873 2433873 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 0
5265168 2434866 2434866 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre,gent 1
5297082 2444143 2444143 defendant Wynterborn John chaplain 641379 641379 Wynterborn, John, of Plymptre, chaplain 1
5315770 2449787 2449787 defendant Knyght William husbandman 641379 641379 Knyght, William, of Plymptre, husbandman 0
5323581 2452136 2452136 defendant Smert Richard clerk 641379 641379 Smert, Richard, of Plymptre, clerk 0
5329492 2453886 2453886 defendant Smort Richard clerk 641379 641379 Smort, Richard, of Plymptre, clerk 0
5329493 2453886 2453886 defendant Trenchard Richard husbandman 641379 641379 Trenchard, Richard, of Plymptre, husbandman 1
5329498 2453888 2453888 defendant Smert Richard   641379 641379 Smert, Richard, of Plymptre 0
5329499 2453888 2453888 defendant Trenchard Richard husbandman 641379 641379 Trenchard, Richard, of Plymptre, husbandman 1
5368308 2465705 2465705 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 0
5426565 2482891 2482891 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 1
5444606 2488289 2488289 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 0
5457351 2492100 2492100 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 0
5469175 2495710 2495710 defendant atte Forde William gent 641379 641379 atte Forde, William, of Plymptre, gent 0
5487271 2501089 2501089 defendant Trenchard Richard husbandman 641379 641379 Trenchard, Richard, of Plymptre, husbandman 1
5491859 2502473 2502473 defendant Atwill John husbandman 641379 641379 Atwill, John, of Plymptre, husbandman 1
5492751 2502747 2502747 defendant Atteford William gent 641379 641379 Atteford, William, of Plymptre, gent 0
5508560 2507543 2507543 defendant Trenchard Richard butcher 641379 641379 Trenchard, Richard, of Plymptre, butcher 0
5537346 2516173 2516173 defendant Trenchard Richard husbandman 641379 641379 Trenchard, Richard, of Plymptre, 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);