names

95 rows where place_id = 587285

✎ 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
3590990 1864807 1864807 defendant Bacon Thomas mercer 587285 587285 Bacon, Thomas, of Kyngesthorp, mercer 0
3626147 1903040 1903040 defendant Reve John husbandman 587285 587285 Reve, John, of Kyngesthorp, husbandman 0
3626148 1903040 1903040 defendant Coke Thomas husbandman 587285 587285 Coke, Thomas, of Kyngesthorp, husbandman 1
3673043 1917577 1917577 plaintiff Dyconson Peter yeoman 587285 587285 Dyconson, Peter, of Kyngesthorp, yeoman 0
3718920 1932197 1932197 defendant Maxe Henry gent 587285 587285 Maxe, Henry, of Kyngesthorp, gent 0
3722585 1933325 1933325 defendant Dowe John husbandman 587285 587285 Dowe, John, of Kyngesthorp, husbandman 1
3722586 1933325 1933325 defendant Thomson Thomas husbandman 587285 587285 Thomson, Thomas, of Kyngesthorp, husbandman 2
3722598 1933328 1933328 defendant Tompson Thomas baker 587285 587285 Tompson, Thomas, of Kyngesthorp, baker 0
3744958 1940328 1940328 defendant Mulso John cardmaker 587285 587285 Mulso, John, of Kyngesthorp, cardmaker 0
3774246 1949665 1949665 defendant Maxe Henry gent 587285 587285 Maxe, Henry, of Kyngesthorp, gent 0
3792056 1955369 1955369 defendant Maxe Henry gent 587285 587285 Maxe, Henry, of Kyngesthorp, gent 0
3808594 1960566 1960566 defendant Maxe Henry gent 587285 587285 Maxe, Henry, of Kyngesthorp, gent 0
3859898 1976816 1976816 defendant Boddymer Henry   587285 587285 Boddymer, Henry, of Kyngesthorp, horse courser 1
4086975 2055634 2055634 defendant Mottershed John gent 587285 587285 Mottershed, John, of Kyngesthorp, gent 0
4086976 2055634 2055634 defendant Shorley George laborer 587285 587285 Shorley, George, of Kyngesthorp, laborer 1
4086977 2055634 2055634 defendant Goodman Nicholas laborer 587285 587285 Goodman, Nicholas, of Kyngesthorp, laborer 2
4086978 2055634 2055634 defendant Weston John laborer 587285 587285 Weston, John, of Kyngesthorp, laborer 3
4462960 2189114 2189114 defendant Hogekyn Henry   587285 587285 Hogekyn, Henry, of Kyngesthorp 0
4486837 2196598 2196598 defendant Duffeld John   587285 587285 Duffeld, John, of Kyngesthorp 0
4491077 2197898 2197898 plaintiff West John   587285 587285 West, John, of Kyngesthorp, on his own account 0
4526937 2208708 2208708 plaintiff Lee John   587285 587285 Lee, John, of Kyngesthorp 0
4526939 2208709 2208709 plaintiff Lee John   587285 587285 Lee, John, of Kyngesthorp 0
4535411 2211346 2211346 defendant Pypar Reginald   587285 587285 Pypar, Reginald, of Kyngesthorp 0
4624565 2238664 2238664 defendant Blokley John   587285 587285 Blokley, John, of Kyngesthorp 4
4635912 2242065 2242065 defendant Staunton William   587285 587285 Staunton, William, of Kyngesthorp 5
4642102 2243801 2243801 plaintiff Greyby John master of the house or hospital of Holy Trinity 587285 587285 Greyby, John, of Kyngesthorp, master of the house or hospital of Holy Trinity 0
4728462 2274133 2274133 defendant Broke John husbandman 587285 587285 Broke, John, of Kyngesthorp, husbandman 0
4746473 2279461 2279461 plaintiff Herfrey Thomas   587285 587285 Herfrey, Thomas, of Kyngesthorp 0
4748116 2279959 2279959 defendant Rote William husbandman 587285 587285 Rote, William, of Kyngesthorp, husbandman 0
4822995 2303273 2303273 defendant Greyby John gent 587285 587285 Greyby, John, of Kyngesthorp, gent 1
4832013 2306044 2306044 defendant Capell John   587285 587285 Capell, John, of Kyngesthorp, mason 0
4836343 2307342 2307342 defendant Chyld John yeoman 587285 587285 Chyld, John, of Kyngesthorp, yeoman 1
4836352 2307344 2307344 defendant Greyby John gent 587285 587285 Greyby, John, of Kyngesthorp, gent 0
4848092 2310871 2310871 defendant Greyby John gent 587285 587285 Greyby, John, of Kyngesthorp, gent 0
4892087 2324266 2324266 defendant Greyby John husbandman 587285 587285 Greyby, John, of Kyngesthorp, husbandman 0
4893112 2324563 2324563 defendant Branfeld William husbandman 587285 587285 Branfeld, William, of Kyngesthorp, husbandman 2
4919957 2332753 2332753 defendant Michell John husbandman 587285 587285 Michell, John, of Kyngesthorp, husbandman 0
4950723 2342194 2342194 defendant Bacon John ploughman 587285 587285 Bacon, John, of Kyngesthorp, ploughman 0
4950724 2342194 2342194 defendant Reve Thomas ploughman 587285 587285 Reve, Thomas, of Kyngesthorp, ploughman 1
4954260 2343247 2343247 defendant Michell John husbandman 587285 587285 Michell, John, of Kyngesthorp, husbandman 1
4954261 2343247 2343247 defendant Michell Thomas husbandman 587285 587285 Michell, Thomas, of Kyngesthorp, husbandman 2
4954264 2343248 2343248 defendant Michell John husbandman 587285 587285 Michell, John, of Kyngesthorp, husbandman 1
4954265 2343248 2343248 defendant Michell Thomas husbandman 587285 587285 Michell, Thomas, of Kyngesthorp, husbandman 2
4961139 2345294 2345294 defendant Doweke William husbandman 587285 587285 Doweke, William, of Kyngesthorp, husbandman 0
5066353 2376463 2376463 defendant Ebrounde William husbandman 587285 587285 Ebrounde, William, of Kyngesthorp, husbandman 5
5075446 2379152 2379152 defendant Elys John husbandman 587285 587285 Elys, John, of Kyngesthorp, husbandman 0
5075885 2379281 2379281 defendant Hopkyn William husbandman 587285 587285 Hopkyn, William, of Kyngesthorp, husbandman 0
5092357 2384142 2384142 defendant Bacon John   587285 587285 Bacon, John, of Kyngesthorp, franklin 0
5101474 2386841 2386841 defendant Dalet Robert husbandman 587285 587285 Dalet, Robert, of Kyngesthorp, husbandman 0
5101475 2386841 2386841 defendant Mychell Margery widow 587285 587285 Mychell, Margery, of Kyngesthorp, widow 1
5101837 2386959 2386959 defendant Mochell Joan widow 587285 587285 Mochell, Joan, of Kyngesthorp, widow 1
5104696 2387809 2387809 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5104698 2387810 2387810 defendant Dove William yeoman 587285 587285 Dove, William, of Kyngesthorp, yeoman 0
5111584 2389783 2389783 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5125308 2393884 2393884 plaintiff Bacon John   587285 587285 Bacon, John, of Kyngesthorp 0
5125571 2393966 2393966 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 2
5126923 2394350 2394350 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5143908 2399360 2399360 plaintiff Bacon John   587285 587285 Bacon, John, of Kyngesthorp 0
5144233 2399465 2399465 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5145646 2399868 2399868 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5149311 2400930 2400930 plaintiff Dowse William   587285 587285 Dowse, William, of Kyngesthorp 0
5149313 2400931 2400931 plaintiff Dowse William   587285 587285 Dowse, William, of Kyngesthorp 0
5149544 2400996 2400996 defendant Revell John fishmonger 587285 587285 Revell, John, of Kyngesthorp, fishmonger 0
5164943 2405483 2405483 plaintiff Bacon John   587285 587285 Bacon, John, of Kyngesthorp 0
5165136 2405549 2405549 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5166008 2405800 2405800 defendant Bacon Johhn husbandman 587285 587285 Bacon, Johhn, of Kyngesthorp, husbandman 0
5168281 2406439 2406439 plaintiff Dowse William   587285 587285 Dowse, William, of Kyngesthorp 0
5178548 2409440 2409440 plaintiff Bacon John   587285 587285 Bacon, John, of Kyngesthorp 0
5178552 2409441 2409441 plaintiff Bacon John   587285 587285 Bacon, John, of Kyngesthorp 0
5178866 2409545 2409545 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5180771 2410114 2410114 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5180776 2410115 2410115 defendant Bacon John husbandman 587285 587285 Bacon, John, of Kyngesthorp, husbandman 0
5184142 2411100 2411100 plaintiff Dowse William   587285 587285 Dowse, William, of Kyngesthorp 0
5201495 2416195 2416195 plaintiff Bacon John   587285 587285 Bacon, John, of Kyngesthorp 0
5201650 2416249 2416249 defendant Johnson Richard fuller 587285 587285 Johnson, Richard, of Kyngesthorp, fuller 2
5204183 2416978 2416978 plaintiff Dowse William   587285 587285 Dowse, William, of Kyngesthorp 0
5217347 2420810 2420810 defendant Pek Richard gent 587285 587285 Pek, Richard, of Kyngesthorp, gent 1
5242629 2428050 2428050 defendant Balen Thomas husbandman 587285 587285 Balen, Thomas, of Kyngesthorp, husbandman 0
5254727 2431592 2431592 defendant Dove William yeoman 587285 587285 Dove, William, of Kyngesthorp, yeoman 0
5351402 2460539 2460539 defendant Bacon Thomas yeoman 587285 587285 Bacon, Thomas, of Kyngesthorp, yeoman 0
5380132 2469367 2469367 defendant Hoker John husbandman 587285 587285 Hoker, John, of Kyngesthorp, husbandman 0
5417674 2480209 2480209 plaintiff Playn Thomas master of the hospital of the Holy Trinity & St David 587285 587285 Playn, Thomas, of Kyngesthorp, master of the hospital of the Holy Trinity & St David 0
5436967 2485989 2485989 plaintiff Shepard Stephen draper 587285 587285 Shepard, Stephen, of Kyngesthorp, draper 0
5436971 2485990 2485990 defendant Warde William yeoman 587285 587285 Warde, William, of Kyngesthorp, yeoman 1
5451527 2490333 2490333 plaintiff Shepard Stephen draper 587285 587285 Shepard, Stephen, of Kyngesthorp, draper 0
5475095 2497539 2497539 plaintiff Shepherd Stephen draper 587285 587285 Shepherd, Stephen, of Kyngesthorp, draper 0
5505742 2506714 2506714 plaintiff Broke Clement   587285 587285 Broke, Clement, of Kyngesthorp, bailiff 0
5505745 2506714 2506714 defendant Rayneford Oliver miller 587285 587285 Rayneford, Oliver, of Kyngesthorp, miller 0
5505746 2506714 2506714 defendant Smyth John husbandman 587285 587285 Smyth, John, of Kyngesthorp, husbandman 1
5505747 2506714 2506714 defendant Draper Richard husbandman 587285 587285 Draper, Richard, of Kyngesthorp, husbandman 2
5518128 2510505 2510505 defendant Hoker John yeoman 587285 587285 Hoker, John, of Kyngesthorp, yeoman 1
5535563 2515652 2515652 defendant Spencer John   587285 587285 Spencer, John, of Kyngesthorp, tallow chandler 0
5535564 2515652 2515652 defendant Michell Alice spinster 587285 587285 Michell, Alice, of Kyngesthorp, spinster 1
5569798 2525741 2525741 defendant Heynes John carpenter 587285 587285 Heynes, John, of Kyngesthorp, carpenter 0
5578272 2528274 2528274 defendant Dove John husbandman 587285 587285 Dove, John, of Kyngesthorp, husbandman 0

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