names

60 rows where place_id = 586301

✎ 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
3588384 1864017 1864017 defendant Broun Thomas laborer 586301 586301 Broun, Thomas, of Fornham All Saints, laborer 2
3591487 1864965 1864965 plaintiff Edward Thomas   586301 586301 Edward, Thomas, of Fornham All Saints 0
3616734 1872864 1872864 plaintiff Edward Thomas   586301 586301 Edward, Thomas, of Fornham All Saints 0
3639475 1907151 1907151 defendant Fytkys Thomas smith 586301 586301 Fytkys, Thomas, of Fornham All Saints, smith 1
3652913 1911237 1911237 defendant Faux Thomas smith 586301 586301 Faux, Thomas, of Fornham All Saints, smith 1
3658167 1912810 1912810 defendant Davy John husbandman 586301 586301 Davy, John, of Fornham All Saints, husbandman 1
3663204 1914412 1914412 defendant Faux Thomas smith 586301 586301 Faux, Thomas, of Fornham All Saints, smith 0
3676903 1918816 1918816 defendant Fakys Thomas smith 586301 586301 Fakys, Thomas, of Fornham All Saints, smith 0
3677616 1919040 1919040 defendant Fakys Thomas smith 586301 586301 Fakys, Thomas, of Fornham All Saints, smith 0
3678978 1919495 1919495 defendant Spaldyng Henry yeoman 586301 586301 Spaldyng, Henry, of Fornham All Saints, yeoman 0
3684324 1921231 1921231 defendant Spaldyng Henry husbandman 586301 586301 Spaldyng, Henry, of Fornham All Saints, husbandman 0
3688536 1922573 1922573 defendant Langham William laborer 586301 586301 Langham, William, of Fornham All Saints, laborer 4
3714030 1930687 1930687 defendant Fakys Thomas smith 586301 586301 Fakys, Thomas, of Fornham All Saints, smith 0
3746753 1940899 1940899 defendant Damme Robert gent 586301 586301 Damme, Robert, of Fornham All Saints, gent 0
3780651 1951675 1951675 defendant Spaldyng Henry yeoman 586301 586301 Spaldyng, Henry, of Fornham All Saints, yeoman 0
3800479 1958071 1958071 defendant Fawxe Thomas smith 586301 586301 Fawxe, Thomas, of Fornham All Saints, smith 0
3834390 1968699 1968699 defendant Davy John husbandman 586301 586301 Davy, John, of Fornham All Saints, husbandman 0
3834391 1968699 1968699 defendant Davy Thomas husbandman 586301 586301 Davy, Thomas, of Fornham All Saints, husbandman 1
4015214 2030132 2030132 defendant Skynner Theodore yeoman 586301 586301 Skynner, Theodore, of Fornham All Saints, yeoman 1
4498930 2200304 2200304 defendant Pepir John   586301 586301 Pepir, John, of Fornham All Saints 1
4542783 2213631 2213631 defendant Tailour John   586301 586301 Tailour, John, of Fornham All Saints 0
4581509 2225671 2225671 plaintiff Durham Thomas de   586301 586301 Durham, Thomas de, of Fornham All Saints, parson 0
4661061 2249284 2249284 defendant Kyngeston Thomas yeoman 586301 586301 Kyngeston, Thomas, of Fornham All Saints, yeoman 0
4661062 2249284 2249284 defendant Kyngeston Robert yeoman 586301 586301 Kyngeston, Robert, of Fornham All Saints, yeoman 1
4665108 2250568 2250568 plaintiff Herry Robert   586301 586301 Herry, Robert, of Fornham All Saints 0
4674427 2257614 2257614 plaintiff Durham Thomas   586301 586301 Durham, Thomas, of Fornham All Saints, parson, on his own account 0
4691836 2262983 2262983 plaintiff Alfred Richard   586301 586301 Alfred, Richard, of Fornham All Saints 0
4764652 2284931 2284931 defendant Skarpp John yeoman 586301 586301 Skarpp, John, of Fornham All Saints, yeoman 1
4764653 2284931 2284931 defendant Morf_ John yeoman 586301 586301 Morf_, John, of Fornham All Saints, yeoman 2
4780575 2289921 2289921 defendant Goshauk John husbandman 586301 586301 Goshauk, John, of Fornham All Saints, husbandman 0
4829172 2305165 2305165 defendant Grene Richard laborer 586301 586301 Grene, Richard, of Fornham All Saints, laborer 0
4886650 2322689 2322689 defendant Howelot John smith 586301 586301 Howelot, John, of Fornham All Saints, smith 2
4941194 2339270 2339270 defendant Baret Nicholas husbandman 586301 586301 Baret, Nicholas, of Fornham All Saints, husbandman 0
4941195 2339270 2339270 defendant Prynce Lawrence tailor 586301 586301 Prynce, Lawrence, of Fornham All Saints, tailor 1
4941196 2339270 2339270 defendant Morce John husbandman 586301 586301 Morce, John, of Fornham All Saints, husbandman 2
4941197 2339270 2339270 defendant Grene John, senior laborer 586301 586301 Grene, John, senior, of Fornham All Saints, laborer 3
4941198 2339270 2339270 defendant Spaldyng Walter husbandman 586301 586301 Spaldyng, Walter, of Fornham All Saints, husbandman 4
4941199 2339270 2339270 defendant Brette John husbandman 586301 586301 Brette, John, of Fornham All Saints, husbandman 5
4961394 2345378 2345378 defendant Mason Walter yeoman 586301 586301 Mason, Walter, of Fornham All Saints, yeoman 0
4967045 2347077 2347077 defendant Moos William cordwainer 586301 586301 Moos, William, of Fornham All Saints, cordwainer 1
4988222 2353447 2353447 defendant Mos William husbandman 586301 586301 Mos, William, of Fornham All Saints, husbandman 1
4999450 2356705 2356705 defendant Fysshere Edmund husbandman 586301 586301 Fysshere, Edmund, of Fornham All Saints, husbandman 4
5019922 2362707 2362707 defendant Mors William cordwainer 586301 586301 Mors, William, of Fornham All Saints, or of Bury St Edmunds, cordwainer 0
5045815 2370383 2370383 defendant Smyth John (legal representative) 586301 586301 Smyth, John, of Fornham All Saints, parson, executors of 2
5104026 2387602 2387602 defendant Wynde Henry husbandman 586301 586301 Wynde, Henry, of Fornham All Saints, husbandman 3
5116217 2391171 2391171 defendant Wynde Henry husbandman 586301 586301 Wynde, Henry, of Fornham All Saints, husbandman 1
5135913 2397016 2397016 defendant Mayhew Henry miller 586301 586301 Mayhew, Henry, of Fornham All Saints, miller 1
5156174 2402966 2402966 defendant Mayhew Henry miller 586301 586301 Mayhew, Henry, of Fornham All Saints, miller 1
5218542 2421154 2421154 plaintiff Grene Andrew (legal representative) 586301 586301 Grene, Andrew, of Fornham All Saints, executors of 0
5220126 2421594 2421594 defendant London John husbandman 586301 586301 London, John, of Fornham All Saints, husbandman 3
5220127 2421594 2421594 defendant Spaldyng John husbandman 586301 586301 Spaldyng, John, of Fornham All Saints, husbandman 4
5256772 2432241 2432241 plaintiff Edward Thomas, senior yeoman 586301 586301 Edward, Thomas, senior, of Fornham All Saints, yeoman 0
5259049 2432946 2432946 defendant Spaldyng Thomas husbandman 586301 586301 Spaldyng, Thomas, of Fornham All Saints, husbandman 0
5259051 2432947 2432947 defendant Spaldyng Thomas husbandman 586301 586301 Spaldyng, Thomas, of Fornham All Saints, husbandman 0
5365362 2464839 2464839 defendant Dowe John weaver 586301 586301 Dowe, John, of Fornham All Saints, weaver 3
5411205 2478310 2478310 defendant Prynce William tailor 586301 586301 Prynce, William, of Fornham All Saints, tailor 2
5522791 2511956 2511956 plaintiff Edward Thomas   586301 586301 Edward, Thomas, of Fornham All Saints 0
5549437 2519888 2519888 defendant Bartylmewe Thomas husbandman 586301 586301 Bartylmewe, Thomas, of Fornham All Saints, husbandman 1
5567770 2525151 2525151 plaintiff Edward Thomas (legal representative) 586301 586301 Edward, Thomas, of Fornham All Saints, executors of 0
5596128 2533704 2533704 defendant Wryght Robert yeoman 586301 586301 Wryght, Robert, of Fornham All Saints, yeoman 1

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