3. For each table under google_political_ads, run the following query: SELECT * FROM `bigquery-public-data.google_political_ads.<TABLE>` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY) GROUP BY country;
3. Export as CSV in GCS
Another procedure that is probably better but requires BigTable is:
More things should be like the Interstate System when federal money is involved: locally budget, appropriate, source, build/implement, and when it meets federal guidelines, you get reimbursed.
Surely not, but it still seems wrong to blame the NFL for something they objectively had no involvement in.
I am glad we're learning more about this and I do think changes are needed, but let's not forget that medical progress takes time. If the NFL was trying to ignore it then I'd be for grabbing the pitchforks, but they are not doing that. We can't reasonably retroactively crucify them for something nobody knew at the time
> … Most undergraduate students do not go to office hours, try to get to know their instructors, ask follow-up questions
This was actively discouraged by the instructors in the school I attended. Not by policy, but by behavior - passive-aggressively belittling students for not “getting” the subject matter, showing a complete lack of interest in reciprocating any amount of getting to know the instructor.
> … ask follow-up questions, pursue independent research, or do anything approaching "apprenticeship". Most American students matriculate into college/uni not even having ingrained behaviors that make any of these things obvious or approachable …
A failure of secondary education and students’ families.
I was talking with a professor yesterday who claimed his students don't ask questions any more on Piazza. They used to, but now they go to ChatGPT which is always perky and ready to answer. Plus, there's no shame in asking a dumb question as there can be in class or on Piazza.
He says it's only a matter of time before the students realize they don't need him. Or need to pay tuition.
And we’ve all been sold a bill of goods on the necessity of diplomas and degrees. Because businesses have been sold a bill of goods on the quality of employees with diplomas and degrees.
Within at least the last 15 years, the paper provided by a school is no guarantee of better pay - but that’s how high schoolers are convinced to go into excessive debt for attending post-secondary schools.
These people can’t possibly be at every university, let alone colleges, community colleges, or technical schools.
> … rote memorization and bad classes …
Not every school will be good. There are at least three post-secondary schools within driving of me that take the minimum required curricula as a script and offer nothing more than the bare minimum required to get certification, accreditation, and receive that sweet state and federal budget money.
I can’t imagine how someone with a good or great post-secondary education is confused that this would be the situation for millions of students.
I feel like the “bending ice makes electricity” bit is years, if not decades, old. Now I’m off to explore the rabbit holes and understand my own memory.
> Flexoelectricity, ever since its discovery, has been regarded as an alternative of piezoelectricity at small scales. In fact, as early as the 1960s, Koehler et al. (1962), Turch´anyi, G.
et al. (1973), Whitworth (1975) found that edge dislocations in centrosymmetric materials,
such as sodium chloride, carry charge. Later, Perenko & Whitworth (1983) extended the
observation to another kind of centrosymmetric material, ice. Piezoelectricity vanishes in
these materials, therefore cannot be the source. Instead, a “pseudo-piezoelectric” effect was
postulated by Evtushenko et al. (1987) for an explanation, which was later shown to be a
result of flexoelectricity Mao & Purohit (2015).
Emphasis added.
So I think this was known but not fully understood by the time Perenko & Whitworth published Electric currents associated with dislocation motion in ice in 1983?
> In this paper we describe [an] experiment in
which a small current is observed due to the movement
of dislocations during plastic deformation [of ice].
The same authors of the paper TFA discusses published a preprint in 2022, which could also be what you're thinking of: https://arxiv.org/abs/2212.00323
The important part about applying ROT13 is the number of iterative applications. The security of even-numbered applications is undeniable. Odd-numbered is even better than that.
I’m currently building an implementation with fractional rotation. Of course I will post a Show HN when it’s ready.
reply