names

129 rows where place_id = 587828

✎ 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
3592548 1865286 1865286 defendant Cary Richard yeoman 587828 587828 Cary, Richard, of Wycombe, yeoman 0
3630080 1904257 1904257 defendant Garlyk William tailor 587828 587828 Garlyk, William, of Wycombe, tailor 0
3713499 1930533 1930533 defendant Bromley William laborer 587828 587828 Bromley, William, of Wycombe, laborer 3
3836059 1969190 1969190 plaintiff Pusey Robert   587828 587828 Pusey, Robert, of Wycombe 0
3921845 1997651 1997651 plaintiff Pusey Thomas (legal representative) 587828 587828 Pusey, Thomas, of Wycombe, clothier, executors of 0
4007099 2027316 2027316 defendant Rance Robert gent 587828 587828 Rance, Robert, of Wycombe, gent 0
4007100 2027316 2027316 defendant Norman Roger yeoman 587828 587828 Norman, Roger, of Wycombe, yeoman 1
4007101 2027316 2027316 defendant Byrde John innholder 587828 587828 Byrde, John, of Wycombe, innholder 2
4413753 2169198 2169198 defendant Matheu John   587828 587828 Matheu, John, of Wycombe 0
4416075 2169912 2169912 defendant Batyn John   587828 587828 Batyn, John, of Wycombe 1
4418125 2170551 2170551 defendant Hauford Robert de   587828 587828 Hauford, Robert de, of Wycombe 0
4425114 2172684 2172684 defendant Gatyn John   587828 587828 Gatyn, John, of Wycombe 1
4429319 2173976 2173976 defendant Hanford Robert de   587828 587828 Hanford, Robert de, of Wycombe 0
4433352 2175185 2175185 defendant Taillour Lawrence le   587828 587828 Taillour, Lawrence le, of Wycombe 8
4434629 2175594 2175594 defendant Batyn John   587828 587828 together with Batyn, John, of Wycombe 3
4435480 2175854 2175854 defendant Adewelle John   587828 587828 Adewelle, John, of Wycombe 0
4438838 2181438 2181438 defendant Palmer Denise   587828 587828 Palmer, Denise, of Wycombe 1
4444996 2183410 2183410 plaintiff Cornewayle Thomas (legal representative) 587828 587828 Cornewayle, Thomas, of Wycombe, executors of 0
4444999 2183410 2183410 defendant Romayn Nicholas   587828 587828 Romayn, Nicholas, of Wycombe 0
4452460 2185766 2185766 plaintiff Kele Richard   587828 587828 Kele, Richard, of Wycombe 0
4452464 2185767 2185767 plaintiff Kele Richard   587828 587828 Kele, Richard, of Wycombe 0
4468378 2190775 2190775 defendant Boynoun Thomas   587828 587828 Boynoun, Thomas, of Wycombe 3
4487579 2196834 2196834 plaintiff Snell John   587828 587828 Snell, John, of Wycombe, on his own account 0
4487580 2196834 2196834 defendant Fullere Richard   587828 587828 Fullere, Richard, of Wycombe 0
4488999 2197279 2197279 defendant Clerk William   587828 587828 Clerk, William, of Wycombe 0
4494287 2198905 2198905 defendant Ba---- Thomas   587828 587828 Ba----, Thomas, of Wycombe 0
4509399 2203414 2203414 plaintiff Clerk William   587828 587828 Clerk, William, of Wycombe 1
4510203 2203674 2203674 plaintiff Barbour Richard   587828 587828 Barbour, Richard, of Wycombe 0
4522147 2207272 2207272 defendant Bance Nicholas   587828 587828 Bance, Nicholas, of Wycombe 0
4544089 2214067 2214067 plaintiff Barbour Richard   587828 587828 Barbour, Richard, of Wycombe 0
4551533 2216419 2216419 defendant Chapman John   587828 587828 Chapman, John, of Wycombe 1
4572510 2222937 2222937 plaintiff atte Dene John   587828 587828 atte Dene, John, of Wycombe 0
4572889 2223063 2223063 defendant Clerk William   587828 587828 Clerk, William, of Wycombe 0
4573273 2223176 2223176 plaintiff Barbour Richard   587828 587828 Barbour, Richard, of Wycombe 0
4577230 2224396 2224396 plaintiff Campeden William   587828 587828 Campeden, William, of Wycombe 0
4578447 2224747 2224747 plaintiff Clerk William   587828 587828 Clerk, William, of Wycombe 0
4578449 2224748 2224748 plaintiff Clerk William   587828 587828 Clerk, William, of Wycombe 0
4578453 2224749 2224749 plaintiff Clerk William   587828 587828 Clerk, William, of Wycombe 0
4578940 2224893 2224893 defendant Sturdy Richard   587828 587828 Sturdy, Richard, of Wycombe, mason 2
4588237 2227715 2227715 plaintiff Kere William   587828 587828 Kere, William, of Wycombe 0
4594118 2229422 2229422 defendant Holewey John ostler 587828 587828 Holewey, John, of Wycombe, ostler 1
4620954 2237536 2237536 defendant Brytte Henry tanner 587828 587828 Brytte, Henry, of Wycombe, tanner 0
4620955 2237536 2237536 defendant Bestylle Hugh   587828 587828 Bestylle, Hugh, of Wycombe 1
4620957 2237536 2237536 defendant Fouke Roger   587828 587828 Fouke, Roger, of Wycombe 3
4620958 2237536 2237536 defendant Forde John   587828 587828 Forde, John, of Wycombe 4
4624917 2238764 2238764 defendant Holweye John   587828 587828 Holweye, John, of Wycombe 1
4629331 2240106 2240106 defendant Boure William shoemaker 587828 587828 Boure, William, of Wycombe, shoemaker 0
4634376 2241596 2241596 defendant Clerk William   587828 587828 Clerk, William, of Wycombe 0
4646247 2244974 2244974 plaintiff Plomere John   587828 587828 Plomere, John, of Wycombe 0
4646249 2244975 2244975 plaintiff Plomere John   587828 587828 Plomere, John, of Wycombe 0
4647809 2245422 2245422 defendant Boure William   587828 587828 Boure, William, of Wycombe 0
4666473 2250993 2250993 defendant Clerk John chapman 587828 587828 Clerk, John, of Wycombe, chapman 0
4677317 2258525 2258525 defendant Sperlyng Andrew gent 587828 587828 Sperlyng, Andrew, of Wycombe, gent 0
4678205 2258792 2258792 defendant Walton William cutler 587828 587828 Walton, William, of Wycombe, cutler 0
4692914 2263292 2263292 defendant Chapman Thomas mercer 587828 587828 Chapman, Thomas, of Wycombe, mercer 0
4695792 2264166 2264166 defendant Merston Thomas   587828 587828 Merston, Thomas, of Wycombe 0
4695794 2264167 2264167 defendant Merston Thomas   587828 587828 Merston, Thomas, of Wycombe 0
4704836 2266891 2266891 defendant Whyte Hugh carrier 587828 587828 Whyte, Hugh, of Wycombe, carrier 0
4704839 2266891 2266891 defendant Tawyer John husbandman 587828 587828 Tawyer, John, of Wycombe, husbandman 3
4709730 2268402 2268402 defendant Northyk William fishmonger 587828 587828 Northyk, William, of Wycombe, fishmonger 1
4710643 2268684 2268684 defendant Talworth Richard husbandman 587828 587828 Talworth, Richard, of Wycombe, husbandman 0
4723371 2272619 2272619 defendant Redehode Richard chandler 587828 587828 Redehode, Richard, of Wycombe, chandler 0
4733487 2275648 2275648 defendant Talworth Richard husbandman 587828 587828 Talworth, Richard, of Wycombe, husbandman 0
4750337 2280578 2280578 defendant Wode John   587828 587828 Wode, John, of Wycombe, cook 0
4759659 2283370 2283370 plaintiff Clerk William (legal representative) 587828 587828 Clerk, William, of Wycombe, executrix of 0
4779856 2289696 2289696 defendant Redehode Richard chandler 587828 587828 Redehode, Richard, of Wycombe, chandler 0
4786454 2291811 2291811 defendant Hoode John carter 587828 587828 Hoode, John, of Wycombe, carter 0
4788223 2292387 2292387 defendant Saundre William husbandman 587828 587828 Saundre, William, of Wycombe, husbandman 0
4808133 2298720 2298720 defendant Lote William shoemaker 587828 587828 Lote, William, of Wycombe, shoemaker 0
4822924 2303253 2303253 plaintiff Sperlyng Andrew   587828 587828 Sperlyng, Andrew, of Wycombe, on his own account 0
4845200 2310011 2310011 defendant Redehoode Richard   587828 587828 Redehoode, Richard, of Wycombe 0
4872785 2318437 2318437 defendant Redehede Richard   587828 587828 Redehede, Richard, of Wycombe 0
4876822 2319722 2319722 defendant Savage John husbandman 587828 587828 Savage, John, of Wycombe, husbandman 0
4892405 2324364 2324364 defendant Ernold Robert spicer 587828 587828 Ernold, Robert, of Wycombe, spicer 2
4905500 2328317 2328317 defendant Mervyn Richard yeoman 587828 587828 Mervyn, Richard, of Wycombe, yeoman 0
4933218 2336779 2336779 defendant Lovell John   587828 587828 Lovell, John, of Wycombe, Bucksm gent 0
4955058 2343464 2343464 defendant Curteys William tailor 587828 587828 Curteys, William, of Wycombe, tailor 1
4955061 2343465 2343465 defendant Curteys William tailor 587828 587828 Curteys, William, of Wycombe, tailor 1
4983882 2352107 2352107 plaintiff Wellesborn John   587828 587828 Wellesborn, John, of Wycombe 0
4983883 2352107 2352107 defendant Paslewe Ralph sawyer 587828 587828 Paslewe, Ralph, of Wycombe, sawyer 0
4996497 2355809 2355809 defendant Melburn John   587828 587828 Melburn, John, of Wycombe, tallow chandler 2
5020733 2362962 2362962 defendant Fourde John husbandman 587828 587828 Fourde, John, of Wycombe, husbandman 0
5022951 2363622 2363622 defendant Gom- John tailor 587828 587828 Gom-, John, of Wycombe, tailor 2
5024441 2364059 2364059 defendant Hamulden John currier 587828 587828 Hamulden, John, of Wycombe, currier 0
5028334 2365167 2365167 defendant Hampdon John   587828 587828 Hampdon, John, of Wycombe 3
5035867 2367344 2367344 defendant Grover Richard dyer 587828 587828 Grover, Richard, of Wycombe, dyer 0
5037916 2367969 2367969 defendant Baret William laborer 587828 587828 Baret, William, of Wycombe, laborer 0
5038478 2368147 2368147 defendant Baret Isabel widow 587828 587828 Baret, Isabel, of Wycombe, widow 0
5041933 2369187 2369187 plaintiff Cotyngham Robert husbandman 587828 587828 Cotyngham, Robert, of Wycombe, husbandman 0
5046695 2370634 2370634 plaintiff More Roger (legal representative) 587828 587828 More, Roger, of Wycombe, executors of 0
5050133 2371664 2371664 defendant Hechenden Walter chapman 587828 587828 Hechenden, Walter, of Wycombe, chapman 0
5057862 2373922 2373922 plaintiff Cotyngham Robert   587828 587828 Cotyngham, Robert, of Wycombe 0
5080606 2380688 2380688 defendant Orchard Thomas, junior baker 587828 587828 Orchard, Thomas, junior, of Wycombe, baker 1
5080607 2380688 2380688 defendant Thomasservant Philip   587828 587828 Thomasservant, Philip, of Wycombe, servant 2
5081064 2380839 2380839 plaintiff Cotyngham Robert   587828 587828 Cotyngham, Robert, of Wycombe 0
5090378 2383566 2383566 defendant Gomme or Gounne John tailor 587828 587828 Gomme or Gounne, John, of Wycombe, tailor 2
5096603 2385440 2385440 defendant Cotyngham Robert chapman 587828 587828 Cotyngham, Robert, of Wycombe, chapman 1
5096604 2385440 2385440 defendant Hill alias Cobbe Margaret widow 587828 587828 Hill alias Cobbe, Margaret, of Wycombe, widow 2
5103858 2387553 2387553 defendant White Richard husbandman 587828 587828 White, Richard, of Wycombe, husbandman 0
5123148 2393205 2393205 defendant Gomme or Gounne John tailor 587828 587828 Gomme or Gounne, John, of Wycombe, tailor 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);