names

50 rows where place_id = 587238

✎ 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
3590870 1864776 1864776 defendant Wyndesore Andrew gent 587238 587238 Wyndesore, Andrew, of Stanwell, gent 0
3650262 1910455 1910455 defendant Pyne William yeoman 587238 587238 Pyne, William, of Stanwell, yeoman 0
3671141 1916943 1916943 defendant Halle Richard yeoman 587238 587238 Halle, Richard, of Stanwell, yeoman 0
3733345 1936660 1936660 defendant Durdant Phelice widow 587238 587238 Durdant, Phelice, of Stanwell, widow 3
3752162 1942604 1942604 defendant Whytyng William yeoman 587238 587238 Whytyng, William, of Stanwell, yeoman 0
3802831 1958780 1958780 defendant Whytyng William yeoman 587238 587238 Whytyng, William, of Stanwell, yeoman 0
3967736 2013350 2013350 defendant Bennett Robert draper 587238 587238 Bennett, Robert, of Stanwell, draper 0
3967737 2013350 2013350 defendant Hetth John pinner 587238 587238 Hetth, John, of Stanwell, pinner 1
3967738 2013350 2013350 defendant Sevell Thomas laborer 587238 587238 Sevell, Thomas, of Stanwell, laborer 2
3967739 2013350 2013350 defendant Trowte James butcher 587238 587238 together with Trowte, James, of Stanwell, butcher 3
3967741 2013351 2013351 defendant Osbourne William husbandman 587238 587238 Osbourne, William, of Stanwell, husbandman 0
3967742 2013351 2013351 defendant Osbourne Geoffrey husbandman 587238 587238 Osbourne, Geoffrey, of Stanwell, husbandman 1
4136083 2073246 2073246 defendant Weden Stephen innholder 587238 587238 Weden, Stephen, of Stanwell, innholder 0
4267040 2118617 2118617 defendant Flye Baptista yeoman 587238 587238 Flye, Baptista, of Stanwell, yeoman 0
4354847 2148916 2148916 defendant Woodstock Thomas miller 587238 587238 Woodstock, Thomas, of Stanwell, miller 0
4408826 2167550 2167550 defendant Woodstock Thomas miller 587238 587238 Woodstock, Thomas, of Stanwell, miller 0
4470267 2191351 2191351 defendant Smyth John   587238 587238 Smyth, John, of Stanwell 3
4506293 2202469 2202469 defendant Marche William   587238 587238 Marche, William, of Stanwell 0
4609502 2234075 2234075 defendant Bailly John   587238 587238 Bailly, John, of Stanwell 0
4707316 2267665 2267665 defendant Ayleston John   587238 587238 Ayleston, John, of Stanwell, parson & clerk 0
4722946 2272491 2272491 plaintiff Cranburn John   587238 587238 Cranburn, John, of Stanwell 0
4722948 2272492 2272492 plaintiff Cranburn John   587238 587238 Cranburn, John, of Stanwell 0
4723559 2272671 2272671 defendant Baylly William husbandman 587238 587238 Baylly, William, of Stanwell, husbandman 0
4723561 2272672 2272672 defendant Bailly William husbandman 587238 587238 Bailly, William, of Stanwell, husbandman 0
4730869 2274853 2274853 defendant Aylston Thomas   587238 587238 Aylston, Thomas, of Stanwell, formerly clerk 0
4742475 2278299 2278299 defendant Cateby John yeoman 587238 587238 Cateby, John, of Stanwell, yeoman 0
4868805 2317215 2317215 defendant Best John laborer 587238 587238 Best, John, of Stanwell, laborer 0
4945322 2340513 2340513 defendant Gastener Walter husbandman 587238 587238 Gastener, Walter, of Stanwell, husbandman 0
4964193 2346194 2346194 defendant Best Thomas yeoman 587238 587238 Best, Thomas, of Stanwell, yeoman 0
4964194 2346194 2346194 defendant Rand Simon yeoman 587238 587238 Rand, Simon, of Stanwell, yeoman 1
4964195 2346194 2346194 defendant Taillour Walter yeoman 587238 587238 Taillour, Walter, of Stanwell, yeoman 2
4966836 2347004 2347004 defendant Randes Alice widow 587238 587238 Randes, Alice, of Stanwell, widow 0
5006630 2358839 2358839 defendant Grene Henry yeoman 587238 587238 Grene, Henry, of Stanwell, yeoman 0
5019727 2362651 2362651 defendant Harlok Walter laborer 587238 587238 Harlok, Walter, of Stanwell, laborer 0
5065264 2376151 2376151 defendant Thressher Richard husbandman 587238 587238 Thressher, Richard, of Stanwell, husbandman 0
5065265 2376151 2376151 defendant Tayllour William husbandman 587238 587238 Tayllour, William, of Stanwell, husbandman 1
5065266 2376151 2376151 defendant Pulton Thomas husbandman 587238 587238 Pulton, Thomas, of Stanwell, husbandman 2
5065267 2376151 2376151 defendant Dery John husbandman 587238 587238 Dery, John, of Stanwell, husbandman 3
5074220 2378776 2378776 defendant Bailly Thomas husbandman 587238 587238 Bailly, Thomas, of Stanwell, husbandman 0
5091462 2383890 2383890 defendant Ferour or Smith John mealman 587238 587238 Ferour or Smith, John, of Stanwell, mealman 0
5099052 2386155 2386155 defendant Palmer Thomas husbandman 587238 587238 Palmer, Thomas, of Stanwell, husbandman 0
5126663 2394272 2394272 defendant Becham John yeoman 587238 587238 Becham, John, of sTanwell, yeoman 1
5212108 2419281 2419281 defendant Polton Christine widow 587238 587238 Polton, Christine, of Stanwell, widow 0
5253946 2431350 2431350 defendant Hill John smith 587238 587238 Hill, John, of Stanwell, smith 0
5253948 2431351 2431351 defendant Hill John smith 587238 587238 Hill, John, of Stanwell, smith 0
5283631 2440261 2440261 defendant Pulton Thomas yeoman 587238 587238 Pulton, Thomas, of Stanwell, yeoman 0
5503905 2506137 2506137 plaintiff Wyndesore Thomas (legal representative) 587238 587238 Wyndesore, Thomas, of Stanwell, esq, executors of 0
5593572 2532972 2532972 defendant Mathewe Robert husbandman 587238 587238 Mathewe, Robert, of Stanwell, husbandman 1
5593573 2532972 2532972 defendant Mathewe Edward husbandman 587238 587238 Mathewe, Edward, of Stanwell, husbandman 2
5593574 2532972 2532972 defendant Grenesmyth Robert husbandman 587238 587238 Grenesmyth, Robert, of Stanwell, husbandman 3

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);