names

102 rows where place_id = 589782

✎ 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
3598726 1867228 1867228 defendant Rykford John husbandman 589782 589782 Rykford, John, of Stanes, husbandman 0
3598727 1867228 1867228 defendant Spycer William sawyer 589782 589782 Spycer, William, of Stanes, sawyer 1
3598728 1867228 1867228 defendant Goldyfine or Goldysue Thomas innholder 589782 589782 Goldyfine or Goldysue, Thomas, of Stanes, innholder 2
3598731 1867229 1867229 defendant Rykford John   589782 589782 Rykford, John, of Stanes husbandman 0
3598732 1867229 1867229 defendant Spycer William sawyer 589782 589782 Spycer, William, of Stanes, sawyer 1
3598736 1867230 1867230 defendant Rykford John husbandman 589782 589782 Rykford, John, of Stanes, husbandman 0
3598737 1867230 1867230 defendant Spycer William sawyer 589782 589782 Spycer, William, of Stanes, sawyer 1
3598738 1867230 1867230 defendant Goldyfine Thomas innholder 589782 589782 Goldyfine, Thomas, of Stanes, innholder 2
3692979 1924004 1924004 defendant Sadler Robert smith 589782 589782 Sadler, Robert, of Stanes, smith 0
3733343 1936660 1936660 defendant Borde John yeoman 589782 589782 Borde, John, of Stanes, yeoman 1
3753982 1943196 1943196 defendant Hardwyk William innholder 589782 589782 Hardwyk, William, of Stanes, innholder 0
3772612 1949126 1949126 defendant Gull Thomas yeoman 589782 589782 Gull, Thomas, of Stanes, yeoman 0
3772613 1949126 1949126 defendant Warde Thomas miller 589782 589782 Warde, Thomas, of Stanes, miller 1
3782811 1952371 1952371 defendant Williams John innholder 589782 589782 Williams, John, of Stanes, innholder 0
3794470 1956147 1956147 defendant Atwyke Robert husbandman 589782 589782 Atwyke, Robert, of Stanes, husbandman 0
3998190 2024099 2024099 defendant Warde Andrew   589782 589782 Warde, Andrew, of Stanes, yeoman, son of Thomas 1
3998194 2024100 2024100 defendant Warde Andrew   589782 589782 Warde, Andrew, of Stanes, yeoman, son of Thomas 1
4088701 2056259 2056259 defendant Penven John clerk 589782 589782 Penven, John, of Stanes, clerk 0
4133330 2072244 2072244 defendant Baker Thomas chapman 589782 589782 Baker, Thomas, of Stanes, chapman 1
4360916 2151075 2151075 defendant Vallys John yeoman 589782 589782 Vallys, John, of Stanes, or of Salisbury, yeoman 2
4416730 2170099 2170099 plaintiff Osberne William (legal representative) 589782 589782 Osberne, William, of Stanes, executors of 0
4510574 2203769 2203769 defendant Barland John   589782 589782 Barland, John, of Stanes 4
4510575 2203769 2203769 defendant Hampton Nicholas   589782 589782 Hampton, Nicholas, of Stanes 5
4551997 2216574 2216574 plaintiff Essheton John   589782 589782 Essheton, John, of Stanes, vicar 0
4551998 2216574 2216574 defendant Bile John   589782 589782 Bile, John, of Stanes 0
4552000 2216575 2216575 plaintiff Esshton John   589782 589782 Esshton, John, of Stanes, vicar 0
4552001 2216575 2216575 defendant Bile John   589782 589782 Bile, John, of Stanes 0
4552002 2216575 2216575 defendant Sawyer Nicholas   589782 589782 Sawyer, Nicholas, of Stanes 1
4576011 2223992 2223992 defendant Drewe Thomas   589782 589782 Drewe, Thomas, of Stanes 3
4576016 2223993 2223993 defendant Drewe Thomas   589782 589782 Drewe, Thomas, of Stanes 3
4609092 2233947 2233947 plaintiff Bronsham Thomas   589782 589782 Bronsham, Thomas, of Stanes 0
4609093 2233947 2233947 defendant Wendesham Ralph baker 589782 589782 Wendesham, Ralph, of Stanes, baker 0
4623376 2238283 2238283 plaintiff Fullere William   589782 589782 Fullere, William, of Stanes 2
4632547 2241068 2241068 defendant Clement John   589782 589782 Clement, John, of Stanes 3
4684501 2260756 2260756 plaintiff Agnes his wife alias Agnes Burstat   589782 589782 Agnes, his wife alias Agnes Burstat, of Stanes 1
4696140 2264275 2264275 defendant del Stanes Thomas yeoman 589782 589782 del Stanes, Thomas, of Stanes, yeoman 0
4791971 2293593 2293593 defendant Mordon Thomas tailor 589782 589782 Mordon, Thomas, of Stanes, tailor 0
4791972 2293593 2293593 defendant Parkere alias Smyth Thomas smith 589782 589782 Parkere alias Smyth, Thomas, of Stanes, smith 1
4818022 2301717 2301717 defendant Boston John hostler 589782 589782 Boston, John, of Stanes, hostler 0
4833067 2306360 2306360 defendant Spylleslby William yeoman 589782 589782 Spylleslby, William, of Stanes, yeoman 1
4933787 2336946 2336946 defendant Hore Adam hosteler 589782 589782 Hore, Adam, of Stanes, hosteler 0
4994036 2355088 2355088 defendant Broun John barber 589782 589782 Broun, John, of Stanes, barber 0
5029367 2365465 2365465 defendant Weston John miller 589782 589782 Weston, John, of Stanes, miller 4
5042513 2369365 2369365 defendant Spycer John husbandman 589782 589782 Spycer, John, of Stanes, husbandman 1
5047400 2370843 2370843 defendant Etemede John yeoman 589782 589782 Etemede, John, of Stanes, yeoman 0
5047401 2370843 2370843 defendant Hervey Nicholas fletcher 589782 589782 Hervey, Nicholas, of Stanes, fletcher 1
5071677 2378019 2378019 defendant Derby Richard yeoman 589782 589782 Derby, Richard, of Stanes, yeoman 0
5107916 2388755 2388755 plaintiff Elkyn Robert (legal representative) 589782 589782 Elkyn, Robert, of Stanes, executors of 0
5131204 2395617 2395617 defendant more John yeoman 589782 589782 more, John, of Stanes, yeoman 0
5141608 2398656 2398656 defendant Eve William husbandman 589782 589782 Eve, William, of Stanes, husbandman 2
5141609 2398656 2398656 defendant Michell John laborer 589782 589782 Michell, John, of Stanes, laborer 3
5141610 2398656 2398656 defendant More John laborer 589782 589782 More, John, of Stanes, laborer 4
5162705 2404811 2404811 defendant Mayhewe John husbandman 589782 589782 Mayhewe, John, of Stanes, husbandman 1
5162706 2404811 2404811 defendant Eve William husbandman 589782 589782 Eve, William, of Stanes, husbandman 2
5162707 2404811 2404811 defendant Michell John barber 589782 589782 Michell, John, of Stanes, barber 3
5163439 2405038 2405038 defendant at Knolle William husbandman 589782 589782 at Knolle, William, of Stanes, husbandman 0
5176635 2408850 2408850 defendant Lefont John husbandman 589782 589782 Lefont, John, of Stanes, husbandman 1
5176636 2408850 2408850 defendant Lefonte William husbandman 589782 589782 Lefonte, William, of Stanes, husbandman 2
5185608 2411542 2411542 defendant More John yeoman 589782 589782 More, John, of Stanes, yeoman 0
5199812 2415692 2415692 defendant at Knolle William husbandman 589782 589782 at Knolle, William, of Stanes, husbandman 0
5199814 2415693 2415693 defendant at Knolle William husbandman 589782 589782 at Knolle, William, of Stanes, husbandman 0
5218848 2421236 2421236 defendant Fewar Thomas ostler 589782 589782 Fewar, Thomas, of Stanes, ostler 1
5226065 2423294 2423294 defendant Derykson John beer brewer 589782 589782 Derykson, John, of Stanes, beer brewer 0
5236304 2426207 2426207 defendant Turney William yeoman 589782 589782 Turney, William, of Stanes, yeoman 0
5236305 2426207 2426207 defendant Gerard John   589782 589782 Gerard, John, of Stanes, yeoman, guild and chantry wardens of Stanes St Mary 1
5247248 2429356 2429356 defendant Derykson Henry beer brewer 589782 589782 Derykson, Henry, of Stanes, beer brewer 0
5247887 2429520 2429520 defendant Wadbroke Henry butcher 589782 589782 Wadbroke, Henry, of Stanes, butcher 0
5273569 2437346 2437346 defendant Olyver Peter butcher 589782 589782 Olyver, Peter, of Stanes, butcher 0
5278844 2438922 2438922 defendant Colyn Richard husbandman 589782 589782 Colyn, Richard, of Stanes, husbandman 0
5280994 2439522 2439522 plaintiff Clerk John   589782 589782 Clerk, John, of Stanes 0
5292520 2442810 2442810 plaintiff Russell Thomas gent 589782 589782 Russell, Thomas, of Stanes, gent 0
5292522 2442811 2442811 plaintiff Russell Thomas esq 589782 589782 Russell, Thomas, of Stanes, gent, son of Russell, Richard, of London, fishmonger, and Isabel his wife, daughter of Connesby, Thomas, esq 0
5323038 2451968 2451968 defendant Waddebroke Henry butcher 589782 589782 Waddebroke, Henry, of Stanes, butcher 0
5334087 2455260 2455260 plaintiff Barry William   589782 589782 Barry, William, of Stanes 1
5334090 2455261 2455261 plaintiff Barry William   589782 589782 Barry, William, of Stanes 1
5338176 2456505 2456505 defendant Wadbroke Henry butcher 589782 589782 Wadbroke, Henry, of Stanes, butcher 0
5347924 2459494 2459494 defendant Colyn John husbandman 589782 589782 Colyn, John, of Stanes, husbandman 2
5359349 2462963 2462963 defendant Colyn alias Barbour Richard barber 589782 589782 Colyn alias Barbour, Richard, of Stanes, barber 0
5359353 2462964 2462964 defendant Colyn alias Barbour Richard barber 589782 589782 Colyn alias Barbour, Richard, of Stanes, barber 1
5361200 2463528 2463528 defendant Colyn Thomas tailor 589782 589782 Colyn, Thomas, of Stanes, tailor 2
5375595 2467955 2467955 defendant Colyn Richard barber 589782 589782 Colyn, Richard, of Stanes, barber 0
5411236 2478321 2478321 plaintiff Clerke John   589782 589782 Clerke, John, of Stanes 0
5420007 2480901 2480901 defendant Rooke Thomas sawyer 589782 589782 Rooke, Thomas, of Stanes, sawyer 2
5441295 2487310 2487310 defendant Colyns Thomas hosier 589782 589782 Colyns, Thomas, of Stanes, hosier 3
5449992 2489886 2489886 defendant Colyns Thomas hosier 589782 589782 Colyns, Thomas, of Stanes, hosier 3
5480084 2499031 2499031 defendant Barrey William cordwainer 589782 589782 Barrey, William, of Stanes, cordwainer 0
5491970 2502507 2502507 defendant Colyn William shoemaker 589782 589782 Colyn, William, of Stanes, shoemaker 1
5492300 2502612 2502612 defendant Spycer William sawyer 589782 589782 Spycer, William, of Stanes, sawyer 0
5492301 2502612 2502612 defendant Goldesny Thomas innholder 589782 589782 Goldesny, Thomas, of Stanes, innholder 1
5492302 2502612 2502612 defendant Colyn John husbandman 589782 589782 Colyn, John, of Stanes, husbandman 2
5506776 2507041 2507041 defendant Colyns William shoemaker 589782 589782 Colyns, William, of Stanes, shoemaker 1
5506781 2507042 2507042 defendant Colyns William shoemaker 589782 589782 Colyns, William, of Stanes, shoemaker 1
5525305 2512506 2512506 defendant Jankyns Mathew yeoman 589782 589782 Jankyns, Mathew, of Stanes, yeoman 2
5544976 2518536 2518536 defendant Golsney Thomas yeoman 589782 589782 Golsney, Thomas, of Stanes, yeoman 1
5557903 2522264 2522264 defendant Goldysue Thomas innholder 589782 589782 Goldysue, Thomas, of Stanes, innholder 1
5557904 2522264 2522264 defendant Shaftysbury John wheeler 589782 589782 Shaftysbury, John, of Stanes, wheeler 2
5561603 2523380 2523380 defendant Gyle John yeoman 589782 589782 Gyle, John, of Stanes, yeoman 0
5581560 2529306 2529306 defendant Rede Lewis yeoman 589782 589782 Rede, Lewis, of Stanes, yeoman 4
5581579 2529313 2529313 defendant Rede Lewis yeoman 589782 589782 Rede, Lewis, of Stanes, yeoman 3
5599092 2534598 2534598 defendant Petytt John husbandman 589782 589782 Petytt, John, of Stanes, husbandman 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);