names

163 rows where place_id = 596711

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616972 1872930 1872930 plaintiff Everard Alice (legal representative) 596711 596711 Everard, Alice, of Gaynesburgh, executrix of Everard, John, of Gaynesburgh, executor of 0
3625854 1902937 1902937 defendant Cort William yeoman 596711 596711 Cort, William, of Gaynesburgh, yeoman 0
3631889 1904783 1904783 defendant Wawyn Richard yeoman 596711 596711 Wawyn, Richard, of Gaynesburgh, yeoman 0
3631893 1904785 1904785 defendant Cort William yeoman 596711 596711 Cort, William, of Gaynesburgh, yeoman 0
3638411 1906835 1906835 defendant Wellys William husbandman 596711 596711 Wellys, William, of Gaynesburgh, husbandman 0
3638412 1906835 1906835 defendant Wellys Robert laborer 596711 596711 Wellys, Robert, of Gaynesburgh, laborer 1
3646762 1909393 1909393 defendant Joly Isabel widow 596711 596711 Joly, Isabel, of Gaynesburgh, widow 0
3648281 1909863 1909863 plaintiff Morton Henry (legal representative) 596711 596711 Morton, Henry, of Gaynesburgh, butcher, executors of 0
3666210 1915380 1915380 plaintiff Leche alias Vawen Richard merchant 596711 596711 Leche alias Vawen, Richard, of Gaynesburgh, merchant 2
3710889 1929725 1929725 defendant Turner Richard yeoman 596711 596711 Turner, Richard, of Gaynesburgh, yeoman 1
3725539 1934277 1934277 defendant Turner Richard yeoman 596711 596711 Turner, Richard, of Gaynesburgh, yeoman 1
3738806 1938342 1938342 defendant Calverley Robert laborer 596711 596711 Calverley, Robert, of Gaynesburgh, laborer 0
3766244 1947095 1947095 defendant Wywen Thomas gent 596711 596711 Wywen, Thomas, of Gaynesburgh, gent 1
3776597 1950426 1950426 defendant Burgh Thomas, junior   596711 596711 Burgh, Thomas, junior, of Gaynesburgh, knight 0
3834326 1968679 1968679 plaintiff Morgan Maurice   596711 596711 Morgan, Maurice, of Gaynesburgh 0
4212841 2100025 2100025 defendant Norton William draper 596711 596711 Norton, William, of Gaynesburgh, draper 0
4420557 2171330 2171330 defendant Baillif Edmund le   596711 596711 Baillif, Edmund le, of Gaynesburgh 0
4477829 2193734 2193734 plaintiff Hamon John   596711 596711 Hamon, John, of Gaynesburgh 0
4478299 2193887 2193887 defendant Gaugy or Gangy John   596711 596711 Gaugy or Gangy, John, of Gaynesburgh 0
4478300 2193887 2193887 defendant Selby Robert de shipman 596711 596711 Selby, Robert de, of Gaynesburgh, shipman 1
4480836 2194675 2194675 defendant Ledes John de shoemaker 596711 596711 Ledes, John de, of Gaynesburgh, shoemaker 0
4487062 2196676 2196676 defendant Smyth Geoffrey   596711 596711 Smyth, Geoffrey, of Gaynesburgh 1
4487063 2196676 2196676 defendant Barne John   596711 596711 Barne, John, of Gaynesburgh 2
4487064 2196676 2196676 defendant Bryan William   596711 596711 Bryan, William, of Gaynesburgh, cogger or cog maker;Smyth, John, of Little Lymbergh 3
4502540 2201380 2201380 defendant Gangs John   596711 596711 Gangs, John, of Gaynesburgh 0
4506115 2202427 2202427 defendant Gauge John   596711 596711 Gauge, John, of Gaynesburgh 0
4506121 2202430 2202430 defendant Gauge John   596711 596711 Gauge, John, of Gaynesburgh 0
4506123 2202431 2202431 defendant Gauge John   596711 596711 Gauge, John, of Gaynesburgh 0
4508620 2203175 2203175 defendant Symson William   596711 596711 Symson, William, of Gaynesburgh 0
4521477 2207060 2207060 plaintiff Gauge John   596711 596711 Gauge, John, of Gaynesburgh 0
4524268 2207926 2207926 defendant Alneth John   596711 596711 Alneth, John, of Gaynesburgh 0
4538305 2212270 2212270 defendant Lasteby Simon de shoemaker 596711 596711 Lasteby, Simon de, of Gaynesburgh, shoemaker 0
4547249 2215073 2215073 plaintiff Burton Thomas   596711 596711 Burton, Thomas, of Gaynesburgh 0
4553353 2216985 2216985 plaintiff Gaugy John   596711 596711 Gaugy, John, of Gaynesburgh 0
4553355 2216985 2216985 defendant Lincoln William de   596711 596711 Lincoln, William de, of Gaynesburgh 1
4564837 2220569 2220569 defendant Godyer Adam   596711 596711 Godyer, Adam, of Gaynesburgh 1
4564838 2220569 2220569 defendant Webster Roger   596711 596711 Webster, Roger, of Gaynesburgh 2
4565113 2220657 2220657 plaintiff Skidgate John   596711 596711 Skidgate, John, of Gaynesburgh 0
4565115 2220658 2220658 plaintiff Skidgate Thomas   596711 596711 Skidgate, Thomas, of Gaynesburgh 0
4565117 2220659 2220659 plaintiff Skidgate Thomas   596711 596711 Skidgate, Thomas, of Gaynesburgh 0
4567102 2221267 2221267 plaintiff Symson Walter   596711 596711 Symson, Walter, of Gaynesburgh 0
4567780 2221490 2221490 defendant Selby Robert shipman 596711 596711 Selby, Robert, of Gaynesburgh, shipman 0
4570416 2222321 2222321 defendant Tebbe William   596711 596711 Tebbe, William, of Gaynesburgh 0
4583954 2226401 2226401 plaintiff Burdet John   596711 596711 (Burdet, John, of Gaynesburgh 1
4591390 2228663 2228663 plaintiff Milnehouse Robert   596711 596711 Milnehouse, Robert, of Gaynesburgh 0
4591393 2228664 2228664 plaintiff Milnehouse Robert   596711 596711 Milnehouse, Robert, of Gaynesburgh 0
4599768 2231150 2231150 plaintiff Symson William   596711 596711 Symson, William, of Gaynesburgh 0
4604492 2232574 2232574 defendant Pollard John   596711 596711 Pollard, John, of Gaynesburgh 1
4609193 2233980 2233980 plaintiff Brounflete Thomas   596711 596711 Brounflete, Thomas, of Gaynesburgh 0
4609561 2234090 2234090 plaintiff Burdet John, sen   596711 596711 Burdet, John, sen, of Gaynesburgh 0
4611221 2234574 2234574 plaintiff Claworth Thomas de (legal representative) 596711 596711 Claworth, Thomas de, of Gaynesburgh, executors of 0
4611227 2234575 2234575 plaintiff Claworth Thomas de (legal representative) 596711 596711 Claworth, Thomas de, of Gaynesburgh, executors of 0
4615695 2235912 2235912 plaintiff Feriby Gescelus de (legal representative) 596711 596711 Feriby, Gescelus de, of Gaynesburgh, formerly vicar, executors of 0
4615701 2235913 2235913 plaintiff Feriby Goscellus (legal representative) 596711 596711 Feriby, Goscellus, of Gaynesburgh, formerly vicar, executors of 0
4615706 2235913 2235913 defendant Horn Adam   596711 596711 Horn, Adam, of Gaynesburgh 1
4615738 2235922 2235922 plaintiff Feryby Goscellus de (legal representative) 596711 596711 Feryby, Goscellus de, of Gaynesburgh, vicar, executors of 0
4624686 2238704 2238704 defendant Gauge or Gange Agnes   596711 596711 Gauge or Gange, Agnes, of Gaynesburgh 0
4631850 2240844 2240844 defendant Flesshewer Richard   596711 596711 Flesshewer, Richard, of Gaynesburgh 0
4635055 2241810 2241810 defendant Goldesburgh John   596711 596711 Goldesburgh, John, of Gaynesburgh 1
4645573 2244775 2244775 plaintiff Northeby William merchant 596711 596711 Northeby, William, of Gaynesburgh, merchant 0
4647649 2245366 2245366 defendant Hode John   596711 596711 Hode, John, of Gaynesburgh 0
4657156 2248123 2248123 defendant Rachedale Richard   596711 596711 Rachedale, Richard, of Gaynesburgh 9
4665355 2250650 2250650 defendant Rachedale Robert yeoman 596711 596711 Rachedale, Robert, of Gaynesburgh, yeoman 8
4673818 2257433 2257433 defendant Skidgate Helen de widow 596711 596711 Skidgate, Helen de, of Gaynesburgh, widow 5
4708219 2267949 2267949 plaintiff Neuton William   596711 596711 Neuton, William, of Gaynesburgh 0
4715770 2270250 2270250 defendant Turnour Gosselus chaplain 596711 596711 Turnour, Gosselus, of Gaynesburgh, chaplain 3
4724759 2273042 2273042 plaintiff Feriby Goscellus (legal representative) 596711 596711 Feriby, Goscellus, of Gaynesburgh, formerly vicar, executors of 0
4731163 2274947 2274947 defendant Qwyxley William yeoman 596711 596711 Qwyxley, William, of Gaynesburgh, yeoman 0
4745677 2279248 2279248 defendant atte Halle John tanner 596711 596711 atte Halle, John, of Gaynesburgh, tanner 0
4750934 2280757 2280757 defendant Asby John husbandman 596711 596711 Asby, John, of Gaynesburgh, husbandman 0
4763209 2284480 2284480 defendant Cristofer John kyddyer or kiddier 596711 596711 Cristofer, John, of Gaynesburgh, kyddyer or kiddier 0
4763952 2284719 2284719 defendant Hales Walter yeoman 596711 596711 Hales, Walter, of Gaynesburgh, yeoman 0
4765573 2285222 2285222 defendant Olyver Thomas butcher 596711 596711 Olyver, Thomas, of Gaynesburgh, butcher 0
4768999 2286281 2286281 defendant Lincoln Thomas fishmonger 596711 596711 Lincoln, Thomas, of Gaynesburgh, fishmonger 0
4779063 2289429 2289429 defendant Lincoln Thomas panier man 596711 596711 Lincoln, Thomas, of Gaynesburgh, panier man 0
4779070 2289431 2289431 defendant Lincoln Thomas panierman 596711 596711 Lincoln, Thomas, of Gaynesburgh, panierman 0
4784025 2291013 2291013 defendant Stokwyth John husbandman 596711 596711 Stokwyth, John, of Gaynesburgh, husbandman 1
4784026 2291013 2291013 defendant Nype John yeoman 596711 596711 Nype, John, of Gaynesburgh, yeoman 2
4786865 2291952 2291952 defendant Cristofer John   596711 596711 Cristofer, John, of Gaynesburgh, "kyddyer" 0
4786867 2291953 2291953 defendant Cristofer John   596711 596711 Cristofer, John, of Gaynesburgh, "kyddyer" 0
4790482 2293113 2293113 defendant Olyver Thomas butcher 596711 596711 Olyver, Thomas, of Gaynesburgh, butcher 1
4793556 2294093 2294093 defendant Lincoln Thomas fisher 596711 596711 Lincoln, Thomas, of Gaynesburgh, fisher 0
4802525 2296979 2296979 defendant Stokewyth John ostler 596711 596711 Stokewyth, John, of Gaynesburgh, ostler 1
4809601 2299167 2299167 defendant Stokwyth John yeoman 596711 596711 Stokwyth, John, of Gaynesburgh, yeoman 0
4831111 2305762 2305762 defendant Lincoln Thomas fishmonger 596711 596711 Lincoln, Thomas, of Gaynesburgh, fishmonger 0
4834808 2306888 2306888 defendant Athern William husbandman 596711 596711 Athern, William, of Gaynesburgh, husbandman 2
4834809 2306888 2306888 defendant Bonas Thomas husbandman 596711 596711 Bonas, Thomas, of Gaynesburgh, husbandman 3
4850028 2311475 2311475 defendant Nayles Walter husbandman 596711 596711 Nayles, Walter, of Gaynesburgh, husbandman 3
4854135 2312703 2312703 defendant Harclay Adam tailor 596711 596711 Harclay, Adam, of Gaynesburgh, tailor 1
4855640 2313133 2313133 plaintiff atte Halle John   596711 596711 atte Halle, John, of Gaynesburgh 0
4861744 2315045 2315045 defendant Stokwyth John yeoman 596711 596711 Stokwyth, John, of Gaynesburgh, yeoman 1
4861745 2315045 2315045 defendant Snaweball William yeoman 596711 596711 Snaweball, William, of Gaynesburgh, yeoman 2
4863505 2315556 2315556 defendant Rachedale Robert yeoman 596711 596711 Rachedale, Robert, of Gaynesburgh, or of Morton, yeoman 0
4869230 2317344 2317344 defendant Snaweball William   596711 596711 Snaweball, William, of Gaynesburgh, bailiff 8
4870830 2317856 2317856 defendant Quyxlay William husbandman 596711 596711 Quyxlay, William, of Gaynesburgh, husbandman 1
4874010 2318809 2318809 defendant Meskyn John chaplain 596711 596711 Meskyn, John, of Gaynesburgh, chaplain 1
4878057 2320090 2320090 defendant Snaweball William   596711 596711 Snaweball, William, of Gaynesburgh, bailiff 3
4878058 2320090 2320090 defendant Stokwyth John   596711 596711 Stokwyth, John, of Gaynesburgh, bailiff 4
4883587 2321783 2321783 defendant Kynardby Roger merchant 596711 596711 Kynardby, Roger, of Gaynesburgh, merchant 4
4897465 2325869 2325869 defendant Stokheth John husbandman 596711 596711 Stokheth, John, of Gaynesburgh, husbandman 1

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