names

39 rows where place_id = 589998

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599508 1867487 1867487 defendant Rysby Alice widow 589998 589998 Rysby, Alice, of Haverhyll, widow 2
3599509 1867487 1867487 defendant Perye Henry husbandman 589998 589998 Perye, Henry, of Haverhyll, husbandman 3
3599510 1867487 1867487 defendant Parker John husbandman 589998 589998 Parker, John, of Haverhyll, husbandman 4
3599514 1867488 1867488 defendant Rysby Alice widow 589998 589998 Rysby, Alice, of Haverhyll, widow 2
3599515 1867488 1867488 defendant Perye Henry husbandman 589998 589998 Perye, Henry, of Haverhyll, husbandman 3
3599516 1867488 1867488 defendant Parker John husbandman 589998 589998 Parker, John, of Haverhyll, husbandman 4
3599520 1867489 1867489 defendant Rysby Alice widow 589998 589998 Rysby, Alice, of Haverhyll, widow 2
3599521 1867489 1867489 defendant Perye Henry husbandman 589998 589998 Perye, Henry, of Haverhyll, husbandman 3
3599522 1867489 1867489 defendant Parker John husbandman 589998 589998 Parker, John, of Haverhyll, husbandman 4
3605428 1869364 1869364 defendant Rydnale James yeoman 589998 589998 Rydnale, James, of Haverhyll, yeoman 0
3626808 1903234 1903234 defendant Turnour Henry esq 589998 589998 Turnour, Henry, of Haverhyll, esq 0
3652914 1911237 1911237 defendant Lamberd Margaret widow 589998 589998 Lamberd, Margaret, of Haverhyll, widow 2
3652915 1911237 1911237 defendant Lamberd John   589998 589998 Lamberd, John, of Haverhyll,point maker 3
3663633 1914558 1914558 defendant Cowper Richard cooper 589998 589998 Cowper, Richard, of Haverhyll, cooper 2
3663634 1914558 1914558 defendant Cobyn or Covyn John   589998 589998 Cobyn or Covyn, John, of Haverhyll 3
3664198 1914752 1914752 defendant Overhall William husbandman 589998 589998 Overhall, William, of Haverhyll, husbandman 0
3664199 1914752 1914752 defendant Colyson John weaver 589998 589998 Colyson, John, of Haverhyll, weaver 1
3683687 1921030 1921030 defendant Rednall James sherman 589998 589998 Rednall, James, of Haverhyll, sherman 1
3683688 1921030 1921030 defendant Awger John miller 589998 589998 Awger, John, of Haverhyll, miller 2
3691479 1923490 1923490 defendant Wagge John husbandman 589998 589998 Wagge, John, of Haverhyll, husbandman 2
3716935 1931583 1931583 defendant Awger John husbandman 589998 589998 Awger, John, of Haverhyll, husbandman 4
3750728 1942151 1942151 defendant Pyngyll Thomas tailor 589998 589998 Pyngyll, Thomas, of Haverhyll, tailor 0
3752492 1942704 1942704 defendant Rydnall James fuller 589998 589998 Rydnall, James, of Haverhyll, fuller 0
3752493 1942704 1942704 defendant Creke William husbandman 589998 589998 Creke, William, of Haverhyll, husbandman 1
3774930 1949890 1949890 defendant Harryson Michael fisher 589998 589998 Harryson, Michael, of Haverhyll, fisher 1
3797509 1957113 1957113 defendant Crane Robert sheomaker 589998 589998 Crane, Robert, of Haverhyll, sheomaker 1
3894238 1988291 1988291 plaintiff Reve John (legal representative) 589998 589998 Reve, John, of Haverhyll, clothmaker, administrator of 0
4931363 2336190 2336190 plaintiff Wagge John   589998 589998 Wagge, John, of Haverhyll 0
5380673 2469520 2469520 defendant Rysby William yeoman 589998 589998 Rysby, William, of Haverhyll, yeoman 1
5549055 2519763 2519763 defendant Cornwayll Robert gent 589998 589998 Cornwayll, Robert, of Haverhyll, gent 0
5589730 2531785 2531785 plaintiff Rydnale James (legal representative) 589998 589998 Rydnale, James, of Haverhyll, executor of 0
5589745 2531788 2531788 defendant Lambard John grocer 589998 589998 Lambard, John, of Haverhyll, grocer 0
5589746 2531788 2531788 defendant Carter John shoemaker 589998 589998 Carter, John, of Haverhyll, shoemaker 1
5589760 2531791 2531791 defendant Tye Thomas butcher 589998 589998 Tye, Thomas, of Haverhyll, butcher 2
5589772 2531793 2531793 defendant Cornwall Nicholas gent 589998 589998 Cornwall, Nicholas, of Haverhyll, gent 0
5596703 2533888 2533888 defendant Cornwall Nicholas gent 589998 589998 Cornwall, Nicholas, of Haverhyll, gent 2
5596704 2533888 2533888 defendant Camfeld John laborer 589998 589998 Camfeld, John, of Haverhyll, laborer 3
5626010 2552098 2552098 plaintiff Mayster Roger   589998 589998 Mayster, Roger, of Haverhyll 0
5633857 2554581 2554581 plaintiff Tomesson Roger   589998 589998 Tomesson, Roger, of Haverhyll 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);