names

46 rows where place_id = 608267

✎ 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
3672936 1917548 1917548 defendant Haccher John husbandman 608267 608267 Haccher, John, of Worthe, husbandman 0
3672937 1917548 1917548 defendant Rowhoke William husbandman 608267 608267 Rowhoke, William, of Worthe, husbandman 1
3672938 1917548 1917548 defendant Slawterford Thomas laborer 608267 608267 Slawterford, Thomas, of Worthe, laborer 2
3713308 1930473 1930473 defendant Bartelott William husbandman 608267 608267 Bartelott, William, of Worthe, husbandman 0
3764873 1946680 1946680 plaintiff Jenkyn Nicholas   608267 608267 Jenkyn, Nicholas, of Worthe 0
3788580 1954227 1954227 defendant Browne John husbandman 608267 608267 Browne, John, of Worthe, husbandman 1
3819156 1963878 1963878 defendant Erle Thomas husbandman 608267 608267 Erle, Thomas, of Worthe, husbandman 2
3922351 1997791 1997791 defendant Haccher John husbandman 608267 608267 Haccher, John, of Worthe, husbandman 0
3947493 2006195 2006195 defendant Monke John shoemaker 608267 608267 Monke, John, of Worthe, shoemaker 2
4000394 2024908 2024908 defendant Rede John yeoman 608267 608267 Rede, John, of Worthe, yeoman 3
4004964 2026557 2026557 plaintiff Karsefeld Thomas yeoman 608267 608267 Karsefeld, Thomas, of Worthe, yeoman 0
4055715 2044431 2044431 plaintiff Bloxon or Blackstone Richard foyster or forester 608267 608267 Bloxon or Blackstone, Richard, of Worthe, foyster or forester 0
4055716 2044431 2044431 defendant Hunt Thomas forester 608267 608267 Hunt, Thomas, of Worthe, forester 0
4122455 2068340 2068340 defendant Bryan John, senior yeoman 608267 608267 Bryan, John, senior, of Worthe, yeoman 0
4122456 2068340 2068340 defendant Nycholas Henry yeoman 608267 608267 Nycholas, Henry, of Worthe, yeoman 1
4122457 2068340 2068340 defendant Nicholas Edward yeoman 608267 608267 Nicholas, Edward, of Worthe, yeoman 2
4122459 2068341 2068341 defendant Byshe John   608267 608267 Byshe, John, of Worthe, gent, son of John Byshe, senior, and Katherine 0
4122461 2068342 2068342 defendant Byshe John   608267 608267 Byshe, John, of Worthe, gent, son of John senior and Katherine 0
4130817 2071332 2071332 defendant Gere Drew husbandman 608267 608267 Gere, Drew, of Worthe, husbandman 0
4213857 2100366 2100366 defendant Aburley John   608267 608267 Aburley, John, of Worthe, bellows maker 0
4213858 2100366 2100366 defendant Gateland Richard husbandman 608267 608267 Gateland, Richard, of Worthe, husbandman 1
4235146 2107851 2107851 defendant Banyster Thomas husbandman 608267 608267 Banyster, Thomas, of Worthe, husbandman 0
4235148 2107852 2107852 defendant Waters Richard yeoman 608267 608267 Waters, Richard, of Worthe, yeoman 0
4253553 2114178 2114178 defendant Hunt Thomas husbandman 608267 608267 Hunt, Thomas, of Worthe, husbandman 1
4277426 2122026 2122026 defendant Page Andrew clothier 608267 608267 Page, Andrew, of Worthe, or of Ixworthe, clothier 0
4360358 2150873 2150873 defendant Nicholas Thomas yeoman 608267 608267 Nicholas, Thomas, of Worthe, yeoman 0
4379312 2157681 2157681 defendant Cooke Nicholas yeoman 608267 608267 Cooke, Nicholas, of Worthe, yeoman 1
4683925 2260583 2260583 defendant Baron Robert husbandman 608267 608267 Baron, Robert, of Worthe, husbandman 0
4696462 2264369 2264369 defendant Bakere Thomas husbandman 608267 608267 Bakere, Thomas, of Worthe, husbandman 0
4707366 2267679 2267679 defendant Webbe Richard clerk 608267 608267 Webbe, Richard, of Worthe, clerk 5
4810590 2299462 2299462 defendant Webbe Richard clerk 608267 608267 Webbe, Richard, of Worthe, clerk 0
4858787 2314123 2314123 defendant Harry Christine singlewoman 608267 608267 Harry, Christine, of Worthe, singlewoman 2
4871758 2318136 2318136 defendant Harry Richard husbandman 608267 608267 Harry, Richard, of Worthe, husbandman 0
5027060 2364784 2364784 defendant Borle John tanner 608267 608267 Borle, John, of Worthe, tanner 0
5027062 2364785 2364785 defendant Borle John tanner 608267 608267 Borle, John, of Worthe, tanner 0
5097118 2385590 2385590 defendant Parker William husbandman 608267 608267 Parker, William, of Worthe, husbandman 0
5097119 2385590 2385590 defendant Parker Richard husbandman 608267 608267 Parker, Richard, of Worthe, husbandman 1
5115810 2391049 2391049 defendant atte Gate John yeoman 608267 608267 atte Gate, John, of Worthe, yeoman 2
5115811 2391049 2391049 defendant Maynard Thomas yeoman 608267 608267 Maynard, Thomas, of Worthe, yeoman 3
5143665 2399280 2399280 defendant Elys John husbandman 608267 608267 Elys, John, of Worthe, husbandman 1
5263744 2434413 2434413 defendant Nicholas Alice widow 608267 608267 Nicholas, Alice, of Worthe, widow 1
5263750 2434415 2434415 defendant Nicholas Alice widow 608267 608267 Nicholas, Alice, of Worthe, widow 1
5318103 2450504 2450504 defendant Worthe Thomas gent 608267 608267 Worthe, Thomas, of Worthe, gent 0
5328415 2453575 2453575 defendant Topsyll William husbandman 608267 608267 Topsyll, William, of Worthe, husbandman 1
5501654 2505449 2505449 defendant Garard Thomas, junior laborer 608267 608267 Garard, Thomas, junior, of Worthe, laborer 0
5501655 2505449 2505449 defendant Garard Richard laborer 608267 608267 Garard, Richard, of Worthe, laborer 1

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