names

64 rows where place_id = 593654

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612806 1871655 1871655 defendant Bowyer John tanner 593654 593654 Bowyer, John, of Bray, Berks, tanner 3
3621872 1874382 1874382 defendant Staverton Henry gent 593654 593654 Staverton, Henry, of Bray, Berks, gent 3
3632455 1904967 1904967 defendant Heyward John   593654 593654 Heyward, John, of Bray, Berks, bargemen 1
3697318 1925383 1925383 defendant Bedyll Henry husbandman 593654 593654 Bedyll, Henry, of Bray, Berks, husbandman 2
3725667 1934313 1934313 defendant Logan Robert yeoman 593654 593654 Logan, Robert, of Bray, Berks, yeoman 0
3739090 1938437 1938437 defendant Grove John yeoman 593654 593654 Grove, John, of Bray, Berks, yeoman 0
3770405 1948421 1948421 defendant Grove John, senior yeoman 593654 593654 Grove, John, senior, of Bray, Berks, yeoman 0
3771082 1948645 1948645 defendant Grove John, senior husbandman 593654 593654 Grove, John, senior, of Bray, Berks, husbandman 1
3782172 1952176 1952176 defendant Horethorne Henry husbandman 593654 593654 Horethorne, Henry, of Bray, Berks, husbandman 0
3800323 1958017 1958017 defendant Bower Thomas bargeman 593654 593654 Bower, Thomas, of Bray, Berks, bargeman 4
3964280 2012112 2012112 defendant Cowper Silvester gent 593654 593654 Cowper, Silvester, of Bray, Berks, gent 0
3964282 2012113 2012113 defendant Wescotte Thomas yeoman 593654 593654 Wescotte, Thomas, of Bray, Berks, yeoman 0
4030437 2035543 2035543 defendant Weldon Edward gent 593654 593654 Weldon, Edward, of Bray, Berks, gent 0
4072901 2050604 2050604 defendant Cowper Silvester gent 593654 593654 Cowper, Silvester, of Bray, Berks, gent 0
4124303 2068984 2068984 defendant Thacham Nicholas yeoman 593654 593654 Thacham, Nicholas, of Bray, Berks, yeoman 1
4195677 2094043 2094043 defendant Page Arthur gent 593654 593654 Page, Arthur, of Bray, Berks, gent 0
4259166 2116041 2116041 defendant Wilk John carpenter 593654 593654 Wilk, John, of Bray, berks, carpenter 0
4294475 2128110 2128110 defendant Hall or Hawle Richard yeoman 593654 593654 Hall or Hawle, Richard, of Bray, Berks, yeoman 1
4392501 2162113 2162113 defendant Wynche Robert yeoman 593654 593654 Wynche, Robert, of Bray, Berks, yeoman 0
4670686 2256513 2256513 defendant Symmes John husbandman 593654 593654 Symmes, John, of Bray, Berks, husbandman 2
4670692 2256514 2256514 defendant Symmes John husbandman 593654 593654 Symmes, John, of Bray, Berks, husbandman 2
4695528 2264084 2264084 defendant Wade Stephen husbandman 593654 593654 Wade, Stephen, of Bray, Berks, husbandman 0
4764302 2284831 2284831 defendant Sape Walter gent 593654 593654 (Sape, Walter, of Bray, Berks, gent 2
4779288 2289502 2289502 defendant Westwode John   593654 593654 Westwode, John, of Bray, Berks, yeoman, rent collector in Bray 0
4779290 2289503 2289503 defendant Westwode John   593654 593654 Westwode, John, of Bray, Berks, yeoman, rent collector in Bray 0
4833173 2306387 2306387 defendant Stafforton Walter esq 593654 593654 Stafforton, Walter, of Bray, Berks, esq 0
4877812 2320024 2320024 defendant Staverton William esq 593654 593654 Staverton, William, of Bray, Berks, esq 2
4877817 2320025 2320025 defendant Staverton William esq 593654 593654 Staverton, William, of Bray, Berks, esq 2
4931641 2336285 2336285 defendant Staverton William gent 593654 593654 Staverton, William, of Bray, Berks, gent 0
4948284 2341441 2341441 defendant Forsterr Richard gent 593654 593654 Forsterr, Richard, of Bray, Berks, gent 0
4983117 2351854 2351854 defendant Staverton William esq 593654 593654 Staverton, William, of Bray, Berks, esq 2
5034966 2367085 2367085 defendant Dauntre William gent 593654 593654 Dauntre, William, of Bray, Berks, gent 4
5041936 2369187 2369187 defendant Strygot William husbandman 593654 593654 Strygot, William, of Bray, Berks, husbandman 2
5046467 2370584 2370584 defendant Forster Richard gent 593654 593654 Forster, Richard, of Bray, Berks, gent 0
5066715 2376574 2376574 defendant Norys John esq 593654 593654 (Norys, John, of Bray, Berks, esq 1
5113072 2390217 2390217 defendant Staverton William gent 593654 593654 Staverton, William, of Bray, Berks, gent 0
5221626 2422021 2422021 defendant Shyre Thomas husbandman 593654 593654 Shyre, Thomas, of Bray, Berks, husbandman 3
5222074 2422158 2422158 defendant Clopton Richard husbandman 593654 593654 Clopton, Richard, of Bray, Berks, husbandman 1
5225637 2423170 2423170 defendant Staverton William esq 593654 593654 Staverton, William, of Bray, Berks, esq 2
5236177 2426168 2426168 defendant Foweler Robert gent 593654 593654 Foweler, Robert, of Bray, Berks, gent 0
5236179 2426169 2426169 defendant Foweler Robert gent 593654 593654 Foweler, Robert, of Bray, Berks, gent 0
5253441 2431179 2431179 defendant Crichefeld John yeoman 593654 593654 Crichefeld, John, of Bray, Berks, yeoman 1
5273383 2437284 2437284 defendant Moreys William   593654 593654 Moreys, William, of Bray, Berks, vicar 0
5299564 2444845 2444845 defendant Inglyssh William gent 593654 593654 Inglyssh, William, of Bray, Berks, gent 3
5438741 2486515 2486515 defendant Wynche Robert husbandman 593654 593654 Wynche, Robert, of Bray, Berks, husbandman 0
5452646 2490675 2490675 defendant Wynche Robert husbandman 593654 593654 Wynche, Robert, of Bray, Berks, husbandman 0
5476096 2497863 2497863 defendant Wynche (illegible) husbandman 593654 593654 Wynche, _, of Bray, Berks, husbandman 0
5487578 2501177 2501177 defendant Wynche Robert husbandman 593654 593654 Wynche, Robert, of Bray, Berks, husbandman 0
5492887 2502782 2502782 defendant Fouler Robert gent 593654 593654 Fouler, Robert, of Bray, Berks, gent 0
5540600 2517189 2517189 defendant Staverton Humphrey esq 593654 593654 Staverton, Humphrey, of Bray, Berks, esq 0
5562019 2523494 2523494 defendant Brachet Thomas yeoman 593654 593654 Brachet, Thomas, of Bray, Berks, yeoman 3
5562032 2523496 2523496 defendant Wattys Richard clerk 593654 593654 Wattys, Richard, of Bray, Berks, clerk 0
5567636 2525106 2525106 defendant Wattys Richard clerk 593654 593654 Wattys, Richard, of Bray, Berks, clerk 3
5569271 2525571 2525571 defendant Webbe John chapman 593654 593654 Webbe, John, of Bray, Berks, chapman 0
5571280 2526162 2526162 defendant Orme William clerk 593654 593654 Orme, William, of Bray, Berks, clerk 1
5580524 2528998 2528998 defendant Heyward John (legal representative) 593654 593654 Heyward, John, of Bray, Berks, husbandman, executor of 0
5580531 2528999 2528999 defendant Maunce Thomas carpenter 593654 593654 Maunce, Thomas, of Bray, Berks, carpenter 0
5580581 2529007 2529007 defendant Staverton Henry (legal representative) 593654 593654 Staverton, Henry, of Bray, Berks, gent, executors of 0
5586776 2530905 2530905 defendant Halle John clerk 593654 593654 Halle, John, of Bray, Berks, clerk 1
5601105 2535233 2535233 defendant Mayncy Thomas carpenter 593654 593654 Mayncy, Thomas, of Bray, Berks, carpenter 0
5601107 2535234 2535234 defendant Mauncy Thomas carpenter 593654 593654 Mauncy, Thomas, of Bray, Berks, carpenter 0
5601109 2535235 2535235 defendant Mauncy Thomas carpenter 593654 593654 Mauncy, Thomas, of Bray, Berks, carpenter 0
5627211 2552476 2552476 defendant Medowecroft Robert yeoman 593654 593654 Medowecroft, Robert, of Bray, Berks, yeoman 0
5627213 2552477 2552477 defendant Medowecroft Robert yeoman 593654 593654 Medowecroft, Robert, of Bray, Berks, yeoman 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);