names

74 rows where place_id = 653372

✎ 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
3928296 1999800 1999800 defendant Carpender James yeoman 653372 653372 Carpender, James, of Kynnersley, yeoman 0
3934551 2001849 2001849 defendant Pycher Henry husbandman 653372 653372 Pycher, Henry, of Kynnersley, husbandman 0
3934552 2001849 2001849 defendant Pycher John husbandman 653372 653372 Pycher, John, of Kynnersley, husbandman 1
3941268 2004084 2004084 defendant Lewes Richard husbandman 653372 653372 Lewes, Richard, of Kynnersley, husbandman 0
3961990 2011291 2011291 defendant Mathew Richard husbandman 653372 653372 Mathew, Richard, of Kynnersley, husbandman 0
3961991 2011291 2011291 defendant Mathew David husbandsman 653372 653372 Mathew, David, of Kynnersley, husbandsman 1
3961992 2011291 2011291 defendant Mathew John husbandman 653372 653372 Mathew, John, of Kynnersley, husbandman 2
3961993 2011291 2011291 defendant Mathewe Margaret widow 653372 653372 Mathewe, Margaret, of Kynnersley, widow 3
3987496 2020276 2020276 defendant Pytcher Augustine yeoman 653372 653372 Pytcher, Augustine, of Kynnersley, yeoman 0
4021557 2032436 2032436 plaintiff Wysham Walter gent 653372 653372 Wysham, Walter, of Kynnersley, gent 0
4022240 2032681 2032681 defendant Vaughan James gent or yeoman 653372 653372 Vaughan, James, of Kynnersley, gent or yeoman 0
4022965 2032934 2032934 defendant Kedward John yeoman 653372 653372 Kedward, John, of Kynnersley, yeoman 0
4061286 2046442 2046442 defendant Hopley Thomas yeoman 653372 653372 Hopley, Thomas, of Kynnersley, yeoman 1
4069394 2049336 2049336 defendant Heynes John husbandman 653372 653372 Heynes, John, of Kynnersley, husbandman 0
4072680 2050528 2050528 defendant Clare John yeoman 653372 653372 Clare, John, of Kynnersley, yeoman 0
4072796 2050570 2050570 defendant Phillpott Miles yeoman 653372 653372 Phillpott, Miles, of Kynnersley, or of Newchirche, yeoman 1
4079902 2053113 2053113 defendant Hall Thomas tailor 653372 653372 Hall, Thomas, of Kynnersley, tailor 0
4081151 2053569 2053569 defendant Mellyn Katherine widow 653372 653372 Mellyn, Katherine, of Kynnersley, widow 0
4092460 2057606 2057606 defendant Hill John husbandman 653372 653372 Hill, John, of Kynnersley, husbandman 0
4099601 2060186 2060186 defendant Hall John yeoman 653372 653372 Hall, John, of Kynnersley, yeoman 0
4102894 2061329 2061329 defendant Lewys John gent 653372 653372 Lewys, John, of Kynnersley, or of Newton, Herefs, gent 0
4107033 2062812 2062812 defendant Hopley Thomas yeoman 653372 653372 Hopley, Thomas, of Kynnersley, yeoman 0
4113761 2065207 2065207 defendant Watson Robert clerk 653372 653372 Watson, Robert, of Kynnersley, clerk 0
4113762 2065207 2065207 defendant Carswell Thomas yeoman 653372 653372 Carswell, Thomas, of Kynnersley, yeoman 1
4113763 2065207 2065207 defendant Hooper John yeoman 653372 653372 Hooper, John, of Kynnersley, yeoman 2
4113764 2065207 2065207 defendant Bell John yeoman 653372 653372 Bell, John, of Kynnersley, yeoman 3
4113765 2065207 2065207 defendant Cornes Margery widow 653372 653372 Cornes, Margery, of Kynnersley, widow 4
4113766 2065207 2065207 defendant Symond John yeoman 653372 653372 Symond, John, of Kynnersley, yeoman 5
4113767 2065207 2065207 defendant Harper alias Henson John yeoman 653372 653372 Harper alias Henson, John, of Kynnersley, yeoman 6
4113768 2065207 2065207 defendant Symond Richard yeoman 653372 653372 Symond, Richard, of Kynnersley, yeoman 7
4118703 2066981 2066981 defendant Lewys John gent 653372 653372 Lewys, John, of Kynnersley, gent 2
4142185 2075445 2075445 defendant Parker Walter husbandman 653372 653372 Parker, Walter, of Kynnersley, husbandman 1
4143661 2075938 2075938 defendant Hooper William hooper 653372 653372 Hooper, William, of Kynnersley, hooper 4
4144509 2076241 2076241 defendant Kedward John yeoman 653372 653372 Kedward, John, of Kynnersley, yeoman 1
4145677 2076641 2076641 defendant Rogers Thomas yeoman 653372 653372 Rogers, Thomas, of Kynnersley, yeoman 1
4163391 2082724 2082724 defendant Watson Robert clerk 653372 653372 Watson, Robert, of Kynnersley, clerk 0
4163392 2082724 2082724 defendant Carswell Thomas yeoman 653372 653372 Carswell, Thomas, of Kynnersley, yeoman 1
4163393 2082724 2082724 defendant Hooper John yeoman 653372 653372 Hooper, John, of Kynnersley, yeoman 2
4163395 2082724 2082724 defendant Symond Richard yeoman 653372 653372 Symond, Richard, of Kynnersley, yeoman 4
4163397 2082725 2082725 defendant Watson Robert clerk 653372 653372 Watson, Robert, of Kynnersley, clerk 0
4163399 2082725 2082725 defendant Caresenall Thomas husbandman 653372 653372 Caresenall, Thomas, of Kynnersley, husbandman 2
4163400 2082725 2082725 defendant Harper alias Hynson John husbandman 653372 653372 Harper alias Hynson, John, of Kynnersley, husbandman 3
4163401 2082725 2082725 defendant Harper Roger husbandman 653372 653372 Harper, Roger, of Kynnersley, husbandman 4
4163402 2082725 2082725 defendant Symons Richard husbandman 653372 653372 Symons, Richard, of Kynnersley, husbandman 5
4163403 2082725 2082725 defendant Symons John husbandman 653372 653372 Symons, John, of Kynnersley, husbandman 6
4163404 2082725 2082725 defendant Bell John husbandman 653372 653372 Bell, John, of Kynnersley, husbandman 7
4163405 2082725 2082725 defendant Bell William husbandman 653372 653372 Bell, William, of Kynnersley, husbandman 8
4163406 2082725 2082725 defendant Hooper John husbandman 653372 653372 Hooper, John, of Kynnersley, husbandman 9
4163407 2082725 2082725 defendant Gravener Reginald husbandman 653372 653372 Gravener, Reginald, of Kynnersley, husbandman 10
4163408 2082725 2082725 defendant Hooper William husbandman 653372 653372 Hooper, William, of Kynnersley, husbandman 11
4163409 2082725 2082725 defendant trustram William husbandman 653372 653372 trustram, William, of Kynnersley, husbandman 12
4163410 2082725 2082725 defendant Leeche John, senior husbandman 653372 653372 Leeche, John, senior, of Kynnersley, husbandman 13
4163411 2082725 2082725 defendant Leeche John, junior husbandman 653372 653372 Leeche, John, junior, of Kynnersley, husbandman 14
4163412 2082725 2082725 defendant Watson John husbandman 653372 653372 Watson, John, of Kynnersley, husbandman 15
4172646 2085893 2085893 defendant Carpynter alias Shere John yeoman 653372 653372 Carpynter alias Shere, John, of Kynnersley, yeoman 0
4172647 2085893 2085893 defendant Walle Richard husbandman 653372 653372 Walle, Richard, of Kynnersley, husbandman 1
4218163 2101854 2101854 defendant ap David Humphrey yeoman 653372 653372 ap David, Humphrey, of Kynnersley, yeoman 0
4218164 2101854 2101854 defendant ap Humfrey John   653372 653372 ap Humfrey, John, of Kynnersley, yeoman, his son 1
4232500 2106872 2106872 defendant Bryan John yeoman 653372 653372 Bryan, John, of Kynnersley, yeoman 0
4233014 2107054 2107054 defendant Eccley Roger husbandman 653372 653372 Eccley, Roger, of Kynnersley, husbandman 1
4243288 2110745 2110745 defendant Vaughan Richard gent 653372 653372 Vaughan, Richard, of Kynnersley, gent 3
4281630 2123481 2123481 defendant Lewis John gent 653372 653372 Lewis, John, of Kynnersley, gent 2
4323612 2138314 2138314 defendant Wellington Roger yeoman 653372 653372 Wellington, Roger, of Kynnersley, yeoman 0
4323613 2138314 2138314 defendant Mathewes John (legal representative) 653372 653372 Mathewes, John, of Kynnersley, gent, executor of 1
4323675 2138333 2138333 defendant ap Evan David yeoman 653372 653372 ap Evan, David, of Kynnersley, yeoman 0
4355667 2149205 2149205 defendant Gregorye Hugh miller 653372 653372 Gregorye, Hugh, of Kynnersley, miller 0
4355668 2149205 2149205 defendant Casewall Robert yeoman 653372 653372 Casewall, Robert, of Kynnersley, yeoman 1
4355669 2149205 2149205 defendant Gregorye Ralph yeoman 653372 653372 Gregorye, Ralph, of Kynnersley, or of Kliderissa, Montgomery, yeoman 2
4379770 2157860 2157860 defendant Gregorye Hugh miller 653372 653372 Gregorye, Hugh, of Kynnersley, miller 0
4379771 2157860 2157860 defendant Casewall Robert yeoman 653372 653372 Casewall, Robert, of Kynnersley, yeoman 1
4379772 2157860 2157860 defendant Gregorye Ralph yeoman 653372 653372 Gregorye, Ralph, of Kynnersley, or of Klyber Issa, Montgomery, yeoman 2
4403546 2165759 2165759 defendant Carswell John yeoman 653372 653372 Carswell, John, of Kynnersley, yeoman 2
4966977 2347053 2347053 defendant Melyn John carpenter 653372 653372 Melyn, John, of Kynnersley, carpenter 1
5579773 2528753 2528753 defendant Dotycote William clerk 653372 653372 Dotycote, William, of Kynnersley, clerk 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);