names

85 rows where place_id = 607468

✎ 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
3669384 1916362 1916362 plaintiff Benet John yeoman 607468 607468 Benet, John, of Hadenham, yeoman 0
3706115 1928205 1928205 defendant Cray John husbandman 607468 607468 Cray, John, of Hadenham, husbandman 1
3727224 1934786 1934786 defendant Barnard Richard yeoman 607468 607468 Barnard, Richard, of Hadenham, yeoman 1
3727227 1934787 1934787 defendant Barnard Richard yeoman 607468 607468 Barnard, Richard, of Hadenham, yeoman 1
3727230 1934788 1934788 defendant Barnard Richard yeoman 607468 607468 Barnard, Richard, of Hadenham, yeoman 1
3762780 1945997 1945997 defendant Fryday Richard husbandman 607468 607468 Fryday, Richard, of Hadenham, husbandman 0
4200684 2095797 2095797 defendant Pope Stephen yeoman 607468 607468 Pope, Stephen, of Hadenham, yeoman 0
4396903 2163533 2163533 defendant Phipers Edward yeoman 607468 607468 Phipers, Edward, of Hadenham, yeoman 1
4396906 2163534 2163534 defendant Phipers Edward yeoman 607468 607468 Phipers, Edward, of Hadenham, yeoman 1
4419258 2170901 2170901 plaintiff Baly Joan   607468 607468 Baly, Joan, of Hadenham, formerly wife of John 0
4438811 2181431 2181431 plaintiff atte Herne John   607468 607468 atte Herne, John, of Hadenham, on his own account 0
4438899 2181461 2181461 plaintiff atte Nayssh Alan (legal representative) 607468 607468 atte Nayssh, Alan, of Hadenham, executors of 0
4438901 2181461 2181461 plaintiff Holyman Richard   607468 607468 Holyman, Richard, of Hadenham 2
4439479 2181612 2181612 plaintiff Baker John   607468 607468 Baker, John, of Hadenham 0
4439480 2181612 2181612 defendant Chapman Richard   607468 607468 Chapman, Richard, of Hadenham 0
4443720 2183005 2183005 plaintiff Chapman Richard   607468 607468 Chapman, Richard, of Hadenham 0
4443721 2183005 2183005 defendant Bakere John   607468 607468 Bakere, John, of Hadenham 0
4452467 2185767 2185767 defendant Wyghtcham William   607468 607468 Wyghtcham, William, of Hadenham 1
4519489 2206455 2206455 defendant Watte John skinner 607468 607468 Watte, John, of Hadenham, skinner 0
4528244 2209109 2209109 defendant Boteler Thomas   607468 607468 Boteler, Thomas, of Hadenham 0
4556546 2217983 2217983 defendant Drape John   607468 607468 Drape, John, of Hadenham 1
4593909 2229371 2229371 plaintiff Grelane John   607468 607468 Grelane, John, of Hadenham 1
4605857 2232946 2232946 plaintiff atte Forde Robert   607468 607468 atte Forde, Robert, of Hadenham 0
4622838 2238123 2238123 plaintiff Man William   607468 607468 Man, William, of Hadenham 0
4622842 2238123 2238123 defendant Mersshe John   607468 607468 Mersshe, John, of Hadenham 3
4622843 2238123 2238123 defendant Boydon William   607468 607468 Boydon, William, of Hadenham 4
4639799 2243144 2243144 defendant Haddam John   607468 607468 Haddam, John, of Hadenham 1
4682049 2260004 2260004 plaintiff Morys Stephen   607468 607468 Morys, Stephen, of Hadenham 0
4682051 2260004 2260004 defendant Chapman John husbandman 607468 607468 Chapman, John, of Hadenham, husbandman 0
4682052 2260004 2260004 defendant Waps John husbandman 607468 607468 Waps, John, of Hadenham, husbandman 1
4799719 2296099 2296099 defendant Otes William husbandman 607468 607468 Otes, William, of Hadenham, husbandman 0
4845333 2310052 2310052 defendant Merssh John husbandman 607468 607468 Merssh, John, of Hadenham, husbandman 3
4852949 2312344 2312344 defendant Freman Thomas gent 607468 607468 Freman, Thomas, of Hadenham, gent 0
4852951 2312345 2312345 defendant Freman Thomas gent 607468 607468 Freman, Thomas, of Hadenham, gent 0
4868871 2317239 2317239 defendant Mensherd Richard husbandman 607468 607468 Mensherd, Richard, of Hadenham, husbandman 1
4880823 2320909 2320909 defendant Muriel John chaplain 607468 607468 Muriel, John, of Hadenham, chaplain 0
4906018 2328480 2328480 defendant Frost Andrew husbandman 607468 607468 Frost, Andrew, of Hadenham, husbandman 3
4916103 2331537 2331537 defendant Robyn John husbandman 607468 607468 Robyn, John, of Hadenham, husbandman 1
4916104 2331537 2331537 defendant Neweman Robert husbandman 607468 607468 Neweman, Robert, of Hadenham, husbandman 2
4916105 2331537 2331537 defendant Cokayn Richard husbandman 607468 607468 Cokayn, Richard, of Hadenham, husbandman 3
4917062 2331844 2331844 plaintiff Freman Thomas gent 607468 607468 Freman, Thomas, of Hadenham, gent 0
4939181 2338642 2338642 defendant Berner William husbandman 607468 607468 Berner, William, of Hadenham, husbandman 0
4945764 2340661 2340661 defendant Colyns John yeoman 607468 607468 Colyns, John, of Hadenham, yeoman 0
4968191 2347437 2347437 plaintiff Freman Thomas gent 607468 607468 Freman, Thomas, of Hadenham, gent 0
4975094 2349520 2349520 defendant Fr- Andrew husbandman 607468 607468 Fr-, Andrew, of Hadenham, husbandman 2
4975095 2349520 2349520 defendant Welles John husbandman 607468 607468 Welles, John, of Hadenham, husbandman 3
4975103 2349521 2349521 defendant Frost Andrew husbandman 607468 607468 Frost, Andrew, of Hadenham, husbandman 2
4975104 2349521 2349521 defendant Welles John husbandman 607468 607468 Welles, John, of Hadenham, husbandman 3
4976900 2350043 2350043 defendant Prykke Thomas yeoman 607468 607468 Prykke, Thomas, of Hadenham, yeoman 0
4985366 2352545 2352545 defendant James alias Grene James butcher 607468 607468 James alias Grene, James, of Hadenham, butcher 0
5005785 2358591 2358591 defendant Atkyn John husbandman 607468 607468 Atkyn, John, of Hadenham, husbandman 0
5005786 2358591 2358591 defendant Grene Richard husbandman 607468 607468 Grene, Richard, of Hadenham, husbandman 1
5005789 2358591 2358591 defendant Dunnyng Robert husbandman 607468 607468 Dunnyng, Robert, of Hadenham, husbandman 4
5053008 2372495 2372495 defendant Barnham Robert husbandman 607468 607468 Barnham, Robert, of Hadenham, husbandman 0
5060507 2374721 2374721 defendant Berner William husbandman 607468 607468 Berner, William, of Hadenham, husbandman 0
5061448 2375014 2375014 defendant Broun Thomas butcher 607468 607468 Broun, Thomas, of Hadenham, butcher 0
5061450 2375015 2375015 defendant Broun Thomas butcher 607468 607468 Broun, Thomas, of Hadenham, butcher 0
5082626 2381308 2381308 defendant Chapman William husbandman 607468 607468 Chapman, William, of Hadenham, husbandman 0
5111546 2389774 2389774 defendant Nyghtyngale Robert tailor 607468 607468 Nyghtyngale, Robert, of Hadenham, tailor 0
5121723 2392782 2392782 defendant Byrd William husbandman 607468 607468 Byrd, William, of Hadenham, husbandman 0
5164994 2405500 2405500 defendant Chapman William husbandman 607468 607468 Chapman, William, of Hadenham, husbandman 0
5173394 2407925 2407925 defendant Fryday Giles husbandman 607468 607468 Fryday, Giles, of Hadenham, husbandman 0
5201550 2416211 2416211 defendant Chapman William husbandman 607468 607468 Chapman, William, of Hadenham, husbandman 0
5261554 2433724 2433724 defendant Stewkeley Thomas gent 607468 607468 Stewkeley, Thomas, of Hadenham, gent 0
5261556 2433725 2433725 defendant Stewkeley Thomas gent 607468 607468 Stewkeley, Thomas, of Hadenham, gent 0
5298883 2444654 2444654 defendant West Robert husbandman 607468 607468 West, Robert, of Hadenham, husbandman 0
5305049 2446510 2446510 defendant Weste Robert husbandman 607468 607468 Weste, Robert, of Hadenham, husbandman 0
5315352 2449648 2449648 defendant Birde William yeoman 607468 607468 Birde, William, of Hadenham, yeoman 0
5335821 2455778 2455778 plaintiff Grene Thomas (legal representative) 607468 607468 Grene, Thomas, of Hadenham, executor of 0
5346049 2458903 2458903 defendant Wyllowes Thomas butcher 607468 607468 Wyllowes, Thomas, of Hadenham, butcher 0
5353743 2461237 2461237 plaintiff Grene Thomas (legal representative) 607468 607468 Grene, Thomas, of Hadenham, executor of 0
5366995 2465325 2465325 defendant Warde Bernard husbandman 607468 607468 Warde, Bernard, of Hadenham, husbandman 0
5366996 2465325 2465325 defendant Colard Robert husbandman 607468 607468 Colard, Robert, of Hadenham, husbandman 1
5420120 2480935 2480935 defendant Trappe Nicholas gent 607468 607468 Trappe, Nicholas, of Hadenham, gent 0
5438834 2486535 2486535 defendant Trappe Nicholas gent 607468 607468 Trappe, Nicholas, of Hadenham, gent 0
5452579 2490656 2490656 defendant _oppe Nicholas gent 607468 607468 _oppe, Nicholas, of Hadenham, gent 0
5464647 2494343 2494343 defendant Trappe Nicholas gent 607468 607468 Trappe, Nicholas, of Hadenham, gent 0
5484547 2500298 2500298 defendant Willeys John yeoman 607468 607468 Willeys, John, of Hadenham, yeoman 0
5499794 2504885 2504885 defendant Brademan Thomas husbandman 607468 607468 Brademan, Thomas, of Hadenham, husbandman 0
5584056 2530086 2530086 defendant Wodbrygge William cordwainer 607468 607468 Wodbrygge, William, of Hadenham, cordwainer 0
5588653 2531460 2531460 defendant Temple Edmund husbandman 607468 607468 Temple, Edmund, of Hadenham, husbandman 0
5611125 2547204 2547204 defendant Saundres John   607468 607468 Saundres, John, of Hadenham 0
5613579 2548023 2548023 defendant Claydon John   607468 607468 Claydon, John, of Hadenham 0
5625520 2551924 2551924 defendant Grene James yeoman 607468 607468 Grene, James, of Hadenham, yeoman 1
5625521 2551924 2551924 defendant Grene John yeoman 607468 607468 Grene, John, of Hadenham, yeoman 2

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