names

74 rows where place_id = 588283

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593976 1865755 1865755 defendant Castelden Robert butcher 588283 588283 Castelden, Robert, of Long Stratton, Norf, butcher 2
3632366 1904943 1904943 defendant Grene John butcher 588283 588283 Grene, John, of Long Stratton, Norf, butcher 0
3660143 1913433 1913433 defendant Sexteyn William pewterer 588283 588283 Sexteyn, William, of Long Stratton, Norf, pewterer 0
3664918 1914973 1914973 defendant Greve John husbandman 588283 588283 Greve, John, of Long Stratton, Norf, husbandman 0
3704794 1927790 1927790 defendant Broun William husbandman 588283 588283 Broun, William, of Long Stratton, Norf, husbandman 0
3708379 1928915 1928915 defendant Sandell Simon yeoman 588283 588283 Sandell, Simon, of Long Stratton, Norf, yeoman 0
3708382 1928916 1928916 defendant Sandell Simon yeoman 588283 588283 Sandell, Simon, of Long Stratton, Norf, yeoman 0
3724595 1933974 1933974 defendant Laneman James husbandman 588283 588283 Laneman, James, of Long Stratton, Norf, husbandman 0
3740525 1938896 1938896 defendant Laneman James husbandman 588283 588283 Laneman, James, of Long Stratton, Norf, husbandman 0
3748987 1941614 1941614 defendant Sexten William pewterer 588283 588283 Sexten, William, of Long Stratton, Norf, pewterer 0
3752924 1942842 1942842 defendant Laneman James husbandman 588283 588283 Laneman, James, of Long Stratton, Norf, husbandman 0
3787241 1953802 1953802 defendant Sexton George pewterer 588283 588283 Sexton, George, of Long Stratton, Norf, pewterer 3
3791666 1955238 1955238 defendant Wyllett Richard husbandman 588283 588283 Wyllett, Richard, of Long Stratton, Norf, husbandman 0
3800772 1958154 1958154 defendant Wyllet Richard husbandman 588283 588283 Wyllet, Richard, of Long Stratton, Norf, husbandman 0
3846644 1972504 1972504 defendant Rysyng Robert chapman 588283 588283 Rysyng, Robert, of Long Stratton, Norf, chapman 2
3853835 1974831 1974831 defendant Vynne Richard husbandman 588283 588283 Vynne, Richard, of Long Stratton, Norf, husbandman 0
3873927 1981499 1981499 defendant Stanton George husbandman 588283 588283 Stanton, George, of Long Stratton, Norf, husbandman 0
3873929 1981500 1981500 defendant Stanton George husbandman 588283 588283 Stanton, George, of Long Stratton, Norf, husbandman 0
3953973 2008461 2008461 defendant Sendell Robert yeoman 588283 588283 Sendell, Robert, of Long Stratton, Norf, yeoman 0
3987089 2020126 2020126 defendant Raynborowe James sherman 588283 588283 Raynborowe, James, of Long Stratton, Norf, sherman 0
3987091 2020127 2020127 defendant Rayneborowe James sherman 588283 588283 Rayneborowe, James, of Long Stratton, Norf, sherman 0
4017111 2030824 2030824 defendant Porter Nicholas yeoman 588283 588283 Porter, Nicholas, of Long Stratton, Norf, yeoman 1
4027457 2034469 2034469 defendant Jarmyn Robert husbandman 588283 588283 Jarmyn, Robert, of Long Stratton, Norf, husbandman 1
4114576 2065501 2065501 defendant Otwey Mathew husbandman 588283 588283 Otwey, Mathew, of Long Stratton, Norf, ,husbandman 1
4125392 2069365 2069365 defendant Stanton Nicholas yeoman 588283 588283 Stanton, Nicholas, of Long Stratton, Norf, yeoman 0
4145625 2076624 2076624 defendant Hott John knacker 588283 588283 Hott, John, of Long Stratton, Norf, knacker 0
4153424 2079294 2079294 defendant Knyvett Edmund gent 588283 588283 Knyvett, Edmund, of Long Stratton, Norf, gent 1
4239667 2109504 2109504 defendant Townesend Edward gent 588283 588283 Townesend, Edward, of Long Stratton, Norf, gent 3
4250924 2113288 2113288 defendant Stanton Nicholas beer brewer 588283 588283 Stanton, Nicholas, of Long Stratton, Norf, beer brewer 1
4250928 2113289 2113289 defendant Stanton Nicholas beer brewer 588283 588283 Stanton, Nicholas, of Long Stratton, Norf, beer brewer 1
4316970 2136051 2136051 defendant Stevenson Thomas tailor 588283 588283 Stevenson, Thomas, of Long Stratton, Norf, tailor 1
4337866 2142988 2142988 defendant Stevenson Thomas tailor 588283 588283 Stevenson, Thomas, of Long Stratton, Norf, tailor 2
4347414 2146350 2146350 defendant Walbye Thomas yeoman 588283 588283 Walbye, Thomas, of Long Stratton, Norf, yeoman 3
4347416 2146351 2146351 defendant Wallye Thomas yeoman 588283 588283 Wallye, Thomas, of Long Stratton, Norf, yeoman 0
4391741 2161859 2161859 defendant Touneshend Edmund gent 588283 588283 Touneshend, Edmund, of Long Stratton, Norf, gent 1
4770339 2286695 2286695 defendant Caudeler William husbandman 588283 588283 Caudeler, William, of Long Stratton, Norf, husbandman 1
4818454 2301851 2301851 defendant Caudeler William husbandman 588283 588283 Caudeler, William, of Long Stratton, Norf, husbandman 0
4818457 2301852 2301852 defendant Caudeler William husbandman 588283 588283 Caudeler, William, of Long Stratton, Norf, husbandman 0
4824873 2303815 2303815 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 2
4824878 2303816 2303816 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 2
4826764 2304407 2304407 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 0
4831446 2305867 2305867 defendant Martyn John husbandman 588283 588283 Martyn, John, of Long Stratton, Norf, husbandman 1
4873241 2318582 2318582 defendant Rose John weaver 588283 588283 Rose, John, of Long Stratton, Norf, weaver 0
4878858 2320321 2320321 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 0
4885630 2322380 2322380 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 0
4914638 2331096 2331096 defendant Barnard John gent 588283 588283 Barnard, John, of Long Stratton, Norf, gent 0
4917534 2331998 2331998 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 1
4937633 2338145 2338145 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, or of Becclys, gent 0
4957814 2344308 2344308 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 0
5018815 2362390 2362390 defendant Bernard John gent 588283 588283 Bernard, John, of Long Stratton, Norf, gent 0
5051052 2371922 2371922 defendant Galyon John miller 588283 588283 Galyon, John, of Long Stratton, Norf, miller 2
5073585 2378582 2378582 defendant Galyon John miller 588283 588283 Galyon, John, of Long Stratton, Norf, miller 2
5074030 2378721 2378721 defendant Baxter Richard yeoman 588283 588283 Baxter, Richard, of Long Stratton, Norf, yeoman 1
5127301 2394462 2394462 defendant Fuller John yeoman 588283 588283 Fuller, John, of Long Stratton, Norf, yeoman 0
5166388 2405894 2405894 defendant Fuller John yeoman 588283 588283 Fuller, John, of Long Stratton, Norf, yeoman 0
5218518 2421147 2421147 defendant Swayn John yeoman 588283 588283 Swayn, John, of Long Stratton, Norf, yeoman 1
5270153 2436374 2436374 defendant Collowe Thomas yeoman 588283 588283 Collowe, Thomas, of Long Stratton, Norf, yeoman 4
5272487 2437027 2437027 defendant Thorne John butcher 588283 588283 Thorne, John, of Long Stratton, Norf, butcher 2
5282448 2439926 2439926 defendant Thorp John butcher 588283 588283 Thorp, John, of Long Stratton, Norf, butcher 2
5304086 2446228 2446228 defendant Collowe Thomas yeoman 588283 588283 Collowe, Thomas, of Long Stratton, Norf, yeoman 0
5306971 2447080 2447080 defendant Baxster John yeoman 588283 588283 Baxster, John, of Long Stratton, Norf, yeoman 2
5310879 2448287 2448287 defendant Collowe Thomas mercer 588283 588283 Collowe, Thomas, of Long Stratton, Norf, mercer 0
5390136 2472240 2472240 defendant Calff John husbandman 588283 588283 Calff, John, of Long Stratton, Norf, husbandman 0
5391857 2472747 2472747 defendant Thorn John butcher 588283 588283 Thorn, John, of Long Stratton, Norf, butcher 2
5408538 2477517 2477517 defendant Calf John husbandman 588283 588283 Calf, John, of Long Stratton, Norf, husbandman 0
5421709 2481429 2481429 defendant Calf John husbandman 588283 588283 Calf, John, of Long Stratton, Norf, husbandman 0
5435668 2485607 2485607 defendant Thorn John butcher 588283 588283 Thorn, John, of Long Stratton, Norf, butcher 2
5492747 2502746 2502746 defendant Metcalff James (legal representative) 588283 588283 Metcalff, James, of Long Stratton, Norf, yeoman, executors of 0
5506676 2507004 2507004 defendant Sexteyn John husbandman 588283 588283 Sexteyn, John, of Long Stratton, Norf, husbandman 0
5508078 2507418 2507418 defendant Thorne John butcher 588283 588283 Thorne, John, of Long Stratton, Norf, butcher 5
5517984 2510469 2510469 defendant Saxtayn John chapman 588283 588283 Saxtayn, John, of Long Stratton, Norf, chapman 2
5529407 2513710 2513710 defendant Thorne John butcher 588283 588283 Thorne, John, of Long Stratton, Norf, butcher 1
5537408 2516193 2516193 defendant Dexter Robert carpenter 588283 588283 Dexter, Robert, of Long Stratton, Norf, carpenter 1
5583998 2530066 2530066 defendant Garlond John pedder 588283 588283 Garlond, John, of Long Stratton, Norf, pedder 6

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