names

360 rows where place_id = 587775

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591131 1864848 1864848 defendant Denys John   587775 587775 Denys, John, of Redyng, Berks, cook 1
3591137 1864849 1864849 defendant Denys John   587775 587775 Denys, John, of Redyng, Berks, cook 1
3592401 1865239 1865239 defendant Hille Lawrence chapman 587775 587775 Hille, Lawrence, of Redyng, Berks, chapman 0
3592741 1865343 1865343 defendant Bulfynch Edward chapman 587775 587775 Bulfynch, Edward, of Redyng, Berks, chapman 1
3595179 1866125 1866125 defendant Rede Robert yeoman 587775 587775 Rede, Robert, of Redyng, Berks, yeoman 0
3596287 1866469 1866469 defendant Baker William   587775 587775 Baker, William, of Redyng, Berks, net maker 0
3596310 1866475 1866475 defendant Baker Richard   587775 587775 Baker, Richard, of Redyng, Berks, net maker 1
3596315 1866476 1866476 defendant Baker Richard   587775 587775 Baker, Richard, of Redyng, Berks, net maker 1
3601639 1868168 1868168 defendant Prowe Robert dyer 587775 587775 Prowe, Robert, of Redyng, Berks, dyer 0
3607013 1869857 1869857 defendant Clerk Thomas fuller 587775 587775 Clerk, Thomas, of Redyng, Berks, fuller 1
3607325 1869953 1869953 defendant Gryffyth John fishmonger 587775 587775 Gryffyth, John, of Redyng, Berks, fishmonger 0
3608018 1870160 1870160 defendant Jorden John spicer 587775 587775 Jorden, John, of Redyng, Berks, spicer 4
3612838 1871664 1871664 defendant Sutton Henry weaver 587775 587775 Sutton, Henry, of Redyng, Berks, weaver 2
3612842 1871665 1871665 defendant Hasilwode William brasier 587775 587775 Hasilwode, William, of Redyng, Berks, brasier 1
3614976 1872328 1872328 defendant Laward William chapman 587775 587775 Laward, William, of Redyng, Berks, chapman 3
3614980 1872329 1872329 defendant Laward William chapman 587775 587775 Laward, William, of Redyng, Berks, chapman 2
3614985 1872330 1872330 defendant Laward William chapman 587775 587775 Laward, William, of Redyng, Berks, chapman 2
3617522 1873100 1873100 defendant Prowe Robert merchant 587775 587775 Prowe, Robert, of Redyng, Berks, merchant 0
3617556 1873114 1873114 defendant Prowe Robert merchant 587775 587775 Prowe, Robert, of Redyng, Berks, merchant 0
3619154 1873594 1873594 defendant Hartford William dyer 587775 587775 Hartford, William, of Redyng, Berks, dyer 0
3619422 1873650 1873650 defendant Haselwode William bellfounder 587775 587775 Haselwode, William, of Redyng, Berks, bellfounder 0
3628307 1903715 1903715 defendant Annysley John gent 587775 587775 (Annysley, John, of Redyng, Berks, gent 5
3631651 1904713 1904713 defendant Wryght William shoemaker 587775 587775 (Wryght, William, of Redyng, Berks, shoemaker 1
3633275 1905225 1905225 defendant Vyncent Richard yeoman 587775 587775 Vyncent, Richard, of Redyng, berks, yeoman 0
3637102 1906404 1906404 defendant Scochyn William (legal representative) 587775 587775 Scochyn, William, of Redyng, Berks, clothmaker, executor of 0
3641661 1907849 1907849 defendant White John   587775 587775 White, John, of Redyng, Berks, bell founder 0
3642784 1908191 1908191 defendant Hyllys Christopher fuller 587775 587775 Hyllys, Christopher, of Redyng, Berks, fuller 0
3643328 1908338 1908338 defendant Kelsale Richard fuller 587775 587775 Kelsale, Richard, of Redyng, Berks, fuller 1
3645188 1908904 1908904 defendant Arnold John dyer 587775 587775 Arnold, John, of Redyng, Berks, dyer 0
3646739 1909382 1909382 defendant Saunder Richard chapman 587775 587775 Saunder, Richard, of Redyng, Berks, chapman 0
3646741 1909383 1909383 defendant Saunder Richard chapman 587775 587775 Saunder, Richard, of Redyng, Berks, chapman 0
3649564 1910252 1910252 defendant Blake John butcher 587775 587775 Blake, John, of Redyng, Berks, butcher 1
3650371 1910491 1910491 defendant Best Thomas chapman 587775 587775 Best, Thomas, of Redyng, Berks, chapman 3
3650520 1910531 1910531 defendant Bryll Robert gent 587775 587775 Bryll, Robert, of Redyng, Berks, gent 0
3651326 1910780 1910780 defendant Saunder Richard chapman 587775 587775 Saunder, Richard, of Redyng, Berks, chapman 0
3651331 1910781 1910781 defendant Saunder Richard chapman 587775 587775 Saunder, Richard, of Redyng, Berks, chapman 3
3668191 1915999 1915999 plaintiff Andrewes John fishmonger 587775 587775 Andrewes, John, of Redyng, Berks, fishmonger 0
3671199 1916964 1916964 defendant Rawlyns Robert dyer 587775 587775 Rawlyns, Robert, of Redyng, Berks, dyer 0
3672035 1917254 1917254 defendant Hyde Nicholas chapman 587775 587775 Hyde, Nicholas, of Redyng, Berks, chapman 4
3676312 1918635 1918635 defendant Gregory Joan single woman 587775 587775 Gregory, Joan, of Redyng, Berks, single woman 0
3679168 1919552 1919552 defendant Hossyar Roger draper 587775 587775 Hossyar, Roger, of Redyng, Berks, draper 2
3679174 1919554 1919554 defendant Spekman Christopher butcher 587775 587775 (Spekman, Christopher, of Redyng, Berks, butcher 1
3681054 1920149 1920149 defendant Lesham William clothman 587775 587775 Lesham, William, of Redyng, Berks, clothman 0
3681078 1920160 1920160 defendant Lesham William clothman 587775 587775 Lesham, William, of Redyng, Berks, clothman 0
3687740 1922333 1922333 defendant Barfote John clothmaker 587775 587775 Barfote, John, of Redyng, Berks, clothmaker 0
3688653 1922611 1922611 defendant Davy John dyer 587775 587775 Davy, John, of Redyng, Berks, dyer 0
3690070 1923055 1923055 defendant Hyett Simon gent 587775 587775 Hyett, Simon, of Redyng, Berks, gent 0
3695161 1924707 1924707 defendant Edmondys William gent 587775 587775 Edmondys, William, of Redyng, Berks, gent 1
3698718 1925815 1925815 plaintiff Wattys William mercer 587775 587775 Wattys, William, of Redyng, Berks, mercer 0
3701197 1926620 1926620 defendant Maxfeld Thomas draper 587775 587775 Maxfeld, Thomas, of Redyng, Berks, draper 0
3701200 1926621 1926621 defendant Maxfeld Thomas draper 587775 587775 Maxfeld, Thomas, of Redyng, Berks, draper 0
3701379 1926677 1926677 defendant Dodson Robert dyer 587775 587775 Dodson, Robert, of Redyng, Berks, dyer 3
3701383 1926678 1926678 defendant Dodson Robert dyer 587775 587775 Dodson, Robert, of Redyng, Berks, dyer 2
3703065 1927233 1927233 defendant Baxter Thomas skinner 587775 587775 Baxter, Thomas, of Redyng, Berks, skinner 3
3703267 1927293 1927293 defendant Symond Richard tucker 587775 587775 Symond, Richard, of Redyng, Berks, tucker 0
3703691 1927435 1927435 defendant Avenon Robert weaver 587775 587775 Avenon, Robert, of Redyng, Berks, weaver 0
3704651 1927741 1927741 defendant Whyte John bellfounder 587775 587775 Whyte, John, of Redyng, Berks, bellfounder 0
3720738 1932776 1932776 defendant Russell John yeoman 587775 587775 Russell, John, of Redyng, Berks, yeoman 0
3720747 1932778 1932778 defendant Russell John yeoman 587775 587775 Russell, John, of Redyng, Berks, yeoman 0
3722726 1933374 1933374 defendant Bassett Richard clothman 587775 587775 Bassett, Richard, of Redyng, Berks, clothman 0
3723354 1933573 1933573 defendant Dave William clothier 587775 587775 Dave, William, of Redyng, Berks, clothier 0
3729699 1935542 1935542 plaintiff Bedwell geoffrey   587775 587775 Bedwell, geoffrey, of Redyng, Berks 0
3731413 1936047 1936047 defendant Whyte John   587775 587775 Whyte, John, of Redyng, Berks, bell founder 0
3738612 1938285 1938285 defendant Barfote John clothman 587775 587775 Barfote, John, of Redyng, Berks, clothman 0
3742876 1939626 1939626 defendant Dawson Thomas gent 587775 587775 Dawson, Thomas, of Redyng, Berks, gent 1
3743109 1939700 1939700 plaintiff Wattis William mercer 587775 587775 Wattis, William, of Redyng, Berks, mercer 0
3745907 1940626 1940626 defendant Barfote John clothier 587775 587775 Barfote, John, of Redyng, Berks, clothier 0
3746213 1940723 1940723 defendant Morice John fishmonger 587775 587775 Morice, John, of Redyng, Berks, fishmonger 0
3750897 1942204 1942204 defendant Mores John baker 587775 587775 Mores, John, of Redyng, Berks, baker 0
3751785 1942479 1942479 defendant Blake Robert clothman 587775 587775 Blake, Robert, of Redyng, Berks, clothman 1
3756958 1944154 1944154 defendant Wey Robert capper 587775 587775 Wey, Robert, of Redyng, Berks, capper 0
3767379 1947442 1947442 defendant Hodson Robert chapman 587775 587775 Hodson, Robert, of Redyng, Berks, chapman 3
3767384 1947443 1947443 defendant Hodson Robert chapman 587775 587775 Hodson, Robert, of Redyng, Berks, chapman 3
3777591 1950743 1950743 defendant Barfote John clothier 587775 587775 Barfote, John, of Redyng, Berks, clothier 2
3777613 1950749 1950749 defendant Ellys Robert chapman 587775 587775 Ellys, Robert, of Redyng, Berks, chapman 3
3781923 1952094 1952094 defendant Thorne William   587775 587775 Thorne, William, of Redyng, Berks, yeomam 0
3781925 1952095 1952095 defendant Thorne William   587775 587775 Thorne, William, of Redyng, Berks, yeomam 0
3791825 1955290 1955290 defendant Way William capper 587775 587775 Way, William, of Redyng, Berks, capper 1
3795060 1956319 1956319 defendant Williams David clothier 587775 587775 Williams, David, of Redyng, Berks, clothier 0
3800319 1958017 1958017 defendant Paynter Thomas smith 587775 587775 Paynter, Thomas, of Redyng, Berks, smith 0
3803633 1959050 1959050 defendant White John   587775 587775 White, John, of Redyng, Berks, bell founder 2
3803637 1959051 1959051 defendant Whyte John bellfounder 587775 587775 Whyte, John, of Redyng, Berks, bellfounder 2
3805589 1959690 1959690 defendant Sexton Humphrey yeoman 587775 587775 Sexton, Humphrey, of Redyng, Berks, yeoman 0
3809243 1960771 1960771 defendant Whyte John bellfounder 587775 587775 Whyte, John, of Redyng, Berks, bellfounder 0
3811400 1961461 1961461 defendant White John bellfounder 587775 587775 White, John, of Redyng, Berks, bellfounder 0
3811404 1961462 1961462 defendant White John bellfounder 587775 587775 White, John, of Redyng, Berks, bellfounder 0
3814452 1962434 1962434 defendant Phelippys William butcher 587775 587775 Phelippys, William, of Redyng, Berks, butcher 1
3820456 1964282 1964282 defendant Davy Thomas clothmaker 587775 587775 Davy, Thomas, of Redyng, Berks, clothmaker 0
3821471 1964609 1964609 defendant Kent John clothier 587775 587775 Kent, John, of Redyng, Berks, clothier 1
3822591 1964971 1964971 defendant Cotterell Richard carpenter 587775 587775 Cotterell, Richard, of Redyng, Berks, carpenter 0
3836611 1969353 1969353 defendant Hopton Walter clothier 587775 587775 Hopton, Walter, of Redyng, Berks, clothier 0
3839555 1970295 1970295 defendant Watfford Henry mercer 587775 587775 Watfford, Henry, of Redyng, Berks, mercer 0
3839558 1970296 1970296 defendant Watfford Henry mercer 587775 587775 Watfford, Henry, of Redyng, Berks, mercer 0
3842515 1971190 1971190 defendant Rede alias Skynner John innholder 587775 587775 Rede alias Skynner, John, of Redyng, Berks, innholder 3
3846597 1972488 1972488 defendant Whey William capper 587775 587775 Whey, William, of Redyng, Berks, capper 1
3849229 1973351 1973351 defendant Daye William chapman 587775 587775 Daye, William, of Redyng, Berks, chapman 4
3850480 1973737 1973737 defendant Rede alias Skynner John innholder 587775 587775 Rede alias Skynner, John, of Redyng, Berks, innholder 3
3850601 1973775 1973775 defendant Whyte John bellfounder 587775 587775 Whyte, John, of Redyng, Berks, bellfounder 0
3858911 1976470 1976470 defendant Bukland John baker 587775 587775 Bukland, John, of Redyng, Berks, baker 0
3866906 1979169 1979169 defendant Hopton alias Payn Walter clothier 587775 587775 Hopton alias Payn, Walter, of Redyng, Berks, clothier 0

Next page

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