names

78 rows where place_id = 586519

✎ 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
3588943 1864193 1864193 defendant Crymbyll George yeoman 586519 586519 Crymbyll, George, of Blyklyng, yeoman 4
3621225 1874180 1874180 defendant Kethood alias Westwyk Edmund husbandman 586519 586519 Kethood alias Westwyk, Edmund, of Blyklyng, husbandman 0
3648606 1909952 1909952 defendant Avettys John husbandman 586519 586519 Avettys, John, of Blyklyng, husbandman 5
3672835 1917515 1917515 defendant Coke Thomas husbandman 586519 586519 Coke, Thomas, of Blyklyng, husbandman 0
3692249 1923745 1923745 defendant Bettys Thomas glover 586519 586519 Bettys, Thomas, of Blyklyng, glover 1
3740897 1939012 1939012 defendant Cooke Thomas husbandman 586519 586519 Cooke, Thomas, of Blyklyng, husbandman 0
3774062 1949602 1949602 defendant Oke William husbandman 586519 586519 Oke, William, of Blyklyng, husbandman 2
3779500 1951311 1951311 defendant Shref John husbandman 586519 586519 Shref, John, of Blyklyng, husbandman 1
3787642 1953922 1953922 defendant Westwyk John husbandman 586519 586519 Westwyk, John, of Blyklyng, husbandman 2
3787643 1953922 1953922 defendant Bettys Thomas glover 586519 586519 Bettys, Thomas, of Blyklyng, glover 3
3787648 1953923 1953923 defendant Westwyk John husbandman 586519 586519 Westwyk, John, of Blyklyng, husbandman 2
3787649 1953923 1953923 defendant Bettys Thomas glover 586519 586519 Bettys, Thomas, of Blyklyng, glover 3
3789581 1954569 1954569 defendant Coke Thomas husbandman 586519 586519 Coke, Thomas, of Blyklyng, husbandman 1
3805528 1959670 1959670 defendant Shreve John husbandman 586519 586519 Shreve, John, of Blyklyng, husbandman 0
3847779 1972878 1972878 defendant Cobbe Thomas yeoman 586519 586519 Cobbe, Thomas, of Blyklyng, yeoman 0
3852698 1974451 1974451 defendant Tyllok Agnes widow 586519 586519 Tyllok, Agnes, of Blyklyng, widow 4
3927220 1999440 1999440 defendant Webster John yeoman 586519 586519 Webster, John, of Blyklyng, yeoman 1
3930010 2000381 2000381 defendant Butler John yeoman 586519 586519 Butler, John, of Blyklyng, yeoman 2
3933114 2001368 2001368 defendant Garrard James   586519 586519 Garrard, James, of Blyklyng, worsted weaver 0
3948097 2006400 2006400 defendant Wodehous John, junior gent 586519 586519 Wodehous, John, junior, of Blyklyng, gent 1
3960537 2010787 2010787 defendant Cokk Thomas carpenter 586519 586519 Cokk, Thomas, of Blyklyng, carpenter 0
3960538 2010787 2010787 defendant Dynne Robert cordwainer 586519 586519 Dynne, Robert, of Blyklyng, cordwainer 1
3960539 2010787 2010787 defendant Jamys Cuthbert   586519 586519 Jamys, Cuthbert, of Blyklyng, worsted weaver 2
4555483 2217647 2217647 defendant Smyth John   586519 586519 Smyth, John, of Blyklyng 10
4667395 2255524 2255524 defendant Hesyngham Stephen husbandman 586519 586519 Hesyngham, Stephen, of Blyklyng, husbandman 0
4718111 2271005 2271005 defendant atte Welle John husbandman 586519 586519 atte Welle, John, of Blyklyng, husbandman 4
4718112 2271005 2271005 defendant Bettes Roger husbandman 586519 586519 Bettes, Roger, of Blyklyng, husbandman 5
4755800 2282196 2282196 defendant Hamond John   586519 586519 Hamond, John, of Blyklyng, shoe maker 0
4804527 2297605 2297605 defendant Letys John laborer 586519 586519 Letys, John, of Blyklyng, laborer 0
4844883 2309920 2309920 defendant Tomys William husbandman 586519 586519 Tomys, William, of Blyklyng, husbandman 8
4867053 2316659 2316659 defendant Mundys William yeoman 586519 586519 Mundys, William, of Blyklyng, yeoman 2
4925867 2334523 2334523 plaintiff Porter John   586519 586519 Porter, John, of Blyklyng 0
4925869 2334524 2334524 plaintiff Porter John   586519 586519 Porter, John, of Blyklyng 0
4950977 2342272 2342272 defendant Osmond John yeoman 586519 586519 Osmond, John, of Blyklyng, yeoman 0
4975328 2349578 2349578 defendant Baxster William baker 586519 586519 Baxster, William, of Blyklyng, baker 1
4989078 2353672 2353672 plaintiff Chever Richard   586519 586519 Chever, Richard, of Blyklyng 1
4989781 2353862 2353862 defendant Lyon George yeoman 586519 586519 Lyon, George, of Blyklyng, yeoman 0
4996135 2355701 2355701 defendant Benne John husbandman 586519 586519 Benne, John, of Blyklyng, husbandman 3
4998390 2356395 2356395 plaintiff Jerveys Henry clerk 586519 586519 Jerveys, Henry, of Blyklyng, clerk 0
5000035 2356892 2356892 defendant Rogers Thomas butcher 586519 586519 Rogers, Thomas, of Blyklyng, butcher 0
5000036 2356892 2356892 defendant Beamont Roger husbandman 586519 586519 Beamont, Roger, of Blyklyng, husbandman 1
5004820 2358306 2358306 defendant Chenere Richard yeoman 586519 586519 Chenere, Richard, of Blyklyng, yeoman 0
5024045 2363943 2363943 defendant Rogers Thomas butcher 586519 586519 Rogers, Thomas, of Blyklyng, butcher 1
5024046 2363943 2363943 defendant Bemond Roger husbandman 586519 586519 Bemond, Roger, of Blyklyng, husbandman 2
5026958 2364756 2364756 defendant Multon John miller 586519 586519 Multon, John, of Blyklyng, miller 0
5030722 2365857 2365857 plaintiff Porter John   586519 586519 Porter, John, of Blyklyng 0
5031452 2366056 2366056 defendant Chevere Richard yeoman 586519 586519 Chevere, Richard, of Blyklyng, yeoman 0
5032209 2366300 2366300 defendant atte Well Roger miller 586519 586519 atte Well, Roger, of Blyklyng, miller 1
5040653 2368814 2368814 defendant Fuller Thomas fuller 586519 586519 Fuller, Thomas, of Blyklyng, fuller 2
5069273 2377296 2377296 defendant Wesewyk John husbandman 586519 586519 Wesewyk, John, of Blyklyng, husbandman 5
5069442 2377359 2377359 plaintiff Reynald Roger   586519 586519 Reynald, Roger, of Blyklyng 0
5075435 2379147 2379147 defendant Whyte Thomas yeoman 586519 586519 Whyte, Thomas, of Blyklyng, yeoman 0
5092171 2384086 2384086 plaintiff Osmond alias Porter John   586519 586519 Osmond alias Porter, John, of Blyklyng 0
5099564 2386311 2386311 plaintiff Whyte Thomas yeoman 586519 586519 Whyte, Thomas, of Blyklyng, yeoman 0
5116385 2391221 2391221 plaintiff Osmond alias Portere John yeoman 586519 586519 Osmond alias Portere, John, of Blyklyng, yeoman 0
5138779 2397841 2397841 defendant Weeland Thomas miller 586519 586519 Weeland, Thomas, of Blyklyng, miller 0
5167089 2406106 2406106 defendant Reynnaldes William husbandman 586519 586519 Reynnaldes, William, of Blyklyng, husbandman 0
5240111 2427308 2427308 defendant Gryce Thomas husbandman 586519 586519 Gryce, Thomas, of Blyklyng, husbandman 0
5314591 2449396 2449396 defendant Porter Roger husbandman 586519 586519 Porter, Roger, of Blyklyng, husbandman 1
5377240 2468468 2468468 defendant Rede Thomas chaplain 586519 586519 Rede, Thomas, of Blyklyng, chaplain 1
5380230 2469393 2469393 defendant Barker Thomas husbandman 586519 586519 Barker, Thomas, of Blyklyng, husbandman 0
5380232 2469394 2469394 defendant Momberey William carpenter 586519 586519 Momberey, William, of Blyklyng, carpenter 0
5422474 2481669 2481669 plaintiff Aldyns Robert   586519 586519 Aldyns, Robert, of Blyklyng 1
5455973 2491697 2491697 defendant Kyng William husbandman 586519 586519 Kyng, William, of Blyklyng, husbandman 0
5455975 2491698 2491698 defendant Kyng William husbandman 586519 586519 Kyng, William, of Blyklyng, husbandman 0
5466260 2494848 2494848 plaintiff Aleyns Robert   586519 586519 Aleyns, Robert, of Blyklyng 0
5477577 2498310 2498310 plaintiff Aleyns Robert   586519 586519 Aleyns, Robert, of Blyklyng 0
5477579 2498311 2498311 plaintiff Aleys Robert   586519 586519 Aleys, Robert, of Blyklyng 0
5484250 2500215 2500215 defendant Larwode John husbandman 586519 586519 Larwode, John, of Blyklyng, husbandman 1
5499643 2504834 2504834 defendant Wallour Richard thatcher 586519 586519 Wallour, Richard, of Blyklyng, thatcher 0
5499646 2504835 2504835 defendant Wallour Richard thatcher 586519 586519 Wallour, Richard, of Blyklyng, thatcher 0
5515821 2509795 2509795 defendant Aleyn Robert roper 586519 586519 Aleyn, Robert, of Blyklyng, roper 2
5535262 2515558 2515558 defendant Boleyn Thomas   586519 586519 Boleyn, Thomas, of Blyklyng, esq, son of Boleyn, William, knight 0
5535360 2515586 2515586 plaintiff Boleyn Anne (legal representative) 586519 586519 Boleyn, Anne, of Blyklyng, widow, executors of, (Boleyn, William, knight 0
5536448 2515887 2515887 defendant Boleyn Thomas   586519 586519 Boleyn, Thomas, of Blyklyng, esq, son of Boleyn, William, of Blyklyng 0
5563204 2523837 2523837 plaintiff Applayard Geoffrey (legal representative) 586519 586519 Applayard, Geoffrey, of Blyklyng, executors of 0
5574209 2527021 2527021 defendant Bukton John yeoman 586519 586519 Bukton, John, of Blyklyng, yeoman 0
5580747 2529058 2529058 defendant Annettys Thomas carpenter 586519 586519 Annettys, Thomas, of Blyklyng, carpenter 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);