names

114 rows where place_id = 589498

✎ 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
3597797 1866927 1866927 defendant Strace or Scrace John laborer 589498 589498 Strace or Scrace, John, of Wynchelse, laborer 0
3604107 1868951 1868951 plaintiff Fuysshe Thomas   589498 589498 Fuysshe, Thomas, of Wynchelse 0
3605924 1869513 1869513 defendant Perys Ralph yeoman 589498 589498 Perys, Ralph, of Wynchelse, yeoman 2
3605926 1869513 1869513 defendant Andrew John yeoman 589498 589498 Andrew, John, of Wynchelse, yeoman 4
3674680 1918129 1918129 defendant Serrynge John yeoman 589498 589498 Serrynge, John, of Wynchelse, yeoman 4
3700344 1926347 1926347 defendant Marshall James (legal representative) 589498 589498 Marshall, James, of Wynchelse, merchant, executors of 0
3700345 1926347 1926347 defendant Stonaker Robert yeoman 589498 589498 (Stonaker, Robert, of Wynchelse, yeoman 1
3704341 1927659 1927659 defendant Blake John yeoman 589498 589498 Blake, John, of Wynchelse, yeoman 1
3739041 1938417 1938417 defendant Hemman John beer brewer 589498 589498 Hemman, John, of Wynchelse, beer brewer 0
3739044 1938418 1938418 defendant Hemman John beer brewer 589498 589498 Hemman, John, of Wynchelse, beer brewer 0
3742477 1939518 1939518 defendant Hemon John beer brewer 589498 589498 Hemon, John, of Wynchelse, beer brewer 0
3742478 1939518 1939518 defendant Fisshe Simon gent 589498 589498 Fisshe, Simon, of Wynchelse, gent 1
3742479 1939518 1939518 defendant Okman Richard draper 589498 589498 Okman, Richard, of Wynchelse, draper 2
3763750 1946308 1946308 plaintiff Heman John beer brewer 589498 589498 Heman, John, of Wynchelse, beer brewer 0
3766684 1947241 1947241 defendant Master Peter (legal representative) 589498 589498 Master, Peter, of Wynchelse, merchant, executor of 1
3766689 1947242 1947242 defendant Master Peter (legal representative) 589498 589498 Master, Peter, of Wynchelse, merchant, executor of 1
3781832 1952064 1952064 plaintiff Henman John beer brewer 589498 589498 Henman, John, of Wynchelse, beer brewer 0
3797317 1957050 1957050 plaintiff Gaunte William (legal representative) 589498 589498 Gaunte, William, of Wynchelse, administrator of 0
3808484 1960532 1960532 defendant Clerk William yeoman 589498 589498 Clerk, William, of Wynchelse, yeoman 1
4418859 2170764 2170764 plaintiff Andreu Stephen   589498 589498 Andreu, Stephen, of Wynchelse, son of Edmund 0
4421497 2171629 2171629 plaintiff Coupere Richard la   589498 589498 Coupere, Richard la, of Wynchelse, son of Alice 0
4431135 2174499 2174499 plaintiff Vynch John   589498 589498 Vynch, John, of Wynchelse, son of John 3
4454050 2186281 2186281 plaintiff Londoneys Robert   589498 589498 Londoneys, Robert, of Wynchelse 0
4467180 2190406 2190406 defendant Fynche Henry   589498 589498 Fynche, Henry, of Wynchelse, son of Vincent Fynche 0
4467183 2190407 2190407 defendant Fynche Henry   589498 589498 Fynche, Henry, of Wynchelse, son of Vincent Fynche 0
4546314 2214783 2214783 plaintiff Salerne John   589498 589498 Salerne, John, of Wynchelse 1
4548723 2215539 2215539 defendant Clevere William   589498 589498 Clevere, William, of Wynchelse 0
4643693 2244255 2244255 defendant Russell Richard   589498 589498 Russell, Richard, of Wynchelse 1
4652744 2246793 2246793 defendant Carder Richard (legal representative) 589498 589498 Carder, Richard, of Wynchelse, chapman, executrix of 4
4652754 2246794 2246794 defendant Carder Richard (legal representative) 589498 589498 Carder, Richard, of Wynchelse, chapman, executrix of 5
4658596 2248565 2248565 plaintiff Crestofre John   589498 589498 Crestofre, John, of Wynchelse 0
4683008 2260299 2260299 defendant Kynton Alan husbandman 589498 589498 Kynton, Alan, of Wynchelse, husbandman 1
4685024 2260913 2260913 defendant atte Gate Roger   589498 589498 atte Gate, Roger, of Wynchelse 0
4748379 2280031 2280031 defendant Amys Stephen glover 589498 589498 Amys, Stephen, of Wynchelse, glover 3
4750830 2280726 2280726 defendant More John husbandman 589498 589498 More, John, of Wynchelse, husbandman 0
4774302 2287942 2287942 plaintiff Tylly William   589498 589498 Tylly, William, of Wynchelse 0
4776397 2288611 2288611 defendant More John hosteler 589498 589498 More, John, of Wynchelse, hosteler 0
4783090 2290730 2290730 defendant Thomoard Henry merchant 589498 589498 Thomoard, Henry, of Wynchelse, merchant 0
4791395 2293402 2293402 defendant Vynagh John tanner 589498 589498 Vynagh, John, of Wynchelse, tanner 1
4816778 2301346 2301346 plaintiff Martham John   589498 589498 Martham, John, of Wynchelse 0
4869069 2317298 2317298 plaintiff Knyght John   589498 589498 Knyght, John, of Wynchelse 0
4887415 2322903 2322903 plaintiff Alard William   589498 589498 Alard, William, of Wynchelse 0
4889488 2323509 2323509 plaintiff Alard William   589498 589498 Alard, William, of Wynchelse 0
4896151 2325453 2325453 defendant Grente Thomas gent 589498 589498 (Grente, Thomas, of Wynchelse, gent 1
4901754 2327154 2327154 defendant Grente Thomas gent 589498 589498 (Grente, Thomas, of Wynchelse, gent 1
4905439 2328294 2328294 defendant Martham Joan widow 589498 589498 Martham, Joan, of Wynchelse, widow 1
4923134 2333653 2333653 plaintiff Marchall William (legal representative) 589498 589498 Marchall, William, of Wynchelse, draper, executors of 0
4923137 2333653 2333653 defendant Marchall William (legal representative) 589498 589498 Marchall, William, of Wynchelse, draper, executors of 0
4925837 2334512 2334512 plaintiff Pulham Godard   589498 589498 Pulham, Godard, of Wynchelse 1
4925956 2334551 2334551 plaintiff Prat John   589498 589498 Prat, John, of Wynchelse 0
4926135 2334601 2334601 plaintiff Pulham Godard   589498 589498 Pulham, Godard, of Wynchelse 0
4926139 2334602 2334602 plaintiff Pulham Godard   589498 589498 Pulham, Godard, of Wynchelse 0
4926140 2334602 2334602 defendant Pulham Godard   589498 589498 Pulham, Godard, of Wynchelse 0
4930862 2336054 2336054 defendant Smyth Henry merchant 589498 589498 Smyth, Henry, of Wynchelse, merchant 0
4942905 2339757 2339757 plaintiff Fysh John   589498 589498 Fysh, John, of Wynchelse 0
4959657 2344849 2344849 defendant Sybbe Robert butcher 589498 589498 Sybbe, Robert, of Wynchelse, butcher 2
4977512 2350238 2350238 defendant Ferby John chaplain 589498 589498 Ferby, John, of Wynchelse, chaplain 0
4995691 2355554 2355554 plaintiff Godfray John   589498 589498 Godfray, John, of Wynchelse 0
4995694 2355555 2355555 plaintiff Godfray John   589498 589498 Godfray, John, of Wynchelse 0
5010228 2359857 2359857 plaintiff Vynehawe John   589498 589498 Vynehawe, John, of Wynchelse 0
5038642 2368201 2368201 defendant Taillour William laborer 589498 589498 (Taillour, William, of Wynchelse, laborer 1
5050945 2371896 2371896 plaintiff Vynehagh alias Vynehoowe John   589498 589498 Vynehagh alias Vynehoowe, John, of Wynchelse 0
5051028 2371917 2371917 defendant Broune Richard gent 589498 589498 Broune, Richard, of Wynchelse, gent 0
5063116 2375504 2375504 defendant atte Lever John husbandman 589498 589498 atte Lever, John, of Wynchelse, husbandman 0
5073454 2378545 2378545 plaintiff Vynhawe John   589498 589498 Vynhawe, John, of Wynchelse 0
5083378 2381525 2381525 plaintiff Farnecombe Simon   589498 589498 Farnecombe, Simon, of Wynchelse 0
5084306 2381813 2381813 defendant Crullyng Thomas merchant 589498 589498 Crullyng, Thomas, of Wynchelse, merchant 0
5084367 2381833 2381833 defendant Allard John butcher 589498 589498 Allard, John, of Wynchelse, butcher 0
5117950 2391676 2391676 defendant Wodeward Thomas husbndman 589498 589498 Wodeward, Thomas, of Wynchelse, husbndman 1
5122502 2393011 2393011 defendant Selton Thomas yeoman 589498 589498 Selton, Thomas, of Wynchelse, yeoman 0
5185611 2411543 2411543 defendant Baseley Robert esq 589498 589498 Baseley, Robert, of Wynchelse, esq 0
5217977 2420992 2420992 defendant Baseley Robert esq 589498 589498 Baseley, Robert, of Wynchelse, esq 0
5217979 2420993 2420993 defendant Baseley Robert esq 589498 589498 Baseley, Robert, of Wynchelse, esq 0
5268597 2435935 2435935 defendant Sevenoke Stephen merchant 589498 589498 Sevenoke, Stephen, of Wynchelse, merchant 0
5337628 2456322 2456322 defendant Andrewe John draper 589498 589498 Andrewe, John, of Wynchelse, draper 2
5341967 2457677 2457677 defendant Hogge Robert husbandman 589498 589498 Hogge, Robert, of Wynchelse, husbandman 0
5358923 2462840 2462840 defendant Curlyng alias Reygate Stephen merchant 589498 589498 Curlyng alias Reygate, Stephen, of Wynchelse, merchant 0
5358925 2462841 2462841 defendant Curlyng alias Reygate Stephen merchant 589498 589498 Curlyng alias Reygate, Stephen, of Wynchelse, merchant 0
5369351 2466016 2466016 defendant Sevenokke alias Romshet Stephen merchant 589498 589498 Sevenokke alias Romshet, Stephen, of Wynchelse, merchant 0
5374473 2467621 2467621 defendant Baseley John gent 589498 589498 Baseley, John, of Wynchelse, gent 0
5404118 2476256 2476256 defendant Clerk Richard (legal representative) 589498 589498 Clerk, Richard, of Wynchelse, butcher, executors of 0
5404119 2476256 2476256 defendant Myles Robert butcher 589498 589498 (Myles, Robert, of Wynchelse, butcher 1
5404120 2476256 2476256 defendant Tyler Robert yeoman 589498 589498 Tyler, Robert, of Wynchelse, yeoman 2
5404121 2476256 2476256 defendant Lew- John beer brewer 589498 589498 Lew-, John, of Wynchelse, beer brewer 3
5404948 2476492 2476492 defendant Morys Robert yeoman 589498 589498 Morys, Robert, of Wynchelse, yeoman 2
5404949 2476492 2476492 defendant Prers Ralph yeoman 589498 589498 Prers, Ralph, of Wynchelse, yeoman 3
5413674 2479012 2479012 defendant Sevenokke Stephen merchant 589498 589498 Sevenokke, Stephen, of Wynchelse, merchant 1
5418025 2480317 2480317 defendant Morys Robert yeoman 589498 589498 Morys, Robert, of Wynchelse, yeoman 2
5418026 2480317 2480317 defendant Piers Ralph yeoman 589498 589498 Piers, Ralph, of Wynchelse, yeoman 3
5423611 2482026 2482026 defendant Straas Henry merchant 589498 589498 Straas, Henry, of Wynchelse, merchant 0
5423614 2482027 2482027 defendant Scraas Henry merchant 589498 589498 Scraas, Henry, of Wynchelse, merchant 0
5423617 2482028 2482028 defendant Straas Henry merchant 589498 589498 Straas, Henry, of Wynchelse, merchant 0
5442854 2487775 2487775 defendant Straas Henry merchant 589498 589498 Straas, Henry, of Wynchelse, merchant 0
5455616 2491585 2491585 defendant Straas Henry merchant 589498 589498 Straas, Henry, of Wynchelse, merchant 0
5467381 2495188 2495188 defendant Scraas Henry merchant 589498 589498 Scraas, Henry, of Wynchelse, merchant 0
5467384 2495189 2495189 defendant Straas Henry merchant 589498 589498 Straas, Henry, of Wynchelse, merchant 0
5467387 2495190 2495190 defendant Straas Henry merchant 589498 589498 Straas, Henry, of Wynchelse, merchant 0
5477683 2498345 2498345 plaintiff Appresser Thomas   589498 589498 Appresser, Thomas, of Wynchelse 0
5502698 2505762 2505762 defendant Sterre Henry   589498 589498 Sterre, Henry, of Wynchelse, "repyer" 1
5502699 2505762 2505762 defendant Bakke Thomas   589498 589498 Bakke, Thomas, of Wynchelse, "repyer" 2

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