names

137 rows where place_id = 586275

✎ 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
3588337 1864002 1864002 defendant Taillour Henry gent 586275 586275 Taillour, Henry, of Chepyng Barnet, gent 0
3592847 1865379 1865379 defendant Neweman Henry collier 586275 586275 Neweman, Henry, of Chepyng Barnet, collier 2
3592848 1865379 1865379 defendant William John butcher 586275 586275 William, John, of Chepyng Barnet, butcher 3
3595691 1866280 1866280 defendant Edward Richard butcher 586275 586275 Edward, Richard, of Chepyng Barnet, butcher 0
3608376 1870278 1870278 defendant Huet Margaret widow 586275 586275 Huet, Margaret, of Chepyng Barnet, widow 0
3609302 1870569 1870569 defendant Wode Edmund butcher 586275 586275 Wode, Edmund, of Chepyng Barnet, butcher 0
3615513 1872493 1872493 defendant Redmayn Richard gent 586275 586275 Redmayn, Richard, of Chepyng Barnet, gent 0
3615514 1872493 1872493 defendant Gardyner Roger yeoman 586275 586275 Gardyner, Roger, of Chepyng Barnet, yeoman 1
3615515 1872493 1872493 defendant Johnson Gilbert beer brewer 586275 586275 Johnson, Gilbert, of Chepyng Barnet, beer brewer 2
3615516 1872493 1872493 defendant Sharpe John laborer 586275 586275 Sharpe, John, of Chepyng Barnet, laborer 3
3618095 1873281 1873281 defendant Dorman John laborer 586275 586275 Dorman, John, of Chepyng Barnet, laborer 4
3654251 1911589 1911589 defendant Mighell William laborer 586275 586275 Mighell, William, of Chepyng Barnet, laborer 1
3678434 1919309 1919309 defendant Gunston John cooper 586275 586275 Gunston, John, of Chepyng Barnet, cooper 3
3680833 1920087 1920087 defendant Hyll William butcher 586275 586275 Hyll, William, of Chepyng Barnet, butcher 0
3680834 1920087 1920087 defendant Hogeson Robert tailor 586275 586275 Hogeson, Robert, of Chepyng Barnet, tailor 1
3680835 1920087 1920087 defendant Fydeler Thomas yeoman 586275 586275 Fydeler, Thomas, of Chepyng Barnet, yeoman 2
3680836 1920087 1920087 defendant Antony alias Nicoll Thomas smith 586275 586275 Antony alias Nicoll, Thomas, of Chepyng Barnet, smith 3
3689553 1922888 1922888 defendant Edward William butcher 586275 586275 Edward, William, of Chepyng Barnet, butcher 0
3695415 1924789 1924789 plaintiff Preston William   586275 586275 Preston, William, of Chepyng Barnet 0
3695621 1924859 1924859 defendant Hoddesdon Simon innholder 586275 586275 Hoddesdon, Simon, of Chepyng Barnet, innholder 0
3703905 1927502 1927502 defendant Edwardys William butcher 586275 586275 Edwardys, William, of Chepyng Barnet, butcher 0
3705944 1928146 1928146 plaintiff Hill Geoffrey husbandman 586275 586275 Hill, Geoffrey, of Chepyng Barnet, husbandman 0
3769928 1948252 1948252 plaintiff Salford William gent 586275 586275 Salford, William, of Chepyng Barnet, gent 0
3804787 1959442 1959442 defendant Ince William gent 586275 586275 Ince, William, of Chepyng Barnet, gent 0
4485494 2196170 2196170 plaintiff Raoulyn John (legal representative) 586275 586275 Raoulyn, John, of Chepyng Barnet, executors of 0
4485515 2196178 2196178 plaintiff Raulyn John (legal representative) 586275 586275 Raulyn, John, of Chepyng Barnet, executors of 0
4563092 2220023 2220023 plaintiff Raulyn John (legal representative) 586275 586275 Raulyn, John, of Chepyng Barnet, executors of 0
4563119 2220033 2220033 plaintiff Rawelyn John (legal representative) 586275 586275 Rawelyn, John, of Chepyng Barnet, merchant, executors of 0
4912527 2330419 2330419 defendant Hale John maltman 586275 586275 Hale, John, of Chepyng Barnet, maltman 0
4967234 2347135 2347135 plaintiff Elys Edmund (legal representative) 586275 586275 Elys, Edmund, of Chepyng Barnet, executors of 0
4977953 2350369 2350369 defendant Nicoll Thomas ostler 586275 586275 Nicoll, Thomas, of Chepyng Barnet, ostler 1
4978030 2350395 2350395 defendant Prest John smith 586275 586275 Prest, John, of Chepyng Barnet, smith 0
4981799 2351475 2351475 plaintiff Taillour John   586275 586275 Taillour, John, of Chepyng Barnet 0
5031812 2366175 2366175 defendant Goderych William tiler 586275 586275 Goderych, William, of Chepyng Barnet, tiler 1
5035138 2367141 2367141 plaintiff Tanner Thomas butcher 586275 586275 Tanner, Thomas, of Chepyng Barnet, butcher 0
5035139 2367141 2367141 plaintiff Alwey John laborer 586275 586275 Alwey, John, of Chepyng Barnet, laborer 1
5035140 2367141 2367141 defendant White Thomas cooper 586275 586275 White, Thomas, of Chepyng Barnet, cooper 0
5049794 2371567 2371567 defendant Hardewyn William yeoman 586275 586275 Hardewyn, William, of Chepyng Barnet, yeoman 1
5066978 2376648 2376648 defendant Chicheley Richard tiler 586275 586275 Chicheley, Richard, of Chepyng Barnet, tiler 1
5066979 2376648 2376648 defendant Heyton Richard tiler 586275 586275 Heyton, Richard, of Chepyng Barnet, tiler 2
5066981 2376648 2376648 defendant Hardwyn William yeoman 586275 586275 Hardwyn, William, of Chepyng Barnet, yeoman 4
5101587 2386883 2386883 defendant Hale John laborer 586275 586275 Hale, John, of Chepyng Barnet, laborer 2
5106570 2388348 2388348 defendant Mille Thomas maltman 586275 586275 Mille, Thomas, of Chepyng Barnet, maltman 0
5110551 2389485 2389485 defendant Catlet Richard butcher 586275 586275 Catlet, Richard, of Chepyng Barnet, butcher 0
5110552 2389485 2389485 defendant atte Hale Thomas maltman 586275 586275 atte Hale, Thomas, of Chepyng Barnet, maltman 1
5110553 2389485 2389485 defendant Heron John laborer 586275 586275 Heron, John, of Chepyng Barnet, laborer 2
5121291 2392661 2392661 defendant Hale John maltman 586275 586275 Hale, John, of Chepyng Barnet, maltman 0
5132100 2395880 2395880 defendant Vat Thomas carpenter 586275 586275 Vat, Thomas, of Chepyng Barnet, carpenter 3
5141540 2398641 2398641 defendant Smyth Thomas smith 586275 586275 Smyth, Thomas, of Chepyng Barnet, smith 1
5141547 2398641 2398641 defendant Haksalt William yeoman 586275 586275 Haksalt, William, of Chepyng Barnet, yeoman 8
5141555 2398642 2398642 defendant Haksalt William yeoman 586275 586275 Haksalt, William, of Chepyng Barnet, yeoman 5
5224359 2422799 2422799 defendant Priour John ostler 586275 586275 Priour, John, of Chepyng Barnet, ostler 0
5234774 2425761 2425761 defendant Osteler John osteler 586275 586275 Osteler, John, of Chepyng Barnet, osteler 1
5257471 2432458 2432458 defendant Myrfyn Thomas smith 586275 586275 Myrfyn, Thomas, of Chepyng Barnet, smith 0
5257472 2432458 2432458 defendant Harrys John sawyer 586275 586275 Harrys, John, of Chepyng Barnet, sawyer 1
5257473 2432458 2432458 defendant Bate Elizabeth widow 586275 586275 Bate, Elizabeth, of Chepyng Barnet, widow 2
5261115 2433587 2433587 defendant Banwell Richard yeoman 586275 586275 Banwell, Richard, of Chepyng Barnet, yeoman 0
5261117 2433588 2433588 defendant Banwell Richard yeoman 586275 586275 Banwell, Richard, of Chepyng Barnet, yeoman 0
5268152 2435809 2435809 defendant Godfrey John, senior maltman 586275 586275 Godfrey, John, senior, of Chepyng Barnet, maltman 0
5278439 2438801 2438801 defendant Grene Richard chaplain 586275 586275 Grene, Richard, of Chepyng Barnet, chaplain 0
5278440 2438801 2438801 defendant Wever Robert tailor 586275 586275 Wever, Robert, of Chepyng Barnet, tailor 1
5278442 2438801 2438801 defendant Trap Thomas ostler 586275 586275 Trap, Thomas, of Chepyng Barnet, ostler 3
5278445 2438802 2438802 defendant Catlotte John butcher 586275 586275 Catlotte, John, of Chepyng Barnet, butcher 1
5278446 2438802 2438802 defendant Chychele Richard tailor 586275 586275 Chychele, Richard, of Chepyng Barnet, tailor 2
5280075 2439247 2439247 defendant Elys John husbandman 586275 586275 Elys, John, of Chepyng Barnet, husbandman 1
5312813 2448862 2448862 plaintiff Bayly William yeoman 586275 586275 Bayly, William, of Chepyng Barnet, yeoman 0
5327848 2453396 2453396 defendant Hede Richard   586275 586275 Hede, Richard, of Chepyng Barnet, net maker 3
5329827 2453990 2453990 defendant Neweman Henry smith 586275 586275 Neweman, Henry, of Chepyng Barnet, smith 0
5336855 2456089 2456089 defendant Smyth Alan laborer 586275 586275 Smyth, Alan, of Chepyng Barnet, laborer 0
5336856 2456089 2456089 defendant Frenssh Robert laborer 586275 586275 Frenssh, Robert, of Chepyng Barnet, laborer 1
5336858 2456089 2456089 defendant Parkyn John laborer 586275 586275 Parkyn, John, of Chepyng Barnet, laborer 3
5339484 2456917 2456917 defendant Goodgame John cordwainer 586275 586275 Goodgame, John, of Chepyng Barnet, cordwainer 0
5339490 2456919 2456919 defendant Goodgame John cordwainer 586275 586275 Goodgame, John, of Chepyng Barnet, cordwainer 0
5348147 2459565 2459565 defendant Maleblanke John innholder 586275 586275 Maleblanke, John, of Chepyng Barnet, innholder 0
5348148 2459565 2459565 defendant Osteler John yeoman 586275 586275 Osteler, John, of Chepyng Barnet, yeoman 1
5348149 2459565 2459565 defendant Bette Roger painter 586275 586275 Bette, Roger, of Chepyng Barnet, painter 2
5348150 2459565 2459565 defendant Blakburn William laborer 586275 586275 Blakburn, William, of Chepyng Barnet, laborer 3
5352243 2460800 2460800 defendant Malblanke John innholder 586275 586275 Malblanke, John, of Chepyng Barnet, innholder 0
5365215 2464794 2464794 plaintiff Bayly William   586275 586275 Bayly, William, of Chepyng Barnet, inn holder 0
5365217 2464794 2464794 defendant Prat William, junior yeoman 586275 586275 Prat, William, junior, of Chepyng Barnet, yeoman 1
5372702 2467063 2467063 defendant Pratte William butcher 586275 586275 Pratte, William, of Chepyng Barnet, butcher 0
5380692 2469525 2469525 defendant Baylly Henry husbandman 586275 586275 Baylly, Henry, of Chepyng Barnet, husbandman 2
5382923 2470183 2470183 defendant Tayllour Henry yeoman 586275 586275 Tayllour, Henry, of Chepyng Barnet, yeoman 0
5384141 2470555 2470555 plaintiff Bayly William   586275 586275 Bayly, William, of Chepyng Barnet, inn holder 0
5385726 2470989 2470989 defendant Barbour Henry yeoman 586275 586275 Barbour, Henry, of Chepyng Barnet, yeoman 1
5385727 2470989 2470989 defendant Baylly Henry husbandman 586275 586275 Baylly, Henry, of Chepyng Barnet, husbandman 2
5387333 2471449 2471449 defendant Maleblank John yeoman 586275 586275 Maleblank, John, of Chepyng Barnet, yeoman 0
5392950 2473053 2473053 defendant Heron William baker 586275 586275 Heron, William, of Chepyng Barnet, baker 1
5392951 2473053 2473053 defendant Wodnet John baker 586275 586275 Wodnet, John, of Chepyng Barnet, baker 2
5393864 2473306 2473306 defendant Taillour Henry yeoman 586275 586275 Taillour, Henry, of Chepyng Barnet, yeoman 0
5394053 2473360 2473360 defendant Couston John yeoman 586275 586275 Couston, John, of Chepyng Barnet, yeoman 0
5395096 2473666 2473666 defendant Bledlowe Thomas laborer 586275 586275 Bledlowe, Thomas, of Chepyng Barnet, laborer 1
5395099 2473666 2473666 defendant Robynson William laborer 586275 586275 Robynson, William, of Chepyng Barnet, laborer 4
5397920 2474479 2474479 defendant Barbour Henry yeoman 586275 586275 Barbour, Henry, of Chepyng Barnet, yeoman 0
5397921 2474479 2474479 defendant Bayly Henry yeoman 586275 586275 Bayly, Henry, of Chepyng Barnet, yeoman 1
5399078 2474808 2474808 defendant Canon William tailor 586275 586275 Canon, William, of Chepyng Barnet, tailor 0
5399778 2475030 2475030 defendant Maleblank Joh yeoman 586275 586275 Maleblank, Joh, of Chepyng Barnet, yeoman 0
5402089 2475661 2475661 defendant Norresy William smith 586275 586275 Norresy, William, of Chepyng Barnet, smith 0
5402090 2475661 2475661 defendant Edwardes Richard botcher 586275 586275 Edwardes, Richard, of Chepyng Barnet, botcher 1
5405776 2476724 2476724 defendant Edwarde William butcher 586275 586275 Edwarde, William, of Chepyng Barnet, butcher 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);