names

73 rows where place_id = 598096

✎ 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
3631123 1904554 1904554 defendant Carter John husbandman 598096 598096 Carter, John, of Folkyngham, husbandman 0
3641082 1907654 1907654 plaintiff Basset William esq 598096 598096 Basset, William, of Folkyngham, esq 0
3641090 1907657 1907657 plaintiff Bassett William esq 598096 598096 Bassett, William, of Folkyngham, esq 0
3654803 1911763 1911763 plaintiff Bassett William esq 598096 598096 Bassett, William, of Folkyngham, esq 0
3731181 1935974 1935974 defendant Raynthorp John yeoman 598096 598096 Raynthorp, John, of Folkyngham, yeoman 0
3731490 1936076 1936076 defendant Raynthorp John yeoman 598096 598096 Raynthorp, John, of Folkyngham, yeoman 0
3778848 1951098 1951098 defendant Smyth Hugh husbandman 598096 598096 Smyth, Hugh, of Folkyngham, husbandman 1
3842444 1971173 1971173 defendant Claymond Richard husbandman 598096 598096 Claymond, Richard, of Folkyngham, husbandman 1
3863389 1977951 1977951 defendant Loughborowe Francis yeoman 598096 598096 Loughborowe, Francis, of Folkyngham, yeoman 0
3868794 1979804 1979804 defendant Longborowe Francis yeoman 598096 598096 Longborowe, Francis, of Folkyngham, yeoman 0
3868795 1979804 1979804 defendant Warde William husbandman 598096 598096 Warde, William, of Folkyngham, husbandman 1
3878674 1983116 1983116 defendant Raynthorp Thomas husbandman 598096 598096 Raynthorp, Thomas, of Folkyngham, husbandman 0
3916520 1995901 1995901 defendant Robynson Robert husbandman 598096 598096 Robynson, Robert, of Folkyngham, husbandman 2
3916521 1995901 1995901 defendant Warde William husbandman 598096 598096 Warde, William, of Folkyngham, husbandman 3
3970813 2014379 2014379 defendant Greneham John yeoman 598096 598096 Greneham, John, of Folkyngham, yeoman 7
3970837 2014381 2014381 defendant Greneham John yeoman 598096 598096 Greneham, John, of Folkyngham, yeoman 7
3983062 2018717 2018717 defendant Gamen Thomas yeoman 598096 598096 Gamen, Thomas, of Folkyngham, yeoman 0
4012325 2029129 2029129 defendant Grenham John innholder 598096 598096 Grenham, John, of Folkyngham, yeoman, or of Donyngton, innholder 0
4031350 2035884 2035884 defendant Gamon Thomas gent 598096 598096 Gamon, Thomas, of Folkyngham, gent 2
4032241 2036204 2036204 defendant Greneham John yeoman 598096 598096 Greneham, John, of Folkyngham, yeoman 0
4047047 2041393 2041393 defendant Greneham John yeoman 598096 598096 Greneham, John, of Folkyngham, yeoman 0
4064987 2047762 2047762 defendant Boston Thomas husbandman 598096 598096 Boston, Thomas, of Folkyngham, husbandman 0
4101133 2060718 2060718 defendant Gamon Thomas gent 598096 598096 Gamon, Thomas, of Folkyngham, gent 0
4101135 2060718 2060718 defendant Gamon or Gamond Charles   598096 598096 Gamon or Gamond, Charles, of Folkyngham, gent, son of Thomas 2
4479756 2194332 2194332 plaintiff Julson John   598096 598096 Julson, John, of Folkyngham 0
4485281 2196099 2196099 defendant Constable Robert   598096 598096 Constable, Robert, of Folkyngham 1
4504558 2201982 2201982 defendant Taillour Alan   598096 598096 Taillour, Alan, of Folkyngham 1
4511847 2204154 2204154 defendant Taillour Alan   598096 598096 Taillour, Alan, of Folkyngham 2
4545001 2214356 2214356 defendant Northfolke Agnes   598096 598096 Northfolke, Agnes, of Folkyngham 4
4553746 2217093 2217093 defendant Wryght Thomas   598096 598096 Wryght, Thomas, of Folkyngham 3
4592924 2229114 2229114 defendant Scothowe Robert   598096 598096 Scothowe, Robert, of Folkyngham 0
4596880 2230264 2230264 plaintiff Saperton John   598096 598096 Saperton, John, of Folkyngham 0
4596882 2230264 2230264 defendant Smyth Alan   598096 598096 Smyth, Alan, of Folkyngham 1
4646946 2245169 2245169 plaintiff Godebowe John   598096 598096 Godebowe, John, of Folkyngham 1
4672220 2256959 2256959 defendant Chapman Adam chapman 598096 598096 Chapman, Adam, of Folkyngham, chapman 0
4696129 2264272 2264272 defendant Skenyngton John draper 598096 598096 Skenyngton, John, of Folkyngham, draper 1
4699844 2265397 2265397 defendant Estwell Roger   598096 598096 Estwell, Roger, of Folkyngham, parson 0
4727037 2273720 2273720 defendant Stokes Thomas yeoman 598096 598096 Stokes, Thomas, of Folkyngham, yeoman 1
4727039 2273720 2273720 defendant Chapman William mercer 598096 598096 Chapman, William, of Folkyngham, mercer 3
4729418 2274414 2274414 defendant Scothowe Robert butcher 598096 598096 Scothowe, Robert, of Folkyngham, butcher 3
4729419 2274414 2274414 defendant Chapman Adam mercer 598096 598096 Chapman, Adam, of Folkyngham, mercer 4
4745678 2279248 2279248 defendant Chapman Adam chapman 598096 598096 Chapman, Adam, of Folkyngham, chapman 1
4747711 2279839 2279839 defendant Chapman Adam mercer 598096 598096 Chapman, Adam, of Folkyngham, mercer 1
4750702 2280692 2280692 defendant Chapman William chapman 598096 598096 Chapman, William, of Folkyngham, chapman 2
4770299 2286682 2286682 defendant Patryk William yeoman 598096 598096 Patryk, William, of Folkyngham, yeoman 1
4773427 2287662 2287662 defendant Dembylby William   598096 598096 Dembylby, William, of Folkyngham, bailiff 1
4779655 2289625 2289625 defendant Chapman Adam husbandman 598096 598096 Chapman, Adam, of Folkyngham, husbandman 0
4783900 2290980 2290980 defendant Patrik William yeoman 598096 598096 Patrik, William, of Folkyngham, yeoman 1
4784315 2291092 2291092 defendant Holte Robert cordwainer 598096 598096 Holte, Robert, of Folkyngham, cordwainer 1
4784316 2291092 2291092 defendant Wyldeblode John shoemaker 598096 598096 Wyldeblode, John, of Folkyngham, shoemaker 2
4814858 2300757 2300757 defendant Neweton Thomas   598096 598096 Neweton, Thomas, of Folkyngham, parson & clerk 0
4820626 2302524 2302524 defendant Chapman Adam chapman 598096 598096 Chapman, Adam, of Folkyngham, chapman 0
4820627 2302524 2302524 defendant Miles Geoffrey husbandman 598096 598096 Miles, Geoffrey, of Folkyngham, husbandman 1
4845545 2310116 2310116 defendant Hardy John   598096 598096 Hardy, John, of Folkyngham, parson 6
4862155 2315177 2315177 plaintiff de Beaumont John   598096 598096 de Beaumont, John, of Folkyngham, knight 0
4871124 2317946 2317946 plaintiff Robynson John   598096 598096 Robynson, John, of Folkyngham 2
4872266 2318284 2318284 defendant Hawh Robert chaplain 598096 598096 Hawh, Robert, of Folkyngham, chaplain 1
4955222 2343522 2343522 defendant Gedeney John husbandman 598096 598096 Gedeney, John, of Folkyngham, husbandman 1
5035221 2367163 2367163 defendant Gedney John husbandman 598096 598096 Gedney, John, of Folkyngham, husbandman 3
5116454 2391246 2391246 plaintiff Oxton Robert   598096 598096 Oxton, Robert, of Folkyngham 0
5210918 2418925 2418925 defendant Smyth Robert husbandman 598096 598096 Smyth, Robert, of Folkyngham, husbandman 3
5219805 2421517 2421517 defendant Taillour James tailor 598096 598096 Taillour, James, of Folkyngham, tailor 4
5242237 2427929 2427929 defendant atte Halle John husbandman 598096 598096 atte Halle, John, of Folkyngham, husbandman 0
5256235 2432075 2432075 defendant Mason Thomas yeoman 598096 598096 Mason, Thomas, of Folkyngham, yeoman 2
5279677 2439139 2439139 defendant Peryman Thomas draper 598096 598096 Peryman, Thomas, of Folkyngham, draper 0
5291536 2442527 2442527 defendant Baily Robert yeoman 598096 598096 Baily, Robert, of Folkyngham, yeoman 0
5295759 2443754 2443754 defendant Webster John husbandman 598096 598096 Webster, John, of Folkyngham, husbandman 0
5346885 2459184 2459184 plaintiff Bailly Robert   598096 598096 Bailly, Robert, of Folkyngham 0
5501940 2505533 2505533 plaintiff Strode William   598096 598096 Strode, William, of Folkyngham 0
5609830 2546777 2546777 defendant Constable Robert   598096 598096 Constable, Robert, of Folkyngham 0
5624472 2551597 2551597 defendant Chapman Adam mercer 598096 598096 Chapman, Adam, of Folkyngham, mercer 1
5624474 2551597 2551597 defendant Clerk William clerk 598096 598096 Clerk, William, of Folkyngham, clerk 3
5625577 2551942 2551942 defendant Boteler John (legal representative) 598096 598096 Boteler, John, of Folkyngham, executors of 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);