names

104 rows where place_id = 596834

✎ 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
3626349 1903099 1903099 defendant Knyght John husbandman 596834 596834 Knyght, John, of Harston, husbandman 0
3633527 1905297 1905297 defendant Papworth John husbandman 596834 596834 Papworth, John, of Harston, husbandman 1
3644867 1908804 1908804 defendant Thirlowe Henry husbandman 596834 596834 Thirlowe, Henry, of Harston, husbandman 3
3669065 1916256 1916256 defendant Hawke William husbandman 596834 596834 Hawke, William, of Harston, husbandman 2
3685151 1921504 1921504 defendant Knyght John husbandman 596834 596834 Knyght, John, of Harston, husbandman 0
3685152 1921504 1921504 defendant Leeke Nicholas husbandman 596834 596834 Leeke, Nicholas, of Harston, husbandman 1
3685153 1921504 1921504 defendant Grove Robert husbandman 596834 596834 Grove, Robert, of Harston, husbandman 2
3685154 1921504 1921504 defendant Russhall Richard husbandman 596834 596834 Russhall, Richard, of Harston, husbandman 3
3746874 1940939 1940939 defendant Belfeld Thomas husbandman 596834 596834 Belfeld, Thomas, of Harston, husbandman 0
3746875 1940939 1940939 defendant Tynnman Thomas husbandman 596834 596834 Tynnman, Thomas, of Harston, husbandman 1
3759096 1944830 1944830 defendant Mannyng John husbandman 596834 596834 Mannyng, John, of Harston, husbandman 2
3776702 1950461 1950461 defendant Hawke Robert husbandman 596834 596834 Hawke, Robert, of Harston, husbandman 4
3795529 1956483 1956483 defendant Papworth John husbandman 596834 596834 Papworth, John, of Harston, husbandman 0
3797281 1957036 1957036 defendant Pryse John, junior carpenter 596834 596834 Pryse, John, junior, of Harston, carpenter 1
3797283 1957037 1957037 defendant Pryse John, senior carpenter 596834 596834 Pryse, John, senior, of Harston, carpenter 0
3797284 1957037 1957037 defendant Pryse John, junior carpenter 596834 596834 Pryse, John, junior, of Harston, carpenter 1
3798800 1957538 1957538 defendant Duckefeld George husbandman 596834 596834 Duckefeld, George, of Harston, husbandman 0
3802330 1958627 1958627 defendant Papworth Thomas husbandman 596834 596834 Papworth, Thomas, of Harston, husbandman 0
3824157 1965432 1965432 defendant Russall Richard husbandman 596834 596834 Russall, Richard, of Harston, husbandman 1
3824158 1965432 1965432 defendant Grove Robert husbandman 596834 596834 Grove, Robert, of Harston, husbandman 2
3824159 1965432 1965432 defendant Walton Robert husbandman 596834 596834 Walton, Robert, of Harston, husbandman 3
3824162 1965433 1965433 defendant Rushall Richard husbandman 596834 596834 Rushall, Richard, of Harston, husbandman 1
3824163 1965433 1965433 defendant Grove Robert husbandman 596834 596834 Grove, Robert, of Harston, husbandman 2
3824164 1965433 1965433 defendant Walton Robert husbandman 596834 596834 Walton, Robert, of Harston, husbandman 3
3838982 1970121 1970121 defendant Belfeld Thomas yeoman 596834 596834 Belfeld, Thomas, of Harston, yeoman 0
3838983 1970121 1970121 defendant Rushall Richard husbandman 596834 596834 Rushall, Richard, of Harston, husbandman 1
3838984 1970121 1970121 defendant Grove Robert husbandman 596834 596834 Grove, Robert, of Harston, husbandman 2
3838985 1970121 1970121 defendant Walton Robert husbandman 596834 596834 Walton, Robert, of Harston, husbandman 3
3959181 2010298 2010298 defendant Peck John yeoman 596834 596834 Peck, John, of Harston, yeoman 0
4037890 2038200 2038200 defendant Newman Henry husbandman 596834 596834 Newman, Henry, of Harston, husbandman 2
4066791 2048422 2048422 defendant Elwyn John tailor 596834 596834 Elwyn, John, of Harston, tailor 0
4076336 2051833 2051833 defendant Allington Robert gent 596834 596834 Allington, Robert, of Harston, gent 0
4262025 2116974 2116974 defendant Manynge Silvester (legal representative) 596834 596834 Manynge, Silvester, of Harston, yeoman, executor of 2
4262026 2116974 2116974 defendant Amy William yeoman 596834 596834 Amy, William, of Harston, yeoman 3
4299103 2129778 2129778 defendant Wylkynson Ralph gent 596834 596834 Wylkynson, Ralph, of Harston, gent 1
4342764 2144742 2144742 defendant Pratte Philip miller 596834 596834 Pratte, Philip, of Harston, miller 1
4366622 2153110 2153110 defendant Pratte Philip miller 596834 596834 Pratte, Philip, of Harston, miller 1
4621895 2237829 2237829 defendant Hauberk William   596834 596834 Hauberk, William, of Harston, parson 0
4641638 2243656 2243656 plaintiff Gamen John   596834 596834 Gamen, John, of Harston 0
4652245 2246648 2246648 defendant Hikkesson John husbandman 596834 596834 Hikkesson, John, of Harston, husbandman 2
4655954 2247740 2247740 defendant Bangyll John husbandman 596834 596834 Bangyll, John, of Harston, husbandman 0
4659017 2248690 2248690 defendant Neuton Robert laborer 596834 596834 Neuton, Robert, of Harston, laborer 5
4668049 2255714 2255714 defendant Pratte Thomas   596834 596834 Pratte, Thomas, of Harston 3
4668051 2255714 2255714 defendant Attekyn Thomas husbandman 596834 596834 Attekyn, Thomas, of Harston, husbandman 5
4678727 2258953 2258953 defendant Atkyn Thomas husbandman 596834 596834 Atkyn, Thomas, of Harston, husbandman 1
4679552 2259221 2259221 defendant Dagay William husbandman 596834 596834 Dagay, William, of Harston, husbandman 1
4683367 2260399 2260399 defendant Wesenam Simon yeoman 596834 596834 Wesenam, Simon, of Harston, yeoman 0
4685109 2260944 2260944 defendant Ely John fowler 596834 596834 Ely, John, of Harston, fowler 0
4685414 2261035 2261035 defendant Trumpe Henry maltman 596834 596834 Trumpe, Henry, of Harston, maltman 0
4692393 2263137 2263137 defendant Atkyn Thomas husbandman 596834 596834 Atkyn, Thomas, of Harston, husbandman 1
4692548 2263184 2263184 defendant Atkyn John, sen husbandman 596834 596834 Atkyn, John, sen, of Harston, husbandman 0
4692768 2263249 2263249 defendant Atkyn John, sen husbandman 596834 596834 Atkyn, John, sen, of Harston, husbandman 3
4693319 2263413 2263413 defendant Bolton Robert husbandman 596834 596834 Bolton, Robert, of Harston, husbandman 0
4697386 2264668 2264668 defendant Baugell or Bangell John husbandman 596834 596834 Baugell or Bangell, John, of Harston, husbandman 0
4697387 2264668 2264668 defendant Page John husbandman 596834 596834 Page, John, of Harston, husbandman 1
4704851 2266895 2266895 defendant Baise John, sen yeoman 596834 596834 Baise, John, sen, of Harston, yeoman 0
4708745 2268105 2268105 defendant Whytsyde Richard fuller 596834 596834 Whytsyde, Richard, of Harston, fuller 4
4717485 2270804 2270804 defendant Atkyn John husbandman 596834 596834 Atkyn, John, of Harston, husbandman 1
4721605 2272088 2272088 defendant Dagay William husbandman 596834 596834 Dagay, William, of Harston, husbandman 1
4721606 2272088 2272088 defendant Hykkesson John husbandman 596834 596834 Hykkesson, John, of Harston, husbandman 2
4739647 2277474 2277474 defendant Smyth John smith 596834 596834 Smyth, John, of Harston, smith 0
4739648 2277474 2277474 defendant Bangyll John carter 596834 596834 Bangyll, John, of Harston, carter 1
4739649 2277474 2277474 defendant Hikkesson John husbandman 596834 596834 Hikkesson, John, of Harston, husbandman 2
4769707 2286499 2286499 defendant Bangill John carter 596834 596834 Bangill, John, of Harston, carter 2
4769709 2286499 2286499 defendant Clerk John husbandman 596834 596834 Clerk, John, of Harston, husbandman 4
4769710 2286499 2286499 defendant Page John (legal representative) 596834 596834 Page, John, of Harston, executrix of 5
4775557 2288348 2288348 defendant Bangle John   596834 596834 Bangle, John, of Harston, shepherd 0
4791761 2293521 2293521 defendant Huckysson John husbandman 596834 596834 Huckysson, John, of Harston, husbandman 2
4806689 2298301 2298301 defendant Colyn John husbandman 596834 596834 Colyn, John, of Harston, husbandman 2
4806690 2298301 2298301 defendant Atkyn Thomas husbandman 596834 596834 Atkyn, Thomas, of Harston, husbandman 3
4822267 2303044 2303044 defendant Weseham Simon husbandman 596834 596834 Weseham, Simon, of Harston, husbandman 1
4835655 2307144 2307144 defendant Wesenham Simon husbandman 596834 596834 Wesenham, Simon, of Harston, husbandman 0
4856169 2313301 2313301 defendant Tyryngton John smith 596834 596834 Tyryngton, John, of Harston, smith 0
4862816 2315355 2315355 defendant Wesenham Simon husbandman 596834 596834 Wesenham, Simon, of Harston, husbandman 0
4899192 2326388 2326388 defendant Wilmot John miller 596834 596834 Wilmot, John, of Harston, miller 0
4902103 2327267 2327267 defendant Bray Thomas   596834 596834 Bray, Thomas, of Harston, millward 0
4906206 2328533 2328533 defendant Grene Nicholas yeoman 596834 596834 Grene, Nicholas, of Harston, yeoman 1
4935435 2337478 2337478 defendant Folke Walter husbandman 596834 596834 Folke, Walter, of Harston, husbandman 1
4935436 2337478 2337478 defendant Teryngton John smith 596834 596834 Teryngton, John, of Harston, smith 2
4938626 2338464 2338464 defendant Grene Nicholas husbandman 596834 596834 Grene, Nicholas, of Harston, husbandman 2
4965245 2346527 2346527 defendant Bayser John husbandman 596834 596834 Bayser, John, of Harston, husbandman 1
4998297 2356360 2356360 defendant Atkin Thomas husbandman 596834 596834 Atkin, Thomas, of Harston, husbandman 2
5008790 2359462 2359462 defendant Hygyn Thomas husbandman 596834 596834 Hygyn, Thomas, of Harston, husbandman 0
5038247 2368075 2368075 defendant Baysy John (legal representative) 596834 596834 Baysy, John, of Harston, executors of 0
5071411 2377944 2377944 defendant Trumpe John maltman 596834 596834 Trumpe, John, of Harston, maltman 2
5076302 2379414 2379414 defendant Baungill Thomas husbandman 596834 596834 Baungill, Thomas, of Harston, husbandman 4
5163942 2405192 2405192 defendant Mannyng John husbandman 596834 596834 Mannyng, John, of Harston, husbandman 0
5247496 2429422 2429422 defendant Hegyn Thomas husbandman 596834 596834 Hegyn, Thomas, of Harston, husbandman 1
5282117 2439842 2439842 defendant Bangle Thomas husbandman 596834 596834 Bangle, Thomas, of Harston, husbandman 0
5282126 2439844 2439844 defendant Bangle or Baugle Thomas husbandman 596834 596834 Bangle or Baugle, Thomas, of Harston, husbandman 0
5339397 2456892 2456892 defendant Thyrlowe Robert husbandman 596834 596834 Thyrlowe, Robert, of Harston, husbandman 1
5391411 2472621 2472621 defendant Folkes John, junior husbandman 596834 596834 Folkes, John, junior, of Harston, husbandman 0
5403901 2476188 2476188 defendant Nappeworthe John, senior husbandman 596834 596834 Nappeworthe, John, senior, of Harston, husbandman 0
5417013 2480000 2480000 defendant Pappeworthe John, senior husbandman 596834 596834 Pappeworthe, John, senior, of Harston, husbandman 0
5451754 2490399 2490399 defendant Mayde Andrew husbandman 596834 596834 Mayde, Andrew, of Harston, husbandman 0
5463708 2494061 2494061 defendant Mayde Andrew husbandman 596834 596834 Mayde, Andrew, of Harston, husbandman 0
5463710 2494062 2494062 defendant Mayde Andrew husbandman 596834 596834 Mayde, Andrew, of Harston, husbandman 0
5484462 2500270 2500270 defendant Mayde John yeoman 596834 596834 Mayde, John, of Harston, yeoman 0
5484463 2500270 2500270 defendant Stevyn John husbandman 596834 596834 Stevyn, John, of Harston, husbandman 1
5484465 2500271 2500271 defendant Prall Simon fisher 596834 596834 Prall, Simon, of Harston, fisher 0

Next page

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