names

365 rows where place_id = 589014

✎ 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
3595171 1866122 1866122 defendant Capelyn Richard   589014 589014 Capelyn, Richard, of Horsham, bed weaver 2
3596270 1866462 1866462 defendant Neudegate Henry gent 589014 589014 Neudegate, Henry, of Horsham, gent 0
3606645 1869752 1869752 defendant Gere John husbandman 589014 589014 Gere, John, of Horsham, husbandman 0
3615818 1872588 1872588 plaintiff Potter Richard   589014 589014 Potter, Richard, of Horsham 1
3617147 1872986 1872986 defendant Pycard Richard   589014 589014 Pycard, Richard, of Horsham, coverlet maker 3
3619407 1873646 1873646 defendant Tyse William yeoman 589014 589014 Tyse, William, of Horsham, yeoman 0
3627339 1903401 1903401 defendant Hosyer Robert hosier 589014 589014 Hosyer, Robert, of Horsham, hosier 2
3631207 1904585 1904585 defendant A Borowe William   589014 589014 A Borowe, William, of Horsham, wax chandler 4
3643459 1908382 1908382 defendant Rosear Thomas butcher 589014 589014 Rosear, Thomas, of Horsham, butcher 0
3646005 1909144 1909144 defendant Huskyn Ralph hosier 589014 589014 Huskyn, Ralph, of Horsham, hosier 0
3650062 1910387 1910387 defendant Notley Richard tanner 589014 589014 Notley, Richard, of Horsham, tanner 2
3650983 1910677 1910677 plaintiff Somersale John (legal representative) 589014 589014 Somersale, John, of Horsham, executor of 0
3650986 1910678 1910678 plaintiff Somersale John (legal representative) 589014 589014 Somersale, John, of Horsham, executor of 0
3651598 1910856 1910856 defendant Banaster John clerk 589014 589014 Banaster, John, of Horsham, clerk 0
3657246 1912529 1912529 defendant Southtown Richard sheerman 589014 589014 Southtown, Richard, of Horsham, sheerman 1
3678969 1919492 1919492 defendant Carter John husbandman 589014 589014 Carter, John, of Horsham, husbandman 0
3689917 1923005 1923005 defendant Goldryng John   589014 589014 Goldryng, John, of Horsham, brick maker 1
3689918 1923005 1923005 defendant Stroger Robert carpenter 589014 589014 Stroger, Robert, of Horsham, carpenter 2
3693724 1924231 1924231 defendant Roser Thomas butcher 589014 589014 Roser, Thomas, of Horsham, butcher 0
3701606 1926750 1926750 defendant Froyle Richard glover 589014 589014 Froyle, Richard, of Horsham, glover 1
3707296 1928570 1928570 defendant Smalpele Nicholas husbandman 589014 589014 Smalpele, Nicholas, of Horsham, husbandman 4
3707297 1928570 1928570 defendant Chaundeler Thomas husbandman 589014 589014 Chaundeler, Thomas, of Horsham, husbandman 5
3713480 1930528 1930528 defendant Jakey Jaket coller 589014 589014 Jakey, Jaket, of Horsham, coller 1
3718408 1932036 1932036 defendant Woller John husbandman 589014 589014 Woller, John, of Horsham, husbandman 3
3718409 1932036 1932036 defendant Sowten Richard fuller 589014 589014 Sowten, Richard, of Horsham, fuller 4
3718681 1932124 1932124 defendant Pulter Henry husbandman 589014 589014 Pulter, Henry, of Horsham, husbandman 0
3724791 1934038 1934038 defendant Mychell Richard yeoman 589014 589014 Mychell, Richard, of Horsham, yeoman 2
3724792 1934038 1934038 defendant Fuller Simon husbandman 589014 589014 Fuller, Simon, of Horsham, husbandman 3
3729702 1935543 1935543 defendant Woller John glover 589014 589014 Woller, John, of Horsham, glover 0
3731147 1935966 1935966 defendant Cachepoll John smith 589014 589014 Cachepoll, John, of Horsham, smith 1
3739931 1938706 1938706 defendant Snellyng Richard baker 589014 589014 Snellyng, Richard, of Horsham, baker 0
3739932 1938706 1938706 defendant Bedyll John butcher 589014 589014 Bedyll, John, of Horsham, butcher 1
3750960 1942225 1942225 plaintiff Michell Henry (legal representative) 589014 589014 Michell, Henry, of Horsham, yeoman, executrix of 0
3751592 1942412 1942412 defendant Belson Thomas yeoman or butterman 589014 589014 Belson, Thomas, of Horsham, yeoman or butterman 0
3767392 1947446 1947446 plaintiff Mychell Henry (legal representative) 589014 589014 Mychell, Henry, of Horsham, yeoman, executrix of 0
3769088 1947984 1947984 defendant Tyrell Edward butcher 589014 589014 Tyrell, Edward, of Horsham, butcher 0
3779141 1951199 1951199 defendant Goldryng John brickmaker 589014 589014 Goldryng, John, of Horsham, brickmaker 0
3785089 1953122 1953122 defendant Tyllam Percival husbandman 589014 589014 Tyllam, Percival, of Horsham, husbandman 0
3793579 1955854 1955854 defendant Lyndesey John, junior husbandman 589014 589014 Lyndesey, John, junior, of Horsham, husbandman 0
3802971 1958827 1958827 defendant Goddeshalle John chapman 589014 589014 Goddeshalle, John, of Horsham, chapman 0
3810781 1961275 1961275 defendant Deraunt Robert dyer 589014 589014 Deraunt, Robert, of Horsham, dyer 0
3816474 1963059 1963059 defendant Hynkys Roger yeoman 589014 589014 Hynkys, Roger, of Horsham, yeoman 1
3816478 1963060 1963060 defendant Newman John draper 589014 589014 Newman, John, of Horsham, draper 0
3817666 1963428 1963428 defendant Austy William tanner 589014 589014 Austy, William, of Horsham, tanner 0
3817667 1963428 1963428 defendant Jennyns John hosier 589014 589014 Jennyns, John, of Horsham, hosier 1
3836108 1969207 1969207 defendant Derrant Robert dyer 589014 589014 Derrant, Robert, of Horsham, dyer 0
3846088 1972335 1972335 defendant Derraunt Robert dyer 589014 589014 Derraunt, Robert, of Horsham, dyer 0
3857036 1975834 1975834 defendant Rose John baker 589014 589014 Rose, John, of Horsham, baker 0
3857037 1975834 1975834 defendant Cowper John baker 589014 589014 Cowper, John, of Horsham, baker 1
3860535 1977017 1977017 defendant Gesalff John yeoman 589014 589014 Gesalff, John, of Horsham, yeoman 0
3862419 1977625 1977625 defendant Bybell Thomas clerk 589014 589014 Bybell, Thomas, of Horsham, clerk 0
3867042 1979217 1979217 defendant Dikman Peter brasier 589014 589014 Dikman, Peter, of Horsham, brasier 0
3888382 1986375 1986375 defendant Wynston John weaver 589014 589014 Wynston, John, of Horsham, weaver 0
3888383 1986375 1986375 defendant Harman John weaver 589014 589014 Harman, John, of Horsham, weaver 1
3888384 1986375 1986375 defendant Sayers Thomas smith 589014 589014 Sayers, Thomas, of Horsham, smith 2
3890270 1986990 1986990 defendant Michell John yeoman 589014 589014 Michell, John, of Horsham, yeoman 0
3891915 1987550 1987550 plaintiff Lysted Robert draper 589014 589014 Lysted, Robert, of Horsham, draper 0
3893932 1988194 1988194 defendant Ellys William tanner 589014 589014 Ellys, William, of Horsham, tanner 0
3893933 1988194 1988194 defendant Ellys John butcher 589014 589014 Ellys, John, of Horsham, butcher 1
3893934 1988194 1988194 defendant Bottyng John butcher 589014 589014 Bottyng, John, of Horsham, butcher 2
3893935 1988194 1988194 defendant Wryght Thomas husbandman 589014 589014 Wryght, Thomas, of Horsham, husbandman 3
3894111 1988246 1988246 defendant Rede Thomas   589014 589014 Rede, Thomas, of Horsham, worsted weaver 1
3900498 1990397 1990397 defendant Hall John mercer 589014 589014 Hall, John, of Horsham, mercer 0
3900499 1990397 1990397 defendant Godson alias Mighell John laborer 589014 589014 Godson alias Mighell, John, of Horsham, laborer 1
3905149 1991986 1991986 plaintiff Jenkynson John gent 589014 589014 Jenkynson, John, of Horsham, gent 0
3908180 1993033 1993033 defendant Pylfford alias Pylffold Henry yeoman 589014 589014 Pylfford alias Pylffold, Henry, of Horsham, yeoman 0
3914039 1995040 1995040 defendant Gendyn John shoemaker 589014 589014 Gendyn, John, of Horsham, shoemaker 0
3914040 1995040 1995040 defendant Lomasse Christopher husbandman 589014 589014 Lomasse, Christopher, of Horsham, husbandman 1
3914041 1995040 1995040 defendant Hill Robert husbandman 589014 589014 Hill, Robert, of Horsham, husbandman 2
3916776 1995978 1995978 defendant Lusted John yeoman 589014 589014 Lusted, John, of Horsham, yeoman 0
3932803 2001275 2001275 plaintiff Garne Edmund   589014 589014 Garne, Edmund, of Horsham 0
3933384 2001459 2001459 defendant Potter James yeoman 589014 589014 Potter, James, of Horsham, yeoman 0
3933385 2001459 2001459 defendant Amy Thomas tanner 589014 589014 Amy, Thomas, of Horsham, tanner 1
3942121 2004382 2004382 defendant Lyntatt Thomas glover 589014 589014 Lyntatt, Thomas, of Horsham, glover 0
3943933 2004989 2004989 defendant Bradbryge Henry gent 589014 589014 Bradbryge, Henry, of Horsham, gent 1
4033647 2036683 2036683 defendant Burchefolde Henry yeoman 589014 589014 Burchefolde, Henry, of Horsham, yeoman 0
4063870 2047361 2047361 defendant Ellys Thomas yeoman 589014 589014 Ellys, Thomas, of Horsham, yeoman 1
4079580 2052995 2052995 defendant Mooncke Robert mercer 589014 589014 Mooncke, Robert, of Horsham, mercer 0
4100129 2060380 2060380 defendant Bryan Mathew husbandman 589014 589014 Bryan, Mathew, of Horsham, husbandman 1
4121454 2067966 2067966 defendant Forster James yeoman 589014 589014 Forster, James, of Horsham, yeoman 0
4121455 2067966 2067966 defendant Michell Joan widow 589014 589014 together with Michell, Joan, of Horsham, widow 1
4132524 2071948 2071948 defendant Danyell Robert yeoman 589014 589014 Danyell, Robert, of Horsham, yeoman 2
4133554 2072333 2072333 defendant Bowbrowe alias Bowbroke Thomas husbandman 589014 589014 Bowbrowe alias Bowbroke, Thomas, of Horsham, husbandman 0
4139270 2074415 2074415 defendant Burde John husbandman 589014 589014 Burde, John, of Horsham, husbandman 0
4139271 2074415 2074415 defendant Hyll John husbandman 589014 589014 Hyll, John, of Horsham, husbandman 1
4139272 2074415 2074415 defendant Jerrett John laborer 589014 589014 Jerrett, John, of Horsham, laborer 2
4139273 2074415 2074415 defendant Pylfold Henry husbandman 589014 589014 Pylfold, Henry, of Horsham, husbandman 3
4146800 2077034 2077034 defendant Brooke John yeoman 589014 589014 Brooke, John, of Horsham, or of Colthrope, Berks, yeoman 0
4146801 2077034 2077034 defendant Bryghtwell alias Shonck Thomas miller 589014 589014 Bryghtwell alias Shonck, Thomas, of Horsham, or of Brympton, Berks, miller 1
4156051 2080189 2080189 defendant Mylles Thomas yeoman 589014 589014 Mylles, Thomas, of Horsham, yeoman 0
4162916 2082558 2082558 defendant Ball William yeoman 589014 589014 Ball, William, of Horsham, yeoman 2
4164009 2082940 2082940 defendant Praye Hugh yeoman 589014 589014 Praye, Hugh, of Horsham, yeoman 1
4164010 2082940 2082940 defendant Bassett Edward yeoman 589014 589014 Bassett, Edward, of Horsham, yeoman 2
4164011 2082940 2082940 defendant Sampson John yeoman 589014 589014 Sampson, John, of Horsham, yeoman 3
4177468 2087594 2087594 defendant Sarys Thomas yeoman 589014 589014 Sarys, Thomas, of Horsham, yeoman 1
4180455 2088643 2088643 defendant Danyell Robert yeoman 589014 589014 Danyell, Robert, of Horsham, yeoman 2
4187604 2091167 2091167 defendant Ball William miller 589014 589014 Ball, William, of Horsham, miller 1
4187605 2091167 2091167 defendant Dungate Richard yeoman 589014 589014 Dungate, Richard, of Horsham, yeoman 2
4187606 2091167 2091167 defendant Chittie Thomas husbandman 589014 589014 Chittie, Thomas, of Horsham, husbandman 3
4188193 2091374 2091374 defendant Randall Richard yeoman 589014 589014 Randall, Richard, of Horsham, yeoman 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);