names

99 rows where place_id = 591742

✎ 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
3605399 1869356 1869356 defendant Harvust John dyer 591742 591742 Harvust, John, of Petworth, Sussex, dyer 0
3645844 1909104 1909104 defendant Kyrby John yeoman 591742 591742 Kyrby, John, of Petworth, Sussex, yeoman 2
3648957 1910061 1910061 defendant Twychener Roger clothmaker 591742 591742 Twychener, Roger, of Petworth, Sussex, clothmaker 1
3660847 1913660 1913660 defendant Portbury Thomas yeoman 591742 591742 Portbury, Thomas, of Petworth, Sussex, yeoman 0
3679133 1919541 1919541 defendant Bowyer William clothier 591742 591742 Bowyer, William, of Petworth, Sussex, clothier 2
3703797 1927467 1927467 defendant Twychenor Roger clothmaker 591742 591742 Twychenor, Roger, of Petworth, Sussex, clothmaker 0
3723360 1933574 1933574 defendant Twychener Roger clothmaker 591742 591742 Twychener, Roger, of Petworth, Sussex, clothmaker 2
3756557 1944029 1944029 defendant Yonge William clothier 591742 591742 (Yonge, William, of Petworth, Sussex, clothier 1
3766904 1947315 1947315 defendant Gobill Henry merchant 591742 591742 Gobill, Henry, of Petworth, Sussex, merchant 3
3785948 1953403 1953403 defendant Bowyer William clothmaker 591742 591742 Bowyer, William, of Petworth, Sussex, clothmaker 0
3826588 1966165 1966165 defendant Heth Robert clothier 591742 591742 Heth, Robert, of Petworth, Sussex, clothier 0
3869127 1979922 1979922 defendant Bowyer Richard yeoman 591742 591742 Bowyer, Richard, of Petworth, Sussex, yeoman 0
3883009 1984581 1984581 defendant Edderton John baker 591742 591742 Edderton, John, of Petworth, Sussex, baker 4
3912801 1994614 1994614 defendant Humfrey John clothier 591742 591742 Humfrey, John, of Petworth, Sussex, clothier 0
3926268 1999108 1999108 defendant Mores John yeoman 591742 591742 Mores, John, of Petworth, Sussex, yeoman 3
3937238 2002787 2002787 defendant Lewkenour Anthony esq 591742 591742 Lewkenour, Anthony, of Petworth, sussex, esq 0
3937420 2002850 2002850 defendant Ukley William chapman 591742 591742 Ukley, William, of Petworth, Sussex, chapman 0
3941125 2004034 2004034 defendant Yonge John gent 591742 591742 Yonge, John, of Petworth, Sussex, gent 2
3942852 2004613 2004613 defendant Beesse or Beeffe William yeoman 591742 591742 Beesse or Beeffe, William, of Petworth, Sussex, yeoman 0
3945146 2005395 2005395 defendant Telyng Thomas chapman 591742 591742 Telyng, Thomas, of Petworth, Sussex, chapman 5
3946276 2005774 2005774 defendant Telyng Thomas chapman 591742 591742 Telyng, Thomas, of Petworth, Sussex, chapman 3
3967297 2013195 2013195 defendant Rale Thomas tailor 591742 591742 Rale, Thomas, of Petworth, Sussex, tailor 0
3975902 2016135 2016135 defendant Trurgys Richard chapman 591742 591742 Trurgys, Richard, of Petworth, Sussex, chapman 0
3977932 2016854 2016854 defendant Kynge Edward clothier 591742 591742 Kynge, Edward, of Petworth, Sussex, clothier 0
3992446 2022064 2022064 defendant Turgus Thomas chapman 591742 591742 Turgus, Thomas, of Petworth, Sussex, chapman 0
4017485 2030957 2030957 defendant Frye John chapman 591742 591742 Frye, John, of Petworth, Sussex, chapman 2
4020987 2032231 2032231 defendant Balle Thomas tailor 591742 591742 Balle, Thomas, of Petworth, Sussex, tailor 2
4026483 2034118 2034118 defendant Turges Richard yeoman 591742 591742 Turges, Richard, of Petworth, Sussex, yeoman 0
4046413 2041164 2041164 defendant Feven John mercer 591742 591742 Feven, John, of Petworth, Sussex, mercer 2
4051459 2042942 2042942 defendant Gobell Richard yeoman 591742 591742 Gobell, Richard, of Petworth, Sussex, yeoman 2
4051463 2042943 2042943 defendant Gobell Richard yeoman 591742 591742 Gobell, Richard, of Petworth, Sussex, yeoman 2
4055599 2044392 2044392 plaintiff Blackwell Thomas (legal representative) 591742 591742 Blackwell, Thomas, of Petworth, Sussex, gent, executrix of 0
4079096 2052825 2052825 defendant Telyng William tailor 591742 591742 Telyng, William, of Petworth, Sussex, tailor 0
4093236 2057899 2057899 defendant Start Arnold clothier 591742 591742 Start, Arnold, of Petworth, Sussex, clothier 0
4101921 2060999 2060999 defendant Hobbes William gent 591742 591742 Hobbes, William, of Petworth, Sussex, gent 0
4164745 2083180 2083180 defendant Smyth John yeoman 591742 591742 Smyth, John, of Petworth, Sussex, yeoman 0
4190490 2092231 2092231 defendant Tompson Thomas chapman 591742 591742 Tompson, Thomas, of Petworth, Sussex, chapman 1
4208072 2098383 2098383 defendant Shorter John chapman 591742 591742 Shorter, John, of Petworth, Sussex, chapman 1
4233613 2107280 2107280 defendant Shatcher William butcher 591742 591742 Shatcher, William, of Petworth, Sussex, butcher 0
4258852 2115930 2115930 defendant Turgys Edward   591742 591742 Turgys, Edward, of Petworth, Sussex, tallow chandler 1
4258855 2115931 2115931 defendant Turgys Edward   591742 591742 Turgys, Edward, of Petworth, Sussex, tallow chandler 1
4277517 2122059 2122059 defendant Kelton Thomas gent 591742 591742 Kelton, Thomas, of Petworth, Sussex, gent 0
4313020 2134677 2134677 defendant Shatcher William butcher 591742 591742 Shatcher, William, of Petworth, Sussex, butcher 0
4335729 2142229 2142229 defendant Ramesden John chapman 591742 591742 Ramesden, John, of Petworth, Sussex, chapman 0
4346478 2146017 2146017 defendant Wyseden Thomas gent 591742 591742 Wyseden, Thomas, of Petworth, Sussex, gent 0
4348536 2146740 2146740 defendant Kelton Thomas gent 591742 591742 Kelton, Thomas, of Petworth, Sussex, gent 0
4349350 2147034 2147034 defendant Kelton Thomas gent 591742 591742 Kelton, Thomas, of Petworth, Sussex, gent 0
4361078 2151129 2151129 defendant Warner Morgan chapman 591742 591742 Warner, Morgan, of Petworth, Sussex, chapman 3
4363325 2151954 2151954 defendant Kelton Thomas gent 591742 591742 Kelton, Thomas, of Petworth, Sussex, gent 0
4366139 2152931 2152931 defendant Breton George gent 591742 591742 Breton, George, of Petworth, Sussex, gent 0
4374558 2155958 2155958 defendant Ireland Richard yeoman 591742 591742 Ireland, Richard, of Petworth, Sussex, yeoman 0
4391647 2161823 2161823 defendant Kelton Thomas esq 591742 591742 Kelton, Thomas, of Petworth, Sussex, esq 0
4760305 2283576 2283576 defendant Baldewyn Robert chapman 591742 591742 Baldewyn, Robert, of Petworth, Sussex, chapman 0
4767210 2285729 2285729 defendant Baldewyn Robert chapman 591742 591742 Baldewyn, Robert, of Petworth, Sussex, chapman 0
4794878 2294543 2294543 defendant Baldewyn Robert chapman 591742 591742 Baldewyn, Robert, of Petworth, Sussex, chapman 2
4794884 2294545 2294545 defendant Baldewyn Robert chapman 591742 591742 Baldewyn, Robert, of Petworth, Sussex, chapman 0
4796744 2295137 2295137 defendant atte Melle John   591742 591742 atte Melle, John, of Petworth, Sussex, franklin 0
4829518 2305272 2305272 defendant Bysley Simon husbandman 591742 591742 Bysley, Simon, of Petworth, Sussex, husbandman 0
4829520 2305273 2305273 defendant Bysley Simon husbandman 591742 591742 Bysley, Simon, of Petworth, Sussex, husbandman 0
4835463 2307086 2307086 defendant Houghton John husbandman 591742 591742 Houghton, John, of Petworth, Sussex, husbandman 1
4835466 2307087 2307087 defendant Houghton John husbandman 591742 591742 Houghton, John, of Petworth, Sussex, husbandman 1
4841387 2308842 2308842 defendant Holden Edmund yeoman 591742 591742 Holden, Edmund, of Petworth, Sussex, yeoman 0
4859730 2314409 2314409 defendant Jonesson William chapman 591742 591742 Jonesson, William, of Petworth, Sussex, chapman 0
4903545 2327719 2327719 defendant Fayrefax William esq 591742 591742 Fayrefax, William, of Petworth, Sussex, esq 3
4919985 2332762 2332762 defendant Blast John husbandman 591742 591742 Blast, John, of Petworth, Sussex, husbandman 1
4919993 2332764 2332764 defendant Blast John husbandman 591742 591742 Blast, John, of Petworth, Sussex, husbandman 2
4952953 2342844 2342844 defendant Holden Emma widow 591742 591742 Holden, Emma, of Petworth, Sussex, widow 2
4969645 2347869 2347869 defendant Houghton John   591742 591742 Houghton, John, of Petworth, Sussex, bed maker 4
4969661 2347871 2347871 defendant Houghton John   591742 591742 Houghton, John, of Petworth, Sussex, bed maker 4
4975676 2349687 2349687 defendant Qwixley John clerk 591742 591742 Qwixley, John, of Petworth, Sussex, clerk 0
5040046 2368620 2368620 defendant Eccles Ralph gent 591742 591742 Eccles, Ralph, of Petworth, Sussex, gent 4
5060668 2374770 2374770 defendant Weston Peter gent 591742 591742 Weston, Peter, of Petworth, Sussex, gent 0
5084392 2381842 2381842 defendant Weston Peter esq 591742 591742 Weston, Peter, of Petworth, Sussex, esq 1
5084394 2381843 2381843 defendant Weston Peter esq 591742 591742 Weston, Peter, of Petworth, Sussex, esq 0
5094761 2384880 2384880 defendant Percy Henry   591742 591742 Percy, Henry, of Petworth, Sussex, or of London, knight, Earl of Northumberland 0
5094764 2384881 2384881 defendant Percy Henry   591742 591742 Percy, Henry, of Petworth, Sussex, or of London, knight, Earl of Northumberland 0
5122857 2393116 2393116 defendant Mallon John yeoman 591742 591742 Mallon, John, of Petworth, Sussex, yeoman 2
5257916 2432599 2432599 defendant Gysburgh William gent 591742 591742 Gysburgh, William, of Petworth, Sussex, gent 0
5273843 2437429 2437429 defendant Merston William tailor 591742 591742 Merston, William, of Petworth, Sussex, tailor 0
5276198 2438113 2438113 defendant Courtmyll John yeoman 591742 591742 Courtmyll, John, of Petworth, Sussex, yeoman 3
5291626 2442555 2442555 defendant Blaste John chapman 591742 591742 Blaste, John, of Petworth, Sussex, chapman 0
5308482 2447573 2447573 defendant Tomson Thomas tailor 591742 591742 Tomson, Thomas, of Petworth, Sussex, tailor 1
5309158 2447777 2447777 defendant Burwell Richard yeoman 591742 591742 Burwell, Richard, of Petworth, Sussex, yeoman 2
5309474 2447872 2447872 defendant Tomson Thomas tailor 591742 591742 Tomson, Thomas, of Petworth, Sussex, tailor 1
5321295 2451464 2451464 defendant Burwell Richard yeoman 591742 591742 Burwell, Richard, of Petworth, Sussex, yeoman 2
5327996 2453440 2453440 defendant Barbour John husbandman 591742 591742 Barbour, John, of Petworth, Sussex, husbandman 1
5338252 2456532 2456532 defendant Dalby John sherman 591742 591742 Dalby, John, of Petworth, Sussex, sherman 2
5345922 2458856 2458856 defendant Barbour John husbandman 591742 591742 Barbour, John, of Petworth, Sussex, husbandman 1
5353511 2461172 2461172 defendant Dawetre Edmund esq 591742 591742 Dawetre, Edmund, of Petworth, Sussex, esq 0
5364088 2464426 2464426 defendant Bechyn Thomas barber 591742 591742 Bechyn, Thomas, of Petworth, Sussex, barber 0
5377010 2468404 2468404 defendant Bechyng Thomas chapman 591742 591742 Bechyng, Thomas, of Petworth, sussex, chapman 0
5393040 2473081 2473081 defendant Bechyng Thomas chapman 591742 591742 Bechyng, Thomas, of Petworth, Sussex, chapman 0
5406177 2476846 2476846 defendant Bechyng Thomas chapman 591742 591742 Bechyng, Thomas, of Petworth, Sussex, chapman 0
5429654 2483806 2483806 defendant Baker William clerk 591742 591742 Baker, William, of Petworth, Sussex, clerk 0
5534979 2515472 2515472 defendant Peverell Robert chapman 591742 591742 Peverell, Robert, of Petworth, Sussex, chapman 3
5534986 2515473 2515473 defendant Peverell Robert chapman 591742 591742 Peverell, Robert, of Petworth, Sussex, chapman 3
5535506 2515632 2515632 defendant Comber Joan widow 591742 591742 Comber, Joan, of Petworth, Sussex, widow 1
5535944 2515745 2515745 defendant Wylkynson James yeoman 591742 591742 Wylkynson, James, of Petworth, Sussex, yeoman 1
5535947 2515746 2515746 defendant Wylkynson James yeoman 591742 591742 Wylkynson, James, of Petworth, Sussex, yeoman 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);