names

44 rows where place_id = 599102

✎ 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
3635253 1905815 1905815 defendant Cooke William, junior yeoman 599102 599102 Cooke, William, junior, of Brooke, yeoman 0
3688914 1922694 1922694 defendant Kyberde Robert husbandman 599102 599102 Kyberde, Robert, of Brooke, husbandman 0
3720616 1932731 1932731 defendant Wheteacre John weaver 599102 599102 Wheteacre, John, of Brooke, weaver 0
3737973 1938092 1938092 defendant Kybard or Kybert Robert husbandman 599102 599102 Kybard or Kybert, Robert, of Brooke, husbandman 1
3738434 1938227 1938227 defendant Belenger Thomas husbandman 599102 599102 Belenger, Thomas, of Brooke, husbandman 3
3758156 1944538 1944538 defendant Kybard Robert yeoman 599102 599102 Kybard, Robert, of Brooke, yeoman 0
3758157 1944538 1944538 defendant Kybard Thomas husbandman 599102 599102 Kybard, Thomas, of Brooke, husbandman 1
3999945 2024750 2024750 defendant Warde Thomas gent 599102 599102 Warde, Thomas, of Brooke, gent 1
3999959 2024753 2024753 defendant Warde Thomas gent 599102 599102 Warde, Thomas, of Brooke, gent 2
4003594 2026049 2026049 plaintiff Howlett Nicholas   599102 599102 Howlett, Nicholas, of Brooke 0
4003595 2026049 2026049 defendant Fylmyngham Robert gent 599102 599102 Fylmyngham, Robert, of Brooke, gent 0
4059161 2045676 2045676 defendant Barnes Robert husbandman 599102 599102 Barnes, Robert, of Brooke, husbandman 1
4064151 2047454 2047454 defendant Ancell William yeoman 599102 599102 Ancell, William, of Brooke, yeoman 2
4072746 2050553 2050553 defendant Antyll William husbandman 599102 599102 Antyll, William, of Brooke, husbandman 2
4079012 2052792 2052792 defendant Brereton William yeoman 599102 599102 Brereton, William, of Brooke, yeoman 3
4084747 2054816 2054816 defendant Felmyngham Robert gent 599102 599102 Felmyngham, Robert, of Brooke, gent 0
4087070 2055668 2055668 defendant Kent Robert husbandman 599102 599102 Kent, Robert, of Brooke, husbandman 0
4101323 2060776 2060776 defendant ap David Owen yeoman 599102 599102 ap David, Owen, of Brooke, yeoman 0
4108295 2063234 2063234 defendant ap David Owen husbandman 599102 599102 ap David, Owen, of Brooke, husbandman 0
4108296 2063234 2063234 defendant Capper Richard husbandman 599102 599102 Capper, Richard, of Brooke, husbandman 1
4108297 2063234 2063234 defendant Gethyn William husbandman 599102 599102 Gethyn, William, of Brooke, husbandman 2
4108309 2063234 2063234 defendant Gethyn Robert husbandman 599102 599102 Gethyn, Robert, of Brooke, husbandman 14
4113085 2064947 2064947 defendant Bowreman Thomas gent 599102 599102 Bowreman, Thomas, of Brooke, gent 0
4179745 2088388 2088388 defendant ap David Owen yeoman 599102 599102 ap David, Owen, of Brooke, yeoman 1
4201431 2096047 2096047 defendant Burgis Henry yeoman 599102 599102 Burgis, Henry, of Brooke, yeoman 2
4223549 2103727 2103727 defendant Adman Christopher husbandman 599102 599102 Adman, Christopher, of Brooke, husbandman 0
4255246 2114741 2114741 defendant Hales Thomas yeoman 599102 599102 Hales, Thomas, of Brooke, or of Westbury, yeoman 0
4255248 2114742 2114742 defendant Kendall Peter husbandman 599102 599102 Kendall, Peter, of Brooke, weaver, or of Westburye, husbandman 0
4284645 2124559 2124559 defendant Brereton William husbandman 599102 599102 Brereton, William, of Brooke, husbandman 1
4290839 2126779 2126779 defendant Kent Robert husbandman 599102 599102 Kent, Robert, of Brooke, husbandman 3
4310616 2133860 2133860 defendant Tugman Robert yeoman 599102 599102 Tugman, Robert, of Brooke, yeoman 0
4318259 2136494 2136494 defendant Soulthorpe William yeoman 599102 599102 Soulthorpe, William, of Brooke, yeoman 0
4323273 2138201 2138201 defendant Carsey John cooper 599102 599102 Carsey, John, of Brooke, cooper 0
4336594 2142526 2142526 defendant Brame or Braine Thomas   599102 599102 Brame or Braine, Thomas, of Brooke, linen weaver 1
4348794 2146838 2146838 defendant Kent Robert husbandman 599102 599102 Kent, Robert, of Brooke, husbandman 1
4352392 2148073 2148073 defendant Blount Charles   599102 599102 Blount, Charles, of Brooke, knight, Lord Mountjoy 0
4364201 2152253 2152253 defendant Strowde James yeoman 599102 599102 Strowde, James, of brooke, yeoman 0
4390660 2161491 2161491 defendant Kent Robert husbandman 599102 599102 Kent, Robert, of Brooke, husbandman 2
4886263 2322565 2322565 defendant Cheyny Cecily (legal representative) 599102 599102 Cheyny, Cecily, of Brooke, widow of Cheyny, William, knight, executors of 0
4886264 2322565 2322565 defendant Cheyny John esq 599102 599102 (Cheyny, John, of Brooke, esq 1
4886265 2322565 2322565 defendant Mayn John yeoman 599102 599102 Mayn, John, of Brooke, yeoman 2
4935038 2337366 2337366 defendant Tyler Henry husbandman 599102 599102 Tyler, Henry, of Brooke, husbandman 1
5047815 2370963 2370963 plaintiff Pigeon Henry   599102 599102 Pigeon, Henry, of Brooke 0
5314583 2449394 2449394 plaintiff Calfe John   599102 599102 Calfe, John, of Brooke 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);